Personal buyers need organization. Resellers need profitability. When you are buying ten, twenty, or fifty items per month with the intent to resell, a basic wishlist sheet falls apart under the weight of cost tracking, margin calculations, and inventory management. This guide shows how to transform a standard eastmallbuy spreadsheet into a reseller command center that tracks every dollar from purchase to profit.
Start Shopping on oocbuy.comThe Reseller Column Set: Beyond Basics
Resellers need columns that personal buyers ignore. Here are the eight additional columns that turn a shopping list into a profit dashboard.
- Cost CNY and Cost USD: The exact amount you paid, including agent fees, domestic shipping, and any discount received. Separate from the public listing price.
- Target Resale Price: The price you intend to list the item for, based on market research from eBay, Grailed, or local resale platforms.
- Platform Fee Percentage: The cut taken by your resale platform. eBay is roughly 13%. Grailed is 9%. Record this per item because fees vary by category and promotions.
- Net Profit: A formula column: Target Price minus Cost USD minus Platform Fee minus Estimated Shipping to Buyer. This is your real take-home.
- Profit Margin Percentage: Net Profit divided by Cost USD, formatted as a percentage. Items below 25% margin should be reconsidered unless they serve as loss leaders.
- Resale Platform: Where you plan to list the item. Some pieces perform better on eBay, others on Grailed, others on local Facebook groups.
- Listing Status: Purchased, Photographed, Listed, Sold, Shipped to Buyer, Completed. This tracks the full resale lifecycle.
- Days to Sell: The number of days between listing and sale. Over time, this reveals which categories and platforms move fastest.
Batch Buying and Shipping Logic
Resellers rarely buy one item at a time. They buy in batches to reduce per-item agent fees and international shipping costs. Your sheet must handle batch logic gracefully.
Create a "Batch ID" column and assign a code like B-2026-05-A to every item in a single order. In a separate "Batches" tab, record the total agent fees, international shipping, and any customs charges for that batch. Then use a formula to divide those shared costs equally across items in the batch, or proportionally by weight if you have that data.
Accurate batch costing is the difference between a 30% margin and a 15% margin. Buyers who estimate shipping per item instead of tracking the real batch total consistently overestimate their profits.
Inventory Turnover Dashboard
The most important metric for any reseller is turnover: how fast items move from purchased to sold. Slow inventory ties up cash and reduces your ability to buy new drops.
Build a Dashboard tab with these KPIs: Average Days to Sell by category, Total Capital Committed, Total Profit Realized, and Margin by Seller. Update these metrics weekly. If a category averages over 45 days to sell, stop buying into it unless the margin is exceptional.
Use conditional formatting on the Days to Sell column. Green for under 14 days, yellow for 15-30, red for over 30. This creates an instant visual alert when inventory is aging.
Tax and Record Keeping
Reselling generates taxable income in most jurisdictions. Your eastmallbuy spreadsheet is your primary record for deductions, cost basis, and revenue reporting. Treat it like an accounting tool, not a shopping list.
Add these columns for tax compliance: Purchase Date, Sale Date, Payment Method, Platform Payout Amount, and Shipping Cost to Buyer. At year-end, export your sheet as CSV and hand it to your accountant. Every dollar is documented. Every deduction is supported.
If you operate under a business name, add a separate tab for Business Expenses that are not inventory: photography lights, packaging materials, measuring tools, and platform subscriptions. These are deductible too, and mixing them with inventory rows creates confusion.
| Metric | Personal Buyer | Reseller (No Sheet) | Reseller (With Sheet) |
|---|---|---|---|
| Monthly items tracked | 3-5 | 10-20 | 20-50+ |
| Time per item admin | 2 min | 8 min | 3 min |
| Profit margin accuracy | N/A | Estimated | Exact |
| Batch cost tracking | None | Rough guess | Precise split |
| Tax record quality | None | Scattered receipts | Export-ready CSV |
| Inventory turnover insight | None | Gut feeling | Data-driven |
Pro Tips
Create a 'Buy List' and a 'Sell List' in separate tabs. The Buy List tracks items you have not yet listed. The Sell List tracks items already photographed and live. Never mix them.
Photograph every item the day it arrives. Delays between receipt and listing are the single biggest killer of turnover speed.
Review your worst-performing ten items monthly. If an item has been listed for 60 days with no interest, drop the price 20% or bundle it with a faster mover.
Ready to take action?
Start your reseller inventory system with verified product sources. Browse bulk-friendly categories on oocbuy.com today.
Visit oocbuy.comFrequently Asked Questions
Do I need a separate sheet for tax purposes?
Yes. Create a dedicated 'Tax Year 2026' tab that strips out personal notes and focuses only on dates, costs, and sales. This makes accountant conversations faster and cheaper.
How do I handle returns as a reseller?
Add a 'Returns' column with the reason and date. Subtract the refund amount from your profit calculation. If a seller has a return rate above 15%, stop buying from them regardless of price.
Should I track competitor prices?
Yes, but in a separate competitor research sheet, not your main inventory tracker. Competing prices change daily and would clutter your permanent records.
What is the minimum margin for a viable resale item?
After all fees and shipping, 25% is the floor. Below that, one return or price drop wipes out your profit. Target 40% for safety.
Can I use the same sheet for personal and resale buying?
We strongly recommend against it. Mixing purposes creates tax confusion and makes it hard to see whether your reseller operation is actually profitable. Separate sheets, separate clarity.
Conclusion
Building and using an eastmallbuy spreadsheet is one of the smartest investments any buyer can make. Whether you are a casual shopper or a full-time reseller, the clarity, savings, and peace of mind that come from organized tracking are impossible to replicate with memory or bookmarks alone.
For more strategies, explore our complete eastmallbuy spreadsheet guide or jump straight to the source and browse verified sellers on the main platform.