How to reconcile card deposits with your POS sales
Reconciling card deposits means matching the money that lands in your bank account with the card sales your POS recorded. When you reconcile credit card deposits regularly, you catch missing deposits, unexpected fees, and chargebacks early. The work is mostly lining up dates and explaining the differences, which usually come down to fees, refunds, and settlement timing.
It's not glamorous. But a store that reconciles every week rarely gets surprised by its bank balance.
Why don't deposits match sales exactly?
A few normal reasons explain most gaps.
Timing. Card sales settle when you close your batch, and deposits usually arrive a business day or more later. Friday, Saturday, and Sunday sales may all land on Monday or Tuesday.
Fees. If your processor uses daily discounting, fees come out of each deposit. Your deposit will be a little less than the batch total.
Refunds and voids. A refund reduces the next deposit. A void before settlement removes the sale entirely.
Chargebacks and adjustments. A disputed sale can be pulled from a deposit or debited separately.
Separate tenders. EBT and eWIC transactions may settle and deposit on a different schedule from credit and debit, depending on your setup.
Each of these is explainable. The goal of reconciling is to explain every dollar of difference.
What records do you need?
You need three things for each period.
- Your POS or terminal batch reports, showing card sales by day and batch.
- Your processor statement or online deposit report, showing each deposit and what it covered.
- Your bank statement, showing what actually arrived.
Line them up by date. For each batch, find the matching deposit. Note the batch total, the deposit amount, and the difference.
Here's a hypothetical week. Monday's batch is $900. The deposit on Tuesday is $875. Your processor report shows $25 in fees for that batch. That's reconciled. Tuesday's batch is $1,100, and Wednesday's deposit is $1,020. Fees were $28. That leaves $52 unexplained. You check and find a $52 refund processed Tuesday. Now it's reconciled too.
How often should you reconcile?
Weekly is a good rhythm for most small stores. It's frequent enough to catch problems while they're fresh and not so frequent that it takes over your day.
Daily checks make sense if you have a lot of card volume or have had problems before. Just glance at yesterday's deposit against yesterday's batch.
Monthly is the minimum. When your statement arrives, add up all deposits and compare them with total card sales minus total fees, refunds, and chargebacks. If the numbers don't match, go back week by week until you find the gap.
A simple spreadsheet with columns for date, batch total, deposit, fees, refunds, and difference does the job. When the difference column is zero, you're done.
What should you do when something doesn't match?
Start with the obvious. Check if the deposit simply hasn't arrived yet because of a weekend or holiday. Check for a refund or void you forgot about.
Next, look at the processor's deposit detail. It should break down what was included in each deposit. Sometimes two batches are combined, or one batch is split across two deposits.
If a batch never made it into a deposit, check whether the batch was actually closed. An open batch doesn't settle. Your POS or terminal should show batch status.
If you still can't explain it, contact your processor with the date, batch number, and amount. NRS Pay has live support seven days a week, and the NRS Pay team can help you set up a routine. If you want background on how card disputes affect deposits, Investopedia has a short explainer on the chargeback process.
Because NRS Pay integrates with the NRS POS, your sales and card reports come from connected systems, which makes the batch side of the match easier to pull.
Frequently asked questions
Why is my card deposit missing?
Check whether the batch was closed. An open batch doesn't settle, so no deposit goes out. Also check for weekend or holiday delays, and look at your processor's deposit report to see if that batch was combined with another. If you still can't find it, contact your processor with the batch date and total.
How do I account for fees when reconciling?
If fees come out daily, subtract each day's fees from its batch total and compare that with the deposit. If fees are billed monthly, deposits should match batch totals, and you reconcile the monthly fee debit separately against your statement. Either way, record fees in their own column so you can track them.
Should EBT deposits be reconciled separately?
It's usually easier to keep them separate. EBT and eWIC transactions may follow their own settlement schedule and reports, depending on your setup. Track them in their own rows or sheet, and match them against the EBT totals in your POS. Ask your processor how those deposits appear on your account.