Trial Balance overview

Open your project and click the Trial Balance tab. You can use this tab to add, edit, delete, import, and export account and balance information. You can customize your own views to include or exclude specific columns in the Trial Balance . For details, see Columns in the Trial Balance screen .


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

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

  • Add a new account or edit an existing account in the Trial Balance view.
  • Enter beginning balances into the Beginning Balance columns of the Trial Balance grid based on the following criteria.
    • You can edit only the beginning balance for the current year. Prior year beginning balance amounts are displayed, but cannot be edited. To edit prior year beginning balances, you'd need to revert to the prior year.
    • Accounts must be grouped to an Account Classification Code of CA, CL, NPE, EQ, NCA, or LTL. Beginning balance cells are disabled if the account is not grouped to one of these codes.
    • If an account is grouped with one of the codes listed above, and is then ungrouped or regrouped as a non-balance sheet account, the cell in the Beginning Balance column becomes non-editable and the amount changes to 0.00.
  • Map accounts , grouping codes, and/or tax code assignments from an Excel spreadsheet (.XLX, .XLSX, and .CSV) — located on your local drive or from Onvio Documents — and import them into the trial balance.
  • Export a trial balance to a Microsoft Excel spreadsheet (.XLSX).
  • Export the contact's tax data to a file for import into ProSystem fx and Lacerte, based on the tax vendor selection on the Settings tab.
  • Permanently delete an account from the trial balance.
  • Sort information in the selected column in ascending or descending order.
  • Manage views by adding a new view and to define the columns within the view. For details, see Manage views in the  trial balance.
  • 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.)
  • Click the Hide zero rows switch above the Trial Balance grid to hide account rows when there are zeros in all the balance columns in the current trial balance view. You can also hide zero rows even when there is activity in those accounts.

Contact us

Was this article helpful?