Creating a rolling financial statement using period indicators

Alerts and notices

Important reminder!

Product support for Engagement CS is ending on September 30, 2020. See Engagement CS license expiration 2020 - frequently asked questions for more information.

Licenses for Payroll CS, Trial Balance CS, and Write-Up CS permanently expired on March 1, 2017.

Some processes documented in the Help & How-To Center are no longer applicable, due to the discontinuation of Creative Solutions Accounting.

You can add together period indicators to total individual periods within the current and prior years.

To create a rolling financial statement or a statement presenting account information that is based on individual periods and that is updated as you move to each period, use the period indicator [CP-x] (where x represents the number of periods prior to the current period). Such period indicators can be added together, for example, to create quarterly reports for monthly clients that are accurate as you move to each processing period.

Requesting prior-period totals in a rolling financial statement can only be accomplished by using the [CP-x] period indicator.

Example: For a monthly client in the last period of the current year, you can create a formula within a cell that totals all periods in the previous year

[CP-12] + [CP-13] +… [CP-23]


  • You can insert date variables with the period CC (current cell contents) into your rolling financial statement. These dates will be updated automatically as your Statement Date changes.
  • The Financial Reporter module offers an example of a rolling financial statement, which is available for you to customize for your own needs within the Financial Statement Editor. In the Financial Statement Editor, choose File > Open > Global Statement to open the global statements in the statements folder on your system, and then select the rolling financial statement example called INCOMESTATEMENT-12MONTHROLLING.FSR.

Was this article helpful?

Thank you for the feedback!