Reconciling the Payables Trial Balance to the GL Liability
At March period close, the Payables Trial Balance by Supplier shows a total liability of $842,300, but the GL accounts payable liability account shows $838,100. The difference is $4,200. Open items include three invoices on hold totaling $2,500; one manual payment of $1,200 recorded in Payables but not yet accounted; one prepayment of $800 applied to an invoice; and one foreign-currency invoice for EUR 5,000 with a $300 exchange rate variance. Create Accounting has not been run for the period. The subledger accounting period and GL period are both open. The controller wants to close in two days and asks whether the difference is an error or a timing issue. AP must also decide whether to release the held invoices before close.
1. What reconciliation approach would you use, and which Oracle reports and processes would you inspect?
Read the worked answer
I would treat the $4,200 as unexplained until the subledger and GL are compared at the same accounting state. First, run Create Accounting in draft or final for Payables and review the output for errors. Then compare the Payables Trial Balance to the Subledger Accounting trial balance and the GL trial balance for the AP liability account. I would also run an unaccounted transactions report and review the payment register, prepayment applications, and any revaluation entries.
The key is to reconcile by supplier and by accounting line, not just by total. A total difference can be a net of offsetting items: an unaccounted invoice, an unaccounted payment, a prepayment application, and an exchange variance. I would verify whether each item is in the subledger only, the GL only, or both. I would not adjust the GL manually to force agreement; that hides the timing or setup issue and creates audit risk.
2. For each open item, state whether it can explain the $4,200 difference and why.
Read the worked answer
The analysis depends on whether the item has been accounted and posted, not merely whether it exists in Payables.
- Three invoices on hold totaling $2,500: a hold alone does not necessarily stop accounting. If the invoices are validated and accounted, they affect both subledger and GL. They explain the difference only if they are unvalidated or unaccounted, so check their accounting status.
- Manual payment of $1,200 not yet accounted: this can create a timing difference because the payment reduces the Payables liability in the subledger but has no GL journal yet. Direction and amount must be verified.
- Prepayment of $800 applied to an invoice: if the application is accounted, the liability effect should be in both ledgers. If it is unaccounted, it can contribute to the difference.
- EUR 5,000 invoice with a $300 exchange variance: the variance may be a revaluation or accounting timing item. It explains the difference only if the revaluation or exchange accounting has not been posted.
The $4,200 cannot be assumed to equal the sum of the face amounts. Each item must be traced to its accounting entry.
3. What should AP do before close to avoid forcing the balance?
Read the worked answer
AP should complete the accounting cycle in the correct order: validate all invoices, resolve or document holds, run Create Accounting to final, correct any errors, transfer and post the journals to GL, run foreign-currency revaluation where required, and then reconcile the subledger to GL. Held invoices should be released only if the underlying issue is resolved; releasing them just to make the balance move is not a valid close action.
If the difference remains, document each reconciling item with an owner and expected clearing date. The controller can close with a supported reconciliation, but should not post a manual plug. The decision on the held invoices should be based on whether they are valid liabilities, not on whether they help the trial balance tie.