Home · Money & bills · Build a quote calculator sheet so every price adds up the same
Build a quote calculator sheet so every price adds up the same
You price each job from scratch and forget the waste, the travel or the VAT. Get a sheet with dropdowns that adds it all up the same way every time.
The prompt · ChatGPT
Help me build a quote calculator in Google Sheets. My trade: [what you do] How I price: [e.g. day rate, per square metre, per item] My rates: [give them, or leave blanks] Materials and markup: [e.g. cost plus 15%] Extras I sometimes forget: [e.g. waste removal, parking, travel over 10 miles] VAT: [registered or not] Ask me up to 3 short questions first if anything important is missing. Wait for my answers. Then: 1. A sheet layout: job type (dropdown), quantity, labour, materials, each extra (dropdown yes/no), subtotal, VAT if it applies, total. 2. The formulas for each total, in Google Sheets. 3. The dropdown options to set up for job types and extras. 4. A worked test job using made-up quantities so I can check it adds up. 5. A checklist of extras to ask about on every site visit. Leave my rates blank if I haven't given them, and check VAT rules on GOV.UK rather than stating them. Only use what I've told you, leave blanks for anything I haven't given, and don't invent facts or figures. UK English. Stay in this ChatGPT chat. Do not turn on apps or connectors, and do not use memory from another chat.
A short example
Fill the blanks, then paste. what you do: a short note you already have. e.g. day rate, per square metre, per item: a short note you already have. Leave the rest of the prompt as written.
This does not give tax advice. The books stay in the accounting system.
Loading the outline…