The default report provides you with a summary of all the transactions for the selected period. Use this detailed report to view the starting balance, ending balance and all of the transactions for the period organised by account.


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


Account CodeSelect the account to show transaction details for.
Reporting PeriodAllow user to select the reporting period from a list of options are set custom a custom date range
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving of a layout for potential future use.
Reset LayoutResets 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. 


Account balance is shown per month of the reporting period. Amount Total column displays the closing account balance for that month. Hover over an Amount Total cell and click the arrow to show a dropdown menu. Click Show Transactions to click through to all transactions for that month for the selected account. 

The following output fields are available for this report (only on the detailed transactions screen).

A sequence of data for report ordering. This has no relevance to your inventory and is only used by the system.
Transaction date
DescriptionDescription of transaction
Document #Transaction document reference number and link
Supplier/CustomerSupplier or Customer associated with the transaction
YearYear that transaction took place
QuarterQuarter that transaction took place
Month that transaction took place
Data Headers
Opening balanceOpening balance for the account for specified month
DebitDebit for the transaction
CreditCredit for the transaction
Closing balanceClosing balance for the account for specified month


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