Distinct-fee inclusion ledger
Create an inclusion ledger for distinct assessed charges across summaries, detail and bank withdrawals.
No signup. Enter reference codes, add records and download a CSV. Entries stay in the browser tab. Filled fields do not establish completion, approval or compliance.
| Fee reference | Detail amount | Summary location | Already deducted? | Include once where? | Unresolved question |
|---|---|---|---|---|---|
| Fee-demo-03 | $45 | Monthly summary line | Verify payout treatment | Include in assessed fee total once | Check whether bank debit repeats summary |
- Use one row for each item described in the article.
- Record the source, unresolved difference and next action before marking an item complete.
- Review the actual business records separately. This worksheet does not connect to accounts or change your records.
A processing statement often repeats the same dollars in several useful views. One page breaks down fees, another totals charges, and a payout report shows cash deductions. Add every number and you might count a cost twice. Before you use an analyzer, make a short list of distinct fees to include. You want the full cost actually charged, not the biggest total you can pull from the paperwork.
Use with this guide
merchant statement analyzer
Review the scope of merchant statement analyzer.
Books bookkeeping workspace
Review the scope of Books bookkeeping workspace.
Auto Body Shop Effective Processing Rate Audit
Work out how the advertised rate compares with the full card-processing bill.
Check your own costs: calculate your effective processing rate or upload a merchant statement for analysis.
Identify summaries before adding lines
Read the headings and subtotal labels. A discount-fee summary may include the line items beneath it, and total fees may already include monthly service charges. Treat each subtotal as a summary, not another separate charge. If it’s unclear, ask the processor to explain. Don’t assume repeated numbers mean extra costs.
The merchant statement analyzer lets you edit figures, so you’re still responsible for checking what each input means. Automated reading can spot text and amounts without fully understanding every statement layout. Compare the extracted total against the document’s structure, and keep a reference to the pages you used. A correct calculation won’t fix duplicated inputs.
Trace deducted fees and later withdrawals
Some fees reduce settlements while other charges are withdrawn later. Stripe’s payout docs show how payments, fees, refunds, and other balance changes show up in reconciliation. Your provider may handle costs differently. Check whether the monthly statement lists charges already withheld, charges still to be collected, or both. A bank withdrawal alone won’t tell you.
Here’s a simple example. Detail lists $900 in processing charges, and the statement summary repeats $900. Add the separate $25 service fee, and the assessed total is $925, not $1,825. If the bank later shows a $925 debit, check whether the statement describes it or some fees were already deducted. Don’t automatically count that debit as another expense.
Sources for this section: Stripe: payout reconciliation report
Separate fees from other balance movements
A $200 customer refund cuts cash, but it isn’t automatically a processing fee. A reserve movement may affect available funds without being an expense like a monthly account charge. Keep those categories separate, and ask the accounting reviewer how to treat them. Calling every reduction a junk fee overstates the cost and makes proposal comparisons unreliable.
The Books bookkeeping workspace helps you keep reviewed financial records and supporting documents. The IRS requires records showing income and expenses, backed by appropriate evidence. Use those records to confirm assessed fees, not to invent a reconciliation plug. If the source doesn’t explain a difference, leave it unresolved, assign an owner, and write down a specific follow-up question.
Sources for this section: IRS: supporting business records
Finish with a reproducible total
List every distinct charge in the inclusion ledger, where it appears, and where you count it once. Keep excluded summaries as references, so another reviewer can see why you didn’t add them. Then divide the verified total by settled card sales for the same period. Use the statement’s denominator definition, and explain any adjustment.
Use the result to ask sharper questions about the current arrangement and a proposed change. A lower verified cost doesn’t mean the audit failed. It gives you a more accurate starting point. The owner gets an honest comparison that can stand up to scrutiny. Keep private statement pages in the approved workflow, and use only internal references in the public worksheet.
Have a second reviewer trace one big fee and one monthly charge through the ledger. This spot check tests whether the inclusion rule is understandable, not just whether the calculator’s final result looks reasonable.
Sources for this section: FTC: protecting personal information
Primary sources
BlueFinch last reviewed these sources on October 23, 2026. Check the linked sources for current requirements and product details.
- Stripe: payout reconciliation report
- IRS: supporting business records
- FTC: protecting personal information
Use this page for general business information. It is not legal, tax, or accounting advice.