This weekend — through Sunday at 11:59 PM: BUNDLE-NOV21 takes 10% off the Practice in a Box + Everything Vault bundle. VAULT-NOV21 takes 15% off the Everything Vault. WEEKEND15 takes 15% off everything else, and the new Close the Month + Close the Year bundle is $149.
Browse templates →

Ecommerce Bookkeeping: From Payouts to True Profit

Your platform payout is not your profit — it is what is left after the platform's silent deductions, before your product costs and ads. This guide sets up books that rebuild the whole picture, per channel.

28%true profit margin in the worked month
15%platform fees share of sales in the example
Per channelthe unit these books run on

Welcome to the numbers workshop

Hi, I'm Max — I run Vickery Finance, and this page is one room in the workshop. Everything here walks the same path: from shoebox-and-guesswork to a clean close you can defend, one honest number at a time. Work through it with your own figures in hand — that's when a guide turns into a result. And when you're ready to do the close instead of just reading about it, start with the Free Month-End Close Checklist: it's page one of the 18-step close my templates run, printable and yours to keep. Know your numbers.

Why seller bookkeeping starts from gross, never from payouts

A payout deposits one net number. The books need at least five: gross sales, refunds, platform and transaction fees, shipping charged and shipping spent, and advertising. Recording only the payout hides your real revenue (which your tax return asks for), hides the fee load (which decides which channel deserves your effort), and makes cost of goods sold impossible to match against what actually sold.

Keep the records per channel — Etsy, Amazon, Shopify, eBay — because the channels have different fee structures, different payout rhythms, and very different true margins on the same product. The per-channel view is where pricing and advertising decisions come from.

The monthly seller bookkeeping rhythm

One session per channel per month, from the channel's own reports.

  1. Import the channel's sales report. Gross sales, refunds, and discounts by channel for the month — from the platform's statement, not from payout emails.
  2. Record fees as their own lines. Transaction fees, listing fees, payment processing, and regulatory or offsite-ads fees, each as an expense category. Fees netted invisibly are fees never managed.
  3. Match shipping both ways. Shipping charged to buyers as revenue; labels and postage as expense. A 'free shipping' shop simply has the second line without the first — price accordingly.
  4. Post cost of goods sold from inventory. What the sold items cost you, from the inventory records — the spreadsheet inventory guide on this site walks the ins, outs, and counts.
  5. Record ads and reconcile payouts. Ad spend by channel, then agree total payouts to bank deposits. The month closes when the platform statements, the books, and the bank all tell the same story.

The 1099-K and your books

Marketplaces report gross sales to the IRS on Form 1099-K. If your books record only net payouts, the 1099-K figure will look alarmingly larger than your recorded revenue — it is supposed to: it is gross. Books kept from gross, as this guide sets up, reconcile to the 1099-K in one step: gross sales per the statements, less refunds, should agree with the form. Keep the monthly statements; they are the proof behind the reconciliation.

A worked month: one shop, true profit

A seller moves $9,300 of gross sales across Etsy and a Shopify store in the month. The statements and inventory records give the rest:

LineMathAmount
Gross salesBoth channels$9,300
Cost of goods sold40% of sales− $3,720
Platform and payment fees15% of sales− $1,395
Shipping (labels net of shipping charged)− $930
AdvertisingBoth channels− $650
True profit for the month$9,300 − $6,695$2,605 (28%)
What the payouts alone suggestedDeposits received$7,905 before COGS and ads

Habits that keep seller books honest

Four disciplines separate sellers who know their margins from sellers who guess:

  • Reconcile payouts monthly, not at tax time — a missing payout is findable in its month and archaeology in March.
  • Keep personal purchases out of the business card; one mixed account doubles every categorization decision.
  • Count inventory on a rhythm and let COGS come from counts, not from purchase totals.
  • Read margin per channel quarterly and let it move your effort: a channel at 12% and a channel at 31% should not get equal ad budgets.

Track it in a workbook built for sellers

The E-Commerce Seller Profit Tracker (Amazon, Etsy, Shopify) is built around this rhythm — gross sales, fees, shipping, and profit per channel in Excel or Google Sheets. The E-Commerce Inventory and COGS Tracker handles the stock side that feeds COGS.

Related guide: track the expenses

Companion to this guide: the Ecommerce Expense Tracker — fees, shipping, returns, and ad spend separated by channel, with a worked two-channel month.

Frequently asked questions

Do I report gross sales or payouts on my tax return?

