Control account: Difference between revisions

From Financial Modelling Wiki
Jump to navigation Jump to search
No edit summary
(Included examples and more information)
 
Line 1: Line 1:
<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 [https://finmod.wiki/wiki/index.php/Cascade cascade].
<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 [https://finmod.wiki/wiki/index.php/Cascade cascade].


==Simple example==
A common implementation that span four rows, with
A common implementation that span four rows, with
* <strong>opening balance</strong> picking up the closing balance from the previous period;
*<strong>opening balance</strong> picking up the closing balance from the previous period;
* <strong>additions</strong> picking up the values within the period that tend to increase the balance;
*<strong>additions</strong> picking up the values within the period that tend to increase the balance;
* <strong>reductions</strong> picking up the values within the period that tend to reduce the balance; and
*<strong>reductions</strong> picking up the values within the period that tend to reduce the balance; and
* <strong>closing balance</strong> calculated based on the opening balance, additions and reductions.
*<strong>closing balance</strong> calculated based on the opening balance, additions and reductions.


For example:
For example:


<div style='text-align: center;'><iframe key="WhiteBoxFinancialLB" path="509&authkey=%21AOICh9VlafB-IBo&em=2&AllowTyping=True&ActiveCell='Example'!F10&Item=ControlAccount&wdHideGridlines=True&wdDownloadButton=True&wdInConfigurator=True" height="187" width="1000"></iframe></div>
<div style="text-align: center;"><iframe key="WhiteBoxFinancialLB" path="509&authkey=%21AOICh9VlafB-IBo&em=2&AllowTyping=True&ActiveCell='Example'!F10&Item=ControlAccount&wdHideGridlines=True&wdDownloadButton=True&wdInConfigurator=True" height="187" width="1000"></iframe></div>
 
==Variants==
 
=== Historical balances ===
Operational models often require balances to be input in each historical period. It is generally prudent to ensure that control accounts pick up these historical balances, rather than assume that they will naturally match calculated balances.
 
Here is an example with the closing balance containing a formula that picks up the input closing balance in each of the historical periods, and it is otherwise a calculation that uses the opening balance and movements.
 
<div style="text-align: center;"><iframe key="WhiteBoxFinancialLB" path="511&authkey=%21ALc5y1ozyvOEyTw&em=2&AllowTyping=True&ActiveCell='Example'!F13&Item=ControlAccount&wdHideGridlines=True&wdDownloadButton=True&wdInConfigurator=True" height="237" width="1000"></iframe></div>
 
It is possible to calculate any inconsistency. Potential uses include:
* Populating an output report. This might help a finance team decide where to focus reconciliation effort, or inform management of uncertainties.
* Presenting the inconsistency within the output financial statements - this should only be considered if you have a way of reliably attributing inconsistencies to particular financial statement areas.
 
<div style="text-align: center;"><iframe key="WhiteBoxFinancialLB" path="513&authkey=%21AD3zoWXot_GOaao&em=2&AllowTyping=True&ActiveCell='Example'!F15&Item=ControlAccount&wdHideGridlines=True&wdDownloadButton=True&wdInConfigurator=True" height="275" width="1000"></iframe></div>
 
=== Intermediate balances ===
Sometimes it is useful to know intermediate balances. For example knowing the inventory balance before sales can help you avoid selling beyond your capacity to deliver.
 
<div style="text-align: center;"><iframe key="WhiteBoxFinancialLB" path="515&authkey=%21ALzFsnF8SyR6hIk&em=2&AllowTyping=True&ActiveCell='Example'!F12&Item=ControlAccount&wdHideGridlines=True&wdDownloadButton=True&wdInConfigurator=True" height="218" width="1000"></iframe></div>
 
When intermediate balances are useful, it is often worth considering changing from a control account to a more general [https://finmod.wiki/wiki/index.php/Cascade cascade].

Latest revision as of 18:14, 21 December 2021

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.

Simple example

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:

Variants

Historical balances

Operational models often require balances to be input in each historical period. It is generally prudent to ensure that control accounts pick up these historical balances, rather than assume that they will naturally match calculated balances.

Here is an example with the closing balance containing a formula that picks up the input closing balance in each of the historical periods, and it is otherwise a calculation that uses the opening balance and movements.

It is possible to calculate any inconsistency. Potential uses include:

  • Populating an output report. This might help a finance team decide where to focus reconciliation effort, or inform management of uncertainties.
  • Presenting the inconsistency within the output financial statements - this should only be considered if you have a way of reliably attributing inconsistencies to particular financial statement areas.

Intermediate balances

Sometimes it is useful to know intermediate balances. For example knowing the inventory balance before sales can help you avoid selling beyond your capacity to deliver.

When intermediate balances are useful, it is often worth considering changing from a control account to a more general cascade.