Fox & SantiagoTechnology, applied.Call (877) 244-9687

Problem guide

Project and budget reports are always out of date

A project or budget report is only as current as the last batch someone posted. Time waits for payroll, purchase orders wait for a bill, and changes wait for an approver before the report can see them. In construction, Electrical Contractor magazine's summary of JBKnowledge's 2020 ConTech survey found that about half of contractors move data between apps by hand. Put an as-of date on every report and show committed spend beside posted cost.

Rolled drawings and a hard hat on a job trailer table

How it actually happens

Every number on a project report has already made a trip. The report just does not say how long the trip took. Labor starts as hours on a timesheet, becomes a payroll run, and lands on the project only after payroll posts. Material starts as a purchase order, becomes a receipt or a supplier bill, and counts as cost only when the costing setting says it does. A change starts with the people doing the work, gets priced and approved in the project system, and reaches the ledger after an accounting approver accepts the export.

Take a typical month on a commercial mechanical job, as an example. The foreman's crew logs hours daily. Payroll runs every Friday, so Thursday's hours are a week old before the report can see them. Early in the month the project manager issued a purchase order for the rooftop equipment. The supplier billed it near the end of the month, and the bill was entered and posted a few days after that. Every report printed before that posting showed the equipment money as budget still available. Meanwhile a change event for added ductwork sat in the approval queue because the controller was closing the prior month.

The controller's report was correct for what had posted. The project manager's spreadsheet was correct for what he knew. Neither was the job. That is why project leads keep their own sheets, and why the review meeting turns into an argument about whose number is real.

The same trip happens in other businesses. A consulting firm's work-in-progress report waits on staff time entered at month end. A city department's budget report shows posted spending while approved purchase orders sit in a separate encumbrance report. An online brand's margin waits on settlement and freight bills that post weeks after the sale. In each case the report is right about the past and silent about what is already committed.

The schedule goes stale for a different reason. Someone draws it for the customer at the start, and the work starts changing the sequence by the second week. On a construction job the superintendent's lookahead on the trailer wall is current, and the schedule in the report is the one from the last pay application. On an AIA job that gap has a cost: the architect reports known deviations from the most recent schedule you submitted, so the owner can learn about a slip from the architect first.

Software adds its own steps. ServiceTitan's help warns that a batch can read Exported while single records failed. Procore holds budget changes for an approver by default and locks an exported budget until Sage posts it. On Sage's forum, users say pending supplier invoices do not show on the standard job cost reports. None of this is a defect. Each step is a control somebody wanted. Together they decide how old your report is.

Put the age on the page

A report with an as-of date and the date of the last posted payroll and bill batch is already more useful than a prettier one without them. Readers stop treating a two-week-old number as today's, and the project lead can say what is missing instead of defending what is there.

Signs you have this problem

  • The schedule in the monthly report shows a sequence the team stopped following weeks ago
  • A project looks under budget on the report and over budget once the supplier bills post
  • Every report starts with someone exporting from two systems and fixing the spreadsheet
  • The accounting batch says Exported, yet the project report is missing some of those invoices
  • Project leads keep their own budget sheet because they do not trust the official one

What usually causes it

  • Costs reach the ledger in batches, after payroll runs, bills are entered and someone posts, so the report trails the work by days or weeksThe re-entry trap
  • Budgets and changes edited in the project system wait for an accounting approver before the ledger sees themApproval drag
  • Purchase orders already issued are left out of the cost column, so spent money looks like budget still availableThe invisible queue
  • Records the accounting system rejects sit in error inside a batch that otherwise looks finishedThe exception swamp

Find your cause

Ask these in order. The first yes is usually where yours starts.

  1. Does the budget report move only after payroll runs or a bill batch posts?If yes: the report is a posting log, not a forecast. Add committed spend and print the last posting dates on it.
  2. Has a batch ever shown Exported while some invoices never reached accounting?If yes: nobody checks per-record status. Make clearing sync errors part of the daily export.
  3. Do budget or change edits in the project system take days to show in the ledger?If yes: they are waiting on the approver queue. Look at who accepts exports, how often, and whether a direct export fits your controls.
  4. Does the team work to a sequence that is not in the published schedule?If yes: the schedule is updated for the customer, not for the work. Revise it on the billing rhythm and from the lead's short-term plan.

How it breaks in each industry

