Vlyt Learn

Why spreadsheet quoting breaks down (and what to use instead)

How Excel and Google Sheets quoting fails for WhatsApp-first SA sellers — and what a phone catalog-to-quote loop fixes.

· Targeting: quoting with spreadsheets problems

Spreadsheets are excellent calculators. They are poor field systems for South African sellers who close jobs on WhatsApp between site visits.

This article sits in the phone-first business pillar.

Direct answer

If your quote price lives in a sheet but the customer negotiation lives in chat, you will eventually send a total that neither file nor chat can fully explain. Move the source of truth for products and quotes onto a phone-friendly catalog.

Failure modes we see repeatedly

  1. Version fog — Quote_Jan, Quote_Jan_fixed, Quote_Jan_use_this.
  2. Chat drift — discounted in WhatsApp, sheet never updated.
  3. VAT maths by hand — wrong inclusive total under time pressure.
  4. No stock link — sheet prices items that are already gone.
  5. Single-laptop dependency — helper cannot quote while you are on site.

What “instead” should mean

Not “another spreadsheet template.” A replacement must:

Compare concrete tools in best quoting apps for SA small business 2026.

A calm migration path

  1. List the 20 lines you quote most often.
  2. Enter them into a catalog with ZAR prices.
  3. Rebuild one live quote from that catalog.
  4. Stop pasting totals into chat as free text.
  5. Keep the old sheet read-only for a month.

Vlyt is built exactly for that migration: catalog to quote on Android, free while we grow — without pretending to be full desktop accounting.

FAQ

Are spreadsheets bad for quoting?

They are fine for one person at a desk. They get brittle when you quote from a bakkie, revise prices in WhatsApp, and need stock or VAT clarity on the fly.

What usually breaks first?

Version control. File names like Quote_FINAL_v7 and chat prices that never make it back into the sheet.

Can I keep Sheets for reports?

Yes. Many operators still export monthly numbers. The day-to-day quote should not depend on opening a laptop.

When should I switch tools?

When you have sent the wrong price twice, or when stock and quotes disagree, or when only you understand the spreadsheet formulas.

What should replace it?

A catalog that feeds quotes on your phone, with clear VAT and shareable output. Compare options in our 2026 quoting apps guide.

Will I lose my history?

Migrate active products and open quotes first. Archive old sheets as reference; do not rebuild every historical tab on day one.

Run quotes from your pocket

Vlyt is free while we grow — catalog, stock, VAT-aware quotes and cashflow on Android.

Get it on Google Play