Payment reconciliation: how to match card deposits to sales

Payment reconciliation is the routine of proving that what you sold matches what you were paid. For card payments, it ties your sales report to your processor's batch and deposit reports and to your bank statement, then checks the month against your merchant statement. When they agree, every sale has been paid. When they don't, the gap tells you something: a batch that never closed, a fee you didn't expect, a chargeback, a reserve, or a deposit that's simply still on its way.

Card deposits rarely equal card sales, which is why reconciliation trips people up. This guide explains what causes the gaps, works through a week of deposits with every number checked, and ends with a monthly checklist. It also covers online payment reconciliation, where authorizations, captures and payment links add steps of their own.

What does payment reconciliation involve?

It means following each sale through every record that should show it. Four documents do the work:

A $64.20 card sale on Tuesday afternoon should appear in Tuesday's sales report, in Tuesday's batch, in the deposit that follows, and in the month's totals on the merchant statement. Reconciliation is checking that it does, for every sale, and explaining the ones that don't. Our guide to batch settlement covers the batch step if it's new to you.

Why don't card deposits match card sales?

Because several things happen between the sale and the deposit, and each one changes either the amount or the date.

Timing gaps are the harmless kind. A batch that closes after your processor's cutoff joins the next funding cycle. A late batch can also cost more, since Mastercard lists the time between authorization and clearing among the requirements its interchange rates depend on (Mastercard).

Bank holidays stretch the gap. On the Federal Reserve Financial Services holiday schedule, Columbus Day falls on Monday, October 12, 2026, so on a next-day funding schedule, Friday's and the weekend's card sales land together on Tuesday. Our guide on how long card payments take walks through each stage of that timing.

How do you reconcile card payments, step by step?

Do the matching daily or weekly while the details are fresh, then close the month against your statement.

1. Close the day in your POS and note card sales, refunds and tips.
2. Pull the batch report for each terminal and for your online gateway, for the same day.
3. Match the two. Differences usually come from voided sales, tips adjusted after approval, offline sales still waiting to go out, or a terminal that didn't batch.
4. Find each batch's deposit in your processor's funding report and on your bank statement.
5. Explain every difference between a batch and its deposit: fees, refunds, chargebacks, reserves.
6. Record sales at their gross amount and fees as an expense, rather than booking the deposit as the sale.
7. Put anything you can't explain on a short list, and ask your processor about it that week.

Step 6 matters more than it looks. Booking deposits as sales understates both your revenue and your fees, and your books won't match your tax forms. For Form 1099-K income, the IRS tells self-employed sellers to report the full gross amount on Schedule C and then make the appropriate offsets (IRS). Your accountant will confirm how your books should show it.

A worked example: one week of card deposits

Here's a made-up week for a garden center in Richmond. Its processor funds the next business day and takes fees out of each deposit. Monday, October 12 is a Federal Reserve holiday, so the batches from Friday, Saturday and Sunday all arrive on Tuesday.

Now tie the week together:

Every dollar is accounted for. Three lines deserve a closer look:

• The $89.00 chargeback isn't from this week. It's an August sale a customer disputed, so record it against that sale and its dispute, not against Wednesday's takings.
• The $14,852.45 from Friday through Sunday wasn't late. It was in transit over a weekend and a holiday. The same thing happens at month end, when the last days' sales land on the next month's bank statement, so list them as deposits in transit instead of hunting for missing money.
• Fees came to $600.40 on $27,776.00 of net card sales, about 2.16%. Track that rate monthly. A jump with no change in your card mix is worth a call to your processor.

If the processor billed fees monthly instead, each deposit would equal its net batch apart from the chargeback and its fee, and the week's $600.40 would leave as part of one fee debit early the next month. Same money, different dates.

How do refunds, chargebacks and reserves show up?

Each one moves money on its own schedule, so each needs its own list.

Refunds

A refund goes out in the batch where you process it, so it lowers that day's deposit rather than the original sale's. Match each refund to its original sale and check that the amount and card agree. Ask your processor whether any of the original fee comes back on a refund, because that changes your numbers. A sale voided before the batch closes never reaches a deposit at all; our guide to void vs refund explains the difference.

Chargebacks

A chargeback takes the money back, usually with a fee, and it often arrives long after the sale. Under Regulation Z, a cardholder can send a billing-error notice to the card issuer within 60 days after the first statement that shows the problem (CFPB), and Mastercard says the whole chargeback process can take up to 120 days (Mastercard). If you win, the money comes back as a separate credit. Keep a running list of open disputes and tick off each reversal when it lands. Our guide to chargebacks vs refunds covers how each one moves money.

