How do I reconcile a payment processor's payouts against individual sales in my books?

Use a separate clearing account for each processor—for example, “Stripe Clearing.” It tracks money the processor has collected but hasn’t yet sent to your bank.

Record the activity in three parts

1. Record each sale at its gross amount—or summarize sales by day or batch if your books don’t need every transaction as a separate entry. Credit sales revenue, and record sales tax separately as a liability if applicable. Debit the processor clearing account for the amount the customer paid.
2. Record fees, refunds, and other adjustments in their own accounts, with the offset to the clearing account. For example, debit processing-fee expense and credit clearing for a fee.
3. Record the payout as a transfer from clearing to your bank. Match the bank-feed deposit to this entry; don’t record the payout as new sales income.

Example: A customer pays $100, the processor charges a $3 fee, and it pays you $97.

• Sale: debit processor clearing $100; credit sales revenue $100
• Fee: debit processing-fee expense $3; credit processor clearing $3
• Payout: debit bank $97; credit processor clearing $97

The clearing account nets to zero for those transactions. In real life, a payout may combine many sales and include refunds, disputes, reserves, or adjustments, so use the processor’s payout detail to explain the net amount. Stripe, for example, provides payout reconciliation details showing the transactions and their gross, fee, and net amounts. (support.stripe.com)

Reconcile regularly

For each payout, check:

Gross payments − refunds − fees − disputes/adjustments = net payout

Then match that net payout to the bank deposit. Investigate differences such as a payout still in transit, a held reserve, a missing fee or refund, or a duplicate entry. At month-end, the clearing-account balance should be explainable by processor funds still pending or held—not unexplained leftovers. Processor reports can differ because of date ranges and time zones, so compare consistent periods and settings. (support.stripe.com)

If your bookkeeping software imports both sales and payouts automatically, check which entries it creates before adding anything manually; otherwise, you can double-count the sale or fee. (quickbooks.intuit.com)

Reconciling payouts is mainly a matter of breaking one net bank deposit back into the individual sales, fees, and refunds that produced it. The usual approach is a clearing account.

1. Set up a clearing account
Record each sale at its full gross amount into a temporary clearing account (a current asset) when it processes. The clearing account holds that money until the processor transfers it, and it should return to zero after each settlement. A clearing account is a temporary account, usually set up as a current asset, that holds your gross sales amount between the transaction date and the bank transfer date.

2. Post the sales and fees separately
Card sales can credit revenue and debit clearing, while processor fees debit a merchant fees expense and credit clearing. When the payout hits the bank, you clear the clearing account against the deposit amount.

Example: a $1,000 sale with a $30 fee pays out $970.

• Sale: Dr Clearing $1,000 / Cr Revenue $1,000
• Payout: Dr Bank $970, Dr Merchant Fees $30 / Cr Clearing $1,000

Recording only the $970 as revenue would understate both sales and fees.

3. Match each payout to its underlying transactions
Pull the processor's payout or settlement report, which lists every transaction, fee, refund, and dispute in that batch. Then confirm that gross sales minus fees minus refunds (and any chargebacks or reserves) equals the deposit. A flat estimated fee rate won't tie out, because refunds and dispute fees in the same batch change the figure. Use the processor's per-transaction data rather than a percentage of total sales.

4. Match by reference, not amount
Matching by amount alone causes errors, especially when several sales share the same value or one deposit covers many transactions. Use the batch or payout ID, processor transaction reference, deposit date, and the fee summary instead.

5. Watch the common problem areas

• Timing: Payouts often cover a batch that doesn't line up with the calendar period, so a day's sales may land in a later deposit. Reconcile by payout batch, not calendar month.
• Refunds and chargebacks: These come out of the payout and need their own entries; they often get missed.
• Sales tax: Confirm that tax collected isn't lost inside a net deposit.
• Reserves and holds: Some processors withhold funds, so the deposit will be lower than sales for reasons other than fees.
• Multiple currencies: Conversion differences need to be booked separately.

6. Check your tie-out
At the end of each period, the clearing account should be zero, every payout should match a bank deposit, and the sum of gross sales, fees, and refunds should equal the total of your payouts. Any leftover balance points to a missing fee, refund, or timing item.

Tools: If you have many transactions, most accounting platforms offer native connectors for Stripe, Square, PayPal, and Shopify, and some third-party apps break payouts down by order. Check that the connector records fees as a separate expense rather than netting them silently.

The exact entries depend on your accounting method and jurisdiction, so have your accountant confirm the setup, especially for sales tax, reserves, and multi-currency transactions.

Reconciling payment processor payouts (like Stripe, PayPal, or Square) is fundamentally different from standard bank reconciliation because the deposit you see in your bank account is a net amount—meaning it has already been reduced by fees, refunds, and other adjustments.

