Spreadsheet vs CRM for building customer quotes

You have a customer waiting on a price. So you open last month's quote spreadsheet, copy it, and start changing numbers. You fix the customer name, then the date, then a few line items. Then you export it to PDF, attach it to an email, and hope nothing broke on the way.

Most small teams quote this way for years. It works, right up until it doesn't. A formula gets overwritten. An old price sneaks into a new quote. Someone asks what you sent two weeks ago, and nobody can say for sure.

This post is about when a spreadsheet is enough, when it is not, and what changed in Coeffection this week for people who build quotes every day.

Is a spreadsheet good enough for quotes?

Sometimes, yes. If you send a handful of quotes a month, sell a small set of items, and only one person touches the file, a spreadsheet is fine. It is cheap, you already know how to use it, and you can bend it to fit almost anything.

The trouble starts when any of these show up:

• More than one person builds quotes.
• Your prices change and old numbers linger in old files.
• Your items have options, like sizes, materials or finishes.
• You need to find out later what was sent, and when.
• You retype the same customer details into the quote, the email and the invoice.

If two or three of those sound familiar, the spreadsheet is costing you time. You just may not be counting it.

What should a good quote include?

Whatever tool you use, a customer should be able to read your quote in under a minute. Here is a simple checklist.

• A clear date. Quotes go stale. Put the date on the page so nobody argues about it later.
• One line per item, with its own description. If two items differ by size or material, say so on that line, not in a footnote.
• Totals that add up the same way every time. Hand typed totals are where most quote errors live.
• Plain wording. Skip internal shorthand. The customer is not in your head.
• A short note on what happens next. Tell them how to say yes.

Then keep one habit. Send quotes from one place, and keep a copy of exactly what you sent. That alone solves half of the "which version was it" arguments.

How do I keep quote line items tidy?

Long item names are the usual culprit. A quote with ten lines and wide, wrapping text can sprawl across the screen and the page.

A few things help in any tool:

• Keep the item name short and put detail in a separate spec or note.
• Keep the header row visible while you scroll, so you always know which column is which.
• Make columns easy to resize, so you can see what matters while you work.

Those are small things. But when you build quotes all day, small things add up.

What does a CRM do for quoting that a spreadsheet can't?

A CRM keeps the quote attached to the customer and the deal. You do not copy the name, the address or the contact into a new file. The quote is part of the record, so the history stays with it.

It also means the email you send, the PDF the customer sees and the screen you work in all come from the same data. Nothing gets retyped, so nothing drifts.

That is the idea behind how Coeffection handles quotes. Here is what got better this week.

How does Coeffection handle quotes now?

This week's updates focused on making the quote screen faster to work in and the documents clearer to read.

A tidier Item column. The Item cell on a quote is now more compact and wraps text more narrowly, so long names no longer push everything sideways. You can drag to resize the column, and dragging it only changes the Item column, not the others around it.

A header that stays put. The line item header now stays visible as you scroll, so you do not lose track of your columns on a long quote. When a quote table is wider than your screen, it scrolls sideways instead of squashing.

Specs that match each line. Each line item now shows its own spec label, so two lines that differ by option are easy to tell apart. Material names also appear on your documents, so the customer sees what they are actually getting.

A Today's Date field. You can drop the current date into your quote content without typing it by hand.

Custom items that behave. A custom item that sits alone in its family now shows that family's switches. Custom items can also carry add on costs, so special requests do not need to live in a side spreadsheet.

Quote fields as list columns. You can show quote fields as columns in your lists, which makes it easier to scan many quotes at once.

Editable email templates. The email you send with a quote now uses templates you can edit. Write your wording once and reuse it. The PDF attachment is also unticked by default, so you choose when to attach it instead of undoing it every time.

PDF text that looks right. Text sizes in the PDF now match what you see on screen, so the document looks like the quote you built.

Should I switch from a spreadsheet?

Here is a plain way to decide. Count how many quotes you send in a month and how many minutes each one takes. Then count how many times a mistake has cost you a conversation, a discount or a customer.

If the number is small, keep your spreadsheet and clean it up. Use the checklist above.

If the number is climbing, or more than one person is quoting, move the work into a tool where the customer, the quote and the email live together.

Also new this week

• Customer forms. You can build forms for your customers to fill in, and several builder fixes landed this week.
• Record reports. Reports on a record page got new tiles, chart displays, tighter layouts and cleaner headers and formats. A Record Status column also shows whether a record is active or converted.
• Insights on record pages. Insights widgets can now sit on your record pages.
• Drafts for new records. Work on a new record is saved as a draft, so a closed tab does not lose it.
• AI model pickers. The lists of AI models you can choose from now stay current, and the picker was cleaned up.
• Lead Inbox. Reject and snooze no longer hang, and there is a new New Lead button.
• iPhone app. Sign in with Google, Microsoft or Apple works more smoothly and returns you to the app. The mobile Home screen has a dashboard switcher. Contract actions now fit on a phone screen.
• Mobile record pages. Comments, teams and the All view now work on mobile.
• Easier to use. Filter chips that read All now tick every box, text inputs show their values, and pages load faster on phones. A skip link and better contrast help with accessibility.
• Security hardening. We tightened security in several places.
• CRM School. A new learning area is live at /crm-school.