All-in-One Product Business Template xlsx

Run your entire product business from one file
If you make and sell physical products, you already know the mess. Stock counts in one spreadsheet, sales in another, a notebook for orders, and no real idea what each product earns you once the fees come out. This template ends that. It is a single file with 24 tabs that behave as one system, built for candle and soap makers, bakers, crafters, resellers and anyone who buys materials, makes things and sells them.
The engine is simple. Three tabs move your stock and everything else reads from them. Purchases bring materials in. Production turns materials into finished products using recipes you define once. Sales take products out, deduct stock and work out your true profit on every line. You never update a stock count by hand again.
What is inside
• Stock and making: Inventory, Stock Log, Stock Take, Recipes, Production
• Money in: Sales, Invoice, Receivables, Clients, Pricing Calculator
• Money out: Purchases, Suppliers, Expenses, Payroll, Commissions
• Planning: Dashboard, Tasks, Calendar, Monthly Report, 12-Month View, Custom Comparison
• Plus a Settings tab that controls every dropdown, and a Start Here tab that walks you through setup
The features that matter
• Automatic cost of goods and profit on every sale, priced from your live average costs
• Recipe costing: list what goes into one unit and your product cost updates the moment a material price changes. Gift sets can even use finished products as ingredients
• Low stock and out of stock alerts at minimum levels you choose, per item
• A printable invoice that fills itself in from your business details and price list
• Receivables aged into 0 to 30, 31 to 60, 61 to 90 and 90+ day buckets, so you know exactly who to remind first
• Payroll that pulls each person’s rate, overtime multiplier and commission from one setup tab
• A calendar that fills itself with invoice due dates, supplier payments and open tasks. No manual entry, ever
• A break-even calculator that tells you how many units a month keep the lights on
• Monthly profit goals and a 12-month chart so the year stays in view
• Colour coded throughout: blue text means type here, black means automatic, yellow cells are quick controls
You also get a worked example
The file ships with a small fictional candle business already inside it: six months of sales, production batches, purchase orders, two overdue invoices and a restock in progress. Click around, change a number, watch what moves. When you are ready, clear the sample and add your own data. The included guide shows you how.
Works where you work
Microsoft Excel 2019, 2021 or 365, on Windows or Mac. Google Sheets on any device, free: upload the file to Drive, open it, then choose File and Save as Google Sheets. Every formula in the file was chosen to behave the same way in both, and changing the currency takes two minutes.
What you receive
• The spreadsheet (.xlsx) with over twelve thousand formulas already in place
• A six page User Guide (Word document) that takes you from download to a running system in one sitting
• Instant download after checkout. No subscription, no monthly fee, yours for good
Setup takes about fifteen minutes. The Start Here tab lists the steps in order and the guide walks through each one in plain language.
Please note: this is a digital download. Nothing will be shipped. Due to the nature of digital files, all sales are final, but if anything is unclear or not working as described, get in touch and we will sort it out.