Stock intelligence for shops that run on spreadsheets
Your stock file already knows what to buy. It just cannot say it.
Spend Crumbs reads the file you already keep — the messy one — and answers the question you actually have: what do I reorder, what do I stop buying, and where is my money sitting still?
Business health
69 / 100
workable, a few things to fix
Cash at risk
KSh 234,400
sitting in stock that is barely moving
Reorder budget
KSh 98,880
to restock what is running out
Rows set aside
4 of 16
not safe to include in the figures
Do this first
Reorder Amoxicillin 500mg at Kisumu — 5.7 days of stock left
Order about 55 units soon to avoid stockout. KSh 69,300 of sales a month runs through this product.
| Product | Branch | Stock | Sold / 30d | Days left | Decision |
|---|---|---|---|---|---|
| Amoxicillin 500mg caps | Kisumu | 8 | 42 | 5.7 | Reorder now |
| Insulin pen | Kisumu | 3 | 9 | 10 | Reorder now |
| Face masks, 50s | Eldoret | 320 | 6 | 365+ | Stop buying |
| Paracetamol 500mg | Nakuru | 240 | 96 | 75 | Keep stable |
What actually happens
A row of numbers becomes a sentence you can act on
You already have the figures. What you do not have is the half-hour to work out which of four hundred rows is about to cost you a sale.
What you have
Correct, complete, and silent. Nothing in it tells you that it runs out on Thursday.
What you get
Reorder now
Six days of stock left. Sells 42 a month. Order about 55 units.
The same row, read against every other row in the file, and turned into an instruction.
The part that matters
Your file is messy. That is the whole point.
A totals row averaged in with the products. A price nobody ever filled in. The same item entered twice at two different costs. Feed those to a spreadsheet formula and it answers confidently and wrongly. Spend Crumbs finds them, leaves them out of every figure, and shows you exactly what it left out and why.
-
Totals rows
TOTAL PHARMACY STOCK · 1,141 · 320
Reads like your best-selling product. It is your whole shop, counted twice.
-
Missing prices
Cetirizine 10mg · 45 in stock · price —
Without a selling price there is no revenue and no margin. Averaging it in drags both down.
-
Impossible figures
Stock −12 · Sold −3
Negative stock and negative sales are data entry, not trading. They quietly cancel real numbers out.
-
Conflicting duplicates
Bandage roll · KSh 150 Bandage roll · KSh 165
Same product, same branch, two costs. Until you say which is right, neither can be trusted.
Matching duplicates that agree are combined rather than discarded, so nothing is lost that can be saved. Everything set aside is listed by its row number in your original file.
Then take it with you
Three files, built on your machine
The decision is only useful if you can act on it away from the screen — at the counter, at the supplier, in front of whoever signs off the money.
-
PDF
A one-page report
The figures, the decision, the order to work through, and what was left out. Prints on a single sheet.
-
XLSX
An eight-sheet workbook
Summary, buying decisions, products, branches, suppliers, data health and the rows set aside.
-
CSV
Your cleaned data
The safe rows only, with the decision on each one, ready to paste into your own sheet.
Who it is for
Shops that run on spreadsheets
Pharmacies, hardware shops, agrovets, electronics dealers, general retail — anyone with more stock than they can hold in their head and a file they half trust. If you have a branch column it compares branches; a supplier column and it compares suppliers. No account, no install, nothing to set up.
Early access. Tell us what breaks — spendcrumbs@gmail.com