Trial Balance

Import and export trial balance account information

You can import account informationbalances 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.
The account information that you can import includes: account numbers, account descriptions, unadjusted balances, and grouping code assignments.
You can also export account information from Onvio to a spreadsheet, which you can save to your local drive.
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
  4. Complete each step of the Import wizard listed below.

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. 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. If you want to map the account codes from your file to existing account codes in Onvio:
    1. Turn on the
      Map accounts
       switch.
    2. Select
      Next
      .
  6. If you don't want to map accounts, select
    Finish Import
    .
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.

How to export account information

You can export all the account balance information from the trial balance as a Microsoft Excel file (.XLSX).
  1. Open a project.
  2. Select the Trial Balance tab.
  3. Select
    Export
    .
Onvio creates a file for export that includes information for all of the rows and columns in the Trial Balance grid. Before you export a trial balance, you can add and delete columns in the grid, as needed.

This article applies to:

  • Product: Onvio
  • Audiences: Staff