TapeAndFloat.com for small builders & GCsJob cost tracking without accounting software: budget vs actual
Job cost tracking means recording every bill, receipt and labor cost against the job and cost code it belongs to, then comparing it with that job's budget. Small builders find overruns too late when costs pile up in one bank account and nobody codes them until tax time.
Free download: Job budget vs actual tracker (Excel). Budget lines by job and cost code, one row per bill or receipt, and a change order log; it adds signed change orders to the budget, works out variance in dollars and percent, and flags lines over or near budget, costs with no job, cost code or budget line, and change orders worked but not signed or signed but not billed. No email required.
1. Start each job with a budget by cost code
Turn your estimate into budget lines using a short list of cost codes you reuse on every job: for example permits and fees, site work, foundation, framing, roofing, plumbing, electrical, HVAC, insulation, drywall, paint, cabinets and counters, flooring, fixtures, cleanup, and general conditions. Keep the list short enough that anyone in the office can pick the right code without asking. One row per job and cost code: budget amount, and whether it is a sub, material or labor line.
2. Code every bill and receipt to a job and a cost code
This is the whole system. Each supplier bill, sub invoice, card receipt and payroll or labor entry gets three things: the job, the cost code and the amount. Do it the week it comes in, not at the end of the job. Receipts in a truck console and bills in an inbox are where overruns hide. A cost with no job or no code goes on a short list to fix, so it never disappears into overhead by accident.
3. Track change orders as budget changes
When the client signs a change order, add it to the budget for that cost code, so the comparison stays fair. A change order you did the work on but never billed shows up as an overrun on paper and as lost money in the bank. Keep a column for the date or invoice number you billed it. See our guide to tracking change orders across every trade.
4. Compare budget vs actual every week
For each job and cost code: revised budget (original plus signed change orders), actual cost to date, and the difference in dollars and as a share of the budget. A line that is over budget before the work is done is the one to look at first. Ask whether it is a pricing problem, a scope change that should have been a change order, or a bill coded to the wrong job.
5. Review the weekly short list
- Over budget: find out why and whether a change order is owed.
- Close to budget with work left: check the remaining bills before you approve more.
- Signed change order not billed: add it to the next draw or invoice.
- Bill or receipt with no job or cost code: code it now.
- Cost coded to a job or code that has no budget line: fix the code or add the line.
6. Close out the job
At the end, compare final actuals with the original estimate by cost code. That comparison is what makes the next estimate better. Your accountant or bookkeeper can still keep the official books; this sheet is the operating view of each job, and it is general information, not tax or accounting advice.
Where an assistant helps
Bills and receipts arrive as emails, photos and PDFs from suppliers and subs. Forward receipts and bills; TapeAndFloat codes them to the job and cost code in your own Google Sheet, asks you about anything it can't place, and flags overruns and unbilled change orders weekly. You approve; nothing is paid or sent without you.
Free 60-day pilot: forward your job emails to the assistant, keep working in your own Sheet, and get a short daily list of what is slipping. No new app, no card. Request a pilot spot.
More guides
- How small builders track change orders across every trade
- Chasing sub paperwork: COIs, W-9s and lien waivers for small GCs
- How small builders get paid faster on draws and invoices
- Keeping clients and subs updated without project management software
- Procore and Buildertrend alternatives for small builders
- How small builders track allowances and client selections
- How small builders track punch lists and warranty callbacks
Frequently asked questions
What is job costing for a small builder?
Recording every cost (bills, receipts, labor) against the job and cost code it belongs to, so you can compare actual cost with the budget for each job instead of only seeing one total for the business.
What are cost codes?
A short, reusable list of categories such as framing, plumbing, electrical or drywall. Using the same codes on every job lets you compare jobs and improve your estimates.
How often should I compare budget vs actual?
Weekly works for most small builders: often enough to catch an overrun or an unbilled change order while you can still act on it.
Do I need accounting software for job costing?
No. A spreadsheet with a budget line per job and cost code and one row per bill or receipt works if someone keeps it current; keeping it current is what TapeAndFloat automates. Your bookkeeper or accountant can still keep the official books.
Want this tracked for you? Join the free pilot.