Contractor OS LiteGoogle Sheets template · by samapp

Know each project's margin before it's too late.

A Google Sheets template for contractors: BOQ, cost ceilings, schedule, S-curve and progress billing in one file. No install, and it works with a regular Gmail account.

The template is in Indonesian. A free bonus for webinar attendees.

The Dashboard tab of Contractor OS Lite with total contract value, HPP budget, actual cost, margin, budget use, milestone status and the project list.
The problem

Profit on paper, a loss at the end of the project.

The estimate is in one file, receipts are in a WhatsApp group, the schedule is in your head. The gap only shows after the project is done, when it is too late to fix.

Margin slips away quietly

Costs arrive a little at a time. The template compares actual cost with the HPP budget of each project, so the margin is visible from week one.

Cost ceilings broken without a sign

Every BOQ item has a ceiling. When costs pass it, the status turns red, and spending without a BOQ item is marked Di luar BOQ (outside the BOQ).

Schedule and billing scattered

Milestones, progress, down payment, progress invoices and retention are in one place. The weekly Gantt and the S-curve show what is late.

What's inside

One file, everything connected.

Enter the BOQ once. Costs, schedule, invoices and profit and loss follow automatically.

Plan

BOQ with HPP, markup and selling price. A weighted milestone schedule, a weekly Gantt and the S-curve.

Money

Cost per BOQ item, invoices for the down payment, progress payments and retention with VAT, a print-ready invoice and profit and loss per project.

People and purchasing

Clients, a sales pipeline with follow-ups, a list of vendors and workers, and purchase orders that reduce the remaining ceiling.

Control

A dashboard of all projects with SPI and warnings, and a risk register with scores and levels.

Screens

This is what it looks like.

All images come from the demo file with sample data.

A dashboard summarising contract value, HPP budget, actual cost, margin and a list of four projects.

Dashboard

Contract value, actual cost, margin and schedule status of every project on one screen.

The BOQ tab with work items, total HPP, selling price, actual spend, remaining ceiling and ceiling status.

BOQ and ceilings

Each item has HPP, markup, selling price and a ceiling. Items that pass their ceiling are flagged right away.

A weekly Gantt with milestone bars coloured by status.

Weekly Gantt

Bars coloured by milestone status, with the current week highlighted. Works on a regular Google account.

An S-curve chart of planned progress, actual progress and actual cost against the budget.

S-curve

Pick a project, then compare planned physical progress with actual progress and cost use.

An A4 invoice with the client name, payment stage details, VAT, total and bank account.

Print invoice

Pick an invoice number and an A4 sheet fills in: client, payment stage, DPP, VAT, total and bank account.

A profit and loss table per project with cost by category, planned margin and cash profit.

Profit and loss per project

Contract, billing, cost by category, margin and cash profit for each project side by side.

How it works

Three steps, no install.

  1. 1

    Join the webinar

    Register for the webinar through the registration page and attend.

  2. 2

    Get the link

    After the webinar you receive a link to make your own copy of the template.

  3. 3

    Make a copy

    Open the link, choose Make a copy, and the file is yours in Google Drive. Follow the 12 steps on the Mulai tab.

Webinar bonus

A free bonus when you join the webinar.

Webinar bonus

Attendees get the complete template from the demo, in their own Google Drive. It is not sold on its own.

  • Every tab: BOQ, costs, schedule, Gantt, S-curve, invoices, profit and loss, pipeline, POs, vendors and risks
  • Several projects at once in one file
  • Indonesian, rupiah, and an adjustable VAT rate
  • A 12-step guide on the Mulai tab

One copy per company. It may not be resold and the link may not be shared.

Lite or Contractor OS

Start with a sheet, move up when the team grows.

Lite suits small contractors who want to get organised today. Contractor OS is for teams that need many users and control.

LiteContractor OS
UsersShared through Google Sheets, no rolesSeven roles with permissions
ApprovalsNoneApproval of POs, costs and data changes
Site photos and reportsNoneYes, from a phone
SetupNone, just make a copyRuns on your server
Activity historyGoogle Sheets version historyA log of every data change
FAQ

Questions before you buy.

Does it work with a regular Gmail account?

Yes. Every tab, including the weekly Gantt, runs on a regular Google account. Google Sheets' built-in Timeline view only exists on paid Workspace accounts, so the template does not depend on it.

Can I open it in Excel?

The template is built for Google Sheets and uses functions Excel does not have. We do not recommend using it in Excel.

Can my team use it together?

Yes. Share your file with the Share button in Google Sheets. There are no roles or approvals: anyone who can edit can change data. For that, there is Contractor OS.

Can I buy Lite on its own?

Not at the moment. Lite is a bonus for webinar attendees. Ask us through the form below and we will tell you when the next webinar is.

Can samapp see my data?

No. Your copy of the template lives in your Google Drive and we have no access to what you enter.

Other questions? Write to us through the form below.

Contact - answered 09:00–21:00 WIB

Fastest on WhatsApp.

Tell us about your project in a few lines. We reply with a demo link, the price list and answers to your questions.

samapp - Contractor OS

Hi, I run an interior contracting business. Can I use it for 3 projects at once?

Yes, users and projects are unlimited. Here is the demo link, you can try it right away without signing up. Shall I send the price list too?

Sure, the subscription please.

An example conversation, not a real one.
prefer email?[email protected]
prefer telegram?@samappdev

Or send it through the form

About

samapp is a software studio in Indonesia. One developer owns your project from start to launch, not a rotating team. The code is in your repository from day one, so you are never locked in to us. Scope, timeline, and price are written down before work begins.

Portrait of Sultan Atha Maulana, founder of samapp
Sultan Atha MaulanaFounder / Developer

Built Contractor OS solo: seven roles, BOQ, Gantt, approvals, and invoicing, all of which you can try right now. Kotlin, Nuxt, and Node. Direct, and easy to work with.

GitHub
© 2026 samappSet in JetBrains Mono and Geist