Monthly performance pack
Harbourline Coffee Ltd
July 2026
Reviewed & signed · 4 August 2026Takings
£145,000
▲ 4.7% vs June
Transactions
16,590
▲ 2.5% vs June
Avg transaction
£8.74
▲ 2.1% vs June
Labour ratio
27.4%
▼ 0.9 pts vs June
Net takings per site from the POS export. Open marker June, filled marker July.
- June
- July
Airside added £3,744 of the group's £6,550 gain — 57% of the growth, from the smallest site. Strip it out and the group grew 2.3%, not 4.7%; that is the number to hold on to when terminal traffic drops back after August.
All four sites summed, one point per trading day. Vertical axis starts at zero.
Saturday 11 July was the best day of the month; the dip on Monday 20 July matches the closure of the Station Road counter for refit.
Gross pay from the payroll register over net takings, by site.
Old Mill runs 2.1 points above the group — £713 of July pay above what the group ratio implies. The other three sit within 0.3 points of each other, so this is one rota rather than a group-wide drift.
POS category totals for July, share of £145,000.
- Coffee & drinks · £81,200
- Food · £47,850
- Retail & beans · £15,950
Checks — the numbers reconcile
POS takings equal card takings plus cash banked
£131,220 + £13,780 = £145,000
Card settlements on the statement equal card takings less processor fees
£131,220 − £1,373 (1.05%) = £129,847
Payroll debits on the statement equal net pay on the register
£39,730 gross − £8,223 deductions = £31,507
Takings of £312 on 14 July had no matching deposit at month end
In transit at 31 July · cleared 2 August
Sources — 3 files, one join
daily_sales_by_site_JUL26.xlsx
POS export — one row per site per day, category totals on a second sheet
Arrived 1 Aug
payroll_register_2026-07.csv
Payroll register — gross pay, deductions and net by employee and site
Arrived 2 Aug
statement_45671_jul.csv
Business current account — settlements, deposits and payroll debits
Arrived 2 Aug
Joined on site code and date. Computed by recipe v3 — frozen 12 May 2026, unchanged since — so July is calculated by exactly the code that calculated June. No cost-of-sales source is connected, which is why this pack claims nothing about margin.
Appendix — by site
| Site | June | July | Change | Payroll | Labour |
|---|---|---|---|---|---|
| Harbour Street | £46,930 | £48,210 | +2.7% | £12,940 | 26.8% |
| Station Road | £40,120 | £41,876 | +4.4% | £11,210 | 26.8% |
| Old Mill | £33,650 | £33,420 | −0.7% | £9,870 | 29.5% |
| Airside | £17,750 | £21,494 | +21.1% | £5,710 | 26.6% |
| Group | £138,450 | £145,000 | +4.7% | £39,730 | 27.4% |
Harbourline Coffee Ltd · July 2026 · prepared by Meridian Bookkeeping
Built with Databoat
Commentary
Group takings for July were £145,000, up 4.7% on June and the strongest month this year.1 Three of the four sites grew, led by Airside at +21.1% as summer traffic returned to the terminal; Old Mill slipped 0.7%, its second consecutive soft month. The pattern within the month was steady, with the usual Saturday peaks and a quiet third Monday.2
Payroll for the month was £39,730, and the group labour ratio improved to 27.4% of takings against 28.3% in June. Old Mill is the outlier at 29.5% — takings dipped while the rota did not move, which leaves £713 of July pay above what the group ratio implies. That is the one thing worth settling before the August schedule is set.3
Coffee and drinks held at 56% of sales, with retail beans reaching 11% — the highest share since the range launched.4 Card settlements and cash deposits reconcile to the POS exactly, after £1,373 of processor fees; £312 of takings from 14 July was in transit at month end and cleared on 2 August.✓
Drafted by Databoat from the computed figures, then edited and signed by Meridian Bookkeeping. Each citation links the sentence to the figure behind it.