Using Rounding Relations
In a financial statement area, you can add a new rounding relation, modify an existing rounding relation, or delete a rounding relation
Prerequisites
To use rounding relations in a financial statement area, you must first open the Firm Library document for this area. See the section Accessing a financial statement area for details on how to do this.
Adding and Applying a Rounding Relation
After you have created rounding relations, you can apply them to test in your library file. However, end users have to apply the relations in their client file to turn rounding on.
Rounding relations can be enabled in the library when the relation is contained within a particular financial statement area, such as the balance sheet. However, relations between statements, such as between the balance sheet and the cash flow statement, must be created in the financial statements and not the respective library documents.
Procedure
- Open the Firm Library document for the area. See the section Accessing a financial statement area for details on how to do this.
-
From the Format tab, in the Operations group, click Rounding (
.) The Rounding dialog will appear. - Select Apply Rounding and Apply Rounding Relations options to enable rounding in the document
-
In the Round To list, select to round figures in the document to ones, thousands, or millions of currencies.
-
Click Add to create a new rounding relation.
-
Type or select the cell to be used for the difference cells, that is cells 1 and 2 in the rounding formula.
-
Type or select the cell to be used as the plug cell (Cell 3) in the rounding formula. The difference between cells 1 and 2 will be added into the plug cell. Click Advanced... to add a plug condition.
-
In the Identifier box, enter a brief description of the rounding relation. An identifier can include, for example, references to the cell numbers in the rounding relation. This is used internally to identify the rounding relation.
-
In the Display Label box, type a description that will be displayed in the Recalculation Error dialog each time a rounding error occurs to help identify the area of the document that contains the error. The display label is also used as a unique identifier for the rounding relation during knowledge library updates. Users have the option in the Section dialog on the Label tab to specify the rounding relations that should be updated during an update for each section based on this label.
Note: We recommend using display labels for all rounding relations. With a label attached, when a cell is renumbered, the label is updated correctly during knowledge library updates.
Results
The new rounding relation is available for use.
Deleting a Rounding Relation
You can delete any rounding relation that you have added.
Procedure
- Open the Firm Library document for the area. See the section Accessing a financial statement area for details on how to do this.
-
From the Format tab, in the Operations group, click Rounding (
). The Rounding dialog will appear. - Select the rounding relation in the Relation list and click Delete.
Results
The selected rounding relation is deleted.
