When a reseller spreadsheet stops coping
Reselling spreadsheets get mocked more than they deserve. A good one - several sheets, a long inventory tab, search that works - will carry you further than most tool vendors would like you to believe. The interesting question is not whether it works. It is which part gives out first.
In our experience it is almost never the arithmetic. It is two things that arrive together: statistics for one specific item, and keeping the receipts somewhere useful.
The first wall: per-item questions
A spreadsheet is very good at totals. Revenue this month, spend this quarter, a sum at the bottom of a column - all easy, all reliable.
It is bad at questions shaped like this:
- What did I make on this pair of jeans, after the fee and the postage?
- How long did that console sit before it sold?
- Of the twelve games from that lot, which four are still here?
- Do electronics actually beat clothing for me, or does it just feel that way?
Each is answerable. Each needs a lookup, a filter, or a pivot table, and each takes long enough that you stop asking. That is the real failure: not a wrong number, but a question you quietly give up on. Sourcing decisions get worse without anyone noticing, because the feedback loop went quiet.
The second wall: receipts
Everything else about a flip is text and numbers, which is exactly what a spreadsheet holds. A receipt is a photograph. So it ends up somewhere else - the camera roll, a folder, an email - and the link between the purchase row and the picture of what you paid lives only in your memory.
It works until you need it: a return, a dispute, or a tax return where you have to prove the cost of something you bought fourteen months ago.
The third: a haul is not a row
You pay 1,000 for a box of forty things. That is one purchase and forty items, and a spreadsheet makes you choose which one to model.
Model it as a purchase and you cannot track the items. Model it as forty items and the purchase price has to be split by hand, and re-split every time you realise the console was worth more than the cables. Most people end up with two sheets and a manual link between them, which holds right up until it does not.
A related trap: five identical items need five rows, or "mark one sold" has nowhere to go. Copy-paste gets you six by accident, and now your inventory count is wrong in a way no formula will catch.
What you should not do about it
Do not go looking for a bigger spreadsheet. The next template will have more tabs, more named ranges and more places to make an error you cannot see. Complexity in a spreadsheet is not free - it is paid for in the moments when you are tired, on a phone, and about to skip the entry entirely.
And do not switch on the strength of feeling behind. Switch when you can name the question you stopped asking. That is the real signal, and it is a much better reason than "everyone says spreadsheets do not scale".
What a tool has to earn
Anything replacing the sheet has to be faster to enter than the sheet was, on a phone, standing up, in bad light. Most reselling software is built for the listing side - writing descriptions, pushing to several marketplaces - and asks for a great deal of typing before it gives anything back. If it is slower to record a purchase than a row in a spreadsheet, it will not get used, and the numbers it produces will be wrong because they will be incomplete.
Flippo is the spreadsheet, kept for you
One row per physical item, hauls that stay attached to the purchase they came from, receipts on the record they belong to, and per-item profit worked out without a single formula.