Free ecommerce sales tracking template (Excel) and planning kit

Track your sales one tab a month, one row per place you sell, and keep definitions steady: traffic is visits or sessions, a checkout is a paid order, and revenue is counted the same way each month, before or after refunds. Weekly beats daily sales entry for most stores. Charts and graphs can wait: a line chart of each month's Total row is enough to monitor sales.

Every result in the tracker spreadsheet is one column divided by another, and the label says which. Traffic > Add to Cart is add-to-cart clicks over traffic. Traffic > Checkout is checkouts over traffic, your conversion. Traffic > Repurchase uses repurchases. Add to Cart > Checkout is checkouts over carts, and Revenue Per Unit is total revenue over units sold.

Made-up numbers: your site gets 40,000 visits, 2,400 add-to-cart clicks, 960 checkouts (150 repeat orders) and $57,600 from 1,200 units. This example works out at 6% visit to cart, 2.4% conversion, 40% cart to checkout and $48 a unit. A marketplace row: 25,000 visits, 1,750 carts, 500 checkouts. More baskets (7% in the example), but only 28.6% get paid for. Fix price, delivery or payment there (cash on delivery matters in much of the Gulf), not traffic.

The fairest way to track a channel is against its own last month first, the market second. Statista's 2025 data puts the average conversion rate across ecommerce sites at under 2%. Statista's 2025 category benchmarks run from skincare at 2.7%, the highest, to luxury apparel at 0.4%, the lowest. So if you sell something expensive, 1.2% may be healthy. For a cheap repeat buy, it's weak.

Repeat purchase rate is the share of customers who bought more than once in a period, usually 12 months: if 5,200 people bought in a year and 1,040 came back, that's 20%. The tracker's Traffic > Repurchase line compares repeat buying with visits instead. If Repurchase counts repeat orders, divide it by Successful Checkouts in a new column (in the example, 150 of 960 is 15.6%).

Mixing date ranges is the classic: a calendar month for your site, a four-week report from a marketplace. Then refunds netted off in one row but not the next, and typing over last month's tab. The sneaky one? Comparing a marketplace's conversion with your site's when they count visits differently. Compare each channel with itself and the trend stays honest.

One tab a month is plenty for a small business with one hero product; a big range needs a tab per product line. Selling B2B? Fewer, larger orders, so watch revenue per unit over visit to cart. Running ads? Add an ad spend column and divide it by checkouts for a rough cost per order. And make room for new channels: HubSpot's 2026 State of Marketing report found that 26% of marketers plan to try selling directly inside social apps in 2026.