The short answer
To reconcile card payments, match your processor’s payout reference to the bank deposit, then explain that payout using its included transactions and adjustments. Compare the same account, currency and reporting period. A sales total and a bank deposit can differ without money being missing.
Start with three records, not one total
Set aside a quiet block of time with three records: your sales or point-of-sale report, the processor’s settlement or payout detail, and the bank’s posted transactions. Give the worksheet a reporting date and identify who reviewed it. Your goal is a traceable path from an order to a payout to a bank entry.
As a provider-specific example, Adyen’s batch guidance uses a batch number to group settlement entries; a batch can include several sales dates, payment methods or currencies. Your provider may use different report names and grouping rules. Ask which report explains the actual amount sent to your bank.
Record the report’s time zone and cutoff. Keep gross sales, refunds and payout totals in separate columns. Combining everything into one number can hide a timing difference or cause you to subtract a refund twice.
Build a matching worksheet
Use one row per payout and add supporting detail only when needed. A practical worksheet has these columns:
- Scope: business location, merchant account, currency and covered dates.
- Processor reference: batch or payout ID, status, expected amount and date sent.
- Bank match: posting date, reference and amount actually received.
- Difference: expected amount minus received amount, with an explanation.
- Follow-up: supporting report, person responsible and next review date.
Start with the provider reference. Amount alone is weak evidence when two deposits happen to be identical. If a bank entry combines several payouts, list the component IDs; if one payout is split, list each bank entry. Mark a match complete only when the pieces add up and the account is correct.
Do not treat an authorized sale as proof that a deposit has been sent. Use the actual status in the provider’s report and its explanation of that status.
Work through a fictional payout
Assume a fictional shop uses net settlement, so the fees shown below are deducted from this payout. Its report includes two groups of settled sales totaling $1,750. A $50 refund, $49.50 in fees and a $100 reserve withholding are also included. There are no other adjustments.
| Included item | Effect on payout |
|---|---|
| First sales group | +$1,000.00 |
| Second sales group | +$750.00 |
| Refund | −$50.00 |
| Fees deducted | −$49.50 |
| Reserve withheld | −$100.00 |
| Expected bank deposit | $1,550.50 |
The calculation is $1,750 − $50 − $49.50 − $100 = $1,550.50. If the bank shows that amount with the matching reference, the payout reconciles. The $199.50 difference from sales is explained; it is not all a processing fee. A reserve withholding belongs in a separate reconciliation category, with accounting treatment confirmed by your bookkeeper.
If your provider instead deducts monthly fees separately, do not subtract those fees from every daily payout. This example is arithmetic, not a claim about any provider’s pricing or reserve policy.
Investigate differences in a consistent order
First check scope: wrong account, wrong currency, a cutoff mismatch or an unsettled item. Next inspect the payout’s detail for refunds, disputes, fees, withheld amounts and adjustments. Adyen’s settlement report documentation, for example, separates transaction entries, fees, reserve adjustments, invoice deductions and merchant payouts. Those labels illustrate why every deduction should not be grouped under “fees.”
Then inspect the bank side for separate deposits or debits. A transaction posted after your reporting window may be a timing item. Carry it forward with its reference and expected follow-up date rather than changing the sales figure to force a match.
If the difference remains unexplained, preserve the original exports. Write a specific question: “Payout reference X shows $1,550.50 sent; our bank entry shows $1,500.50. Which entry explains $50?” A focused question is easier to investigate than a whole month of unlabeled screenshots.
Close the loop before next month
Keep an unresolved-items list with the amount, age, evidence and next action. Review it regularly so an old missing deposit does not disappear inside the next month’s totals. When an item clears, record where it cleared and retain the link to the original row.
For repeat problems, improve the routine: use the same report settings, save the cutoff definition, and agree who reviews refunds and adjustments. Reconciliation quality comes from consistent records and resolved exceptions, not from making two unrelated totals look equal.
Prepare a useful statement-review question
If confusing statement or payout labels are part of the problem, request a merchant-services conversation. Start with basic business and contact information; ask the team for its approved document-sharing process before providing financial records.
Opulent Lending receives your inquiry and coordinates an introduction to Green Payment Solutions. Payment-processing proposals, approval, onboarding and service are handled by GPS and the applicable provider. A review does not guarantee savings or a particular funding schedule.
Frequently asked questions
Should every day’s card sales equal one bank deposit?
No. The provider’s cutoff, settlement grouping, refunds and other adjustments can make the amounts or dates differ. Reconcile using the payout detail and bank reference, not a same-day assumption.
Is a reserve withholding a processing fee?
Do not automatically classify it that way. Track withheld and released reserve amounts separately and confirm their treatment with your provider and bookkeeper.
What should I give support when a deposit does not match?
Provide the payout reference, relevant dates, expected amount, actual posted amount and the unexplained difference through the provider’s approved support channel. Avoid sending unneeded customer payment data.
Sources and further reading
Original sources used to prepare this guide. Provider terms and network requirements can change; check the linked source and your applicable agreement.
- Adyen: Batch-level reconciliation (opens in a new tab)↗docs.adyen.com
- Adyen: Settlement details report (opens in a new tab)↗docs.adyen.com
About this guide. Prepared by Opulent Lending for general merchant education. Opulent receives inquiries and coordinates introductions to Green Payment Solutions. It does not promise a particular rate, approval or savings.
Read our editorial policy. For a correction, email support@opulentlending.com with the page link and the issue.
