Creating a rolling financial statement using period indicators

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Important reminder!

Licenses for Payroll CS, Trial Balance CS, and Write-Up CS (but not Engagement CS) permanently expired on March 1, 2017. CSA will not include 2017 tax rates or payroll forms, so, for 2017 and beyond, you will need to process payroll in another application. We recommend Accounting CS Payroll and myPay Solutions. For more information, see the following topics.

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]

Notes

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

Share This