Net sales
$20,210
Avg transaction
$48
Conversion
24%
Retail Sales Tracker
Daily sales by channel with transactions, average basket and target progress.
12 free sales tracker templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 12 spreadsheets from Pipeline & Opportunity, Activities & Follow-up and Accounts & Customers. Start with Retail Sales Tracker, Sales Commission Tracker and Sales Quota Attainment Tracker: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Net sales
$20,210
Avg transaction
$48
Conversion
24%
Daily sales by channel with transactions, average basket and target progress.
Commission owed
$5,483
Total earned
$10,083
Team attainment
84%
Tiered commission with an accelerator above quota, a margin kicker, payouts to date and what each rep is owed.
Team attainment
45%
Projected finish
84%
Gap to quota
$347,000
Bookings against quota for each rep, with pace for the days gone, projected finish, pipeline coverage and the gap to close.
Output tax (sales)
$3,178
Input tax (purchases)
$383
Net tax due
$2,795
Output and input tax on every sale and purchase, the quarter worked out from the date, and the net due for each return.
Open pipeline
$270,400
Weighted forecast
$89,550
Won
$18,000
Deals by stage with weighted forecast, deal age, overdue follow-ups, win rate and a scorecard for every rep.
Open leads
7
Hot leads
3
Conversion rate
20%
Score every lead on fit and intent with points you control, grade them Hot, Warm or Cold and never miss a follow-up.
Activities this period
8
Meetings booked
2
Positive outcome rate
38%
Every call, email, meeting and demo with outcomes, plus a weekly scorecard for each rep against activity targets.
Active prospects
6
Overdue follow-ups
5
Gone quiet (14+ days)
4
Plan the next touch for every prospect so no lead goes quiet, with overdue follow-ups on top.
Revenue
$159,850
Average order value
$39
ROAS
7.4
Monthly orders, revenue, ad spend and refunds for each channel, with AOV, ROAS and refund rate.
Open partner pipeline
$484,000
Weighted open pipeline
$221,700
Won revenue
$141,500
Registered partner deals by stage with weighted pipeline, partner payouts, registration expiry and attainment by partner.
Gross revenue retention
85%
Net revenue retention
92%
Open renewals
$184,000
Every contract up for renewal with its value, likelihood and outcome, plus gross and net revenue retention.
Referrals
10
Conversion rate
70%
Referred revenue
$1,374
Track every referral from invite to first purchase, calculate rewards automatically and see what you owe and when.