On this page
Define the entity, account and period
Identify the legal entity, currency, processor, merchant reference, clearing account, bank destination and reporting period. Keep actual account numbers and credentials in controlled records. An anonymous account reference is sufficient for the public worksheet. Separate periods and accounts that have different populations instead of combining them because their totals happen to agree.
The existing QoE guide and workbook compare monthly sources. The next step is explaining the mechanism behind a difference. A monthly P&L, CRM invoice report and bank deposit total need not be identical: recognition, collection, processor fees, held funds and noncustomer bank movements can separate them. Their reconciliation is evidence work, not a forced equality.
Trace a customer payment through its records
| Record | What to match | What it does not establish alone |
|---|---|---|
| Job and invoice | Entity, work, amount, tax/refund treatment and invoice reference | An invoice is not proof of cash received. |
| Field-system payment | Payment reference, method, date and any reversal | A paid flag is not bank settlement evidence. |
| Processor clearing detail | Gross payments, refunds, chargebacks, fees and held balances | Gross activity is not the net payout. |
| Bank settlement | Actual credit/debit, value date and processor reference | A bank credit is not automatically customer revenue. |
IRS guidance explains that Form 1099-K gross payment amounts are not reduced by specified items such as fees and refunds. Use it with the processor records rather than treating the form as net cash. Publication 583 also explains the role of source records and checking-account reconciliation. These tax-recordkeeping sources do not prescribe a complete revenue-recognition method for every acquisition.
Roll the clearing balance forward
Use a consistent due-from-processor account. Start with its opening balance, add current gross customer payments, subtract actual refunds, chargebacks and fees, include supported other clearing movements, then subtract the closing balance. Under that defined scope, the result is the expected net payout to the bank. Independently compare the actual bank evidence.
| Original hypothetical January bridge | Amount |
|---|---|
| Opening due-from-processor balance | $20,000 |
| Gross processed payments | +$100,000 |
| Refunds | −$5,000 |
| Chargebacks | −$2,000 |
| Charged processing fees | −$3,000 |
| Closing due-from-processor balance | −$19,000 |
| Expected net bank payout | $91,000 |
| Observed net bank payout in this case | $90,000 |
| Actual less expected | −$1,000 unresolved |
The closing $19,000 consists of $15,000 unsettled funds and $4,000 held reserve in this example. Those are components of the closing balance. Subtracting another $4,000 reserve would count the same held amount twice. Confirm whether fees and other adjustments are charged through the clearing account or somewhere else before using the bridge.
A chargeback or refund can concern an earlier sale. Refunds exceeding current-period gross payments are not automatically invalid. A processor can also debit a bank account or have an amount owed to it. The settlement tool supports signed clearing balances and net payouts, with explicit categories, rather than forcing every period into a positive-receipt pattern.
Keep unexplained differences visible
A second period with a positive $1,000 variance does not explain the first period’s negative $1,000. Their signed total is zero; the sum of absolute period differences is $2,000. Investigate each account and period. Check duplicate exports, missing batches, mismatched cutoffs, refunds, reserve releases and amounts routed to another account before drawing a conclusion.
For consecutive periods on the same account, compare the prior closing clearing balance with the next opening. A difference is another evidence exception; do not overwrite the opening to make the numbers agree. For a gap between periods, identify the missing population. Overlapping periods should not be aggregated as separate complete populations.
Classify bank movements outside customer cash
Bank credits can include loan proceeds, owner funding, transfers, rebates and other movements. In a separate hypothetical classification, $91,000 of processor credits plus $25,000 loan funding, $10,000 owner capital and $9,000 inter-account transfers total $135,000. That total does not establish $135,000 of customer payments or earned revenue. Preserve both the bank population and the classification evidence.
The settlement bridge is not a complete bank-statement reconciliation, an audit opinion or an automatic tax calculation. It explains the defined processor population. Reconcile other receipts, outgoing bank payments, outstanding checks and the ledger separately. If the scope is partial, a zero calculated difference does not prove completeness.
Treat the ownership cutoff as part of the evidence
The IRS Form 1099-K page specifically discusses business purchases and sales where a terminal has not been updated with the new business owner’s name and tax ID. Identify transactions before and after the agreed cutoff and obtain the actual processor’s authorized entity/account process. The IRS example does not mean that every merchant account can simply be renamed or transferred.
Link this work to the service-agreement and payment handoff and digital delivery plan. Record who bills, receives settlement, refunds and handles disputes during the transition. Use an authorized provider test and destination evidence; a successful login or an invoice marked paid is only one part of the chain.
Prepare a reproducible review file
Retain the original exports, entity/account map, period definitions, clearing roll-forward, bank references, closing component tie and exception log. Sample material, unusual, reversed and cutoff transactions deliberately. Identify whether testing covers the whole population or a sample, and keep customer/employee identities and banking details out of public exports.
The useful conclusion states what reconciled, what remains unresolved and which records could resolve it. It should not label every variance fraud, invent an unrecorded-revenue adjustment or imply that processor cash settles the accounting treatment. Carry any reviewed financial correction into the earnings, working-capital or closing schedules once, with its own evidence and responsible adviser.
Companion resources
Use the printable or editable materials alongside the guide.
Payment-settlement example CSVCustomer-payment source and bank registerRelated decisions
Sources and scope
Source links support the specific topics noted. Examples and analytical frameworks are illustrative; confirm current requirements and transaction facts with the responsible advisers.
- What to do with Form 1099-K
Gross payment reporting differs from fees/refunds and settlement cash; specific bought/sold-business section flags merchant name/TIN cutover. No reporting threshold or tax rate is assumed. - Publication 583, Starting a Business and Keeping Records
Source documents and bank reconciliation; tax recordkeeping context does not determine GAAP revenue recognition or validate an acquisition. - Manage your business: Manage your finances
Bookkeeping, available cash, bank reconciliation, payroll, receivables and payables. Not a prescriptive acquisition forecast or accounting opinion.
Continue your research
Browse the research library · Calculators and downloads · Trade profiles