Bookkeeping and P&L Spreadsheet for Bakeries and Home Bakers

Bakers price by feel, then wonder where the money went. Butter, eggs, decorations, boxes and market fees rise and fall with the seasons, and custom cakes, everyday bakes and wholesale behave very differently. You need ingredient cost % and profit per order.

This workbook is set up for bakeries and home bakers. It has 6 income categories (Custom cakes, Cupcakes & dessert boxes, Bread & everyday bakes, Wholesale to cafés & shops, Farmers' market sales, Baking classes) and 12 expense categories (Flour, sugar & dry goods, Dairy, eggs & butter, Decorations & fondant, Boxes, boards & packaging, Kitchen rent & utilities, Equipment & bakeware, Market stall fees, Permits, licences & food safety, Delivery fuel, Helper wages, Website & ordering platform, Insurance), each with a note on what goes there, plus spare lines for your own. Fees kept by your card processor or platform are entered next to each sale and reported as their own expense line (card & online-ordering fees).

The Monthly P&L totals every category by month, then shows net profit, margin, a tax set-aside at the rate you choose and your monthly orders fulfilled. The Dashboard compares any month with the year to date and tracks 5 trade KPIs against your targets: ingredient cost % of revenue; average order value; packaging cost per order; custom cake share of revenue; market fees % of market sales. The Annual Summary gives quarterly totals, your best month, the largest cost and the receipts still missing.

Included: a worked-example copy filled with a fictional bakery year, a blank copy, and a 6-page quick-start guide in US Letter and A4 (category map, KPI guide, worked example, tips for the trade). 7 sheets, 6,710 formulas, room for 1,000 income and 1,500 expense entries a year.

General information, not tax or accounting advice.