General ledger vs subledger: AP and AR reconciliation with examples and a free template

The general ledger holds one summary balance per account, such as accounts payable, while a subledger holds the detail behind it: every open bill by vendor or every open invoice by customer. Knowing which ledger owns which detail tells you where to look when they disagree.

• Control accountA general ledger account whose balance is supported by a subledger, so it should change only through that subledger. Accounts payable and accounts receivable are the classic control accounts, and inventory and fixed assets often are too.
• SubledgerThe detailed ledger behind one control account. The AP subledger tracks bills, credits, and payments by vendor, and the AR subledger tracks invoices, credit memos, and receipts by customer.
• Aging reportThe subledger's open items grouped by age, such as current, 1–30 days, and over 90 days. Its total is the number you tie to the control account, which is why you run it at every month-end.

The point of a subledger is to keep high-volume vendor and customer detail out of the general ledger while still tying to it in one number.

AP and AR reconciliation, also called subledger to general ledger reconciliation, proves that your AP and AR aging totals agree with their control accounts at month-end, with every difference explained. It's one type of account reconciliation, and it covers two of your main working capital balances.

• Accounts payable reconciliationTies the AP aging to the AP control account, then checks key vendor balances against their statements. It catches accruals posted to AP, batches that never reached the ledger, and invoices you never entered.
• Accounts receivable reconciliationTies the AR aging to the AR control account and confirms each customer payment is applied to the right invoices. It catches credit memos that didn't sync, receipts posted in the wrong month, and unapplied cash.

The general ledger and subledger reconciliation formula is the same on both sides:

• Adjusted GL balanceGL balance ± ledger-side items
• Adjusted aging totalAging total ± subledger-side items
• Unexplained differenceAdjusted GL balance − adjusted aging total, which should be $0

For a subledger tie-out the target is $0, because both ledgers record the same transactions. A written threshold still helps, as a trigger for which items you investigate first and which go to the controller. It isn't a reason to leave a gap unexplained.

The AP reconciliation process has seven steps: close the cutoff, run both reports as of the same date, roll forward last month's balance, compare totals, explain each difference, reconcile key vendor statements, and post corrections for review. Working in this order puts the cheapest checks first.

1. 1Close the cutoffEnter every bill for goods and services received by month-end and every payment released. Accrue receipts with no bill yet to accrued liabilities, not to AP, then close the AP module for the period.
2. 2Run both reports as of the same datePull the AP aging and the GL balance for every account mapped to AP, with the same entity, currency, and accounting basis.
3. 3Roll forward last month's reconciled balanceOpening balance + bills − payments − credits ± manual journal entries should equal the closing GL balance. Start from last month's reconciled number, not from scratch.
4. 4Compare the totalsWrite down the difference before you look at individual items.
5. 5Explain each differenceCheck manual journal entries to the control account first, then unposted batches, items in the wrong period, and a second AP account.
6. 6Reconcile key vendor statementsStart with your largest vendors, any vendor with a dispute, and any vendor showing a debit balance.
7. 7Post corrections and get sign-offPost the entries, rerun both reports, confirm the unexplained difference is $0, and send the reconciliation with its support to a reviewer.

For a month-end reconciliation of accounts payable, steps 1 and 7 are the close tasks: cutoff before you start and a reviewed reconciliation before the period locks. See where they sit with owners and due dates in the month-end close checklist. The signed AP tie-out is also the support for accounts payable in your balance sheet reconciliation.

In this accounts payable reconciliation example, a misposted accrual and an unposted batch explain a $5,450 gap between a $407,150 AP aging and a $412,600 general ledger balance. An invoice found on a vendor statement then sets the reconciled balance.

AP aging, October 31, 2026

AP aging vs GL reconciliation, October 31, 2026

What each item means:

• JE-2291 ($9,250)A month-end accrual for legal fees with no invoice yet was credited to accounts payable instead of accrued expenses. In this company's system, it sits in the ledger but not in the aging, because no vendor bill exists.
• Batch B-1107 ($3,800)Three bills posted in the AP module on October 31, but the matching general ledger batch is still unposted. They're in the aging but not in the ledger.
• INV-7781 ($8,500)The vendor statement check for Vendor 1042 found an October invoice that was never entered. It's missing from both ledgers, so the tie-out can't see it.

Correcting entries, October 31, 2026

Entry 1 is the kind of manual entry to a control account worth allowing: a reviewer-approved fix of an earlier mispost. Entry 2 is the system's own batch posting, and entry 3 runs through the subledger, so it moves the aging and the ledger together.

Reconciled AP balances, October 31, 2026

The three adjustments net +$3,050 in the ledger ($3,800 + $8,500 − $9,250), and both sides land on $415,650.

You reconcile accounts receivable by tying the AR aging to the AR control account as of the same date, explaining every difference, and checking unapplied cash and open credit memos on their own. These steps keep receivables and revenue accurate each month.

