Tracking costs on a small job without software: three sheets and a Friday half-hour
A concrete contractor has a folder of receipts and a notebook of crew hours. The garage slab is progressing, but the owner cannot tell which part of the job has used its allowance. The next supplier payment gives a cash balance, not an explanation of remaining work.
Use three linked sheets: the approved budget, the coded transaction record and the forecast of remaining work. Give them the same short code list and a regular posting time, such as Friday's half-hour. These are working job controls, with accounting treatment confirmed by your bookkeeper. Their value comes from complete inputs and consistent coding; a spreadsheet does not become reliable simply because its totals calculate automatically.
Build a small system you will maintain
- Keep the budget sheet stable. Enter the agreed allowance for each activity and show approved revisions separately. Use the code list the crew already understands instead of starting a second set of labels for receipts.
- Create a transaction sheet. Give each entry a date, code, reference, description and amount or hours. Keep labour hours separately identifiable and use the company's cost rate consistently. Link to the original receipt, ticket or timesheet.
- Mark documents when they arrive. Write the job and code on each receipt or record, then put it in one collection point. Assign uncertain items for clarification; a blank code should remain visible rather than becoming miscellaneous forever.
- Post and reconcile weekly. Compare entered references with the collected paperwork and crew totals. Mark what has been entered so a forwarded receipt does not create a second transaction. Note missing records beside the affected line.
- Estimate what remains on the forecast sheet. Add each code's recorded cost and its remaining-work estimate using the office's cutoff method. Include outstanding orders without counting their received portion twice. Revisit the forecast monthly or when an important change becomes known.
- Keep one controlled copy. Date the weekly issue, back it up and limit formula editing. Have another person check a sample entry and total. Follow the same company treatment for taxes and deposits throughout the three sheets.
Common mistakes
- Replacing the original budget with actual spending.
- Counting an emailed receipt and its paper copy as separate purchases.
- Calling the difference between budget and posted costs the remaining-work estimate.
Action list
Set up the next posting
- Use identical codes on all three sheets.
- Collect hours and purchase records in one place.
- Mark entered documents and retain their references.
- List missing inputs by code.
- Price the work still ahead before judging the result.
Check your understanding
A sheet shows money left, but the remaining work has not been estimated. Does it show the job will finish under budget?
