PRACTICAL GUIDE · RESELLING
Sale price is not profit, and unsold stock is not revenue.
A reseller needs one row per item and a status that controls when sale calculations apply. Item-level records reveal which marketplaces, categories and buying decisions actually produce margin after direct costs.
Core takeaway
Assign a SKU at purchase, keep stock and sold logic separate, record every direct cost and review aging alongside profit.
1. Give every item a stable SKU
Create the SKU when the item enters inventory. Record purchase date, source, category, description, cost and intended marketplace. Do not use a listing title as the only identifier because titles change.
2. Separate inventory cost from sale results
Active stock should contribute to inventory value, not sold revenue. Only calculate net revenue, profit and margin after the status is sold and the sale fields are complete.
- Purchase cost
- Preparation or repair
- Sale price
- Marketplace and payment fees
- Shipping paid by seller
- Net revenue and profit
3. Calculate item-level profit consistently
Net revenue equals sale proceeds after selling fees and seller-paid shipping. Profit then subtracts the full item cost. Use the same formula across marketplaces so channel comparisons are meaningful.
4. Review aging and sell-through with margin
High margin on a few old items may still tie up cash. Track days held, active stock cost and sell-through beside profit. Use aging flags to decide whether to relist, discount, bundle or stop buying a category.
Educational organization and planning content only. It does not replace tax, legal, accounting, financial or technical advice where applicable.
WORKFLOW CHECKLIST
The complete routine in six steps.
- 01Assign a SKU at purchase
- 02Record every acquisition cost
- 03Keep active and sold statuses explicit
- 04Enter fees and shipping after sale
- 05Review profit by item and marketplace
- 06Flag aging inventory
APPLY THE METHOD
Use a workbook that already connects the steps.
The template turns this method into editable inputs, checks and summaries with realistic example rows.
Reseller Inventory and Profit Tracker
FREQUENTLY ASKED QUESTIONS
Before you begin.
When should fees be calculated?
Apply sale fees when an item is marked sold and the required sale data is present. Marketplace rules can change, so verify current fee schedules.
Should unsold stock count as an expense?
Inventory and tax treatment depend on the applicable accounting rules. The operational tracker should at least keep unsold cost separate from sold-item profit.
What is sell-through?
It compares items sold with the relevant stock pool over a defined period. State the period and method consistently when comparing results.