Yoybuy Spreadsheet for Resellers (2026 Profit Guide)

Reselling cross-border products is a profitable business when you track numbers properly. A purpose-built yoybuy spreadsheet for resellers goes far beyond basic order tracking. It becomes your profit calculator, inventory manager, tax assistant, and business intelligence dashboard. This guide shows exactly how to build and use a reseller-grade spreadsheet that scales from your first flip to your hundredth.

Why Resellers Need a Different Spreadsheet

Casual shoppers track spending. Resellers track investment, return, and velocity. A standard order tracker misses the metrics that determine whether your business lives or dies:

• Cost Per Unit: Product price plus agent fees, shipping, and import duties divided by units purchased.
• Time to Sell: Days between acquisition and sale. Slow inventory kills cash flow.
• Platform Fees: eBay takes 13%. Grailed takes 9%. Depop takes 10%. Your spreadsheet must subtract these before showing profit.
• Net Margin: The only number that matters. Selling price minus all costs minus platform fees.
• Return Rate: Percentage of sold items that come back. High return items get flagged and dropped.

The Reseller Spreadsheet Structure

Resellers need at least four interconnected sheets:

1. Acquisition Tracker: Every item you buy, with full cost breakdown including product, shipping, agent fees, and customs.
2. Inventory Sheet: Items you own but have not sold yet. Includes days in inventory, current listing price, and platform.
3. Sales Log: Every completed sale with selling price, platform, fees, net profit, and buyer location.
4. Dashboard: Auto-calculated summaries showing monthly profit, top categories, fastest sellers, and return rates.

Acquisition Tracker: The Foundation

This sheet answers one question: "What did this item actually cost me?" Columns include:

• Item ID: Unique identifier linking to Inventory and Sales sheets.
• Product Name and URL: For reference and dispute evidence.
• Category: Shoes, Hoodies, Accessories, etc.
• Size / Color: Critical for inventory accuracy.
• Quantity: How many units purchased.
• Unit Product Cost: Price per item in original currency.
• Total Product Cost: Unit cost times quantity.
• Shipping to Warehouse: Domestic shipping from seller to agent.
• International Shipping: Cost from agent to you.
• Agent Fees: Service charges per item or per order.
• Customs / Duties: Import taxes paid.
• Total Landed Cost: Sum of all costs.
• Cost Per Unit: Total landed cost divided by quantity.
• Acquisition Date: When the order was placed.
• Warehouse Arrival: When items reached the consolidation center.
• Delivery Date: When items arrived at your door.
• Status: Ordered, In Transit, Received, Listed.

Inventory Sheet: Managing Unsold Stock

Items that have arrived but not sold live here. This sheet prevents two expensive mistakes: forgetting what you own and missing stale inventory. Key columns:

• Item ID: Links back to Acquisition Tracker.
• Product Name: For quick scanning.
• Category: Enables filtering by type.
• Size / Color: Prevents listing the wrong variant.
• Cost Per Unit: From Acquisition Tracker.
• List Price: Current asking price on the marketplace.
• Platform: eBay, Grailed, Depop, Instagram, etc.
• Listing Date: When you first posted it for sale.
• Days Listed: Formula: =TODAY()-H2. Flags stale items.
• Status: Listed, Reserved, Sold, Returned, Donated.
• Notes: Condition details, flaws, or special selling points.

Conditional formatting highlights items listed for over 30 days in yellow and over 60 days in red. This forces you to drop prices or switch platforms before inventory dies.

Sales Log: The Truth About Profit

This sheet records every completed transaction and calculates true profit after all hidden costs:

• Item ID: Links to acquisition and inventory.
• Sale Date: When payment cleared.
• Platform: Where the sale happened.
• Sold Price: What the buyer paid.
• Platform Fee: Percentage or flat fee charged.
• Payment Fee: PayPal, Stripe, or bank fees.
• Shipping to Buyer: Cost of sending the item to your customer.
• Packaging Cost: Boxes, tape, labels.
• Cost Per Unit: Pulled from Acquisition Tracker.
• Total Cost: Sum of cost, fees, shipping, and packaging.
• Net Profit: Sold price minus total cost. This is the only number that matters.
• Profit Margin: Net profit divided by cost per unit, formatted as a percentage.
• Days to Sell: Sale date minus acquisition date.
• Buyer Location: For tax and market analysis.

Dashboard: Your Business at a Glance

The Dashboard sheet pulls data from the other three sheets using formulas. Essential metrics:

• Monthly Revenue: =SUMIF(Sales!B:B,">="&DATE(2026,5,1),Sales!D:D)
• Monthly Net Profit: Same SUMIF on the Net Profit column.
• Current Inventory Value: =SUM(Inventory!E:E) (sum of cost per unit).
• Inventory Count: =COUNTA(Inventory!B:B)-1
• Average Days to Sell: =AVERAGE(Sales!N:N)
• Top Category by Profit: A pivot table or QUERY function summarizing profit by category.
• Worst Performing Items: Items with profit margin under 20% or days to sell over 60.
• Return Rate: =COUNTIF(Sales!M:M,"Returned")/COUNTA(Sales!B:B)

Reseller Spreadsheet vs Basic Tracker

Tax and Record-Keeping Tips

Resellers face tax obligations. Your yoybuy spreadsheet becomes your primary record:

• Export a CSV backup monthly and save it with the filename format: Yoybuy_YYYYMM.csv.
• Keep receipts and agent invoices in a folder named to match your spreadsheet rows.
• Record the date you paid import duties. Some jurisdictions allow duty deductions.
• Track business expenses separately: packaging, shipping supplies, phone bills used for business.
• Consult an accountant about deducting agent fees and international shipping costs.

A yoybuy spreadsheet built for reselling is the difference between a hobby and a business. It tells you which items make money, which categories move fast, and where your cash is tied up. If you are new to reselling, start with our beginner guide, then layer on the reseller-specific columns from this article. For automation that handles large volumes, explore automation techniques.