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 organized by account.
Before you start
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 or set 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.
