From Spreadsheets to Custom ERP: How a Lagos SME Reclaimed 40 Hours a Week

Midwest Logistics and Supplies had 30 employees, three departments, and a growing customer base. They also had 47 spreadsheets. Every department maintained its own set of Excel files for inventory, sales, purchases, payroll, and customer records. Data was duplicated, outdated, or just plain wrong. The finance team spent three days every month reconciling figures that never matched across departments.

The managing director knew the spreadsheets were holding them back, but off the shelf ERP systems were either too expensive or required changing how the business operated. He wanted a system built for the way his company actually worked, not the other way around. We built a custom ERP that replaced every spreadsheet and saved the company 40 hours of manual work per week.

The Challenge

47 Spreadsheets, Zero Coordination

Midwest Logistics and Supplies ran their entire business on spreadsheets. The inventory team tracked stock in one file, sales recorded orders in another, finance managed invoices in a third, and HR kept employee records in a fourth. None of these files talked to each other. When a sale was made, the sales team would mark it in their sheet, but the inventory team would not know about it until someone sent an email with the update.

This meant stockouts happened regularly because the inventory count did not reflect real time sales. The finance team spent the first three days of every month trying to reconcile revenue, expenses, and inventory movements. It was common to find differences of millions of naira between what the sales sheet showed and what the bank statement said. The MD told us the spreadsheets were costing them money, but he was not sure by how much.

No Central Source of Truth

When a manager needed a report, they had to request data from multiple departments, wait for each team to prepare their numbers, and then manually combine everything. By the time the report was ready, the data was already a week old. Decisions were being made on stale information, and the company was missing opportunities because they could not react quickly to changes in demand or cash flow.

The MD had looked at popular ERP platforms like Odoo and SAP Business One, but the implementation costs were high and the setup required consultants who did not understand the Nigerian business context. He needed something more practical and affordable.

Our Solution

A Modular ERP Built Around Their Workflow

We built a custom ERP with four core modules: Finance and Accounting, Inventory Management, Human Resources, and Procurement. Each module was designed to mirror the company's actual processes rather than forcing them into a generic template. The finance module handles invoicing, expense tracking, bank reconciliation, and financial reporting. The inventory module tracks stock levels across two warehouses, generates low stock alerts, and supports batch tracking.

The HR module manages employee records, attendance, leave requests, and payroll calculations. The procurement module handles purchase orders, supplier management, and goods received notes. All modules feed into a central dashboard that gives the MD a real time view of revenue, expenses, stock levels, and employee costs.

Data Migration and Team Training

We migrated five years of historical data from the 47 spreadsheets into the ERP. This was the most delicate part of the project because the data was inconsistent across files. We built validation scripts to clean and normalize the data before importing it, and we worked with each department head to verify that the numbers matched their records.

Training was done in small groups over two weeks. Each department got hands on sessions with their specific module. We also created simple video guides that new employees could watch instead of needing live training sessions. The adoption rate was high because the system looked and felt like the spreadsheets they were used to, just better connected and automated.

The Results

After the full deployment, Midwest Logistics and Supplies eliminated spreadsheet based operations entirely. The finance team's monthly reconciliation went from three days to 30 minutes. Data accuracy hit 99% because every transaction was entered once and propagated automatically across all modules. The MD estimated that the company saved 40 hours of manual data entry and reconciliation work every week across all departments.

The real time dashboard changed how decisions were made. For the first time, the MD could see his cash position, stock levels, and outstanding invoices on one screen. He told us he discovered that one product category he thought was profitable was actually losing money because the spreadsheets had been miscalculating the cost of goods sold. The ERP caught it in the first week.

Key Takeaways

• Custom does not mean expensive. The ERP cost a fraction of what commercial systems would have, and it fit the business perfectly because we built only what they needed.
• Data migration is critical. Cleaning and validating the old spreadsheet data was half the work. Skipping this step would have meant garbage in, garbage out.
• Train in small groups. Department specific training sessions got higher adoption than a company wide workshop would have. People learned what mattered to their job.
• Go module by module. We deployed the finance module first, then inventory, then HR, then procurement. Each module went live once the team was comfortable with the previous one.

Frequently Asked Questions