Import accounts and balances from QuickBooks Online

You can import and map QuickBooks Online accounts to your Onvio contacts by choosing Import > QuickBooks Online in the Trial Balance screen.

Before you can import a company's accounts into Onvio from QuickBooks Online, a connection between the two applications is required.

Current limitations

  • You can import up to 1,000 accounts at a time from QuickBooks Online.
  • The import brings in cumulative balances (including beginning balances), therefore we recommend only using this feature for annual clients. Importing period balances from QuickBooks Online will be released in the future.

Import from QuickBooks Online

Use the following steps to import accounts into Onvio.

  1. Connect to QuickBooks Online via the Integration tab on the Setup > Contacts screen, or the Setup > Clients screen.
  2. Choose Import > QuickBooks Online in the Trial Balance screen to start the import process.

    Note: If you have not yet established a connection to QuickBooks Online, a separate browser window will open so that you can do so, prior to starting the import.

  3. Step 1: Options – Set your options for the import.

    Notes

    • The Accounting method and the Accounts to Include options are retained and available by default the next time that you import from QuickBooks Online for each contact.
    • The Destination Posting Period corresponds to the Period settings that have been set up for the contact in Onvio.
  4. Click Next.
  5. Step 2: Map Accounts – Add QuickBooks Online accounts as new, or map to existing accounts.

    Notes

    • Onvio matches accounts from QuickBooks Online based on the account number and/or account description to existing accounts in the contact's trial balance. If a match cannot be found it can be added as a new account. You can also choose to manually map accounts that are imported from QuickBooks Online.
    • The Account Type column is used as a reference to assist you in mapping the QuickBooks Online accounts with the corresponding account in Onvio. The Account Types are also used to automatically populate the account classification and tax grouping codes in Step 3.
  6. Step 3: Define Data – Review the data to be imported.
  7. Verify your data from the QuickBooks Online import, and then click the Finish Import button. Everything, except for the Unadjusted Balance column can be modified in Step 3.

Notes

  • After QuickBooks Online accounts are imported into the Trial Balance screen, an adjustment is created for the imported balances. You can delete the adjustment if it is necessary to import for the same date range and avoid duplicating account balances in the Trial Balance screen.
  • If the application encounters any alerts and/or warnings during the mapping process, the Finish Import button is unavailable (grayed) until you resolve these items. You can hover your cursor over an alert or warning to view its description and modify the accounts in the grid to resolve any issues.

Contact us