How to track quarterly tax payments and cash flow UK sole trader
Updated 2026-11-08Introduction
If you're a self-employed freelancer or run a side-hustle, unexpected tax bills can throw a spanner in the works. Keeping an eye on quarterly tax payments, National Insurance Contributions (NICs) and cash flow doesn't have to be a mystery. This guide shows you how to set up a simple spreadsheet that meets the legal framework and helps you stay on top of your finances.
Understand the key tax dates and rules
- The UK tax year runs from 6 April to 5 April. check GOV.UK for the current rules.
- Your online Self Assessment return and any payment are due by 31 January after the end of the tax year. check GOV.UK for the current rules.
- Making Tax Digital (MTD) for Income Tax applies to sole traders with qualifying income:
- Over £50,000 you must use MTD from 6 April 2026.
- Over £30,000 you must use MTD from 6 April 2027.
- Over £20,000 you must use MTD from 6 April 2028.
- You must use HMRC-compatible software; a spreadsheet alone is not sufficient, but it can sit alongside "bridging" software. check GOV.UK for the current rules.
Why a spreadsheet can still be useful
Even though HMRC-compatible software is required for filing, a spreadsheet remains a powerful tool for: 1. Consolidating income, expenses and NICs in one view. 2. Projecting quarterly payments based on your estimated profit. 3. Visualising cash-flow gaps before they become a problem.
Setting up your tax-tracker spreadsheet
Below is a practical layout you can copy into Excel, Google Sheets or any similar programme.
1. Create the main tabs
| Tab | Purpose |
|---|---|
| Income | Record every invoice, date, client and amount. |
| Expenses | Log business costs, categorize (e.g., travel, software, office). |
| NICs & Tax | Calculate Class 2 and Class 4 NICs, and Income Tax based on profit. |
| Cash Flow | Show month-by-month opening balance, inflows, outflows and closing balance. |
2. Income tab - columns to include
- Date of invoice
- Client name
- Invoice number
- Amount (incl. VAT if you're VAT-registered)
- Received? (Y/N)
- Payment date
3. Expenses tab - columns to include
- Date
- Supplier
- Category (travel, equipment, software, etc.)
- Net amount
- VAT reclaimed (if applicable)
- Total cost
4. NICs & Tax tab - formulas
- Profit = Total Income - Total Expenses
- Class 2 NICs - flat rate (£3.45 per week for 2024-25). Multiply weekly rate by weeks in the tax year.
- Class 4 NICs - 9% on profits between £12,570 and £50,270, then 2% above that threshold.
- Income Tax - use the appropriate rates for your profit band (basic, higher, additional).
- Quarterly payment - divide the total tax and NICs due by four. Remember to adjust the thresholds each year; check GOV.UK for the current rules.
5. Cash Flow tab - layout
| Month | Opening Balance | Income | Expenses | Tax & NICs (quarterly) | Closing Balance |
|---|---|---|---|---|---|
| Apr | =previous month closing | =SUM(Income!C:C for month) | =SUM(Expenses!C:C for month) | =IF(month is quarter end, NICs&Tax!Quarterly, 0) | =Opening+Income-Expenses-Tax |
Step-by-step: Using the spreadsheet each month
- Enter every invoice as soon as you issue it. Mark it "Received?" when the payment hits your bank.
- Log every expense with a receipt attached (digital copy works for HMRC records).
- Update the NICs & Tax tab at the end of each month - the formulas will recalculate profit and the quarterly estimate.
- Check the Cash Flow tab to see if you have enough buffer for the upcoming quarterly payment.
- When a quarter ends, note the amount due and set aside the cash in a separate account.
Bridging software and HMRC-compatible tools
Because HMRC requires you to file through compatible software, you can use a low-cost solution (e.g., FreeAgent, QuickBooks Online, or Xero) to submit your figures. Keep your spreadsheet as a "working document" and export the totals into the software each month. This satisfies the legal requirement while giving you the flexibility of a custom tracker. check GOV.UK for the current rules.
FAQ
Q1: Do I need to use MTD if my income is below £20,000? A: No, the thresholds start at £20,000 for the 2026-27 tax year. check GOV.UK for the current rules.
Q2: Can I rely solely on a spreadsheet for filing? A: No, filing must be done through HMRC-compatible software. The spreadsheet is for planning only. check GOV.UK for the current rules.
Q3: How often should I review my cash-flow forecast? A: At least once a month, and again before each quarterly payment date.
Q4: What if my profit estimate changes mid-year? A: Update the NICs & Tax tab; the quarterly figure will automatically adjust.
A quick shortcut
If you prefer not to build the sheet from scratch, the Quarterly Tax Forecast & Cash-Flow Tracker template does all the above set-up for you. At £9.99 it saves time and ensures the required columns and formulas are ready to use, letting you focus on your business rather than spreadsheet mechanics.