Move Stock In and Out to a Shared Team Screen
Stock should increase when goods arrive, decrease when sold or used, and show the reason when an item returns. I can organise the movements spread across your Excel and Google Sheets files in a shared inventory screen, starting with the way your small business already tracks stock.
Calculate quantities from movements
A team member selects the product, chooses a receipt or issue and records the quantity. The screen calculates stock from those movements. A difference found during a count becomes a separate count adjustment. Linking a return to the earlier issue helps explain why the goods came back. We agree checks for repeated submissions and attempts to issue more than is available.
Choose between an improved sheet and a custom app
An improved spreadsheet may be enough for a simple process used by a few people. When you need task-specific screens, movement history and shared records, I can develop a custom web app. A product list and receipt-and-issue form give us a narrow first version to try quickly. The team checks an actual receipt, issue and return; low-stock alerts and monthly summaries can follow where useful.
Frequently Asked Questions
How is opening stock entered?
A stock count or verified spreadsheet at an agreed date becomes the opening quantity. We define when subsequent movements start to avoid counting old receipts again.
How do we correct a wrong quantity?
Depending on the movement’s status, we use a correction or reversal. The reason and person responsible stay in the record so the quantity change can be reviewed.
Discuss your workflow
Describe your workflow on the contact page. Explore other examples of custom web apps for your team.
Related services
How do I work?
Work-hour packages
Tell me about your website and what you need on WhatsApp or by phone; we agree on a work block of somewhere between 5 and 40 hours and I start doing what is needed. What you get is not a calendar window — it is net working hours spent directly on your business. I can use 40 hours working three days straight, or deliberately spread it out and finish it over a year — whatever the work calls for. I do not spend my time estimating how long something will take, I spend it doing the work; every hour I spend has a lasting result on your site. We keep going for as long as you find it useful.
Why not monthly?
Is 40 hours a week?
On a fixed monthly fee both sides are watching the wrong thing: you watch a fixed cost, the other side watches how many more contracts like this they can line up. Working by the hour puts us both in front of the same thing — the real value of the work that got done. I know not having an upfront answer to "how much will this cost in total?" is the natural cost of this model. But instead of paying a fixed fee for months to a setup that is not producing results, you only pay for the qualified time spent on your work — and you see exactly where that time went, start to finish. That is why my clients keep coming back.