The Problem: Running a Business on Anecdotes and Spreadsheets
The owner of a 40-person specialty food manufacturer made almost every strategic decision based on “how things felt.” Were sales up this month? Nobody knew until the accountant sent a report two weeks later. Which product lines were most profitable? The owner guessed it was the organic sauces, but the actual numbers were buried in an Excel file nobody had time to analyse. The company was losing money on one popular product for two years before anyone noticed.
How ERPNext Solved It
The company turned on ERPNext’s reporting and analytics tools, customising dashboards for each department. The key enhancements were:
- Executive dashboard – a single screen showing revenue, gross profit, cash balance, and top-selling products, refreshed every few minutes.
- Product profitability analysis – ERPNext automatically calculated the gross margin for each SKU by linking sales price to raw material cost and production time.
- Sales trend reports – month-over-month and year-over-year comparisons for any product or customer, with drill-down to individual invoices.
- Automated email reports – every Monday morning, the CEO received a PDF with the key numbers for the prior week.
The Improved Result
Within one month, the owner discovered that one “best-selling” sauce had a margin of only 8% after packaging and was dragging down overall profitability. He reformulated the recipe and switched to cheaper packaging, boosting that product’s margin to 25%. Overall company profit increased by 18% in the next quarter. “I used to fly blind,” the CEO says. “Now ERPNext shows me exactly where to focus my energy to make the most money.”