Home Bakery Job Profit & Bookkeeping Tracker (Excel & Google Sheets)

A simple spreadsheet for home bakery owners who want to know which orders actually make money — and keep tidy records of money in, money out and business miles. No subscription, no app.

What's inside

• Jobs tab: date, client, order type (cookies, cupcakes, custom cake, bread, market day, other order), amount charged, ingredients + packaging, labor hours, miles and other costs → labor cost, mileage cost, total cost, profit, margin % and profit per labor hour for every order.
• Income & Expenses log with category dropdowns (sample expense categories: ingredients, packaging, equipment, permits/fees, market booth fees, marketing, utilities share, delivery/fuel, card fees — edit them in Settings).
• Mileage log: start/end odometer or miles, value at the rate you choose.
• Dashboard: month-by-month income, expenses, net, order count, order revenue and profit, average profit per order, miles and mileage value; yearly totals by category; an income-vs-expenses chart.
• Instructions tab, sample rows to show how it works, 300 rows per log, yellow input cells and locked formula cells.

Real screenshots (sample data)

Dashboard: monthly income, expenses, net, jobs, job profit, miles + chart (sample data)

Jobs tab: per-job profit, margin and profit per labor hour (sample data)

Income & Expenses log with categories (sample data)

Mileage log (sample data)

What you get

Home-Bakery-Profit-Bookkeeping-Tracker.xlsx and a 2-page PDF quick-start guide (includes Google Sheets import steps).

$19

Instant download (.xlsx + PDF quick-start guide). Works in Excel, Google Sheets and LibreOffice.

Record-keeping tool only — not tax advice (and not accounting, legal or financial advice). It does not calculate taxes or deductions. Ask a tax professional what you can deduct and which records you must keep.

Opening it in Google Sheets

Google Drive → New → File upload → open the .xlsx → File → Save as Google Sheets. The formulas (SUMIFS, COUNTIFS, MONTH, YEAR, IF) and dropdowns carry over. If the chart doesn't convert cleanly, select Dashboard A4:C16 and Insert → Chart. Sheet protection is an Excel/LibreOffice feature; in Sheets just type only in yellow cells. Excel and LibreOffice open it directly.

Try the math first: free home bakery order profit calculator. Other trades: cleaning · lawn care · pressure washing