How to Use GTBuy Spreadsheet Step-by-Step

Never work directly in the master template.

Open the GTBuy spreadsheet template in Google Sheets, click File > Make a Copy, and rename it with the current month and year.

This preserves your master file and creates a clean workspace.

Organize your Google Drive by creating a folder named GTBuy Tracking and storing each monthly copy inside.

If you use Excel, save the template as an .xlsx file and create a new copy each month using Save As.

This habit alone will save you hours when you need to look up old orders or compare month-over-month performance.

The template includes standard columns, but your business is unique.

Review each column and decide if you need it.

Selling sneakers? Add columns for Size and Colorway.

Buying electronics? Add Condition Grade and Warranty Expiry.

Dropshipping? Add Platform Name and Listing Date.

Remove columns you will never use to reduce clutter.

The goal is a sheet that feels custom-built for your workflow.

To add a column, right-click the column header next to where you want it, select Insert column, and add your header.

Drag columns to reorder them.

Rename existing headers by double-clicking the cell.

Start with a small, recent order so the data feels familiar.

Click the first empty row below your headers.

Enter the order date using YYYY-MM-DD format.

Type the supplier name exactly as you want it to appear in reports.

Fill in Product Name, SKU, Quantity, Unit Cost, and Shipping Per Unit.

The Total Cost column should auto-calculate.

Enter your Target Resale Price.

The Estimated Profit column should also auto-calculate.

If either formula cell shows an error, double-check that you entered numbers, not text, in the numeric columns.

In the Notes column, add anything useful: delivery took 12 days, color slightly darker than photos, customer loved this batch.

These notes become invaluable when you scale.

Raw data is useful.

Summarized data is powerful.

Create a new sheet tab named Dashboard.

In cell A1, type Monthly Summary.

In A3, type Total Orders This Month.

In B3, enter =COUNTA(Master!A:A)-1 to count all rows minus the header.

In A4, type Total Spend.

In B4, enter =SUM(Master!H:H) assuming column H is Total Cost.

In A5, type Total Estimated Profit.

In B5, enter =SUM(Master!J:J).

In A7, type Top Supplier.

Use =QUERY(Master!A:L, select B, sum(H) group by B order by sum(H) desc limit 1, 1) to find your biggest supplier by spend.

These formulas update automatically as you add rows, giving you a live business dashboard.

A spreadsheet is only as good as the data you feed it.

Set a recurring 10-minute calendar block every evening to update your sheet.

Log new orders, mark items as sold, and add any notes.

Every Sunday, spend 20 minutes reviewing your Dashboard tab.

Look for red flags: shrinking margins, slow-moving SKUs, or suppliers with rising costs.

Every month, archive the current sheet and start a fresh copy.

Compare this month is profit to last month is.

This routine turns your spreadsheet from a chore into a competitive advantage.