Payment Processing Discrepancies: Why Recorded Sales Do Not Match Deposits

Why Recorded Sales Do Not Match Bank Deposits

If you accept electronic payments—credit cards, debit cards, ACH, digital wallets—your payment processor deposits money into your bank account. But the deposit amount rarely matches the total sales you recorded. The difference is not necessarily revenue leakage, but it can hide leakage if you do not understand and reconcile it.

This guide explains why payment processing discrepancies occur, what they mean, and how to reconcile your processor settlements against your recorded sales.

What Causes Payment Processing Discrepancies?

1. Processing Fees

Every time a customer pays by credit card, the payment processor deducts a fee. The fee is typically 2-4% of the transaction amount plus a fixed per-transaction fee (e.g., $0.30). The deposit you receive is the gross sales amount minus the processing fee.

If you record the full sale amount as revenue but do not account for the processing fee as an expense, your revenue will appear higher than your actual cash collected. This is not leakage—it is a legitimate cost of doing business—but it creates a discrepancy between recorded sales and deposits.

2. Chargebacks

A chargeback occurs when a customer disputes a charge with their bank, and the bank reverses the transaction. The processor deducts the chargeback amount from your deposit, along with a chargeback fee.

If you do not record chargebacks in your accounting system, your recorded sales will be higher than your deposits. Chargebacks that are not investigated may also indicate billing errors or fraud.

3. Holds and Reserves

Some processors hold a percentage of your deposits as a rolling reserve—typically 5-10% held for 90-180 days to protect against chargebacks. The held amount is not deposited until the hold period expires.

If you do not account for the reserve hold, your deposits will be lower than your recorded sales by the reserve amount. The reserve is not lost—it will be released later—but it creates a timing discrepancy.

4. Settlement Timing

Payment processors typically deposit funds on a delayed schedule—1-3 business days for credit cards, 3-5 days for ACH. Sales recorded at the end of a period may not be deposited until the next period. This creates a timing discrepancy that resolves in the next period.

5. Refunds and Returns

When you issue a refund, the processor returns the money to the customer and deducts the refund amount from your next deposit. If refunds are not recorded in your accounting system, your recorded sales will be higher than your deposits.

6. Foreign Currency Conversion

If you accept payments in foreign currencies, the processor converts the currency before depositing. The exchange rate used by the processor may differ from the rate you used to record the sale. The difference is a currency conversion discrepancy.

7. Processor Errors

Occasionally, processors make errors—duplicate deposits, missed deposits, or incorrect fee calculations. These errors are rare but do occur. Without reconciliation, they can go undetected.

How to Reconcile Payment Processing

Step 1: Pull the Settlement Report

Log into your payment processor's dashboard and download the settlement report for the period you are reconciling. The report should show:

• Gross sales volume
• Processing fees
• Chargebacks
• Refunds
• Reserve holds
• Net deposit amount

Step 2: Compare to Recorded Sales

Compare the gross sales volume on the settlement report to the sales recorded in your accounting system. If they do not match, investigate:

• Are there sales in your system that the processor does not show? (This may indicate a processing error or a sale that was recorded but not actually charged.)
• Are there sales on the processor report that your system does not show? (This may indicate a sale that was processed but not recorded in your accounting system.)

Step 3: Verify Fees

Compare the processing fees on the settlement report to the fees recorded in your accounting system. If the fees are not recorded, your expenses are understated and your net income is overstated.

Step 4: Track Chargebacks

Review the chargebacks on the settlement report. For each chargeback:

• Was the chargeback recorded in your accounting system?
• Was the original sale valid, or was it a billing error?
• Is the chargeback being disputed?

Unusual chargeback patterns—high rates, concentrated on certain products—may indicate billing errors or fraud. See our guide to revenue loss versus fraud.

Step 5: Reconcile the Deposit

Compare the net deposit amount on the settlement report to the actual deposit in your bank account. If they do not match, contact the processor to investigate.

Key Formulas

Processing Fee Rate = Total Processing Fees ÷ Gross Sales Volume × 100

Chargeback Rate = Number of Chargebacks ÷ Total Transactions × 100

A chargeback rate above 1% is considered high and may indicate billing disputes or fraud.

Net Deposit Rate = Net Deposit ÷ Gross Sales × 100

