UK Home Bakery Spreadsheet: Cake Pricing, Recipe Costing and Allergen Labels
Home bakery business spreadsheet for UK bakers, for Excel and Google Sheets. Cost every recipe in grams, price any cake with a cake pricing calculator, take orders with deposits and Royal Mail postage, print Natasha's Law allergen labels, and keep your registration, hygiene rating and HMRC tax in order. UK Edition.
Built for home bakers, cake makers and biscuit decorators in England, Wales, Scotland and Northern Ireland. Enter each ingredient price once and every recipe, product and quote updates. Know your real cost, charge the right price, and open the Action Board every morning to see exactly what to do next.
✅ PRICE ANY CAKE IN TWO MINUTES (Cake Builder) • Up to 5 tiers: round, square or traybake. UK tins in inches and cm, 4 in or 6 in tall. • Finger (1 x 1 in) and party (1 x 2 in) portions, plus grams of batter, buttercream and filling for every tier. Oven in °C, fan and gas mark. • Two prices side by side: by your real cost and margin, and by the portion (with tier surcharge and design fee). It recommends the higher of the two. • Decoration level, sugarpaste, toppers, drums and boxes, extra hours, delivery and set-up. • By the dozen: decorated biscuits, cupcakes and cookies, with the price per dozen and per piece.
✅ RECIPE COSTING IN GRAMS: ONE CHAIN OF COSTS • Ingredient price → recipe cost → product cost → order cost → dashboard. • g, kg, ml, l, tsp, tbsp, pints and pieces are converted for you. • Starter library ready to adjust: – 65 ingredients and packaging items with typical UK supermarket prices (Nov 2026) – 17 base recipes: Victoria sponge, buttercreams, ganache, brownies, flapjacks, mince pies, Christmas cake… – 26 products • Real product cost: ingredients, decorations, packaging and your hands-on time × (hourly rate + overhead). • Suggested price, margin, price per portion and a Price Health check for every product.
✅ NATASHA'S LAW LABELS AND THE 14 ALLERGENS • The 14 UK allergens follow every ingredient into recipes, products, orders, labels and the menu. • Label Maker, PPDS or wholesale: – name of the food and every ingredient in weight order, with the allergens in CAPITALS – your "May contain" line, net weight and best before – "Keep refrigerated" when needed, and your name and address • 10 labels per A4 sheet, 99.1 x 57 mm (Avery L7173 layout). • Smart checks: keep chilled, alcohol ABV, and "may contain nuts" wording that should name the allergen. • Printable Menu & Allergen Chart showing your food hygiene rating.
✅ ORDERS, DEPOSITS, POSTAGE AND DOCUMENTS • From Enquiry and Quoted to Booked, In Production, Ready and Completed. • Fees and charges: – deposit to book (50% by default) and balance due date – short-notice fee, local delivery by the mile and set-up – VAT when registered • Post orders: Royal Mail Large Letter, Tracked 48 / 24 and courier. The postage you charge and what it costs you are worked out, and postage comes off your profit. • Letterbox brownies, Etsy, website, cake shed and café wholesale tracked by sales channel. • Order confirmation with the allergens of every item (needed for distance orders), your terms and a signature line. • Invoice (VAT invoice once registered) that turns into a receipt once paid.
✅ STAY COMPLIANT: COUNCIL, HYGIENE RATING, SFBB • Rules for your nation: who to register with, SFBB or CookSafe, the hygiene rating scheme and whether displaying it is compulsory. • Compliance register with renewal dates and reminders, covering: – council registration and food hygiene rating – SFBB 4-weekly review and Level 2 certificate – allergen training, insurance, home insurance and mortgage / landlord permission – street trading and the ICO fee • Markets, fairs, pop-ups and cake shed: sell-through, profit and profit per hour.
✅ ACTION BOARD, DASHBOARD AND HMRC TAX • Orders due in the next 7 days, deposits and balances to collect, quotes waiting. • Also on the board: stock to reorder, cake stands out, customer birthdays and renewals. • Dashboard: revenue earned, cash received, net profit and revenue per hands-on hour. • Tax & MTD: – monthly set-aside (income tax + Class 4 NI estimate, or a fixed %) – HMRC mileage at 55p / 25p with the 10,000-mile split, and use of home at the flat rate – Making Tax Digital quarters and Self Assessment payments – income by sales channel and the £90,000 VAT check • VAT by product: most cakes are zero-rated; mark chocolate-covered biscuits as 20%.
📦 WHAT'S INCLUDED (5 files, version 1.0.1) • READY workbook (.xlsx): for your bakery, with the starter library. • DEMO workbook (.xlsx): a fictional Leeds home bakery taking Christmas orders, so you can see everything working. • Google Sheets Access (PDF): one-click "Make a copy" links to the READY and DEMO Google Sheets. • Quick Start (PDF). • User Guide (PDF, 21 pages).
🇬🇧 UK Edition: • £, grams and ml, °C / fan / gas, UK tins and portions, British English • the 14 allergens, Natasha's Law, the four nations • HMRC, MTD and VAT, tax year 6 April – 5 April A US Edition is also available.
💻 WORKS IN • Microsoft Excel 2019 or newer, Microsoft 365 (Windows and Mac). • Google Sheets (free Google account). • No macros, no add-ons, no subscription. Your data stays in your own file. • Not supported: Excel 2016 or earlier, Apple Numbers.
⚠️ GOOD TO KNOW • This is a digital download. No physical item will be shipped. • It is an organisational tool, not accounting, tax, legal or food-safety advice. It does not file anything with HMRC. • Rules differ by nation and council and change over time. Check with your council, the FSA / FSS and HMRC. • Labels are built from your recipes; check them before printing. Nutrition values are not calculated. • Pre-filled prices, recipes and products are examples to adjust.
QUICK FACTS Works in: Excel 2019+ / Microsoft 365 (Win & Mac) · Google Sheets Files: 5 (READY + DEMO workbooks, Google Sheets Access, Quick Start, User Guide) Tabs: 23, with an Action Board and Dashboard Bakery tools: Cake Builder · recipe costing · Production Plan · Label Maker · Menu & Allergen Chart UK compliance: Natasha's Law labels · 14 allergens · compliance register · four nations Tax: HMRC mileage · use of home · MTD · Self Assessment · VAT by product Version: UK Edition 1.0.1 · No macros · No subscription
BOMDOXI Pro Series: business spreadsheets built for one trade at a time. Simple tools. Smarter work.