Picture this: five companies under one roof, five different ways of recording expenses, and a finance team that spent the first two weeks of every month glued to Excel. The group’s accountant called month-end the nightmare that never ends. Consolidated reports were delivered on the 22nd of the following month, which meant decisions were always made on stale data.
The mess came from small differences nobody thought mattered. One entity categorized freight as cost of goods, another as a selling expense. Intercompany loans were tracked differently in every ledger, and reconciling them took the finance team three full days each month. Twelve days of value were lost every single month, and the whole group just accepted it.
Standardize first, automate second
ERPNext Consulting started with the boring stuff, which is where all the money was hiding. They created one chart of accounts that all five entities had to follow, with mandatory fields for cost center and project code. Then they mapped intercompany transactions so that when entity A invoiced entity B, the system recorded both sides in one step.
The finance team resisted at first, especially the accountant who had her own clever spreadsheet. But once the first automated consolidation ran without a single manual adjustment, she became the biggest supporter. Her team now closes the books by the 4th business day, and the consolidated view of the group is available the next morning.
What a smooth close actually requires
Here is the minimum standard:
- One shared chart of accounts, enforced by the system so nobody can quietly invent a new category.
- A fixed close calendar with named owners for each task, from bank reconciliation to intercompany matching.
- A golden rule that any unapproved expense from the previous month gets rejected, not tucked into next month.
The group eliminated about 120 hours of manual consolidation work per month. More importantly, the CEO started getting real answers — which entity was profitable, which cost center was bleeding, and which client segment deserved more attention. The culture changed from we’ll fix it later to it must be right today.
If your month-end takes more than a week, run a simple audit: list every manual step between the last transaction and the final report. Each one is a candidate for elimination or automation. ERPNext Consulting specializes in exactly that kind of cleanup, but you can start by simply asking each finance person what they spent Wednesday on.