Two Days to Close August: Exceptions, Unaccounted Items, and a 47,320 USD Gap
Meridian Health Supply runs Receivables in three business units on one primary ledger and must close the August 2026 AR period in two days. Open items: 3 AutoInvoice interface lines worth 1,250 USD have sat in exception across four import attempts; 220 transactions are unaccounted because Create Accounting has not been run since the 27th; 5 receipts totaling 180,000 USD are fully applied but still show as remitted rather than cleared; one EUR invoice for 64,000 EUR failed accounting because no exchange rate exists for its GL date; and the Receivables-to-GL reconciliation reports a 47,320 USD difference between the subledger AR balance and the GL receivable account balance for August. The September AR period is still closed and the GL August period is open. A supplier invoice requiring a debit memo of 25,000 USD arrives from the business on the morning of the close.
1. Set out the sequence in which these items must be resolved to close August on time, and explain why the order matters.
Read the worked answer
Sequence matters because AR close freezes the period; anything missed must be dated into the next open period.
- Complete AutoInvoice. Resolve or quarantine the 3 exception lines. Fixing them and re-importing is preferable; if they are genuinely unresolvable within the deadline, document the decision and leave them out of August rather than forcing them through with wrong data.
- Complete receipts and applications. Ensure all receipts are applied or deliberately unapplied, and that applications are final before accounting runs.
- Fix the EUR rate in Currency Rates Manager for the GL date and rate type used by the ledger, then re-run accounting on the failed invoice. Never let a rate error sit until after close.
- Run Create Accounting in Final for August and review the output for exceptions and for any entry that stayed draft.
- Transfer to GL and post. Unposted journals transferred but not posted are one of the most common sources of a reconciliation gap.
- Reconcile AR to GL and clear or explain the residue.
- Close the AR period, then the GL period. Closing AR first locks August; late adjustments then land in September and distort two periods.
Getting steps 4 to 6 out of order is the classic failure: the period closes while journals are still in draft, and the gap has to be chased in the next cycle.
2. How would you isolate and resolve the 47,320 USD difference between the subledger and the GL receivable account?
Read the worked answer
Work from cause to amount, not the other way round. Run the Receivables-to-GL reconciliation by business unit and by account, then test the four usual causes:
- Unaccounted or draft accounting. The 220 unaccounted transactions plus the failed EUR invoice are in the subledger balance but not in the GL. Run Create Accounting, transfer and post, then re-run the reconciliation; this will probably clear the bulk of the gap.
- Journals transferred but not posted. Check the subledger journal entries for August still sitting unposted, and post them.
- Manual GL journals posted directly against the receivable or related accounts. These are not reflected in the subledger and are the classic permanent difference. Identify them, confirm they are legitimate, and either reverse them or disclose them as a reconciling item.
- Date mismatches. Transactions dated in one period but accounted in another, and any receipt whose accounting date differs from its GL date, will shift balances between August and September.
The residue after these four tests should be very small. If it is not, expand by customer and transaction type before accepting it - a residual difference is not a rounding item until you can name every component of it. Never plug the difference.
3. What do you do with the 25,000 USD debit memo that arrives on close day, and how does clearing status of the 180,000 USD in receipts affect the decision?
Read the worked answer
Debit memo timing. The accounting period is driven by the GL date, not by when the paper arrives. Decide on cut-off grounds: if the underlying obligation was incurred in August and the amount is material to the August result, record it in August, which means keeping the AR period open long enough to enter, account and transfer it. If it is not material, date it into September and disclose the cut-off decision. What you must not do is backdate it arbitrarily into a period that has already been reconciled, or leave it in a pending state across the close so that it appears in neither period.
Clearing status. The 180,000 USD in receipts marked remitted rather than cleared is a treasury and bank reconciliation matter. Those receipts generated their AR accounting when they were created and applied; clearing affects cash positioning and the cash-in-transit balance, not whether the receivable is relieved. So clearing should not hold the AR period open - but it must be tracked to completion, because an uncleared receipt that the bank never honours becomes a reversal, and if the AR period is closed by then the reversal has to be accounted in the next period. Flag the 180,000 USD on the close checklist with an owner, and reconcile it against the bank statement before the GL period closes.