Desktop File
Converting from QuickBooks Desktop to QuickBooks Online
Moving your financial data from QuickBooks Desktop to QuickBooks Online is a significant step. While we strive to make the transition smooth, there are specific limitations, time restrictions, and functional differences you should understand before and after the conversion.
The 60-Day Rule for Imports
One of the most important constraints to understand is the 60-day window for importing data.
- New Accounts: You can only import (upload) a Desktop file into a QuickBooks Online company if the Online subscription is less than 60 days old.
- Overwriting Data: If you need to overwrite your existing QuickBooks Online data with a fresh Desktop file, you must also be within this 60-day window.
- Older Accounts: If your QuickBooks Online account is older than 60 days, the system will not allow you to upload a Desktop file to replace the existing data. To proceed with a fresh import, you must cancel your current subscription and start a new one. We recommend contacting our support team regarding potential refunds or subscription transfers if you are in this situation.
Browser Requirements for Upload
If you are using a Windows PC to upload your Desktop file, you must ensure your browser settings are configured correctly.
- Required Browser: You must use Internet Explorer (IE) to initiate the upload process. You cannot use Chrome, Edge, or other browsers for this specific step.
- Windows 10 Users: Internet Explorer is included with Windows 10 but may be turned off by default. You can enable it via the Control Panel before starting the import.
Preparing and Cleaning Your Data
Before you begin the conversion, we strongly recommend preparing your Desktop file to ensure a smooth transition.
- Check for Limitations: Not all features in QuickBooks Desktop function exactly the same in QuickBooks Online. We advise reviewing the official list of limitations to ensure your workflow is supported.
- Clean Up: If your current Desktop file has errors or data you no longer need (such as incorrect bills or journal entries), clean the file in Desktop before importing. It is much easier to fix issues in the Desktop environment than after the data has been moved to Online.
- Inventory: If you plan to import inventory, review specific guidelines for preparing inventory data to avoid import errors.
Post-Conversion: Reconciliation and Adjustments
Once your data is in QuickBooks Online, you will likely need to perform some manual verification and adjustments.
Bank Reconciliation
QuickBooks Online does not retain the history of bank reconciliations performed in Desktop. When you first visit the Reconciliation screen in Online, it will show that you have not performed any reconciliations.
- How to Fix: Open your original Desktop file and note the ending date and balance of your last reconciliation.
- In QuickBooks Online: Go to the Settings gear icon and select Reconcile. Enter the ending date and balance from your Desktop records. You may need to manually mark off transactions to match your Desktop status and complete the reconciliation.
Payroll Data
Payroll data behavior depends on the specific payroll service you subscribe to in QuickBooks Online.
- Data Transfer: The conversion utility attempts to copy your payroll data, but you may need to categorize tax payments manually if you are using the Enhanced Payroll version.
- Historical Entries: If you encounter restrictions preventing you from entering historical payroll data (e.g., for prior years), we recommend processing any outstanding or late tax payments in your original Desktop file to avoid penalties. Once current, you can record summary journal entries in QuickBooks Online to account for those historical payments.
Journal Entries and Errors
Occasionally, the conversion utility may create journal entries that do not align with your needs or contain errors due to differences between the two platforms.
- Correcting Entries: Since you generally cannot delete the initial imported data if it causes imbalances, the standard solution is to create a reversing or correcting journal entry in QuickBooks Online to fix the accounting impact.
Data Export and Backup Limitations
It is important to understand how data portability works in the cloud.
- No Direct Download: You cannot download a full QuickBooks Online company file and upload it into another QuickBooks Online account (for example, during a change of company ownership).
- Export Options: You can export lists and transaction data to Excel, or export your data to a QuickBooks Desktop version. However, exporting to Desktop is not a perfect 1:1 transfer, and some data may be lost or formatted differently.
- Reporting: For ownership changes or major transitions, we advise having your accountant log in and print essential reports, such as the Balance Sheet, Profit and Loss, and Inventory Valuation Summary, to maintain a permanent record of the company’s financial status.