From Spreadsheets to MRP: A Step-by-Step Migration Checklist

You've decided to move from spreadsheets to MRP software. Good. But the transition itself — the part where you stop doing things the old way and start doing them the new way — is where most shops stumble.

The fear is real: you can't afford to lose a week of productivity while everyone figures out the new system. You can't lose data during the transition. And you definitely can't miss customer deliveries because your team was busy learning software instead of making parts.

This guide gives you a phased migration checklist designed for job shops. It's built around one principle: never go cold turkey. Run the old system alongside the new one until the new one proves itself. Then cut over.

Before You Start: The Migration Mindset

A few ground rules:

This is not a one-weekend project. Plan for 2–4 weeks of parallel operation where you're running both systems. It's extra work in the short term, but it's how you avoid the "we switched and everything broke" scenario.

Pick a champion. One person (usually the shop owner, office manager, or lead estimator) owns the migration. They learn the system first, set it up, and become the go-to person when the team has questions.

Don't migrate everything at once. Start with quoting. Then add scheduling. Then purchasing. Each phase gets validated before you add the next. Trying to flip every function simultaneously is how migrations fail.

Accept imperfection. Your spreadsheets have years of accumulated data. You won't migrate all of it, and you shouldn't try. Migrate what you need going forward. The old spreadsheets stay available for historical reference.

Phase 1: Data Preparation (Week 1)

Before you touch the MRP system, organize the data you're going to migrate.

Checklist: Data Preparation

• [ ] Customer list — Compile a clean list of active customers: company name, primary contact name, email, phone, address. Remove duplicates and outdated contacts. You don't need every customer from the last 10 years — focus on customers you've quoted or shipped to in the past 12 months.

• [ ] Supplier list — Same treatment: active suppliers with contact info, what they supply, lead times, and any negotiated pricing. Include your top 10 material suppliers and your outside service vendors (heat treat, anodize, plating, etc.).

• [ ] Material catalog — List the materials your shop uses regularly: material type (aluminum, steel, stainless, etc.), alloy/grade (6061-T6, 4140, 303, etc.), form (round bar, flat bar, plate, tubing), standard sizes you stock, and current unit pricing. Twenty to thirty materials cover most small shops.

• [ ] Machine list — Every machine in your shop: name, type (CNC mill, CNC lathe, manual mill, saw, grinder, etc.), and your hourly rate for that machine. If you don't have per-machine rates, calculate them now — it's essential for accurate quoting.

• [ ] Process list — The manufacturing processes your shop performs: milling, turning, grinding, welding, assembly, inspection, deburring, etc. These map to operations in the MRP system.

• [ ] Rate card — Your current shop rates, overhead percentage, material markup, and standard margin tiers. If you've been quoting from memory, now is the time to formalize these numbers.

• [ ] Active quotes — Any open quotes that haven't been won or lost yet. These are the first ones you'll re-enter in the new system.

• [ ] Active jobs — Jobs currently in production. You'll enter these into the MRP system during the parallel-run phase.

Data Cleaning Tips

• Standardize naming. If your spreadsheets call the same customer "ABC Manufacturing," "ABC Mfg," and "ABC Mfg Inc," pick one and use it consistently.
• Verify pricing. Material prices from 6 months ago are probably wrong. Get current quotes from your top suppliers.
• Drop the dead weight. That customer who ordered once in 2019 and never came back doesn't need to be in your new system. You can always add them later if they return.

Phase 2: System Setup (Week 1–2)

With your data prepared, set up the MRP system. This is the champion's job.

Checklist: System Setup

• [ ] Company profile — Enter your company name, address, logo, and contact info. This appears on quotes, POs, and other documents the system generates.

• [ ] Users and permissions — Create accounts for everyone who'll use the system. Consider who needs full access (owner, office manager) vs. limited access (shop floor operators who only need to view schedules and update job status).

• [ ] Processes and equipment — Enter your machine list and process list from Phase 1. Set the hourly rate for each machine. This is the foundation of your labor cost calculations.

