Reseller Profit Tracker Spreadsheet, eBay Poshmark Mercari Inventory and Sales, Reseller Inventory Spreadsheet, Excel Google Sheets

Description du créateur

Reseller Profit Tracker Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Know the real profit on every item you flip, after platform fees, shipping and what you paid for it. Perfect for eBay, Poshmark, Mercari, Depop and Facebook Marketplace resellers.

🎥 WATCH THE FULL WALKTHROUGH VIDEO before you buy, every tab explained: https://youtu.be/ot7qpjJ18I8

✨ NOW INCLUDES 4 FILES: a SAMPLE version (filled in so you can see exactly how it works) and a BLANK version (cleared and ready for your own info), each in an Excel edition and a Google Sheets edition.

★ WHAT'S INCLUDED ★
• Clickable Start Here cover page with quick-start steps and a colour key (yellow = you type)
• Reseller Dashboard: net profit, revenue, gross profit, items sold, average ROI, profit per sale, days to sell, net margin, items on hand, cost of unsold stock, profit waiting on the shelf, aged items, sell-through rate, miles, running costs and best platform, plus goal progress bars, 7 automatic insights and alerts, month-by-month and per-platform tables and 4 charts
• Setup: an editable fee table for 10 platforms (eBay, Poshmark, Mercari, Depop, Facebook Marketplace, Etsy, Whatnot, Grailed, Local / Cash, Other) with selling %, processing % and fixed fee, your report year, aged-item days, mileage rate, ROI target, 8 yearly goals and your sourcing spot, category, expense type and condition lists
• Inventory: room for 750 items with SKU, brand, category, condition, sourcing spot, trip #, cost, list price, bin and a tick column for each of your first 6 platforms. Status, sold date, days held, Fresh / Watch / AGED / STALE flag, profit, ROI and estimated profit at list price are automatic
• Sales: 750 rows. Pick the SKU and platform, type the sale price, shipping charged, label cost, ad fee and supplies. Platform fees, item cost, net profit, ROI, margin and days to sell are worked out for you, with a fee override for odd fees
• Sourcing Trips: 200 trips with store, source type, miles, entry fees and hours. Items bought, spend, mileage cost, items sold, profit so far, ROI, $ per hour and a Great / Good / Waiting / Weak rating fill in from Inventory
• Expenses & Mileage: 400 rows for supplies, packaging, storage, apps, equipment and other drives, with a this-year breakdown by type
• Aged Inventory: your 40 oldest unsold items with a suggested markdown price and next step, plus unsold stock by age (items, cost, list value, est. profit) and a chart
• Platforms: sales, revenue, fees, fees as % of revenue, ad fees, labels, net profit, ROI, margin, average sale, profit per sale, days to sell, share of profit and items listed now for every platform, a platform x month profit grid and 2 charts
• Fee Calculator: type an item's cost, price and shipping to see fees, net profit, ROI, break-even price and the price you need for your target ROI on every platform, with the best platform highlighted and a chart
• Monthly P&L: sales, shipping charged, cost of items, platform fees, ad fees, labels, supplies, gross profit, 10 running-cost lines, sourcing trip fees and mileage, net profit and margin for every month, plus items bought, stock spending and a running cash total, with a chart
• Goals: 8 yearly goals (profit, revenue, items sold, ROI, sell-through, days to sell, items sourced, aged items) with progress, pace and year-end projection, plus monthly profit and sales goals with your own overrides and a chart
• Insights: profit, sell-through and ROI by category and by sourcing spot, top 10 flips by profit and by ROI, results by sale price and by day of the week, with 2 charts
• Item Lookup: pick any SKU to see where it came from, where it's listed, how it sold and what it would net on each platform at its list price
• Sample data version so you can see how it works, plus a blank ready-to-use version

★ PERFECT FOR ★
✓ eBay, Poshmark, Mercari, Depop and Facebook Marketplace resellers
✓ Thrift, garage sale and estate sale flippers
✓ Anyone who cross-lists on several platforms

★ COMPATIBILITY ★
• Microsoft Excel (desktop, Mac, web)
• Google Sheets (upload to Google Drive and open with Google Sheets)
• 2 files included: an Excel version + a Google Sheets edition
• Not designed for Apple Numbers

★ HOW IT WORKS ★
1. Check the fee table on Setup and edit it to match each platform's current fees.
2. Add every item you buy on Inventory.
3. Log each sale on Sales: fees, profit and ROI fill in automatically.
4. Check Aged Inventory and the Dashboard to see what sells and where.

Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol.

★ PLEASE NOTE ★
• This is a digital download. Nothing will be shipped.
• Platform fees change often. The fee table uses example rates you can edit; always check each platform's current fees.
• This is a record-keeping tool, not tax or financial advice.
• Platform names are used only to describe what the tracker works with. Not affiliated with any of them.
• Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.