Business SystemIs this job really making money, or losing it?
BOQ estimating, quotations, actual costs, installments and Gantt plan
For: Builders, extension and renovation contractors · Tradespeople running several sites at once · Small design-and-build firms
฿1,290
ExcelGoogle Sheets
Q&A with real numbers from the sample file
How much work is on hand?Sample data: 8 projects worth 3,902,834 baht, 5 under construction
How much has been spent, and the expected profit?Actual cost 1,600,250 baht, expected profit 591,673 baht, and 1 project flagged as over plan
How much installment money has come in?Received 2,221,084 baht, overdue installments 441,206 baht
FAQ about this system
Does it work in Excel and Google Sheets?Both. Open it in Excel 2016 or later / Microsoft 365, or upload it to Google Drive and open it with Google Sheets
Do I need to be good at Excel?No. Fill in the white cells only; dark cells are formulas, and a 5-step guide is inside the file
Can I change the business name and address on the forms?Yes. Edit them once in Settings and every form updates
How do I clear the sample data?Delete only the white cells on the data tabs; formulas and forms stay in place
How much data can it hold?Up to 300 projects and 3,000 BOQ lines, tested with full tables and no formula errors
Can I print or save the forms as PDF?Yes. Forms are set up for A4; pick the document number and print or save as PDF
What happens if I type the wrong kind of value?Number and date cells are validated and show a message, and formulas are guarded against error values
How do I build a BOQ?Pick items from the price list and enter quantities; material and labour rates are pulled in and your markup added
Do quotes handle VAT and withholding tax?Yes. Switch VAT and 3% withholding on or off in Settings; both show on quotes and invoices
How many installments can a job have?As many as you need. Enter a percentage per installment and the amount and status are tracked
Does it warn about late jobs?Yes. Projects shows "past due" and "over plan" when spending runs ahead of progress