In this article, you can find all the information you need to migrate your accounts data from QuickBooks Online into QuickBooks Desktop.
How it works
For seamless migration, we've broken it down into 5 easy steps.
2. Admin privileges are needed to convert the data from QuickBooks Online to QuickBooks Desktop.
3. Create Necessary Sales tax Items and Sales tax group Item in QuickBooks Desktop file.
4. Enable Multi-currency feature in QuickBooks Desktop file if it is enabled in QuickBooks Online.
After the successful installation and activation of "SaasAnt Transactions", navigate to Import Settings ( Edit>Import Settings)
- Click on the "Miscellaneous" tab and turn on "Enable QuickBooks Online Migration" feature.
- Click on "General" tab and select date format in File as"YYYY-MM-DD".
Save the settings.
Exporting your data
- Login to "Excel Transactions" using Intuit Credentials and Click on "Export" Menu.
- Select the appropriate date range and download the reports for all Lists and transactions.
Importing your data
Now you can import each file downloaded from "Excel Transactions" into QuickBooks Desktop using "SaasAnt Transactions". We highly recommend importing the "Lists" completely before migrating the transactions.
- Launch "SaasAnt Transactions".
- Click on "Import" button.
- Choose "Select QuickBooks Transaction/List Type" as one of the values based on the below table (an equivalent entity of QuickBooks Desktop).
- Browse and select the exported file from "Excel Transactions".
- Click "Next" on File upload Screen.
- Click "Next" on Mapping Screen.
- Click "Send to QuickBooks" on Review Screen.
If there are any issues during conversion an error may display immediately.
In the table below, we've noted the equivalent transactions and lists for QuickBooks Online and QuickBooks Desktop.
|QuickBooks Online||QuickBooks Desktop|
|Chart Of Accounts||Account|
|Credit Memo||Credit Memo|
|Sales Receipt||Sales Receipt|
|Expense||Credit Card Charge and Check|
|Bill Payment||Bill Payment|
|Purchase Order||Purchase Order|
|Vendor Credit||Vendor Credit|
|Credit Card Credit||Credit Card Credit|
|Journal Entry||Journal Entry|
|Time Activity||Time Tracking|
When you have completed your QuickBooks Online to QuickBooks Desktop conversion, follow below steps to review the migration.
- Check account balances in QuickBooks Desktop match account balances in QuickBooks Online.
- We suggest you run a full trial balance in both QuickBooks Desktop and QuickBooks Online for the end of the current month, and then compare the balances.
- You may also see invoices and bills that were paid in Quickbooks Online, but now show as awaiting payment in QuickBooks Desktop. In this case, payments will need to be applied again, and reconciled.
- Purchase Order with category accounts cannot be imported
- Expenses need to be imported as Credit Card Charges or checks
- Customer with SSN cannot be imported.
- Account sub type or detail type cannot be imported.
- Sales with Markup Percentage are not supported.