I will build excel or google sheets job and invoice trackers for UK trades
About this Gig
I build Excel and Google Sheets job and invoice trackers for UK tradespeople and small shops, such as plumbers, electricians, builders and retailers.
You get a clear, working spreadsheet instead of a pile of paper. Typical builds:
- Job and invoice tracker with VAT at 20%, 5% or 0%, paid, due and overdue status, and a summary dashboard
- CIS subcontractor payment log with 20% or 30% deductions and monthly totals
- Income and expense log laid out to make Making Tax Digital record-keeping easier
- Stock tracker with reorder alerts
Everything is set up for the UK: £, DD/MM/YYYY dates, drop-down lists and formulas that do the sums for you. I also fix or tidy an existing sheet.
I am a UK-based IT support engineer with 29 years' experience. I test every file before I send it. My workbooks help you organise your records. They are not tax or accounting advice, so check rates and rules with HMRC or your accountant.
Message me with what you track now and I will tell you honestly what fits.
Platform:
Excel
•
Google Sheets
Development technology:
VBA
•
Google Apps Script
Expertise:
Formatting
•
Fixing
•
Formulas
•
Macros
•
Dashboard
FAQ
Is this tax or accounting advice?
No. The workbooks help you organise your records and do the arithmetic. VAT and CIS rates are set up as you tell me. Please check your rates and obligations with HMRC or your accountant.
Do you work in Excel, Google Sheets, or both?
Both. Tell me which you use. I will not move you to a different tool unless you ask.
Are dates and currency set up for the UK?
Yes. £, DD/MM/YYYY dates and UK number formats are the default.
Do you use AI to do the work?
I may use AI as a helper when it speeds things up, but I design, check and test every spreadsheet myself before I send it. If you would rather I did not use AI at all, say so in the order requirements and I will work without it.
What if my project is bigger than the package I chose?
I will tell you before I start and suggest a higher package or a custom quote. I will not add fees after work has begun.

