Although we make the data conversion as comprehensive as possible, there are still a few tasks you need to perform before you start using QuickBooks Online on a day-to-day basis.
This document explains what you need to do. It’s best to take care of these jobs as soon as possible, and certainly before you make other changes to the data or begin entering new transactions.
To finalise the data and get QuickBooks ready for day-to-day use, you need to do these tasks:
- Check and fully review converted data
- Confirm company settings
- Confirm VAT settings
- Clean up VAT
- Tidy bank reconciliations
- Linking Payments/Credits to open invoices
- Remove Intuit Data Services user from your QuickBooks Online account
This document explains how to perform each of these tasks.
Before you begin:
- Make sure you have received an email inviting you to become the primary administrator of this QuickBooks Online account.
- Select the Accept link in the email. It will take you to sign in to QuickBooks Online.
- Sign in using your QuickBooks Online credentials.
Please note, if you created your own QuickBooks Online file, you are already the primary admin!
1. Checking your Data
Please follow these post-conversion steps to validate your data in QuickBooks Online.
Please review your data after the conversion process, it is your responsibility to verify the completeness and accuracy of all converted data.
Compare your (printed) previous software (Sage/Kashflow/Xero/QuickBooks Desktop/etc.) reports with the QuickBooks Online reports set out below to ensure the conversion was successful and accurate:
Note: Please be sure to run your reports on an accrual basis when checking the balances from previous software to Online - even if you currently work on a cash basis. This will ensure accurate balances are shown and confirm the accuracy of the data migration.
- Balance Sheet Report
- Trial Balance - All dates
- Customer Balance Summary - All dates
- Supplier Balance Summary - All dates
- VAT Summary Report for the most recent VAT period
- Any other reports you’d like to check
In the Trial Balance report, if you have completed a filing but have not yet made or received payment for that filing before you moved to QuickBooks Online, the amount will be moved from the A/P or A/R account in previous software to a new suspense account in QuickBooks Online. This is due to a difference in the way that the two systems track VAT.
Any current VAT exceptions will not be captured in your next filing. If you currently have any exceptions in your previous software data then please contact your QuickBooks Online support team.
Note: If you had any un-cleared/non-reconciled transactions in your previous software file, you will need to untick them in the QuickBooks Online reconciliation report to ensure all the transactions match.
2. Confirm company settings
Why do this?
Although we’re able to move your accounting figures into QuickBooks, we don’t carry over information like company name, address, and email details.
Here’s how to confirm the company settings:
- Go to Settings ⚙ and select Accounts and Settings.
- In the Company tab, enter your company and contact information here.
- Update the email addresses to ensure billing communications and customer communications are handled correctly.
- Enter your email address for QuickBooks billing into the Company email box. Intuit will send monthly invoices to this email address for your QuickBooks subscription.
- If you do not want to use the Company email address for your customers to contact you, then enter the email address in the Customer-facing email box that you want your customers to associate with your business.
- Select Save at the bottom of the screen to save these changes.
3. Confirm VAT settings
Why do this?
It’s important that QuickBooks Online is set up with the correct VAT registration number and filing frequency before you and your client start using it. You can skip this step if your business isn’t registered for VAT.
How to confirm VAT settings:
- Go to VAT.
- Select the Edit VAT dropdown and select Edit Settings.
- Enter your VAT registration no.
- Make sure the Reporting method is correct and change the Filing frequency if required.
- Select the Save button to save these settings.
4. Clean up VAT
Why do this?
Because you have never filed VAT using QuickBooks Online before, QuickBooks Online assumes that all VAT recorded in the accounts is now due. This means the VAT balance shown in QuickBooks is wrong. Enter the date of the last VAT filing from your QuickBooks Desktop file. This will ensure the VAT balance shows correctly and that future VAT returns are accurate.
How to clean up VAT:
- Go to VAT and select Prepare return.
- Enter the following details on the Prepare VAT return screen:
- Select the End date as the last day of the period covered by the most recent VAT return.
- Select the Filing date.
- Select Mark as Filed, then Continue to confirm that the VAT returns have been filed up to the To Date.
- You’ll be taken to the VAT screen. Now you need to enter a reverse journal entry to ensure your current balance is correct.
- Go to Transactions and select Chart of accounts (Take me there).
- From the Chart of Accounts, choose VAT Suspense account, select Account history.
- Find the VAT transaction you just created, then select Edit.
- You’ll see the Journal Entry screen. At the bottom, select Reverse.
- A new VAT Suspense line will be added to the list. If you like, you can type a note into the Description column to show that this was a Post System Migration Task or similar.
- Select Save and new to save these changes.
The VAT balance shown in QuickBooks should now be correct, ensuring that future VAT returns are accurate.
5. Tidy bank reconciliations
Why do this?
Because you have never used QuickBooks Online to perform bank reconciliation, QuickBooks Online assumes that no bank transactions have been reconciled. You need to tell QuickBooks to mark all transactions up to the conversion date as reconciled, so it only considers future transactions for reconcilement.
Follow these steps to tidy bank reconciliations:
- Go to Settings ⚙ and select Reconcile.
- Choose the relevant bank account from the drop-down. Enter the Ending balance and Ending date, then select Start reconciling.
- You will see a list of transactions. Select all transactions in the list. If the data is in two columns, make sure you’ve selected all transactions in both columns. Then find and uncheck transactions that are still uncleared. When the difference is Zero that means you have completed these steps successfully.
- Select Finish Now.
- It is important to repeat this process for all bank accounts in QuickBooks Online.
It is important to repeat this process for all bank accounts in QuickBooks Online.
6. Linking payments/credits to open invoices
Why do this?
Because the transactions downloaded in QuickBooks did not link the invoices with their respective payments. If you open your A/R and A/P ageing reports in QuickBooks Online, you may notice names that have zero balances.
7. Remove the Intuit Data Services user from your QuickBooks Online Account:
Why do this?
Because the Intuit Data Services team has finished their task and now they do not require access to your file.
To remove the user follow the steps listed below :
- Go to Settings ⚙ and select Manage users.
- Select the Data Services user you've added (it'll have intuit.com email address), then select Delete.
Getting QuickBooks help and support
Once you’ve performed the tasks described in this document, you can start using QuickBooks on a day-to-day basis.If you have any questions about any of these tasks - or any other aspect of QuickBooks Online - just contact the expert QuickBooks Online support team.