Financial Dashboard for Trade Businesses UK — The 5 Numbers Every Tradesperson Should Track Weekly (2026)

Most tradespeople are busy people. The diary is full, the phone doesn't stop, and there's always another job to quote, another invoice to chase, another material run to make. Financial awareness gets pushed to “when I get a minute” — which usually means never, or once a year when the accountant files your return.

The problem with that approach is that you end up making decisions blind. Taking on more jobs without knowing if your margins are holding. Accepting work from slow-paying customers without knowing how stretched your cash actually is. Growing your business without being able to see whether that growth is making you money.

You don't need to become an accountant. You need five numbers, tracked once a week. Here they are.

The weekly financial dashboard: the 5 numbers that matter

1. Weekly revenue billed — total invoice value sent this week
2. Cash position — what's in the business bank account right now
3. Debtors — total outstanding invoices, broken by age
4. Pipeline value — total value of quotes sent but not yet accepted
5. Gross margin on completed jobs — average margin on jobs finished this month

Together these five numbers tell you what you've earned, what you actually have, what you're owed, what you might earn, and whether your pricing is working. They're your early warning system and your performance scoreboard in one.

How to track without an accountant

Even a simple spreadsheet updated weekly with these five numbers is transformative compared to not tracking at all. A tab per week, five cells, five minutes. Over time that record becomes genuinely valuable — you can see trends, spot problems early, and know instantly where things stand.

Better still: accounting software like Xero or QuickBooks has dashboards that surface most of these automatically, as long as you're raising invoices and recording costs in the system. If the data is in, the numbers come out.

Best of all: job management software like Trade2Base links revenue to specific jobs and customer sources, so you can see not just what you've earned but which types of work and which customers are driving it. That's when the numbers become genuinely strategic.

Number 1: Weekly revenue billed

This is the total value of invoices you sent this week. Not cash received — invoices raised. It measures your output as a business: have you done the work, completed the jobs, and sent the paperwork?

To make this number meaningful, set a weekly revenue target. Take your annual revenue target and divide by 48 — that allows four weeks off for holidays, illness, and bank holidays. If your annual target is £120,000, your weekly revenue target is £2,500. Track actuals against that target every week without exception.

If you're consistently below target, there are only two possibilities: you don't have enough jobs, or you're not invoicing the jobs you've completed promptly enough. Both are fixable — but you need to know which it is. And don't confuse invoiced with received. You've earned that revenue and it should appear in your numbers, but the cash isn't in your account yet. That leads us to number two.

Number 2: Cash position

Check your business bank balance every Monday morning before you do anything else. Write it down. That number — and the direction it's trending — is one of the most important things you can know about the health of your business.

The trend matters more than any individual week. Is your cash balance growing over the past month? Broadly flat? Declining? A growing balance with solid invoicing means the business is generating and retaining money. A declining balance despite solid invoicing is a red flag: your debtors are rising, meaning you're doing the work but not collecting the cash.

Cash goes down when you pay for materials before you invoice — a timing issue that's normal in trades. The way to manage it is to build a float: aim for at least four to six weeks of operating expenses sitting in the account at all times. That float is your buffer against slow-paying customers, unexpected costs, and quiet periods.

If you don't have that buffer yet, build it deliberately: resist drawing everything that lands, build the reserve over six to twelve months, and then maintain it as a standing rule.

Number 3: Debtors (money owed to you)

Your debtors figure is the total value of invoices that have been sent but not yet paid. It's money you've earned but haven't received. Most accounting software can generate an aged debtors report in seconds — run one every week.

Break the total into three buckets:

• Current (0–30 days): within your payment terms — normal, no action needed yet
• Late (31–60 days): outside terms — these need an active chase this week
• Seriously late (60+ days): a problem — escalate, consider a formal letter, stop taking new work from that customer

