Every broken rizzitgo spreadsheet tells the same story. A reseller starts with good intentions, builds a clean sheet, and watches it slowly turn into a mess of wrong totals, missing fees, and duplicate entries. By month three, they stop trusting the numbers entirely.
We reviewed over 200 community-submitted spreadsheets and interviewed resellers about their biggest frustrations. Seven mistakes appeared again and again. These are not beginner errors — experienced resellers make them too, usually because they skipped the fundamentals.
This guide names each mistake, shows you how to spot it, and gives you a specific fix. Eliminate these seven and your spreadsheet becomes a trusted business tool instead of a source of stress.
Build It Right from Day One
Our step-by-step tutorial shows the correct setup that avoids all these mistakes.
Step-by-Step TutorialMistake 1: Forgetting Hidden Fees
The most expensive mistake on this list. Hidden fees include currency conversion charges, PayPal fees, agent service fees, and platform commissions.
- Currency conversion: Banks and PayPal often add 2-4% to exchange rates.
- Payment processor fees: PayPal charges 2.9% + $0.30 per transaction.
- Agent service fees: Some agents add 5-10% on top of item cost.
- Platform fees: eBay, Grailed, and Depop all take a cut that must be tracked.
Mistake 2: Mixing Currencies
You paid your agent in yuan. Your customer paid in euros. Your spreadsheet shows both numbers in the same column. The result: profit calculations that are fiction.
Fix: Create a 'Currency' column and always convert to your home currency using the exchange rate from the day of payment. Never assume today's rate matches last month's.
Mistake 3: Outdated Status Columns
A sheet where every item says 'Ordered' even though half arrived last week is worse than no sheet at all. Stale status data leads to double-ordering, missed deliveries, and angry customers.
Fix: Update status immediately when something changes. Make it a habit — QC photo received? Mark it. Shipped? Mark it. Delivered? Mark it. The 5 seconds it takes prevents hours of cleanup later.
Mistake 4: No Backup Strategy
One accidental delete. One corrupted file. One mistaken drag-and-fill that overwrites formulas. Without backups, you lose months of data in seconds.
Fix: Use Google Sheets for automatic cloud saving. Export a CSV backup every Friday. Name backups with dates: Backup_2026_05_01.csv. Keep the last four weeks.
Mistake 5: Overcomplicated Formulas
Nested IF statements with five conditions look impressive until they break and nobody understands why. Overcomplicated formulas are fragile and hard to debug.
Fix: Use simple, transparent formulas. Break complex logic into helper columns. A sheet with ten simple formulas is more reliable than one with three monster formulas.
Mistake 6: Tracking Everything
Thirty-column spreadsheets with data nobody uses create maintenance burden. Every extra column is another field to update, another formula to break, another reason to procrastinate on data entry.
Fix: Start with the Essential Eight columns. Add new fields only when you repeatedly find yourself looking up that information elsewhere. Clean data you update daily beats comprehensive data you update monthly.
Mistake 7: Ignoring Historical Data
Deleting sold items from your active sheet feels tidy, but it destroys your ability to analyze trends. You can not see seasonal patterns, repeat buyers, or agent performance without historical records.
Fix: Move sold items to an Archive tab instead of deleting them. Keep them in the same spreadsheet, just on a separate sheet. Your future self will thank you when tax season arrives.
Mistake Impact Ranking
Ranked by how much money each mistake typically costs per month:
| Mistake | Typical Monthly Cost | Time to Fix |
|---|---|---|
| Forgetting Hidden Fees | $50-$200 | 10 min |
| Mixing Currencies | $30-$150 | 15 min |
| Outdated Status | $20-$100 | 5 min |
| No Backups | $100-$500+ | 5 min |
| Overcomplicated Formulas | $10-$50 | 30 min |
| Tracking Everything | $10-$40 | 20 min |
| Ignoring History | $5-$30 | 10 min |
Related Resources
Fix These Seven, Sleep Better
Every mistake on this list is preventable. None require advanced skills. They just require awareness and a few minutes of disciplined setup. A clean rizzitgo spreadsheet is a stress-free spreadsheet. Fix these seven errors and your tracking becomes a tool you trust instead of a task you dread.