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

Map trial balance account information

When importing accounts to a trial balance, you can map which account codes being imported correspond to which account codes in Onvio.
Once you have created a new mapping of accounts, you can save it and apply to other imports.

Before you begin

  1. You will need to have added an accounts project to your client, opened the project, and selected an import option from the
    Trial Balance
     tab. Import and export trial balance account information.
  2. At the end of the
    Define Data
     step of the import wizard, you will need to have turned on the
    Map account
     switch.
    note
    When you turn the
    Map account
     switch on, the
    Mapping Options
     and
    Map Accounts
     steps of the import wizard are displayed, and
    Finish Import
     changes to
    Next
    .

Step 3: Mapping options

  1. Select one of the following options to map accounts.
    • Create new mapping for accounts
      . This option is selected by default if no saved mapping exists.
    • Use existing mapping for accounts
      , then select an existing mapping from the dropdown. This option isn't available until a mapping has been saved.
  2. Select
    Next
    .

Step 4: Map accounts

Two grids are displayed. One shows the account details from the spreadsheet, the other is for the corresponding account codes and descriptions.
  1. Check that any accounts selected by the auto-mapping process in the grid are correct.
  2. If an account has been wrongly mapped or not auto-mapped, select the correct account from the
    Map account
     dropdown in the Onvio grid.
  3. If you've created a new mapping, you'll need to select an option to save it.
  4. If the imported account is out of balance, you can continue the import out of balance, or assign the out of balance amount to a selected balancing account.
  5. Select
    Finish Import
    .
note
  • Onvio tries to auto-map accounts by looking for account numbers and account descriptions in the imported file that match those in Onvio.
  • If you didn’t define an account description column in the
    Define Data
     step, or an account description cell is empty, then Onvio will try to auto-map by using only the account number.
  • If you didn’t define an account number column in your spreadsheet, then Onvio won’t be able to auto-map any accounts.
  • If an account number cell is empty, then Onvio won’t be able to auto-map that account.
  • The comparisons that Onvio makes when auto-mapping accounts are not case
  • If you selected an existing mapping, this will take priority over auto-mapping.
  • You can manually change any auto-mapped account by using the Map account dropdown list.
  • Multiple accounts from the spreadsheet can be mapped to the same Onvio account.
  • Changes made when mapping don’t affect the source file that you've imported data from.

This article applies to:

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