GTBuy Spreadsheet for Resellers: Complete Workflow Guide

Before you buy anything, log it in your spreadsheet.

This is your pre-purchase checkpoint.

Enter the product name, supplier, unit cost, and estimated shipping.

Let the spreadsheet calculate total landed cost and estimated profit.

If the margin is green, proceed.

If it is red, walk away.

This single habit prevents 90% of bad purchases.

Professional resellers never buy on impulse.

They buy on data.

Add a Sourcing tab to your spreadsheet where you list potential deals before committing.

Rank them by margin, then buy the top three.

This transforms random shopping into strategic purchasing.

Once you place an order, move it from Sourcing to Active Orders.

Add tracking numbers, expected delivery dates, and payment method.

When items arrive, update the Status column to Received and add a quality check note.

Did everything match the description? Were there damages? Was the count correct? These notes protect you in disputes and help you rate suppliers accurately.

Create a Receiving tab with columns for Inspection Date, Pass/Fail, Issues, and Photo Link.

Document everything.

A photo of damaged goods uploaded to cloud storage with a link in your spreadsheet is evidence that wins PayPal disputes.

After receiving, list your items and record the details.

Add Platform Name, Listing Date, Listed Price, and Listing Fee to your spreadsheet.

Track Days to Sell from listing date to sale date.

Fast sellers tell you what to reorder.

Slow movers tell you what to discount.

Update the Actual Sale Price the moment an item sells, not at month-end.

The difference between listed price and actual sale price reveals how often you need to discount.

If you are discounting more than 20% of listings, your sourcing criteria need adjustment.

Use your spreadsheet to find the sweet spot where items sell within 14 days at full price.

At month end, run your numbers.

Total revenue minus total cost equals true profit.

Divide profit by revenue for your margin percentage.

Break it down by category to find your winners.

Break it down by supplier to find your best partners.

Break it down by platform to see where you sell best.

Use this data to adjust next month is strategy.

If hoodies earn 35% margins but sneakers only earn 18%, shift buying power toward hoodies.

If Supplier A delivers in 8 days and Supplier B takes 18 days, increase volume with A.

This is how spreadsheet data becomes business strategy.