Timesheet and Day Rate Tracker for UK Trades

Timesheet and Day Rate Tracker for UK Trades is an Excel and Google Sheets workbook for self-employed tradespeople who bill by the day or hour, and for small firms keeping track of workers' hours. Log each shift with start, finish and break. The workbook gives you the hours (overnight shifts included), full or half day, overtime and the amount earned, using each client's own day rate if it has one.

Weekly and All weeks sheets add everything up by ISO week and client. The Invoice summary gives each client's amount due for a week or a month. If a client deducts CIS, an optional column applies 20%, 30% or 0% to the labour only and shows what you receive. Year view shows days and income by month, and your best and smallest client.

Up to 50 clients and 1,500 log lines. Includes example data for an electrician and a blank copy. One .xlsx download, no macros, no password.

It does not connect to HMRC and it is not an invoice template. Figures are estimates for planning. They are not tax advice.