Reconcile Accounts Payable to the General Ledger in QuickBooks Online
A/P can look reasonable while hiding old credits, duplicate bills, or payments that never reached the right vendor record. Accounts payable reconciliation catches those problems before they affect cash planning, financial statements, or a tax return.
In QuickBooks Online, this is a report comparison, not a bank-style task. You compare what vendor-level reports say you owe with the Accounts Payable balance in the general ledger, using the same cutoff date and accounting basis.
A steady monthly process makes differences smaller, easier to explain, and less likely to become a year-end cleanup project.
Why accounts payable reconciliation works differently in QuickBooks Online
QuickBooks Online's standard Reconcile workflow is designed for bank and credit-card accounts. It compares cleared activity against an outside statement ending balance. Accounts Payable has no equivalent statement inside QuickBooks.
Instead, accounts payable reconciliation ties the vendor detail in QuickBooks to the Accounts Payable control account in the general ledger. Both records should show the same liability at month-end.
The A/P aging report is your supporting detail
The Accounts Payable Aging Summary shows the total owed to vendors, grouped by how long each bill has been outstanding. The Accounts Payable Aging Detail goes further by listing bills, credits, dates, due dates, and open balances.
That detail should support the Accounts Payable number on the Balance Sheet. If it doesn't, an entry may have reached the general ledger without appearing correctly in vendor reports.
Bank reconciliation still matters, but it answers a different question
Bank reconciliation confirms that recorded payments and deposits match the bank statement. A/P reconciliation confirms that the unpaid bill balance matches the general ledger.
Both reviews matter. A vendor payment can clear the bank correctly while remaining unapplied to a bill, leaving Accounts Payable overstated. For the bank side of the close, use a consistent QuickBooks Online bank reconciliation checklist.
Pull the right reports before you compare balances
Run reports after you finish entering bills, vendor credits, and payments for the month. More importantly, set every report to the same period-end date . A report set to "Last 30 days" won't reliably tie to a Balance Sheet dated as of month-end.
Menu names can vary by QuickBooks Online edition, region, and interface updates. Look for the report names rather than relying on one fixed click path.
Start with Accounts Payable Aging Detail
Set the Accounts Payable Aging Detail report to "As of" the final day of the month. This is usually the best starting point because it shows the transactions behind each vendor's open balance.
Look for bills that seem too old, negative vendor balances, and credits with no related bill. A negative balance often points to an unapplied payment or vendor credit.
Use vendor reports to isolate the source
Vendor Balance Detail, Vendor Balance Summary, Unpaid Bills, and Bill Payment List can help you narrow a difference. Use them when the aging report shows an unexpected vendor total or a bill that should have been cleared.
Clean bill entry also prevents many errors. Review the difference between bills versus expenses in QuickBooks Online before correcting a transaction. A bill belongs in A/P when you will pay later. An expense is generally appropriate when you pay at the time of purchase.
Compare the General Ledger and Balance Sheet
Run a Balance Sheet as of the same month-end date, then note the Accounts Payable balance. Next, run the General Ledger for the month or a transaction-detail report filtered to Accounts Payable.
This comparison gives you both the ending balance and the entries that created it.
| Report | Date setting | What to compare |
|---|---|---|
| Accounts Payable Aging Detail | As of month-end | Open bills, credits, and vendor balances |
| Balance Sheet | As of the same date | Accounts Payable ending balance |
| General Ledger | Month through month-end | Every debit and credit posted to A/P |
| Bill Payment List | Month through month-end | Payments posted against vendor bills |
The Aging Detail total and the Balance Sheet A/P balance should agree. If they do, scan for unusual aged items before closing the month.
How to reconcile A/P to the general ledger
Use the same sequence every month. It reduces the chance that a correction creates a new difference in another period.
Set one firm cutoff date and accounting basis
Choose the last calendar day of the month, such as September 30, and apply it to every report. Then confirm that each report uses the same accounting basis, usually accrual for accounts payable review.
A bill dated October 1 does not belong in a September A/P reconciliation, even if it was entered early. Likewise, a September bill entered after the close may need review with your accountant before you change a closed period.
Compare the totals first
Write down the A/P Aging Detail total and the Accounts Payable balance on the Balance Sheet. If the figures match, the control account agrees with vendor-level detail.
If they differ, calculate the exact gap. A clean round-number difference may point to one bill, credit, journal entry, or duplicate payment. A collection of smaller differences usually requires transaction-by-transaction review.
A/P can only tie out when every report uses the same "as of" date. A correct report with the wrong cutoff date can create a false discrepancy.
Trace the difference through the general ledger
Filter the General Ledger to Accounts Payable and review entries near month-end first. Compare vendor names, transaction types, amounts, and posting dates against the aging detail.
Then work vendor by vendor. Find the vendor whose open balance differs from the GL activity, open the related transactions, and compare them with invoices, credit memos, payment confirmations, and vendor statements.
Avoid unsupported journal entries to force agreement. Every adjustment needs a source document and a clear explanation.
Find the usual causes of A/P differences
Most A/P mismatches come from a short list of entry problems. Fix the cause, then rerun the reports using the original cutoff date.
Unapplied payments and vendor credits
A vendor payment may be recorded in QuickBooks but not applied to the intended bill. The bank and expense account may look fine, while the bill remains open in A/P.
Vendor credits also stay in Accounts Payable until you apply them to a bill. Review the vendor record for credits, open payments, and negative balances. Apply a valid credit to the related bill, but don't use a vendor credit when the vendor issued a cash refund.
Voided, deleted, and duplicate transactions
A voided or deleted bill can leave an unexpected trail in reports, especially if a payment or credit remains. Check the transaction history and supporting documents before recreating anything.
Duplicates often appear when someone enters a bill manually, then records the same bank-feed payment as a new expense. Another common error occurs when a bill payment is entered twice. Remove or void only the confirmed duplicate, then check that the remaining transaction still has the correct vendor and date.
Posting dates and period-end cutoff errors
A bill dated in one month and paid in the next is normal. However, the bill payment should not change the month in which the expense first belonged. Review both the transaction date and the date entered in QuickBooks.
Late entries, backdated corrections, and payments posted to the wrong period can distort month-end liabilities. If a prior period has already been reported or used for tax filing, confirm the correction with your accountant.
Journal entries without vendor information
A journal entry can post to Accounts Payable but fail to appear properly in vendor reporting if it lacks a vendor association. That creates a GL balance that the aging report cannot support.
Review every journal entry hitting A/P. Ask your accountant before changing entries involving owner contributions, loan activity, inventory adjustments, tax accruals, or prior-period corrections.
Correct errors without creating a second problem
Start with source records, not the report total. Review the bill, vendor statement, credit memo, payment confirmation, and bank activity before making any edit.
When you identify a mistake, correct the original transaction where practical. For example, apply an existing payment to the correct bill instead of entering another payment. If a bank-feed item already matches a bill payment, match it rather than adding a new expense.
QuickBooks Online's audit trail can help identify who changed, voided, or deleted a transaction and when. It is useful for investigation, but it does not prove that A/P and the general ledger agree at a past date.
For several months of duplicate entries, stale balances, or unclear posting patterns, bookkeeping cleanup versus monthly bookkeeping can help you decide whether the work needs a defined cleanup scope or ongoing support.
Use this month-end A/P reconciliation checklist
Complete the review after bills and payments for the period are entered, and before you rely on the Balance Sheet for planning or tax work.
- Set a clear month-end cutoff date and use the same accounting basis on every report.
- Run Accounts Payable Aging Detail, the Balance Sheet, General Ledger, and Bill Payment List.
- Compare the aging total to the Accounts Payable balance on the Balance Sheet.
- Review negative vendor balances, old unpaid bills, unapplied payments, and unused credits.
- Inspect all journal entries posted to Accounts Payable.
- Check for duplicate bills, duplicate payments, and bank-feed expenses that duplicate bill payments.
- Save the reports, note unresolved timing differences, and confirm material corrections with your accountant.
Keep the completed reports with your close records. At year-end, those files support a faster QuickBooks Online tax preparation review and make follow-up questions easier to answer.
Frequently asked questions
Can I use QuickBooks Online's Reconcile tool for Accounts Payable?
No. The built-in Reconcile workflow is for bank and credit-card accounts. Reconcile A/P by comparing Accounts Payable aging and vendor reports with the Accounts Payable balance in the general ledger.
Why does my A/P aging report differ from the Balance Sheet?
The common causes are journal entries to A/P without a vendor, unapplied vendor payments or credits, deleted or voided transactions, duplicate entries, and mismatched report dates. Start by confirming that both reports use the same month-end date.
Should vendor statements match my A/P aging report exactly?
They should generally agree after you account for timing. A vendor may show an invoice or payment that posted after your cutoff date, or may not yet have processed a credit. Compare individual documents and dates before changing your books.
Can I delete an old unpaid bill to make the report look right?
Don't delete it without checking the invoice, vendor communication, and payment history. The bill may be valid, paid incorrectly, or tied to a credit. Deleting it can remove expense history and create a larger discrepancy.
Close the Month With an A/P Balance You Can Trust
A dependable A/P balance starts with one shared cutoff date, matching reports, and source-backed corrections. The general ledger total should always be supported by open bills, valid credits, and properly applied vendor payments.
Monthly accounts payable reconciliation protects cash planning because it shows what the business truly owes. When a difference appears, trace it patiently instead of covering it with a quick adjustment.
