PSA reporting: What it is, why it goes wrong, and the KPIs that protect margin

Blog post image

PSA reporting: Summary & key takeaways

  • What PSA reporting is: The layer that catches a wrong number before Friday, not a chart set.

  • Why reports go wrong: Late timesheets, and averages that hide the two people quietly heading for burnout.

  • What actually fixes it: One place inputs get logged, decision-ready views by role, and a weekly and monthly rhythm.

  • Core KPIs: Billable utilisation, project gross margin, planned vs actual effort, time-log completeness, WIP readiness, and capacity forecast.

  • What good looks like: Finance and delivery arguing about the plan, not about whose number is right.

Spreadsheets don't fail loudly. I ran client accounts for years on a stopwatch and a stack of tabs, and the failure always looked the same: nothing broke, nobody got an alert, the sheet just kept agreeing with the room while the real number underneath it drifted further from true. By the time someone opened the invoice and asked why the math didn't add up, the gap had already cost weeks.

Dashboards can look healthy while margin quietly slips. Green traffic lights don't mean the fixed-fee job still pays. This guide is about closing that gap: what PSA reporting actually is, the KPIs worth tracking, how to build a stack people trust instead of argue with, and the mistakes that wreck it.

What is PSA reporting, really?

PSA reporting gets sold as a chart upgrade — swap the widgets, add a colour, ship a new dashboard. That's not what it is. It's the layer that would have caught Tuesday's wrong number before it became Friday's negotiation: live dashboards and scheduled reports built from the same connected project, resource, and financial data — utilisation, project margin, budget vs actuals, forecast, and billing readiness.

A project dashboard and PSA reporting answer different questions, and mixing them up is where most of the trust problem starts. A dashboard tells you whether tasks are moving. PSA reporting tells you whether the job still pays.

Dimension

Project dashboard
PSA reporting
Primary question
Are tasks and milestones on track?
Are utilisation, margin, and forecast healthy?
Typical metrics
% complete, due dates, blockers
Utilisation, margin, budget burn, WIP, forecast
Main audience
PM and delivery team
COO, CFO, head of delivery, ops
Data dependency
Tasks and owners
Time, rates, budgets, assignments, billing state
Cadence
Daily / stand-up
Weekly ops + monthly commercial
Failure mode
Busywork looks fine
Margin and capacity surprises

Project health views still matter — they feed PSA reporting as an input, not the whole product. Pure PM software leaves you feeling the money gap first: it tracks work, not cost and margin as delivery happens. A heavy traditional PSA suite that teams avoid leaves you feeling the trust gap first instead — the financial model is there, but the actuals go stale the moment people stop logging into it.

