Reconciling Stripe, PayPal and Square in the books
Payment processors like Stripe, PayPal, and Square are where a lot of small-business bookkeeping quietly goes wrong, because they deposit a net figure — sales minus fees minus refunds — and it is tempting to just record that deposit. Do that and your revenue and your costs are both understated at once. This guide explains how to record processor activity so gross sales, fees, and refunds each land where they belong, and how to reconcile the processor cleanly.
The net-deposit trap
When a customer pays $100 through a processor, the business does not receive $100 in its bank — it receives the payout after the processor's fee (say $3) and after any refunds, so perhaps $97 lands a day or two later. The error is to record only that $97 as income. That single shortcut understates gross sales (which were $100) and hides the $3 processing fee entirely. The books should instead show $100 of income and $3 of processing-fee expense, so both the revenue and the cost of accepting payment are stated correctly.
Use a clearing account
The clean way to handle this is a clearing account — a holding account that money passes through between the sale and the bank deposit. The mechanics are simple:
- Each sale posts into the clearing account as income (gross).
- Fees and refunds come out of the clearing account (fees to an expense account, refunds against sales).
- The payout transfers the net balance from the clearing account to the bank.
Because everything the processor did flows through this one account, its balance shows exactly what the processor is holding but has not yet paid out — and it can be reconciled to the processor's own reports to the penny.
We reconcile every processor to gross sales, fees and refunds, so your revenue and margins are finally accurate.
Avail our bookkeeping servicesReconciling and why it matters
With a clearing account in place, reconciling a processor is like reconciling a bank account: match the processor's transactions to the books, ensure fees and refunds are captured, and confirm the payout clears the clearing balance. Getting this right does more than tidy the books — it reveals true gross revenue (which matters for thresholds and for understanding the business), the real cost of accepting payments, and it keeps refunds and chargebacks properly recorded rather than silently netted away. It also connects to what customers owe, since processor timing affects when cash actually arrives. Handled on a monthly rhythm, processors stop being a black box in the accounts.
A worked month, in numbers
Take a store that ran $10,000 of gross card sales through Stripe in a month, issued $150 of refunds, and paid $320 in processing fees. The bank shows deposits of $9,530 — and that $9,530 is the only number a bank-feed-only bookkeeping setup ever sees.
| Item | Amount | Where it belongs |
|---|---|---|
| Gross card sales | $10,000 | Revenue |
| Refunds issued | ($150) | Contra-revenue, not an expense |
| Processor fees | ($320) | Merchant fee expense |
| Net deposited | $9,530 | Bank |
Booking the deposit as $9,530 of revenue understates sales by $470 and records no fee expense at all. Revenue is wrong, deductible expenses are wrong, and gross margin is wrong — all from one shortcut. The clearing-account method above produces the four lines instead of the one: debit bank $9,530, debit merchant fees $320, debit refunds $150, credit revenue $10,000.
Timing, holdbacks and the month-end cut
Two things routinely stop the clearing account from reaching zero, and only one of them is an error.
- In-transit settlements. A sale on the 30th that settles on the 2nd sits in the clearing account across the month end. That balance is correct — it is genuinely money earned and not yet received, and it should agree to the processor's pending-payout figure.
- Reserves and holdbacks. Some processors retain a rolling percentage against chargeback risk. That is an asset you own but cannot yet spend, so it belongs in its own account rather than buried in the clearing balance, or it will look like an unexplained reconciliation difference every month.
Anything left in the clearing account that is neither in transit nor held in reserve is an error, and finding it monthly takes minutes. Finding it in March, across twelve months and three processors, does not. See the monthly close checklist for where this step sits in the sequence.
Sources
This guide is written against the official and clearly labelled professional references below. Rates, thresholds and portal procedures change between reviews, so open the primary source before relying on a figure.
Questions people also ask
Why is recording only the payout from Stripe or PayPal wrong?
Because the payout is the net figure after the processor has deducted its fees, and often after refunds. Recording only the net deposit understates both your gross sales and your processing-fee expense. The books should show the full sale as income and the processor fee as a separate expense, so revenue and costs are each stated correctly rather than silently netted.
What is a clearing account and why use one for processors?
A clearing (or holding) account is an account that money passes through between the sale and the bank deposit. Sales post into it as income, fees and refunds come out of it, and the payout transfers from it to the bank. It lets you reconcile the processor to the penny and see exactly what is sitting with the processor but not yet deposited.
How do processor fees get recorded?
As a business expense in their own account, separate from sales. Each processor deducts a fee from the transactions it handles; that fee is a real cost of taking payment and should be visible as an expense, not buried by only recording the net amount that lands in the bank. Recording fees separately also lets you monitor what payment acceptance is costing the business.
Send the tax year and the transaction or filing involved, and we will tell you what is actually required.
Talk to Chartered Advisory Open the tax calculators