Commercial electrical subcontractors
Labor hours by cost code drive the job, and the report sees them after payroll posts. Change events and their budgets often wait for an accounting approver in the project system, so the project manager's forecast and the controller's report disagree for a week at a time.
HVAC service and replacement
The call closes when the technician leaves, but equipment ordered on a purchase order shows on the job only after it is received or billed, depending on the costing setting. A replacement can look profitable for the whole month the unit sits on the supplier's invoice.
General contractors on AIA work
The schedule is a contract document in practice. Under an unmodified A201-2017 it must be revised at appropriate intervals, and the architect reports known deviations to the owner, so a stale schedule is a report the owner can hold against you.
Accounting and professional services firms
The work-in-progress report shows only the hours people have entered and the invoices that have posted. Staff enter time at the end of the week or the month, so an engagement looks on budget until the late time lands and the partner learns it ran over.
Local government and community organizations
Department heads read budget-to-actual reports that show posted spending. Purchase orders already approved but not yet paid sit in a separate encumbrance report, so a line can look open in one report and be fully committed in the other.
E-commerce and consumer brands
Margin by product depends on marketplace settlements, fulfillment invoices and freight bills that arrive days or weeks after the sale. The sales dashboard is live, the cost side is not, and a product looks profitable until the warehouse and freight bills post.

Where it breaks between systems

