Guy Thomas Evans

Finance

Know the month while you can still change it.

In my own business I found out how a month had gone weeks after it ended. I set up a few plain sheets that tell you sooner: cash ahead, the margin on each job, and a month closed in days.

Closer in

i. Cash

Cash you can see coming.

Thirteen weeks of money in and out, a column a week, rolled forward every Monday. Penhallow’s tight week is in January, when the VAT bill lands in the Christmas shutdown. It showed up in November, with time to talk to the bank.

Cash at the end of each week, £000

Specimen · Penhallow, fictional

Penhallow Fabrications Ltd, a fictional company: cash at the end of each of the thirteen weeks from 23 November, in thousands of pounds: 23 Nov, 15; 30 Nov, 15; 7 Dec, 21; 14 Dec, 26; 21 Dec, 10; 28 Dec, 5; 4 Jan, overdrawn 20; 11 Jan, overdrawn 14; 18 Jan, overdrawn 14; 25 Jan, overdrawn 6; 1 Feb, overdrawn 4; 8 Feb, 3; 15 Feb, 11. The works shut over Christmas, and the VAT quarter of £22,000 is paid the week after. The overdraft limit is £25,000. The tightest week is 4 January, with £5,000 of room.

ii. Margin

What each job really makes.

The margin on every job, from the quote and the timesheets, highest first. One margin for the year hid it: site repairs and gates lost money every time. New prices for both start on 1 December.

Gross margin on the last 18 jobs, %

Specimen · Penhallow, fictional

Gross margin on each of Penhallow Fabrications Ltd’s last 18 jobs, highest first: 1183 Balustrade, 35.4 per cent; 1192 Balustrade, 34.1 per cent; 1181 Staircase, 33.1 per cent; 1198 Balustrade, 32.8 per cent; 1186 Railings, 31.6 per cent; 1195 Staircase, 31.4 per cent; 1188 Canopy, 30.2 per cent; 1189 Staircase, 29.7 per cent; 1193 Railings, 28.9 per cent; 1187 Fire escape, 26.8 per cent; 1194 Fire escape, 24.6 per cent; 1184 Structural frame, 22.4 per cent; 1191 Structural frame, 19.8 per cent; 1196 Structural frame, 17.6 per cent; 1197 Canopy, 12.4 per cent; 1185 Gates, -4.2 per cent; 1182 Site repairs, -8.7 per cent; 1190 Site repairs, -14.6 per cent. The target is 25 per cent. Three lost money: 1185 (gates), 1182 (site repairs), 1190 (site repairs).

iii. The close

The month closed in days.

Every task between month-end and a profit and loss you trust, in order, with a name against each. Penhallow took a fortnight, every month. September closed in four working days, and October in three.

Working days to close each month

Specimen · Penhallow, fictional

Working days to close each month at Penhallow Fabrications Ltd, a fictional company, November 2025 to October 2026: 14, 15, 14, 13, 14, 15, 14, 13, 15, 14, 4, 3. After the Survey in September, September closed in 4 working days and October in 3.

iv. Seven numbers

Seven numbers, on one page.

Cash cover, margin, debtor days, the three largest customers, revenue per head, days to close and the hours only you can work. Each against its line, this month, with the one decision they ask for.

The seven numbers, October

Specimen · Penhallow, fictional

The month on one pageOctober 2026 · page 1

  1. iWeeks of cash cover1.6 weeks: past the line (the line: under 8 weeks).
  2. iiGross margin, on last year2.4 points down: past the line (the line: a fall of more than 2 points).
  3. iiiDebtor days46 days: past the line (the line: over 45 days).
  4. ivThree largest customers30 per cent: inside the line (the line: over 50 per cent).
  5. vRevenue per head£85k a head: inside the line (the line: any fall on last year).
  6. viDays to close3 working days: inside the line (the line: over 10 working days).
  7. viiHours only you can do36 hours a week: past the line (the line: over 20 hours).

Decision needed

New prices for site repairs and gates, from 1 December.

Next

Most of this starts with the Survey.

Ten working days on your own figures, and you’ll know which of these to build first.

The Business Surveyten working days

Write to meThe Business SurveySpecimensSeven numbers