Back to Blog

How to Migrate Data from QuickBooks Online to Wesley

3 min read
How to Migrate Data from QuickBooks Online to Wesley

This document is under review. Content may change frequently.

To migrate your data to Wesley, you will need two specific files: the Chart of Accounts and the Journal. Please ensure you have both ready before beginning the import process.

Note: For instructions on migrating from QuickBooks Desktop, click here.

Step 1: Export the Chart of Accounts

First, ensure that Account Numbers are enabled in your QuickBooks settings so Wesley can map your data accurately.

Enable Account Numbers:

  1. Sign in to your QuickBooks Online account.
  2. Go to Settings ⚙️ > Account and Settings.
  3. Select Advanced from the left navigation bar.
  4. In the Chart of Accounts section, toggle on Enable account numbers and check the box for Show account numbers.
  5. Click Save and then Done.

Export the Report:

  1. Go to Settings ⚙️ > Chart of Accounts.
  2. Click the Run Report button.
  3. Click the Columns icon and ensure the following are selected:
  4. Account, Full Name, Type, Detail Type, Description, Total Balance, and Account Name.
  5. Click the Export icon and select Export to CSV.

While we recommend turning on account numbers in QuickBooks, don't worry if you haven't set them up. If account numbers are missing, Wesley will automatically generate and assign them for you during the import.

Step 2: Export Journal File

The Journal is the most critical file for ensuring your data moves correctly.

  1. Go to Settings ⚙️ > Export Data.
  2. On the Reports tab, ensure the toggle for Journal is turned ON.
  3. Click Export to Excel.
  4. Once downloaded, locate the file on your computer and extract the ZIP file to access the Excel document inside.

Pro-Tip: Date Ranges and Data Limits

There is no limit to the period of data you can import into Wesley.

  • Import Everything at Once: You can export your entire history from QuickBooks Online in one go.
  • No Need to Split Files: You do not need to break your data down by year or specific periods; Wesley is designed to handle multiple years of data in a single import.

Phase 3: Importing to Wesley

Now that you have your files ready, follow these steps to bring your data into Wesley.

  1. Open the specific Client file in Wesley where you want to import the data.
  2. Navigate to the Transactions page.
  3. Click Import and select Import from QuickBooks Online.
  4. Upload both your Chart of Accounts and Journal files.
  5. Once the uploads are complete, the Import button will become active. Click it to finalize the process.

Success! You should see a confirmation message within a few seconds.

Need Help?

If you encounter any errors or the data doesn't look quite right, please reach out to the Wesley Support Team for immediate assistance.

Share this article

Related reads

Discover other posts that cover similar topics.

View all posts →