Ecommerce Bookkeeping Spreadsheet: Track Every Order, Fee & Profit in One Place

Published June 17, 2026

Most ecommerce sellers track revenue in one place, fees in another, and COGS nowhere. By tax time, reconstructing profit is a week-long project. A proper bookkeeping spreadsheet changes that — order log, automatic fee calculation, COGS tracking, and a dashboard you can glance at in 10 seconds.

Why Ecommerce Bookkeeping Is Different

Revenue is not bankable. What lands in your bank account can be 40-60% less than what your store reports as "sales." Ecommerce sellers face a unique set of bookkeeping challenges that a simple income/expense ledger does not capture:

• Fee stacks: Each platform deducts 6-8 separate fees per order — listing fees, transaction fees, payment processing, ad fees, subscription costs. They hit at different times on different statements.
• Multi-channel complexity: Selling on Etsy, Shopify, Amazon, and eBay means four different fee structures, four payout schedules, and four CSV formats to reconcile.
• Inventory-as-COGS timing: You bought materials in January, sold the product in March, and paid shipping in March — matching COGS to the right order across time periods is where spreadsheets break.
• Refunds reverse profit: A refund in July wipes profit you already booked in June. Without per-order tracking, refunds land as a mystery expense with no connection to the original sale.
• Ad spend attribution: Etsy Ads, Amazon PPC, Facebook ads — spend hits your credit card, not a platform deduction. Attributing ad cost to the specific orders it generated is manual and error-prone without a system.

An ecommerce bookkeeping spreadsheet does what QuickBooks cannot: it ties every fee, every ad dollar, and every unit of COGS directly to a specific order, so you know exactly which products and channels make money.

What an Ecommerce Bookkeeping Spreadsheet Must Include

Order log with platform, SKU, price & fees — the foundation

Every order gets one row. Platform name, order ID, SKU, sale price, and every fee broken out into its own column. This is the single source of truth that everything else — dashboard, tax reports, profit analysis — pulls from. No more cross-referencing three CSV exports.

Automatic fee calculation per platform

Etsy takes 6.5% + $0.20 + $0.25 payment processing (plus Offsite Ads at 12-15%). Amazon charges a 15% referral fee plus variable closing fees. eBay is 13.25% in most categories plus $0.30 per order. A good bookkeeping sheet has these formulas pre-built. You select the platform from a dropdown and the fees calculate automatically.

COGS and inventory tracking — match costs to specific orders

Your cost of goods sold is not one number. Different SKUs have different material costs. The sheet must let you set a per-SKU COGS and automatically pull it into each order line. Bonus: a running inventory count that decreases as orders are logged, so you know when to reorder without checking physical stock.

Ad spend tracker — ROAS per channel per product

Log ad spend by channel (Etsy Ads, Amazon PPC, Meta, Google) and assign it to products. The sheet calculates ROAS per channel and per SKU, so you see whether that $200 Facebook campaign actually generated profitable orders — or just generated revenue that fees and COGS turned into a loss.

Real-time dashboard — revenue, net profit, margin %, by-channel breakdown

One tab you open for 10 seconds and understand your entire business. Total revenue, total fees, net profit, and profit margin percentage. Broken down by platform so you see that Amazon does 3x your Etsy volume but at half the margin. No pivot tables, no filtering — the dashboard updates as you log orders.

Invoice generator — tied to actual orders, not guesswork

For wholesale buyers, tax records, or B2B customers who need documentation. Generate a clean invoice from any order row with one click. Line items, fees, totals — all pulled from the data you already logged, formatted and ready to send.

DIY vs Ready-Made: The Real Trade-Off

At $20/hour your time is worth something — spending 10 hours to build a sheet that might have formula errors costs more than $19. And if a bad formula underreports your profit by 5% all year, the tax implications cost far more than the spreadsheet.

Real-World Example: Tracking One Order

Let's walk through an Etsy order at $45. Here is what actually happens to that $45 — and what the spreadsheet captures in two line entries (one for the sale, one for COGS/shipping).

Plug this order into the bookkeeping spreadsheet and two things happen instantly: the dashboard updates to reflect the new net profit and margin (51.7%), and the inventory count for this SKU drops by one. Two line entries. Complete financial picture.

Most sellers log the $45 sale and stop there. They feel profitable. The spreadsheet shows $23.27 in real profit — and that is the number that matters for pricing, taxes, and knowing whether you can afford to scale.

Get Your Bookkeeping Under Control Today

You do not need another SaaS subscription. You need one spreadsheet that does the job — order log, fee calculator, inventory tracker, dashboard, invoice generator — with formulas you can audit and data you own. A one-time purchase that works in Excel and Google Sheets, no macros, no recurring billing.