Skip to content
Chat with MjengoKit on WhatsApp
Construction cost control

Construction expense tracker: free Excel template.

By the MjengoKit team. Updated 7 November 2026. 5 min read.

A construction expense tracker is a spreadsheet that logs every site cost against a project and compares the total with your budget. Our free Excel template does this in Kenya shillings for up to five projects, with budget against actual by cost type. Download it, replace the example rows and start logging today.

Construction expense tracker (Excel)Budget, expense log and summary sheets. Formulas are built in and the example rows are clearly marked.
Download free

What is in the template?

Sheet What you do there What it gives you
Start here Read the short instructions and list your projects Project names used everywhere else
Budget Enter a budget for each project and cost type The figures you will compare against
Expense log Add one row per expense Automatic outstanding balance on each row
Summary Pick a project from the list Budget, spent, paid, outstanding and remaining by cost type

How to use it in five steps

  1. List your projects on the Start here sheet.
  2. Enter your budgets by cost type. If you have a BOQ, add up its sections into materials, labour, subcontractors and overheads.
  3. Log each expense when it is requested, not when the receipt turns up. Record the date, project, cost type, payee, who asked and who approved.
  4. Fill in what was paid and how, including the M-Pesa or bank reference. The sheet works out what is still owed.
  5. Review the Summary every week. Look for any cost type running ahead of the work done.

Three rules that keep a spreadsheet honest

  • One person owns the file. Copies on three laptops quickly become three different versions of the truth.
  • Every row has a project and a cost type. A row without them can't be reported on, so it might as well not exist.
  • Record the reference. An M-Pesa code or bank reference lets you match each row to the statement.

Spreadsheet or software: when should you switch?

A spreadsheet is a sound way to start, and for one small project it may be all you need. It records spending, but it can't stop spending. Nothing in a spreadsheet prevents someone from buying before anyone approves.

If this is true Spreadsheet Software
One site, and you approve everything yourself Usually enough Optional
Two or more sites, with several people spending Starts to strain Worth it
You need approvals before money leaves Can't enforce it Built in
You pay many workers by M-Pesa Manual matching Linked to each request
Totals are needed daily, not monthly Depends on one person Always current

When you reach that point, construction expense tracking software keeps the same structure and adds the approvals and payment links. Our guide on how to track construction expenses across sites explains the process in more detail.

See it working on your own numbers

Bring your spreadsheet. We will show you how the same figures look in MjengoKit, with approvals built in.

Book a 20-minute demo
FAQs

Frequently asked questions

Is there a free construction expense tracker in Excel?

Yes. This template is free to download, and it covers a budget, an expense log and a summary by project and cost type, in Kenya shillings.

How do I track construction expenses in Excel?

Set a budget by cost type, then add one row per expense with its date, project, cost type, payee, amount, amount paid and payment reference. Use the totals to compare with your budget every week.

Can I use it in Google Sheets?

Yes. Upload the file to Google Drive and open it with Google Sheets. The formulas used are standard, but check the dropdown lists after opening.

Can it handle several projects?

Yes. It has room for up to five projects, and the Summary sheet shows one project at a time.

Will it stop people overspending?

No. A spreadsheet records spending after someone enters it. To control spending before it happens, you need an approval step, on paper or in software.

Book a 20-minute demo and discover your spending confidence.

Bring your spreadsheet. We will show you how the same figures look in MjengoKit, with approvals built in.