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 Expense Tracker: See What Each Channel Really Keeps

A store's bank deposits are the most misleading numbers in e-commerce — every platform has already taken its cut. This tracker rebuilds the month gross, channel by channel, so fees, shipping, and ads are judged against the sales that caused them.

9 categoriessplit by channel, not just by type
$2,276tracked costs in the worked month
Gross firstfees recorded, never netted away

Why e-commerce store expenses need their own system

E-commerce spending hides inside settlements. Etsy deducts transaction fees, listing fees, regulatory fees, and ad charges before paying out; Shopify takes its subscription and processing share through different pipes; shipping labels come from a third balance entirely. An owner reading deposits sees one number per platform and learns almost nothing from it.

Channel blindness is the expensive consequence. The same product sold on Etsy, on Shopify, and through social shops carries three different fee loads, three different ad costs, and often three different return rates. A tracker that cannot separate channels cannot answer the basic question of where the next hour of effort should go.

How to track e-commerce store expenses, step by step

Rebuild each channel gross every week, then let the month assemble itself.

  1. Record sales gross and fees as expense rows. For every payout, enter the full sales amount as revenue and each fee type as its own expense. The settlement statement already itemizes them; the tracker just refuses to throw the detail away.
  2. Tag every expense with its channel. Ecommerce-specific rule: a shipping label, ad charge, or return belongs to the channel that produced the order. Channel tags are what convert a pile of fees into a per-channel profit picture.
  3. Log labels and packaging at purchase and at use. Buy labels and boxes in bulk if you like, but the tracker charges orders as they ship, using your average label cost per package type. Postage bought is inventory; postage shipped is expense.
  4. Enter returns as a three-part event. A return is a revenue reversal, a shipping cost that usually stays spent, and sometimes a restocked product. Recording all three parts stops returns from masquerading as a simple sales dip.
  5. Separate ad spend by platform and campaign. Etsy Ads, social ads, and search ads go in as distinct rows with the channel they feed. Blended ad spend cannot be cut intelligently because nobody knows which third of it works.
  6. Close the month with contribution per channel. Revenue minus product cost, fees, shipping, returns, and ads, for each channel separately. The ranking that falls out of this view regularly surprises sellers who judged channels by gross sales alone.

Nine ecommerce expense categories that must not be blended

Each category exists because some platform or carrier reports it separately — the tracker simply keeps the separation the statements already offer.

Marketplace and platform fees. Transaction percentages, listing fees, regulatory and payment-processing charges on marketplaces, plus store subscription fees on hosted platforms.

Payment processing. Card processing on your own storefront and any wallet or installment-service fees, kept apart from marketplace bundles where statements allow.

Shipping labels. Postage and carrier charges for outbound orders, by channel — usually the largest single cost after product itself.

Packaging and inserts. Boxes, mailers, tape, labels, tissue, and thank-you inserts, charged to orders as they ship.

Product cost and inbound freight. What the goods cost you, including freight-in and any prep or inspection charges before items reach the shelf.

Returns and refunds cost. Return postage you fund, non-refundable fee portions, and damaged-on-return write-offs — the full economics of a returned order.

Advertising and promoted listings. Marketplace promoted listings, social and search campaigns, and influencer or affiliate payouts that function as advertising.

Apps, tools, and subscriptions. Store apps, email platforms, design and mockup tools, accounting connectors, and domain and hosting renewals.

Storage, prep, and fulfillment help. Warehouse or prep-center fees, pick-and-pack charges, and part-time packing help during peak pushes.

The per-order view: where pricing gets fixed

Channel totals tell you where to sell; per-order economics tell you what to charge. Once a month of orders carries its true fees, label, packaging, and product cost, divide the totals by orders shipped and the result is your real cost to fulfill one order on each channel. Sellers who run this once usually find a free-shipping threshold or a small-item price that loses a little money hundreds of times.

Fixes are correspondingly precise: a minimum basket for free shipping on the channel where labels cost most, a small-item surcharge where packaging dominates, or a price difference between channels that reflects their fee loads instead of pretending they are identical. None of these decisions can be made from deposit totals.

Worked example: one month across Etsy and a Shopify store

A home-goods seller moves $8,940 of gross merchandise sales in a month — $5,120 on Etsy and $3,820 on Shopify — across 214 orders. The tracker rebuilds the month from statements:

The tracked rows total $2,276. The $2,276 of tracked selling costs is 25.5% of gross sales before product cost — a figure no deposit statement ever showed. Labels alone, $924 across 214 orders, average $4.32 per order, which becomes the shipping assumption inside every price the store sets next season.

CategoryAmount
Marketplace and platform fees$486
Payment processing (own store)$118
Shipping labels$924
Packaging and inserts$137
Returns cost (postage and write-offs)$96
Etsy Ads and social ads$342
Apps and subscriptions$79
Prep and packing help (peak weekend)$94
Total tracked$2,276

Ecommerce tracking habits for statement season

Platforms change fee names regularly; these habits keep the tracker stable anyway:

  • Download every platform statement monthly, even if you enter data weekly — portals prune history, and tax time asks for documents, not memories.
  • Map each new fee name to an existing category instead of creating a new one, so year-over-year comparisons survive platform relabeling.
  • Track gift-wrap, personalization, and other add-on revenue separately; add-ons often carry the margin that headline prices cannot.
  • Reconcile tracker channel totals to actual payouts monthly — the difference should be exactly the fees you recorded, and any gap is a fee you missed.

Rebuild your channels in a seller-ready workbook

The E-Commerce Seller Profit Tracker for Amazon, Etsy, and Shopify carries the channel-split categories on this page, per-order cost views, and monthly contribution by channel in Excel and Google Sheets.

Frequently asked questions

Why not just track what hits my bank account?

Because deposits are sales minus an unknown mixture of fees, ads, and adjustments. Two months with identical deposits can have very different economics, and pricing decisions made from deposits alone systematically underprice the fee-heavy channel.

How should I treat shipping I charge the customer for?

Record shipping charged as its own revenue line and labels as expense. Netting them hides both your true product margin and your true shipping cost, and the gap between the two lines is itself a number worth managing.

Do I need separate tracking for each platform?

Separate channel tags, one system. A single tracker with a channel column gives both the combined business view and the per-channel verdicts; separate spreadsheets per platform guarantee the combined view never gets built.

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.

DYMO LabelWriter 450 Turbo — for fast label printing — and the 450-series printer the 30252-compatible rolls above actually fit.

CyberPower CP1500AVRLCD UPS, 1500VA/900W — the original AVR LCD 1500VA unit, still the budget pick of the line.

Rediform Small Money Receipt Book (8L820) — the pocket-size 50-form version of Rediform's money receipt book.

Casio fx-991ES Plus, 2nd Edition — Casio's full scientific calculator for statistics and formula-heavy work.

More books and gear live on the Resources page.