Rounding Discrepancy in Trial Balance Reconciliation with Auditors
We are seeking guidance regarding a reconciliation discrepancy between our Business and Finance team and our auditors. The issue stems from differences in how rounding is applied during Trial Balance reconciliation.
Our Trial Balance and related reports are generated using nVision with matrix layouts. To streamline reporting and reduce maintenance, we use Trees to summarize data. This allows us to avoid updating multiple reports when a new Chartfield is added. For example, a new Fund or Account.
Each year, our auditors receive a raw data extract from the ledger table (ACTUALS ledger). Before performing any calculations, they round every amount to the nearest dollar at the row level.