Accounts

Import trial balance account information

You can import balances and transactions from an Excel spreadsheet (.XLS or .XLSX) or a comma-separated values (.CSV) file stored in your local drive or in Onvio Documents.
Hidden and filtered rows or columns will not be included in the spreadsheet import.

Start the Import wizard

  1. Open a project.
  2. Select the Trial Balance tab.
  3. Select
    Import
    , then
    Spreadsheet
    Import Balances
    .
  4. Complete each step of the Import wizard listed below.
If you want to import transaction information, choose
Import
, then
Spreadsheet Import Transactions
.

Import wizard step one: Select File

  1. Choose
    My computer
     or
    Documents in Onvio
     from the
    Select source
     drop-down list.
  2. If you chose My computer, use
    Browse
     or drag and drop to select a file. If you chose Documents in Onvio, select a file from your folders.
  3. Enter a different name in the
    Save import journal as
     field if you want to change the name of your imported journal.
  4. Select
    Next.
note
If you chose
My computer
, the file will be stored in Onvio Documents unless you clear the
Store the uploaded file in Documents
 checkbox.

Import wizard step two: Define Data

  1. If you're importing a spreadsheet with more than one worksheet, choose the worksheet that you want to import from the
    Select worksheet
     options.
  2. Select
    Edit
     at the top of each column that contains data that you want to import, choose the
    Column Type
     that describes the data, then select
    Save
    .
  3. Mark the
    Omit
     checkbox in any row that contains incorrect data or a header row.
  4. Deal with any alerts or warnings that are flagged in the Issues column.
  5. Select
    Next
    .
note
  • If you see alerts and/or warnings when defining data, you will not be able to continue until you have resolved them. Hover over an alert or warning to read a description of it.
  • Onvio can only import the following characters from your file: letters, numbers, hyphens, dots, and forward slashes.
  • The
    Map accounts
     switch is turned on by default and cannot be turned off.
  • Onvio compares column headers in the spreadsheet to its column types. This comparison ignores case and spaces. If Onvio finds matching columns, it defines these for you and omits the first row of your spreadsheet. If more than one column in the spreadsheet has the same heading, Onvio will not define them. You can select
    Edit
     to redefine columns.

Import wizard step three: 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 drop-down list. This option is disabled until a mapping has been saved.
  2. Select
    Next
    .

Import wizard step four: Map Accounts

  1. Check that any accounts chosen by the auto-mapping process in the Onvio grid are correct.
  2. If an account has been wrongly mapped or not auto-mapped, choose the correct account from the
    Map account
     drop-down list in the Onvio grid.
  3. Select
    Finish Import
    .
note
  • Onvio auto-maps accounts in the imported file to existing accounts in Onvio based on account numbers and account descriptions.
  • If there’s no account description, Onvio auto-maps based on only the account number.
  • If you chose an existing mapping, this takes priority over auto-mapping.
  • The comparisons that Onvio makes when auto-mapping accounts are not case sensitive.
  • When you manually map a transaction to an Onvio account, your mapping is copied to unmapped transactions with the same account number. If there's no account number column, your mapping is copied to transactions with the same description.

This article applies to:

  • Product: Onvio
  • Audiences: Staff