Maker Business OS Starter
A free 3-tab Excel starter that connects inventory, a sales log, and a monthly summary in one file — log a sale once and the month totals itself up. It is the lite cut of the full 14-tab Maker's Business Operating System, built to show what a connected system feels like before you outgrow the grid.
A free, connected 3-tab Excel starter for makers who are tired of running their business across spreadsheets that do not talk to each other. Tab one is an Inventory list with on-hand quantity, reorder point, a status column that flashes the row red/amber/green, and a per-item value that calculates itself. Tab two is a Sales Log — one row per sale, with the line total computed for you. Tab three is a Monthly Summary that rolls revenue and units up by month straight from the Sales Log, with no typing. It is the lite cut of the paid 14-tab Maker's Business Operating System (which adds a fee-aware pricing calculator, a customer CRM, wholesale tools, expenses mapped to Schedule C, a monthly P&L, and a year-end tax summary, all connected). Built to show, in your own file, exactly what a connected system feels like — and where a spreadsheet still runs out of road.
- An Inventory tab with on-hand qty, reorder point, last unit cost, and a status column that reads on-hand vs. reorder point and flashes the row red/amber/green automatically
- A Sales Log tab — one row per sale, with the line total computed for you and hidden helper columns that classify each sale by month
- A Monthly Summary tab that totals revenue and units by month straight from the Sales Log, with nothing to type
- A Read Me that explains the color code (yellow = your input, gray = formula) and how the three tabs connect
- Sample data from a working soap & candle business you can replace with your own catalog in a few minutes
- A clear upgrade path: this is the free 3-tab cut of the full 14-tab Maker's Business Operating System (inventory + pricing + wholesale + customers + sales + expenses + a reconciling Schedule C), available on the Ardent Workshop storefront
Educational tool only — not financial, tax, or accounting advice. The reorder-point status is an estimate; tune it to your supplier lead times and demand. The full version's Schedule C mapping and any tax figures are starting points to review with a qualified professional.
Why a connected spreadsheet beats six separate ones
Most makers keep one spreadsheet for inventory, another for sales, and a third for the monthly numbers — none of which talk to each other, so the same figures get typed two or three times and rarely agree. This starter connects the three: a sale logged on the Sales Log flows into the Monthly Summary on its own, and the Inventory tab's status column flags low stock without you walking the shelves.
The point of starting connected is that you feel the payoff immediately (numbers that add themselves up) and the limits eventually (a spreadsheet still can't decrement materials when you produce, separate a refund, or keep an audit trail) — which is exactly the knowledge you want before deciding whether to graduate to software.
What the full Business Operating System adds
This free file is the 3-tab cut of a 14-tab paid workbook. The full Maker's Business Operating System adds a Settings tab that drives a fee-aware pricing calculator (suggested prices that hit your target margin after Etsy/Shopify/Square fees), a customer CRM, wholesale line-sheet and outreach tools, an expense log mapped to its Schedule C line, a mileage log, a monthly P&L, and a year-end tax summary — with all four net-profit figures reconciling to the same number.
If the starter earns its keep, the full version is the next step before software — and Ardent Seller is the step after that, when the file finally gets too big to keep by hand.
Want the full version?
This free starter is the 3-tab lite cut. The full 14-tab Maker's Business Operating System adds a fee-aware pricing calculator, a customer CRM, wholesale tools, an expense log mapped to Schedule C, a monthly P&L, and a year-end tax summary — all connected, with every net-profit figure reconciling. Available on the Ardent Workshop storefront.
Get the full Business Operating SystemOr skip the spreadsheet entirely
A connected spreadsheet is a great place to start — and the clearest preview of why a real system helps. Ardent Seller keeps this whole picture live all year: inventory that decrements itself when you sell or produce, costs that reprice when a vendor's price moves, fee-aware sales and P&L reports, an Etsy connector that fills the sales log for you, and an audit trail of every change. Same model you already think in (materials → recipes → batches → sales), without the formulas you maintain by hand. There's a free plan to start.
Dashboards & reports
The live version of the Monthly Summary — revenue, profit, margin, and what needs reordering, updated automatically and fee-aware, on every device.
Multi-location inventory
On-hand balances that decrement when you sell or produce — across booth, studio, and retail partner — without a single typed-over formula.
Sales & customers
Every sale tied to a customer and an order, so order history and totals build themselves instead of relying on a name match in a column.
Frequently asked questions
Is this spreadsheet really free?
Yes — the 3-tab starter (Inventory, Sales Log, Monthly Summary) is a free download with no email required. It is the lite cut of the paid 14-tab Maker's Business Operating System; the full version adds pricing, customers, wholesale, expenses, a monthly P&L, and a Schedule C summary.
Does it work in Google Sheets, or only Excel?
Both. It is an .xlsx file that opens in Microsoft Excel, imports into Google Sheets (File > Import), and opens in LibreOffice Calc. The formulas use standard functions (SUMIFS, IF) supported everywhere, with no macros.
How do the three tabs connect?
You log each sale as one row on the Sales Log; the line total is computed for you, and hidden helper columns tag the sale's month. The Monthly Summary then sums revenue and units by month straight from those rows — so the monthly numbers update themselves. The Inventory tab is standalone but uses the same reorder-status logic as the rest of the family.
When should I move from this to inventory or business software?
The usual signals are selling from more than one location, producing in batches that should decrement raw materials, needing fee-aware profit by channel, reconciling sales channels that take more than 30 minutes a month, or catching formula errors you can no longer trust. Any one of those is the moment a connected file stops keeping up and real software earns its place.
Related resources
Inventory Tracker Starter Kit
A working Excel inventory tracker for makers — raw materials, finished goods, packaging, and a purchase log. Reorder thresholds and a status column do the math; conditional formatting flashes red when you are below the line.
Product Pricing Calculator
A working Excel pricing calculator — materials, labor, packaging, and platform fees in, a defensible retail price out. Plus a batch tab that shows what 50 vs. 10 actually costs.
Schedule C Tax Expense Tracker
A working Excel expense tracker organized by IRS Schedule C category. Drop-down picker on every row, a Monthly Summary that builds itself, a year-end Schedule C view, and a mileage log with the deduction calculated for you.
Multi-Channel Sales Reconciliation Worksheet
A working Excel worksheet for sellers reconciling Etsy + Shopify + in-person sales against bank deposits — surfaces fee shortfalls, refund mis-postings, and a per-channel monthly P&L.
Wholesale Line Sheet
A working Excel line sheet for handmade wholesale — buyer-ready front sheet, per-SKU pricing math behind it, and the formulas already wired in.
Spreadsheet vs Inventory Software: The Decision Guide
When a spreadsheet is enough, when it stops working, and how to tell the difference before it costs you.
From the blog
Articles that dig deeper into the topics this tool covers.
Spreadsheet Breakup: How to Know When Your Maker Business Has Outgrown Excel (And What Actually Replaces It)
Your spreadsheet got you this far. It is also the thing that is quietly breaking every time you open it. Here is how to tell when a maker business has outgrown Excel, what you actually lose by staying too long, and a plain decision framework for choosing what replaces it.
Scaling from 10 Orders to 100: When Handmade Businesses Outgrow Their Systems
There is a painful middle stage between hobby and thriving business where your order volume breaks everything — your inventory tracking, your purchasing, your fulfillment process. Here is what breaks first, why, and exactly how to fix it at each growth stage.
Why Are My Margins Shrinking? A Six-Symptom Diagnostic for Maker Businesses
Revenue is up, orders are up, and somehow the bank account is not. Here is a six-symptom diagnostic for the most common margin leaks in a maker business — supplier drift, packaging creep, shipping spillover, custom-order time bleed, marketplace fee inflation, and discount habituation — with the specific report that will tell you which leak is yours.
When Your Hobby Becomes a Business: The Tax and Record-Keeping Tipping Point
The IRS draws a hard line between hobbies and businesses — and being on the wrong side of it can cost you thousands. Learn how to recognize the tipping point and what records to keep from day one.