• [ ] Material types and shapes — Set up your material catalog. Enter the types (aluminum, steel, etc.), shapes (round bar, plate, etc.), and standard dimensions your shop works with.

• [ ] Customers — Import or enter your cleaned customer list. Most MRP systems let you import from CSV — use it instead of typing each one manually.

• [ ] Suppliers — Enter your supplier list with contact info and supply categories.

• [ ] Quote settings — Configure your defaults: payment terms, quote validity period, default markup percentages, tax rates, and email template for sending quotes.

• [ ] Purchase order settings — Set up PO numbering, default payment terms, and your shipping address for receiving.

Setup Validation

Before moving to Phase 3, validate the setup by creating a test quote:

1. Create a quote for a real part you've quoted recently.
2. Add materials, operations, and any outside services.
3. Compare the total to what you quoted in your spreadsheet.
4. If the numbers are close (within 5%), your rates and settings are configured correctly.
5. If they're off, debug: is it the material cost? The labor rate? The overhead percentage? The markup?

Don't proceed until a test quote produces a number you'd actually send to a customer.

Phase 3: Parallel Run — Quoting (Week 2–3)

This is where the transition begins. You'll create every new quote in both systems: your old spreadsheet and the MRP system.

Checklist: Parallel Run — Quoting

• [ ] New quotes go in both systems. Every quote that comes in gets entered in your spreadsheet (as usual) AND in the MRP system. Compare the outputs.

• [ ] Send quotes from the MRP system. Once you've validated that the MRP system produces correct quotes, start sending the MRP-generated PDF to customers instead of the spreadsheet version. Keep the spreadsheet copy as backup.

• [ ] Track discrepancies. If the MRP system and spreadsheet produce different numbers for the same quote, figure out why. Common culprits:

  • Shop rate mismatch (the MRP system uses different hourly rates than your spreadsheet)
  • Material cost differences (different unit prices or waste factors)
  • Overhead calculation differences (percentage vs. fixed vs. omitted)
  • Markup applied differently (per-item vs. total quote)

• [ ] Iterate for 5–10 quotes. After you've created 5–10 parallel quotes and the numbers consistently match (or the MRP numbers are more accurate because they're more systematic), you're ready to drop the spreadsheet for quoting.

• [ ] Cut over quoting. Stop entering new quotes in the spreadsheet. The MRP system is now your quoting system of record.

When to Extend the Parallel Run

If after 10 quotes you're still seeing significant discrepancies, don't force the cutover. The problem is in your setup, not in the approach. Common fixes:

• Re-check machine hourly rates against your actual cost data
• Verify overhead percentage against last year's financials
• Confirm material pricing is current

Phase 4: Parallel Run — Jobs and Scheduling (Week 3–4)

Once quoting is cut over, extend to job management and scheduling.

Checklist: Parallel Run — Scheduling

• [ ] Enter active jobs. Take your currently active jobs and enter them into the MRP system. For jobs that are partially complete, enter only the remaining operations.

• [ ] Convert won quotes to jobs. When a customer accepts a quote created in the MRP system, convert it to a job directly. This is where MRP saves the most time — the quote data (materials, operations, times) flows into the job without re-entry.

• [ ] Schedule the production board. Assign jobs to machines and sequence them. Compare the MRP schedule to your whiteboard or spreadsheet schedule. They should tell the same story.

• [ ] Daily operator check-ins. Have operators look at the MRP schedule (on a screen or tablet near the shop floor) alongside the existing whiteboard. Do they agree on what to run next?

• [ ] Update job status in MRP. As jobs progress, update their status in the MRP system: in progress, on hold, complete. This is the habit that takes the most effort to build but provides the most value long-term.

• [ ] Compare completed jobs. When a job finishes, compare the MRP system's data (material used, time logged, cost calculated) to what your spreadsheet tracked. The MRP system should be at least as accurate.

• [ ] Cut over scheduling. When the MRP schedule matches reality for 1–2 weeks, retire the whiteboard (or relegate it to high-level overview). The MRP system is now the scheduling source of truth.

Phase 5: Extend to Purchasing (Week 4+)

Purchasing is the last major module to bring online.

Checklist: Purchasing

