Import and export trial balance account information

You can use the import feature in the Trial Balance tab to add and map account information in the trial balance, or you can use the export feature to create a file of existing accounts for export to your local drive via a Microsoft Excel file.

See also: Import grouping schedules and tax code assignments

Import

You can import account numbers, account descriptions, unadjusted balances, grouping code and/or tax code assignments from a local file or a file from Documents into the trial balance.

  1. Open a project and choose Import > Spreadsheet in the Trial Balance tab to create and map columns prior to importing account information into the trial balance.
  2. Select File – Choose the method and file to import.
  3. Select Source – Choose My Computer or Documents in Onvio. Based on the selection that you make, you can Browse for, or drag and drop a file from a local drive on your computer or select a folder/file location within Onvio.
  4. Click Next.
  5. Define Data – Define the account records from the import file and map them to the appropriate accounts in Onvio.
    1. Click the appropriate worksheet above the grid (tab in the spreadsheet) from which to import data.
    2. Click Edit at the top of the appropriate column to open the Column Details panel.
  6. Click the Finish Import button to complete the import.

Notes

  • If the application encounters any alerts and/or warnings during the mapping process, the Next/Finish button is unavailable (grayed) until you resolve these items. You can hover your cursor over an alert or warning to view the description and modify imported accounts in the mapping grid to resolve any issues.
  • Valid characters in the import file include letters, numbers, hyphens, dots, and forward slashes.
  • When you apply changes in the mapping screen, these changes do not affect the original Microsoft Excel spreadsheet.

Export

You can create a Microsoft Excel file (.XLSX) that contains all the account balance information from the trial balance.

  1. Open a project and click Export in the Trial Balance tab.
  2. In the Save As panel, navigate to the location in which to save the export file, enter the filename, and click Save.

Onvio creates an export file 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

Was this article helpful?