To reconcile these accurately, you must move away from treating the bank deposit as the "source of truth" for your sales and instead treat it as a settlement of a clearing account.

1. The Core Strategy: The Clearing Account

Instead of recording your bank deposits directly as "Sales," use a Payment Clearing Account (a temporary holding account in your balance sheet).

• Step A: Record Gross Sales. When a sale occurs, record the full gross amount in your accounting system. Debit (increase) your Clearing Account and credit (increase) your Revenue/Sales account.
• Step B: Record Fees and Adjustments. When you receive your settlement report from the processor, record the fees, refunds, and chargebacks as separate entries. Credit (decrease) the Clearing Account for these amounts and debit (increase) the appropriate expense accounts (e.g., "Merchant Fees," "Refund Expense").
• Step C: Record the Payout. The remaining balance in your Clearing Account should now match the actual cash deposit that hit your bank account. When the deposit arrives, record a transfer from the Clearing Account to your Bank Account.

2. The Step-by-Step Reconciliation Process

To keep your books audit-ready, follow this cycle:

1. Download the Settlement Report: Every payment processor provides a report (CSV or PDF) for every payout batch. Do not rely on your bank statement alone; it only shows the final lump sum.
2. Match Transactions: Use the report to identify the specific sales, fees, and refunds that make up that batch.
3. Account for Timing Differences: Remember that sales often occur on different days than the settlement/payout. Your clearing account will carry a balance for these unsettled transactions; this is normal.
4. Clear Exceptions: Identify and investigate "breaks"—amounts that don't match or aren't accounted for (e.g., a chargeback that appeared in a different period or a currency conversion discrepancy).

3. Best Practices to Save Time

• Automate where possible: Most modern accounting software (Xero, QuickBooks, etc.) has built-in bank feed rules or integrations with processors like Stripe and PayPal that can automate the recording of fees.
• Avoid "Guessing": Never simply categorize a net deposit as "Sales" and ignore the fees. This leads to underreporting your gross revenue (which can affect VAT/tax thresholds) and prevents you from tracking your actual cost of doing business.
• Use Unique Identifiers: If your system supports it, ensure that order or invoice IDs are passed through to the processor’s reference field. This makes matching individual transactions during reconciliation significantly faster.
• Reconcile Regularly: Do not wait until month-end. Reconciling by payout batch (e.g., weekly or as they occur) prevents a massive pile-up of "mystery money" that becomes harder to trace over time.

If your volume is high (hundreds of transactions daily), consider using dedicated payment reconciliation software that can ingest these settlement files and automatically match them against your ledger entries.

Use a payment-processor clearing account to connect each sale to the payout that eventually reaches your bank. That way, the payout is not mistakenly recorded as new revenue.

A practical workflow

1. Record each sale at its gross amount.

   Match each order or invoice to the processor’s transaction using an order or transaction ID. Record sales, taxes collected, and any other components in their proper accounts; post the amount the processor owes you to the clearing account.

1. Record activity that changes the amount owed.

   Post processing fees as expenses, refunds as refunds or contra-revenue, and chargebacks or other adjustments to the appropriate accounts. These often reduce the clearing balance.

1. Match the payout report to the bank deposit.

   A payout may combine many sales and adjustments. Use the processor’s payout or settlement report to identify the transactions included, then compare the net payout with the corresponding bank deposit. For Stripe, its itemized payout reconciliation report lists the payments, refunds, disputes, fees, and other transactions in a payout ¹².

1. Record the payout as a transfer, not a sale.

   For example, if $1,000 in sales is reduced by $30 in fees and $20 in refunds, the $950 deposit is a transfer from the clearing account to the bank. The sale and fee/refund entries account for the difference; don’t book the $950 again as revenue.

1. Check the clearing balance regularly.

   Investigate unmatched transactions and confirm that the ending balance is explained by money still held by the processor or payouts in transit. A clearing account is commonly used to track itemized sales, fees, refunds, and payouts without overstating revenue ³.

Simple example

• Customer sales: $1,000 → clearing account
• Processor fees: $30 → fee expense, reducing clearing
• Refunds: $20 → refunds/contra-revenue, reducing clearing
• Bank payout: $950 → transfer from clearing to bank

The key is to reconcile in three links: sale to processor transaction, transaction to payout, and payout to bank deposit. Don’t expect a payout to match one sale or one day’s sales; automatic payouts can bundle transactions from different dates ². If you use manual payouts, the processor may not identify which transactions were included, so you’ll need to reconcile them against your transaction history ².

Sources: ¹ Stripe payout reconciliation report ² Stripe payout reconciliation ³ Payment processor clearing-account guidance