Basetao Spreadsheet for Resellers
Inventory, Profit, and Scale Management

Resellers operate under different constraints than personal buyers. Every purchase is an investment that must generate return. Inventory must turn over quickly or capital sits idle. Profit margins are thin and shipping costs can erase gains entirely. A personal basetao spreadsheet tracks orders. A reseller spreadsheet tracks a business.

The difference is columns. Resellers need buy price, target sell price, estimated profit margin, listing platform, days in inventory, and sell-through rate. They need to see at a glance which items are profitable and which are shelf warmers. They need historical data that reveals seasonal demand patterns. A repurposed personal tracker simply cannot handle this analytical load.

Build your reseller basetao spreadsheet with these essential columns. Product Name and Link identify the item. Buy Price and Shipping In record your total landed cost per unit. Target Sell Price reflects market research from platforms like Grailed, eBay, or Depop. Platform tracks where you intend to list. Status moves through Sourcing, In Transit, Listed, Sold, and Shipped.

The magic column is Estimated Margin. Use a formula that subtracts Buy Price plus Shipping In from Target Sell Price minus Platform Fees minus Shipping Out. This single number tells you whether an item is worth buying before you ever click the purchase button. No margin, no buy. It is that simple.

Inventory that sits unsold for sixty days is dead capital. Add a Days in Inventory column that auto-calculates from the listing date. Set conditional formatting to turn rows yellow at thirty days and red at sixty. When a row turns red, it triggers a pricing review. Drop the price, bundle it, or write it off. But do not let it rot silently in your basetao spreadsheet.

Cash flow tracking is equally critical. Create a summary row that shows total capital deployed, total revenue received, and net profit month by month. Watch the gap between deployed capital and received revenue. If that gap grows, you are buying faster than you are selling. Slow down sourcing until the numbers rebalance.

Every resale platform takes a different cut. eBay charges insertion fees, final value fees, and promoted listing costs. Grailed takes a percentage plus payment processing. Depop has its own fee structure. Your basetao spreadsheet should not assume a flat ten percent. It should calculate exact fees by platform so your margin estimate is precise.

Create a separate Platform Fees reference tab that lists each platform, its fee percentage, fixed fees, and average shipping cost. Your main sheet then uses VLOOKUP to pull the correct fee structure based on the Platform column. When a platform changes its fees, update one cell in the reference tab and every margin calculation updates automatically.

A side hustle reseller might track twenty items in a simple Google Sheet. A scaling operation tracks two hundred items across multiple agents, platforms, and currencies. At that volume, your basetao spreadsheet needs database-level architecture. Consider graduating to Airtable or Notion for relational data, automated views, and API integrations with your listing platforms.

The transition point is usually around one hundred active inventory items. Before that, a well-structured spreadsheet handles the load. After that, the benefits of a real database start outweighing the familiarity of spreadsheet formulas. Plan the migration before you hit the wall. Export your historical data as CSV, design the database schema, and switch during a slow sales period rather than mid-peak season.