Reserves and holds

A reserve holds back part of your deposits for a period. The OCC's handbook names delayed settlement and reserves among the tools acquirers use with merchants that carry more fraud or chargeback risk (OCC). If you're on one, track the amounts held and released like a separate account. Otherwise every deposit looks short for months and nobody can say why. Our guide to the rolling reserve shows the math.

What should a monthly reconciliation checklist include?

Once a month, close the books on card payments with this list:

1. Card sales in your POS match the batch totals for every day of the month.
2. Every batch has a matching deposit, and you know the date each one arrived.
3. Deposits still in transit at month end are listed, with the date they landed.
4. If fees come out daily, the month's deductions add up to the statement's total fees. If they're billed monthly, the fee debit matches the statement.
5. Every refund matches an original sale.
6. Every chargeback is on your dispute list, with its status and any reversal.
7. The reserve balance held, released and outstanding agrees with the statement.
8. Every online payment captured in your gateway appears in a batch, and authorizations you never captured have been released.
9. Every invoice paid by card or payment link is marked paid against the right invoice.
10. Your effective rate, total fees divided by card sales, is in line with recent months.
11. Anything unexplained is on a list, with a question for your processor.
12. The month's statements and reports are saved where your accountant can find them.

Once a year, add one more check. Form 1099-K reports the gross amount of your card sales, before fees or refunds (IRS), so compare it with your gross card sales for the year, month by month. Our Form 1099-K guide shows how to explain the gap between the form and your deposits.

How does an interchange-plus statement make reconciliation easier?

Reconciliation answers one question: did I get all my money? A good statement also answers a second one: was I charged the right amount? Interchange-plus pricing is what makes the second question answerable.

On interchange-plus, each interchange category gets its own line with a count, a volume and a rate, network fees are listed separately, and your processor's markup sits on its own line. You can recalculate any line yourself. On Visa's schedule effective April 18, 2026, a standard consumer credit card in the "all other products" group, dipped or tapped in a store, carries 1.51% + $0.10 (Visa). If your statement shows 120 of those sales totaling $7,800, the interchange should be $117.78 plus $12.00, or $129.78.

Our guide on how to read a merchant statement shows where each section usually sits. Canada adds a rule of its own. The Code of Conduct for the Payment Card Industry requires statements, at least monthly, that show the rates and totals for interchange, network assessment fees and all other fees, plus the effective merchant discount rate for each card type (FCAC). That makes the same line-by-line check possible for merchants across Canada.

On our interchange-plus pricing, each of those layers is its own line, so you can reconcile and audit from the same statement.

How does online payment reconciliation work?

Online sales add steps between the order and the batch, so match on order and invoice numbers, not just totals.

• Authorization isn't capture. Many stores authorize at checkout and capture when the order ships, and Visa's dispute guidance tells card-absent merchants not to deposit a transaction until the merchandise ships (Visa). An order placed on the 30th can be captured, batched and deposited the following month.
• Partial shipments create partial captures, so one order can show up in two batches.
• Payment links and emailed invoices are easiest to match when the invoice number is in the payment description. Our guide to payment links covers setting that up.
• Recurring charges that decline never reach a batch, so reconcile the billing run's report, not only the deposits.
• Your gateway shows orders, and your processor shows funding. Reconcile gateway to batch, then batch to deposit.

Clearo's online payments and virtual terminal handle the card side of these sales, and your dedicated rep can help you set up a matching routine that fits how you sell. For deposit timing, our payment processing page covers the same-day and next-day funding options.

Common reconciliation mistakes

• Booking deposits as sales, which understates revenue and hides fees.
• Treating a weekend or holiday gap as a missing deposit.
• Matching a refund to the day of the original sale instead of the day it was processed.
• Forgetting to record chargeback reversals when you win.
• Ignoring the reserve line on the statement.
• Re-sending a batch that may already have gone through, which can charge customers twice.
• Leaving reconciliation until year end, when the details are gone.

Next step

If your deposits never quite line up, or your statement doesn't give you enough detail to check, send a recent one for a free statement review. We'll trace where each fee and deduction came from and show what the same month would look like on interchange-plus pricing. Or contact us to ask about funding schedules and reporting.