Home Setup Do it yourself Results Blog About
Free Client Leak Check Apply for the setup
Back to Articles
Nov 15, 2026 Feyisayo Daisi System Setup

Sales Tracking Template for B2B Teams: The Columns That Matter and When a Spreadsheet Stops Working

Revenue Systems Architect | Founder, Plumemark

TL;DR
  • A B2B sales tracker needs 8 columns: client and contact, source, stage, value, owner, next action and date, expected close date, and lost reason.
  • Every deal needs a next action with a date, and deals with no activity in 30 days should leave the active list.
  • A spreadsheet works for one to three people; it fails when updates depend on memory or selling happens on WhatsApp.
  • Choose tracking software that does the remembering for you, not just stores the record.
Sales tracking template on a laptop for a B2B team

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:

ColumnExampleThe question it answers
Client and contactOkafor Logistics, Mrs Okafor (Ops Director)Who is this, and who decides?
SourceInstagram ad, field agent Tunde, referralWhat actually brings buyers?
StageQuote sentWhere is it, honestly?
Value₦4,500,000How much is at stake?
OwnerChidiWho is responsible for the next step?
Next action and dateCall to confirm approval, 21 NovWhat happens next, and when?
Expected close date30 NovHow much lands this month?
Lost reasonWent with cheaper quoteWhy 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

  1. 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.
  2. 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.
  3. Format Value as naira and Next action date as a date, so you can sort and total them.
  4. 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.
  5. Add an overdue rule. Conditional formatting that turns a row red when Next action date is before today shows the deals nobody is working.
  6. 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.

Related reading


Want tracking that runs itself?

Get the Plumemark Client System in the do-it-yourself kit. No monthly bill, priced in naira for Nigerian businesses.

Get The Do-It-Yourself Kit →

Frequently Asked Questions

What should a sales tracking template include?

For B2B sales: client and contact, lead source, pipeline stage, deal value, owner, next action with a date, expected close date and, for lost deals, the reason. Leave out columns nobody acts on.

Is a spreadsheet good enough to track sales?

For one to three people with a few dozen open deals, yes, if every deal has a next action date and stale deals are removed. It stops working when updates depend on memory, when selling happens on WhatsApp, or when you need reminders rather than a record.

What is the best sales tracking app for a B2B business?

The one your team will actually keep up to date. Look for one that connects to where your conversations happen, such as WhatsApp, and that reminds people what to do next, not just one that stores the deal.

How do I track where my sales come from?

Record the source the moment a lead arrives: the specific ad, field agent or referral. If it is not captured on day one, it can almost never be worked out later.