Payment Reconciliation: Types & Example (2026)

Payment reconciliation means comparing a business’s payment records with its bank and payment processor records. It confirms that each transaction has the correct amount, date, and status.

Incorrect payment records throw off the books and make unauthorized transactions harder to spot. A 2026 AFP Payments analysis found that 76% of US organizations reported attempted or actual payment fraud in 2025. Regular payment reconciliation identifies discrepancies and prompts investigation before they hit the financial reports.

This guide covers payment reconciliation types, a four-step reconciliation process, and when to bring in software or automation.

What is payment reconciliation?

Businesses use payment reconciliation to compare internal payment records with external records and confirm that the transactions agree. Those external records could be bank or credit card statements or batch reports from a payment processor that list the payments included in each settlement.

Reconciliation is part of bookkeeping and accounting. For each payment in the books, the business checks the amount, date, and status against the corresponding entry in a bank statement, settlement report, or other financial statement.

The business receives payment funds through settlement and uses reconciliation to confirm that transfers match their records.

Why payment reconciliation is important

Companies use payment reconciliation to confirm that the transactions in the general ledger match what their bank, card issuer, payment processor, or gateway reports. Any differences in amount, date, or payment status require an explanation before the business can close their books for the period.

Payment discrepancies include:

• Timing differences. A payment reaches one set of records before the other.
• Missing transactions. A bank or processor record contains a payment that is absent from the ledger.
• Incorrect amounts. The ledger entry and external record show different totals.
• Duplicate entries. The same payment appears more than once in the ledger.
• Fees, refunds, or chargebacks. A processor adjustment changes the amount deposited.
• Settlement batch differences. The payments in a settlement report add up to a different amount than the bank deposit.
• Unauthorized transactions. The account includes an unapproved payment.

Timing and data-entry errors explain many discrepancies, but sometimes those discrepancies indicate suspicious activity. Juniper Research estimated $56.1 billion in fraudulent ecommerce transactions worldwide in 2025. When a transaction looks suspicious, confirm the amount and recipient with the customer, supplier, or payment processor as part of the fraud investigation.

Payment records also feed cash flow reports. After reconciliation, the reports can account for cleared payments, available cash, and outstanding balances. Auditors and tax preparers can trace each ledger entry to a bank statement or processor report. The transaction history also documents how the business applied accounting rules.

Types of payment reconciliation

The payment method determines which records a business compares. Reconcilable payment types include:

• Bank reconciliation
• Credit card reconciliation
• Digital wallet reconciliation
• Cash and POS reconciliation
• Payment gateway reconciliation
• Accounts receivable and payable reconciliation
• Billing reconciliation
• Foreign currency reconciliation

Bank reconciliation

Bank reconciliation is when businesses compare the cash balance in their ledger with the balance on their bank statement. Timing differences often explain mismatched totals.

A rejected customer payment, service fee, or interest credit may also appear on the statement before it reaches the business’s bank account records.

For example, a store that deposits $2,400 on June 30 may see the bank post it on July 1. The June reconciliation records a $2,400 deposit in transit and clears it when it appears on the July statement.

Credit card reconciliation

Credit card reconciliation lets businesses compare company card activity records with the card issuer’s statement. A review covers purchases, refunds, and payments made to the card account.

If a $650 inventory purchase was entered as $560, the statement supplies the correct amount for the ledger adjustment.

Digital wallet reconciliation

Digital wallets accounted for 56% of global ecommerce transaction value in 2025, according to Worldpay. Reconciling these payments means matching each order to the processor record and final bank deposit.

A $100 Shop Pay order might produce a $97 bank deposit after a $3 processing fee. The store records $100 in sales and $3 in processing fees, then matches the $97 settlement to the deposit.

Cryptocurrency payments, if accepted, require separate tax records. The IRS treats digital assets as property for federal income tax purposes. A store that accepts crypto records the amount received and its USD value, as well as any subsequent sale, exchange, or transfer.

The tax information above is for general education and does not constitute legal or tax advice. Consult a qualified professional about your business.

Cash and POS reconciliation

At a brick-and-mortar store, the point-of-sale (POS) system closes groups of sales by payment type. Store owners or staff check the cash total against the drawer, and check electronic payments against processor reports and bank deposits.

Digital wallets accounted for 17% of US in-store POS value in 2025, compared with a global average of 33%, according to Worldpay.

Suppose a POS reports $2,000 in sales, with $500 paid in cash and $1,500 by card or wallet. The drawer count confirms the cash total, and the processor batch accounts for the electronic payments before each deposit reaches the bank.

Payment gateway reconciliation

An online store records $8,000 in paid orders for the week, but only $7,540 reaches their bank account. The store owner opens the payment gateway or payment service provider settlement report and traces the difference to $240 in refunds, $180 in processing fees, and $40 held in reserve. The remaining $7,540 matches the bank deposit and the net amount posted to the ledger.

Payment gateway reconciliation accounts for the difference between gross sales and the amount deposited. Store owners compare the deductions in each settlement report with their ledger entries, then match the net payout to the bank deposit.

Stores using Shopify Payments can use the payout reconciliation report to review balance activity for a selected period and compare payout totals with bank deposits.

Accounts receivable and payable reconciliation

Accounts receivable reconciliation describes the process of matching customer payments to sales invoices and confirming the balance still due. Accounts payable reconciliation compares supplier invoices and payments with entries in the accounts payable ledger.

A customer might send one $1,500 automated clearing house (ACH) transfer to cover two invoices. The business applies $900 to the first invoice and $600 to the second, closing both invoices and leaving the customer balance at zero.

Billing reconciliation

With billing reconciliation, owners or staff compare a bill or invoice with the contract, purchase order, or usage record behind it, then check the price and quantity before the business pays or collects it.

