How to Reconcile Payments: Match Every Transaction to Its Source

Payment reconciliation means confirming that every payment your business received — from every source — is correctly recorded in your books and matches a corresponding bank deposit. It sounds straightforward, but most businesses receive money from multiple channels: bank transfer, Stripe, PayPal, Square, credit card terminals — each with different settlement timing, fees, and CSV formats.

Why Payment Reconciliation Is Harder Than Basic Bank Reconciliation

• Batch settlement — Stripe, PayPal, and Square batch multiple transactions into a single daily deposit, so one bank line represents many individual sales
• Processor fees deducted at source — the deposit you receive is net of fees, but your sales records show the gross amount
• Timing differences — a sale on Monday may not settle until Wednesday or Thursday
• Multiple currencies — international payments may arrive in a different currency than the sale was recorded in
• Refunds and chargebacks — these create negative entries that span multiple days and processors

Step 1: Export Transaction Reports From Every Payment Processor

For each processor you use, export a transaction report (not a payout report) for the reconciliation period. This is the gross transaction level — every individual sale, refund, and fee. Where to find them:

• Stripe: Dashboard → Reports → Balance transactions → Export CSV
• PayPal: Activity → Download → All transactions → CSV
• Square: Reports → Sales summary → Export
• Shopify Payments: Analytics → Reports → Payouts → Export
• Bank transfers / ACH: Bank statement CSV (from your bank's online portal)

Step 2: Export Your Sales and Ledger Records

Export your sales records from your POS system, invoicing software, or accounting package for the same date range. This is what you recorded as income. The goal: every item in this export should match a corresponding item in one of your payment processor exports.

Step 3: Match Payments to Sales Records

For direct payments (bank transfer, ACH), match one-to-one by amount and date. For batch processors (Stripe, PayPal, Square), work at the payout level: find the payout in your bank statement, then verify that the sum of the individual transactions in the processor report equals that payout amount (after fees).

Step 4: Handle Refunds and Chargebacks

Refunds appear as negative transactions in your processor report and reduce the payout for that period. Chargebacks appear as separate debit items, often with a dispute fee. Make sure both are recorded in your ledger — missing chargebacks are one of the most common causes of unresolved payment reconciliation differences.

Step 5: Reconcile Net Deposits to the Bank Statement

After matching at the transaction level, verify at the deposit level: every line in your bank statement marked as a payment processor deposit should tie to a specific settlement in your processor report. Any bank deposit you cannot trace to a processor payout is either an error or an unrecorded income source.

Common Payment Reconciliation Errors and How to Fix Them

• Gross vs net mismatch — your ledger shows the gross sale but the bank received a net amount after fees. Fix: record processor fees as a separate expense line item.
• Settlement timing — a sale on the last day of the month settles in the next month. Fix: treat it as a deposit in transit and carry it forward.
• Duplicate entries — a payment entered manually and also imported via bank feed. Fix: delete the manual entry and keep the imported one.
• Missing refund in ledger — processor issued a refund that was never recorded. Fix: add a credit memo or negative entry in your books.