Title: ERP or Spreadsheet for a Small Shop URL: https://zudoworks.com/answers/do-i-need-an-erp-or-a-spreadsheet/ Description: ERP vs spreadsheet: what a spreadsheet does well, where it breaks for a manufacturer, a six-point test and the middle path before a full system. Updated: 2026-11-03 # Do I need an ERP, or is a spreadsheet enough? A spreadsheet is enough while one person owns it, stock fits on one sheet and nobody needs the job cost before the invoice goes out. You need an ERP when two or more people change the same numbers, the count on the shelf drifts from the sheet, or you cannot say what a job cost after it shipped. Many shops cross that line earlier than they expect. By Arunkumar V, CTO · 03 November 2026 · 2 min read [Try ZMOS free](https://app.zudoworks.com/signup) [Book a 20-minute demo](https://zudoworks.com/contact/) - do I need an ERP - spreadsheet vs ERP manufacturing - when to move from Excel to ERP - inventory in Excel problems ## What a spreadsheet does well A spreadsheet is free, familiar and changeable in a minute. For a shop with one person running purchasing, stock and quoting, it is often the right tool for the first few years. It handles a parts list, a simple bill of materials, a reorder list and a quote template without any setup. It is also honest about its limits: everyone knows it is one file on one machine. The trouble starts when a second person needs to write to it at the same time, or when the numbers in it start to be used to make decisions about money. ## Where it breaks Five failures show up in almost every shop that has outgrown the sheet. - Two people editing: changes overwrite each other, or two copies drift apart. - No history: a stock figure can be typed over, and nobody knows what it was yesterday or why it changed. - No link between records: a purchase receipt does not update stock, and a work order does not consume material, unless someone types it twice. - No job cost: material and labour are not tied to a job, so margin is worked out after the fact, if at all. - No audit: when a customer asks who inspected a part and when, there is no record to show. ## A six-point test Score one point for each statement that is true for your shop today. Three or more points means the spreadsheet is now costing you more than software would. - More than one person changes the stock or order list each week. - The count on the shelf differs from the sheet by more than you are comfortable with. - You cannot name last month's least profitable job without a special exercise. - A purchase is sometimes raised twice, or missed, because the sheet was out of date. - A customer or auditor has asked for a record you could not find quickly. - You have hundreds of active items or more than ten open jobs at a time. ## The middle path Not every shop goes straight from a spreadsheet to a full ERP. Some move accounting to Tally, QuickBooks, Xero or Zoho Books first and keep stock in the sheet. Some add an inventory app for stock and purchasing while quoting stays in Excel. These steps work for a while and they are cheaper than a wrong ERP. They stop working when job cost is the question, because job cost needs stock, labour and purchasing in one place. If that is the question you keep asking, go to a system where those three share one ledger, and let the spreadsheet become a reporting tool rather than the record. ## Where ZMOS fits ZMOS replaces the spreadsheet for stock, bills of materials, work orders, purchasing and job costing, and keeps a stock ledger where every change is a movement with a user and a date. CSV import brings your items, customers and vendors across, and you can export everything at any time, so the sheet remains available for analysis. It suits sheet-metal, machining and fabrication shops of 10 to 50 people. A one or two person shop with a single owner of the spreadsheet, or a business with no production at all, may not need it yet. [What ZMOS does](https://zudoworks.com/zmos/) - [ZMOS vs spreadsheets](https://zudoworks.com/zmos/vs/spreadsheets/) - [the immutable stock ledger](https://zudoworks.com/zmos/stock-ledger/) - [stock control](https://zudoworks.com/zmos/inventory/) ## People also ask Short answers, each one complete on its own. ### Related answers - [How do I move from spreadsheets to an ERP?](https://zudoworks.com/answers/how-to-move-from-spreadsheets-to-an-erp/) - [Does a 10 person shop need an ERP?](https://zudoworks.com/answers/erp-for-a-10-person-shop/) - [What is an immutable stock ledger?](https://zudoworks.com/answers/what-is-an-immutable-stock-ledger/) - [What is job costing in manufacturing?](https://zudoworks.com/answers/what-is-job-costing/) - [ERP vs accounting software for manufacturers: what is the difference?](https://zudoworks.com/answers/erp-vs-accounting-software-for-manufacturers/) - [Is open source ERP good for manufacturing?](https://zudoworks.com/answers/open-source-erp-for-manufacturing/) - [What is the best ERP?](https://zudoworks.com/answers/what-is-the-best-erp/) - [All 54 answers](https://zudoworks.com/answers/) ### Inside ZMOS [Zudo AI](https://zudoworks.com/zudo-ai/)[Stock ledger](https://zudoworks.com/zmos/stock-ledger/)[Low-code forms and rules](https://zudoworks.com/zmos/low-code/)[Barcode job cards](https://zudoworks.com/zmos/barcode-job-cards/)[Roles, audit log, API](https://zudoworks.com/zmos/roles-audit-api/)[Security](https://zudoworks.com/zmos/security/)[Free trial](https://zudoworks.com/zmos/free-trial/)[Why Zudo Works](https://zudoworks.com/why-zudo-works/) At what size does a manufacturer need an ERP? Size matters less than sharing. The moment two people depend on the same stock and order numbers, and decisions about money rest on them, a spreadsheet starts to fail. That often happens well before 20 people. Can Excel be used as a manufacturing ERP? It can track items, a simple bill of materials and a reorder list for one person. It cannot post stock from receipts, consume material on work orders, log labour or keep a change history without heavy custom work that one person then maintains. What is the cheapest step up from a spreadsheet? Usually an inventory app or accounting software with basic stock, kept alongside the sheet. It fixes counting and purchasing but not job costing. Treat it as a stage rather than the destination, and keep your data exportable. How do I move spreadsheet data into an ERP? Clean the item list first: one row per item, consistent units, no duplicates. Then import items, customers and vendors by CSV, enter opening stock as a counted figure, and start new orders in the system from a fixed date.