Consultant Utilisation Tracker

Consultant Utilisation Tracker is an offline app (one HTML file in a zip) for a consultancy of one to twenty people that sells time in days. You list your consultants with a standard day rate and a target utilisation, then each engagement with the days sold and the sold day rate. You log days as they are worked: billable against an engagement, or internal, business development, training, leave or public holiday. The app compares days billed with days available, shows which engagements are behind pace or over their days, and puts a value on the gap to target.

The problem it removes: A consultancy sells days but nobody compares the days billed with the days available. One engagement has run past its days without anyone noticing, another has twelve unused days and an end date three weeks away, and the partner cannot say whether the team was 60 percent or 75 percent utilised last month. This app answers those questions from a simple day log.

What is inside:

• Utilisation page: team utilisation last month against target, billable days so far this month, engagements behind pace, over-sold engagements and unused days at risk
• Day log per consultant: a day cannot be logged for more than 1 day in total, and billable days need an engagement
• Engagements with days sold, sold day rate, days delivered, days left, percent used and the days per week still needed against the pace of the last four weeks
• Monthly capacity per consultant with leave and public holidays taken out of the days available
• Utilisation against target per consultant and month, days short of target and the revenue gap at the standard day rate
• One press adds this month's capacity rows, and days logged by month and by kind are charted
• Example data you can load in one click, a Start here guide and an Honest limits panel
• JSON backup and restore, CSV export, and CSV import with a check of every row before anything is added

Who it is for: boutique consultancies, advisory and training firms, design and engineering studios and independent consultants with associates, who sell days or fixed packages and want to know how busy their people really are.

What it is NOT: It does not track money received or invoices, timesheet approval, costs or profit, and it does not forecast sales. The target utilisation and standard day rates are numbers you enter, not advice on what to charge or what is a good utilisation. It does not know your public holidays: you log them as a day kind. It is not legal, tax or accounting advice, it is not connected to any government system, bank or messaging service, and it does not file or send anything by itself. UAE e-invoicing is not part of it.

Your data stays on this device in your browser. Back it up with Export; clearing browser data loses it otherwise.

Verified by us: scripted tests in Chromium (152 checks through the real screens: adding, editing and deleting records in every table, required-field messages, backup then clear then restore, CSV export then import, keyboard order, print layouts rendered to PDF, no horizontal scrolling at 375 and 1280 pixels, no network requests) and an independent recalculation by a separately written Python evaluator of 2707 calculated values (25 randomised rows plus the example data) with 0 mismatches. Safari engine (WebKit): smoke test passed; Firefox: could not be launched. Not tested: Firefox beyond what is stated here, and no real printer was used (print layouts were checked as PDF).