Gross sales (less refunds) is the revenue figure; fees, shipping, COGS, and ads are then deducted as their own lines. That is why the books must be built from gross — and why they will reconcile with your 1099-K. Confirm your specifics with a tax professional.

How do I handle sales tax the platform collects?

Marketplace platforms collect and remit sales tax on your behalf in most states under marketplace-facilitator laws. Amounts the platform collected and remitted are neither your revenue nor your expense — keep them out of both, and keep the platform's tax reports with your records.

One channel or many books?

One set of books, with a channel dimension on every revenue and fee line. Separate books per channel cannot share inventory or expenses honestly; one book with channels tagged gives both the combined and the per-channel view.

Year-end and tax time for ecommerce sellers

A seller's December close starts with documents that do not agree with each other — and should not. Each marketplace issues its own tax paperwork: a Form 1099-K per platform where thresholds are met, plus annual sales reports that show the gross the platform processed. Because marketplaces act as facilitators in most states, the sales tax on most of my orders was collected and remitted by the platform itself — which means that tax was never my revenue and never my filing, but I still keep the facilitator reports with the return so the gross on the 1099-K can be walked down, line by line, to the net sales on my books: gross, minus refunds, minus facilitator-collected tax, minus the shipping my customers paid. If that walk does not tie, December is when I find out why.

Inventory is the second year-end reckoning, and it is a physical one. I count everything on December 31 and compare it with the book quantity. This year the count exposed $1,940 of obsolete seasonal stock still carried at full cost; writing it down to the $260 I can realistically clear it for is a $1,680 hit to the year's profit — taken this year, honestly, rather than smeared across next year's margins one disappointed sale at a time. Damaged returns go through the same door: resellable, refurbishable, or scrap, each with its own value. I also confirm that inventory purchases sitting in transit are recorded once and only once, pull 1099-NEC totals for any contractor — a product photographer, a prep center — paid $600 or more ahead of the January 31 deadline, and check my sales tax nexus picture for my own-site sales, where no facilitator stands between me and the filing.

My closing checklist: every platform's annual report reconciled from gross to book net; facilitator tax reports filed with the return; physical count done and write-downs recorded; contractor 1099 totals pulled; and true net margin by channel computed for the year — the report January's decisions come from.

Dropping a marketplace: decide on true net margin

Sellers keep channels out of habit long after the margin has left. I judge each channel on what a year of its sales actually contributed, after every cost the channel causes. One of my secondary marketplaces produced $12,600 in gross sales last year. Its costs: selling fees at 13%, $1,638; sponsored placement spend, $890 — without which the listings were effectively invisible; refunds and returns, $540; the shipping shortfall I absorbed to stay competitive, $310; and the cost of the goods themselves, $6,930. Total costs: $10,308. True contribution: $12,600 minus $10,308, which is $2,292 — an 18.2% margin, before counting the hours spent feeding its listing format and answering its messages.

My main channel, on the same math, returns 26%, and my own site returns more than that on repeat customers. The decision is not automatically to close the weak channel — it is to price what staying would require. To match a 26% margin on $12,600 of sales, the channel would need to contribute $3,276, which is $984 more than it does; I would have to raise prices there by about 8% or cut the ad spend that props it up, and either move likely shrinks the gross. I gave it one quarter at the higher price. Sales fell by a fifth and contribution fell with them, so I closed it and moved the inventory and the hours to the channels that pay for them. A channel is a landlord, not a friend: when the rent exceeds the location's worth, you move.

Before you go

1 — Your first win (10 minutes): the Free Month-End Close Checklist — page one of the 18-step close, printable, free.

2 — Do it with the workbook: find your trade's template — every workbook runs this same clean-close ritual, with example data and a guided first step inside.

3 — Keep the rhythm: one practical numbers email a week — Know Your Numbers, free to subscribe.

The way back: start any visit at the Start Here hub, or email a human — [email protected]. I answer.

Know your numbers. — Max

Gear we use

Some links below are affiliate links. If you buy through them, Vickery Finance may earn a small commission at no extra cost to you.

Brother P-touch PT-D600 Label Maker — the PC-connectable P-touch for designed labels and barcodes.

APC SurgeArrest 11-Outlet Surge Protector (P11VNT3) — for the whole desk on one strip: eleven outlets with surge protection.

SPVIOQI Fireproof Document Bag — for storing deeds, titles, and business records with heat protection.

Tripp Lite TLP1208TEL Surge Protector, 12 Outlets — twelve outlets and 2,160 joules for the whole desk run.

More books and gear live on the Resources page.