Control account

From Financial Modelling Wiki
Revision as of 10:26, 17 December 2021 by 191.101.209.5 (talk) (Created page with "<strong>Control accounts</strong> can be used to keep track of balances. They are also referred to as <strong>running balances</strong>, <strong>corkscrews</strong>, and <strong>roll-forward calculations</strong>. A control account is a special case of a cascade. A common implementation span four rows in the following order: # <strong>Opening balance</strong>. This picks up the closing balance from the previous period. # <strong>Additions</strong>. This picks up the val...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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 span four rows in the following order:

  1. Opening balance. This picks up the closing balance from the previous period.
  2. Additions. This picks up the values within the period that tend to increase the balance - for example deposits into a bank account.
  3. Reductions. This picks up the values within the period that tend to reduce the balance - for example withdrawals from a bank account.
  4. Closing balance. This is calculated based on the opening balance, additions and reductions.