Two partners sit down to discuss work in progress, billings or client profitability. Within the first few minutes, it becomes clear that they are working from different numbers.
One partner has figures from an export run last Tuesday. The other is using a spreadsheet prepared later in the week, perhaps with a different date range, filter or definition of “current.” Neither figure is necessarily incorrect. They are simply based on different reporting conditions.
What happens next is familiar: the meeting stops being about the decision and becomes an exercise in reconciling the numbers. Time that should have been spent discussing an ageing job, a billing delay or a low-recovery client is spent asking where each figure came from.
The problem is not merely that two totals are different. It is that the firm lacks a shared and clearly defined view of performance.
Why manual reporting creates conflicting numbers
When management reports are rebuilt from spreadsheets and exports, small differences can enter at several points:
reports are extracted at different times;
users apply different date ranges or filters;
calculations define WIP, productivity or recoverability differently;
adjustments are made manually in one version but not another; and
updated files are circulated while older copies remain in use.
Each variation may appear minor. Together, they create multiple versions of the firm’s performance and make it difficult to know which figure should guide a decision.
This is particularly important for measures such as work in progress, where the position can change as time is entered, invoices are raised, write-offs are processed and interim fees are allocated.
The hidden cost is lost confidence
Reconciling reports consumes meeting time, but the larger cost is reduced confidence in the reporting process.
When partners repeatedly encounter figures that cannot be explained quickly, they may become reluctant to rely on the reports. Decisions then drift towards personal spreadsheets, historical knowledge or instinct. Those inputs remain valuable, but they should complement consistent evidence rather than replace it.
A disputed number can also delay action. Instead of deciding who will address old WIP or review a client’s declining recoverability, the issue is deferred until somebody checks the source data and circulates another report.
A standard spreadsheet is not always enough
Templates, reporting calendars and agreed definitions can improve manual reporting. They are worthwhile controls, particularly while a firm is developing its reporting process.
However, they do not eliminate the underlying risks of separate extracts, copied files and manual transformations. A standard template can still contain information captured on different dates or modified by different people.
The more durable approach is one governed reporting model in which:
measures use agreed business definitions;
data is refreshed on a consistent schedule;
users access the current report rather than emailed copies;
appropriate permissions control what each person can see; and
headline figures can be traced to the underlying detail.
This is what turns a collection of reports into a dependable management system.
What changes when partners use one reporting model
When partners and managers work from the same reporting model, meetings can begin with interpretation rather than reconciliation.
The conversation changes from “Which total is correct?” to more useful questions:
Why has aged WIP increased in this portfolio?
Which clients or jobs are driving the movement?
Are draft fees waiting for approval?
Where are write-offs affecting recovery?
Who owns the next action?
Disagreement does not disappear, nor should it. Partners may still interpret the same evidence differently or prefer different actions. The difference is that they are debating the business response rather than the origin of the figures.
With interactive Power BI reporting designed for accounting firms, users can filter a firm-wide position and drill into the relevant partner, manager, client, job or transaction. Questions can be investigated during the meeting instead of being assigned for another round of spreadsheet work.
One model does not mean identical access
A consistent reporting model does not require every person in the firm to see every number.
Partners may need a firm-wide view, managers may need information relating to their portfolio, and staff members may only need their own performance information. Role-based access allows each person to see the information appropriate to their responsibilities while keeping the underlying definitions and calculations consistent.
Practice Clarity connects timesheets, productivity, WIP, billings, recoverability and debtors in one reporting model. It uses a read-only connection to the firm’s existing practice-management data, so the operational system remains in place while the reporting layer provides consistent, filterable and drillable views.
The goal is not simply to produce a more attractive report. It is to give the firm a shared basis for making decisions.
Frequently asked questions
Why do partners in the same accounting firm see different numbers?
The figures may come from exports created at different times or use different filters, date ranges, adjustments or calculation rules. Even when each report is reasonable on its own, those differences can produce conflicting results.
What does “one source of truth” mean in management reporting?
It means agreed measures are calculated through one governed reporting model using a consistent refresh process. Users may have different access levels, but the definitions behind the figures remain consistent.
Can a standard spreadsheet solve the problem?
A standard spreadsheet can reduce variation, but it still depends on consistent extracts, manual steps and version control. It is usually a useful interim control rather than a complete solution.
Does Practice Clarity replace our practice-management system?
No. Practice Clarity connects to supported practice-management systems in read-only mode and turns the existing operational data into a purpose-built reporting layer.
If leadership meetings are still beginning with a debate about whose numbers are current, book a Practice Clarity walkthrough to see how one connected reporting model could work for your firm.