Move Your QuickBooks Desktop Company File to QuickBooks Online
If you are planning to Move QuickBooks Desktop to Online, proper preparation is important. A well-prepared company file can help reduce migration problems and make the transition smoother.
Before you begin, sign up for QuickBooks Online if you do not already have an account. Your QuickBooks Online account should be registered in the same country or region as your QuickBooks Desktop product. You also need administrator access to both your Desktop company file and QuickBooks Online account.
What to Do Before Moving QuickBooks Desktop to QuickBooks Online
Before starting the migration, prepare your QuickBooks Desktop company file. This can help prevent errors and data-related problems during the transfer.
Update QuickBooks Desktop
First, update QuickBooks Desktop to the latest available release. Using an outdated version may interfere with the migration process.
After updating, restart QuickBooks Desktop and open your company file to confirm that everything works properly.
Check Your QuickBooks Company File Size
QuickBooks Desktop has a limit on the amount of data that can be transferred through the migration process. You can check your file's Total Targets count by following these steps:
1. Open QuickBooks Desktop.
2. Press F2 or Ctrl+1 on your keyboard.
3. Locate the Product Information window.
4. Check the Total Targets count.
Make sure the Total Targets count is below 4,000,000. If the count is higher, you may need to condense your company file before moving the data to QuickBooks Online.
Verify and Rebuild Your Company File
Data problems in QuickBooks Desktop can create complications during migration. Run the Verify Data utility to check for issues in your company file.
If QuickBooks identifies a problem, use the Rebuild Data utility to repair the file. After rebuilding the company file, run Verify Data again to make sure the issues have been resolved.
It is a good idea to create a backup of your company file before performing any major data repair or migration procedure.
Make Sure the Company File Is Stored Locally
Your QuickBooks Desktop company file should be available locally on your computer when you start the migration.
If you use a hosting or cloud service, contact your service provider for help obtaining a local copy of the company file. This is particularly important when the original company file is stored on a hosted server rather than directly on your computer.
Prepare QuickBooks Payroll Before Migration
If you use QuickBooks Desktop Payroll, review your payroll information before moving your company file.
Check that employee names, addresses, tax information, and other payroll details are accurate. Update anything that is outdated.
You should also remove employees who have no pay history during the current calendar year when appropriate. Run payroll before beginning the migration and allow enough time for payroll information to synchronize.
For a smoother transition, plan the migration well before your next scheduled payroll. Allowing several business days between migration and payroll processing gives you time to review the transferred information and address unexpected issues.
Option 1: Move Your Company File Using QuickBooks Desktop
One way to move QuickBooks Desktop to QuickBooks Online is to use the migration option built directly into QuickBooks Desktop.
The exact menu options can vary depending on your QuickBooks Desktop edition.
For QuickBooks Pro or Premier
1. Open QuickBooks Desktop.
2. Sign in as the company administrator.
3. Select Company from the top menu.
4. Choose Migrate this company file to QuickBooks Online.
5. Select Export Your Company File to QuickBooks Online.
6. Select Get started.
QuickBooks may display a personalized checklist showing tasks that need to be completed before migration. Review the checklist and complete the required actions.
After completing the checklist, select Continue.
Choose What Data to Transfer
QuickBooks gives you options for the information you want to move.
Choose Bring all your company data if you want to transfer the complete company file.
You can also choose Bring only list and balances if you only want to transfer important lists and balances, such as:
· Customers
· Vendors
· Chart of accounts
· Employees
· Items
Select Continue after making your choice.
Sign in to QuickBooks Online
Select Yes, sign me in and enter the email address and password associated with your QuickBooks Online account.
Next, select the QuickBooks Online company where you want to transfer your Desktop data.
Be careful when selecting the destination company. If the QuickBooks Online company already contains information, QuickBooks may ask you to replace the existing data.
Replacing existing QuickBooks Online data is an important step because the action cannot be undone. If you do not want to replace an existing company, select or create an empty QuickBooks Online company instead.
QuickBooks Enterprise Migration
QuickBooks Enterprise users can access the company file export process through the Product Information window.
Press Ctrl+1 to open the Product Information window. Then press Ctrl+B+Q to open the company file export window.
Select OK to close the Product Information window and choose Get started.
Select Bring all your company data or choose Bring only list and balances, depending on your migration requirements. Sign in to QuickBooks Online, select the destination company, and follow the instructions displayed on the screen.
Select Export to begin transferring the company file. A progress indicator will show the status of the migration.
Option 2: Use the QuickBooks Online Migration Tool
You can also use the online migration tool when you do not have QuickBooks Desktop installed but have a Desktop company file that needs to be transferred.
This option can be useful for accountants helping clients migrate their data or users who have a supported QuickBooks Desktop company file but no longer have the Desktop application installed.
The online migration tool supports several QuickBooks Desktop file types, including:
· .QBW — QuickBooks Desktop company file
· .QBB — QuickBooks Desktop backup file
· .QBM — QuickBooks portable file
The supported QuickBooks Desktop company file version may also affect whether the online migration tool can be used.
QuickBooks Desktop for Mac Users
If you use QuickBooks Desktop for Mac, you may need to create a Windows-compatible backup of your company file before starting the migration.
The goal is to obtain a compatible .QBW file that can be uploaded to QuickBooks Online.
How to Upload Your QuickBooks Desktop File Online
After preparing your company file, follow these steps:
Step 1: Open the Migration Tool
Open the QuickBooks Online migration tool and select Get started.
Sign in using your QuickBooks Online account credentials.
If you are using QuickBooks Desktop for Mac, make sure the company file has been converted to the required Windows-compatible format before uploading it.
Step 2: Upload the Company File
On the upload screen, select Select file.
Browse to the location where you saved your QuickBooks Desktop company file and select it. You can also drag and drop the file into the upload area if that option is available.
QuickBooks will begin uploading the file. The time required depends on the size and complexity of your company data and your internet connection.
If you use QuickBooks Enterprise, follow the Enterprise-specific instructions displayed during the upload process.
Step 3: Complete the Online Setup
After the upload finishes, follow the on-screen instructions to complete the setup of your QuickBooks Online company.
When the migration has successfully finished, you should see a confirmation message indicating that your company is now online.
Review your customers, vendors, accounts, transactions, and other important information after the migration. This gives you an opportunity to identify anything that may require attention before you begin using QuickBooks Online regularly.
Important Tips for a Smooth QuickBooks Migration
A few additional precautions can make the transition easier:
· Create a backup of your QuickBooks Desktop company file before starting.
· Complete any data repairs before migration.
· Confirm that your QuickBooks Online account is in the correct country or region.
· Make sure you have administrator access to both accounts.
· Check payroll information before transferring your data.
· Avoid replacing an existing QuickBooks Online company unless you are certain that is what you want to do.
· Review your data after the migration is complete.
· Keep your original QuickBooks Desktop backup until you are satisfied with the transferred information.
How Long Do You Have to Move QuickBooks Desktop Data?
The available migration period can depend on how your QuickBooks Online account was created.
If you signed up for QuickBooks Online yourself, you may have 90 calendar days to move your Desktop data.
If an accountant created the QuickBooks Online account for you, the available period may be 180 calendar days.
Because account circumstances can vary, check the information provided in your QuickBooks Online account before starting the migration.
What Happens After Moving to QuickBooks Online?
Once your company data is online, you can access your business finances without relying on the same computer where your QuickBooks Desktop software was installed.
You can use QuickBooks Online to manage invoices, review transactions, monitor business activity, and work with your financial information from supported devices.
However, you should not assume that migration is complete simply because the upload finishes. Take time to review important financial records and confirm that the information you depend on is available and accurate.
Final Thoughts
Moving a QuickBooks Desktop company file to QuickBooks Online requires careful preparation, but following the correct process can make the transition easier. Start by updating QuickBooks Desktop, checking the company file, verifying your data, and creating a backup.
You can then choose between the migration option available in QuickBooks Desktop and the online migration tool, depending on your situation. After transferring the data, review the new QuickBooks Online company carefully before relying on it for everyday accounting and payroll tasks.
Taking time to prepare and verify your information can help you avoid unnecessary migration problems and make the move from QuickBooks Desktop to QuickBooks Online more organized.
FAQs
1. How Do I Move QuickBooks Desktop to QuickBooks Online?
You can move QuickBooks Desktop to QuickBooks Online by using the migration option in QuickBooks Desktop or the online migration tool. Prepare and verify your company file first, then follow the prompts to transfer your data.
2. Can I Transfer My Entire QuickBooks Desktop Company File to QuickBooks Online?
Yes, you can transfer most of your company data using the full migration option. Before starting, check your company file size, verify the data, and create a backup.
3. What QuickBooks Desktop Files Can I Upload to QuickBooks Online?
The online migration tool can support QuickBooks Desktop company files in .QBW, backup files in .QBB, and portable files in .QBM formats, depending on the supported migration requirements.
4. Do I Need QuickBooks Desktop to Migrate My Company File?
Not always. If you have a supported QuickBooks Desktop company file but no longer have QuickBooks Desktop installed, you may be able to use the online migration tool.
5. How Do I Prepare My QuickBooks Desktop File for Migration?
Update QuickBooks Desktop, check the Total Targets count, verify and rebuild your data if necessary, save the company file locally, and create a backup before beginning the migration.
6. What Is the QuickBooks Desktop File Size Limit for Migration?
Before migrating, check the Total Targets count in the QuickBooks Desktop Product Information window. The article's migration guidance recommends keeping the count below 4,000,000.
7. Can I Move QuickBooks Desktop Payroll Data to QuickBooks Online?
Yes, payroll data can be part of the migration, but you should review employee information and payroll records before transferring your company file. It is also helpful to allow sufficient time to review payroll after migration.
8. Can I Move QuickBooks Desktop for Mac to QuickBooks Online?
Yes, but Mac users may need to create a Windows-compatible copy of their company file first. The resulting file can then be used with the migration process.
9. Will Migrating QuickBooks Desktop Replace My Existing QuickBooks Online Data?
It can. If you select an existing QuickBooks Online company containing data, you may be asked to replace that data. Review the destination company carefully because replacing existing data cannot be undone.
10. What Should I Do After Moving QuickBooks Desktop to QuickBooks Online?
After migration, review your customers, vendors, accounts, transactions, payroll information, and other important records. Keep your original Desktop backup until you are satisfied that the transferred information is correct.
0 comments
Log in to leave a comment.
Be the first to comment.