Home / Blog / Order management

Order management

Google Sheets Order Tracker: The Columns Every Seller Needs

Build a clean Google Sheets order tracker for eBay, Amazon or Etsy. The exact columns to use, formulas for profit, and mistakes to avoid.

By the Ecom Orderlytics team4 min read

Google Sheets Order Tracker: The Columns Every Seller Needs – Ecom Orderlytics blog illustration
On this page
  1. The essential columns
  2. The profit formula
  3. Five rules that keep a tracker clean
  4. Useful formulas for your tracker
  5. Data validation keeps the sheet clean
  6. Protect the header row
  7. From tracker to dashboard
  8. Frequently asked questions

A good order tracker is boring in the best way: the same columns, filled the same way, by everyone, every day. Here is the layout we recommend for marketplace sellers.

The essential columns

Column Example Why
Order date 2026-10-21 Daily and monthly totals
Marketplace order ID 12-34567-89012 Unique key, avoids duplicates
Supplier Supplier name Compare suppliers
Supplier order ID A-99812 Match purchases to sales
Quantity 1 Units sold
Payout 34.20 Money from the marketplace
Sourcing cost 18.50 Product cost
Shipping cost 5.10 Delivery cost
Prep cost 0.90 Packaging and labels
Order status Completed / Refund / Cancelled Honest totals
Tracking Tracking number Customer service

The profit formula

Add a Profit column: =Payout - Sourcing - Shipping - Prep.

For a monthly total, use SUMIFS on the profit column filtered by month and status. Exclude cancelled orders, and decide clearly how you treat refunds.

Five rules that keep a tracker clean

  1. One row per order. Never merge orders into one row.
  2. Order ID is unique. It is how duplicates are caught.
  3. Never delete refunds. Change the status instead.
  4. Dates in one format. Mixed formats break monthly totals.
  5. One sheet per account. Do not mix stores in one tab.

Useful formulas for your tracker

Assuming payout is in column F and costs are in G, H and I:

  • Profit per row: =F2-G2-H2-I2
  • Margin per row: =IF(F2=0,"",J2/F2) (using profit in column J)
  • Monthly profit: =SUMIFS(J:J, A:A, ">="&DATE(2026,10,1), A:A, "<"&DATE(2026,11,1), K:K, "<>Cancelled")
  • Refund count this month: =COUNTIFS(K:K, "Refund", A:A, ">="&DATE(2026,10,1))

Adjust the column letters to match your sheet.

Data validation keeps the sheet clean

Use Data → Data validation in Google Sheets to:

  • Limit the status column to Completed, Refund and Cancelled.
  • Require dates in the date column.
  • Require numbers in payout and cost columns.

Validation stops most typing mistakes before they reach your totals.

Protect the header row

Lock the header row (Data → Protect sheets and ranges) so nobody renames or deletes a column by accident. Renamed columns are one of the most common reasons syncs and formulas break.

From tracker to dashboard

This layout is exactly what Ecom Orderlytics expects. Connect the sheet once and you get sales, payout, expenses, profit and ROI per account, a daily tracker and monthly reports, with no formulas to maintain. Prefer files? Import a CSV, Excel file or sheet link from the Daily Tracker → Import screen and match your columns once.

Ready to stop maintaining formulas? Read when to switch from Google Sheets.

Frequently asked questions

What columns should an order tracking sheet have?

Order date, order ID, supplier, supplier order ID, quantity, payout, sourcing cost, shipping cost, prep cost, order status and tracking number.

How do I calculate profit in the sheet?

Add a column with =Payout - Sourcing - Shipping - Prep for each row.

Should refunds be deleted from the sheet?

No. Mark them with a status so your history and totals stay honest.

See your real profit, account by account.Free 7-day trial with every feature. Keep your Google Sheets.
Start free trial

← All articles

Free 30-minute live demo available

See your real profit, account by account.

Start a 7-day free trial and we’ll set everything up with you, or book a live demo and see Ecom Orderlytics running on real numbers first.

  • Set up within one working day
  • No card needed for the trial
  • Your data stays yours

Video

Write a review

Tell other sellers how Ecom Orderlytics works for you. Reviews appear on the website after a quick check.

Your rating
0 / 1500
Upload your video or Short to YouTube, then paste its link here.
Use your Ecom Orderlytics login email to get the “Verified customer” badge.

Start your free trial

Two quick steps. It takes about a minute.

Step 1 of 2: your details
What would you like?
Plan
Enter your name.
Enter an email like name@example.com.
Enter your WhatsApp number with country code, like +92 300 1234567.
Choose your country.
Use at least 8 characters.You’ll sign in with this email and password at app.ecomorderlytics.com.
Free for 7 days. No payment details needed.

Book a free live demo

Pick a time that suits you, then tell us about your business.

Step 1 of 2: choose a day and time
Choose a day
Choose a day for your demo.
Choose a time (Pakistan time, GMT+5)

Choose a day first.

Choose a time for your demo.
Free, no obligation. We confirm your slot on WhatsApp.