How settlement report works
A settlement report is the source document that lets a bookkeeper explain a payout instead of guessing at it. It typically lists each transaction date, amount, the fee taken, and any adjustments such as refunds or disputed charges, all rolled up to the exact deposit figure that hit the bank, giving the bookkeeper a full audit trail for every dollar.
Without the settlement report, a bookkeeper only sees one lump-sum deposit in the bank feed and has no way to split it correctly between sales, fees and refunds. Pulling and reconciling settlement reports regularly is one of the main tasks in payment-processor reconciliation, especially for businesses selling through several platforms at once, where each processor formats its report differently and needs its own handling.
Example
A processor's settlement report for the week shows gross sales of $14,600, fees of $410, refunds of $220, and a chargeback of $180, netting to a payout of $13,790. The bookkeeper uses the report to post each component separately in the general ledger, then confirms the $13,790 matches the actual bank deposit for that date.
Settlement report in QuickBooks Online vs Xero
Most processors, including Stripe, Square and PayPal, make settlement reports available for download or through an API. QuickBooks Online and Xero do not generate these reports themselves; they rely on the processor's data, often pulled in through a connected app, to break a payout into its components.
Common mistakes
- Skipping the settlement report and posting the bank deposit directly to sales, which buries fees, refunds and chargebacks inside a single revenue number that no longer reflects reality.
- Not pulling a settlement report for every processor a business uses, which leaves some sales channels reconciled properly and others recorded as an unexplained lump-sum deposit.
- Filing settlement reports away without comparing the net total to the actual bank deposit, which can let a processor error or missing deposit go unnoticed for a full cycle.
Why it matters
Without the settlement report, a business has no way to prove why a deposit is smaller than its sales, which makes it hard to trust the numbers going to a lender, investor or tax preparer. For a business selling across multiple processors, settlement reports are the only way to see gross revenue and collection costs by channel. Reconciling them every cycle keeps financial statements defensible instead of built on guesswork.
Related terms
How LedgerBPO handles settlement report
We pull settlement reports from each of your processors every payout cycle and use them to reconcile gross sales, fees, refunds and chargebacks down to the exact deposit in your bank feed, so nothing is left as an unexplained lump sum.