A services firm with 60 retainer clients was billing from a spreadsheet maintained by one person. When she took two weeks of leave, invoices went out eleven days late and three clients called to ask if the company was still operating.
That kind of fragility is what pushes a business toward structured systems. Here’s the sequence that worked during this ERPNext Consulting engagement, in the order we actually did it.
Steps that took this firm from spreadsheet to predictable billing
- List every contract and its billing rhythm — monthly, quarterly, milestone, or hourly with a cap. Sixty clients, four patterns. Anything that didn’t fit went into a “needs a decision” pile.
- Agree what triggers an invoice. For fixed retainers it’s the calendar date. For hourly work it’s the approved timesheet. Writing this down killed most of the disputes.
- Set up the service items once, correctly — description, rate, tax treatment — so nobody retypes a contract name with a typo.
- Automate the draft, not the send. Invoices generate as drafts two days before the due date. A human reviews the list and releases it.
- Build one aging view that the account manager sees, not just finance. Chasing a late client is easier for the person who has the relationship.
Why we kept a human on the send button
Full automation sounds appealing until a client’s scope changes mid-month or a project pauses for two weeks. Two days of draft review catches roughly six exceptions a month at this firm — the kind that, if billed wrong, take three emails and a credit note to fix.
The measurable win came on the collection side. Average days to payment dropped from 47 to 29 over one quarter. That’s not a software feature. It’s the result of the person who owns the relationship seeing the overdue balance on the same screen they use every day.
What to check before you start
Count how many of your recurring invoices are edited by hand each month. If the answer is more than one in five, your contracts aren’t described clearly enough yet, and automating will just make wrong invoices go out faster.
An ERPNext Consulting engagement here isn’t about billing software. It’s about deciding what a contract actually promises, one client at a time, until the pattern is obvious.