Trial Balance

A simple snapshot of all financial transactions within a given period. Use this report to see opening balance, closing balance and amount debited and credit for each of your accounts within the selected time period.

To compare Balance Sheets across multiple time periods, try Balance Sheet by Periods

This report is only available to users with Financial Reporting permissions. 


Data from this report can be exported in Excel, PDF or RTF format. 


Reporting PeriodAllows the user to select the reporting period from a list of options or set a custom date range.
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving a layout for potential future use.
Reset LayoutResets the layout to the default layout or selected saved layout.

Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters. 


The following output fields are available for this report. 

Account ClassLedger account class
Account CodeLedger account code
DescriptionAccount description
Job #Job number if applicable
Data Headers
Opening BalanceOpening balance for the account
DebitAll debit turnovers for the period
CreditAll credit turnovers for the period
Closing BalanceClosing balance for the account


Balance sheet by periods can be Saved or Published to save a snapshot of the report and its settings where the data and date range cannot be changed. 

Published reports can be accessed from the top right of the reports screen in the Published tab. Reports that have been saved but not published will appear in the Draft tab. 

Add notes to a report for publishing by clicking the drop-down arrow in a cell and clicking Add a footnote. You will then be able to enter text in the notes field below the report. Notes text will be saved to draft or published reports. 

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.