AP Reconciliation Template and Guide

Reconciling accounts payable to the general ledger is a critical month-end control. This guide provides a template and step-by-step process for accurate AP reconciliation.

Why AP Reconciliation Matters

Monthly reconciliation: - Catches errors before they compound - Ensures financial statement accuracy - Identifies process issues - Satisfies audit requirements - Provides control assurance

Basic AP Reconciliation Concept

The AP subledger (detail of what you owe to each vendor) should equal the AP control account in the general ledger (summary liability on your books).

AP Subledger Total = AP GL Balance

When they don’t match, you need to find and explain the difference.

AP Reconciliation Template

Header Information

ACCOUNTS PAYABLE RECONCILIATION
Period Ending: _______________
Prepared By: _______________ Date: _______________
Reviewed By: _______________ Date: _______________

Section 1: AP Subledger

AP Aging Report Total as of [Date]: $______________

Adjustments to Subledger:
  Add: Items in subledger not yet in GL      $______________
  Less: Items in GL not yet in subledger     $______________
  Other adjustments (explain):               $______________

Adjusted Subledger Total:                    $______________

Section 2: General Ledger

AP Control Account Balance per GL:           $______________

GL Account Breakdown (if multiple accounts):
  Account 2000 - Trade AP                    $______________
  Account 2010 - Accrued AP                  $______________
  Account 2020 - Other AP                    $______________
  Total GL Balance:                          $______________

Section 3: Reconciliation

Adjusted Subledger Total:                    $______________
GL Balance:                                  $______________
                                            ─────────────────
Difference:                                  $______________

Reconciling Items:

Description                     Amount       Status
─────────────────────────────────────────────────────────────
______________________________  $__________  ☐ Resolved
______________________________  $__________  ☐ In Progress
______________________________  $__________  ☐ Carry Forward

Total Reconciling Items:        $______________

Unreconciled Difference:        $______________

Section 4: Sign-Off

Preparer Certification:
I have reconciled the AP subledger to the general ledger. All
differences are explained above.

Signature: _______________ Date: _______________

Reviewer Certification:
I have reviewed this reconciliation and concur with the results.

Signature: _______________ Date: _______________

Step-by-Step Reconciliation Process

Step 1: Run Reports as of the Same Date/Time

From AP Subledger: - AP Aging Report (summary) - AP Aging Report (detail)

From General Ledger: - Trial Balance showing AP accounts - AP account detail (if needed)

Critical: Both reports must be as of the exact same date and time.

Step 2: Compare Totals

If they match, document and you’re done. If they don’t match, proceed to investigate.

Step 3: Identify Common Reconciling Items

Timing Differences: - Transactions posted on close date - Items in transit between systems - Late entries not reflected in one report

Cutoff Issues: - Different close times for subledger vs. GL - Transactions straddling period end

System Issues: - Integration failures - Manual journal entries - Posting errors

Step 4: Investigate Differences

Compare Detail: 1. Print detailed AP aging 2. Print detailed GL activity 3. Tick and tie transactions 4. Identify items in one but not the other

Check for: - Manual journal entries to AP account - Voided transactions - Payment timing differences - Credits not applied - Invoices entered but not posted

Step 5: Document Findings

For each reconciling item: - Describe the item - Explain why it exists - Note expected resolution - Assign owner if action needed

Step 6: Clear Items

Items that can be cleared: - Correct errors in current period - Post missing transactions - Apply unapplied credits - Void duplicate entries

Items to carry forward: - Legitimate timing differences - Items pending investigation - Approved write-offs in process

Step 7: Finalize and Sign Off

• Ensure remaining difference is zero or explained
• Obtain preparer sign-off
• Obtain reviewer sign-off
• File with period close documentation

Common Reconciling Items

Timing Differences

Errors

Process Issues

Reconciliation Best Practices

Timing

• Reconcile monthly at minimum
• Run reports at same time
• Complete within 5 business days of close
• Don’t wait until year-end

Documentation

• Keep all supporting reports
• Document reconciling items clearly
• Explain why items exist (not just what they are)
• Track items carried forward

Review

• Different person should review
• Reviewer should verify math
• Question unusual or recurring items
• Sign-off should be meaningful

Continuous Improvement

• Track common reconciling items
• Address root causes
• Reduce reconciling items over time
• Target zero unexplained differences

Troubleshooting Variances

Large, Unexplained Variance

Steps: 1. Verify report dates match exactly 2. Check for manual GL entries 3. Look for large transactions near period end 4. Compare prior period to identify when variance started 5. Escalate if cannot resolve

Recurring Variance

Common causes: - Systematic timing difference (find and document) - Integration issue (work with IT) - Process gap (fix the process) - Manual workaround causing drift (eliminate workaround)

Variance Equals Specific Invoice(s)

Check for: - Invoice in subledger but not posted - Invoice posted to wrong GL account - Duplicate posting - Invoice incorrectly voided

Small Variance (Won’t Tie to Penny)

Common causes: - Rounding differences - Currency conversion - Tax calculation variances

Resolution: - Investigate if over threshold (e.g., $100) - Document if under threshold and immaterial - Don’t waste hours on pennies

Excel Reconciliation Template

Column Structure

Formulas

Difference: =SUM(Subledger Total) - SUM(GL Balance)
Reconciling Total: =SUM(Reconciling Items)
Remaining: =Difference - Reconciling Total

Key Takeaways

• Reconcile AP subledger to GL monthly
• Run reports as of the exact same date/time
• Investigate all differences—don’t just accept them
• Document reconciling items clearly
• Have someone else review the reconciliation
• Track and resolve recurring items
• Target zero unexplained variance

Want cleaner data flowing into your AP system? See how BillerPlus captures invoice information at intake →