Small Business Bookkeeping

Why Customer Payments Don’t Always Match Your Bank Deposits

Understand processing fees, grouped payouts, timing differences, refunds, and the steps that help you match customer payments to your bank deposits.

By Michelle MingHighland, MichiganBookkeeping Tips & Guidance

Getting paid should close the loop on a job. When your bank deposit does not match the customer’s payment, that finished job can turn into another round of checking invoices, searching transaction records, and wondering who needs a follow-up.

For a small business owner in Highland, the frustration goes beyond one unexplained amount. It makes the rest of the books harder to trust. At Ming Bookkeeping, I help you follow the money from customer payment to bank deposit so you can understand the difference and take the right next step.

Key Takeaways

  • Fees and refunds can reduce the deposit.
  • One deposit may combine several customer payments.
  • Transfer schedules and holds can delay funds.
  • Match payout details with existing records to avoid counting sales twice.

Why doesn’t the deposit match what customers paid?

Customer payments and bank deposits describe different stages of the same money movement:

  • Invoice: What you billed the customer.
  • Customer payment: What the customer paid.
  • Payout: What a payment processor, such as Stripe or Square, transfers to your bank.
  • Bank deposit: What arrives in your bank account.

A processor can combine payments and deduct charges before sending a payout. Start with the payout details to see which payments and adjustments make up the deposit. Comparing a sales total with a bank total skips the information that connects them. My monthly bookkeeping services in Highland include reconciliation: checking records against statements and explaining differences.

What can change the amount or arrival date?

Processing fees reduce the payout

If your processor takes its fee before transferring money, the deposit will fall below the customer’s payment. Keep the full payment and the fee visible in your records. Intuit’s guidance on merchant service fees explains this distinction.

If the customer paid the full invoice, the processor’s fee does not leave them owing you that fee. Record the payment cost separately instead of reducing the customer’s payment.

Several payments become one deposit

A processor may group payments from different customers into one payout. Comparing that deposit with a single invoice will leave an apparent mismatch. Find the payments within the group, then compare their combined total with the payout breakdown.

The bank description may name your payment processor rather than the customer. Use the payout reference to identify the underlying payments, especially when several customers paid similar amounts.

Payment dates and deposit dates differ

A completed customer payment may reach your bank later. Transfer schedules, daily cut-off times, weekends, and bank holidays can affect arrival. Square’s transfer-matching guidance explains why payments after the cut-off can enter the following transfer.

Refunds, disputes, or holds affect available money

A refund can reduce the balance available for payout. A chargeback involves a customer challenging a card payment through their bank. A processor may also hold funds temporarily in a reserve. Stripe explains these balance changes and holds. Track held money separately from processing fees.

How can $1,000 in payments become an $870 deposit?

Here is a hypothetical payout in US dollars. The fee is illustrative, and no other adjustments apply.

Payout activityAmount
Customer payments in the group$1,000
Refund deducted−$100
Processing fees deducted−$30
Net amount reaching the bank$870

The report explains the $130 difference. A smaller deposit alone does not show that a customer underpaid. The refund might also relate to an earlier sale, so today’s sales total may not explain today’s deposit.

How do you match deposits without counting income twice?

Make two checks: connect customer payments to the processor’s records, then connect the payout to your bank deposit.

  1. Start with the bank entry. Note its amount, posting date, and reference.
  2. Find the payout breakdown. Identify the corresponding transfer in your processor’s records. Use its reference and amount, not the date alone.
  3. Trace the customer payments. Connect each payment to its invoice or sales record. Keep refunds and fees separate.
  4. Check existing entries. Review what your software or payment connection already recorded before adding anything manually.
  5. Match the deposit. Link the bank transaction to the existing deposit record where appropriate. If you already recorded the sale, adding the payout as another sale counts income twice.
  6. Review money still with the processor. Check pending payments and held balances, especially when a payout crosses month-end.

At month-end, a payment can still sit with the processor while you await its bank deposit. Keep a list of payments awaiting transfer and check it against the processor’s closing records, including relevant fees, refunds, and holds. Investigate any unexplained remaining balance.

Intuit’s bank-transaction guidance distinguishes matching an existing transaction from adding a new entry.

Want help keeping customer payments and bank deposits aligned?

Explore Bookkeeping Services

What should you do if the difference remains?

Identify where the payment trail stops:

  • The payment never completed: Check its status before treating it as money available for deposit.
  • The payout has not arrived: Check the expected arrival date and destination account. Contact your processor or bank when it falls outside the stated window.
  • The bank deposit matches the payout, but your books differ: Review missing, duplicated, or incorrectly matched entries.

Keep the relevant invoices, payment references, payout reports, and bank statements together. Note which payments remain unexplained and what you have checked. Those details help the person investigating follow the trail without repeating your work. Avoid an unexplained adjustment simply to make the totals agree.

How can Ming Bookkeeping help keep payment records clear?

With small business monthly bookkeeping in Highland, MI, I help owners maintain organized records and review financial statements. Tell me which payment tools you use and where the figures stop lining up. My getting-started FAQs explain how we discuss software suitability before beginning.

Online monthly bookkeeping services in Highland include account reconciliation, financial statements, and email support. We can discuss how your payment records fit that routine.

FAQs

What if a customer paid only part of an invoice?

Record the amount they actually paid and leave the unpaid balance open, unless you agree on a credit or another adjustment.

What if the payment has no invoice number?

Compare the payer’s details, amount, date, and transaction reference. Ask the customer to confirm which invoice they paid if those records leave uncertainty.

Why can’t I match an instant payout to a specific batch?

Stripe cannot automatically identify the transactions in each instant payout. Use its reconciliation guidance to match the payout against your transaction history.

Will my processor transfer cash payments I record in the app?

Recording cash or checks does not mean the processor collected that money. Square explains this distinction. Trace those payments through your own bank deposits.

Can you review unmatched payments from earlier months?

Tell me which periods need attention. We can discuss the records and scope, including whether catch-up or ongoing bookkeeping fits your situation.

How can I find bookkeeping near me for payment reconciliation?

I work from Highland, Michigan, and support clients remotely. Share your payment setup so we can discuss the bookkeeping help you need.

Let’s Get Started

Make your payment records easier to trust.

Book a free bookkeeping consultation to discuss the recurring work you want to hand over. Bring an example of a deposit you cannot explain so we can discuss where your records need attention.

Book Your Free Bookkeeping Consultation