Bakery Order Tracker and Market Stall Takings Log UK

Run your cake orders, your weekly bake list and your market stall from one spreadsheet, in pounds, for UK home bakers and market traders.

Type in each order: customer, product, servings, price, deposit, collection date and time, status and allergen notes. The balance and the deposit still due work themselves out. A This week sheet gives you a printable bake list for the next 7 days with total servings, and a calendar shows which days are full.

On market days, record the pitch fee, cash, card, and what you took and sold of each item. You get leftovers, card fees, takings, profit after the pitch fee and ingredients, and the best seller. The Monthly summary shows orders, deposits outstanding, top products and your best market.

Included:

• Settings, Orders (300 rows), This week, Calendar, Market days, Stall stock, Monthly summary
• Two .xlsx files: a made-up home cake maker with 25 orders and 6 market days, and a blank copy
• Works in Excel 2016 or later and Google Sheets. No macros.

A free-text allergen field is on every order, but the sheet cannot check allergens: the baker must. A record-keeping aid, not tax, accounting or food safety advice.