✦ Buying, cost and process
Professional services automation: replacing the timesheet-and-spreadsheet stack
Professional services automation (PSA) replaces the separate timesheet spreadsheet, billing spreadsheet and resourcing spreadsheet that most firms accumulate, joining time, work-in-progress and staff availability into one place. It matters once those spreadsheets stop agreeing with each other.
Haystak · 11 August 2026 · Updated 11 August 2026 · 8 min read
Professional services automation is the category of software that runs the operational side of a services firm - time recording, project and client billing, staff utilisation, and resourcing - as one connected system rather than as separate spreadsheets that someone reconciles by hand at month end.
Most firms don't start here. They start with a timesheet spreadsheet, add a separate one for tracking work-in-progress, and a third for planning who's free next week. Professional services automation is what you reach for once keeping those three in sync becomes a job in itself.
Time capture: the foundation everything else depends on
Every part of a PSA system depends on time being recorded accurately and promptly, which is also the part staff resent most. Software helps less by adding features and more by removing friction - timers that start with one click, templates for recurring work, and reminders that catch people before a week's memory goes fuzzy.
- Capture close to the work, not reconstructed at 5pm on a Friday from memory.
- Categorise by client and matter automatically where possible, so billing doesn't need re-coding afterwards.
- Flag missing time early, ideally daily, rather than discovering gaps when an invoice is being prepared.
Poor adoption at this stage undermines everything downstream - utilisation figures, WIP, and billing are all only as accurate as the time data feeding them.
Utilisation: what it measures and what it hides
Utilisation - the proportion of available time spent on billable work - is the headline metric in most services firms, and the one most often misread. A generic spreadsheet usually reports it at firm level only, which flattens real differences between teams, seniorities, and individual weeks affected by leave or training.
| Metric | What it tells you | Common mistake |
|---|---|---|
| Overall utilisation | Roughly how busy the firm is on billable work | Treated as a target rather than a health indicator |
| Utilisation by grade or team | Where capacity is genuinely tight vs comfortable | Not tracked at all in a spreadsheet, so imbalances go unseen |
| Realisation rate (billed vs recorded time) | Whether time recorded is actually being invoiced | Confused with utilisation, which measures a different thing entirely |
A PSA system that reports utilisation by team and by individual, refreshed daily rather than reconstructed monthly, gives partners and managers something they can actually act on before a quarter is over.
WIP and billing: where spreadsheets fall apart fastest
Work-in-progress - time and costs recorded against a client but not yet invoiced - is where the spreadsheet approach breaks down soonest, because it needs to be current at any moment, not just at month end. A partner deciding whether to bill early on a large matter needs an accurate WIP figure today, not one reconstructed from three separate files.
- 01Time and expenses accumulate against a client or matter automatically as they're recorded, rather than being pulled together in a spreadsheet later.
- 02WIP is visible in real time, including write-offs and write-ons applied before an invoice is raised.
- 03Invoices are generated directly from that WIP, removing a manual re-entry step that's a common source of billing errors.
- 04The billed figure flows to the finance system automatically, closing the loop without a second re-key.
That last step is a genuine integration question - a PSA tool and an accounting package are usually separate products, and how cleanly they connect matters as much as either tool individually.
Resourcing: matching people to work before it's a crisis
Resourcing spreadsheets tend to answer "who's free this week" reasonably well and "who's free in six weeks, across three offices, once we account for the two people on leave and the one starting a new qualification" very badly. That's exactly the kind of multi-variable lookup software handles well and spreadsheets don't.
- Forward visibility of committed and forecast work against available capacity, not just this week's diary.
- Skills and grade matching, so resourcing isn't just about hours but about the right person for the work.
- One shared view that project leads, resourcing managers and partners all look at, rather than each holding a slightly different version.
Where firms outgrow generic tools
A spreadsheet, or a lightweight generic time-tracking tool, is a perfectly reasonable choice for a small firm with a handful of people and straightforward billing. The point most firms outgrow it is fairly recognisable: multiple billing structures (fixed fee, hourly, retainer) running alongside each other, more than one office or team needing a shared resourcing view, or WIP and utilisation reporting that has become someone's part-time job to assemble by hand.
| Situation | Generic tool or spreadsheet | Dedicated PSA / bespoke system |
|---|---|---|
| Under 15 people, one billing model | Usually adequate | Rarely justified yet |
| Mixed billing models across clients | Becomes error-prone quickly | Handles this as standard |
| Multiple offices or practice groups | Reconciliation becomes a full role | Built for shared, real-time visibility |
| Reporting to partners weekly or monthly | Manual assembly from several files | Reporting is a direct output, not a project |
There are established off-the-shelf PSA products built specifically for accountancy, legal and consultancy firms, and for many that's the right route - it's worth evaluating them properly before assuming a custom build is needed. Bespoke development earns its place where your billing structures, client reporting requirements, or the way work is organised genuinely don't fit what the standard products assume. Our professional services page covers how we think about that distinction, and our pricing page gives a sense of what different scopes involve.
✦ Where this fits
More on this from us: our work with professional services firms.