Download
AI Time Tracker app
(Timesheet)
Desktop app
(Computer activities)
Mobile app
Browser Extensions
Managing a 30-person team in Excel files, with everyone involved in different projects, became a hassle. TimeCamp's timesheet & resource planner fixed it by bringing the team into one clear view that visualizes workload and shows current capacity.
DEWIZA Audyt is an audit firm with more than 10 years of experience in statutory audits. Operating across Poland and collaborating with experts from various other fields, they provide comprehensive financial statement reviews, tax audits, accounting advisory services, and more. They make sure every service is tailored to each client's unique needs and allocate services and consultants accordingly.
Industry: Audit and assurance
Employees: 20-49
Location: Gliwice, Poland
Using TimeCamp: For time tracking and resource planning
Ready to switch from endless Excel spreadsheets to one source of planning truth?
Quick insights into who works on what as the week runs. Greater visibility into resource allocation thanks to a granular view.
Up-to-date time and resource data, always ready to review. Timesheets are already collected and don't require the extra effort of consolidating 30 spreadsheets when month-end approaches.
Planned and submitted hours sit in one tool, side by side, so there's no need to switch between two different Excel files to reconcile the numbers manually. They also see which projects are under- or overstaffed and can adjust staffing accordingly.
Before, a single Excel cell always meant a whole week, while Resource Planner in TimeCamp lets you allocate by the hour, especially when managing multiple clients in one week.
Rafał Rydzak
VP, DEWIZA Audyt
“With 30 people on board and so many great clients, allocating resources in Excel simply became not worth the effort. The Planner view gave us what we needed – seeing every project with employees allocated to it in one place.”
30 people and 30 different Excel files. A weekly manual resource-to-project allocation became too much. The team was big enough to cover current workload – the problem was in how the workforce management was handled.
A planning matrix, packed with different kinds of information, worked fine as long as no unplanned changes were made. For example, moving an engagement by a month meant going through that week and shifting the entry for every person on it, and a team covering two clients at once left two names in one cell that could no longer be filtered. Maintaining the grid had become a hassle.
A pile of separate files only grew. Everyone kept separate timesheets, named projects at their whim, printed a monthly summary, and sent it to payroll. Each Excel review, compiling data, clearing errors, and producing management outputs took usually around three weeks of admin time. The management team kept another file for settlement, checking the hours on a contractor's invoice against what the record showed. None of the files connected, so manually comparing the plans against actual hours to maintain accuracy was time-consuming.
| Before TimeCamp | After TimeCamp |
|---|---|
| Each person kept their own Excel timesheet, project names typed freehand | Project names set centrally, so allocation and reporting use one name |
| An admin colleague consolidated around 30 files after month end, up to three weeks | The system collects the hours itself, available as the month runs |
| Planning matrix of surnames by week, one client name per cell | Allocation per person per week, in hours, several people visible on one engagement |
| Two clients in one week meant two names in one cell and no usable filter | Two clients in one week split by hours, each visible separately |
| A client's date shift had to be moved by hand across every affected row | Allocation moved in the planner, with the change visible to the team |
| Planned versus actual hours matched manually | Planned hours and submitted hours read from the same record |
| Excel accepted any number of hours, so over-allocation against a client fee surfaced late | Hours checked against the client budget before the engagement runs over |
| Before TimeCamp |
|---|
| Each person kept their own Excel timesheet, project names typed freehand |
| An admin colleague consolidated around 30 files after month end, up to three weeks |
| Planning matrix of surnames by week, one client name per cell |
| Two clients in one week meant two names in one cell and no usable filter |
| A client's date shift had to be moved by hand across every affected row |
| Planned versus actual hours matched manually |
| Excel accepted any number of hours, so over-allocation against a client fee surfaced late |
| After TimeCamp |
|---|
| Project names set centrally, so allocation and reporting use one name |
| The system collects the hours itself, available as the month runs |
| Allocation per person per week, in hours, several people visible on one engagement |
| Two clients in one week split by hours, each visible separately |
| Allocation moved in the planner, with the change visible to the team |
| Planned hours and submitted hours read from the same record |
| Hours checked against the client budget before the engagement runs over |
“Excel accepts anything. TimeCamp shows you if it adds up.”
Rafał Rydzak
VP, DEWIZA Audyt
Moving the Excel data to Resource Planner connected all the employees to a single source of truth. Project names are set centrally and shared across resource planning and reporting; resources are allocated in hours rather than entire weeks; and when two clients are scheduled for the same week, each client's allocation stays visible on its own.
No more loose timesheets; now they go to an approver each week, and managers can check who worked on what and whether anything unplanned happened. Settling with contractors also uses the same records, so hours billed on invoices are checked against them rather than compared with the sheets. As Dariusz Głąb, VP, says, now it’s “real work hours, not guesswork.”
Follow DEWIZA's example – switch from messy Excel files to one tool for tracking and planning. Sign up for a free 14-day trial or just schedule a call with us to see TimeCamp with your numbers.
Google