Itaobuy Spreadsheet for Resellers

A reseller's itaobuy spreadsheet extends far beyond basic order tracking. The essential columns are: Item Name, Category, Size, Purchase Price, Estimated Resale Price, Platform (StockX/GOAT/eBay/Grailed), Listing Date, Listed Price, Sold Price, Shipping Cost, Platform Fees, Net Profit, Profit Margin %, Days to Sell, Status (Purchased / Listed / Sold / Returned), and Notes. This 16-column structure captures every financial variable that determines whether a flip makes money or loses it.

The most important column is Net Profit, calculated with the formula: =Sold Price - Purchase Price - Shipping Cost - Platform Fees. Every row must show a real number. If you are not tracking fees accurately, you are flying blind. Platform fees vary: StockX takes 9-12% depending on your seller level, GOAT takes 9.5% plus $5, eBay takes 13-15% depending on category. Create a lookup table in a separate tab and use =VLOOKUP() to auto-populate fees based on the Platform column. For basic tracking setup, see our beginner guide.

Smart resellers do not just track profits. They analyze them. Add a Profit Margin % column with the formula: =Net Profit / Purchase Price. This tells you the return on investment for every flip. A $50 profit on a $200 purchase is 25% margin. A $50 profit on a $500 purchase is 10% margin. The absolute dollar amount is identical, but the capital efficiency is drastically different. Low-margin flips tie up more money for the same return, limiting how many deals you can pursue simultaneously.

Use conditional formatting on the Profit Margin % column: green above 30%, yellow 15-30%, red below 15%. At a glance, you will see which purchases were smart capital allocation and which were mistakes. Over time, this visual feedback trains your buying instincts. You start recognizing which categories, sizes, and colorways consistently deliver the margins you need. For advanced analysis techniques, explore our advanced tips guide.

Profit margin means nothing if your inventory sits unsold for six months. Capital tied up in slow inventory cannot fund new purchases. Add a Days to Sell column with the formula: =Sold Date - Listing Date. For unsold items, use a placeholder or calculate =TODAY() - Listing Date to show current aging. Sort by this column regularly to identify stale inventory that needs price cuts or platform switches.

Create a separate "Aging Report" tab that categorizes inventory by age brackets: 0-14 days (fresh), 15-30 days (normal), 31-60 days (concerning), 61+ days (stale). Use COUNTIF and SUMIF formulas to show how much capital is trapped in each bracket. If more than 30% of your inventory value sits in the 61+ day bracket, you have a pricing or sourcing problem. This quantitative reality check prevents emotional attachment to items that should have been discounted weeks ago. For bulk inventory management, see our bulk buyers guide.

Professional resellers buy repeatedly from the same sources. A seller scorecard tab in your itaobuy spreadsheet tracks this relationship intelligence. Columns include: Seller Name, Total Orders, Total Spend, Average Purchase Price, QC Pass Rate, Average Ship Time, Return Rate, and Overall Rating. This data tells you which sellers deliver profitable, fast, high-quality inventory and which sellers waste your time with delays and defects.

Use QUERY() functions to auto-populate the scorecard from your main order tab. When a seller's Return Rate climbs above 10% or their Average Ship Time exceeds 14 days, their Overall Rating drops automatically. Set conditional formatting to highlight sellers in red when their rating falls below 3.0. This objective scoring prevents you from giving second chances to sellers who have already proven unreliable. Your capital is too precious to risk on inconsistent sources.

Resellers who wait until April to organize their finances face a nightmare. A properly maintained itaobuy spreadsheet makes tax preparation a 30-minute task instead of a week-long ordeal. Every purchase, sale, fee, and shipping cost is already recorded. Create a "Tax Summary" tab that sums total revenue, total cost of goods sold, total fees, total shipping, and net profit by quarter. Export this tab as a CSV and hand it to your accountant.

In most jurisdictions, you need records of every transaction, not just totals. Your spreadsheet provides this by default. Every row is a receipt. Every formula is an audit trail. If tax authorities question a deduction, you open your sheet, find the row, and present the complete transaction history. This level of documentation protection is worth more than any single flip. For data safety practices, review our safety guide.