-- User Help --
-- How Do I? --

Adding and modifying rounding relations

In the financial statements, you can use rounding relations functionality to compare balances in two cells and add the difference to a specified third cell (called the plug cell).

  1. Open the Financial statements document and select the Global Setup tab.

  2. Click the Apply relations link. A rounding relation pane appears.

  3. To add a new rounding relation, click (Add a rounding relation). To modify an existing rounding relation, click (Modify a rounding relation).

  4. If you are adding a new rounding relation, in the Label field, type a label for the new rounding relation. If you are modifying an existing rounding relation, from the Label drop-down, select the label of the rounding relation that you want to modify.

  5. Click the radio button next to Cell A. In the financial statements, click on a cell. This cell becomes the first of the two cells to be compared in the rounding relation, and its name and description are included in the fields to the right of the Cell A radio button. For example, Total assets.

  6. Click the radio button next to Cell B. In the financial statements, click on a cell. This cell becomes the second of the two cells to be compared in the rounding relation, and its name and description are included in the fields to the right of the Cell B radio button. For example, Total liabilities and equity.

  7. If only one plug cell is needed, click the radio button next to Cell C. In the financial statements, click on a cell. This cell becomes the plug cell, which is the place where the difference between Cell A and Cell B is stored. Its name and description are included in the fields to the right of the Cell C radio button. For example, Accounts payable.

  8. If necessary, create conditional plug cells. >>How Do I?

  9. In the Rounding tolerance field, type the rounding tolerance, which is the maximum allowed difference between Cell A and Cell B. If the difference is greater than the rounding tolerance, an error message is displayed.

  10. Click Save.

The rounding relation you have specified is added.