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 master 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 master 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 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 recently 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 a 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:
- Select the gear icon near the top right of the screen, then choose Company 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 address box. Intuit will send monthly invoices to this email address for your QuickBooks subscription.
- Enter your company email address into the Customer email address box. This is the email address where customers of the QuickBooks business will contact you.
- 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:
- Choose VAT in the left column of QuickBooks Online.
- Click on the Edit VAT drop down and click on Edit Settings.
- Enter your VAT registration number into the VAT registration number box.
- 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:
- Choose VAT in the left column of QuickBooks Online, then select Prepare Return.
- You will see the Prepare VAT Return screen. Enter these details into the Prepare VAT Return screen:
- Set Start Date as the start date of the conversion period.
- Set End Date as the last day of the period covered by the most recent VAT return.
- Click Mark as Filed button, 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.
- In the left column of QuickBooks Online, select Transactions, then Account Histories.
- From the Chart of Accounts, choose VAT Suspense account, click on 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 a 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:
- Select the gear icon near the top right of the screen, then choose Reconcile.
- Choose the relevant bank account from the dropdown, then select Reconcile Now.
- A Start Reconciling box will open. Enter your last reconciliation date in Statement ending date and put cleared Balance as it was on your last reconciliation in the Ending Balance field.
- Leave the rest of the form blank and select OK.
- You will see a list of transactions. Select the top tick boxes to 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 which are still uncleared. When difference is Zero that means you do it right.
Select Finish Now.
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.
To resolve this, turn on automatically apply credits preference so you can easily link and credits/payments to your open invoices. You can turn on auto apply credits by going to Gear icon > Company Settings > Advanced tab > Automatically apply credits > Save.
If you do not want to automatically apply all payments, you can individually create payments. This would have to be done on a name by name basis.
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 :
- Select the Gear Icon on the upper right.
- Select Manage User.
- Click on the Data Services user you have added (it will 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.