BimpBlog

ERP Implementation for a Small Manufacturer: The First Monday Without Excel After Three Weeks

A fictional joinery of 8 people: how to move 140 items, 60 counterparties and 25 specifications from Excel into Bimp in three weeks and close the spreadsheets.

DO
Dmytro ObukhovCo-Founder & CEO
Table of contents
In short
  • ERP implementation for a small manufacturer has five blocks: company setup, import of products with stock, import of counterparties and specifications, opening balances and reconciliation with the old spreadsheets.
  • In a fictional joinery of 8 people, 140 items, 60 counterparties and 25 specifications end up in Bimp within three weeks. The shop does not stop, because for two weeks the first orders run in parallel with Excel.
  • The transfer is verified with the "Stock movement" and "Counterparty settlements" reports: the totals must match the spreadsheets to the cent. After that Excel is closed.

The company is fictional. Every action in Bimp is a real product feature. The figures and timing in the example are invented, and the arithmetic can be checked on a calculator.

ERP implementation for a small manufacturer fits into three weeks if the data already sits in spreadsheets. In the example a joinery of 8 people moves 140 catalog items, 25 product specifications and 60 counterparties from two Excel files. The first Monday without spreadsheets comes on day twenty-two.

The owner of Ashwood Joinery was afraid of something else: half a year of project work, a stopped shop and errors in the stock. He stands in the shop himself, so only evenings remain for the launch. Below, those evenings are laid out step by step.

Why does a workshop owner postpone the launch?

Ashwood Joinery (a fictional company) makes doors, windows and stairs to order. It has 8 people: the owner, a manager, a technologist and storekeeper, four joiners and a part-time accountant. Accounting is kept in two Excel files. The first holds the item catalog with stock and the product specifications, the second holds counterparties and settlements.

The fear of launching has three causes, and each can be removed with a concrete step. First: it is unknown how much time it will take. Second: it is unclear how to move 140 items without errors. Third: the shop cannot stand still, because orders are waiting.

Before starting, the owner spends an hour over the files: he removes empty rows, fixes units of measure and fills in SKUs where there were none. This is the most time-consuming step, but it is done once.

The result of the preparation is this. The spreadsheet had 152 catalog rows, 12 of them duplicates (“beam 50x50” and “Beam 50×50”), so after cleaning 152 - 12 = 140 items remained. Of these, 115 are materials and hardware and 25 are products: 115 + 25 = 140. There are 60 counterparties: 38 customers and 22 suppliers.

How does ERP implementation for a small manufacturer go in Bimp?

The order of steps follows the launch checklist: each next step uses the data of the previous one.

Week 1. Company and directories. The owner creates the company and checks the accounting settings: the accounting currency cannot be changed once documents are entered, so it is chosen right away (Creating a company, Organizations). Next come warehouses (materials and finished goods), a bank account and a cash desk, and users with roles: owner, manager, storekeeper, accountant.

On Friday the products are loaded. In the “Warehouse → Data import” window you turn on “Products” and “Balances and cost price”, choose “By SKU” as the product search so that no duplicates are created, and map the columns. Details: Importing products and stock, What can be imported into Bimp. The “Cost price” column is filled with the purchase price. The selling price does not go here: otherwise the margin in the reports comes out zero. The Confirm button uploads only the correct rows, and the erroneous ones stay for correction.

Week 2. Counterparties, specifications, prices, balances. Monday goes to counterparties: you fill in the Bimp template without changing the column names or order and load 60 cards (Importing counterparties). The specifications of 25 products are loaded with a template in “Production → Specifications → Import”. Materials and products must already be in the directory with SKUs, so this step comes after the products (Importing specifications). The “Doors, stairs” price list is loaded in the same import window with the “Customer price list” switch on (Importing price lists).

Then the opening balances. Raw material stock already entered Bimp with the product import, so in the “Opening balances” document you fill in the cash and settlements tabs: cash desk, account, debts of customers and suppliers. Everything is entered with one date, for example the last day of the month (Opening balances, Settlements). A mistake in the “Advance” checkbox turns a debt the other way round, so it is checked on every row.

Week 3. Parallel work and reconciliation. The manager enters new customer orders in Bimp (Customer order), and the technologist launches production orders from the specifications (Production order). Excel still sits alongside, but new data is no longer entered there, and it is used only for reconciliation.

The very first test sale shows whether everything is in place. If materials are written off from the right warehouse and the balance after the shipment matches the expected one, the directories are set up correctly. If not, the error is fixed before real documents appear in the system.

Which numbers must match before Excel is closed?

Before closing the spreadsheets, the owner compares them with the Bimp reports.

The comparison covers raw material stock, debts and cash. For the fictional joinery it looks like this.

