From spreadsheet to scannable ledger without losing your data

You do not have to abandon your spreadsheet to start scanning. The spreadsheet is usually the best record of what you sell, it is just a bad record of what happened today.

Step one: clean the columns. You need a product name, a SKU, a price, and a count. Anything else is optional. Delete the merged cells and the colour coding, they will not survive the trip.

Step two: map stickers to rows. Scan a sticker, paste in the SKU and name from the corresponding row, set the count. Twenty products takes about fifteen minutes.

Step three: change one habit. From now on, sales get logged by scanning rather than by editing a cell. This is the only behavioural change the system requires, and it is the one that makes the data trustworthy.

Step four: export back out. At the end of each week, export the ledger to Excel. You now have the same spreadsheet you always had, except it was filled in by the act of selling rather than by somebody remembering to type.

If you share the shop with staff or a partner, do the export together for the first month. Reconciling once or twice builds more confidence in the numbers than any amount of explaining.