ERPNext Consulting: Closing the Books in 3 Days Instead of 11 — Working Backwards

Let’s start at the end. A 140-employee food processor now closes its monthly books in three working days, with the same five-person finance team, on the same systems it had five years ago.

Two years earlier, the close took 11 days, depended on a 40-tab spreadsheet that one person understood, and produced numbers that were still being corrected three weeks later. Here is the story backwards, starting with what day three looks like now, after an ERPNext Consulting project that changed almost nothing about the tools and a lot about the habits.

Day 3: the close is mostly a review

By the morning of day three, the bank accounts are matched, the inventory is valued, and the only thing left is a checklist of six review items. The controller signs off before lunch.

There are no all-nighters and no spreadsheet sent around for “final checks.” That is the visible result. The cause sits much earlier in the month.

Day 1, every day: the 15 minutes that ended the scramble

The team added a short routine at the end of every working day, and this is the piece most companies skip because it feels too small to matter.

  1. Post everything received that day, including deliveries that arrived without paperwork. Nothing waits for the invoice.
  2. Match yesterday’s bank transactions. One day of activity takes about four minutes; a month takes half a day.
  3. Look at the exception report — short shipments, price mismatches, unapplied credits — and clear or assign each item before leaving.
  4. Count the three highest-value ingredients in the production area. Just three, every day, rotating through the list.

Fifteen minutes a day replaced 60 hours of month-end panic. The finance manager told me she stopped dreading the first of the month for the first time in nine years. On its own, though, the daily routine was not enough. Two structural things were still creating the mess.

The two things that were generating the work

First, inventory was valued once a month from a 300-row spreadsheet, which meant every month ended with a three-day reconciliation. Second, revenue was recorded when cash arrived rather than when goods shipped, so sales figures were argued about every single period.

Changing those two rules cut the close from 11 days to 6. The daily routine cut it from 6 to 3. This is the part of the ERPNext Consulting work clients resist most, because it means giving up a spreadsheet people have learned to trust.

Three months after the switch, correction entries after close fell from about 200 lines a month to fewer than 20. The leadership team now sees last month’s numbers on the fourth working day instead of the fourteenth. Eight extra days of knowing, every month, is worth more than any report the finance team could have built under the old cycle.

Tomorrow, take the one task that always piles up at month end — usually bank matching — and do it daily for two weeks. Time yourself. By Friday you will have your own business case, written in minutes saved.