BlockIn Excel, €In Bimp, €Report
Timber (beams, boards)10,25010,250“Stock movement”
Panel materials3,7003,700“Stock movement”
Hardware4,6904,690“Stock movement”
Lacquers, glue2,4252,425“Stock movement”
Total raw material stock21,06521,065
Customer debt (3,000 + 1,600 + 760)5,3605,360“Counterparty settlements”
Supplier debt (1,950 + 1,210)3,1603,160“Counterparty settlements”
Cash desk and account (960 + 2,390)3,3503,350“Cash flow”

Stock total: 10,250 + 3,700 + 4,690 + 2,425 = €21,065. The “Stock movement” report shows the opening balance, receipts, write-offs and closing balance by warehouse, in units or in value (Stock movement). The “Counterparty settlements” report gives each customer and supplier an opening balance and a closing debt (Settlements).

If a number diverges, the cause is looked for in the opening balances document: a double entry, a missed item or a wrong “Advance”. A detailed list of checks is covered in the article for the first days after launch, and a short version is enough here: compare quantities, then values, then debts.

Challenge

There are 8 people, accounting sits in two Excel files, and the owner stands in the shop. An ERP launch looks like a half-year project with a production stop.

Solution with Bimp

A launch checklist, import of products with stock, counterparties, specifications and the price list from Excel, opening balances and reconciliation by reports. The shop works in Excel and Bimp in parallel.

Result in numbers

Within three weeks Bimp holds 140 items (152 rows minus 12 duplicates), 25 specifications and 60 counterparties. Raw material stock of €21,065, customer debt of €5,360 and supplier debt of €3,160 match the spreadsheets. On day twenty-two Excel is closed.

How do you close Excel without stopping the shop?

Only those who enter documents work in the system at the start: the owner, the manager, the storekeeper and the accountant. The joiners do not need the system on day one: the technologist hands them their orders. This removes training of all eight people at once from the launch.

Parallel work should last no longer than reconciliation needs. In the fictional workshop it is planned for five working days of the third week. During that time six production orders are completed, and each ends with the written-off materials, stock and cost price in Bimp matching what the owner sees in the shop.

When no divergences remain, the first Monday without Excel arrives. The spreadsheets go to the archive, and in Bimp a lock date is set so that nobody edits documents of past periods (Lock date). The owner enters the next order straight into Bimp.

What does this give the owner?

The main change is that the launch stops being an event postponed until a “calmer season”. It is split into evenings, and the risk of error is closed by a reconciliation to the cent.

The owner gets a clear plan instead of a vague “we will launch someday”. Every week ends with a concrete result: by Friday of week one the catalog is in the system, by the end of week two counterparties, specifications and balances are loaded, by the end of week three the reports are reconciled. The shop does not stop, because it works on the same documents that are already kept in Excel.

The manager sees stock and material reserves without asking the shop. The technologist has the specifications from which the planned cost price is calculated. The part-time accountant looks at debts in a report and does not assemble them from two files. Bimp is a Ukrainian cloud ERP for manufacturers, and this whole transition runs on standard functions, with no programming.

The minimum set of functions for a shop of up to 20 people is covered in ERP for Small Manufacturing: The Minimum Set and Launch Without a Stop. For how the quick start works for production accounting, see the Bimp for manufacturers page.

Scenario limits

The three weeks in this example are a model and no guarantee. Real timing depends on the quality of the spreadsheets, the number of stock lines and the time the owner can give to the launch, so it is agreed with the implementation team. Importing specifications needs ready product directories and the Bimp template, and in spreadsheets without SKUs materials have to be matched by name. Bimp does not fix errors in the source data: if the cost price in Excel was a selling price, the import loads it as it is. Some help articles that the steps rely on have a verification status, so check the button names against your version.

FAQ

How long does it take to launch Bimp in a small shop?

It depends on the volume of data. Setting up the company takes hours, and most of the time goes into preparing the spreadsheets and reconciling them. The timing in the example is fictional and is agreed with the implementation team at the start of the project.

Do you have to enter products by hand?

No. Products and stock are loaded from Excel in one file through "Warehouse → Data import" (up to 9,000 items). Counterparties and specifications are loaded from Bimp templates.

What if the file contains duplicates and errors?

Bimp marks problem rows during mapping, and the Confirm button uploads only the correct ones. It is better to remove duplicates before the import, and searching for existing products by SKU prevents copies from being created.

Can you work in Excel and Bimp at the same time?

Yes, during the parallel run. Opening balances are entered with one date, after which new operations are kept in Bimp, and Excel stays for reconciliation until the totals match.

Draw up a launch plan for your shop

In a Bimp ERP demo a specialist breaks the transfer of your spreadsheets into steps with you and shows what the first week in the system looks like.

Book a demo
DODmytro ObukhovCo-Founder & CEO