Reconciling a Suspense Account After a Batch Import Failure
A regional insurer's finance team runs a nightly interface that posts premium receipts from a billing system into the general ledger. On Monday the suspense account shows a debit balance of 84,300. The interface log reports 1,240 receipts totaling 1,187,600 successfully posted, but the billing system's control total for the same run is 1,271,900 across 1,268 records. The difference of 84,300 matches exactly the sum of 28 receipts flagged 'currency = null' in the staging table. The team lead wants to force-post the 28 records to clear suspense before month-end close in two days. The ERP treats suspense as a balance-sheet clearing account that must net to zero at close. A separate manual journal of 84,300 posted last Friday is still unapproved and sitting in a workflow queue.
1. The team lead proposes force-posting the 28 flagged receipts to clear the suspense balance. Evaluate this proposal and recommend the correct treatment.
Read the worked answer
Force-posting would clear the visible balance but would corrupt the ledger in two ways. First, the 28 records have a null currency, so any posting assigns an arbitrary or default currency and creates a foreign-exchange exposure that cannot be substantiated. Second, the 84,300 difference is explained by those 28 records - it is not an unexplained residual. The correct treatment is to hold the 28 records in staging, correct the currency field at source (or map it via a validated lookup), and re-run the interface so the receipts post with their true currency. Suspense should be cleared by the corrected interface run, not by a manual plug.
Key reasoning: an explained variance is not a suspense item. The control-total gap (1,271,900 − 1,187,600 = 84,300) reconciles exactly to the 28 excluded records, so there is no missing money - only a data-quality defect. Posting to suspense and then force-clearing would double-count the receipts and leave the ledger unable to reconcile to the billing control total.
2. What is the significance of the unapproved 84,300 manual journal, and how should it affect the close decision?
Read the worked answer
The coincidence of amount is the trap. A manual journal of exactly 84,300 sitting unapproved is either (a) an attempt to pre-clear the same variance, or (b) an unrelated entry that happens to match. Either way it must not be approved to 'solve' the suspense balance, because the suspense balance is already fully explained by the 28 staging records. Approving it would create a second 84,300 entry against the same underlying cause, overstating the clearing and leaving the GL out of agreement with the billing control total.
The correct action: quarantine the manual journal, trace its preparer and purpose, and reject it if it was raised to clear suspense. Document the reconciliation (control total vs posted vs staged exceptions) as close evidence. Close can proceed with the 28 records held as a known, quantified exception provided the suspense account is supported by a reconciliation schedule - not by a plug.