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

Import grouping and tax code assignments

You can import a file that contains account groupings and tax code assignments, map them to the correct columns, then import them into the trial balance. Follow these steps to create and map columns prior to importing grouping and tax code assignments into the trial balance.
  1. Open a project and select the
    Trial Balance
     tab, then
    Import
    .
  2. Select
    My Computer
     or
    Documents in Onvio
    , then
    Next
    .
  3. Select
    File – Choose the file
     to import using either of the following methods.
    • If you select
      My Computer
      , go to the location of the file to import from your local drive, select the file, then
      Open
      . You can also drag and drop the file into the
      Import
       screen.
    • If you select
      Documents in Onvio
      , go to the file for the current project and select the file from the Onvio Documents location.
  4. Select
    Next
    .
  5. Define the account records from the import file and map them to the correct accounts in Onvio.
  6. Select the worksheet before the grid (tab in the spreadsheet) from which to import account groupings and tax code assignments.
  7. Select
    Edit
     for the column to open the
    Column Details
     panel.
  8. Select
    Account Grouping
     in the
    Column Type
     field.
  9. Select a schedule in the
    Grouping Schedule
     field.
  10. Select a grouping level in the
    Code Level
     field.
    note
    All related subcode levels for a selected grouping schedule are automatically made available for selection in the
    Code Level
     field.
  11. Select
    Save
     to insert the selected codes and subcodes into the correct columns.
  12. Select
    Done
     to complete the import.
note
  • The application displays any invalid codes and subcodes in red in the grouping columns of the Mapping grid.
  • You can assign a subcode to an account grouping column only if the account grouping code has already been assigned.
  • When tax grouping schedules and tax codes exist in the import file, the application automatically adds them to the list in the
    Grouping Schedule
     field of the
    Mapping
     panel.
  • When you select a tax grouping schedule, the Grouping Level list includes a
    Unit
     option. You can apply a unit to any level of subcode or multiple levels of subcodes in the same import file. For example, you can apply the same unit grouping level to account 1 subcode 1 and to account 2 subcode 2.

This article applies to:

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