1. 1Run both reports after billing's last syncPull the AR aging and the GL balance for every account mapped to AR, as of month-end.
2. 2Roll forward last month's reconciled balanceOpening balance + invoices − receipts − credit memos ± manual journal entries should equal the closing GL balance.
3. 3Compare totalsCalculate the difference between the aging and the ledger.
4. 4Check billing and credit memo syncFind invoices and credit memos in billing that never reached the ledger.
5. 5Check cash receipt cutoffCompare receipts applied in the subledger with cash posted to the ledger and with bank deposit dates.
6. 6Clear unapplied cash and creditsMatch each receipt to invoices using remittances and customer statements, and age anything left.
7. 7Document and sign offConfirm the unexplained difference is $0 and send the schedule with support to a reviewer.

If you bill in one system and book in another, such as Stripe and NetSuite, run three checks. Tie billing to the AR subledger, the AR subledger to the control account, and the payment processor's clearing account to the bank. Match records on the billing system's invoice ID, not on customer name or amount. Include unapplied cash and open credit memos in the comparison, whether your system holds them in AR or in a clearing account.

Document the AR reconciliation on one schedule for your controller's review. Show the GL balance, the aging total, and each reconciling item with its reference, amount, cause, owner, and clearing entry. Then show adjusted balances with $0 unexplained, and attach the aging, the GL detail, and the entries. Your reviewer should be able to re-foot the schedule and trace every item to support.

In this accounts receivable reconciliation example, a credit memo that never synced and a receipt posted in the wrong month explain a $15,500 gap. Applying $24,000 of unapplied cash then brings both ledgers to $1,246,900.

AR aging, October 31, 2026

AR aging vs GL reconciliation, October 31, 2026

What each item means:

• Credit memo CM-311 ($6,500)Billing issued a credit on October 28 for a pricing error, and the aging shows it. The sync to the general ledger failed, so the ledger still carries the full invoice. Repost it through the integration, dated October 28, rather than keying a manual journal.
• Cutoff item ($9,000)A customer check arrived October 31 and was applied in billing that day, but the cash batch posted to the ledger on November 2, the deposit date. Record the receipt in October. It then shows as a deposit in transit on your October bank reconciliation.

How do you clear unapplied cash?

You clear unapplied cash by matching each receipt to the customer's open invoices, using the remittance or the customer's confirmation, and applying it in the AR subledger. In this setup it doesn't create an aging-to-GL gap, so it needs its own check.

A $24,000 ACH payment from Customer 207 arrived October 30 with no invoice numbers, so cash application posted it to 2150 Unapplied cash. Both the aging and the ledger still show the customer's two invoices as open. Customer 207's remittance, emailed separately, names invoices INV-20311 and INV-20318, both in the 1–30 day bucket, and applying the payment lowers both ledgers by $24,000.

If you present receivables net of unapplied cash on the balance sheet, show that netting on the reconciliation so your reviewer can follow it. Age every receipt that stays unapplied, and give it an owner, so it can't sit unexamined inside receivables at month-end.

Correcting entries, October 31, 2026

For entry 2, either move the cash batch into October or post this entry and reverse the November posting, so the receipt isn't counted twice. Entry 3 runs through cash application, so it moves the aging and the ledger together.

Reconciled AR balances, October 31, 2026

The 2150 Unapplied cash account is back to $0, and the three adjustments net ($39,500) in the ledger.

Your aging and general ledger disagree when something hit one ledger but not the other, or when you ran the two reports on different dates, periods, or accounting bases. Sorting the gap by cause tells you which ledger to correct.

An AP aging shows open bills, credits, and unapplied payments by vendor. It doesn't show services or goods received without a bill, which belong in accrued liabilities (see accrued expenses). Depending on your system, it may also leave out journal entries posted straight to AP, or group them on a line with no vendor.

Goods received but not invoiced (GRNI) belong in an accrued liabilities or GRNI account, not in the AP control account. If they're posted to AP, the GL runs ahead of the aging by that amount until it's reclassed, as JE-2291 did in the example. Reclass them, reverse the accrual when the bill arrives, and reconcile the GRNI account separately against open receipts.

To resolve AP reconciliation discrepancies, work by category, not line by line. Timing items clear next month, one-sided entries need a correcting entry in the right ledger, and anything still unexplained stays open with an owner. To set up an alert for repeats, run a month-end saved search or report that lists every journal entry posted to a control account.

Where the tie-out breaks in NetSuite, QuickBooks, SAP, and Dynamics

Each ERP breaks the AP and AR tie-out in a different place, so start with the setting or report your system's own help names. Every row below comes from the vendor's help pages, checked November 11, 2026.

