In this article
Spreadsheets are genuinely good at running a small practice. They are free, everyone can use one, and they bend to how your firm actually works rather than how a vendor thinks it should.
They do not fail suddenly. They degrade, and the degradation is easy to miss because each individual workaround is small. Here is what the drift looks like.
One: you cannot answer a question in the meeting
Somebody asks how much of the Fernwood fee is left. You say you will check and come back. That gap between the question and the answer is the cost, and it grows quietly.
Two: the same number lives in three places
The fee is in the proposal document, again in the project tracker, and again in the invoice. Each was typed by hand. When a variation changes it, at least one of them stays wrong, and nobody knows which.
Three: month end takes a day
Reconstructing what to bill is the tell. If billing means opening timesheets, cross-referencing the fee schedule and rebuilding the position from parts, you are doing a data integration job by hand every month.
Four: you have stopped trusting the file
Someone keeps a private version because the shared one is out of date. Two people quote different numbers in the same meeting. At this point the spreadsheet has become a report of what somebody last remembered, not a record.
Five: nobody knows who is busy
Utilization is guessable at four people. At ten it is not, and the guess is usually wrong in the direction of taking on more work than the team can deliver.
Six: writing off has become routine
Hours get logged late or not at all, so some of them never make it onto an invoice. Nobody decided to write them off. They just were not visible at the moment the invoice went out.
What a system actually fixes
Not the reporting, which is what most vendors sell on. The handoffs.
The reason month end is slow is that the quote, the hours and the invoice are three separate records that a person joins together. Keep them linked on one project and billing becomes assembly instead of reconstruction. That is the whole argument, and it is the one worth testing on a real project rather than in a demo.
Be clear about what you are buying, though. A system that connects those steps will tell you what you invoiced, what you collected and where hours went. It will not tell you your gross margin unless it holds staff cost data, and most tools at this end of the market do not. What architecture project management software is and how phase-based billing works explain what to look for.