Nothing is wrong with a spreadsheet until the business has four moving parts at once. These are the four that break it, in the order they usually break:
One order, twelve compounds, one shipping figure. Splitting it evenly is wrong (a $9 vial and a $27 vial do not carry the same overhead fairly), and splitting it by value needs a formula that has to be rewritten every order. Most sheets end up not splitting it at all, and every margin is overstated.
A single cost cell per product means the newest price silently rewrites the value of stock you bought months ago — including stock you have already sold.
A reseller's holdings need to be in your stock total and out of your physical count at the same time, and their balance moves every time they sell something you have not approved yet.
The failure that costs the most is the quiet one: a number typed into the wrong row. A sheet will carry it forever. This is the whole argument for a tool — not that it is faster, but that it refuses to add up wrongly.
Import the workbook you already keep. Inventory creates the products, pricing fills the tiers, purchase lots become batches with vendors and landed cost, reseller quantities become allocations, and sales and expenses arrive as history. You see what each sheet will do before anything saves, and the same file cannot be imported twice by accident.
In the app
Every figure on this page is something PepStock keeps without being asked — landed cost per batch, each purchase's own cost, what every reseller is holding, and the per-mg ranking at one kit and at ten.