This shows what percentage of your gross sales actually reaches your bank account after all deductions.

Unreconciled Difference = Recorded Sales − Bank Deposits − Processing Fees − Chargebacks − Refunds − Reserve Holds

If the unreconciled difference is not zero, investigate further.

Distinguishing Legitimate Costs from Leakage

Not every payment processing discrepancy is leakage. The following are legitimate costs of doing business:

• Processing fees: A legitimate cost of accepting electronic payments.
• Chargebacks from valid disputes: A legitimate cost of customer disputes.
• Reserve holds: A timing difference, not a loss.
• Refunds for returned goods: A legitimate business transaction.

Payment processing leakage occurs when:

• Chargebacks are caused by billing errors: If a customer chargebacks a charge because the invoice was wrong, the chargeback is a symptom of a billing process failure.
• Processor errors go undetected: If the processor deducts fees incorrectly or misses a deposit, the error is leakage if not caught.
• Refunds are issued for overbilling: If you refund a customer because you overcharged them, the original overbilling was an error and the refund is a correction—but the net effect is still lost revenue.

Prevention

1. Reconcile Monthly

Reconcile your processor settlements to your bank deposits and accounting records monthly. Do not let discrepancies accumulate.

2. Record Processing Fees

Record processing fees as an expense in your accounting system. Do not net them against revenue—this distorts your revenue figure and makes it harder to track the true cost of payment processing.

3. Track Chargebacks

Track chargeback rates by product and customer. Investigate unusual chargeback patterns—they may indicate billing errors or fraud.

4. Monitor Fee Structures

Review your processor's fee structure annually. Processors may change their rates or add new fees. If your fee rate is increasing, negotiate or switch processors.

5. Automate Reconciliation

Use accounting software that integrates with your payment processor. Automated reconciliation catches discrepancies faster than manual reconciliation.

Related Topics

• Revenue reconciliation: How to compare sales, invoices, and payments
• Unpaid invoices: How to find and recover outstanding receivables
• Accounting errors: How general ledger mistakes hide lost revenue
• Revenue recovery software: Tools for automating reconciliation

When Software May Help

Payment reconciliation software can:

• Automatically import settlement reports from your processor
• Match transactions to bank deposits
• Flag unreconciled differences
• Track processing fees and chargeback rates
• Categorize discrepancies by type

For businesses processing more than a few hundred transactions per month, reconciliation software can save significant time and catch discrepancies earlier. See our guide to revenue recovery software.

Summary

Payment processing discrepancies occur because processors deduct fees, process chargebacks, hold reserves, and operate on delayed settlement schedules. Reconciling your processor settlements to your bank deposits and accounting records is essential for distinguishing legitimate costs from actual revenue leakage.

The key is to reconcile monthly, record processing fees as expenses, track chargeback rates, and monitor fee structures. If your recorded sales consistently exceed your deposits by more than the total of fees, chargebacks, and reserves, investigate further—the difference may represent leakage.

The Recoupant revenue assessment can help you identify whether payment processing discrepancies may be hiding revenue leakage.

Frequently Asked Questions

Why do my sales not match my bank deposits? Payment processors deduct fees, process chargebacks, hold reserves, and operate on delayed settlement schedules. The deposit you receive is the gross sales amount minus all deductions. The difference between your sales and your deposits is the sum of all processor deductions.

What is a chargeback? A chargeback is when a customer disputes a charge with their bank, and the bank reverses the transaction. The processor deducts the chargeback amount from your deposit, along with a chargeback fee. High chargeback rates may indicate billing errors or fraud.

What is a rolling reserve? A rolling reserve is when a payment processor holds a percentage of your deposits for a defined period (typically 90-180 days) to protect against chargebacks. The held amount is released after the hold period expires. It is a timing difference, not a loss.

How do I reconcile payment processing? Pull the settlement report from your processor, compare the gross sales to your recorded sales, verify that fees are recorded as expenses, track chargebacks, and reconcile the net deposit to your bank account. Do this monthly.

What is a normal processing fee rate? Processing fees typically range from 2-4% of the transaction amount plus a fixed per-transaction fee. The exact rate depends on your processor, transaction volume, and average transaction size. If your fee rate is above 4%, consider negotiating or switching processors.