Guides

Budget vs actual in Buildertrend: how to read the job costing budget

Goodluck Ogundare ·

Budget against actual is the first number most owners ask me for. Buildertrend's job costing budget has what you need to answer it, but the screen shows several costs side by side and each one means something specific.

This is how I read it, and what I check before a budget figure goes on a dashboard.

The five costs on the screen

  • Original budget: the starting cost for each cost code, taken from the signed proposal.
  • Revised budget: the budget after changes to the original.
  • Committed cost: what you have agreed to spend. Approved purchase orders count, and so do time-clock shifts that have not been approved yet.
  • Actual cost: what has been spent. Bills count, approved time-clock shifts count, and QuickBooks expenses count if the two systems are connected.
  • Projected cost: the forecast. By default it is the highest of the revised budget, the committed cost and the actual cost.

Budget against actual compares the revised budget with the actual cost. Budget against forecast compares it with the projected cost. They are different questions, and a job can look fine on one and bad on the other.

Check the accounting setting

Which bills count as actual cost depends on whether the budget is set to accrual or cash accounting. Two people looking at the same job on different settings will see different actuals. Agree on one before you compare jobs.

Costs with no original budget

On one build, several thousand cost-code rows had actual costs against an original budget of zero. Any report that starts from the budgeted lines drops them, and the job looks better than it is. Start from every line that has a cost.

Hours that are not approved yet

Unapproved time-clock shifts sit in committed cost, so they move the forecast before anyone has signed them off. If the forecast jumps on one cost code between two looks, check the time clock first.

Orders and bills for the same work

An approved order and the bill that pays it describe the same money. Committed cost and actual cost are not meant to be added together.

What I put on a dashboard

  • Revised budget, actual cost and projected cost for each open job, side by side.
  • The gap between budget and projected cost, in dollars and as a percentage.
  • A count of jobs with no budget entered, shown as its own number.
  • The accounting setting, stated once on the page.

Reference: Buildertrend's Job Costing Budget overview (opens in a new tab)

If you would rather have this built for you, I do it for building and remodeling firms. It starts with a small fixed-price review.