Excel + Google Sheets
Small Business Bookkeeping
Small business bookkeeping spreadsheet for Google Sheets and Excel: price each product from its real material and labor cost, track materials, stock and orders, make invoices and see your profit.
Run the whole product side of your business from one file: what things cost to make, what you charge, what's in stock, who ordered, and what you owe at tax time. Made for makers and small shops that need real bookkeeping without accounting software.
Coming to Etsy this week
Instant download on Etsy: Excel files plus a link to your own Google Sheets copy.
What’s inside · 13 tabs
- Welcome: Quick start
- Business Dashboard: Your business at a glance. Big KPI cards, donut and bar charts
- Order Setup: Business name, currency, tax rate, payment terms, tax set-aside %, and your materials and products with their prices
- Product Recipe: Up to 4 materials per product with the quantity per unit, so its true material cost is calculated
- Price Worksheet: Materials, labor, equipment and other costs give you the selling price, net price and profit per unit at your margin, plus wholesale and break-even
- Materials Inventory: Stock = purchases arrived − what your recipes used; status, value and a purchase log
- Products Inventory: What you made − what you sold, with stock value and how many more you can make right now
- Order Tracker: Every invoice with customer, channel, item and qty; tax, total, balance and paid / partial / unpaid status calculate
- Invoice: Pick an invoice number and the header, dates, prices and totals fill in
- Customer Tracker: Who buys from you, with orders, total spent, last order and VIP calculated from your orders
- Order Overview: 6 months of invoices, payments and restock spend, plus to-dos that flag low stock and unpaid invoices
- Sales Overview: Units, revenue, material cost and margins per product and per sales channel
- Tax & Fiscal: P&L by month, an expense log, deductibles, cash flow and how much to set aside for taxes
Features
- Visual Business Dashboard tab: big KPI cards (revenue, expenses, net profit, net margin, tax set-aside), donut and bar charts by product and sales channel that update from your entries
- True cost per product from its materials: pricing stops being a guess
- Inventory that talks to your orders, so you don't sell what you can't make
- Invoices without a second tool
- Currency picker, your own tax rate and set-aside %, reusable year after year
- Excel AND Google Sheets versions, both in this listing
- Every formula tested before publishing
You’ll need
- Microsoft Excel 2016 or newer (desktop; Microsoft 365 not required) or a free Google account for the Google Sheets version.
- Best on desktop or laptop.
More in Small Business
