Pass 1: establish the boundary
Write the merchant account identifier, currency and exact start and end dates at the top of your working copy. A calendar-month statement and a settlement export cut at a different time are not interchangeable. Do not store card numbers in the worksheet.
Retain the original statement and annotate a copy. Use page and line references so another person can reproduce every total. If there are multiple locations, separate them before combining the results.
Pass 2: reconcile the sales activity
Begin with gross captured sales, then record refunds and disputes as separate movements. A bank deposit is not a sales total. In a fictional period with $50,000 sales, $1,200 refunds, $100 dispute principal, $1,380 fees and a $500 reserve hold, the expected available payout is $46,820, assuming all movements belong to that settlement period.
A timing difference is not automatically a missing payment. Build an opening balance + activity − payouts = closing balance bridge. Carry unmatched amounts forward with a reason and a date rather than forcing the worksheet to zero.
Pass 3: reconstruct fee lines
For each line, copy the description, billable base, units, rate and amount. Recalculate rate × base or event count × unit charge. Keep a separate column for unexplained differences. Small rounding differences and material contractual differences deserve different responses.
| Field | Why it matters |
|---|---|
| Description | Preserves the processor’s original language |
| Billable base | Identifies the dollars or events being charged |
| Rate / unit price | Lets you reproduce the charge |
| Amount | Provides the statement total |
| Evidence reference | Links the line to a contract or explanation |
Pass 4: look outside the statement
A gateway, software subscription or leased terminal may be billed elsewhere. Add only charges relevant to the comparison. A business-wide inventory application should not silently become a card-processing fee merely because the same vendor supplies it.
The audit tool uses manual entry. It does not upload or parse your statement, and it cannot determine whether a charge is lawful. That narrow scope keeps the arithmetic visible and your documents out of an unconfigured backend.
Pass 5: normalize recurring costs
Put monthly charges in one bucket, annual charges in another and one-time items in a third. Allocate annual amounts over twelve months only when that is the comparison you intend. Keep onboarding or cancellation costs visible in a first-year view, not hidden in an ongoing monthly average.
Pass 6: send questions with evidence
Replace “your fees are too high” with a precise query: “Page 3, line 14 shows 1,250 authorization events at 6¢. Our export shows 1,000 successful payments. Please explain the event definition and provide the matching activity report.” The processor may have a valid explanation; the worksheet gives you a way to test it.
Frequently asked questions
Does the site read uploaded statements?
Why do deposits differ from sales?
Check the source.
Sources consulted for this edition. Public prices are not personalized quotes; a source’s original date and its retrieval date are separate.
Visa · merchant pricing and interchange ↗Mastercard · interchange explained ↗Checked 2026-11-15 · Read the methodology