Quoting Without Excel: When the Spreadsheet Starts Costing You

Almost every low-voltage contractor starts quoting in a spreadsheet. It makes sense: it is already on the computer, it costs nothing, and you can make it look however you want. A tab for prices, a tab for the quote, a formula for the total, save it as a PDF, attach it to an email. Done.

For a while it works. Then the business grows a little, and the spreadsheet starts costing you money in ways that never show up as a line on it.

Here are the ways a quoting spreadsheet quietly breaks, so you can tell whether yours already has. Plenty of contractors are fine without software for a while; the point is to know which side of that line you are on.

The formula that stopped adding up

Spreadsheets fail silently. A row inserted above the total that the SUM range does not include. A price typed over a formula on one quote and never put back. A copied tab still pointing at last year's price list. None of these throw an error. The quote looks finished, the number looks reasonable, and it is wrong.

It may not happen often. The trouble is that you cannot tell when it has. You only find out when a customer questions a line, or when the job is done and the money does not add up.

Ask yourself: if a formula in your quoting sheet broke last month, how would you know?

Old prices that travel with every copy

The usual way to start a new quote in a spreadsheet is to copy the last one. That copies everything: the customer's details you then have to clear, the services you then have to delete, and the prices you charged last time.

If you raised your per-drop price in the spring, every quote copied from a winter quote still carries the winter price unless you remembered to change it. Multiply that by a year of quotes, and the raise you gave yourself only reached some of your customers.

Prices should live in one place, and every new quote should read them from there. In a spreadsheet that takes discipline. In good quoting software it is simply how it works.

Every quote is a little different, and so are the mistakes

A spreadsheet is flexible, which is its strength and its weakness. Each quote gets built slightly differently: a line added here, a discount there, a footage charge worked out by hand on one job and forgotten on the next.

Over time you are not running one price list, you are running hundreds of slightly different ones. Two customers with nearly the same job get noticeably different prices, and you cannot say why. Neither can whoever helps you quote when you are busy.

Whatever you quote in, what belongs on the quote does not change: a clear scope, payment terms and the fine print. Here is what to include in a low-voltage quote.

The customer still has to print, sign and scan

A PDF made from a spreadsheet is a picture of a quote. To accept it, the customer has to reply by email ("looks good, go ahead"), or print it, sign it and scan it back. Many do neither straight away, and the quote sits.

Every step you put between "the customer likes the price" and "the customer said yes" loses some jobs. An online signature on a quote they open on their phone removes most of those steps.

Following up is a separate job you do from memory

A spreadsheet does not know a quote was sent, opened, ignored or about to expire. So following up lives in your head, on sticky notes, or in a second spreadsheet you have to keep in step with the first.

You remember the big quotes. The ones that slip are the mid-size jobs from three weeks ago that would have said yes to a phone call.

The invoice gets typed again

When the job is won, the quote becomes an invoice, which in a spreadsheet usually means another tab, another copy, and the lines typed or pasted again. Any change agreed on site has to be carried over by hand. A deposit you took has to be remembered and subtracted.

Every retype is a chance for the invoice to disagree with the quote the customer signed, and a disagreement on an invoice is the slowest way to get paid.

You cannot see what a job leaves you

The spreadsheet tells you what to charge. It rarely tells you what you keep after parts, your tech's time, gas and the drive. To know that, you would need your costs in the same place as your prices, kept up to date, and most quoting spreadsheets never get that far.

So the question "was that job worth it?" gets answered at the end of the month, if at all, when it is too late to change the price on the next one. If you suspect jobs are leaking money, these are the five places it usually goes.

When the spreadsheet is still fine

To be fair to the spreadsheet: if you send a handful of quotes a month, every job is much the same, you never have anyone else quoting for you, and your customers are happy to reply "go ahead" by email, a well-built sheet can serve you for a long time. Keep the prices on their own tab, lock the cells with formulas, and check the totals by hand on anything large.

The signs it is time to move:

• You have found a wrong total on a quote that had already gone out.
• You are not sure every recent quote used your current prices.
• Someone else needs to quote when you are on a job.
• Quotes sit unsigned for days, and you follow up from memory.
• You retype quotes into invoices.
• You could not say, for last month's jobs, which ones made money.

If two or three of those sound familiar, the spreadsheet is no longer free.

Moving off it without losing a week

Switching does not have to mean stopping work. What usually takes the time is setting up your prices, and you already have them, in the spreadsheet:

1. Write down your real prices, per drop, per camera, per door, per rack size, per run, and what you add for hard jobs (drywall ceilings, no pathway, after hours).
2. Put them in once in the new tool, and check one old job against it: the new quote should land close to what you charged.
3. Send your next real quote from the new tool, while keeping the spreadsheet as a backup for a few weeks.
4. Bring your team in once you trust the numbers.

Most of that is an afternoon, not a week.

Where NexVolt fits

NexVolt is built to replace the quoting spreadsheet for low-voltage contractors. Your prices live in one place, set per drop, camera, door, rack size and run, with your job conditions; every quote reads them, so a price change reaches every new quote at once. Customers sign online, you invoice from the signed quote without retyping it, and they can pay by card. The Margin box shows what a job leaves you before you send it.

You can see a demo quote, check your prices with the free pricing calculator, or look at the plans. The free trial needs no card, so you can send your next real quote from it and keep the spreadsheet as a backup until you are sure.