For accounts payable reconciliation in SAP, that means down payments and other special G/L items are the first place to look, not manual journals. NetSuite's period close checklist also has separate Lock A/R and Lock A/P tasks (Oracle NetSuite help, “Locking and Unlocking Accounting Periods”). They let you stop A/R and A/P posting for the period separately from the rest of the ledger.

How do you find the month a difference started?

Run the aging and the GL balance for each prior month-end until they agree, then compare the next month's activity line by line. In that month, look for a migration balance, a one-sided journal, or an edit in a period that should have been closed.

The difference first appears in July, so the team compares July's GL detail for the control account with July's subledger activity. A July 14 journal entry wrote off an old vendor balance in the GL without closing the vendor's open bill. The fix is to reverse the journal and write off the bill in the subledger, so both ledgers move together.

Vendor statement reconciliation compares a supplier's statement with your AP balance for that supplier and explains each difference, and customer statement reconciliation does the same for what a customer says it owes you. Both catch errors the aging-to-GL tie-out can't see.

Only the vendor's statement shows an invoice you never entered, such as INV-7781 in the AP example. The vendor statement reconciliation, also called an accounts payable reconciliation statement, is a short schedule for each vendor you review.

How to treat each item:

• Unrecorded invoice ($8,500)The cartons arrived October 28, so under accrual accounting the liability belongs in October: it follows receipt of the goods (or title transfer under the shipping terms), not the October 29 invoice date. Enter it through the AP module, as entry 3 above. If you had already accrued the receipt as received but not invoiced, reverse that accrual at the same time.
• Payment in transit ($6,000)Your books already show the payment, so no entry is needed. Confirm the vendor applies it on the November statement.
• Disputed credit ($2,000)You recorded debit memo DM-118 because the vendor billed above the contract price. Keep it as an open item with an owner and a follow-up date. If the vendor wins the dispute, reverse it: debit inventory $2,000 and credit accounts payable $2,000.

Customer statements work the same way in reverse. Customer 207's AP team replied to its October statement that it paid two invoices on October 30. That reply is the evidence for applying the $24,000 of unapplied cash.

Customer statement reconciliation, Customer 207, October 31, 2026

An AP and AR reconciliation template needs a header, a GL roll-forward, the aging total as of the same date, a reconciling items log, adjusted balances with a $0 unexplained difference, statement checks, correcting entries, and sign-off. The free workbook below has all eight, prefilled with this page's October example.

The AR tab uses the same layout and adds an unapplied cash check for the 2150 clearing account and a customer statement check. Every total is a formula, and a side column (Ledger, Subledger, or Both) tells the workbook which balance each item adjusts.

These are the core formulas in the accounts payable reconciliation format in Excel, using the workbook's named ranges:

Status reads Enter balances only when the GL balance or every aging bucket is blank, so a true $0 aging still reconciles. The workbook uses only SUM, SUMIFS, COUNT, COUNTIFS, IF, AND, OR, and ROUND, so it calculates the same way in Google Sheets. The Instructions tab doubles as an AP and AR reconciliation checklist, with eight monthly steps from cutoff to sign-off. Print the AP or AR tab to PDF if your audit file needs a static copy.

Reconcile AP and AR to the general ledger every month before the period locks, check unapplied cash weekly, and have someone who didn't prepare the reconciliation review and sign it. A fixed cadence keeps small differences from aging into audit findings.

One person can handle both AP and AR and prepare both reconciliations, as long as someone else reviews them and the preparer doesn't also approve payments. On a one-person team, the controller or owner reviews every reconciliation and approves every payment run.

Restrict manual journal entries to the AP and AR control accounts. Accruals, reclasses, and write-offs should post to other accounts or flow through the subledger, so the control accounts move only with vendor and customer transactions. Where your ERP can't block them, run the month-end search for journals on control accounts and clear each one.

Close the AP and AR modules before the general ledger, so the balances you're reconciling can't change underneath you. For how period locks work in each system, see lock accounting period.

Verify vendor payment details as part of the AP review. The Association for Financial Professionals released its 2026 Payments Fraud and Control Survey on April 14, 2026, based on 465 treasury practitioners at US organizations. In it, 76% of organizations experienced attempted or actual payments fraud in 2025. In the same survey, 74% were affected by business email compromise. Confirm any change to vendor bank details by calling a known contact before the next payment run.

Make the reconciliation a fixed close task with a named preparer and reviewer and the same template every month. Write down your investigation threshold, and escalate any reconciling item that carries into a second month. If you reconcile many entities or accounts, compare tools in best account reconciliation software.

Our Close Agent works payables and receivables as tasks on your close checklist. It ties each AP and AR aging to its control account, lists every reconciling item with its support, and proposes the correcting entries. Each reconciliation goes to a named reviewer, and the period can't lock until it's approved. If you want these reconciliations ready before your team starts the close, explore our Close Agent.