Onvio Trial Balance overview

Open your project and select the Trial Balance to add, edit, delete, and export account and balance information. You can also customize views to include or exclude columns in the Trial Balance.

Notes

  • The Net Income row displays a balance when accounts are grouped to revenue and expense codes or subcodes in the Account Classification grouping schedule. Currently, the application does not calculate net income for grouping schedules other than the Account Classification grouping schedule.
  • Cells that can be edited in the Trial Balance grid are highlighted yellow.
  • Prior year Unadjusted balance columns are read only and cannot be edited in the current year. To edit prior year balance amounts, you must revert to the prior year by changing the current period in the Settings tab.
  • Accounts cannot be deleted if they are used as a rounding account, included in a transaction created from a QuickBooks Online import and included in any adjustment on the adjustments tab.

On the Trial Balance tab, you can complete the following actions.

  • Add a new account or edit an existing account in the Trial Balance view.
  • Map accounts and grouping codes from an Excel spreadsheet (.xlx, .xlsx, and .csv) in a local drive or in Onvio Documents and import them into the trial balance.
  • Export a trial balance to a Microsoft Excel spreadsheet (.xlsx).
  • Permanently delete an account from the trial balance.
  • Sort a column in ascending or descending order.
  • Manage views by adding a new view and defining columns in the view.
  • View the journal entry types that are included in the calculation of each balance type for the current contact from the Setup > Balance Definitions panel. (This view is currently read-only.)
  • Hide zero rows if there are zeros in all the balance columns in the current trial balance view, even when there's activity in those accounts.
  • Cells that can be edited in the Trial Balance grid are now white and cells that cannot be edited are now shaded in grey. 
  • Cells that contain drop downs now have visible drop down arrows to indicate the cell is editable and contains a drop down list in the Trial Balance grid.
  • Only two decimal places are allowed to be entered for balances in the Trial Balance grid.
  • Column widths are now remembered per staff member in the Trial Balance grid.