Balance Sheet by periods

Balance Sheet by periods

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 see opening and closing balances with debit and credit summary, try Trial Balance report.

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

Prerequisites

 

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

Input:

Balance Dates

Allow user to select the balance date month. Closing balance is shown.

Compare To

Allows user to select comparison range, e.g. previous year, previous quarter, previous month.

Compare periods

Selects number of previous periods to compare against. Up to 12 periods can be compared.

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:

The following output fields are available for this report.

Fields

Account Class

Ledger account class

Account Code

Ledger account code

Description

Account description

Job #

Job number if applicable

Period

Closing Balance

Closing balance for the account for the selected period.

 

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.

Was this article helpful?

Have more questions? Submit a request