Inventory and Bookkeeping Spreadsheet in One
The short answer
One product, tracked in one file: 63 sales at C$19.99 earn C$691.11 of profit, and 37 units worth C$240.50 stay on the shelf, counted.
An inventory and bookkeeping spreadsheet in one file keeps stock, costs and sales together, so profit is a number you can read: buy 100 units at C$6.50, sell 63 at C$19.99, and the file shows C$691.11 of profit with 37 units, C$240.50 of stock at cost, still on the shelf.
Educational information, not financial advice. The example states every price and fee it uses; your own costs and marketplace decide your real figures.
What does one product look like, tracked in one file?
Start with stock. You buy 100 units at C$6.50 each, which is C$650 of stock on the shelf. Then 63 of them sell at C$19.99 each, for revenue of C$1,259.37. On each sale, Etsy fees take C$2.52: a transaction fee of C$1.30, payment processing of C$0.85, a regulatory fee of C$0.10 and the listing fee at C$0.27.
| Line | Amount |
|---|---|
| Stock bought | 100 units at C$6.50 = C$650.00 |
| Units sold | 63 at C$19.99 |
| Revenue | C$1,259.37 |
| Etsy fees per unit | C$2.52 |
| Net per unit after fees | C$17.47 |
| Profit per unit after cost | C$10.97 |
| Total profit on 63 sales | C$691.11 |
| Stock left | 37 units, C$240.50 at cost |
Kept in two places, those numbers drift apart: the stock count lives in one notebook, the sales in a marketplace export, and the profit becomes a feeling. In one file, each sale lowers the stock count and adds its own profit line at the same moment, so the shelf and the books can never quietly disagree. At any point you can answer both questions a small seller actually asks: what do I have, and what did it make me?
What does the workbook keep together?
The Inventory Tracker & Bookkeeping Spreadsheet is built around that one-file rule:
- Inventory and bookkeeping in one place: stock, costs and sales recorded together, not in separate files.
- A filled sample workbook ships with it, so you see the system working before you load your own products.
- Profit per product read as a number, built from each sale's price, fees and unit cost.
- A running stock value at cost, so the money sitting on your shelf is always visible.
It is a close cousin of the Etsy profit tools in this batch: sellers whose main gap is fees and recipe costs, rather than stock counts, will find the narrower tool on our sellerboard alternative page. This workbook is the one that adds the shelf to the books.
Who is this for, and who should skip it?
This fits a small seller who holds physical stock and currently tracks it apart from the money, in notes, exports or memory. Skip it if you sell digital products or made to order items with no shelf stock: the inventory half has nothing to count. Skip it, too, if your stock runs into the thousands of units across warehouses. At that scale you need dedicated inventory software, and a spreadsheet will slow you down instead of helping.
FAQ
Does one file really hold both stock and sales? Yes. Each product carries its unit cost and its stock count in the same workbook that records its sales. A sale updates both sides at once, which is the whole point: the count and the profit come from the same record.
How is profit per unit worked out? Sale price minus the marketplace fees on that sale, minus the unit cost. In the example: C$19.99 minus C$2.52 of fees minus C$6.50 of cost leaves C$10.97 of profit on each of the 63 sales.
What does the sample workbook show? A filled shop, with products, costs and sales already entered, so you can trace how a sale moves the stock count and the profit before you enter anything of your own. Learn on the sample, then start your own file clean.
Can it track more than one marketplace? The bookkeeping side records sales with their fees, so you enter each sale's own fee figures. The worked example uses Etsy fees because that is where the example shop sells; a sale from elsewhere carries its own costs.
What if the file does not work for us? Digital downloads are not refunded, and that is stated before you buy. The fix-it promise stands in its place: if the file will not open or a formula is broken, we fix it or replace it until it works. Write to us with what broke and we repair the workbook.
How the numbers were run
Revenue is 63 times C$19.99. Fees per unit use the Canada Etsy rates: 6.5% transaction, 3% plus C$0.25 processing, 0.50% regulatory, and the listing fee at about C$0.27, each rounded to the nearest cent. Net per unit is the price minus fees; profit per unit subtracts the C$6.50 unit cost; totals multiply by the 63 units sold. Stock left is 37 units times the same unit cost.
About Kollaz
Kollaz: Smart financial tools for modern money. We build spreadsheets that answer real money decisions with real math. Browse the shop: etsy.com/shop/kollaz. Get the spreadsheet: Inventory Tracker & Bookkeeping Spreadsheet.