Account Summary Report

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.

Prerequisites

Managing Cin7 Core Reports

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

Input:

Account Code	Select the account to show transaction details for.
Reporting Period	Allow user to select the reporting period from a list of options are set custom a custom date range
Layout	Set to the Default layout. Allows selection of saved layouts, if any.
Save Layout As	Allows saving of a layout for potential future use.
Reset Layout	Resets 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 Cin7 Core Reports - Filtering Reports for more detailed information about using filters.

Output:

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

Fields
Order	A sequence of data for report ordering. This has no relevance to your inventory and is only used by the system.
Date	Transaction date
Description	Description of transaction
Document #	Transaction document reference number and link
Supplier/Customer	Supplier or Customer associated with the transaction
Year	Year that transaction took place
Quarter	Quarter that transaction took place
Month	Month that transaction took place
Data Headers
Opening balance	Opening balance for the account for specified month
Debit	Debit for the transaction
Credit	Credit for the transaction
Closing balance	Closing balance for the account for specified month

Publish

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.

Account Summary Report

Prerequisites

Input:

Output:

Publish

Was this article helpful?