Case Study: A US Distributor Moves from QuickBooks and Spreadsheets to ERP in 10 Weeks

A US distributor with 4 warehouses and 3,000+ SKUs left QuickBooks for ERP: stock-outs near zero, 90% automatic reorders, month-end close in half a day.

By 3 min read

This case study looks at a US distributor that outgrew QuickBooks and spreadsheets. The client is not named; the figures are the ones already published on our founder's profile.

The project at a glance

BeforeAfter
SystemsQuickBooks, spreadsheets and one person's memoryOne ERP for inventory, purchasing, manufacturing and accounting
Warehouses and catalogue4 warehouses, more than 3,000 SKUsSame, with stock visible in one place
Stock-outs2–3 a weekNear zero within two months
Purchase ordersRaised by hand90% generated by reorder rules
Month-end close4 daysHalf a day
Time to go live–10 weeks
Payback–By month 4

The situation

The company had 4 warehouses and more than 3,000 SKUs, and its tools had not kept up:

  • Accounting ran in QuickBooks.
  • Stock was tracked in spreadsheets.
  • Reordering depended on one person's memory.

The result: products ran out two or three times a week, and closing the books took four days every month.

What the implementation covered

The ERP implementation covered inventory, purchasing and manufacturing.

  • Stock in one place. All 4 warehouses and more than 3,000 SKUs in one system, with real-time quantities instead of spreadsheets.
  • Reorder rules instead of memory. Minimum and maximum stock levels and vendor lead times let the system generate purchase orders when stock runs low. Today 90% of purchase orders are generated this way.
  • Small settings over custom code. A reorder rule set up in minutes can save more time than a new custom module, and it keeps future upgrades simple.

The results

  • Stock-outs fell from 2–3 a week to near zero within two months.
  • Reorder rules now generate 90% of purchase orders automatically.
  • Month-end close went from 4 days to half a day.
  • The project went live in 10 weeks and paid for itself by month 4.

What other distributors can take from this

  1. Start where it hurts most. Go live with the area in the most pain, make it stable, and let the team win once before adding the next part.
  2. Judge an ERP on your worst order, not a demo. Ask vendors to run last month's messiest order with your data.
  3. Replace memory with rules. If reordering depends on one person, it will fail the week they are away.
  4. Clean the data first. Fixing product codes, units and opening stock is cheaper before go-live than after; messy data is the most common reason ERP timelines slip (see how long an ERP implementation really takes).
  5. Watch month-end. If close takes days because stock values do not reconcile, the problem is the system, not the accountants.

If you are planning a similar move, our guides on planning an ERP budget and SaaS versus custom software costs help you size it.

How MFY Innovatech works with distributors

Our team implements ERP for wholesale distributors in the United States as an official Odoo partner and a US-registered company: multi-warehouse inventory, reorder rules, purchasing, lot and serial tracking, and accounting in one system. See ERP and inventory software for wholesale distributors and our ERP implementation services.

Frequently asked questions

How long did the ERP implementation take?
The implementation, covering inventory, purchasing and manufacturing, went live in 10 weeks. A focused scope and standard ERP flows are what make timelines like that possible.
What results did the distributor see?
Stock-outs fell from 2–3 a week to near zero within two months, reorder rules now generate 90% of purchase orders automatically, and month-end close went from 4 days to half a day. The project paid for itself by month 4.
Why did QuickBooks stop being enough?
QuickBooks handled the accounting, but stock across 4 warehouses and more than 3,000 SKUs lived in spreadsheets and in one person's memory. Without real-time stock and reorder rules, the company ran out of products every week and closing the month took days.
Can a distributor keep QuickBooks and add inventory software instead?
Sometimes, for a single warehouse and a small catalogue. Once you have several warehouses, many SKUs, purchasing based on reorder points and month-end close depending on stock values, one system for inventory, purchasing, sales and accounting usually removes more work than it adds.
Why is the client not named?
We keep client names confidential unless a client chooses to be named. The figures in this case study are the ones already published on our founder's profile.
Case studyWholesale distributionERP implementationQuickBooksInventory managementOdooUSA
Related serviceERP & OdooOfficial Odoo partner. Implementation, customization and accounting alignment.

Keep reading

Talk to us directly

Prefer a quick conversation?

Message us on WhatsApp or call. You'll reach the team, not a call centre.

Start a project

Let's build something precise.

Tell us what you need to ship. You'll hear back within one business day, with questions rather than a sales pitch.