Kumar Deepansh

Home / Solutions / Custom business software and internal tools

Excel and WhatsApp to a shared web board for stock and orders

What I hear

We track stock, production and client status in Excel and WhatsApp, and things keep falling through because nobody knows which version is current.

A shared web board gives everyone one current view of stock, production steps or client status, with a clear record of who changed what. I build it as a small web app: cards or rows in columns, filters, comments, and an interface that can run in more than one language, because teams that share a board are often not all reading the same one.

What this looks like in practice

Take production. Each order is a card moving through your own stages, for example received, in progress, quality check, ready, shipped. Opening a card shows quantity, due date, notes, photos and a history of every move. For stock, the same board becomes a table: item, location, quantity, minimum level, with a low-stock highlight.

Client status works the same way, with stages that match how you work with clients rather than a generic sales funnel.

Why spreadsheets and chat groups break down

Excel fails when several people hold copies, when formulas get overwritten, or when one person owns the “real” file. WhatsApp fails differently: the decision is in the chat, but the status is not anywhere you can filter. A board fixes both by making each item one record with one history. The weak spot I design around is permissions. Not everyone should edit prices or delete rows, so I set roles: view only, update status, edit everything.

What I build

  • Boards and tables built around your own stages and fields.
  • Per-item history, comments and attachments.
  • Roles and login, usable on phone and desktop.
  • Multi-language interface, chosen per user.
  • Email or message notifications on the moves that matter, such as “ready to ship”.
  • Excel import at the start and Excel or CSV export at any time.

When this is the wrong answer

If a single person edits a sheet that nobody else needs, keep the sheet. If you need full accounting or complex warehouse logic, a larger system is better, and I would say so. The board is for the middle ground, where the process is simple but the sharing is broken.

How it goes live

I ask for your current sheet and a description of how an item moves from start to finish. I show a working version early so the team can correct the stages and fields. Then I import your data, train the team in one short session, and run the old and new methods side by side for a short period. The scope and one fixed price are agreed before work begins, and monthly maintenance is optional.

What it replaces

a shared spreadsheet and a WhatsApp group used as a status board

How pricing works

One fixed price, agreed before I start. Optional monthly maintenance after handover.

Questions people ask

Will my team actually use it if they love WhatsApp?

They will if it is faster than the chat. I keep the board to a few screens that work on a phone, and I can add a link or notification so people are pulled into the board rather than asked to remember it.

Can the interface be in several languages?

Yes. Labels and messages are kept in language files, so each user can pick their language. Your own data, such as product names, stays as you typed it. I will agree which languages with you before I start.

Can I keep my existing Excel data?

Yes. I import the sheet once, clean obvious duplicates with you, and the board becomes the single place to edit. You can still export to Excel whenever you want.

What if two people edit the same item at once?

The system saves each change as its own entry with the user and time, and warns when someone is editing a card that just changed. Nothing is silently overwritten like in a shared file.

Related

Tell me what is slowing your business down.

Twenty minutes, no charge. If I can fix it, you get a fixed price. If not, I will say so.