Sales Operations · 2026 Edition

Quotation Management: From Excel to CRM

Why Indian SMBs are retiring their quotation spreadsheets — and how a modern CRM generates a branded PDF quote with logo, T&Cs, bank details, product images, GST, and discounts in under 60 seconds.

By Clientfisher Team April 2026 10 min read Quotation
Schedule a Free Demo Explore Features

Almost every Indian SMB we meet has the same quotation story. Someone in the sales team maintains a master Excel — Final_Quote_Format_v14.xlsx — copies it for each new customer, manually changes the logo, the address, the GST number, the price, the T&Cs, fixes a formula or two, exports to PDF, and sends it on WhatsApp. It works. Until it does not.

Excel-based quotations are fast on day one, but they quietly erode sales velocity as the team grows. Versions get confused, numbers drift across team members, logos and fonts change with every laptop, and nothing is ever linked back to the deal. By the time a customer asks, "which quote are we going by?", finding the right file takes longer than writing a fresh one.

📌 The Short Answer

Move quotations out of Excel. A CRM-based quotation engine stores every quote against the customer and deal, applies your logo, T&Cs, bank details, and tax rules automatically, and turns a line-item list into a branded PDF in under a minute. Sales executives send more quotes. Finance closes the month faster. And margin leaks show up in a report instead of a fire drill.

<60 sec
To generate a branded PDF quote from the CRM
2–3×
More quotes sent per executive after migration
0
Version conflicts — every revision is tracked on the deal
100%
Brand-consistent output — logo, fonts, T&Cs, bank details

Why Excel Quotations Eventually Break

Excel starts as the "lightweight" option, but every Indian sales team eventually runs into the same five problems. None of them are fatal on their own — together, they cost you deals and hours.

The Version Chaos Problem

Each sales executive keeps a local copy. Somebody changes a formula. Somebody else updates the logo. A new joiner uses a six-month-old template. Three weeks later, nobody knows which template is the real one — and customer-facing quotes start going out with inconsistent branding, tax rates, or terms.

The Pricing Drift Problem

Product prices are revised quarterly, but the Excel templates are not. Executives quote from memory, from an older version, or from yesterday's quote copy-pasted. The result: the same SKU goes to two customers at two different prices in the same week — and margin reporting becomes impossible.

The Traceability Problem

Quotes live on laptops, email drafts, and WhatsApp forwards. When a customer calls asking about "the quote your executive sent last week", nobody can find it quickly. And when the deal closes — or does not — there is no structured record of which revision the customer accepted.

The Manager Visibility Problem

Sales managers cannot see, in one view, how many quotations went out last week, which are still open, which were revised, and what the total open pipeline value is. They have to ask, chase, and consolidate. By the time the report is ready, the week is already over.

The Compliance Problem

GST rules change. HSN/SAC codes get updated. A customer's state moves between intra-state and inter-state. Updating every Excel template individually is a chore that gets skipped — and the first incorrect GST number on a customer's quote lands the accounts team in trouble.

⚠ A Telling Sign

If your sales executives spend more than 20 minutes writing a quote, or if your manager can't pull today's open-quote list without messaging the team, Excel is already costing you more than a CRM would.

Excel vs CRM — A Side-by-Side Reality Check

Excel Workflow

Manual, Local, Fragile

  • Master template copied & renamed per customer
  • Logo and letterhead re-pasted each time
  • T&Cs and bank details typed or copied from last quote
  • GST/CGST/SGST/IGST calculated manually
  • Discounts entered without approval rules
  • Version tracking by file name (_v1, _v2, _final, _final_final)
  • No link between quote and the lead or deal
  • No central list for the manager
  • PDF done via "Save As → PDF" — formatting breaks often
CRM-Based Workflow

Structured, Cloud, Automated

  • Logo, letterhead, fonts set once — auto-applied everywhere
  • T&Cs and bank details saved as templates
  • Products picked from a priced catalogue
  • GST, CGST, SGST, IGST applied by state automatically
  • Line-item & order-level discounts
  • Every revision linked to the deal, with timestamp
  • Central "All Quotations" list with filters and status
  • Product images and specs attached automatically
  • Branded PDF ready in under 60 seconds — from web or mobile

See a full quotation built in under a minute

Free demo · Setup in 1 day · Your logo, your catalogue, your T&Cs
Schedule Demo →

9 Capabilities Your CRM's Quotation Engine Must Have

Use this as your buyer's checklist. Without these capabilities, migrating from Excel only moves the problem to a different tool.

📋
1. Central Quotation Listing

Every quotation in one list — with filters by status (Draft, Sent, Revised, Accepted, Lost), customer, executive, date range, and value. Search across quote numbers, customer names, or product SKUs instantly.

🆕
2. New Quote in a Few Clicks

Pick the customer, add products from the catalogue, apply discount, hit save. No typing customer address, GST number, or product description — it's all prefilled from master data.

🏢
3. Pre-defined Logos & Letterhead

Upload your logo once, configure your letterhead, signature block, and colour scheme — every quotation comes out on-brand, regardless of who generated it.

📜
4. Saved Terms & Conditions

