You run finishing or contracting jobs and you want to know, without a calculator, how far along each project is, how much you have spent against its budget, what profit to expect, how much the client still owes you and whether it is late. The free finishing and contracting projects tracker answers these from four records you type: projects, stages, expenses and payments. The template and its page are in Arabic.
The problem it solves
A contractor with several sites knows the picture: material receipts in a pocket, labour lists on paper, client payments in chat messages, one notebook per job. If someone asks whether a project is making money, it takes an hour of adding up. Worse, you may find out a job went over budget after the money is spent, or that a client owes you for work you finished and never invoiced. The sheet adds these numbers up for every project each time you open it.
How it works, step by step
- Write your projects in the "Projects" sheet: code, name, client, contract value, cost budget, start date and agreed delivery date.
- Split each project into stages in the "Stages" sheet with a weight and a completion percentage, and update the percentage as work moves on.
- Log every expense in "Expenses" with its date, project and item: materials, labour, subcontractor or transport.
- Log every client payment in "Payments".
- When a job is handed over, type the actual delivery date in "Projects".
- Read the result in each project's row and in the "Summary" for all projects.
What each sheet does
- Settings: today's date (type =TODAY() to keep it current) and the share of budget at which you want a warning.
- Projects: your details for the job, plus progress, actual spend, share of budget spent, expected profit, amount collected, amount due from the client, remaining contract value, days late, status and a budget alert.
- Stages: stage weights and completion; project progress is calculated from them.
- Expenses: the expense log by item; the project name appears by itself and a wrong code is flagged.
- Payments: what you received from clients and how.
- Summary: all projects together: contracts, cost, expected profit, collected, due, and spend split over the four items.
A walk-through with the sample numbers
These numbers come from the sample data inside the sheet, and the names are made up. It shows five projects:
- Villa finishing, New Cairo: contract 1,200,000, cost budget 900,000. Progress is 88%, spend 780,000 (about 86.7% of budget), so expected profit is 300,000. You have collected 960,000 and the client owes 96,000 for the work done. The agreed delivery was 15 October and it has not been handed over, so it shows 17 days late against the sample date (1 November).
- Office renovation, Dokki: handed over two days early, but spend is 355,000 against a 340,000 budget, so it is flagged "over budget" and its profit is 125,000. The client still owes 48,000.
- Residential building, 6th of October City: 1,835,000 spent of a 1,900,000 budget (about 96.6%) with only 61% progress, so it is flagged "near the limit". Note that its expected profit shows 600,000 because the sheet assumes cost will not fall below budget, and this one needs your review because the rest of the work may push cost higher.
- Shop finishing, Maadi: 20% complete, 32,000 spent of 110,000; you collected 45,000, so nothing is due from the client.
In the Summary: contracts total 4,680,000, actual spend 3,187,000 against budgets of 3,510,000, expected profit 1,155,000, collected 3,362,000, due from clients by progress 144,000, and one project late.
Benefits and why they matter
- A project's profit before it ends, not after the books close.
- Budget alert at a share you choose, so you act before the overrun.
- Due from the client reminds you of work done and not yet collected.
- Days late measured from the agreed delivery date, for running and delivered jobs alike.
- One summary for all jobs.
The online version
You can open the sheet online on the same example, edit the white cells and watch results change, add an expense, payment or project with a form so you never hunt for the last row, and import or export .xlsx. Your data stays in your browser. If you also invoice clients, try the customer ledger.
Who it suits
A finishing contractor, a small company running several jobs at once, an engineer managing sites with subcontractors, or anyone who wants to see project profitability from their own figures. It is not accounting software; it gives a quick picture of every job. If your business grows and more than one person needs to record at the sites, Softwiro can build custom software around your way of working.