How do I tie subledgers (AR/AP/inventory) to the GL at close?
All three share one root pattern: a subledger and its GL control account stay in sync only when every transaction goes through a real subledger type — an invoice, a bill, a receipt — never a bare journal entry against the control account. Check each subledger's own detail report against its control account separately; a tie on one doesn't imply a tie on the others.
By Zuny Fester, Head of Operations and MarketingPart of the month-end close guide.
| The shared root pattern | A journal entry posted directly to a control account, bypassing the transaction type that also updates the subledger |
|---|---|
| AR | Compare an AR aging/register report to the AR control account — see the dedicated AR subledger page for the detailed mechanics |
| AP | Compare a vendor balance/AP aging report to the AP control account — same bypass risk, on the payable side |
| Inventory | Compare an Inventory Valuation report to the inventory GL account — only receipt and issue transactions should hit it |
| Close-process discipline | Any manual JE against one of these control accounts should require documentation and be treated as a reconciling item, not routine activity |
Why the same root cause shows up in all three
AR, AP, and inventory subledgers break out of sync with their GL control accounts for structurally the same reason: someone posted a journal entry directly against the control account instead of going through the transaction type that's actually designed to keep both sides moving together. For AR that's an invoice or payment; for AP it's a bill or bill payment; for inventory it's a receipt or issue transaction. A bare journal entry updates the GL balance immediately but has no mechanism to touch the corresponding subledger detail, which is exactly what creates the gap.
Why each subledger still needs its own separate check
Sharing a root cause doesn't mean sharing a reconciliation — AR ties to its own control account using an AR-specific detail report (see the dedicated page on that), AP ties to its own control account the same way using vendor balance/AP aging detail, and inventory ties using an Inventory Valuation report, which lists the transactions actually affecting inventory value rather than a customer- or vendor-level balance. A clean AR tie says nothing about whether AP or inventory are also clean — each needs to be pulled and compared on its own during close, not assumed from the others.
What's specific to inventory's break pattern
Inventory has one wrinkle AR and AP don't: its GL account should be touched by receipt and issue transactions specifically, tracking physical inventory movement in and out. A manual adjustment — correcting a count discrepancy, writing off damaged stock — that's posted as a bare journal entry rather than through a proper inventory adjustment transaction creates the same detail-vs-control-account gap as an AR or AP journal-entry bypass, but the diagnostic signal is different: it shows up as inventory value on the GL that doesn't trace to any actual receipt, issue, or documented adjustment transaction in the subledger detail.
Making the discipline explicit for close
The practical takeaway for a close checklist isn't "double-check the math" — it's a policy question: does a manual journal entry against any of these three control accounts require documentation and approval before it's posted? Treating any such entry as a flagged reconciling item, rather than routine close activity, is what actually prevents this break pattern from recurring every period, since the break is never really about arithmetic — it's about a transaction type that skipped the subledger.
Next step
Map the finance workflow with the most exposure and prove the automation path.
Bring the invoice, contract, payment reconciliation, or customer finance workflow you have to defend at audit. Loopfour can map the trigger, controls, integrations, and approval loop.
Checklist
Three subledgers, checked independently, same close
| Subledger | Control account balance | Subledger detail total | Tie? | Root cause if not |
|---|---|---|---|---|
| AR | $406,300 | $406,300 | Yes | — |
| AP | $212,900 | $208,400 | No — off by $4,500 | An accrual journal entry booked directly to AP instead of via a bill |
| Inventory | $1,184,600 | $1,184,600 | Yes | — |
AR and inventory tie cleanly this close. AP doesn't — a $4,500 accrual for an anticipated invoice was booked as a direct journal entry against AP (debit an expense account, credit AP) rather than waiting for the actual bill and entering it as a proper transaction. The fix mirrors the AR journal-entry-bypass case exactly: once the real bill arrives, it needs to be entered as an actual bill (updating both GL and subledger together), and the original accrual journal entry reversed — not left standing alongside the new bill, which would double-count the $4,500.
Frequently Asked Questions
Sources
Related
Topic
Month-End Close
Month-end close is the set of accounting tasks a company runs after a calendar month ends to turn raw transactions into a finished, trustworthy set of financial statements: reconciling subledgers, boo…
Read moreDiagnostic
How do I reconcile negative inventory before closing a period?
Negative inventory usually means a sale or transfer was recorded before the corresponding receipt was entered into the system, so the item's on-hand quantity temporarily went below zero. Find and correct the sequencing — enter the missing receipt, or adjust the transaction dates — before running standard costing or valuation, since both assume a non-negative quantity on hand.
Read moreDiagnostic
Why does my AP aging report not match my GL AP balance?
The AP aging report is your subledger detail; the GL AP balance is the control account it should sum to. A mismatch almost always means a journal entry hit the control account without a matching subledger entry — a manual JE to AP, a bill dated into the wrong period, or an accrual that never reversed. Find the entry that only exists on one side.
Read moreDiagnostic
How do I reconcile the AR subledger to the GL control account?
Pull the AR subledger balance (sum of open customer invoices, from an AR aging or register report) and compare it to the GL's AR control account balance for the same period-end. They should match exactly. When they don't, the almost-always cause is a journal entry posted directly to the AR GL account instead of through an actual invoice or payment transaction.
Read more