Professional services automation connects the wider quote-to-cash system — pipeline, projects, people, time, billing, and analysis. Reporting is how leaders read that system without rebuilding spreadsheets every Friday. (If you landed here looking for a PAYE Settlement Agreement or a graded-card population report, this isn't that guide.)

Why PSA reports break

The problem is never a shortage of charts. I've seen teams with a dashboard for everything still get blindsided on a Friday, because the charts were only ever as current as the last time someone remembered to log their hours.

Manual reporting is usually the real culprit. Pulling a status pack together by hand — chasing timesheets, rebuilding a finance export, screenshotting three tools into one deck — eats hours that never show up as billable, and every one of those hand-offs is a place for the numbers to quietly drift apart before anyone notices.

Teamwork.com research in The Sprint to AI found 50% of respondents named data management and reporting as a top tech fail. Connected data doesn't just look better — it gets you to the decision sooner.

Generic PM dashboards stop at task health because that's all they were built to track. Traditional PSA suites usually have the financial depth — they just struggle the same way when people stop logging. Either way, catch delivery risk before month-end with live Project Health views that pull status from the same place teams already work.

How do you build a reporting stack people trust?

Start with the decisions, not the widgets. I see teams spend months theming dashboards and still miss the one question the COO asks every Monday. Three things have to be true, in this order:

  • Trusted actuals. Time, scope, cost, and assignments captured in the flow of work, not reconstructed after the fact. Late timesheets and rebuilt budgets are the usual failure mode, and every chart downstream inherits it.

  • Decision-ready views. Utilisation versus target, margin, budget burn versus progress, planned versus actual effort, WIP readiness, near-term forecast — each with an owner and a decision attached, or it's just scenery.

  • Operating cadence. Weekly ops on utilisation, project risk, and time completeness. Monthly commercial review on margin, forecast, and billing readiness. Alerts on broken thresholds, so nobody's waiting on the pack to find out.

When teams rebuild actuals after the fact, finance and delivery end up with two different "official" numbers for the same month — and a calm Monday turns into a reconciliation fight before anyone's even opened a dashboard.

Name the decisions before the dashboards

List the five decisions you make on a repeatable rhythm — staffing, scope control, invoice timing, hiring, sales throttle — and assign one owner to each. If two people "own" utilisation, nobody owns it. Map each decision to one primary KPI from the table below; six strong signals beat twenty weak ones, so resist pinning up every chart on day one.

Fix the actuals path first

Decide this early: where people log time, how budgets get set, who updates assignments. Write the rule down in one page. If logging is optional, your report quality is optional — the best version I've seen is same-week completion with a named completeness owner.

Set thresholds that force a decision

Keep thresholds simple enough that teams act on them instead of debating them:

  • Budget consumed beyond progress by a set gap

  • Utilisation 10 points under target for two weeks

  • Time-log completeness under 90% mid-week

  • Forecasted margin under a floor on sold work

Run the weekly review on utilisation, project exceptions, and time completeness before the monthly commercial trends. Quarterly, retire whatever nobody's acted on in three months — a report nobody uses is just decoration.

Six KPIs, each tied to one decision, beat twenty that nobody owns:

KPI

What it measures
Primary owner
Decision it drives
Billable utilisation
Billable hours ÷ available hours by person, role, team
Resource / ops lead
Hiring, staffing mix, non-billable load
Project gross margin
Revenue − delivery cost on the job
Delivery lead + finance partner
Scope control, rate or effort reset, kill/continue
Budget vs actuals
Planned cost or hours versus consumed
PM / commercial owner
Re-plan, change order, pause work
Planned vs actual effort
Estimated effort versus logged effort by phase
PM
Estimate quality, delivery risk
Time-log completeness
% of required logs in on time
Ops / team leads
Trust score for every other report
WIP / billing readiness
Completed work finance has not invoiced yet, or time teams still have not billed
Finance + PM
Invoice timing, cash, leakage
Capacity / revenue forecast
Tentative and sold demand versus supply
COO / ops
Hiring, sales throttle, bench risk

Industry benchmarks put average billable utilisation around 68.9%, against a widely cited 75% target — though in my experience, billable roles more often land closer to 75–85%, depending on role mix and non-billable load. The exact number matters less than whether you can show target versus actual by role: a healthy-looking average can hide two people quietly heading for burnout while two more coast — I've watched it happen on a team sitting at a perfectly respectable 75%.

Different roles need different views, not one mega-board

One mega-board fails executives, delivery leads, and finance in the same meeting, because they're not looking for the same thing. Executives need margin by service line and forecast gap, to decide on hiring and sales throttle. Delivery leads need planned-versus-actual by phase and open scope risk, to decide on re-plans and change orders. Resource managers need utilisation by role and bench risk, to decide on staffing. Finance needs WIP, unbilled time, and budget variance, to decide on invoice timing. Same underlying data, different saved views — and it's exactly where estimate drift and margin risk should surface while there's still runway to act on it.

Worked example: retainer bleed

Retainer accounts often burn quietly when hours run ahead of plan and new requests keep arriving in chat. Retainers often go off track by the third week when consumed hours outpace planned delivery cost. Projected margin = retainer fee − projected delivery cost — put hours consumed, remaining plan, and that number on one view, and the decision set becomes plain: change order, re-scope lower-value requests, or accept a known margin hit with eyes open. Without the report, none of those choices get made in time.

Governance: who owns the numbers

Owners matter more than charts. Name who can change cost rates, bill rates, and budget templates. Name who closes the week for time completeness. Name who publishes the monthly commercial pack. I assign rate ownership to one commercial owner for a reason — untracked mid-month rate edits make packs disagree and waste the review on reconciling files.

Keep a short data dictionary that defines billable utilisation, productive utilisation, gross margin, WIP, and completeness in one page. When two leaders use the same word differently, the stack fails before the meeting starts.

Scope creep does the same damage from a different angle. Clients ask for a little more inside the same retainer, there's no mechanism to recover the extra cost at the end of the month, and by the time anyone adds it up, overservicing by even 10% has quietly cost six weeks of unpaid work over the year. That's not a client problem — it's a scoping problem, and it shows up in your margin report before it shows up anywhere else.

Most firms still need CRM and accounting alongside this. Keep time, task progress, and project budgets where delivery happens; push invoices and closed-won structure outward through controlled integrations; pull pipeline signals in as tentative demand. That pattern protects the whole stack better than complex bi-directional syncing — and if analysts need deeper models, export governed datasets instead of rebuilding utilisation logic in five personal workbooks. Personal workbooks are how official numbers multiply.

Self-audit: Score your current reporting before you buy another widget

  • Can finance and delivery defend last month's margin with the same source file?

  • Is billable utilisation visible by role against a named target?

  • Do you see budget burn versus progress on fixed-fee jobs weekly?

  • Is time-log completeness measured, not hoped for?

  • Does every red cell have an owner and a next action within seven days?

If you answered no to two or more, strengthen the stack before you add more charts.

The mistakes that wreck PSA reporting

The mistake I see derail trust fastest is treating task green as commercial green. Most of the rest comes down to a handful of fixable habits:

  1. Treating task green as commercial green. Progress without cost hides overservice on fixed-fee burn. Fix it by pairing burn with remaining work in the same weekly view.

  2. Utilisation without a target. Same average-hides-burnout problem as above — track target versus actual by role, not just the team number.

  3. Separate systems for time, tasks, and budgets. Every export is a chance to disagree on the same month. Teamwork.com research in The Sprint to AI found only 1% of respondents could manage data, projects, profits, and resources in one tool.

  4. No path from red cell to ticket. Without an owner and date, the pack is only a slideshow.

  5. Ignoring tentative demand. Verbal yeses still consume people, so sold-only capacity looks too healthy — and AI summaries built on top of incomplete logs just speed up the same bad decision.

How does Teamwork.com turn delivery into reports you can defend?

Calmer Monday reviews often become more regular once teams centralise delivery data instead of stitching three exports. Buying another status view won't fix margin if the actuals are still late — that's the gap Teamwork.com closes as an agentic PSA, with projects, resources, financials, and AI agents in one platform people will actually use.

When OIC Advisors centralised delivery in Teamwork.com, they gained 360° visibility across active projects and cut time spent manually generating reports. The win was trusted visibility, not another theme pack.

Here's what makes Teamwork.com different:

  • Spot delivery risk without leaving the work with Project Health and live dashboards, catch plan-versus-reality drift before write-offs with Planned vs Actual reporting, and see margin risk early enough to act with profitability and budget tracking by project.

Blog post image

  • Keep workloads balanced when utilisation sits on live time, not last month's spreadsheet. Team utilisation reporting shows who is buried, who has space, and how close you sit to target.

Blog post image

  • Stop rebuilding the Friday pack by hand. Scheduled reports and shareable views cut the screenshot-and-paste routine that eats an ops team's week — once delivery and finance read the same pack, that manual rebuild usually just disappears.

Blog post image

  • Trusted actuals make AI useful instead of theatrical. In practice, teams use TeamworkAI to summarise utilisation risk and flag profitability pressure from the same governed project data, and live AI Teammates such as Scout, Flo, Dotty, and Jack help with fast status reads and capacity nudges — keeping delivery leads and resource managers out of five open tabs.

Blog post image

  • Keep AI under your controls and on one source of truth. The Teamwork.com MCP server lets Claude and ChatGPT read and act under your controls. Teamwork.com doesn't use your private data to train third-party models, and the platform is SOC 2 Type 2 certified.

Blog post image

Keep delivery work captured in one place so project management records the work as it happens, while resourcing and financial views keep the commercial score. Delivery teams live in the system that produces the commercial numbers, so the numbers stop drifting apart.

Get faster weekly reviews and earlier risk detection from connected utilisation, margin, and delivery data.
Start free

What PSA reporting questions do leaders ask most often?

What is PSA reporting?

When finance and delivery trust the same numbers, PSA reporting becomes the dashboard set leaders actually use to run the business. I use that definition because it keeps teams focused on commercial decisions, not prettier status slides. See the full definition earlier in this guide.

What is the difference between a project dashboard and PSA reporting?

A green task board can still hide a job that is underwater on margin, which is where PSA reporting earns its place. Use the comparison table above for the full split.

What KPIs belong on a PSA reporting dashboard?

The ones that force a staffing, scope, or margin decision within a week or a month: billable utilisation, project gross margin, planned versus actual effort, time-log completeness, WIP readiness, and capacity forecast. Six is usually plenty — everything else is noise nobody acts on.

What is a healthy billable utilisation rate?

There isn't one number — SPI Research puts the industry average around 68.9%, while many billable roles I've seen aim nearer 75–85% depending on role mix and non-billable load. The number matters less than whether you can show target versus actual by role, because a healthy average can still hide two people burning out while two others coast.

Can AI replace PSA reporting?

AI speeds up reporting, but it cannot rescue missing time, budget, and assignment data. Automating incomplete logs only speeds up bad decisions.

Related Articles
View all