Shopify Seller Bookkeeping Spreadsheet | Payout Reconciliation, Fee and Profit Tracker - Google Sheets

Shopify paid you $2,477.02. Your orders say $2,524.34. Where did the $47.32 go?

That gap is where Shopify sellers lose money quietly — a chargeback you never logged, a fee you never saw, an adjustment buried in a payout report. This tracker closes the gap: every payout is tied back to the exact orders inside it, with what you expected and what actually landed in your bank, side by side. When a payout ties out, it shows a green check. When it doesn't, it flags itself with the exact variance — so you go find the missing money while you still can.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

**WHAT'S INSIDE — 7 focused tabs:**

• Start Here + Dashboard — the plain-English guide, the money-flow math, and the whole store at a glance: expected vs. received, variance, fees, tax owed, net profit

• Order Log — every order with items, discounts, shipping charged, sales tax, refunds, chargebacks, the Shopify transaction fee, and the order's true net — plus which payout it landed in

• Payout Reconciliation — the hero: payout by payout, expected (from the orders inside it, plus adjustments) vs. actual received, with a variance flag to the cent

• Product Profit — revenue, COGS, and shipping per SKU, so you see true margin by product, not just by store

• Expenses & App Costs — the plan, the apps, the supplies: the whole subscription stack Shopify sellers accumulate, totaled by category

Sales Tax by State — collected vs. remitted per state, with the balance you still owe — because collected tax is the state's money, never your income

• Monthly P&L — item sales, shipping, refunds, chargebacks, fees, COGS, and expenses by month, built automatically, with a year-end summary and tax totals

**HOW IT WORKS**

1. After checkout you get a PDF with your private link. Click it and choose "Make a copy" — the tracker is yours.
2. Log each order in one row. Sales tax (looked up from the ship-to state) and the transaction fee (your plan's rate — the samples use Basic, 2.9% + $0.30) calculate themselves.
3. When a payout lands, type the amount that actually hit your bank. The sheet compares it to the orders inside t payout and flags any difference.

**THE MATH, PLAIN AND SIMPLE**

An order's net = items − discounts + shipping charged + sales tax collected − refunds − chargebacks − transaction fee. A payout's expected total = the nets of its orders + any adjustments on the payout report. In the fictional sample store (Willow Creek Candle Co., 26 orders, 6 payouts), five payouts reconcile to the cent. Payout PO-0925 flags ⚠ DOESN'T TIE OUT at −$47.32: an unlogged $32.32 chargeback plus its $15.00 chargeback fee. Order #1066 shows the other case — a chargeback that WAS logged, so its payout ties out fine. Adjustments like label credits are first-class rows, so a clean payout with a credit still reconciles.

**WHY THIS ONE**

The generalist bookkeeping sheets treat Shopify as one fee percentage in a dropdown. This one is built around how Shopify money actually moves: payout schedule, per-order fee stack, refunds and chargebacks as first-class rows, app-cost tracking, and sales tax collected by state. One Google Sheets file for a one-time price — instead of a bookkeeping app plus a connector subscription every month. It comes loaded with the fictional sample store so you can watch every flag fire before you replace the samples with your own numbers.

**PLEASE READ:** This is an organization and calculation tool. It is not tax or accounting advice, and it does not file or remit anything for you. Sales tax rules, nexus, and rates vary by state and change over time — set your own states and rates on the Sales Tax by State tab and check with your accountant or bookkeeper.

**FINISHED FILE** — This listing is a digital item, delivered instantly as a file at checkout. The file is finished and ready to use — nothing is customized or personalized. If anything ever breaks or a formula misbehaves, message us and you will receive a corrected file free — forever, no time limit.

**REQUIREMENTS:** a free Google account. Your tracker lives in Google Sheets — no Excel needed, and it works at your desk, in the packing area, and on your phone.

This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.