Should I track sales tax?

Yes, if you are required to collect it. Add a 'Tax' column in your Sales tab. Record the tax rate and amount for each sale.

What is a healthy profit margin?

For fashion reselling, 30% to 50% is healthy. Below 20% is risky. Above 50% is excellent but may indicate underpricing or overpricing.

Superbuy Spreadsheet for Resellers: Inventory and Profit Tracking

Q: How do I track profit across multiple platforms?

Add a 'Platform Sold' column in your Sales tab. Filter by platform to see which channel is most profitable.

June 202610 min readSuperbuy Spreadsheet Team

Superbuy Spreadsheet for Resellers: Inventory and Profit Tracking

Track inventory, calculate profit margins, and manage reorder schedules like a professional.

Why Resellers Need a Different Spreadsheet

A buyer's spreadsheet tracks what they bought. A reseller's spreadsheet tracks what they bought, what they sold, what they earned, and what they need to reorder. The difference is the profit layer. Without it, you are running a business blind.

The Reseller's Spreadsheet Structure

Inventory Tab

All items you have in stock. Columns: Item, Link, Supplier, Cost, Quantity, Platform, QC Status.

Sales Tab

Every item you have sold. Columns: Item, Sale Date, Selling Price, Platform Sold, Buyer, Profit.

Profit Tab

A summary of profit per item, per month, and per supplier. Use formulas to calculate automatically.

Reorder Tab

Items that need restocking. Columns: Item, Current Stock, Reorder Level, Last Ordered, Supplier Link.

Supplier Tab

Your supplier database. Columns: Name, Link, Quality Score, Speed Score, Notes.

Key Formulas for Resellers

Profit per Item

=Selling Price - (Cost + Shipping + Fees)

Profit Margin

=Profit / Selling Price. Aim for 30% or higher.

Monthly Revenue

=SUM(Sales!B2:B100). Track revenue trends.

Stock Alert

=IF(Inventory!D2 < 5, 'REORDER', 'OK'). Never run out of stock.

Reseller Mistakes to Avoid

The biggest mistake resellers make is not tracking fees. Agent fees, payment fees, shipping fees, and platform fees eat into profit. Record every fee. The second biggest mistake is not tracking slow-moving inventory. If an item sits for 60 days without selling, it is dead stock. Mark it and discount it.