Budget vs Actual on Construction Jobs: Setting Up Job Budgets and WIP in Business Central

The Job Statistics page in Business Central will tell you your project is perfectly on budget right up until the moment it is not – if you set it up incorrectly, that is.

Budget vs actual tracking in Business Central is not automatic. It requires deliberate configuration: a task structure that mirrors how your projects are managed, planning lines for every cost type, a correctly selected WIP method, and consistent posting discipline.

Get any of these wrong and the budget vs actual view becomes a number with no reliable context.

This guide walks UAE contractors in Dubai, Abu Dhabi, and across the region through the four-step setup that makes Dynamics 365 Business Central budget vs actual reporting meaningful and IFRS 15 compliant.

Why Budget vs Actual Breaks Down Without Proper Setup

Most Business Central implementations that fail to deliver useful budget vs actual reporting have one of three configuration problems.

No planning lines. Planning lines are the budget baseline – the expected quantities and costs for each cost dimension on each task. Without them, Business Central has nothing to compare actual postings against.

The Job Statistics page shows actual costs only, with zero budget reference. Project managers see spending without context and cannot identify variances until the project is complete.

Tasks that are too high-level. A job structured with a single task called “Project” or three broad tasks called “Design,” “Build,” and “Close” gives no useful variance information.

When costs overrun, the task structure cannot show which phase caused the problem, where in the procurement chain costs are running high, or which subcontractor package is out of control. Task structure determines the granularity of budget vs actual visibility.

Wrong WIP method. The WIP method determines how Business Central recognises revenue and cost while the project is in progress. An incorrectly configured WIP method produces financial statements that misstate the project’s contribution to the business – potentially significantly – and creates UAE Corporate Tax and IFRS 15 compliance risk.

Understanding what goes wrong is the starting point. Here is how to set it up correctly.

Setting Up Budget vs Actual in Business Central: Four Steps

These four steps are sequential – task structure enables planning lines, planning lines enable WIP, and WIP determines what the financial statements show.

Step 1: Structuring Your Job and Tasks for Budget Control

The task structure you build into the job card at the start of the project determines what budget vs actual analysis is available for the life of that project.

Each job in Business Central sits under a job card – the top-level record linking the project to the customer, contract type, and general ledger. Under the job card sit job tasks, each of which becomes a separate cost tracking unit with its own budget and actual reporting.

For a construction project, the task structure should mirror either your bill of quantities breakdown or your project phases – whichever gives your project managers the level of visibility they need to control costs in real time.

The rule: if a cost category could meaningfully overrun without being immediately visible in a single task, it needs its own task. A main contractor managing five subcontractors across three phases needs tasks for each subcontract package, not just each phase.

One additional setup decision here is the WIP method on the job card. Business Central applies WIP at task level but the method is set at job level – selecting it correctly now avoids reconfiguration mid-project.

Step 2: Setting Up Planning Lines for Each Cost Dimension

Once the task structure is in place, the next step is creating planning lines – the budget baseline for each task.

Planning lines define what Business Central expects to see in terms of quantities and costs for each cost type against each task. Without them, there is no budget for actual postings to be measured against.

This is the single most common configuration gap in Business Central job setups across Dubai and Abu Dhabi construction businesses.

Business Central recognises three planning line types, corresponding to the three cost dimensions of a construction project:

• Resource planning lines cover labour hours and equipment usage. Each resource is set up with a cost rate (what you pay) and a billing rate (what you charge). Planning lines define the budgeted hours for each role against each task.
• Item planning lines cover materials and purchased equipment drawn from the item master. Planning lines define the budgeted quantities and unit costs for each material line.
• G/L account planning lines cover subcontractor costs, direct expenses, and overhead. Subcontractor budgets are defined here, linking the expected spend to a G/L account and task.

Planning lines serve a second purpose beyond budget comparison: they are also the source for client invoicing when billing is linked to planned quantities. A job with incomplete planning lines will produce incomplete invoices. Completeness is not optional.

Step 3: Configuring WIP Methods for UAE Construction Contracts

Work in Progress accounting determines how Business Central recognises revenue and cost while the project is in progress. For UAE construction firms under IFRS 15, the WIP method choice is both a financial reporting decision and a compliance requirement.

IFRS 15 requires revenue to reflect the transfer of control to the client. For most construction contracts, this means recognising revenue progressively over the project duration. The WIP method in Business Central is the mechanism that delivers this.

Business Central offers four WIP methods, each suited to different contract structures common in the UAE:

For most fixed-price construction contracts in Dubai and Abu Dhabi – the standard contract form for main contractors on commercial development and infrastructure projects – Percentage of Completion is the IFRS 15-compliant default. Cost Value is common for cost-plus contracts where the margin is defined as a percentage of actual spend.

For UAE contractors also preparing for FTA e-invoicing compliance, IPC invoices and milestone billing from Business Central job records are transmitted in PINT AE format once the mandate applies – the billing workflow sits within the same module as WIP accounting.

After setting the WIP method, WIP must be calculated and posted before each financial period close. WIP posting is the step that moves the calculated revenue recognition entry into the general ledger.

Without it, the period’s financial statements will not reflect the project’s true contribution – regardless of how well the underlying job is configured.

Step 4: Reading and Acting on Budget vs Actual Reports

With planning lines set, costs posting, and WIP configured, the Job Statistics page becomes the primary tool for project financial control.

The Job Statistics page in Business Central shows, for each job and each task, the following data in real time:

Variances become visible at task level the moment actual postings exceed or fall short of the planning line budget. A project manager on a Dubai commercial fit-out can see, in real time, whether their electrical subcontractor package is tracking to budget or whether materials consumption is ahead of the planned rate.

Beyond the Job Statistics page, Business Central includes a Job Profitability report that compares invoiced amounts, costs, and calculated margins across all active jobs simultaneously.

For Business Central project management across multiple concurrent projects – common for mid-size contractors in Dubai, Abu Dhabi, and Sharjah – this report provides the portfolio-level view that finance directors and board members need.

Two principles govern acting on budget vs actual data.

First: investigate variances when they appear, not at month-end. A 10% materials overrun on a task is recoverable at week two of a project. It may not be recoverable at week ten.

Second: update the cost-to-complete estimate when actual costs diverge from budget. Business Central allows revised quantity and cost estimates to be posted alongside original planning lines, giving the finance team both a historical view (what has been spent) and a forward view (what the project is forecast to cost in total).

For UAE contractors managing WPS payroll allocation across projects, labour costs from payroll flow directly into the job – maintaining consistency between payroll and job cost actuals without manual reconciliation.

Burhani™ has configured Business Central budget and WIP setups for construction businesses across Dubai, Abu Dhabi, and the wider UAE – main contractors, MEP firms, fit-out specialists, and engineering consultancies.

The configuration decisions across these four steps determine whether budget vs actual works from day one or gets rebuilt six months into a troubled implementation.

Final Thoughts

Budget vs actual on construction jobs is not a reporting feature you switch on. It is the output of a configuration that starts at the job card and runs through task structure, planning lines, WIP method selection, and posting discipline.

Done correctly, it gives project managers in Dubai real-time visibility into which contracts are performing, which are under pressure, and where intervention is needed while intervention is still possible. Done incorrectly, it gives finance teams a cost total with no baseline – useful for accounting, useless for project control.

If your Business Central setup is not producing the budget vs actual visibility you expected, the problem is almost always in steps one or two: task structure that is too coarse, or planning lines that were never completed. Both are fixable. Start there.

Frequently Asked Questions

These questions address the most common setup challenges UAE construction businesses encounter when configuring job budgets and WIP in Business Central.