You are here: Template Author Topics > Content Creation and Editing in the Knowledge Library > Tables > Inserting an unreconciled difference row
-- Template Author Help --
-- How Do I? --

Inserting an unreconciled difference row

In a table, you can insert an unreconciled difference row before a subtotal row. An unreconciled difference row is a reconciliation of the table subtotal/total compared to the mapped/grouped value in the trial balance. This feature is useful when users must manually select the map/group numbers or manually input values for detailed rows of the table and ensures completeness.

For example, when building the inventory note, the detailed breakout of work-in-progress, raw, and finished goods may exist in a supporting work paper and the total for inventory is in the trial balance. As end users manually add this detail into the inventory note, the unreconciled difference row will keep a running total of the difference between the manually entered data and the mapped value of inventory in the trial balance. The row displays the difference between the subtotal and the corresponding mapping or grouping selected in the row.

The difference will display in red in the client financial statements.

An unreconciled difference row can only be added to subtotals created by the template author. You cannot add to tables where subtotals/totals exist.

  1. In the Firm Library document for the financial statement area, click in the subtotal for which you want to create an unrecognized difference row.

  2. From the Table Tools tab, in the Operations group, select Insert | Insert Unreconciled Difference Row.

  3. From the browse, select the applicable map or group number.

The new row is added immediately above the subtotal.

Note: You can add rounding relations to unreconciled difference row to eliminate rounding differences between notes and related statement line items. For more information, see Using Rounding Relations.