Matching & Reconciliation

What is Reconciliation?

The process of comparing and matching records between systems to ensure accuracy, identify discrepancies, and maintain financial integrity.

Quick Definition

Reconciliation is the accounting process of comparing two or more sets of records to verify they are in agreement. Common examples include bank reconciliation (comparing bank statements to cash records) and vendor reconciliation (comparing vendor statements to AP records).

  • Ensures accuracy between internal and external records
  • Identifies errors, duplicates, and missing transactions
  • Critical for financial statement accuracy and fraud detection
Reconciliation - Comparing Records Between Systems

Understanding Reconciliation

Reconciliation is a fundamental financial control that ensures records across different systems agree with each other. It's the process of comparing data from two or more sources—typically an internal record and an external statement—to identify and resolve any differences.

In accounts payable, reconciliation serves several critical purposes:

  1. Verify accuracy — Confirm that all payments made match what was recorded in your systems
  2. Detect errors — Identify duplicate payments, missing transactions, or data entry mistakes
  3. Prevent fraud — Catch unauthorized transactions or suspicious patterns
  4. Maintain compliance — Ensure financial statements accurately reflect your organization's position

Unlike invoice matching, which occurs before payment, reconciliation typically happens after transactions are recorded to verify everything was captured correctly.

Types of Reconciliation

Bank Reconciliation Most Common

Compares your bank statement to your internal cash records to ensure all deposits, withdrawals, and fees are properly recorded.

Bank Statement vs. Cash LedgerTypically monthly

Vendor Reconciliation

Compares vendor statements to your AP subledger to identify outstanding invoices, unapplied payments, or disputed items.

Vendor Statement vs. AP RecordsMonthly or quarterly

Intercompany Reconciliation

Compares transactions between related entities within an organization to ensure intercompany balances eliminate properly during consolidation.

Entity A Records vs. Entity B RecordsMonthly close

Subledger-to-GL Reconciliation

Verifies that subledger totals (AP, AR, inventory) agree with the corresponding general ledger control accounts.

AP Subledger vs. AP Control AccountPeriod-end close

The Reconciliation Process

1

Gather Records

Collect the internal records and external statements to be compared for the reconciliation period.

2

Match Transactions

Compare records line by line to identify transactions that appear in both sources and agree in amount.

3

Identify Differences

Flag transactions that appear in only one source, or that appear in both but with different amounts.

4

Investigate Discrepancies

Research each difference to determine the cause—timing, error, omission, or unauthorized transaction.

5

Make Adjustments

Record necessary journal entries to correct errors and update records based on findings.

6

Document and Approve

Prepare reconciliation documentation with explanations for all differences and obtain required approvals.

Matching vs. Reconciliation

While often confused, matching and reconciliation serve different purposes in the procure-to-pay process.

Invoice Matching

  • -Occurs before payment
  • -Compares documents within one transaction
  • -Invoice vs. PO vs. Receipt
  • -Authorizes payment release

Reconciliation

  • -Occurs after transactions post
  • -Compares aggregated records across systems
  • -Internal ledger vs. external statement
  • -Verifies recording completeness

Common Discrepancy Types

Timing Differences

Transactions recorded in different periods—like checks issued but not yet cleared, or deposits in transit. These reconcile in subsequent periods.

Data Entry Errors

Transposition errors, incorrect amounts, or wrong account coding. These require corrections to internal records.

Missing Transactions

Items appearing on external statements but not in internal records—bank fees, automatic debits, or invoices not yet recorded.

Duplicate Transactions

The same transaction recorded twice, often from processing the same invoice or payment more than once.

Benefits of Automated Reconciliation

Speed and Efficiency

Match thousands of transactions in minutes instead of days. Automated reconciliation is 90% faster than manual processes.

Higher Match Rates

AI-powered matching handles variations in descriptions, amounts, and dates that would create false exceptions in rule-based systems.

Better Controls

Consistent application of matching rules, complete audit trails, and no items overlooked due to manual fatigue.

Earlier Detection

More frequent reconciliation catches errors and fraud faster, reducing the cost and complexity of resolution.

Continuous Reconciliation

Move from monthly to daily reconciliation without adding headcount, enabling real-time visibility into financial position.

Why Reconciliation Matters

30%

of payments have reconciliation issues

5-10 hrs

Average time for manual bank reconciliation

90%

Time reduction with automation

Organizations that delay or skip reconciliation face higher risk of undetected errors, fraud losses, and inaccurate financial statements. Automation makes frequent reconciliation practical and cost-effective.

Common Reconciliation Mistakes

  • XReconciling too infrequently — Monthly reconciliation misses issues that compound over time
  • XForcing balances to match — Adjusting records to eliminate differences without investigation
  • XNot documenting discrepancies — Missing patterns that indicate systematic issues or fraud
  • XSame person records and reconciles — Lacking segregation of duties creates control weaknesses

Frequently Asked Questions

Automate Your Reconciliation

See how Remmi helps AP teams reconcile faster with AI-powered matching that catches discrepancies and reduces manual effort.