ServiceTitan project financials and accounting export
ServiceTitan's help says plainly that Exported does not always mean synced: a batch can show Exported while individual records inside it carry errors from the accounting system. Draft pay applications do not sync at all.[1]
ServiceTitan to QuickBooks or Intacct, batch export
Transactions reach accounting only after someone batches, posts and exports them. ServiceTitan recommends doing that daily, usually for the previous day's invoices. A partially exported batch has to be unposted, the failed items unbatched, and the batch posted and exported again.[2]
ServiceTitan costing settings
Actual cost on a job or project is counted from purchase orders, receipts (the default) or vendor bills, depending on one setting. Under the vendor bill setting, expenses show on the project only after the bill is entered and its batch is posted.[3]
QuickBooks Online Projects and payroll
Intuit's help explains that payroll labor reaches a project only after payroll is run. Estimated hourly costs can show sooner, but they are estimates.[5]
QuickBooks Online report basis
Intuit's help explains that a cash-basis report counts income and expenses when money moves, while accrual counts them when the invoice or bill is recorded, and that a single report can be switched between the two. A cash-basis job report leaves out unpaid supplier bills.[6]
Procore and Sage 300 CRE, budgets and change orders
There is no on-demand sync for budgets, commitments, commitment change orders or prime contract change orders. By default they go to the ERP Integrations tool for an accounting approver to accept or reject; Direct Export or Workflows can replace that step. After a budget export, the Procore budget stays locked until the entries are posted by hand in Sage Job Cost.[7]
Procore and Sage 300 CRE, actual cost
Job cost comes from Sage into Procore at summary level, into an ERP Direct Costs column. For most auto syncs, Sage pushes to the hh2 service about every five minutes and Procore polls hh2 every 30 minutes, so the sync is quick. The wait is for Sage to post the cost in the first place.[8]
Sage 300 CRE job cost reports (users' reports)
On Sage's community forum, users report that pending AP invoices do not appear on the standard job cost reports because Job Cost entries are created only when the invoice posts, and that Job Cost sometimes needs a separate Post Entries step. These are user answers, not Sage documentation.[9]

By the numbers

FigureWhat it measures
About half[11]Share of contractors in JBKnowledge's 2020 ConTech survey who move data by hand between apps that do not integrate, as summarized by Electrical Contractor magazine. The same summary says 27% reported that none of their apps integrate. The JBKnowledge report itself was not reached.
51%[12]Share manually transferring data between apps that do not integrate in the 2021 edition of the same survey, as reported on Autodesk's construction blog. Autodesk sells construction software.
$1.84 trillion[13]FMI's modeled estimate of what bad data may have cost the global construction industry in 2020 through poor decisions, in a study commissioned by Autodesk with a survey of about 3,900 industry leaders. Built from construction's share of global GDP; an estimate, not a measured loss.

Rules that apply

AIA A201-2017, Sections 3.10.1 and 3.10.3, the construction schedule[14]
Under the unmodified form, the contractor submits a construction schedule promptly after award, revises it at appropriate intervals as the work and project require, and performs the work in general accordance with the most recent schedule submitted. The form sets no fixed interval. Supplementary conditions often do.
AIA A201-2017, Section 9.2, schedule of values[14]
On stipulated sum and guaranteed maximum price contracts, the contractor submits a schedule of values before the first application for payment, and unless the architect objects it becomes the basis for reviewing every pay application. A budget report built on different line items than the schedule of values will not reconcile to what you bill.
FAR 52.236-15, Schedules for Construction Contracts[15]
Where the clause is in a federal fixed-price construction contract, the contractor enters actual progress on the schedule chart as the contracting officer directs and delivers annotated copies immediately. A missing schedule can hold up approval of progress payments. FAR 36.515 makes the clause optional, for contracts above the simplified acquisition threshold lasting more than 60 days.

Measure it in your own shop

From: Twenty recent cost records (timesheets, purchase orders, supplier bills and changes) from active projects, with their dates in the operating system, the project system and the ledger, plus the last six project reports you sent.

  1. For each record, write the date the cost happened and the date it first appeared on the project budget report.
  2. Split the records by type and find the median gap for labor, material and changes.
  3. On the last report for each project, add up the purchase orders issued but not yet billed on that date.
  4. Compare the schedule in each of the last six reports with the actual sequence of work and count the activities that had moved.

Reading it: The longest median tells you which stream makes the report stale: labor usually points to payroll or time entry timing, material to bill entry, changes to approval. The committed total is spending the report did not show. Moved activities count how far the schedule had drifted from the work.

What does not fix it

A new project management system
Procore with Sage 300 CRE still routes budgets and change orders through an accounting approver by default and still pulls actuals only after Sage posts them. The handoffs stay where they were.
A rule that everyone enters costs daily
Daily entry does not post a batch, run payroll or accept an export. The report waits on those steps, not on the people doing the work.
Reporting only posted cost
Posted cost is accurate and late. Without issued purchase orders beside it, a project can look healthy until the bills land.

What to try this week

  1. Date every reportPrint an as-of date on the schedule and the budget, and for the budget also print the date of the last posted payroll and the last posted bill batch. Readers then know what the number can and cannot include.
  2. Show committed spend beside actualAdd a column for purchase orders issued and not yet billed. In ServiceTitan that is the Committed Costs column, which only appears when the Committed Costs in Job Costing setting is turned on. Most accounting and ERP systems have an equivalent open purchase order or encumbrance report.
  3. Batch and post dailyServiceTitan's own help recommends batching, posting and exporting transactions every day, usually for the previous day's invoices. Whatever your system, put a name on that task and a time on the clock.
  4. Check each record, not the batchAfter every export, open the per-record sync status and clear the errors before the next batch. A batch can read Exported while single records inside it failed.
  5. Update the schedule on the billing rhythmRevise the schedule on a fixed rhythm the team can keep, and send it with each bill or pay application so the customer sees the same dates you are working to.

Where do-it-yourself stops

These steps make each report honest about its age and close part of the gap. The numbers still pass through payroll runs, bill entry, approval queues and export batches, and the schedule still changes faster than anyone redraws it. The lasting fix is a tool built around your operating system, your project system and your ledger, so committed, posted and scheduled data show on one screen with the date each piece arrived. That is what a Workflow Spec designs.

How a Workflow Spec fixes it for good

Questions people ask

Why does our budget report not match what the project lead sees?

They are usually reading different stages of the same cost. The project system may hold budget changes and purchase orders that the ledger has not accepted or posted yet, while the ledger holds posted bills the project system has not pulled in.

How often should a construction schedule be updated?

An unmodified AIA A201-2017 says only at appropriate intervals as the work requires. On federal fixed-price work with FAR 52.236-15 in the contract, actual progress is entered on the chart as the contracting officer directs, and a missing schedule can delay progress payment approval.

What are committed costs?

Purchase orders and subcontract amounts you have issued that are not yet billed. ServiceTitan shows them in a Committed Costs column. Its help warns that with the setting off, unbilled purchase orders drop out of the budget view and the project manager risks overspending.

Why are some invoices missing from QuickBooks when the batch says Exported?

ServiceTitan's help says a batch can be marked Exported while individual records were rejected by the accounting software. Check per-record sync status after every export.

How many contractors still move project data by hand?

About half, according to Electrical Contractor magazine's summary of JBKnowledge's 2020 ConTech survey, and 51% in the 2021 edition as reported by Autodesk. Both are survey results, not audits.

Next step

How we fix this

This guide is how to find it and work around it. If it keeps coming back, it is rarely the only thing costing you. We come on site, find the issues costing you the most, and fix them, starting with the most pressing.

Fox & Santiago, Genesee, Idaho. We work nationwide, for clients across the United States, from our headquarters in Genesee, Idaho.