The Complete Etsy Seller Bundle is an Etsy seller spreadsheet bundle built as one connected Excel workbook — 19 sheets in which your orders, monthly results, pricing and stock read from each other instead of sitting in separate files. The fee rates live in one place, so a figure you type once is the same figure everywhere it appears. It is made for makers who are done reconciling five versions of the same shop.
| Date | Order # | Customer | Item |
|---|---|---|---|
| Oct 28 | #8821 | J. Miller | Mug 11oz |
| Oct 29 | #8822 | S. Chen | Tote bag |
Illustrative example — the workbook itself is a clean spreadsheet.
An order doesn’t move the shelf.
Loose cards, stamped one by one — they drift.
This counter is a picture of the idea, not the product: type an order on the form, press the SOLD stamp once, and this month’s figures and the profit print through together, identical — the workbook’s Transactions fee model, worked per line. The shelf layer does not print from the order: stock moves only when you stamp its Stock Log slip, exactly as in the file. Beside the stack, the loose cards show the old way — stamped one by one, and already drifting apart.
A shop’s numbers, in most small businesses, live in fragments that quietly disagree. A fee worked out one way in a pricing calculator and another way in the accounts. A stock level counted on a notepad and sold from somewhere else. A monthly total re-typed by hand into a third place, then re-typed again when it turns out to be wrong. None of these fragments is a disaster on its own. Together they mean you never actually see the whole business at once — and you learn not to fully trust any single figure, because you’ve caught them contradicting each other before.
So you make decisions on the fragment nearest to hand. You price from instinct. You reorder from a glance at the shelf. You tell yourself the month was fine because the fragment you happened to look at said so.
This Etsy seller spreadsheet bundle ends the fragmentation by being one file rather than several. It’s a purpose-built Excel workbook — not a set of separate tools collected into a folder, but a single system with its own sheets, its own layout, and its own wiring between them. The order log writes the monthly figures. The monthly figures feed the dashboard. The pricing bench and the stock list read the same costs. And at the back sits one Settings sheet carrying the Etsy fee rates and the reorder threshold, which every calculation in the file pulls from — so a rate changed once is changed everywhere. The connections have defined boundaries, too: recording an order and recording a stock movement are different jobs in this workbook, and neither is ever presented as doing the other’s work.
One plain note before you read on: the visuals and interactive elements on this page are illustrations, made only to introduce the product and show what it does. What you receive is the Excel workbook described here — those illustrations are not part of the file you receive.
What changes is that the contradictions stop. A cost held on your stock sheet is the cost the order log uses for that sale. A stock movement logged once is the stock level everything else reads. The monthly revenue on the dashboard isn’t typed by you and isn’t re-typed by anyone — it’s the sum of the order lines you already entered. And because every sheet is protected with only the yellow input cells open, a stray keystroke can’t quietly break a total you were relying on.
Most shops work out Etsy’s fees differently in different places, which is how two documents end up disagreeing about the same sale. Here the rates live once, on the Settings sheet: the transaction fee, the listing fee per sale, the processing percentage, the processing fixed fee and the Offsite Ads percentage, plus the reorder threshold for finished goods. Every sheet that needs a fee reads from those cells. If Etsy changes a rate, you update it in one place and the whole workbook follows — the order log, the pricing calculator, the batch comparison, the estimated monthly fees. Nothing has to be chased around and nothing gets left on an old rate.
On most spreadsheets, the monthly summary is a second job: you finish the orders, then sit down and total them up again. In this workbook you log each item sold on the Transactions sheet, and the monthly figures fill themselves in. Orders counts each order once however many item lines it carries; revenue adds up that month’s line totals. That single connection removes the most error-prone half hour of the month, and it means the dashboard can’t disagree with the order log — it has no independent source to disagree from.
Each line in the order log works out its cost of goods by looking up the item’s unit cost on your Inventory sheet, matched by product name, and multiplying by quantity. You set that unit cost once and it’s used on every sale of that item. If a particular line needs a different cost — an older batch, a one-off — you can type a cost override on that line, and it replaces the lookup for that line alone. The pricing workshop keeps its own chain honest the same way: materials you cost once in the library are looked up when you build a product, so a product’s cost never has to be re-typed to be re-priced. One honest boundary: the batch comparison’s quick estimate leaves the Offsite Ads fee out, so use Listing Calc for the exact check on a single listing — it is the sheet that includes Offsite Ads at the Settings rate, capped at $100 per sale.
START HERE isn’t a title page. It carries four headline cards — the period’s revenue and orders, how many SKUs need restocking, and how many products are sitting under a 30% margin — and beneath them a live restock list of up to nine SKUs at or below their reorder point, out-of-stock items first. When nothing needs attention it says so plainly. Opening the workbook therefore starts with a decision rather than a browse.
The whole workbook is protected without a password: yellow cells accept typing, white cells hold formulas and stay locked. That’s a guarantee rather than a restriction, because it means every total you read was calculated rather than accidentally overwritten. What stays switched on is everything that helps you work — sorting, filtering, inserting and deleting rows and columns, and formatting. The protection stops damage; it doesn’t stop you.
You don’t have to use all of it on day one, and you don’t have to reconcile it if you don’t. The sheets are grouped into five working areas — Shop, Money, Pricing, Workshop and Stock — and they connect in one direction: you enter facts, and the workbook derives everything else. Adding a product doesn’t require updating four other places by hand, because the other places are already looking at the one you changed.
The workbook opens on START HERE, which states the golden rule, lays out the five working steps, maps the sheets in their five groups, and shows the four headline cards and the restock list described above. Behind it sit the working areas.
Shop is where the month gets its shape. Dashboard is driven by two selectors — a year (2023–2030, set to 2026 as shipped) and a period (All, Q1, Q2, Q3, Q4; All as shipped) — and gives headline cards for revenue, orders and weighted conversion (the period’s total orders divided by its total visits) against the same period last year, a twelve-month trend table with true month-on-month growth, a revenue column chart comparing this year with last, a traffic snapshot read from the Traffic sheet, an average-monthly-fees readout, and three goal cells you type in. Stated plainly: of those three goals, only the monthly revenue goal is wired into a calculation — it is the target behind Shop Data’s Target Hit flags. The annual orders goal and the conversion goal are reference entries that no formula reads. Shop Data holds one row per month across 3,000 rows: you type the month (dates from January 2023 to December 2030), visits, ad spend, new listings and reviews, while orders and revenue arrive from the order log — orders counted once per order, revenue summed from that month’s line totals. Rank, Target Hit (● HIT / ○ MISS against the monthly revenue goal), an estimated-Etsy-fees column worked out at the Settings rates, and a duplicate-month warning are calculated. New listings and reviews are recorded on this sheet, but no KPI is calculated from them. Shop KPIs mirrors Shop Data with conversion, average order value, revenue growth against the previous calendar month and ad ROAS — and stays honestly blank where a divisor is zero. No profit or margin figures live on this sheet; profit lives in Bookkeeping. Traffic is a 60-row snapshot of where your buyers came from this month: five sources come pre-named — Etsy Search, Social, Direct, Ads, Other — and those names are fixed in the file; they cannot be edited and no further sources can be named. You type visits and orders per row; conversion and an above- or below-average verdict are calculated. It is a current snapshot you refresh monthly, not a history.
Money is the bookkeeping. Transactions is the order log — 3,000 rows, one row per item sold — where you enter the date, order number, item (picked from your Master SKU Catalog), sale price and quantity, with an optional COGS Override for freezing a line’s cost. Everything else calculates: the listing fee per unit, the transaction and processing percentages worked out on the item total (price × quantity) only, the $0.25 processing fixed fee charged once per order on its first line, total Etsy fees, cost of goods looked up by item name from the unit costs on Inventory, net profit for the line, and a flag for any line where no cost could be found. This sheet has no shipping, discount or Offsite Ads columns — its fee model is its own, and it is stated here exactly as the file runs it. Expenses records costs in five categories — Supplies, Shipping, Ads, Software, Other — across 1,500 rows. Bookkeeping is the monthly profit and loss: pick a month and the sheet fills itself in with revenue, total costs, net profit and margin, plus a year-to-date block, an inventory-on-hand value line, the month’s first ten orders, a “where the money went” breakdown by cost type (Etsy fees, COGS, and the five expense categories), and the workbook’s second column chart — net profit for the last six months. One precision worth knowing: the P&L’s cost-of-goods figure is summed from the looked-up costs on Transactions, so a COGS Override settles that order line’s own profit without rewriting the monthly P&L.
Pricing is the check on any listing. Listing Calc takes ten inputs for one listing — price, quantity, shipping charged, material, packaging, labour minutes, hourly rate, shipping cost, discount and a profit goal — and returns every fee line individually (the Offsite Ads fee always included at the Settings rate, capped at $100), total costs, net profit, margin, the margin measured against the file’s fixed 40% target, progress toward your profit goal, a break-even price from the workbook’s own formula, the price cushion above break-even, and a plain-English verdict in three bands. Its fee panel is read live from Settings. Listing Batch lines up to 100 listings side by side with fees, net profit and margin calculated for each — its estimate leaves the Offsite Ads fee out — then a win-rate badge, a top-five table and a dot grid of which listings make money.
Workshop is where products get costed. Pricing Materials is a 900-row library of material names, units, unit costs and suppliers — the one table in the file that ships with examples: three materials (Cotton Fabric at $4.50 per yard, Ceramic Blank at $2.80 per piece, Kraft Box at $0.85 per piece) so you can watch the lookup work before entering your own; the rows are ordinary input rows you can edit or clear. Pricing Products builds up to 900 products from up to three library materials each, plus labour, overhead and a target margin, and returns the total unit cost, a suggested price (unit cost divided by one minus the target margin), your actual margin at your price, a verdict against target — or a plain “material not found” flag when a picked material is missing from the library, never a guessed cost — and an estimated profit. Pricing Inventory tracks finished goods made and sold across 900 rows: on hand is made minus sold, its status flags a reorder when on hand falls below the reorder threshold held on Settings (5 as shipped), unit cost is pulled from Pricing Products, and what’s on hand is valued. Pricing Dash reads the workshop back as headline figures — total SKUs, units on hand, inventory value, average actual margin measured against a fixed 60% benchmark, a stock alert counting products under five units, a profit-goal tracker, and cards for the first eight products.
Stock is the storeroom. Inventory holds 900 rows: you pick the SKU from the catalog and set the product name, reorder point and unit cost — quantity on hand is never typed, it is counted from the log (units in minus units out), and the status reads Out of stock, Low or OK. Its unit costs are the ones Transactions looks up for cost of goods. Stock Log is 3,000 rows of movements in and out, each dated and tied to a SKU, with the product name filled in from Inventory.
Behind it all sit Settings — the five fee rates, the reorder threshold, and the 900-row Master SKU Catalog, which ships empty and feeds both the Inventory SKU picker and the Transactions item picker — Lists, the helper sheet behind the dropdowns (the month list, the expense categories, the traffic source names) that never needs editing, and Guide, ten numbered sections explaining every sheet in plain language, including the note that three benchmarks — the 40% margin target, the 60% Pricing Dash benchmark and the 30% low-margin alert — are fixed reference points, not settings.
Worth saying plainly: every log and table in the workbook ships empty — no orders, no expenses, no months, no products, no stock. The only things filled in are the fee rates and reorder threshold on Settings, the dashboard’s year and period selectors, the five traffic source names, and the three example materials. And the whole file contains exactly two charts, both column charts: the Dashboard’s revenue comparison and Bookkeeping’s net profit for the last six months.
The front door: golden rule, five working steps, four headline cards and the live restock list of up to nine SKUs.
Year and period selectors; revenue, orders and weighted conversion against the same period last year, a trend table and the revenue column chart.
One row per month across 3,000 rows: visits, ad spend, new listings and reviews typed in; orders and revenue arrive from the order log.
Conversion, average order value, growth against the previous month and ad ROAS — honestly blank where a divisor is zero.
A 60-row snapshot with five fixed source names — Etsy Search, Social, Direct, Ads, Other; conversion and a verdict per source.
The order log: 3,000 rows, one per item sold; fees on the item total only, the $0.25 fixed fee once per order, cost of goods looked up from Inventory.
Costs in five categories — Supplies, Shipping, Ads, Software, Other — across 1,500 rows.
The monthly profit and loss: revenue, costs, net profit and margin, a year-to-date block, and the net-profit chart for the last six months.
One listing in full: every fee line with Offsite Ads included and capped at $100, net profit, margin, break-even price and price cushion.
Up to 100 listings side by side; its estimate leaves the Offsite Ads fee out; win rate, a top-five table and a profit dot grid.
A 900-row library of material costs — a cost reference, not a stock list — shipping with three example materials you can edit or clear.
Up to 900 products built from up to three library materials each, plus labour, overhead and a target margin.
Finished goods made and sold across 900 rows; on hand is made minus sold and reorder flags follow the Settings threshold.
The workshop read back: headline figures, a stock alert, average margin against a fixed 60% benchmark and a profit-goal tracker.
900 rows; quantity on hand is counted from the Stock Log, never typed; status reads Out of stock, Low or OK.
3,000 rows of dated movements in and out — the only place stock levels change.
The five fee rates, the reorder threshold, and the 900-row Master SKU Catalog (ships empty) feeding both item pickers.
The helper sheet behind the dropdowns; it never needs editing.
Ten numbered sections explaining every sheet in plain language.
Short walkthroughs for this workbook. Nothing loads until you press play.
Short, focused walkthroughs of the Complete Etsy Seller Bundle are being recorded — getting started, working each sheet, and the month-end routine. When they are published, they will appear right here, filed under the categories above.
The bundle’s Listing Calc sheet, in miniature — one listing checked live in your browser: every Etsy fee line at the workbook’s own Settings rates, your material, packaging, labour and shipping costs, then net profit, margin, break-even price and a plain verdict. It runs entirely here: nothing is stored, and no data leaves the page. The full workbook remains the complete version.
The bundle’s Listing Calc sheet, in miniature: one listing checked with every Etsy fee line at the workbook’s own Settings rates, each percentage fee rounded to the cent on its own line, live in your browser. Amounts are in dollars; a blank field counts as 0.
A negative or non-numeric entry is rejected — it counts as 0 until it is fixed.
This miniature checks one listing in full, as the Listing Calc sheet does. The full workbook also carries the batch comparison, the order log, the monthly bookkeeping and the stock system — and remains the complete version.
This is for the Etsy seller — most often a maker — who is already running the shop’s numbers somewhere, in more than one place, and has started to notice that the places don’t agree. You sell physical products, you’ve got a pricing calculator and a stock list and a monthly summary that were never introduced to each other, and you’d rather have one matched system than add a fourth tool. You’re comfortable typing figures into a workbook, and you want the arithmetic done for you at consistent rates.
It’s not for you if you’re hoping for something that connects to Etsy and imports your data — nothing here syncs, and every figure is typed by hand. It’s also not a tax tool: there’s no tax calculation, report or filing anywhere in the file. And if you sell digital downloads only, or you want daily or weekly figures rather than monthly ones, this isn’t the right shape.
One payment through the listing, nothing else to set up.
The file arrives instantly — no shipping, nothing posted.
Set your fees on Settings, log orders on Transactions and a row per month on Shop Data, price on the Pricing sheets, keep stock honest on Stock Log and Inventory — the Guide explains each sheet as you go.
The workbook opens in Microsoft Excel, Google Sheets and LibreOffice Calc, so it runs wherever you already look at numbers, including a free browser tab if you don’t own Excel. Delivery is immediate at checkout, the single payment is the whole cost, and the file is yours to keep and reuse — no subscription and no renewal.
No, and that’s worth being clear about. This is one purpose-built workbook of 19 sheets, built as a connected system with its own sheet names and its own versions of those jobs — it isn’t the standalone files collected into a folder, and it doesn’t carry their extra features. What you get is a single file where the parts read from each other.
Not at all. Plenty of sellers start with the order log and the monthly dashboard, then add pricing once they’re comfortable. The sheets connect in one direction — you enter facts and the workbook derives the rest — so using some of it leaves the rest ready rather than half-finished.
No. Stock changes only when you add an entry to the Stock Log — logging an order never reduces a quantity by itself. The Inventory sheet counts the Stock Log to show what’s on hand, and the materials library is a cost reference rather than a stock list, so no stock movement applies to materials at all.
You pay once on Etsy, and the file is yours to keep and reuse.
Instant download after checkout. One payment, and the workbook is yours to keep.