Reseller Inventory and Sourcing Log UK

Reseller Inventory and Sourcing Log UK is an Excel and Google Sheets workbook for people who sell second-hand clothes and other stock on Vinted, eBay and Depop.

You log each sourcing trip (date, place, spend, miles, items bought), each item (brand, category, size, condition, cost, bin, date in, photos done, listed or not, listing price, platform, status) and each sale (date, price, one fees total). The workbook does the sums:

• A SKU for every item, filled in automatically
• Days in stock with colour flags at 30, 60 and 90 days
• Cost per item and profit per £ spent for every trip
• Profit, margin and days to sell for every sale
• A dashboard with items in stock and their value, listed against not listed, stale stock, your best categories and brands by profit and speed, and your best sourcing spots

Mileage uses HMRC's 55p and 25p simplified rates for the first 10,000 miles and after. It only applies if you are trading, so it is off in the trip results until you switch it on.

Room for 500 items, 500 sales and 150 trips. You get two files: one filled with about 60 example clothing items, and one blank. Yellow cells are for typing; everything else is locked with no password. No macros.

It is a stock and sourcing log, not a tax record. It does not connect to the selling sites.

Questions: help@highstreetstack.com