The problem
For an equipment service and operations business, the numbers that matter most live inside the ERP, the system that holds invoices, orders and customers. They are hard to see there. Finance staff pulled reports by hand to find out who owed money, and leadership had no quick way to see which work was actually profitable.
Sales had a smaller version of the same problem. Requests arriving by email or through a website had to be re-typed into the ERP before anyone could follow up.
What I built
Three connected tools, all reading from and writing to the ERP.
Accounts-receivable dashboards. A dashboard of what customers owe and how overdue it is, so collections can start with the right accounts rather than a spreadsheet.
CFO margin analysis. A view built for the CFO that shows margin so leadership can see where the business makes and loses money, without waiting for a monthly report.
A public request form. A form on the company's website that creates a lead directly in the ERP as soon as it is submitted. Email notifications go to the right people, so a request is routed and visible immediately instead of sitting in an inbox.
Stack
- Integration with the company's ERP system
- Web dashboards for finance and leadership
- A public web form that writes straight to the ERP
- Email routing for new leads
Outcome
Finance and leadership see receivables and margin in one place without pulling reports by hand. New leads reach the ERP the moment they are submitted, with the right people notified, so nobody has to retype them.