About Rounding Relations
Use rounding relations to change the appearance of figures in the financial statements and to balance the financial statements.
The CaseView rounding relations feature automatically calculates the difference between two cells and places the difference into a third cell, the plug cell. The rounding formula is as follows:
Cell 1 - Cell 2 = PLUG CELL
For example, in a balance sheet, the rounding relation calculates the difference between the Total Assets cell and the Total Liabilities cell, which displays in the plug cell. For a rounding relation to work, the plug cell (i.e. Accounts Receivable or Accounts Payable) has to be part of the Total Assets or Total Liabilities cell.
The contents of the plug cell will differ depending on whether an asset account or a liability account is used as the rounding account, for example:
If the rounding account is |
Difference Cell 1 should be |
Difference Cell 2 should be |
An asset |
Total Liabilities |
Total Assets |
A liability |
Total Assets |
Total Liabilities |