Control account

Control accounts can be used to keep track of balances. They are also referred to as running balances, corkscrews, and roll-forward calculations. A control account is a special case of a cascade.

A common implementation that span four rows, with

• opening balance picking up the closing balance from the previous period;
• additions picking up the values within the period that tend to increase the balance;
• reductions picking up the values within the period that tend to reduce the balance; and
• closing balance calculated based on the opening balance, additions and reductions.

For example: