Reseller Inventory Spreadsheet, Reseller Profit Tracker for Clothing Resellers and Thrift Flips, Google Sheets & Excel + Offline App

Seller's description

Track every item you resell, from the thrift store to the sale, and see your real profit after platform fees, shipping and packaging. You get an offline inventory and profit tracker app and a Google Sheets & Excel spreadsheet with the same calculations.

Made for clothing and secondhand resellers who source at thrift stores, charity shops, car boot and yard sales, estate sales and wholesale bundles, and sell online or at markets.

WHAT'S INCLUDED
• Reseller-Inventory-and-Profit-Tracker.html: the tracker. It opens in your web browser and works offline. No account, no subscription, no internet connection needed.
• Reseller-Inventory-and-Profit-Tracker.xlsx: the spreadsheet version for Google Sheets and Microsoft Excel, with live formulas and no macros.
• START-HERE guide (PDF): the first 10 minutes, how fees and profit are worked out, and how to import the spreadsheet into Google Sheets.
• Examples: a printed year report and stock list (PDF) and an exported inventory list (CSV).
• A licence to use it in your own resale business.

HOW IT WORKS
• Sourcing log: item, brand, category, size, condition, source, purchase date, cost, storage location or bin, and whether photos are taken.
• Bundles: bought a lot for one price? The cost is split over its items equally or by estimated value, and always adds up to the total to the cent. Change the total later and every item's cost updates.
• Bulk add a whole haul in one go, or paste rows copied from a spreadsheet.
• Listing: tick the platforms an item is listed on and enter the list price. See unlisted, listed and sold at a glance, with a "needs photos" filter.
• Sales: sold price, shipping charged to the buyer, label cost, packaging and promotion fees. Fees, net profit, margin, ROI and days to sell are worked out for you.
• Fee rules per platform that you set: selling fee %, fixed fee per order, payment processing, small-sale flat fees, whether the % also applies to shipping, and 0% for platforms where the buyer pays the fees. It starts with example fee settings you can change.
• Dashboard: stock value at cost, listed value, sell-through, month-by-month sales and profit, sales by platform, best brands, categories and sources, and slow movers (unsold for longer than the number of days you choose).
• Tax-year totals: revenue, cost of goods sold, fees, shipping labels, packaging and optional mileage, with your own tax-year start (for example January 1 or April 6). A summary for your records, not tax advice.
• Printable year report and stock list sorted by bin, on A4 or US Letter.
• Search and filter by status, category, source and platform. CSV export and import, plus backup and restore in one file.
• Your currency symbol, number format and date format (dates show the way you choose, whatever language your computer uses), miles or km.

WORKS WITH THE PLATFORMS YOU SELL ON
You enter each platform's fees yourself, so it works for any marketplace and for in-person sales, for example eBay, Poshmark, Depop, Vinted, Mercari, Facebook Marketplace and market stalls. This tracker is not affiliated with, endorsed by or connected to any of these platforms, and it does not import your listings or orders automatically.

Pairs with the reseller measurement card from this shop (garment measurements for tops and pants), sold separately.

REQUIREMENTS
• The tracker: a computer with Chrome, Edge, Firefox or Safari, or an Android phone or tablet with Chrome.
• iPhone and iPad: Apple's Files app shows HTML files as a static preview and cannot run the tracker, so use the spreadsheet in the Google Sheets app on those devices.
• The spreadsheet: Microsoft Excel, or a free Google account for Google Sheets.
• A way to unzip the download (built into Windows and macOS).

WHAT IT DOES NOT DO
• It does not connect to selling platforms: you enter your sales yourself or import them from a CSV file.
• It does not sync between devices, or between the browser tracker and the spreadsheet. Use the backup file or CSV to move your data.
• It is not accounting or tax software and does not know your local tax rules.
• It does not record garment measurements (that is what the measurement card is for).
• One row is one item. For several identical items, add one row each (Bulk add and Duplicate make this quick).

LICENCE
Use the tracker and the spreadsheet in your own resale business, on all your own devices. Reselling, sharing or redistributing the files is not allowed.

FAQ
Is there a monthly fee? No. You pay once and keep the files.
Does it work without internet? Yes. The tracker is a single file that runs in your browser. It makes no network connections.
Where is my data stored? Only in your browser on your device. Nothing is uploaded. Export a backup now and then to keep a copy.
Are the platform fees up to date? The tracker starts with example fee settings so you can see how it works. Platforms change their fees and they differ by country, so check the current fees for the platforms you use and enter them in Settings. It takes a few minutes.
Can I bring my existing list? Yes. Save it as a CSV file with an "Item" column (the guide lists the other column names it reads) and import it.
Does it work outside the US? Yes. Currency, number format, date format, miles or km and the start of your tax year are all settings.
Can I use it on more than one device? Yes, on all your own devices. Move your data with the backup file.
Is this a physical product? No. It is an instant digital download. Nothing is shipped.

SUPPORT
Send a message through Etsy or email karelialabs [!at] outlook.com.

Made by Karelia Labs with AI-assisted development; every calculation was checked and tested by hand before release.