FREE WORKBOOK
Hospitality Bookkeeping Template
Four weeks of takings to a monthly P and L with the three splits that matter: food against drink, card against cash, and sales against tips.
Join dozens who use this
Who this workbook is for
Anyone whose food and drink are one number
Mixed together they hide each other: the demo venue runs food at 68 per cent GP and drink at 72, and a single takings line would show neither. The wet and dry split is the first thing a hospitality accountant looks for in a new client’s books, and this template starts there.
Anyone whose P and L still contains VAT or tips
Takings arrive VAT-inclusive; profit is measured without it, so the sheet strips a sixth on its way to the P and L line. And tips are never your revenue: they sit in the takings block so the card reconciliation works, then pass to the tronc records without ever touching sales or profit. The template is built so that raising the tips line moves neither.
Anyone whose accountant asks the same questions every quarter
Week by week, the demo month lands on a £10,429 operating profit with every line the accounts actually need: purchases split wet and dry, wages with on-costs, the fixed base. Feed it from the Daily Takings and Cash-Up Sheet, close it with the Weekly Close Checklist, and the year end becomes an assembly job instead of an excavation.
