Reseller Profit Tracker - Track Your Resale Business Finances
Reselling on eBay, Poshmark, and Mercari means tracking sourcing costs, platform fees, shipping expenses, and inventory. SheetLink automatically syncs your bank account to Google Sheets, giving you real-time visibility into sales, costs, and profit per item—all in one spreadsheet.
Why Resellers Need Better Bookkeeping
Reselling is more complex than it looks—profitability depends on tight cost tracking:
- Item-level tracking - Need to know profit on each individual item, not just monthly totals
- Variable platform fees - eBay (12.9%), Poshmark (20%), Mercari (10%), Facebook Marketplace (free)
- Shipping costs - Varies by carrier, package size, and buyer location
- Sourcing channels - Thrift stores, garage sales, wholesale, clearance, online arbitrage
- Inventory management - Track what's sold vs sitting, calculate inventory value
- Multi-platform selling - Cross-posting means sales come from different platforms
SheetLink solves this by automatically syncing all bank transactions—platform deposits, sourcing purchases, shipping costs, and supplies—to Google Sheets where you can track profit per item and overall business metrics.
How SheetLink Helps Resellers
Get automated resale bookkeeping at a fraction of the cost of inventory management software:
- Auto-sync platform deposits - Track sales from eBay, Poshmark, Mercari, Depop, Vinted
- Track sourcing costs - Sync thrift store, yard sale, and wholesale purchases
- Monitor platform fees - See how much each marketplace takes from your sales
- Track shipping expenses - USPS, UPS, FedEx charges and supplies (boxes, tape, labels)
- Calculate profit per item - Know which categories and sourcing channels are most profitable
- Affordable pricing - $2/month vs List Perfectly ($30/month) or Vendoo ($40/month)
What to Track for Your Resale Business
SheetLink syncs all transactions so you can organize your reseller finances:
Income Sources
- eBay sales deposits
- Poshmark payouts
- Mercari payments
- Depop sales
- Facebook Marketplace (Venmo/Zelle)
- Local sales (cash app deposits)
- Wholesale/bulk sales
Expense Categories
- Inventory purchases (COGS)
- Platform fees (eBay, Poshmark, Mercari)
- Shipping costs (postage, carriers)
- Packaging supplies (boxes, mailers, tape)
- Listing fees & promoted listings
- Labels & printer ink
- Software subscriptions (crossposting tools)
- Storage (shelves, bins, climate control)
- Mileage (sourcing trips)
Calculate Profit Per Item
Successful resellers track every item's profitability. Here's how to calculate accurately:
Example: Thrift Store Clothing Flip
Example: eBay Electronics Flip
With SheetLink, build formulas in Google Sheets to calculate this automatically for each sale. Track which categories (clothing, electronics, vintage) have the best margins.
Platform Fees Breakdown
Understanding platform fees is critical for pricing and profitability:
eBay: 12.9% + $0.30 Final Value Fee
eBay charges 12.9% + $0.30 on most categories. Some categories differ: guitars (3.5%), trading cards (12.35%). Add 250 free listings/month, then $0.35/listing. Promoted listings: 2-20% ad fee optional.
Poshmark: 20% on $15+, $2.95 on under $15
Poshmark takes 20% commission on sales $15 and above, flat $2.95 on sales under $15. Shipping labels provided at flat rate ($7.97 for up to 5 lbs). No listing fees. Best for clothing, accessories.
Mercari: 10% + Payment Processing
Mercari charges 10% selling fee + payment processing (2.9% + $0.30). Lower fees than competitors. Prepaid shipping labels available. Good for general merchandise, collectibles, electronics.
Facebook Marketplace: Free (0% fees)
Facebook Marketplace has no selling fees for local pickup. Shipping option charges 5% or $0.40 minimum. Best for large items, furniture, local sales. Use Venmo/Zelle for payment.
Track Inventory & Sourcing ROI
Smart resellers track which sourcing channels give the best ROI:
- Thrift stores (Goodwill, Value Village) - High margin potential (400-1000% ROI) but time-intensive
- Yard/garage sales - Best prices but inconsistent inventory, seasonal
- Estate sales - Quality items, vintage finds, but competitive with other resellers
- Retail arbitrage - Clearance racks at Target, Walmart, TJ Maxx (lower margins, 30-50%)
- Online arbitrage - Amazon clearance, eBay lots (easier to scale, requires research)
- Wholesale - Buy in bulk from distributors (lower per-unit margins but volume)
Tag each inventory purchase in SheetLink by sourcing channel. Calculate average ROI per channel to focus your time on highest-return sources.
Key Metrics for Resellers
Build these metrics in your SheetLink spreadsheet to monitor business health:
Essential Reseller Metrics
- Profit Margin %: (Net Profit ÷ Sale Price) × 100 (target: 40-60%)
- Average ROI: (Total Profit ÷ Total COGS) × 100 (target: 200-500%)
- Inventory Value: Total $ tied up in unsold items (minimize to improve cash flow)
- Sell-Through Rate: (Items Sold ÷ Items Listed) × 100 (target: 70%+)
- Average Days to Sell: How long items sit before selling (lower is better)
- Inventory Turnover: Items Sold ÷ Average Inventory (target: 6-12x per year)
- ROI by Category: Which item types (clothing, electronics, vintage) are most profitable
- ROI by Sourcing Channel: Which sourcing method gives best returns
How to Set Up Your Reseller Tracker
Get your resale business bookkeeping organized in under 15 minutes:
- Install SheetLink Chrome Extension - Add from Chrome Web Store
- Connect Your Business Bank Account - Link the account where platforms deposit sales via Plaid
- Connect Your Business Credit Card - Track sourcing purchases, shipping, and supplies
- Create Your Reseller Finance Sheet - Start with a blank Google Sheet
- Sync Transactions - SheetLink pulls in all sales deposits and expenses
- Add Custom Columns - Item SKU, Platform, Category, Source Channel, Sale Date
- Tag Transactions - Mark each sale with item details and each purchase with sourcing info
- Build Profit Formulas - Calculate profit per item, average margin, ROI by category
Manage Dead Stock & Slow Movers
Not every item sells quickly. Track aging inventory to minimize cash tied up:
30-60 Days Listed
Normal timeframe for most items. Monitor interest (views, likes, watchers). Consider small price drop or promotion if no traction.
60-90 Days Listed
Slow-moving inventory. Reduce price by 10-20%, improve photos/description, relist with better keywords, or bundle with other items.
90+ Days Listed (Dead Stock)
Consider deep discount (30-50% off), donate for tax write-off, or source to wholesale buyers. Accept break-even or small loss to free up cash for better inventory.
SheetLink vs. Reseller Software
| Tool | Cost | Best For |
|---|---|---|
| SheetLink | $2/month | Solo resellers, simple bookkeeping |
| List Perfectly | $30-70/month | Crossposting + profit tracking |
| Vendoo | $40-80/month | Multi-platform automation |
| QuickBooks | $30-75/month | Full-time resellers with employees |
| Manual spreadsheet | Free (time cost) | Beginners, very small scale |
SheetLink advantage: Automated bank sync with full spreadsheet control at a fraction of the cost. Perfect for resellers who want profit tracking without expensive crossposting features. Combine with free listing tools for complete workflow.
Tax Season for Resellers
Resellers file Schedule C (self-employment income) and track COGS carefully:
- Gross receipts - Total sales from all platforms (tracked automatically by SheetLink)
- COGS deduction - Inventory purchases are deductible when items sell, not when purchased
- Year-end inventory - Calculate value of unsold items; affects COGS calculation
- Business expenses - Shipping, platform fees, supplies, mileage, storage
- Quarterly estimated taxes - Pay 25-30% of net profit each quarter to avoid penalties
- 1099-K reporting - Platforms send 1099-K if you make $5,000+; verify with SheetLink records
- Mileage deduction - Track sourcing trips at $0.67/mile (2024 rate)
Real Reseller Use Cases
Jessica - Clothing Reseller
Challenge: Jessica thrifted 50+ items per week but couldn't track which brands were most profitable. Wasted time on low-margin items.
Solution: SheetLink syncs all Poshmark and eBay sales. Jessica tags each sale by brand and category, calculates profit per item.
Result: Discovered designer jeans had 800% ROI while fast fashion averaged 200%. Focused sourcing on high-end brands, doubled monthly profit from $2,000 to $4,200.
Tom - Electronics Flipper
Challenge: Tom sourced from yard sales and online marketplaces but had $3,000 in dead stock not selling on eBay.
Solution: SheetLink tracks all purchases and sales. Tom calculated days-to-sell for each category and identified slow-moving items.
Result: Liquidated dead stock at break-even, reinvested in faster-selling categories (gaming consoles, Apple products). Reduced inventory from $8,000 to $4,500 while maintaining same revenue. Improved cash flow by 45%.
Pricing for Resellers
SheetLink is designed to scale with your resale business:
- Free Tier - Last 7 days of transactions (good for new resellers testing viability)
- Basic Plan - $2/month for 90 days of history (recommended for part-time resellers)
- Pro Plan - $10/month for 24 months of history (best for full-time resellers, tax records)
Recommended tier: Basic ($2/month) for side hustle resellers making under $3k/month. Pro ($10/month) for full-time resellers doing $3k+ monthly revenue who need complete tax records and year-over-year comparisons.
Get Started: Track Your Reseller Profit Today
Stop guessing at profitability and start tracking real numbers. Know which items are winners, which sourcing channels work best, and exactly what you owe in taxes.
Ready to track your reseller finances automatically?
Free forever for the last 7 days of transactions. Perfect for resellers.
Add to Chrome - Start Tracking Your Business