A mid-sized architectural practice ran a mixed portfolio of residential and commercial projects. It struggled to see its time tracking and project costs clearly and accurately.
The firm relied on spreadsheets and manual reports. This created gaps and mismatches that hurt project budgets, staff utilisation and overall performance.
As the practice grew and took on more live projects, the problems grew too. Small annoyances became structural problems. They limited profit and the quality of management decisions.
The firm then put in Quantim's timesheet and operational tracking system. It gained:
- real-time transparency
- better accountability
- more accurate project budgets
- a big cut in admin work
This case study sets out the challenges they faced, how they made the change and the results after adopting Quantim.
1. Background
The firm had built a strong name for design quality over more than ten years. Its projects ranged from single homes to complex commercial schemes built in several phases.
The team had grown large. Directors could no longer keep a direct eye on every live job. The need for clear, built-in visibility had grown with the practice, but its systems had not kept up.
Staff worked on several projects at once. Yet nobody had a clear, reliable picture of how time was spent on each activity.
Project managers judged progress from chats, emails and their own memory. That was fine when the practice was small. It worked less and less well as the number of live projects grew.
How the practice worked before Quantim
- Timesheets were kept by hand in spreadsheets.
- Project budget reviews relied on email and verbal updates.
- Reports were limited and did not show what was happening now.
- Resource planning was patchy, so capacity decisions were more art than science.
As the practice grew, these habits hurt both output and financial control more and more.
2. The Challenges
2.1 Lack of Real-Time Insight
Time records were often late or patchy. Many staff filled in timesheets at the end of the week. Some waited until the end of a fortnight.
By the time a project manager saw the data, it was already history. It was no longer a picture of the present. So managers could not tell:
- whether projects were on budget
- which activities took the most time
- whether staff were working on the right priorities
- when projects were heading for overspend
Without real-time data, the team reacted to problems instead of getting ahead of them. An issue that could have been fixed in week two stayed hidden until week six.
By then, fixing it cost far more. The options for recovery were far fewer too.
Many professional services firms know this pattern well. Our article on eliminating data blind spots in engineering calls it the gap between when performance slips and when managers find out.
2.2 Difficulty Managing Project Budgets
All the data sat in spreadsheets. So tracking time spent against fees was slow, prone to error and rarely up to date.
Project managers found it hard to spot:
- which clients were getting more service than their fees covered
- which activities ran over their estimated hours
- which projects were drifting off plan
There was no clear tool for seeing budgets. Fee erosion went unnoticed until it showed up in a month-end financial summary. By then it was too late to win back the lost margin.
This is one of the most common causes of profit problems in architectural practices. Two reports would have given managers the clarity they needed. They are covered in our article on the two reports every manager needs for smarter billing.
Without those reports, budget control becomes a look back at the past. It is not a live, day-to-day discipline.
The hit to profit was measurable. Yet it was hard to put an exact figure on it. The data simply was not good enough for accurate analysis.
2.3 Accountability Across the Team
With manual processes, there was no set way to make sure time entries were complete, accurate and linked to the right project codes.
Staff built different habits. Some filled in entries daily and others weekly. How much detail they gave on activity codes also varied a lot.
The result was a set of personal habits, not one consistent record of the firm's work.
This caused two problems:
- Admin overload. Managers spent time chasing and fixing entries.
- Poor transparency. The data they finally collected was too patchy for reliable reports.
The practice knew this was a problem with the system, not with any one person. But without a platform that made entries consistent, they had no way to change the pattern.
2.4 Excessive Administrative Burden
Staff spent hours each week on manual tasks:
- updating spreadsheets by hand
- matching up hours across several project files
- fixing version control errors
- preparing reports that were out of date by the time they went out
This work fell mostly on project managers and operations leads. They were also responsible for client delivery, so they carried both jobs at once.
The practice saw that this double load could not support further growth. The manual setup had served them well when they were smaller. It could not support the firm they were becoming, so they needed a modern, structured system.
3. Why Quantim Was Selected
The firm looked at several tools before choosing Quantim. Its main criteria were:
- simple daily use for staff without a finance background
- real-time visibility for project managers and directors
- a clear link between time entries and project budget performance
- accurate reports without pulling data together by hand
Several platforms offered some of these features. None offered all of them in one connected system.
Quantim provided:
- a simple, intuitive timesheet entry process
- real-time visibility of staff hours and utilisation
- clear links between time, project budgets and fees
- accurate reports with no manual consolidation
- better accountability through structured workflows
- a scalable platform that could grow with the practice
Our article on why Excel fails for modern project and cost management looks at the limits of the spreadsheet approach the firm was replacing.
The move to a dedicated platform was not about unhappiness with the team. The firm saw that no amount of personal effort could overcome the limits of a tool never built for this job.
4. Implementation Approach
4.1 Staff Training
Training focused on making time entry simple, consistent and meaningful for everyone, whatever their financial knowledge.
The practice did not present Quantim as an admin tool. It framed it as a visibility system. Staff saw how their daily entries fed directly into:
- project budget tracking
- utilisation reports
- the information project managers used to protect the team from overload
This approach won stronger buy-in than simply asking staff to comply would have done.
Staff feedback was positive. Team members said the clear interface and quick daily entry were instant gains over the spreadsheet process.
4.2 Transition from Spreadsheets
The team moved live project budgets into Quantim. They set up proper fee allocations for every live job.
They retired the old spreadsheets instead of running them side by side. This removed the urge to slip back into old habits under pressure.
The clean break mattered. It kept the new data free of the old system's errors and gaps.
Within the first two weeks, all time tracking had moved into Quantim. For the first time, the practice began building a data set that was consistent, structured and ready to query at once.
4.3 Establishing an Accountability Cadence
The firm made two checks part of its standard routine:
- weekly timesheet checks
- monthly utilisation reviews
Automated reminders and clean reporting dashboards backed these up. Managers got the information they needed with no manual preparation.
This greatly cut the admin effort of chasing and fixing entries. It also replaced the informal, patchy follow-ups that had been the only way to keep timesheets up to date.
5. Results After Adopting Quantim
5.1 Real-Time Time Tracking and Budget Visibility
Quantim gave the leadership team instant, always up-to-date insight into:
- how every employee's time was used
- which projects were running on target
- which clients or tasks were taking too many hours
- where changes were needed to protect fee recovery
For the first time, project managers could see where their jobs stood without piecing together data from several sources.
This alone changed project management meetings. Managers no longer guessed what might be happening or asked for updates. They arrived knowing the facts, so they could focus on decisions instead of gathering information.
5.2 Increased Productivity and Accountability
Once their entries showed up in a structured system linked to project budgets, staff became much more aware of how they used their time.
The practice saw:
- stronger personal responsibility for accurate logging
- more awareness of project budgets among staff who had never seen financial results before
- more transparency between teams that had known little about each other's workload
With no reliance on Excel templates, the practice got rid of duplicate files, mismatched versions and missing data. These had been a constant source of admin frustration.
5.3 More Accurate Project Budgeting
For the first time, the firm could link daily activity straight to project budgets. It could see in real time whether fees were being used up as planned.
Project managers could spot early when a project needed action. That action might be:
- a scope conversation with the client
- moving hours between activities
- a change to the original fee structure
This early warning directly protected profit margins. Surprises that used to appear at the end of a project became decisions made in the middle of it.
Real performance data built up over time. This let the firm predict task demands more precisely. Our article on predicting engineering task loads with greater precision explains how past actual-versus-estimate data makes future project pricing far more accurate.
5.4 Reduced Administrative Workload
The practice greatly cut the time spent on:
- collecting timesheets
- updating spreadsheets
- matching up project hours
- producing monthly reports
Operations staff freed up hours each week. They put that time into project delivery and client service. These tasks build revenue and reputation. Admin had been taking up far too much of managers' time.
Lighter admin was one of the first gains people felt. It also lifted morale among operations staff, who had found the old process very frustrating.
5.5 Better Resourcing Decisions
With clear, current utilisation data, leaders could:
- allocate staff more effectively
- balance workloads across the team
- avoid over-servicing individual clients, which had eaten into margins on some of the firm's busiest accounts
- plan hiring from evidence-based forecasts, not gut instinct
Resource planning is especially hard in design and architecture practices. Workload rises and falls sharply across project phases. Our article on burnout in design teams and how better resource planning prevents it explores this.
After the move, the practice reported a far more controlled and sustainable working environment. Team members had fewer periods of severe overload.
6. Key Outcomes
| Area Improved | Impact |
|---|---|
| Time visibility | Full real-time insight into how hours were used across all live projects |
| Project budget accuracy | A direct, live link between time spent and fee allocation |
| Productivity | Measurable gains through structured workflows and less admin |
| Accountability | Stronger personal ownership of time entry and budgets |
| Administration | Big cut in Excel use, manual tracking and report preparation |
| Decision making | Faster, evidence-based decisions in place of reactive management |
| Resourcing | Balanced workloads and evidence-based hiring decisions |
7. Lessons That Apply to Any Firm
This case study is about an architectural practice. But the same patterns apply in every professional services sector.
Keeping time data accurate across a team on many projects at once is a shared problem. Engineering firms, consultancies, legal teams, IT service providers and construction managers all face it.
The tasks differ, but the core problem is the same:
- Labour is the main cost.
- Labour data is captured inconsistently.
- So the financial picture is too unreliable to base management decisions on.
Lesson 1: Structured tracking changes behaviour
Moving from manual to structured time tracking changes behaviour as much as process.
Staff can see that their entries feed a live picture their managers rely on. So their reason to log promptly and accurately shifts. It moves from compliance to contribution.
This change in culture often lasts longer than the process change that caused it.
Lesson 2: Consistency matters more than features
The most important thing a platform delivers is not features. It is consistency.
The practice in this case study did not gain features they had never heard of. They gained the ability to apply ones they already understood. They could do it accurately, without manual effort, across every project at once.
Design and architecture firms face a particular challenge in managing time from concept to completion. Our article on managing design time without friction from sketch to submission covers this.
Key takeaways
- Late, patchy timesheets hide budget problems until they are costly to fix.
- A clean break from spreadsheets keeps new data free of old errors.
- Showing staff how their entries are used builds better buy-in than compliance alone.
- Live links between time, budgets and fees turn end-of-project surprises into mid-project decisions.
- Clear utilisation data supports balanced workloads and evidence-based hiring.
8. Conclusion
This architecture practice transformed how it performed. It replaced manual, spreadsheet-based time tracking with Quantim's structured platform.
The firm gained real-time insight, better accountability and stronger financial control across all live projects.
The change removed admin burden. It created a more predictable, transparent way of working. It also gave the firm data good enough to make commercial decisions truly reliable, not informed guesswork.
The return on this kind of change goes beyond hours saved on admin. It includes:
- margin won back through earlier action
- projects priced more accurately from real performance data
- hiring decisions made with confidence, not uncertainty
Our article on the true ROI of smarter project tracking sets out the full commercial case for smarter project tracking.
Does your organisation face similar problems with time tracking, budgeting or project visibility? Contact the Quantim team at info@quantim.co.uk or book a demonstration below.
