U.S. card acceptance / a statement-first journal
LAUNCH EDITION · 15 NOV 2026
Guides

Read the statement before you read the sales pitch.

A six-pass worksheet for tracing card sales, deductions and the amount that actually reaches your bank.

U.S. / USDPrepared 15 Nov 20262 min read
A six-pass worksheet for tracing card sales, deductions and the amount that actually reaches your bank.

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.

FieldWhy it matters
DescriptionPreserves the processor’s original language
Billable baseIdentifies the dollars or events being charged
Rate / unit priceLets you reproduce the charge
AmountProvides the statement total
Evidence referenceLinks 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.

Saved locally when checked.

Frequently asked questions

Does the site read uploaded statements?
No. The statement tool accepts numbers you enter manually. No statement upload or remote analysis service is implemented.
Why do deposits differ from sales?
The worked example shows how fees, refunds, disputes, reserve movements and settlement timing can create a difference. Reconcile against your own agreement and records.

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