AICLOUD.BG

Working with leading AI partners.

Claude Gemini OpenAI AWS Vertex AI Databricks DeepSeek Cerebras Qwen Stability AI

Guide

How to stop using Excel for stock without stopping work

Excel is almost every company's first stock program, and for a long time it does a good job. So we won't try to convince you it is bad. This guide covers when it stops being enough and how to move to proper software without a week of chaos or retyping everything by hand.

When Excel does the job

If one person keeps the spreadsheet, you have a few dozen items and one warehouse, and nobody needs to check stock from a phone, Excel is enough and there is no point replacing something that works. Below are the signs that tell you it no longer does.

The signs that stock has outgrown the spreadsheet

It is rarely one big problem. Usually several small ones pile up until they get in the way every day.

  • The spreadsheet has several versions (“stock_new”, “stock_new_2”) and nobody is sure which one is right.
  • Two people open it at once and one of them loses their changes.
  • People phone to ask about stock, because the spreadsheet sits on one computer.
  • Someone deleted or moved a formula and the numbers have been wrong for weeks without anyone noticing.
  • You can’t see who changed a quantity or why.
  • You have a second warehouse, a shop or online sales, and each place keeps its own sheet.
  • The stock count always comes out with a difference and nobody can find the reason.

Step 1: don’t tidy the spreadsheet first

The most common mistake is deciding to “clean up the Excel first” and then spending months on it. The spreadsheet is imported as it is, with your columns, names and abbreviations. Tidying comes afterwards, inside the program.

Step 2: describe how the goods move

Menus and buttons don’t matter at this stage. What matters is describing what happens in the warehouse: who receives a delivery, who issues goods, what document goes with each movement and which items have a minimum level. That description becomes the brief for the program.

Step 3: pick a date and count

Choose the day from which the program becomes the record that counts, and do a stock count on exactly that date. Use the counted quantities as your opening stock. The figures in the spreadsheet may have drifted from reality long ago, so don’t start from them.

Step 4: run both side by side for a short while

For a few weeks, record movements in both the program and the spreadsheet, and compare them at the end of each week. Once they match and people open the program first of their own accord, you stop filling in the spreadsheet.

Step 5: keep the Excel as an archive

There is no need to delete it. The old spreadsheet stays for reference, read-only, and all new movements are recorded in one place.

What you gain

There is more detail on the Warehouse software and Stock and sales software pages. If you run a shop, start with the guide How to track stock in a shop. If you are thinking of writing the program yourself with a chat assistant, read Can ChatGPT build software for your company? first.

  • One shared stock figure the whole team can see according to their role, from a phone or a computer.
  • Every movement recorded with its document, date and person in an audit log.
  • A reminder whenever an item drops below its minimum.
  • Reports you ask for in plain words, such as “what hasn’t moved in three months”.
  • You can export the data back to a spreadsheet at any time, so the import is reversible.

Frequently asked questions

Do we have to stop work while we switch?

No. You keep the program and the spreadsheet going together until the numbers match, and only then do you stop filling in the spreadsheet.

Our spreadsheet is a mess. Is that a problem?

It isn’t a problem. We import it as it is, and you don’t need to rearrange it to fit someone else’s template first.

How much does the program that replaces Excel cost?

Signing up is free, so you can try it without entering a card. The program is paid for with prepaid credits based on how much it is used, with no subscription, and while the project is active there is also a daily hosting fee. You can see what credits cost on the Pricing page. If you would rather we handle the switch with you, have a look at Services.

Show us your spreadsheet

Sign up, upload your stock spreadsheet and describe how goods move. If the program you get doesn’t fit your warehouse, you haven’t paid anything.