Credit Card Reconciliation: Match Deposits to Sales Every Month
Learn credit card reconciliation for small business: match deposits to sales, explain every fee, refund and chargeback, and catch missing funds.
Photo: Pixabay
On this page 7 sections
- Why Your Deposit Doesn't Match Sales
- Gross vs. Net Settlement: Know Your Funding Type
- Credit Card Reconciliation for Small Business: A Monthly Routine Step by Step
- Accounting for Refunds, Chargebacks, and Reserves
- Syncing Processor Reports With Your Accounting Software
- Red Flags That Signal Errors or Missing Funds
- Next Steps: Make Reconciliation a Routine
Key takeaways
- Deposits rarely equal gross sales. Fees, refunds, chargebacks, reserves and batch timing create predictable gaps you can explain line by line.
- Find out whether you are funded gross (fees billed monthly) or net (fees deducted daily), because it changes what every deposit should look like.
- A monthly routine of POS-to-batch, batch-to-deposit and statement-to-books checks catches errors while they are still easy to fix.
- Record gross sales and fees separately through a clearing account instead of booking net deposits as revenue.
The problem usually shows up the same way. The POS says you sold one amount, and the bank shows a smaller deposit on a different day. Credit card reconciliation for small business is the monthly habit of explaining that gap, line by line, until every dollar of card sales is either in your bank account or accounted for. This guide covers why deposits differ from sales, how your funding type changes the math, and a step-by-step monthly routine. It also covers how to handle refunds, chargebacks and reserves, how to sync reports with your accounting software, and which red flags mean money may be missing.
Why Your Deposit Doesn't Match Sales
A deposit that doesn't match sales is not automatically an error. What matters is whether you can explain the difference. These are the usual causes:
- Batch timing. Sales count on the day they happen, but they fund only after the batch closes and settles. Batch cutoff times, weekends and bank holidays can push deposits back by a day or more. Our guide to how batch timing, weekends and holidays affect deposits covers the details.
- Processing fees. Fees come out either daily or monthly, depending on your funding type.
- Refunds and voids. A refund reduces the batch it settles in, not the day of the original sale.
- Chargebacks. Disputed amounts, and often a chargeback fee, are debited from deposits or from your bank account.
- Reserves and holds. Your processor may hold back part of your funds under your agreement or during a risk review.
- Non-card tenders. Your POS sales total includes cash, checks, gift cards and house accounts. None of those flow through card deposits.
- Separately funded cards. If you accept American Express through a direct agreement rather than through your processor, those funds typically arrive as a separate deposit.
- Multiple locations or merchant IDs. Each merchant ID (MID) usually funds on its own, sometimes into a different bank account.
Each industry adds its own wrinkles. Restaurants and bars adjust tips after authorization, and late-night tabs can close after the batch cutoff. Hotels authorize cards at check-in and settle the final folio at checkout, so a multi-night stay funds days after the guest arrived. E-commerce stores may capture payment when an order ships rather than when it is placed. Retailers often process exchanges as a refund plus a new sale. If you run a restaurant or bar, see our guide on whether you can deduct credit card fees from employee tips.
Gross vs. Net Settlement: Know Your Funding Type
Before you reconcile anything, find out how your processor funds you. Your merchant agreement or monthly statement should say. If it doesn't, ask your provider.
| Gross Funding | Net Funding | |
|---|---|---|
| What arrives daily | The full batch amount, minus refunds and chargebacks | The batch amount minus that day's processing fees |
| When fees are taken | Usually one debit early the following month | Every day, built into each deposit |
| Reconciliation upside | Daily deposits are easy to match to batches | Monthly statement fees should already be paid |
| Common pitfall | Forgetting the large monthly fee debit | Booking net deposits as sales, which understates both revenue and fees |
Your pricing model matters too. With flat-rate pricing, you can roughly predict each day's fees. With interchange-plus, fees vary by card type and transaction, so you reconcile against the statement rather than a simple percentage. If you're not sure which model you're on, read our comparison of interchange-plus vs. flat-rate pricing.
Pricing programs also change what "sales" means. Under a dual pricing program or a cash discount program, the card price includes a non-cash adjustment. Your POS should record that adjustment as a separate line so your sales reports and deposits tie out. Surcharging rules vary by state and card network, so confirm current requirements before you turn it on.
Credit Card Reconciliation for Small Business: A Monthly Routine Step by Step
Run this routine at month-end. If you have time, do the first two steps daily or weekly. Small gaps are much easier to trace while they're only a few days old.
Step 1: Gather Your Reports
Pull these five documents for the same date range:
- POS or sales report by day, broken out by tender type
- Batch or settlement reports from your terminal, POS or gateway
- Processor funding (deposit) report showing which batches made up each deposit
- Monthly merchant statement
- Bank statement for the account that receives card deposits
Step 2: Do a Batch Reconciliation
Compare each day's card tender total in your POS to that day's batch total. They should match exactly. If they don't, check these causes:
- Tips added or adjusted after the batch closed (common in restaurants and bars)
- Voids done in the POS but not on a standalone terminal, or the reverse
- Offline or stored transactions that haven't uploaded yet
- A batch that never closed, which can happen when a terminal is left open over a weekend
Step 3: Reconcile Merchant Deposits to Batches
Use the funding report to match each bank deposit to the batch or batches it contains. Friday, Saturday and Sunday batches often arrive together as one Monday or Tuesday deposit. Mark each deposit as matched. If a batch has no matching deposit, flag it.
Step 4: Build a Bridge for Each Gap
For any deposit that differs from its batch, list every adjustment. The example below is for a net-funded merchant, and the numbers are illustrative only.
| Line Item (Illustrative) | Amount |
|---|---|
| Gross card sales in batch | $4,850.00 |
| Refunds settled in same batch | −$120.00 |
| Net batch total | $4,730.00 |
| Daily processing fees (net funding) | −$137.17 |
| Chargeback debit | −$65.00 |
| Expected deposit | $4,527.83 |
If the bank shows $4,527.83, that deposit is reconciled. If it doesn't, whatever difference remains is what you investigate.
Step 5: Complete Your Merchant Statement Reconciliation
Once the month closes, tie the statement to your books:
- Total sales on the statement should equal your batch totals for the month.
- Total fees should equal the daily fee deductions (net funding) or the monthly fee debit (gross funding).
- Separate debits for equipment leases, gateway fees or monthly service fees should each appear on the statement or in your contract.
Step 6: Post Entries and Carry Open Items Forward
Record the month's gross sales, fees, refunds and chargebacks. Note any open items, such as an unfunded batch or a pending dispute, and carry them forward so they get resolved next month instead of forgotten.
Accounting for Refunds, Chargebacks, and Reserves
These three items are frequent sources of confusion, and each one needs its own tracking.
Refunds
A refund reduces the batch it settles in, which may be days or weeks after the original sale. Retailers with return windows and e-commerce stores that refund once a return arrives see this constantly. If refunds in a batch exceed sales, which can happen on a slow day after a holiday return rush, the processor may debit your bank account for the difference.
Chargebacks
When a cardholder disputes a charge, the amount is usually debited right away. A chargeback fee may also apply under your agreement. If you win the dispute, the funds come back as a separate credit, sometimes weeks later. Track each case by its reference number so you can match the original debit to any reversal. For the full timeline, see how the chargeback dispute lifecycle works.
Reserves and Holds
A reserve is money your processor holds back to cover future refunds or chargebacks. Common structures include:
- A rolling reserve: a percentage of each batch held for a set period, then released
- An upfront reserve: a fixed amount held at the start of the relationship
- A capped reserve: funds collected until they reach a set amount
Reserved funds are still your money. Record them as an asset (a receivable from the processor), not as an expense, and track the expected release dates.
Separate from reserves, processors may temporarily hold funds during a risk review. Large tickets or sudden volume jumps, such as a hotel's peak season or a retailer's holiday weekend, can trigger one. It helps to warn your processor before a sales spike. If you're weighing financing for cash flow gaps, see our comparison of business line of credit vs. term loan.
Hotels and bars should also keep authorization holds apart from settled sales. A pre-authorization at check-in or on an open tab isn't revenue and doesn't fund. Only the final captured amount does. Our guide to credit card authorization holds and how long they last explains how they work.
Syncing Processor Reports With Your Accounting Software
A common bookkeeping mistake is recording each bank deposit as "sales." That understates revenue, hides your true processing costs and makes refunds and chargebacks invisible.
A cleaner approach uses a card clearing account:
- Record daily gross card sales from your POS in the clearing account.
- Record fees, refunds and chargebacks against the clearing account, and map fees to a processing expense account.
- Match each bank deposit against the clearing account.
- At month-end, the clearing balance should equal unfunded batches plus reserves. Investigate anything else that remains.
Some industries need extra steps:
- E-commerce stores: Your gateway report and your processor's funding report are different documents. Reconcile orders to the gateway, then the gateway to deposits. Watch time zones, because your store's "day" may not match the processor's batch day.
- Hotels: Reconcile property management system (PMS) folios to settled card transactions, not to authorizations.
- Restaurants and bars: Reconcile tip totals to payroll so that card tips paid out in cash or through payroll are fully accounted for.
- Multi-location retailers: Reconcile each MID separately before consolidating.
Integrations help. MannyPay supports a QuickBooks integration among its accounting and e-commerce connections, which can reduce manual data entry. Even with an integration, review the account mappings so fees and refunds land in the right accounts. This is general bookkeeping information, not tax or accounting advice. Confirm your chart of accounts and revenue recognition approach with a qualified accountant or CPA.
Red Flags That Signal Errors or Missing Funds
A gap often has an ordinary explanation. Even so, contact your processor promptly if you see any of the following:
- A batch with no deposit after your normal funding window, allowing for weekend or holiday delays
- Fees you don't recognize or that don't appear in your agreement
- A sudden jump in effective cost with no change in your sales mix
- Duplicate transactions in a batch, often from re-running a card after a timeout
- Chargeback debits without a dispute notice from your processor
- Reserve releases that don't happen on the schedule in your agreement
- Deposits going to an unfamiliar bank account. This can mean someone changed your banking details through social engineering. Our article on social engineering lessons for merchants explains how these schemes work.
- Statement totals that don't match your batch reports for the month
Keep a simple log of each issue: the date you found it, the amount, who you contacted and how it was resolved. It speeds up follow-up and gives your accountant a clear audit trail.
Next Steps: Make Reconciliation a Routine
Start small. This week, confirm whether you're funded gross or net and pull last month's statement. Next month, run the full routine and build a bridge for every deposit that doesn't match. After a few cycles, the routine usually gets faster as you learn your own patterns.
If your statements are hard to read or your reports don't line up cleanly, ask your provider for better reporting. It may also be time to compare options, and our list of questions to ask a merchant service provider is a good place to begin. To review MannyPay's payment processing solutions, request a free quote and a MannyPay specialist will respond within one business day.
This article is for general educational purposes and is not legal, tax or financial advice. Card network rules and state laws change; confirm current requirements for your business.
