Skip to main content

Solutions

Products

Recommended products

Questions? We are here to help.
Contact us

Purchase

Questions? We are here to help.

Resources

Trial Balance

Import accounts and balances from QuickBooks Online

You can import and map QuickBooks Online accounts to your Onvio contacts by selecting
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 2 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. Select
    Import
    , then
    QuickBooks Online
     in the
    Trial Balance
     screen to begin the import process.
    note
    If you haven’t 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.
    note
    • 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. Select
    Next
    .
  5. Step 2:
     Map Accounts – Add QuickBooks Online accounts as new, or map to existing accounts.
    note
    • 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 can't be found it can be added as a new account. You can also map accounts imported from QuickBooks Online manually.
    • 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 populate the account classification and tax grouping codes automatically 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 select
    Finish Import
    . Everything except the Unadjusted Balance column can be modified in Step 3.
note
  • 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 or warnings during the mapping process, the
    Finish Import
     button isn't available (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.

This article applies to:

  • PRODUCT: Onvio
  • Subject: Trial balance
  • Audiences: Staff