Construction expense tracker: free Excel template.
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.
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
- List your projects on the Start here sheet.
- Enter your budgets by cost type. If you have a BOQ, add up its sections into materials, labour, subcontractors and overheads.
- 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.
- Fill in what was paid and how, including the M-Pesa or bank reference. The sheet works out what is still owed.
- 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.
Bring your spreadsheet. We will show you how the same figures look in MjengoKit, with approvals built in.
Book a 20-minute demo