Maintain one or multiple T&C templates — standard, government supply, export, AMC. The right T&Cs attach automatically based on the customer segment or product type.

🏦
5. Bank Details Auto-Included

Your current-account details, IFSC, and UPI are saved once and appended to every quote. Change them once, they update everywhere. Multiple banks? Pick one per business unit.

🖼️
6. Product Images & Specs

Attach product photos and technical specifications to each catalogue item. When added to a quote, images and specs are embedded in the PDF automatically — crucial for catalogue-heavy businesses.

🧮
7. Tax Rules: GST / CGST / SGST / IGST

HSN/SAC codes and tax rates set at the product level. The CRM picks CGST+SGST for intra-state, IGST for inter-state automatically based on the customer's billing state. Reverse charge and exempt rules supported.

💰
8. Flexible Discounting

Line-item discount (percentage or flat), order-level discount, volume slab pricing, and approval thresholds. Discounts beyond a set limit route to the manager before the quote can be issued.

9. PDF Ready in Under 60 Seconds

One-click PDF export with logo, letterhead, product images, pricing breakup, tax summary, discounts, T&Cs, and bank details — all laid out cleanly. Download, email, or send on WhatsApp without opening another tool.

Anatomy of a Modern Quotation

Here is what a CRM-generated quotation looks like under the hood — every element populated automatically from master data, not typed in fresh each time.

Header
Company logo, letterhead, sender branch address, GSTIN
Customer Block
Bill-to and ship-to addresses, GSTIN, contact person — pulled from customer master
Quote Meta
Auto-generated quote number, date, validity, revision number, sales executive
Products Table
SKU, description, HSN/SAC, optional image, qty, unit, rate, discount, taxable value
Tax Summary
CGST & SGST (intra-state) or IGST (inter-state), amount in words
Charges
Freight, installation, AMC, or any custom charge — configurable per quote
Totals
Taxable value, total tax, grand total, amount in words
Terms & Conditions
Selected T&C template — payment terms, delivery terms, warranty, jurisdiction
Bank Details
Account name, number, IFSC, branch, UPI — for direct payments
Signature Block
Authorised signatory name, designation, digital signature (if enabled)

Tax & Discount Options — What "Good" Looks Like

Taxes and discounts are where most Excel quotes go wrong. Here is what a well-built CRM handles without any manual maths.

Tax Handling

Configure HSN/SAC codes and GST rates at the product level. The CRM determines the tax type based on the company state vs customer state — intra-state means CGST + SGST (half-and-half of the GST rate), inter-state means IGST (full GST rate). Exempt items, zero-rated exports, and reverse-charge scenarios are supported as flags on the product or customer.

Discount Types

Line-item discounts let you drop a single SKU's price without touching others. Order-level discounts apply to the subtotal after taxes or before, depending on your preference. Volume-slab pricing auto-applies different rates based on quantity. Free-text discount reason codes keep your margin reporting clean.

Approval Workflow

Ensure that every Quotation is reviewed and approved before it finally reaches the customer. This one rule eliminates the "my executive gave too much discount or not correct prices" conversation forever.

Currency & Multi-Branch

Support for multiple currencies (for export customers), multiple branches with separate GSTINs, and per-branch tax registrations. The quotation format respects the branch issuing it — so a Pune-branch quote looks different from a Bangalore-branch quote, without anyone switching templates.

Quotation Tools Compared

Here's how Excel, Word templates, and a field-ready CRM stack up on the capabilities that matter for Indian SMBs.

Capability Excel Template Word Template Clientfisher CRM
Central quotation listing with filters
New quote in under 2 minutes Manual Manual
Pre-defined logo & letterhead Copy-paste Copy-paste
Saved T&C templates Manual select
Bank details auto-populated Typed Typed
Product images in PDF Manual insert
Auto GST / CGST / SGST / IGST
Line-item & order-level discount Formula-based
Approval workflow
Quote revision history File name File name
Branded PDF in < 60 seconds
Mobile quote from the field

Your 4-Week Migration Path from Excel to CRM

Migrating quotations does not require a three-month project. Done right, a typical Indian SMB is live on CRM-based quotations in four weeks or less. Here's the sequence we have refined over hundreds of rollouts since 2012.

1

Week 1 — Master Data Setup

Upload your company logo, letterhead, signature block, GSTIN(s), and bank details. Import the product catalogue with SKU, description, HSN/SAC, GST rate, unit, standard price, and product image. Most SMBs finish this in 2–3 days using a simple Excel import.

2

Week 2 — Templates & Rules

Configure your quote number format, validity defaults, one or more T&C templates, discount approval thresholds, and per-branch tax settings if you operate from multiple states. Sign off with your accounts team so GST handling is correct.

3

Week 3 — Pilot with Two Executives

Start with two sales executives — ideally one power user and one sceptic. Let them issue real quotes to real customers for a week. Collect feedback on anything that still feels slower than Excel, and fix before the wider rollout.

4

Week 4 — Full Rollout & Retire Excel

Roll out to the rest of the team with a 30-minute training session. Set a date after which Excel quotes will not be accepted by accounts. Review the first week's output — quotes sent, average time, approval loop performance — and iterate.

