📣 Top up ฿1,000+ get 5% bonus · ฿3,000+ get 10% bonus

Excel / Google Sheets Templates

Ready-made templates with formulas for Excel and Google Sheets

Contractor BOQ & Construction Budget System for Excel / Google Sheets (Business System)
เทมเพลต Excel / Google Sheets

Contractor BOQ & Construction Budget System for Excel / Google Sheets (Business System)

  • A 13-tab .xlsx file with a 21-item price list and 8 sample projects
  • 3 printable forms: quotation, installment invoice, receipt/tax invoice
  • Budget vs actual by work category
  • Gantt plan by project and month
฿1,290
 
Business System

Is 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

30-second demo

Problems this file solves

1Slow BOQs and quotes lose jobs
2Costs overrun unnoticed until the job ends
3Missed installments leave money uncollected

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

Settings you can switch yourself

ชื่อบริษัท
ที่อยู่
เลขผู้เสียภาษี
โทรศัพท์
กำไรบวกเพิ่ม (Markup)
คิด VAT
อัตรา VAT
ลูกค้าหัก ณ ที่จ่าย
อัตราหัก ณ ที่จ่าย
ยืนราคา (วัน)
ผู้มีอำนาจลงนาม

What is inside (13 tabs)

How to use
1. How to use
Settings
2. Settings
Dashboard
3. Dashboard
Price list
4. Price list
Projects
5. Projects
BOQ
6. BOQ
Actual costs
7. Actual costs
Installments
8. Installments
Budget vs actual
9. Budget vs actual
Gantt plan
10. Gantt plan
Quotation
11. Quotation
Installment invoice
12. Installment invoice
Receipt
13. Receipt

What you get

  • A 13-tab .xlsx file with a 21-item price list and 8 sample projects
  • 3 printable forms: quotation, installment invoice, receipt/tax invoice
  • Budget vs actual by work category
  • Gantt plan by project and month
  • Works in Microsoft Excel and Google Sheets

Get the file in 3 steps

  1. Order and pay by PromptPay or credit
  2. Download the .xlsx file from My Account
  3. Open it in Excel, or upload it to Google Drive and open with Google Sheets, add your business name in Settings and start

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

สงวนลิขสิทธิ์ © LoongTeeAi.Com

Related products

ระบบบิลหอพัก ผังห้อง มิเตอร์น้ำไฟระบบบิลหอพัก ผังห้อง มิเตอร์น้ำไฟ฿290ตารางเวรพยาบาลรายเดือนตารางเวรพยาบาลรายเดือน฿290ระบบบัญชี SME ภาษีซื้อขาย หัก ณ ที่จ่าย Excel / Google Sheets (Business System Pro)ระบบบัญชี SME ภาษีซื้อขาย หัก ณ ที่จ่าย Excel / Google Sheets (Business System Pro)฿1,990ใบงานซ่อมรถและอะไหล่อู่ซ่อมรถใบงานซ่อมรถและอะไหล่อู่ซ่อมรถ฿290ระบบหอพัก อพาร์ตเมนต์ จดมิเตอร์น้ำไฟ Excel / Google Sheets (Business System)ระบบหอพัก อพาร์ตเมนต์ จดมิเตอร์น้ำไฟ Excel / Google Sheets (Business System)฿1,290ประวัติสัตว์เลี้ยงและตารางวัคซีนคลินิกสัตว์ประวัติสัตว์เลี้ยงและตารางวัคซีนคลินิกสัตว์฿290

Product reviews

No reviews yet