Skip to content Nicolas Schmid
← All posts

Quotes from site notes and photos: build the tool yourself

The site visit is done. Your notepad has measurements, a few keywords and a sketch. Your phone has twelve photos. And at some point in the evening you sit down at the desk and turn all of it into a quote. Finding line items, calculating quantities, copying prices from the list, writing the text. An hour disappears quickly. With three visits a week, that is half a working day.

This kind of work is a good fit for a small tool of your own. Not expensive industry software, but a program that does exactly one thing: turn your notes and photos into a draft in your own quote template. You review it, correct it and send it.

In this post I show step by step how such a tool comes together. You do not need to know how to program. The AI writes the code. You explain how your work is done and check the result.

How it works today

Take a painting company in Bern with eight employees. The example is made up, but typical. The owner does the site visits himself. Room by room he notes wall area, ceiling, the state of the surface and special requests. He photographs cracks, old wallpaper and awkward corners.

Two things in the office are already in good shape. First, a price list in Excel, with items such as "prime walls, per m²" or "cover and tape, flat rate per room". Second, a quote template in Word with logo, terms and footer.

The problem is everything in between. The notes are brief. You have to look at the photos again to remember. You search for items in the list by hand. And VAT gets added at the very end. Mistakes do not come from lack of knowledge but from tiredness.

What the tool does

The tool is deliberately simple:

  1. After the visit you drop the photos and a voice memo or a short text into a folder, one folder per job.
  2. You start the tool.
  3. It reads your notes and looks at the photos.
  4. It proposes line items from your price list, with quantity and unit price.
  5. It fills in your Word template and calculates the total including VAT (currently 8.1 % standard rate according to the Swiss Federal Tax Administration).
  6. Anything unclear appears as an "open question" at the top of the draft. For example: "Ceiling height in the living room is missing" or "Photo 7 may show mould. Add mould treatment?"

You end up with a Word file that looks like your usual quote. Most of it is already filled in, and whatever is missing is flagged.

How it is built, step by step

The tool is built with a coding agent. That is an AI program such as Claude Code that does not just write text but creates files on your computer, writes small programs and tries them out straight away. You talk to it in plain language. The instruction you give it is called a prompt.

Step 1: Describe the process precisely. Before any code exists, you write down how you produce a quote today. In the KI-Werkstatt (the AI workshop course) this is week one, "choose a process". A first prompt might look like this:

I run a painting business. After every site visit I have photos
and short notes. From those I write a quote in my Word template
(file quote-template.docx). Prices are in price-list.xlsx.
Ask me questions first until you understand how I work.
Do not write any code yet.

The agent then asks back: what are the columns in the price list called? Are there flat rates? How do you round areas? These questions are valuable. They make you write down knowledge that so far only lived in your head.

Step 2: Connect your own data. Now you show the agent real examples: the price list, the template, two old quotes with the matching notes. For practice, use jobs without personal data or replace names and addresses. This is week two of the Werkstatt, "AI on your data". This is where you find out whether your price list is clean enough. Often it is not quite, and tidying it up pays off anyway.

Step 3: Build the tool. In week three you ask the agent to write the actual tool. A script, meaning a small program you start with a double-click or a command. The agent writes it, runs it on your examples and shows you the draft. You say what is wrong: "The covering item is always missing." It adjusts. These rounds take minutes, not days.

Step 4: Secure and hand over. Week four is for tests and guardrails. A test is an automatic check: you give the tool a known input and compare the result with what has to come out. A guardrail is a fixed rule the tool cannot get around. More on that now.

What can go wrong, and the guardrails

AI is a very fast, very well-read intern. Great for drafts, but anything that has to be right, you check. For a quote, that mainly means prices and quantities.

Three guardrails are mandatory for this tool:

  • Prices only come from the price list. The AI may suggest items but must not invent a price. If it finds no matching item, it writes an open question instead of an amount. A test checks this: a note describing a made-up job must lead to an open question, not a price.
  • Every draft is reviewed by a person. The tool saves the quote marked "DRAFT" in the document. Only when you remove that mark is it final.
  • Nothing is sent automatically. The tool has no access to your e-mail account. Sending stays your click.

Typical errors you will find while reviewing: areas estimated from a photo instead of taken from the notes. An item listed twice because two photos show the same room. A special request mentioned only in passing in the voice memo. That is why the tool should state where each item comes from: "from notes, line 4" or "from photo 3". You check specifically instead of checking everything.

One more point on data protection. Customer names, addresses and photos of people's homes are personal data. Clarify where they are processed before real use. Which AI models are suitable depends on data protection and budget. Local models running on your own computer are possible too.

What it costs in time

Honestly: the tool is built in the KI-Werkstatt over four weeks, half a day each. Add some time in between to keep working with your own examples. After that it takes one or two weeks of daily use until you trust the draft enough to look only at the flagged parts.

What you gain day to day depends on how many quotes you write and how clean your price list is. I deliberately give no percentage here. Measure it yourself: time your next five quotes done by hand, then five with the tool.

If the quote later needs to go straight into your order software, several people need to use the tool, or a login is required, it becomes a software project. That is a case for implementation by Halvic Labs, at a fixed price after an analysis. I compare what the different paths cost in What does your own AI tool cost.

What you can do today

  • Create one folder for each of your next three site visits. Store photos and notes together, with the job number in the name. That is half the data foundation already.
  • Check your price list. Does every item have a clear name, a unit and a price? If not, now is the time to tidy up.
  • Write down how you produce a quote. Half a page is enough. Which steps, which rules of thumb, which typical mistakes.
  • Time it. How long does a quote really take today, from sitting down to sending?
  • Read the security checklist. Before a self-built tool goes into daily use, the questions in Vibe coding in an SME: the security checklist help.

Frequently asked questions

Do I need to know how to program?

No. The AI writes the code. If you work confidently with Excel and e-mail and can explain how a quote is made, you have what it takes. Knowing your own process well matters more than technology.

Can the AI really recognise areas and damage in photos?

Partly. Current models can recognise and describe cracks, wallpaper or damp patches in photos. Estimating measurements from photos is unreliable, though. That is why quantities come from your notes, and photos only provide hints and open questions.

What happens when my prices change?

You change the price list in Excel as before. The tool reads it fresh every time it starts. There is no second place where prices need to be maintained.

Does this work for other trades?

Yes. The pattern is the same for electricians, carpenters or gardeners: notes and photos in, draft in your own template out, prices only from your own list. Only the price list and the follow-up questions differ.

The next step

If you want to build a tool like this for your business, the KI-Werkstatt is the right setting: four weeks, half a day each, and at the end every participant has their own tool with tests and guardrails. If you would rather first work out with the whole team which process pays off most, start with the KI-Kickstart workshop. For a first assessment you can also book a free initial call.

Sources