💡 Migration Tip

Do not try to migrate historical quotations. Start fresh from the go-live date. Historical quotes can be kept as PDF attachments on the customer record for reference — no need to rebuild them in the CRM.

What Clientfisher's Quotation Engine Includes

Clientfisher was built for Indian SMBs from day one, and quotation management has been a core module since 2012. Here is what your team gets on day one — no premium add-ons, no bolted-on third-party plugin.

📋

All Quotations List

Central list with filters by status, customer, executive, date, and value. Export to Excel any time.

<1 Minute Quote

Pick customer, add products, hit generate — a branded PDF is ready. From desktop or the mobile app.

🏢

Pre-defined Branding

Logo, letterhead, signature, colours configured once — every quote comes out on-brand, every time.

📜

Multiple T&C Templates

Standard, government, export, AMC — the right T&Cs attach automatically by customer segment or product.

🏦

Bank Details Built-In

Saved once and appended to every quote. Support for multiple bank accounts per business unit.

🖼️

Product Images & Specs

Attach photos and technical spec sheets at the catalogue level. Automatically included in the PDF.

🧮

Smart GST Engine

Auto-calculates CGST+SGST or IGST based on customer state. HSN/SAC codes flow from product master.

💰

Discount & Approval Rules

Line-item, order-level, and slab-based discounts with configurable approval thresholds.

🔄

Revision History

Every revision saved with timestamp and user. See exactly which version the customer accepted.

📱

Mobile Quotation

Generate and send a branded quote from the phone — before leaving the customer's office.

💬

WhatsApp & Email Send

Send the PDF directly from Clientfisher over email or WhatsApp — the send is logged on the deal.

📊

Open-Quote Reports

Daily and weekly reports of open quotations, by executive and by value — straight into the manager's inbox.

What Indian Sales Teams Say

Before Clientfisher we had four people maintaining their own version of our quote format. Every single quote needed an accounts check for GST. Now the template is one, the tax engine is one, and the accounts team doesn't even look at the PDF anymore — they only check totals.

Karthik S.
Director, Industrial Supplies · Coimbatore

Our quotation cycle used to be: executive sends draft, manager reviews, accounts checks GST, someone signs — then it goes to the customer. Took two days on average. Now the executive sends the PDF from the customer's office. Closures went up 30% in the first quarter.

Priya R.
Sales Head, Engineering Equipment · Pune

The product image thing sounds small but it's huge for us. We sell LED panels — customers want to see what they're buying. Earlier our Word quote had a small cropped photo that looked unprofessional. Now the PDF has clear images, specs, and a proper table. Inbound enquiry-to-order is up measurably.

Abhinav T.
Proprietor, Lighting Trading · Delhi

Evaluation Checklist Before You Pick a Tool

If you are evaluating quotation software, run through this list with the vendor. Ideally ask them to build a real quote for your business during the demo:

Want a branded quote built live from your actual catalogue?

Free 30-min demo · We'll configure your logo & T&Cs on the call
Schedule Demo →

Frequently Asked Questions

Why move sales quotations from Excel to a CRM?
Excel quotations are fast to start but break down at scale — versions get confused, numbers drift, branding is inconsistent, and nothing is tied to the lead or deal. A CRM stores every quote against the customer, standardises the template, applies the right tax and discount rules automatically, and generates a branded PDF in under a minute.
How long does it take to generate a quotation in a CRM?
Under 60 seconds. You pick the customer, add products from the catalogue, and the CRM auto-applies logo, letterhead, bank details, T&Cs, GST, and discounts. The PDF is ready for download or send in one click.
Can a CRM handle GST, CGST, SGST, and IGST on quotations?
Yes. Clientfisher applies CGST and SGST for intra-state sales and IGST for inter-state sales automatically based on the customer's state. HSN/SAC codes and tax rates are set at the product level and flow through to every quotation.
Can I include product images in the quote?
Yes. Attach product photos and spec sheets at the catalogue level. When a product is added to a quote, the image and specs are embedded in the PDF automatically — especially useful for industrial, electronics, furniture, and any catalogue-heavy business.
Does the CRM support multiple discount types?
Yes. Line-item discount, order-level discount, volume-slab pricing, and approval thresholds. Any discount beyond the configured limit routes to the manager for approval before the quote can be issued.
Are terms and conditions and bank details saved once or entered every time?
Saved once. Configure your letterhead, logo, T&Cs, payment terms, and bank details during setup — every quote uses the latest approved version. Maintain multiple T&C templates and pick the right one per product category or customer segment.
Is the quotation module included in the base Clientfisher CRM price?
Yes. Quotation management has been a core module in Clientfisher since 2012 — not a paid add-on, not a third-party plugin. You get the full engine, including mobile quotation, with every Clientfisher subscription.

Retire Your Quote Excel This Month

Book a free 30-minute demo. We will configure your logo, letterhead, T&Cs, and a few of your actual products on the call — and generate a real PDF quote for a real customer, live.

Schedule a Free Demo Explore All Features

Related Articles