01
Subcontractors tab for up to 100 subcontractors
With UTR, CIS status, verification number and date, plus totals paid, deducted and net for the tax year
For UK building contractors & bookkeepers
7 reasons to stop working out CIS deductions by hand
Paying subcontractors under the Construction Industry Scheme? Every month you have to take the right deduction from each payment, total it all up for the CIS300 return by the 19th, pay HMRC by the 22nd and give each subcontractor a payment and deduction statement. This tracker does the sums and keeps the record.
- Excel & Google Sheets, no macros
- Example + blank file
- Start-here guide
- One-off price, no subscription
Screens from the included example file. All names and figures are fictional.
100subcontractors
2,000payments
20 · 30 · 0%deduction rates for 2026/27
0macros, add-ons or subscriptions
The list
Why a ready-made tracker beats paper and a blank spreadsheet
02
Payments log for up to 2,000 payments
Enter gross ex VAT, materials and VAT, and the deduction (rounded down to the penny, or nearest penny), net pay and tax month are worked out
Get the tracker · £12.99 Instant download · Excel & Google Sheets
03
Status override, so a status change during the year does not change past…
…deductions
Monthly Returns
The totals for each CIS300 return, the return and HMRC payment due dates, and Filed / Overdue / Paid statuses once you record them
Payment and deduction statement
Pick a subcontractor and tax month, then print or save as PDF
Flags missing statuses, bad UTRs
Unverified or duplicate subcontractors, unknown names, text in date or amount cells and materials above gross
Dashboard with tax year totals
The next return due, a top 10, four charts and a "What needs your attention" list
Get the tracker · £12.99 Instant download · stuck? Email us for help
Compare
Three ways to keep these records
| Feature | Paper or notes | A blank spreadsheet | This tracker |
|---|---|---|---|
| Subcontractors tab for up to 100 subcontractors | ✗No | ~ If you build it | ✓ Built in |
| Payments log for up to 2,000 payments | ✗No | ~ If you build it | ✓ Built in |
| Monthly Returns | ✗No | ~ If you build it | ✓ Built in |
| Payment and deduction statement | ✗No | ~ If you build it | ✓ Built in |
| Flags missing statuses, bad UTRs | ✗No | ~ If you build it | ✓ Built in |
| Cost | Free, plus your time | Free, plus your time | £12.99 once |
What's inside
Everything you download
3 files
- XLSX UK-CIS-Contractor-Tracker.xlsxfilled with fictional example data (10 subcontractors, 158 payments) so you can see how it works
- XLSX UK-CIS-Contractor-Tracker-BLANK.xlsxan empty copy, ready for your own business
- PDF Start-here.pdfone-page quick-start guide, including how to open it in Google Sheets
Also included
- Start Here tab with a 3-step plan and a health check
Good to know
- A Health check on the Start Here tab and a Check/Status column on every log flag missing or odd entries
- Dates show as DD/MM/YYYY; tax months run from the 6th to the 5th
Is it right for you?
Made for some, honestly not for others
A good fit if you…
- UK building contractors and bookkeepers under the GOV.UK CIS rules for 2026/27: 20% for registered subcontractors, 30% for unregistered and 0% with gross payment status, worked out on the payment less VAT and the materials the subcontractor paid for
- use Excel or Google Sheets on a computer
- want to pay once, not another subscription
Not for you if you…
- need Apple Numbers or mobile-only editing
- want someone to do the records for you
How it works
Three steps to get going
- 1
Set up once
Your name, employer reference and tax year on Settings (CIS rates are filled in)
- 2
Add each subcontractor with the CIS status HMRC gave you
- 3
Log every payment
File and pay from Monthly Returns and print each Statement.
Microsoft Excel2010 or newer (Windows & Mac) and Microsoft 365
Google SheetsFree Google account. Upload the .xlsx, then set the locale to United Kingdom
0
No macrosNothing to enable, no add-ons or subscriptions. Not designed for Apple Numbers or mobile-only editing. A computer is recommended
- Instant download
- Example + blank file
- Start-here guide
The offer
Ultimate UK CIS Contractor Tracker
£12.99one-off · no subscription
- Filled with fictional example data (10 subcontractors, 158 payments) (UK-CIS-Contractor-Tracker.xlsx)
- An empty copy, ready for your own business (UK-CIS-Contractor-Tracker-BLANK.xlsx)
- One-page quick-start guide, including how to open it in Google Sheets (Start-here.pdf)
- Licensed for use within one business or household
Price includes VAT where applicable — calculated at checkout. Secure checkout by Payhip.
14-day money-back guaranteeIf the template doesn't work for you, email info@phkmedia.co.uk within 14 days of purchase and we'll refund you in full — no hoops.
Questions? Email info@phkmedia.co.uk
Stuck after you buy? We'll help you set it up.
Digital download, nothing is posted. This tracker is a record-keeping and calculation aid, not tax advice. Terms & licence.
Bundle
Also in 2 bundles with related tools
Employer Complete BundleIt's Monday, someone has called in sick, a new starter needs a right to work check, the tronc is due and the fire alarm test was last week, or was it?
£84.99£137.90 one by one
Construction & Trades BundleSubbies to pay with the right CIS deduction, a new labourer starting Monday, a van MOT due, a near miss on site and a snag list for the handover.
£36.99£59.95 one by one
14-day money-back guarantee
If the template doesn't work for you, email info@phkmedia.co.uk within 14 days of purchase and we'll refund you in full — no hoops.
Full policy in our Terms.
FAQ
Questions people ask
Does it file my CIS300 or verify subcontractors?
No. You do both through HMRC online services or your software; this gives you the figures and statements.
Does it cover quarterly payments, credit notes, reverse-charge VAT or the CITB levy?
No.
Can my bookkeeper use it?
Yes, in Google Sheets you can share it.
What if it doesn't work for me?
You're covered by our 14-day money-back guarantee. If the template doesn't work for you, email info@phkmedia.co.uk within 14 days of purchase and we'll refund you in full — no hoops.
What happens after I pay?
This is a digital product. Nothing physical will be shipped. Your download link appears straight after checkout and is also emailed to you.
Can I get help if I'm stuck?
Yes. Message us at info@phkmedia.co.uk and we'll help you set it up.