A useful metric to track monthly is your DSO — Days Sales Outstanding. The formula is: (total debtors ÷ annual revenue) × 365. If your annual revenue is £100,000 and you have £12,000 outstanding, your DSO is 44 days. Target under 30 days. Over 45 days means you have a structural cash flow problem — customers are routinely paying you well outside your terms and you're funding the gap.

Number 4: Pipeline value

Pipeline is the total value of quotes you've sent that haven't yet been accepted or declined. It's your near-future revenue indicator — not guaranteed, but indicative of what's coming.

To make the number useful, apply your historical conversion rate. If you typically win 60% of the quotes you send, then a £40,000 pipeline represents roughly £24,000 of expected future revenue. Track that expected value week to week alongside your actual revenue.

The rule of thumb: if your pipeline drops below two to three months of revenue, it's time to increase marketing activity. Not next month — now. There's typically a lag of four to eight weeks between increasing marketing effort and seeing new jobs booked, so by the time you can see the quiet period in your diary, it's often too late to fill it easily. Pipeline is your early warning signal.

Number 5: Gross margin on completed jobs

For each job you complete, calculate gross margin: (invoice value − materials cost − direct labour cost) ÷ invoice value × 100. Track the average across all jobs completed in the month.

As a concrete example: a £3,000 job with £800 of materials and £600 of direct labour gives you £1,600 of gross profit and a gross margin of 53%. That's healthy.

Target ranges by trade:

• Electricians: 45–65% gross margin
• Plumbers: 40–60% gross margin
• Builders and groundworkers: 30–50% gross margin

If your margins are declining month on month, your costs are rising faster than your prices. Materials inflation, subcontractor rate increases, jobs taking longer than quoted — any of these erode margin silently over time. Tracking gross margin monthly means you catch it early, when you still have pricing power to respond. Wait until your accountant tells you at year end and you've absorbed twelve months of margin compression.

The monthly review

Once a month, step back and look at all five numbers over the past four weeks. Are they moving in the right direction? Are there patterns you wouldn't spot in a single week?

Add two more numbers at the monthly level:

• Net profit: gross profit minus all overheads — van, insurance, phone, subscriptions, advertising. This is what you actually made.
• Tax provision: set aside 25–30% of net profit for tax as you go. Don't wait until January to discover you owe HMRC money you've already spent.

If you have data from last year, compare the same month. Revenue up or down? Margins holding? This kind of year-on-year comparison is where patterns become really visible — seasonal dips, growth trends, the effect of a price increase you made in March.

The quarterly review: where is the business going?

Four times a year, spend an hour on the bigger picture. The weekly and monthly numbers tell you how you're doing right now. The quarterly review tells you where the business is heading.

Five questions to answer every quarter:

1. Revenue trend: is turnover growing, flat, or declining compared to the previous quarter and the same quarter last year?
2. Margin trend: is your gross margin holding, improving, or compressing? If it's compressing, what's driving it?
3. Cash position: is your float building or drawing down? A business that's growing revenue but seeing its cash shrink has a cash flow management problem that needs addressing before it becomes a crisis.
4. Which customers and job types are most profitable? Not just highest revenue — highest margin. A £5,000 job at 55% margin is worth more than a £8,000 job at 25% margin. Know which work you want more of.
5. Where did the best jobs come from? Referrals, Google, repeat customers, lead platforms? Knowing your best source of profitable work lets you double down on it rather than spreading budget thinly across everything.

Five numbers, five minutes a week

None of this requires a financial qualification. It requires consistency: the discipline to update five numbers once a week, every week, whether it's a good week or a bad one. Over time that habit compounds. You develop instincts about your own business that you simply can't develop any other way — you'll notice something feels off before you can articulate why, because the numbers have trained your eye.

The tradespeople who run the most resilient businesses aren't always the most skilled technically. They're the ones who know their numbers, act on them quickly, and never find themselves surprised by their bank balance or their tax bill. That's a learnable habit. Start this Monday.