Methods to import your QuickBooks desktop company file to online:
Do you want to migrate your QuickBooks desktop file to QuickBooks online? We are here with a guide to walk you through the process to successfully move/export your company file to QuickBooks online. It is very much important to check whether you should migrate to QuickBooks online or not. Both online and desktop are powerful versions, but it all depends on your requirements. Large companies generally have complex company file, and therefore they aren’t a good candidate for migration.
If you are a small or medium sized company and using QuickBooks desktop, premier, pro, etc. then you can simply migrate to QuickBooks online. Here is what all you would have to do!
You may also: Learn How to Install QuickBooks Database Server Manager
Steps to Move/migrate your QuickBooks Desktop file to QuickBooks Online
Checkout these updated steps to move your QuickBooks desktop company file to Online:
Step 1: Prepare for migration
Are you all set to migrate? Have you made the necessary preparations? Before you start with the actual migration, there are certain procedures that you should follow:
#1: Backup your company file
- Just in case you are using multi-user mode, then go for file menu and pick the switch to single user mode option.
- Head to the file menu and hover over back up company. Choose create local backup.
- In the window, tap on local backup and hit Next.
- Choose browse tab in the local backup only section and pick where you want to save the backup company file.
- Set the number of backups that you want to keep.
- A test would run to ensure that your backup file is appropriate.
- Hit OK tab when you are all set to proceed.
- Choose save it now and Next tab.
#2: Updating QuickBooks desktop
- Open the QuickBooks desktop software.
- Head to help tab and click on update QuickBooks desktop.
- Pick update now tab.
- Choose get updates.
- Switch to single user mode, select file, if you are not in single user mode.
- Click on file tab and hit exit.
- Reboot QuickBooks desktop.
- Run the payroll, if you have.
#3: Export your reports and lists
- Head to the reports menu and choose report center.
- Look for and open any report.
- Choose the desired date range from the dates drop-down menu.
- Pick excels on the toolbar. Select print or email to save the report as a PDF.
- Choose create new worksheet to create a new excel workbook.
- To update an existing workbook with the data in the open report and select update existing worksheet.
- Choose browse and locate the workbook on the system.
- To format the data, select advanced.
- Select and un-check the space between columns, hit OK button.
- Click on OK tab when you are ready to export.
Step 2: Import your desktop file to QuickBooks Online
Now that you are all set to migrate your data to QuickBooks online, below are the steps to follow:
QuickBooks desktop pro or premier
- Log in as admin to the company file that you want to import.
- Head to the company menu and choose export company file to QuickBooks online.
- Pick the get started tab.
- Hit a click on select destination, and sign in to QuickBooks online account.
- You will get success message i.e. Your data is now available on QuickBooks online.
Just in case you track your inventory in QuickBooks desktop, follow the below steps:
- Go for the Yes option to bring them over and specify the starting date.
- Pick No option, if you want to set up the new items later in QuickBooks online.
- After conversion is complete, you will get an email, where you have to click on complete your setup tab.
- Sign to the QuickBooks online account.
- Pick the company file you want to open.
This will open the QuickBooks online dashboard.
QuickBooks desktop enterprise
- Log in as admin in the company file you want to import.
- Press Ctrl + 1 keys to open the product information window.
- Press Ctrl + B + Q keys and hit OK tab.
- Select start your export on the export window.
- Sign in as admin to QuickBooks online company.
Just in case you track inventory in QuickBooks, then perform the below steps:
- Pick the Yes tab to bring them over and specify the as of date.
- Choose No if you want to set up new items later in QuickBooks online.
- Go for the choose online company drop-down and pick the QuickBooks online company that is to be replaced.
- Pick the continue tab and hit enter on agree tab and choose replace.
- End the process by selecting yes, go ahead and replace the data and click on replace.
Step 3: Move your lists
In above steps you have moved your lists from QuickBooks, so as to import them in QuickBooks online. You will have to perform the necessary steps for chart of accounts, products and services, customer and supplier individually.
Steps to set up inventory
- You can setup inventory by heading to the settings menu.
- And selecting account and settings.
- Pick the sales option.
- Further, go for edit tab in the product and services section.
- Turn on the show product/service column on sales forms.
- Turn on both track quantity and price/rate and track inventory quantity on hand.
- Pick the save tab and click on done.
Step 4: Connect to QuickBooks Online and import your data
- Start off with logging in QuickBooks online by entering the necessary details. The user ID is usually the email address used to sign up. So, you can use your email and agree to the terms of service before selecting the sign in option.
- Just in case, you are having inventory in your file and are trying to import from QuickBooks desktop 2016 or later, then you might see the screen else, you can skip to the next step.
Want to import inventory? If yes, then you will have the plus or advanced edition of QuickBooks online. It should be noted that the simple start and essentials don’t have the inventory tracking feature. Whereas, if you have an extensive inventory, then in such a scenario, you have extensive inventory, or you can track the product items quantity on hand in plus or advanced.
3. You are then required to pick the QuickBooks online company that you wish to import your data into, or create a new one.
The most important point to note here is that, if you have already created a QuickBooks online company, then avoid creating a new company. All you have to do is to select one you created from the drop-down.
4. Go for the ok, got it option
You would be getting an email confirmation, after the import process ends. Whereas, this could also take up to 24 hours.
Step 5: Do it before using QuickBooks Online
Once you are done with the steps above, there are a few tasks that you would have to perform before starting with the QuickBooks online software. Before you make any changes to the data or enter the new transactions, it is recommended to complete the following steps. You are suggested to go through the below checklist after migrating, so as to ensure that all of the data transferred as expected, and also for importing information that wasn’t included in the migration.
1. Start off with checking the data by comparing the reports: You are supposed to compare the below reports in QuickBooks online and in QuickBooks desktop, so as to ensure that the data was transferred properly.
2. Checking the company settings: Even though you are able to move the accounting data into QuickBooks online, the information like the company name, address, and email related information isn’t carried along. It is recommended to enter the information in the QuickBooks online company manually.
3. Configuring the sales tax settings is the next step: It is very much essential for you to set up QuickBooks online with the appropriate CRA business number and filing frequency before starting with its use.
4. Connecting bank and credit card accounts: Most important point to be noted here is that the bank and credit card information isn’t transferred when migrating from QuickBooks desktop to QuickBooks online.
5. Cleaning up bank reconciliations: It should be noted that it is assumed that no bank transactions have been reconciled, as you haven’t yet performed a bank reconciliation in QuickBooks online.
You are supposed to convey QuickBooks to mark all transactions up to the conversion date as reconciled, so it only considers the future transactions for reconciliation.
6. Linking payments and credits for opening invoices: You might come across the names having zero balances in the A/R and A/P aging reports, this is due to the transactions downloaded into QuickBooks online didn’t link invoices with the respective payments. You can link credits and payments for opening invoices with much ease, by simply turning on the automatically apply credits preference.
7. Reviewing the account’s detail types: Once the conversion takes place, the software will keep the sub account hierarchy. Whereas, it will also make use of an additional level of account typing which can be named as detail type. This basically permits to be more specific with the account organization. The process of conversion will assign detail types of accounts where the detail is obvious. For the accounts, where you are unsure of the detail type, the conversion process will assign them a generic detail type, which can be like Other Miscellaneous income. You can correct this later on.
8. Carrying out the payroll setup: However the transactions and payroll accounts are converted to balance the books, but the details behind the transactions which includes the payroll item breakdown or employee year-to-date numbers, aren’t a part of it. Moreover, the liability refunds, adjustment transactions nd opening balance transactions that hamper the accounts, are converted to journal entries
9. Linking the payments account: In this particular step, you would have to note that you won’t be able to transfer the existing payments to QuickBooks online, rather you would have to create a new one.
10. Adding users: It is very much essential to keep in mind that the users you wish to add in QuickBooks online, should have proper access. Moreover, you can also view the current users by opting for the settings gear icon and the manager users tab respectively.
11. Inviting an accountant: You can call upon up to two of the accounts, so as to work along with you in the QuickBooks online company.
This is how you can move your data file from QuickBooks desktop to QuickBooks online. As always, if you have any concerns, please connect our support team today! We are a hub of technocrats, who work round the clock to provide the best possible QuickBooks desktop support services. So, do not hesitate in calling us anytime and seeking for assistance! We will be more happy to help you.