Pricing & inventory
Price it from your real costs, and know what is left on the shelf. For makers and resellers who have been pricing on instinct and counting stock by opening the cupboard.
Selling on Etsy? The free Etsy fee calculator shows what one sale keeps after every fee, and works backwards from the amount you want to keep.
The templates side by side
Every one works in Excel and Google Sheets. "You type into" counts the tabs where your numbers go; "calculated for you" counts the tabs that need no typing at all, and "set up once" the tabs you fill in at the start.
| Template | Tabs | You type into | Calculated for you | Set up once | Price |
|---|---|---|---|---|---|
| Small Business Bookkeeping (Income/Expense) | 9 | 3 | 4 | 2 | $4.79 |
| 1099 / Schedule C Self-Employed Tax Spreadsheet | 9 | 2 | 5 | 2 | $3.80 |
| S-Corp Reasonable Salary & Distribution Optimizer (US) | 8 | 1 | 5 | 2 | $8.69 |
| Mileage Tracker | 8 | 2 | 4 | 2 | $2.81 |
| Business Budget Spreadsheet | 6 | 2 | 2 | 2 | $3.29 |
| Profit & Loss Statement Generator | 7 | 2 | 3 | 2 | $3.80 |
| Pricing Calculator | 7 | 2 | 3 | 2 | $4.49 |
| Inventory Tracker | 6 | 2 | 2 | 2 | $2.69 |
| Employee Timesheet | 6 | 2 | 2 | 2 | $3.29 |
| Invoice Tracker & Generator | 8 | 3 | 3 | 2 | $2.99 |
| Cash Flow Spreadsheet | 8 | 4 | 2 | 2 | $3.29 |
| Employee Attendance and PTO Tracker | 6 | 2 | 2 | 2 | $3.29 |
| Client Tracker & CRM | 7 | 2 | 3 | 2 | $5.69 |
| Business Expense Tracker | 8 | 2 | 4 | 2 | $1.79 |
| Product Profit Tracker | 6 | 1 | 2 | 3 | $2.69 |
Which template do I need?
Price first, then check the price held. A price that accounts for fees, materials and the margin you meant to make is the first file. Profit per order once the platform has taken its cut is how you find out whether it survived contact with real orders.
Stock levels that update from simple in and out logging closes the loop, with no scanner and no subscription. The pricing and stock pair and the full four-file bundle are the two ways to buy these together.
Markup, margin and when to reorder
Markup and margin describe the same price from two ends, and mixing them up is the most common pricing mistake (the margin and markup calculator converts one to the other). An item that costs $10 to make and sells for $25 has a 150% markup (the $15 profit divided by the cost) and a 60% margin (the $15 divided by the price).
A reorder point tells you when to buy before you run out: daily sales times the days a delivery takes, plus a safety stock for slow weeks. Selling 3 a day with a 10-day lead time and 15 spare means reordering at 45.
Selling on Etsy? The free Etsy fee calculator shows what each sale keeps after every fee, and the break-even calculator how many sales cover your fixed costs.