What to Track in Your GTBuy Spreadsheet

Every GTBuy spreadsheet needs these twelve columns, no exceptions.

Date tells you when you committed capital.

Supplier Name identifies who you trusted with your money.

Product Name and SKU make items searchable.

Quantity and Unit Cost show your buy-in price.

Shipping Per Unit is where beginners consistently underestimate — a $2 item with $5 shipping is really a $7 item.

Total Cost should auto-calculate.

Target Resale Price is your goal before you list.

Estimated Profit reveals whether the deal is worth pursuing.

Actual Resale Price records what really happened.

Final Profit shows true performance.

Notes captures the story behind the numbers.

Without all twelve, your sheet is a partial picture.

Partial pictures lead to bad decisions.

Once your essentials are solid, consider adding these advanced columns.

Platform Name tracks where you sold each item — eBay, StockX, your own site.

Days to Sell measures velocity.

Fast sellers deserve bigger reorders; slow movers need price cuts.

Return Status and Return Reason flag quality issues.

Supplier Rating lets you score vendors on speed, accuracy, and communication.

Season Tag helps you spot winter coats that sell in October and die in March.

Restock Threshold triggers a reminder when inventory drops below your comfort level.

These columns add complexity, so only add them when you are consistently filling the essentials without skipping rows.

Raw data becomes intelligence when you calculate the right metrics.

Total Revenue sums every Actual Sale Price.

Total Profit sums every Final Profit.

Average Margin divides Total Profit by Total Revenue and shows your overall health.

Top Category identifies which product type earns the most.

Slowest Mover finds the SKU with the longest Days to Sell.

Supplier of the Month rewards your best partner.

Return Rate divides returned units by total sold.

A return rate above 5% signals a quality problem.

Each metric takes one formula to calculate but gives you strategic clarity that raw rows cannot provide.

More data is not always better.

Avoid tracking information that does not affect profit or operations.

Customer names are irrelevant unless you do direct sales.

Detailed product descriptions belong in your listing tool, not your tracker.

Emotional notes like excited about this drop clutter your sheet.

Shipping carrier details matter only if you are comparing speeds, which most buyers do not.

Photos have no place in a spreadsheet — use your phone or cloud storage.

The golden rule: if a column does not help you buy smarter, sell faster, or calculate profit, delete it.