A sales tracking sheet is a spreadsheet with one row per customer or lead, showing who owns them, what stage they are at, what they might spend, when you last spoke and what happens next. Twelve columns are enough for most small teams, and the free template below uses exactly those, so it imports into a pipeline later without remapping.
Key takeaways
- One row per lead, one owner per row, and a last-contact date. Those three things do most of the work.
- Add two formulas, days since last contact and a gone-quiet flag, and the sheet starts telling you who to call.
- Keep stages to six words and write them the same way every time. Spelling variants break every report.
- A sheet works well up to a handful of people and a few hundred leads. After that, the cost is in what nobody updates.
- This template uses the same columns as Rople's leads import template, so you can move without reworking it.
What columns should a sales tracking sheet have?
Use these twelve. Only the first is essential; every other column earns its place by answering a question you will ask every week.
| Column | What goes in it | Why it is there |
|---|---|---|
| Name | The person or business | The row's identity |
| Their email address | Spots duplicates, lets you send quotes | |
| Phone | Their number, formatted as text | The way most Nigerian customers reach you; text format keeps the leading 0 |
| Company | Where they work, if it is a business sale | Groups people at one buyer |
| Source | Instagram, referral, walk-in, website, flyer, Google Ads | Tells you which channel pays |
| Campaign | The named promotion, if any | Compares one flyer or ad with another |
| Interested in | What they asked for, in their words | So anyone can take over the conversation |
| Value | What the sale could be worth, in naira | Lets you add up the pipeline |
| Stage | New, Contacted, Qualified, Proposal, Closed won or Lost | Shows where each lead is |
| Owner | One named person | Without an owner, nobody follows up |
| Last contact | The date you last reached them | Drives the gone-quiet flag |
| Created | The date the lead arrived | Measures how long deals take |
A short example, with invented names. Treat it as an illustration of the layout, not real customers.
| Name | Phone | Source | Interested in | Value (₦) | Stage | Owner | Last contact |
|---|---|---|---|---|---|---|---|
| Adaeze Nwosu | 0803 000 0001 | 50 branded tote bags | 425,000 | Proposal | Tunde | 2026-11-12 | |
| Emeka Obi | 0802 000 0002 | Referral | Office chairs, 12 units | 1,080,000 | Qualified | Funmi | 2026-11-05 |
| Hauwa Bello | 0805 000 0003 | Walk-in | Wedding aso-oke order | 310,000 | Contacted | Tunde | 2026-11-10 |
| Segun Alabi | 0806 000 0004 | Website | Monthly catering for staff | 650,000 | Closed won | Funmi | 2026-11-14 |
How do you get the free template?
Download the Rople leads import template (.xlsx). It is an Excel workbook with three tabs. Leads is where you type, one lead per row from row 2, with a note on each column heading. How to fill it in explains each column and the stage words. Example shows five filled-in rows. It opens in Excel and in Google Sheets, where you can use File › Import to upload it.
You do not need Rople to use it. It is a plain sheet.
Three habits make it work:
- Type the same word every time. "Closed won", not "won", "Closed" and "Sold". Pick a list and use Data Validation to give the Stage column a drop-down.
- Format Phone as text before typing, or Excel drops the leading zero from 0803 numbers.
- Update Last contact the same day you speak to someone. A sheet with stale dates is worse than none.
What formulas make the sheet useful?
Put these in extra columns to the right of the twelve, so the main columns stay clean. They assume Stage is in column I, Value in H, Source in E, Owner in J and Last contact in K, with data from row 2.
If you would rather not type them, this workbook has the twelve columns, both formula columns and the summary formulas already set up.
Download the sales tracking sheet with the formulas built in (Excel)
Days since last contact (column M). Last contact must be a real date, not text:
=IF(K2="","",TODAY()-K2)
Gone quiet flag (column N). This marks open leads nobody has reached for six days or more:
=IF(AND(I2<>"Closed won",I2<>"Lost",M2<>"",M2>=6),"Gone quiet","")
Filter column N for "Gone quiet" every morning. That is your follow-up list.
Open pipeline value (anywhere on a summary tab):
=SUMIFS(H:H,I:I,"<>Closed won",I:I,"<>Lost")
Sales won, by source (one row per source on a summary tab):
=SUMIFS(H:H,E:E,"Instagram",I:I,"Closed won")
Win rate, the share of decided leads you won:
=COUNTIF(I:I,"Closed won")/(COUNTIF(I:I,"Closed won")+COUNTIF(I:I,"Lost"))
Microsoft documents both functions: SUMIFS and COUNTIFS. Google Sheets accepts the same formulas.
Now a note on the win rate: count only leads you have decided. A sheet with forty open leads and two wins is not a 5% win rate; it is a pipeline still in progress.
How do you track sales team performance in Excel?
Add a Weekly tab with one row per salesperson, put each owner's name in column A, and fill the other columns with COUNTIFS and SUMIFS. Here is a layout, for the owner in row 2.
| Owner | Open leads held | Gone quiet | Deals won | Value won (₦) |
|---|---|---|---|---|
| Tunde | =COUNTIFS(Leads!J:J,A2,Leads!I:I,"<>Closed won",Leads!I:I,"<>Lost") | =COUNTIFS(Leads!J:J,A2,Leads!N:N,"Gone quiet") | =COUNTIFS(Leads!J:J,A2,Leads!I:I,"Closed won") | =SUMIFS(Leads!H:H,Leads!J:J,A2,Leads!I:I,"Closed won") |
These count everything to date. For a monthly view, add a Closed date column to the Leads tab and a date condition to the formulas. Keep the measures to things a person can influence this week: leads held, leads gone quiet, proposals sent. Avoid ranking people by raw value alone, because one large deal can hide a quiet month.



