Ecommerce bookkeeping: matching Shopify, Stripe and Amazon payouts to the bank

 To match Shopify, Stripe and Amazon payouts to your bank, give each platform its own clearing account. Book every payout report into that account at its gross figures, sales in and refunds and fees out, then categorize each bank deposit to the same clearing account. When the books are right, each clearing account sits at zero at month end, or holds a balance you can name, like a payout still on its way.

Most sellers skip the clearing account and categorize the deposit straight to sales. That works until a payout and a deposit stop lining up, and then there is nowhere to see it.

What is a clearing account, in plain terms?

It is a holding account on the balance sheet. The payout report puts money into it. The bank deposit takes money out of it. If both sides are booked, they cancel. If one side is missing, the leftover tells you which.

You want one per platform because each pays on its own schedule. Shopify might pay out most business days, Stripe on its own rolling schedule, Amazon about every two weeks. Mix them in one account and a missing Amazon deposit hides behind three Shopify ones.

How do you book each payout?

Wickline Candle Co. is a fictional seller with its own Shopify store, wholesale customers who pay invoices by card through Stripe, and an Amazon listing. Here is its April 2026. Sales tax is left out to keep the numbers short; on your own site it goes to a sales tax payable account, never to sales.

Shopify sent two payout reports in April:

Shopify payout	Orders	Refunds	Processing fees	Payout
Paid April 14	6,420.00	(310.00)	(197.40)	5,912.60
Paid April 30	1,140.00	0.00	(55.50)	1,084.50
April total	7,560.00	(310.00)	(252.90)	6,997.10

Each payout becomes one journal entry: debit Shopify clearing for the payout, debit refunds and merchant fees, credit product sales for the orders. The April 14 entry debits clearing 5,912.60, refunds 310.00 and fees 197.40, and credits sales 6,420.00. Both sides come to 6,420.00.

Stripe made one payout for wholesale invoices: charges of 2,850.00 less fees of 82.95, so 2,767.05 to the bank.

Amazon closed one settlement inside April, covering April 8 to 21: product sales 4,180.00, referral fees (627.00), fulfillment fees (838.20), payout 2,714.80. The settlement that started April 22 closes in May, so it goes into May's books by its own dates.

What does the month-end check look like?

Now the bank. Every deposit from a platform gets categorized to that platform's clearing account, not to sales. Then read the balances on April 30:

Clearing account	Payouts booked in	Deposits booked out	April 30 balance
Shopify clearing	6,997.10	5,912.60	1,084.50
Stripe clearing	2,767.05	2,767.05	0.00
Amazon clearing	2,714.80	2,714.80	0.00

Stripe and Amazon are at zero. Shopify holds 1,084.50, which matches the payout dated April 30 to the cent, and the bank statement shows it arriving May 1. That balance is money in transit. It clears on the first deposit of May.

That is the whole method. Any other leftover is a question with a short list of answers.

What does a leftover balance usually mean?

• Exactly one payout. Either the deposit hasn't landed yet, or it landed and was categorized somewhere else, often straight to sales. Search the bank for that amount.
• A negative balance. A deposit was booked out but its payout report was never booked in. Find the report for that date.
• A small odd amount. Usually a chargeback, a chargeback fee or an adjustment taken out of a later payout. Book it where it belongs and the balance goes back to zero.
• A balance that grows every month. Often a marketplace reserve. That is still your money, held by the platform, so it belongs on the balance sheet. A reserve that only grows is worth a call to the platform.

Why go to this trouble?

Because a payout is a net number and the business runs on the gross ones. Wickline's bank received $11,394.45 from the platforms in April (5,912.60 + 2,767.05 + 2,714.80). What it actually sold through them was $14,590.00 (7,560.00 + 2,850.00 + 4,180.00). The $3,195.55 between those figures is refunds, fees and the Shopify payout still in transit. Booked from deposits, April's sales would be short by that much and every fee would be invisible.

The form that settles arguments here is the 1099-K. A platform files one only when your gross payments through it top $20,000 and your transactions top 200 in the year, and it reports gross sales before refunds and fees. Books built on deposits never match it. Books built through clearing accounts match it platform by platform.

For the rest of an online store's books, including an Amazon settlement worked line by line, marketplace sales tax and cost of goods sold from your inventory count, see our guide to bookkeeping for ecommerce.

Disclosure: I'm Damin and I run ZeraBooks, so weigh this part accordingly. ZeraBooks doesn't connect to Shopify, Stripe, Amazon or your bank. Our bookkeeping team works from the statements and payout reports you upload through your portal, grosses up each payout through its own clearing account, and won't sign a month off until every bank and card account ties to its statement and every clearing account is at zero or explained. You see it all in a read-only login. The service starts at $150 a month (USD) and is quoted after a free call; more on our bookkeeping services page.

Start with one platform. Once its clearing account reaches zero for a month, the others are the same work.