Sales pipeline in Excel: CRM for quotes, renewals and forecasts

Context

If you're responsible for sales at a services business or professional practice, you deal with changing quotes, engagements awaiting confirmation and contracts due for renewal. Checking where a deal stands means opening Excel, finding the latest email and asking whoever last spoke to the client. The information exists, but you need the right person to piece it together.

That becomes a problem when you plan the workload. Which jobs might start, when, and what have you already committed to? The spreadsheet holds the values; the terms and the client's reservations are elsewhere. Before you can discuss priorities, you have to establish the facts.

This is a representative scenario, not an account of a single client engagement. We explain how we tackle these issues using CRM within the Odoo business management system. The before-and-after comparisons describe intended changes, not measured results.

The challenge

1. Quotes are in Excel; the client conversation is elsewhere. Tracking quotes, jobs and renewals through Excel files and scattered messages leaves firms with unclear pipelines and unreliable revenue forecasts (sellyerp.com, 4 September 2026). You recognise the problem when two people bring different lists of open deals to a meeting. You cannot tell which is current, or whether a quote is still under discussion or has been superseded.

2. The quote keeps changing, but nobody knows which version was agreed. A quote starts in Word or Excel, changes after a phone call and goes out again. Accounts receives an attachment, then has to ask whether it includes the latest amendments. Failure to track client feedback and signatures is another reported difficulty (turatti.digital, 27 November 2025). Without that trail, even finding the accepted quote means searching through emails.

3. Follow-ups rely on someone remembering. One client is waiting for clarification; another asked for a call after the summer. Without a date and an owner, the next step is just an intention. When you review the pipeline, deals remain open with no indication of whether the client is considering the offer or waiting to hear from you.

4. The forecast mixes expectations with commitments. Ask what will come in this quarter and everyone uses a different test. One person counts every quote sent; another counts only verbal agreements. Adding those values together does not make a reliable forecast without expected close dates and shared criteria. An order is not yet revenue, either: service delivery and the agreed invoicing schedule also need to be considered.

The numbers worth looking at

Before configuring the CRM, we help you establish a starting position. These questions measure the process, using the files you already have if necessary. To make comparisons over time meaningful, we agree what counts as open, which period to review and which dates to use.

• How many leads and deals have no assigned owner?
• How many days have passed since the last contact on each open deal? Which has gone longest without contact?
• How many follow-up tasks are overdue, and by how many days? How many open deals have no next action scheduled?
• How many quotes still have no recorded outcome? How long ago were they sent?
• What is the total value, in euros, of deals stalled for more than 30, 60 and 90 days? Which stages account for most of them?
• How long does it take to move from first contact to quote, and from quote to order? How does that vary by service?
• How far does the forecast differ from orders secured in the same period? How many expected close dates have slipped?
• How many people, files and hours does it take to establish how the quarter is going?

The value of stalled deals alone cannot tell you whether demand is weak or follow-up is poor. We look at it alongside new enquiries, activities and outcomes. Missing data needs to be flagged too: an empty field does not mean zero.

The approach

1. Agree the stages with the people who sell. We start with actual deals and work through what moves them forward. Everyone needs to mean the same thing by “quote sent”; a sign of interest is not an acceptance. We agree what information each stage needs and what happens next. Before importing spreadsheets, we separate active opportunities from those needing review or closure, remove duplicates and assign owners. Importing everything unchecked would bring the confusion with it.

2. Connect quotes, orders and invoices. These are separate documents that should share confirmed data. We set up the flow from an accepted quote to an order and invoicing around the agreed terms, including any scheduled dates or work that must be completed first. Copies of revised quotes sent to the client and a reference to their acceptance stay with the deal. Accounts should be able to check the agreement without retracing the negotiation.

3. Give the next action a deadline. Each open deal needs a task, a date and an owner. For renewals, we agree when to act ahead of the contract end date and configure reminders accordingly. A reminder does not make the call: whoever looks after the client must record the outcome and decide what comes next. We also establish who can pick up the work during an absence.

4. Build a forecast you can check. We agree how to record deal values, expected close dates and probabilities, keeping estimates distinct from commitments. We retain each period's forecast and compare it with orders secured so that slippage remains visible. Where a revenue forecast is needed, we also bring in delivery timings and invoicing terms. We test the flow with the sales team and accounts before extending its use.

What changes

The aim is to open the pipeline and see where action is needed: quotes awaiting a reply, deals needing work from your team and renewals to prepare. A stalled deal should have an explanation you can read, rather than just a value and a date pushed further out.

In a sales meeting, you can separate confirmed orders from open opportunities and examine the assumptions behind the forecast. When a date slips, you can check whether the cause is a client decision, a quote needing revision or an outstanding task. The CRM makes those questions easier to address, provided the records are kept current.

Handovers have a firmer basis too. Documents, agreed terms and next actions remain available to whoever takes over. A conversation with the colleague may still be useful; it should not be the only way to find out what needs doing.

What people fear, and what we say

“It's too rigid for the way we work.” We start with your process and allow for exceptions, agreeing how to record them. That costs time: it takes days of work together before launch, followed by a review in the early months as overlooked cases emerge. It also requires decisions. If everyone gives the stages a different meaning, no configuration will produce a shared pipeline. You need to agree common rules with the people using it.

“The sales team won't use it.” They may not. Asking for data without giving something useful back leads to incomplete records or updates made only before a meeting. We tie deal updates to everyday work: preparing a quote, finding agreed terms and planning follow-up calls. There is still a real commitment. Changing habits takes weeks of support, plus someone inside the business checking how the system is being used every day at first. You have to make that time available; a training course cannot replace it.

“It will become a way to monitor people.” That risk is real. Recording activities, timings and outcomes also makes individual work visible. Before launch, we document what will be measured, who can see it and how it will be used. Those rules must hold in meetings too. If reporting a delay always brings a reprimand, people have an incentive to hide it. Part of your commitment as a manager is to spend time examining discrepancies and accept bad news without penalising the person reporting it. Use the pipeline to demand reassuring answers and you lose the basis for a credible forecast. Access permissions alone cannot fix that.

How we approach it today

At Gitogi, we start with how you handle a deal now: where the quote begins, who records acceptance, how it reaches accounts and who handles the renewal. That tells us what to configure in Odoo, which data to bring across and what commitment your team will need to make.

These pages explain the parts of that process:

• CRM and customer management
• Sales and order management
• How we work with Odoo

If preparing for a sales meeting means chasing files and colleagues first, let's talk. In an initial 30-minute conversation, with no obligation, we start with the handover that takes the most detective work and assess what needs clarifying before you change tools.