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, grouping codes, and tax coded 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.

    Read more about how to Map account information.

  6. If you don't want to map accounts, select Next to go to step three (Choose Tax Codes).

Notes:

  • 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. 

Import wizard step three: Choose Tax Codes

  1. Tax codes will be predicted based on account descriptions. Choose the correct tax code for each account.

    Note: Tax codes are only predicted for entity types Individual, C Corporation, S Corporation, and Partnership.

  2. Choose a predicted tax code.
  3. Choose Assign manually and select a code that was not predicted.
  4. Choose Don't assign tax code if you do not want any tax code assigned to the selected account.

    Note: Turn off the Use predictive tax codes for tax accounts switch if you don't want to import tax codes.

  5. Select Finish Import.

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.


Contact us