You started a spreadsheet to track sales. Column A for the client, B for the amount, C for the status. For two weeks it was perfect. Now it is a month behind, three people keep their own copies, and when you ask "how much is coming in this month?" someone still has to scroll WhatsApp to find out.
A sales tracking template isn't the problem. What goes in it, and who keeps it current, is. Here is the sales tracking template structure that works for B2B businesses, what to put in each column, and the point at which a spreadsheet stops being enough. If you want this structure ready-made, the Plumemark Client System is a Google Sheets CRM and sales tracker with automatic follow-ups.
The sales tracking template: the columns that matter
Most free sales tracking templates are built for shops: product, quantity, price. B2B sales need to track deals that take weeks and pass through several conversations. These are the columns that answer the questions a B2B owner actually asks:
| Column | Example | The question it answers |
|---|---|---|
| Client and contact | Okafor Logistics, Mrs Okafor (Ops Director) | Who is this, and who decides? |
| Source | Instagram ad, field agent Tunde, referral | What actually brings buyers? |
| Stage | Quote sent | Where is it, honestly? |
| Value | ₦4,500,000 | How much is at stake? |
| Owner | Chidi | Who is responsible for the next step? |
| Next action and date | Call to confirm approval, 21 Nov | What happens next, and when? |
| Expected close date | 30 Nov | How much lands this month? |
| Lost reason | Went with cheaper quote | Why do we lose, and can we fix it? |
Leave out anything nobody will act on. Every extra column is one more thing that won't get updated in a busy week.
The rules that keep a sales tracker accurate
- Every deal has a next action with a date. A row with no date is a deal nobody is working.
- Stages have rules. "Quote sent" means the buyer confirmed they received it, not that you emailed it. See our sales pipeline stages template for the full set.
- Source is filled in on day one. You can't work out later which ad a lead came from.
- Stale deals leave. No activity in 30 days moves a deal to lost or to a dated "check back" list. Otherwise your total pipeline looks healthy and isn't.
- One sheet, one owner of the structure. Copies multiply and nobody knows which one is true.
Not sure where your sales are leaking?
Run the free Client Leak Check. Two minutes, no call required.
Run The Client Leak Check →How to set up the sales tracking template in Google Sheets
- Create the eight columns above in one sheet called "Deals". One row per deal, not per client: a client with two projects gets two rows.
- Turn Stage, Source and Owner into dropdowns (Data, then Data validation). Free typing is how "Quote Sent", "quote sent" and "Qt sent" end up as three different stages.
- Format Value as naira and Next action date as a date, so you can sort and total them.
- Add a "This month" view. Filter Expected close date to this month and Stage to anything not won or lost. That list is your honest forecast.
- Add an overdue rule. Conditional formatting that turns a row red when Next action date is before today shows the deals nobody is working.
- Set a 15-minute weekly review. Every Monday, each owner updates their rows and clears the red ones. The review is what keeps the sheet true.
Twenty minutes to build, fifteen a week to keep honest. If even that keeps slipping, the problem is the reliance on memory, which is the point to move to something that reminds you.
Sales tracking app, software or spreadsheet?
A well-built spreadsheet is enough for one to three people selling, with up to a few dozen open deals. It stops being enough when:
- Updating it depends on people remembering, and a busy week means it falls behind.
- Most of the selling happens on WhatsApp, so the real conversation never reaches the sheet.
- You need reminders, not just a record. A spreadsheet will show you a follow-up date; it won't tell you it is today.
- A rep leaves and nobody can tell which of their deals were real.
That is when B2B teams reach for sales tracking software or a CRM. Before paying for one, read which CRM fits a Nigerian B2B team and spreadsheet vs CRM for B2B founders. The tool matters less than whether it does the remembering for you.
What changes when tracking runs itself
With clients abroad, moving from hand-kept sheets to a system that updates as deals move cut manual reporting by 78% and made replies to new leads 3.2x faster. The owners stopped asking for status updates, because the numbers were already on one screen.
If you want that without a monthly CRM bill, the Plumemark Client System in the do-it-yourself kit is built on your own Google account and tells you each morning who to talk to. It is priced in naira for Nigerian businesses.