Litbuy Spreadsheet for Resellers Explained

Why Resellers Need a Specialized Layout

Personal buyers care about one question: did I get the item? Resellers care about six: did I get it, what did I pay, what can I sell it for, where should I list it, how fast will it sell, and when should I reorder? A generic ten-column tracker cannot answer all six. A litbuy spreadsheet guide built for resellers needs at least sixteen columns and a secondary tab for sold inventory.

The extra columns are not bloat. They are the difference between knowing your true profit and guessing. Shipping, platform fees, taxes, and storage costs silently eat twenty to thirty percent of gross margin. Without dedicated fields for each, you are flying blind.

The Reseller Column Stack

1. Item Name / SKU: Identical to personal buyers, but include the platform-specific listing ID once live.
2. Purchase Price: What you actually paid including tax and shipping, not the retail tag price.
3. Platform Fees: StockX, GOAT, eBay, and Grailed all take different cuts. Track the exact percentage per item.
4. Shipping Out: Cost to ship to the buyer or authentication center.
5. Total Cost: Auto-calculated sum of purchase price, platform fees, and outbound shipping.
6. Listed Price: The price you posted on your primary platform.
7. Current Market Price: Updated from marketplace feeds or manual checks.
8. Net Profit: Listed price minus total cost. This is your real margin, not a fantasy number.
9. ROI Percentage: Net profit divided by purchase price, formatted as a percentage.
10. Days Listed: How long the item has been for sale. Critical for cash-flow planning.
11. Status: Inbound, Listed, Sold, Shipped, Authenticated, Payout Received.
12. Platform: Where the item is currently listed or sold.
13. Reorder Trigger: A formula that flags items for reorder when inventory hits zero and market price stays above your threshold.
14. Storage Location: Physical bin or warehouse slot for high-volume operations.
15. Notes: Flaws, authentication issues, or buyer communication logs.

Margin Tracking That Tells the Truth

Most beginner resellers calculate profit as listed price minus retail price. That formula lies. The truth is listed price minus total cost. Total cost includes purchase price, inbound shipping, platform fees, outbound shipping, and any authentication or storage fees. A sneaker that retails at one hundred and sells at two hundred might look like a hundred-dollar profit. After all fees, it is often closer to sixty.

Your litbuy spreadsheet must expose the real number. Use a formula that sums every cost column and subtracts from the listed price. Color-code margins below twenty percent in red. Color-code margins above fifty percent in dark green. At a glance, you know which items deserve shelf space and which deserve a fire sale.

Reorder Timing and Inventory Velocity

Professional resellers do not guess when to restock. They use velocity data from their sheet. If an item averages three days from listing to sale, you reorder when inventory drops to one unit. If an item averages thirty days, you wait until zero. The math is simple, but only if your sheet tracks days listed and status accurately.

Create a secondary tab called "Velocity Report" and use AVERAGEIF formulas to calculate sell-through speed by category, brand, or SKU pattern. Use this data to guide your purchasing budget. Fast movers get more capital. Slow movers get less or get dropped entirely.

Personal Buying vs Reselling: The Spreadsheet Difference