How to Record Stripe, Square, and PayPal Payouts in QuickBooks

A merchant processor payout is never the same number as your sales. When Square deposits $4,812.37, that figure is gross card sales minus refunds, processing fees, chargebacks, and any instant transfer charge, so coding the whole deposit to income understates your revenue and hides your fee expense at the same time. Split every payout instead: gross sales to income, processing fees to a merchant fees expense account, refunds and chargebacks as reversals of sales, and only the leftover net to the bank. Higher volume sellers do the same through a merchant clearing account that holds gross sales until the payout arrives. Either way, income and expense show their true size and the bank still ties out.

This is the most common mistake in books that involve card payments. The bank feed shows a clean deposit, the number looks like money earned, and it gets accepted as sales. A year later the profit and loss shows revenue that is thousands of dollars light and an empty merchant fee expense line. Sales tax reporting suffers too, because the tax you collected is buried inside a net number.

Why does my Square deposit not match my sales?

Your deposit does not match your sales because the processor takes its cut before it sends the money, and it also nets out anything it owes back to customers. A day with $5,120.00 in card sales can land in your bank as $4,812.37 after refunds and fees. Nothing is wrong; you are simply looking at the net rather than the gross.

Here is the same batch broken out, with the account each piece belongs in:

Only the last line appears on your bank statement. The first three exist only in the processor's payout report, which is why the bank feed alone is never enough. Pull the payout detail from the Square, Stripe, or PayPal dashboard for that date and treat it as your source document.

How do I record a Stripe payout in QuickBooks?

Record a Stripe payout as a bank deposit split into at least two lines: the gross amount of the charges included in that payout coded to sales income, and the Stripe fees as a negative line coded to merchant processing fees. The two lines net to the amount that hit your checking account, so the deposit matches the bank exactly while income and expense are both stated at full size.

Stripe deducts its fee from each individual charge rather than billing you monthly, then pays out on a rolling schedule that for most US accounts runs a couple of business days behind the charge. That delay matters: the payout landing Wednesday contains Monday's charges, so the gross figure you post is not Wednesday's sales. Use the payout report, which lists exactly which charges and fees make up that transfer.

Refunds and disputes ride along inside the payout as negative amounts. A refunded charge reduces the payout, and a disputed one pulls both the sale and a dispute fee out. Those get their own lines. If you are seeing unexplained deductions, the guide on recording a chargeback in QuickBooks covers how to book the reversal and the fee separately.

Are Square fees an expense or a deduction from income?

Square fees are an expense, not a reduction of income. Report gross sales as revenue and the processing fees as an operating expense on their own line. Netting the fee against sales hides a real cost of doing business, distorts your gross margin, and can create problems on a tax return or a loan application where gross receipts are compared against what the processor reported.

Processors file Form 1099-K reporting your gross card volume, not your net deposits. If your books show only net, your reported revenue comes in lower than the 1099-K, and the difference is exactly your fee total. Booking fees as an expense closes that gap and gives you the deduction.

Processing fees typically run a bit under 3 percent plus a small fixed amount per transaction, and the exact rate depends on your plan, your card mix, and whether the card was present or keyed in. Do not back into the fee from a flat percentage. Take the actual total off the payout report.

How do I record PayPal fees in QuickBooks?

Treat the PayPal balance as its own bank account in QuickBooks, record each sale into it at gross, record each PayPal fee as an expense out of it, and then record the withdrawal to your checking account as a transfer between two accounts you own. That keeps fees visible and stops the transfer from being miscounted as income a second time.

PayPal is different from Stripe and Square in that money sits in a balance you control until you move it. A standard transfer to your bank is free and takes a day or so; an instant transfer costs a fee that comes out of the amount moved. That instant transfer fee is a bank or merchant expense, and it belongs in the same expense account as your other processing costs. The transfer itself is never income. It is cash moving from one asset account to another.

Skip the PayPal-as-bank-account setup and book only the withdrawals, and any sale still sitting in the balance is missing from your books while the fees stay invisible. For several payment channels at once, the ecommerce bookkeeping workflow covers keeping them separate.

How do I set up a merchant clearing account for high volume?

Create a bank-type account in your chart of accounts called Merchant Clearing (or use Undeposited Funds if you prefer). Post gross sales into it as they happen, post processing fees out of it as expense, and when the payout arrives, record a transfer from clearing to checking for the net amount. A correctly maintained clearing account nets to zero once all funds settle.

This is the better method once you run more than a few payouts a week, because it separates two questions the split-deposit method jams together: when did I earn the money, and when did the bank get it. The balance left sitting there is funds in transit, a real asset at month end. The split-deposit method is simpler and perfectly correct at low volume. Pick one and stay with it.

Should I use the Stripe app or import my bank statement?

Use one or the other for the sales detail, never both pointed at the same transactions. The connected Stripe or Square app brings in each individual charge and fee, and your bank connection or statement import brings in the payout deposit. If you accept both as sales, you book the same revenue twice: once as the charges and once as the deposit.

Let the app create the gross sales and fees, then match the bank deposit to that batch rather than categorizing it as new income. In QuickBooks Online the deposit should offer itself as a match. If it insists on being added instead, the amounts do not agree and something is missing from the batch.

Many bookkeepers skip the app entirely and work from the payout report plus the bank statement, which is faster to audit and does not break when an app disconnects. In that case, converting the PDF bank statement to a QBO file gets every payout deposit into the register with the correct date and amount, ready to be split. Then categorize the imported transactions against the payout detail.

What do I do when a payout spans two months?

Record the sales in the month they were earned and the deposit in the month the cash arrived, using the clearing account to bridge the two. Charges from the last days of March that pay out in early April sit in Merchant Clearing at March 31, so March income is complete and the April deposit simply clears the balance.

On a cash basis this matters less, since you can reasonably record the income when the deposit lands. On an accrual basis, or any period where the year end falls in the gap, the clearing account is the only clean way to handle it. Apply whichever rule you pick at every month end so month-to-month comparisons mean something.

How do I reconcile merchant deposits in QuickBooks?

Reconcile against the bank statement, not the processor report. Your books should contain a deposit for every net payout on the statement, at the exact amount and date, with the gross and fee detail behind it. If the reconciliation is off by an odd amount, check for a fee or refund that was netted instead of split out.

Three checks catch nearly every problem. First, add up the merchant fee expense for the month and compare it to the total fees on the processor reports; they should agree. Second, confirm the clearing account balance equals funds genuinely in transit. Third, compare gross sales in your books against the processor's gross volume for the same period. Once those tie, reviewing the imported transactions before you accept them is what keeps the next month clean, and the month's finished numbers are ready for whatever you use for turning a bookkeeping export into presentable financial statements for a lender or a partner.

Get the deposits in first, then split them

You cannot split a payout that is not in the register. Every deposit first needs to exist in QuickBooks on the right date and for the right amount, which is what a converted bank statement gives you. Upload the PDF, get a QBO file, import it, and every Stripe, Square, and PayPal deposit for the period is waiting to be broken into gross sales and fees.

If you are catching up several months or several accounts at once, converting the statements in a batch saves the tedious part, and you can work through the payouts month by month with the processor reports open beside them.