• [ ] Create POs in MRP. When you need to buy material or outside services for a job, create the PO in the MRP system instead of your usual method (email, phone, separate spreadsheet).

• [ ] Use RFQs for multi-supplier quotes. If the MRP system has an RFQ module, use it to request pricing from multiple suppliers. Compare to your usual process.

• [ ] Track receiving. When material arrives, log it in the MRP system. This builds your inventory records and links material to specific jobs and POs.

• [ ] Monitor purchase requirements. The MRP system should show you what needs to be bought based on active jobs. Compare this to your manual "to-buy" list.

• [ ] Cut over purchasing. When you trust the MRP system's purchase requirements and PO tracking, stop maintaining the separate purchasing spreadsheet.

Phase 6: Decommission the Old System

Once all three modules (quoting, scheduling, purchasing) are running in MRP:

Checklist: Decommission

• [ ] Archive old spreadsheets. Don't delete them — move them to a clearly labeled archive folder. You'll occasionally need historical data from before the migration.

• [ ] Remove the whiteboard schedule. Or repurpose it for daily standup notes, metrics, or motivational quotes about hitting delivery dates.

• [ ] Update your process documentation. If you have SOPs, update them to reference the MRP system instead of the old spreadsheet process.

• [ ] Celebrate. Seriously. Migrating from spreadsheets to MRP is a significant operational upgrade. The team should know it matters.

Timelines: What's Realistic

| Shop Size | Data Prep | Setup | Quoting Parallel | Full Parallel | Total | |-----------|-----------|-------|-------------------|---------------|-------| | 1–5 employees | 2–3 days | 1–2 days | 1 week | 1 week | 2–3 weeks | | 5–15 employees | 3–5 days | 2–3 days | 1–2 weeks | 2 weeks | 4–5 weeks | | 15–30 employees | 1 week | 3–5 days | 2 weeks | 2–3 weeks | 5–7 weeks | | 30+ employees | 1–2 weeks | 1 week | 2–3 weeks | 3–4 weeks | 7–10 weeks |

These timelines assume the migration champion is spending 1–2 hours per day on the transition alongside their normal duties. If you can dedicate more time, it goes faster.

Common Migration Pitfalls

Pitfall 1: Trying to Migrate Historical Data

You do not need 5 years of old quotes in the new system. You need your rate card, your customer list, and your active jobs. The old spreadsheets are your archive. Use them when you need to look up a past quote — don't spend weeks re-entering data you'll rarely reference.

Pitfall 2: Going Live on a Monday

Don't cut over on the busiest day of the week. Cut over quoting on a Wednesday or Thursday, when the quote volume is moderate and you have the rest of the week to iron out issues before the weekend.

Pitfall 3: Training Everyone at Once

Train the champion first. Let them get comfortable over a week. Then train the office staff. Then train the shop floor. Stagger it so the champion can support each group as they onboard.

Pitfall 4: Expecting Instant ROI

The first month will feel slower, not faster. You're building new habits, learning new workflows, and probably entering some data twice during parallel runs. The efficiency gains show up in Month 2–3, once the team is comfortable and the system has enough data to be useful.

Pitfall 5: Not Setting a Cutover Date

Without a firm date, the "parallel run" becomes permanent. You end up maintaining two systems forever. Set a date for each cutover phase and stick to it. If a specific module isn't ready, push that module's date — but don't stall the entire migration.

Key Takeaways

1. Never go cold turkey. Run old and new systems in parallel until the new one proves itself.
2. Clean your data first. Garbage in, garbage out. Spend the time upfront.
3. Start with quoting. It's the most self-contained module and gives the fastest confidence boost.
4. Pick a champion. One person owns the migration, learns first, and supports the team.
5. Validate with real jobs. Test quotes against known outcomes before cutting over.
6. Set cutover dates. Parallel runs without deadlines become permanent dual maintenance.
7. Don't migrate history. Bring forward what you need. Archive the rest.

ForgeMRP is designed for fast migration. Set up your shop, enter your first quote, and start running in under 3 hours — no implementation consultant required. Get started or explore the help docs.