Small Business Spreadsheets
These workbooks are for people who run a small shop or a side business from a spreadsheet. Each one does one job: a ledger that rolls up into a profit and loss, stock counts with reorder points, a price worked out from materials and time, a cash flow forecast, a reseller log, an order tracker or a year's expenses and mileage.
Every workbook comes as a filled example with made-up numbers and a blank copy, and a bundle holds several such pairs. Formula cells are locked with no password, and you type only in the colored cells. There are no macros.
Scripts recalculated each workbook in LibreOffice and compared the results with a separate Python calculation. A script also opened and recalculated them in Excel for Mac; that test did not type in new data. Google Sheets has not been tried. These files add up what you type. They are not tax, legal or financial advice, and each product page says what was tested.
All 5 templates
-
Reseller Spreadsheet
Profit per item, a fee you set per platform, and the 10 oldest unsold items
$5.99 on Etsy -
Bookkeeping Spreadsheet
One ledger rolls up into a 12-month profit and loss and a cash table
$5.99 on Etsy -
Inventory Spreadsheet
Stock in and out by SKU, with a ready reorder list and stock value at cost
$5.99 on Etsy -
Product Pricing Calculator
Materials and labor minutes turn into a price for your target margin
$5.99 on Etsy -
Cash Flow Spreadsheet
Forecast 12 months, add actuals, and see which month dips under your warning level
$5.99 on Etsy
Which one do I need?
| Template | Best for | Inside | Format | Bundle contains | Price |
|---|---|---|---|---|---|
| Reseller Spreadsheet | Resellers selling on more than one platform | Four tabs, 500 item rows, up to 8 platforms | .xlsx, Example and Blank copies | — | $5.99 |
| Bookkeeping Spreadsheet | Small businesses keeping cash-basis books | 6 tabs, 1,000 ledger rows, up to 40 categories | .xlsx, Example and Blank copies | — | $5.99 |
| Inventory Spreadsheet | Small shops counting stock by SKU | 6 tabs, 300 SKUs, 2,000 movement rows | .xlsx, Example and Blank copies | — | $5.99 |
| Product Pricing Calculator | Makers who sell what they make | 6 tabs, 120 materials, 600 build rows, 40 products | .xlsx, Example and Blank copies | — | $5.99 |
| Cash Flow Spreadsheet | Owners planning cash a year ahead | 6 tabs, 12 months, 6 money-in and 16 money-out lines | .xlsx, Example and Blank copies | — | $5.99 |
Prices in US dollars from our listing records. Etsy shows the current price and your local currency at checkout.
Questions
- Which platforms does it know?
None. You type the name and fee of each one on the Setup tab, up to 8. The Example uses made-up names and fees.
- Is this double-entry bookkeeping?
No. It is a single list on a cash basis. It does not do invoices, depreciation or sales tax.
- Can it track more than one location?
No. It keeps one count per SKU.
- What does margin mean here?
Profit after fees, divided by the selling price. Labor counts as a cost, so profit is what is left after paying yourself the rate on Setup.