FREE WORKBOOK
13 Week Cash Flow for Hospitality
Weekly takings scaled by your own seasonality index, with payroll, the VAT quarter and the rent quarter on their real dates, and actuals against forecast.
Join dozens who use this
Who this workbook is for
Anyone whose quiet months pay the busy months’ taxes
The VAT earned in the loud quarter falls due in the quiet weeks after it, and the rent quarter does not read the calendar either. On the demo quarter the low point is week one itself, the rent landing on the quietest index of the year, which is exactly the kind of thing this sheet names in advance and averages hide.
Anyone forecasting on the average week
A venue that averages 620 covers might never have a 620-cover week. The index row scales every week’s takings, 0.86 to 1.12 on the demo, and the supplier lines scale with it while payroll and rent hold still, which is the honest shape of a seasonal quarter. Writing your own index down from last year’s tills is an afternoon that upgrades every forecast after it.
Anyone who wants the discipline, not just the spreadsheet
Each Monday the real bank balance goes on the actuals row inside the Weekly Close, the variance shows while it is a week old, and the sheet rolls forward one week. Weeks forecast below your buffer are flagged, and the buffer conversation happens while it is a planning problem rather than an overdraft conversation.
