Real Yoybuy Spreadsheet Examples That Work (2026)

Theory is helpful, but nothing beats seeing a real yoybuy spreadsheet in action. This article presents five fully detailed examples from actual cross-border shoppers. Each example includes the exact column structure, sample data rows, and formulas that make it work. Copy what fits your needs, adapt what does not, and start tracking smarter today.

Example 1: The Casual Buyer Tracker

User Profile: Sarah buys 5-8 items per month for personal use. She wants to know what she spent and when packages arrive. No reselling, no complex formulas.

Sheet Structure: One sheet named "Orders" with 10 columns:

• A: Item ID (1, 2, 3...)
• B: Product Name (e.g., "Nike Dunk Low Panda")
• C: Product URL
• D: Category (Shoes, Hoodies, Accessories)
• E: Size / Color
• F: Original Price (CNY)
• G: Converted Price (USD) — formula: =F2*0.14 (manual rate in a hidden cell)
• H: Shipping Cost
• I: Total Cost — formula: =G2+H2
• J: Status (Wishlist, Ordered, Shipped, Received)
• K: Tracking Number
• L: Notes

Why It Works: Simplicity breeds consistency. Sarah updates the sheet in under 30 seconds per item. The manual rate means no internet dependency. No formulas break. No confusion.

Example 2: The Budget-Conscious Family Tracker

User Profile: The Chen family places group orders for 4 people. They need a monthly budget cap and spending visibility by family member.

Sheet Structure: Two sheets. "Orders" has columns A-N plus "Family Member." "Budget" has:

• Month
• Budget Limit (e.g., $500)
• Total Spent — formula: =SUMIF(Orders!M:M,A2,Orders!I:I)
• Remaining — formula: =B2-C2
• Items Purchased — formula: =COUNTIF(Orders!M:M,A2)

Why It Works: The family sees exactly how much budget remains before placing the next order. The SUMIF formula auto-totals by month. No manual budget math means fewer arguments about overspending.

Example 3: The Reseller Profit Machine

User Profile: Mike runs a small reselling business. He buys 20-40 items monthly and sells on eBay, Grailed, and Depop. Profit is the only metric that matters.

Sheet Structure: Four sheets: "Acquisition," "Inventory," "Sales," and "Dashboard."

Acquisition Columns (A-Q): Item ID, Name, URL, Category, Size, Qty, Unit Cost, Total Product Cost, Shipping, Agent Fee, Customs, Total Landed Cost, Cost Per Unit, Acquisition Date, Warehouse Date, Delivery Date, Status.

Inventory Columns (A-L): Item ID, Name, Category, Size, Cost Per Unit, List Price, Platform, Listing Date, Days Listed (formula: =TODAY()-H2), Status, Notes.

Sales Columns (A-O): Item ID, Sale Date, Platform, Sold Price, Platform Fee, Payment Fee, Shipping to Buyer, Packaging, Cost Per Unit, Total Cost, Net Profit (formula: =D2-I2-J2-K2-L2), Profit Margin (formula: =M2/L2), Days to Sell, Buyer Location.

Dashboard Summary: Monthly Revenue, Monthly Net Profit, Inventory Value, Average Days to Sell, Top Category by Profit, Return Rate.

Why It Works: Every number feeds into profit calculation. Mike knows which categories make money, which platforms have the best margins, and how long inventory sits before selling. Data drives every buying decision.

Example 4: The Bulk Group Order Coordinator

User Profile: Alex coordinates group buys for 10-15 friends. Everyone pays Alex, who places one large order and distributes items locally. Tracking who ordered what is critical.

Sheet Structure: One "Group Orders" sheet with columns:

• A: Batch ID (e.g., "Batch_2026_05")
• B: Group Member Name
• C: Product Name
• D: Product URL
• E: Size / Color
• F: Quantity
• G: Original Price Per Unit
• H: Member Total — formula: =F2*G2
• I: Shipping Share — formula: =TotalShipping/FriendsCount
• J: Agent Fee Share
• K: Member Grand Total — formula: =H2+I2+J2
• L: Payment Status (Pending, Paid, Delivered)
• M: Status (Ordered, Warehouse, Shipped, Received)
• N: Notes

Why It Works: Alex sends each friend a filtered view of their rows. Payment disputes disappear because every cost is transparently split. The formula calculates each member's fair share of shipping and fees automatically.

Example 5: The Data-Driven Trend Analyst

User Profile: Jordan buys limited drops and tracks resale value over time. Understanding which items appreciate is the entire business model.

Sheet Structure: "Drops" sheet with columns:

• A: Drop Date
• B: Item Name
• C: Brand
• D: Category
• E: Retail Price (CNY)
• F: Converted Retail
• G: Shipping + Fees
• H: Total Cost
• I: Resale Price (Week 1)
• J: Resale Price (Month 1)
• K: Resale Price (Month 6)
• L: Profit (Week 1) — formula: =I2-H2
• M: Profit (Month 6) — formula: =K2-H2
• N: ROI % — formula: =M2/H2
• O: Size Run (which sizes were available)
• P: Cop or Drop? — formula checks if Month 6 profit exceeds $50

Why It Works: After one year, Jordan has a dataset showing which brands, categories, and sizes appreciate most. Future drops are evaluated against historical ROI, not hype. The "Cop or Drop?" column automates buy decisions using historical thresholds.

Example Comparison: Which Fits You?

How to Adapt Any Example to Your Needs

Follow this 3-step adaptation process:

1. Copy the Structure: Create a new sheet and type the column headers from the example closest to your use case.
2. Add Your Data: Enter 3-5 real orders to test whether the columns capture everything you need. Add or remove columns based on what feels missing or redundant.
3. Fix Formulas: Adjust cell references to match your actual column layout. Test each formula with sample data before trusting it with real money.

These real yoybuy spreadsheet examples prove that no matter how you shop, there is a structure that fits. Start with the closest example, adapt it over a week, and you will have a personalized system that outperforms any generic template. If you need help building from scratch, check out our DIY build guide or grab free templates as a starting point.