For example, a software vendor invoices a retailer $900 for 30 user licenses, although the contract lists 25 licenses at $30 each. The retailer confirms the $750 charge and requests a revised invoice before sending it to accounts payable.

Foreign currency reconciliation

Foreign currency reconciliation accounts for exchange-rate changes between the invoice date and payment date. An Italian supplier might invoice a US bakery €10,000 when the euro trades at $1.12, so the bakery records an $11,200 payable.

If the rate falls to $1.09 before payment, settlement costs $10,900, and reconciliation records a $300 foreign exchange gain.

How to reconcile payments

Payment reconciliation typically follows four steps. The work is more complex when banks, processors, and accounting systems use different dates or labels for the same payments.

A processor may also combine dozens of orders into one deposit, which you must trace back to its settlement batch.

Complete these steps to reconcile payments:

1. Records retrieval
2. Matching
3. Reconciliation
4. Finalization

1. Records retrieval

Gather internal transaction records such as invoices, receipts, sales reports, and the general ledger. Collect bank and credit card statements, along with settlement reports or transaction exports from payment processors and gateways.

Different cutoff times can place one payment in two reporting periods. Choose a review period and note any bank or processor report that uses a different cutoff.

2. Matching

Compare each internal transaction with its external record by checking the date, amount, description, currency, and transaction ID. For batch payouts, compare the batch total with the payments listed in the settlement report.

Mark exact matches as cleared and carry unmatched items into the reconciliation step. Automated accounting can compare large sets of transactions and present unmatched entries for review.

3. Reconciliation

Investigate each unmatched entry using the original transaction records. Depending on the item, the review may involve checking a receipt, reading the processor report, or contacting the bank.

Some discrepancies have known causes:

• Chargebacks. A processor reverses all or part of a completed payment after a dispute.
• Failed payments. The order system records the payment attempt, but the processor never completes it.
• Processor fees. The bank receives the payout after deducting the fee from the gross transaction total.

Once you know what caused the discrepancy, correct the amount, account, or payment status in the ledger, and keep the related documents with the adjustment.

4. Finalization

Review every adjustment and confirm that the reconciled balance matches the bank statement or processor report. Post the approved changes to the general ledger.

The final output is a reconciliation report. It records the period reviewed, the source documents used, each discrepancy, and the adjustment made.

For Shopify Payments, the payout reconciliation report breaks down balance activity and payouts for a selected date range. Compare its payout totals with bank deposits and keep the report with the completed reconciliation.

Payment reconciliation example

In this payment reconciliation example, a business’s general ledger shows a month-end balance of $15,500 compared with $14,700 on the bank statement.

Three transactions account for the $800 difference:

• A $1,000 customer deposit was recorded in the ledger and will reach the bank later.
• A $300 vendor check was recorded in the ledger and has not yet cleared the bank.
• A $100 bank service fee appears on the statement and needs to be entered in the ledger.

The timing items adjust the bank balance. The service fee adjusts the ledger balance.

Both adjusted balances equal $15,400. The deposit and check will clear the bank later, and the $100 fee is a permanent ledger adjustment.

Payment reconciliation software and automation

You can complete payment reconciliation manually, with accounting software, or through an automated connection between the store and its ledger. The table below compares each method.

When to automate payment reconciliation

Automation is worth considering when transaction volume makes manual matching difficult to finish on schedule. Reasons for adoption include:

• Single payouts frequently contain dozens or hundreds of orders.
• The store uses several payment gateways, sales channels, or currencies.
• Each month-end close depends on CSV exports and manual journal entries.
• Similar or repetitive payout differences take hours to trace every week or month.

Automation handles routine matching, and an accountant or bookkeeper reviews unmatched entries, mapping rules, and journal entries before closing the period.

Ecommerce reconciliation tools for Shopify

Shopify stores can combine Shopify reports with accounting apps based on their transaction volume and existing accounting system:

• Shopify payout reconciliation report. The payout reconciliation report details Shopify Payments balance activity for a selected period. It covers fees, refunds, chargebacks, adjustments, and payouts. Store owners can compare the payout totals with their bank deposits.
• Shopify finance reports. Finance reports separate sales activity from payment activity. The Payments finance report covers captured payments across payment gateways and shows gross payments, refunds, and net payments. Use these figures alongside the payout reconciliation report to explain timing or total differences.
• Shopify Balance. Shopify Balance keeps account transactions and Shopify Payments payout records in the Shopify admin. View payouts from the Balance account and export transactions for their accounting software.
• Reconcile.ly. Reconcile.ly sends Shopify sales and payout data to Xero or QuickBooks. It can record refunds, taxes, processing fees, and payout summaries, then create entries that match the related bank deposits.
• Bookkeep. Bookkeep posts daily summary journal entries to accounting systems such as QuickBooks Online, NetSuite, Sage Intacct, and Xero. It can also reconcile payouts by order and post sales data by channel, location, or market.

Payment reconciliation best practices

Two practices keep payment reconciliation current:

Set a schedule

Reconcile cash drawers and POS tender totals at the end of each business day. Match processor payouts to bank deposits as they arrive, then complete a full reconciliation of bank and credit card accounts at month-end.

According to the Shopify Survey of Store Owners, Q4 2025*, 69% of store owners review their finances at least weekly.

Formalize the process

Document which records are reviewed, who prepares the reconciliation, and who approves it. A standard operating procedure enforces separation of duties by setting distinct permissions and ensuring different employees handle preparation and approval. Train everyone involved on the process and applicable accounting rules.

*Based on a 2025 survey of 500 Shopify merchants conducted in English across Australia, Canada, the United Kingdom, Ireland, New Zealand, and the United States. Respondents were established merchants with two or more years on the platform. Results reflect the experiences of this specific sample and may not be representative of all merchants.