Consider a CRM customer follow-up workflow when a colleague taking over a quote cannot identify the latest version, the customer’s response and the next action from the shared record. Test one open quote by asking a colleague to explain the next step using the record alone.
When a colleague is on leave, a shared Excel spreadsheet may show that a quotation was sent. Can the person taking over find the version the customer received, the latest changes discussed on WhatsApp, the agreed reply deadline and the person responsible? If they have to contact the original owner for these details, the spreadsheet does not contain enough information for the handover.
Excel can still meet the team’s needs if one person usually handles each enquiry from start to finish and everyone can find the latest information in a shared spreadsheet. To assess whether you need a customer relationship management (CRM) system, start by testing the handover of one quotation that still requires follow-up.
Test the handover of an open quotation
Choose a quotation that has already been sent and still requires follow-up. Ask a colleague who has not worked on it to take over using the shared records they can normally access. Before the original owner briefs them, see whether the colleague can answer these four questions in five minutes.
- What is the status of the quotation? Which version did the customer receive? Is there a more recent version that has yet to be sent?
- What did the customer most recently request? Which requirements are confirmed and which still need to be checked?
- What is the next action? When did the team agree to respond, and what needs to happen before then?
- Who is responsible for the follow-up? Who owns the next action, and can they open the quotation and access the related records?
Example: A customer requests an additional service
An office cleaning company emails its first quotation on Monday. On Tuesday, the customer asks on WhatsApp whether carpet cleaning can be added. The salesperson agrees to reply by noon on Thursday but is on leave on Wednesday. Excel records only “Quotation sent”. If the colleague taking over asks the customer to approve the first quotation, the customer’s question about the additional service and its cost goes unanswered.
A handover note could read as follows. We emailed the first quotation on Monday (link to the file). On Tuesday, the customer requested carpet cleaning on WhatsApp. The operations team still needs to confirm the cost. Yan will take over and respond by noon on Thursday. If the cost is confirmed, send the revised quotation. If confirmation is still pending, give the customer a progress update and say when they can expect a further response.
The colleague taking over can use the note to find the quotation the customer received, confirm the cost with the operations team and respond by the agreed deadline.
Use the test results to decide what to do next
If the test reveals a few gaps, add fields for the latest quotation sent, the most recent customer contact, the next action, the reply deadline and the person responsible. Have the responsible person update the same shared spreadsheet after each customer interaction, then repeat the test with a different quotation.
If the fields are already in place but the team still spends time searching several inboxes or WhatsApp conversations, comparing quotation versions or missing reply deadlines when colleagues are on leave, consider a CRM for managing customer information, follow-up records, assignments and reminders in one place. During a trial, ask the colleague taking over to repeat the test with the same quotation and confirm whether they can respond on time using the information in the CRM.
For details on keeping follow-up records in one place, assigning work and setting reminders, see the IntelliPro CRM page.
Quote handover questions
When is Excel still sufficient?
Keep using the spreadsheet if a colleague can find the current quote, its owner and the next contact date in one place without checking anyone’s private messages.
How can we test whether a CRM improves handovers?
Give two colleagues the same quote, one in the spreadsheet and one in the CRM. Ask each to identify the last response and the next commitment, then check both answers against the original correspondence.
Which details belong in a quote record?
Record the customer and contact, quote number and version, last response, next action, owner and follow-up date. Include a link to the quote itself.

