An agency with 25 employees ran a review of their 40 active projects. They assumed the biggest client was the most profitable because it generated the most revenue. Turns out that client was losing them money every month, and the smallest retainer project was quietly funding the whole office.
Revenue Is Not Profit, and Everyone Had It Backwards
The agency tracked billable hours but never compared them to what each project actually cost to deliver. The account manager for the big client kept asking for extra design reviews, all uncharged, because “the client is worth keeping happy.”
ERPNext Consulting helped them set up a simple structure: every project carried its own costs, its own hours, and its own budget on one screen. Project managers finally saw a running number instead of discovering a surprise at the end of the quarter.
What Made the Numbers Look Different
- Time entries were tagged against a specific project and phase, not just the client
- Fixed-fee projects showed a live profit number that updated as hours went in
- Retainer projects were reviewed on a fixed date every month, comparing hours spent to the fee received
The result was uncomfortable but useful. They renegotiated one contract, dropped one unprofitable service line, and put the big client on a new pricing model that charged for the extra review cycles. Within three months, the agency’s average project margin went up from 24 percent to 39 percent.
Do This Before You Buy Anything
For two weeks, list every project and write down the hours your team actually spent, not what you planned to spend. Add in the small extras, the calls, the last-minute tweaks. That two-week snapshot will tell you more about your business than any software demo ever will.
The agency’s mistake was celebrating revenue while ignoring the cost of delivery. ERPNext Consulting did not save them money with fancy features. It just showed them the truth in a format they had to look at daily. If your agency cannot tell which projects make money right now, start fixing that next Monday, not next quarter.