Eastmallbuy Spreadsheet for Resellers: Complete Setup
Resellers face unique challenges that casual buyers never encounter. Profit margins fluctuate by product. Shipping costs vary by destination. Customer returns eat into revenue. An eastmallbuy spreadsheet built for resellers tracks all these variables in one place, giving you the data you need to make profitable decisions. This complete setup guide walks you through building a reseller-focused spreadsheet from scratch.
Want to browse products while reading this guide? Visit our main store for the latest deals.
Visit Our Main WebsiteReseller-Specific Columns You Must Include
Standard order tracking columns are not enough for resellers. You need financial columns that reveal whether each sale actually made money after all costs are considered.
Add a Cost Per Unit column showing your supplier price. Add a Selling Price column showing what the customer paid. Add a Platform Fee column for marketplace commissions like those charged by third-party platforms. Add a Shipping Cost column for postage to the customer.
Create a Net Profit column with a formula: Selling Price minus Cost Per Unit minus Platform Fee minus Shipping Cost. This is your true profit per order. Many resellers mistakenly think revenue minus supplier cost is profit, forgetting fees and shipping that often consume half the margin.
Add a Profit Margin Percentage column dividing Net Profit by Selling Price. Format it as a percentage. When this number drops below your minimum threshold, conditional formatting highlights the row in red. This instant visual alert prevents unprofitable repeat orders.
Tracking Inventory vs Orders
Resellers need to distinguish between items ordered from suppliers and items sold to customers. These numbers rarely match because you hold stock between purchase and sale. A proper eastmallbuy spreadsheet for resellers tracks both.
Create an Inventory tab separate from your Orders tab. The Inventory tab lists every SKU you currently hold with columns for SKU, Product Name, Size, Color, Units In Stock, Units Reserved, and Units Available.
When you place a supplier order, add the incoming quantity to Units In Stock with a status of On Order. When the shipment arrives, change status to In Stock. When a customer buys, subtract from Units Available and add to Units Reserved until you ship.
Use conditional formatting on the Units Available column. When it hits zero, the cell turns red. When it drops below your reorder threshold, it turns yellow. This inventory-aware system prevents overselling and stockouts that damage customer trust.
Ready to put these tips into action? Start shopping on our main store.
Get Best Deals NowHandling Returns and Refunds
Returns are inevitable in reselling. The difference between profitable and struggling resellers is how efficiently they handle returns and learn from them. Your eastmallbuy spreadsheet should track every return in detail.
Add a Return Status column with options: No Return, Return Requested, Return Shipped, Return Received, Refunded, and Exchanged. When a customer initiates a return, update this column immediately so the inventory count adjusts correctly.
Add a Return Reason column using dropdown options: Wrong Size, Defective, Not as Described, Changed Mind, and Shipping Damage. After collecting thirty or more returns, filter by reason and identify patterns. If Defective dominates, that supplier needs quality discussion.
Add a Refund Amount column and a Net After Return column. The Net After Return formula subtracts Refund Amount and return shipping costs from the original Net Profit. Some orders that looked profitable actually lost money after returns. This column reveals the truth.
Looking for the complete picture?
Read the Eastmallbuy Spreadsheet Ultimate GuideCustomer Segmentation and Repeat Buyer Tracking
Repeat customers are the most profitable part of any reselling business. Tracking them in your eastmallbuy spreadsheet helps you identify VIPs who deserve priority treatment and occasional discounts.
Create a Customer Summary tab that aggregates order data by customer name. Use COUNTIF to count total orders per customer. Use SUMIF to total lifetime revenue. Use AVERAGE to show average order value. Sort by lifetime revenue descending to see your top customers instantly.
In the main Orders tab, add a Customer Tier column using a formula that references the Customer Summary. If lifetime revenue exceeds one thousand dollars, label them Gold. If between five hundred and one thousand, label them Silver. Below five hundred, label them Bronze.
Use conditional formatting on the Customer Tier column. Gold rows get a subtle gold background. When scanning active orders, you immediately spot VIP shipments and can prioritize them for faster processing or bonus packaging.
Tax Reporting and Expense Categorization
Tax season terrifies resellers who kept sloppy records. A well-structured eastmallbuy spreadsheet makes tax preparation a thirty-minute task instead of a week-long nightmare.
Add an Expense Category column with options: Cost of Goods Sold, Shipping Expense, Platform Fees, Packaging Materials, and Return Losses. Every order row gets one category. At year end, filter by category and sum the Net Profit or Loss column.
Create a Tax Summary tab that auto-calculates quarterly totals. Use SUMIFS formulas that sum Net Profit where Order Date falls within each quarter. This gives you quarterly profit numbers that align with tax payment schedules in most jurisdictions.
Save copies of your spreadsheet at the end of each quarter. Tax authorities sometimes request documentation from specific periods. Having dated snapshots ready eliminates last-minute scrambling through old files.
Comparison Table
| Metric | Formula Example | Purpose | Review Frequency |
|---|---|---|---|
| Net Profit | =Selling-Cost-Fee-Ship | True per-order profit | Per order |
| Profit Margin | =Net/Selling | Profit percentage | Weekly |
| Inventory Available | =InStock-Reserved | Sellable units | Daily |
| Return Rate | =Returns/TotalOrders | Quality indicator | Monthly |
| Customer LTV | =SUMIF(customer) | Lifetime value | Quarterly |
| Quarterly Profit | =SUMIFS(date range) | Tax reporting | Quarterly |
Related Reading
Frequently Asked Questions
Track order-related expenses like shipping and fees in the main sheet. Track general business expenses like software subscriptions in a separate Expenses tab or file. Keep them linked by month for consolidated reporting.
Start Using Your Eastmallbuy Spreadsheet Today
Download our free beginner template and visit the main store to begin organizing your orders the smart way.