Guide for quotes and orders
Quote and order tracking in Excel: when it helps and when it starts causing mistakes
Excel is often a good start. Problems appear when the sheet no longer shows who owns the next step, what is late, or when the customer should hear back.
01
Signs the spreadsheet is no longer enough
You do not need to replace Excel immediately. First check whether the spreadsheet still helps the team answer customers, or whether it has become a place where status is hidden.
- 01
A quote exists in Excel, but nobody knows whether the customer is waiting or the team is waiting.
- 02
The same customer details are copied from chat to spreadsheet, then to email, then to invoice.
- 03
Only one person understands the colors, abbreviations, or comments in the sheet.
- 04
The owner asks for status because the sheet does not show open, overdue, and completed work.
- 05
There is no clear next-contact date, so follow-up depends on memory.
02
Separate calculation from work tracking
Excel can calculate price, quantities, and margin. Tracking work needs different information: status, owner, and next contact. When those jobs are mixed, the sheet becomes harder to use every day.
- 01
Keep Excel where it calculates
Prices, quantities, discounts, and margins can stay in the sheet if the team understands them.
- 02
Add one status
Use a few states everyone understands: new, quote sent, waiting for customer, needs reply, done.
- 03
Add an owner
Every open row needs one person who owns the next step.
- 04
Add next contact
Without a date or agreed moment, follow-up quickly depends on memory.
03
The first version does not have to remove Excel
Often the smallest useful system is a working record around the spreadsheet: customer, status, owner, next contact, and a link to the quote.
One owner for each open item.
One status list that the whole team uses the same way.
One date or agreement for the next customer contact.
A link to the quote, email, or document.
A view of open, overdue, and completed work.
A short note field, not a full history.
04
How Excel stays useful
Today
The sheet has many columns and comments.
Working record
A working view shows only status, owner, and next contact.
Gain
01The team sees what needs action today.
Today
Only one person understands the colors.
Working record
Statuses come from a short shared list.
Gain
02Less explanation and fewer wrong assumptions.
Today
Quotes are forgotten after they are sent.
Working record
Every sent quote has a follow-up date.
Gain
03Open revenue is not lost to memory.
Next guide
Choose one small process for v1.
When you know what Excel should still do, it becomes easier to choose one small process for the first digital version instead of a large ERP project.