How to Build Job Budgets and Work Orders from PDF Estimates

The estimate is approved. Now you have to turn it into a job: a budget for each trade, and a work order for each sub, all inside what the carrier agreed to pay.

An accurate budget comes down to two things:

1. It's built from the approved scope. What the carrier approved is what you get paid for, so it's what you budget against.

2. It has trade data for every line item. Your subs work by trade, so every line item in the approved scope needs a trade before it can become a budget or work order.

The approved estimate usually arrives as a PDF, and a PDF has no trade data. This post shows how to build job budgets and work orders from approved scope, and why trade data is where most budgets go wrong.

Requirement 1: Build the Budget from the Approved Scope

The approved scope is the only number that's guaranteed. Your original bid, your field notes, and your estimator's first pass are useful references, but none of them is what you'll be paid for.

When a budget is built from anything else, it drifts. Work orders include items the carrier never approved. Approved items get left off a work order and never get assigned. Six weeks later, the job is over budget and nobody can say exactly where it went wrong.

Before you build anything, make sure you have the current approved scope:

• The latest revision of the estimate, not the first one you received

• Any approved supplements, added to the original

• Notes on items that were approved with conditions or at changed quantities

Every dollar in your budget should trace back to a line item in that scope.

Requirement 2: Get Trade Data for Every Line Item

Insurance estimates are organized by room: kitchen, hallway, primary bedroom. Production is organized by trade: demo, drywall, paint, flooring, finish carpentry.

To build a budget, every line item in the approved scope has to be assigned to the trade that will do the work. That's the trade data, and it's what lets you:

• Total the approved dollars per trade, split into material and labor

• Compare each sub's invoice against what was approved for that trade

• See your gross profit by trade

• Build a work order with the exact line items and quantities each sub is responsible for

The PDF doesn't have trade data

In Xactimate, every line item carries a category code (DRY for drywall, PNT for painting, FCC for carpet, and so on) and a material, labor, and equipment split. Those codes tell you which trade the work belongs to, and the split tells you what the work is made of.

When an estimate is exported to PDF, most of that is lost:

• Line items have no trade. You get a description, quantity, and price, but no category code.

• There's no material and labor split. Each line shows one price, so you can't tell how much of it is material and how much is labor.

• Category totals may or may not be there. Some PDFs include a Recap by Category page and some don't. Even when it's there, it only gives totals, not the line items behind them.

Here's a typical line from a PDF estimate:

Bedroom ceiling 39. Seal/prime (1 coat) then paint (1 coat) part of the ceiling 66.50 SF × $1.11 · Tax $1.17 · O&P $15.00 · RCV $89.99 · Depreciation ($30.00) · ACV $59.99

[IMAGE: PDF line item with "PNT" written in by hand]

To budget this line, someone has to:

1. Read the description and decide it's painting, then write "PNT" next to it by hand.

2. Add $89.99 to the painting total for the job.

3. Figure out how much of the $73.82 ($1.11 × 66.50 SF) is paint and primer and how much is labor.

The first two steps are slow. The third can't really be done from the PDF. The material and labor split isn't on the page, so anything you write down is a guess. If you're buying the paint and paying your sub for labor only, that guess is your budget.

The split lives in the Xactimate file. That's why the reliable way to budget from a PDF estimate is to convert it back to Xactimate first.

On a small job that's tedious. On a large loss with hundreds of line items across dozens of rooms, it takes hours, and every line is a chance to put an item in the wrong trade or miss it entirely.

That's where budgets break. A painting line assigned to drywall makes one sub's budget too high and another's too low. A line nobody assigned never makes it onto a work order, so either the work gets done without a budget or it doesn't get done at all.

How to Build Trade Budgets and Work Orders from an Approved Estimate

Step 1: Get the approved scope into a working format

You need the line items as data, not as a document. The best source is the Xactimate file (ESX), because it keeps each line item's category code, material and labor split, quantity, unit price, and room.

If you only have the PDF, you have two options: retype it into Xactimate or a spreadsheet, or convert the PDF to ESX.

Step 2: Group every line item by trade

Use the category codes to sort the line items into trades. Most categories map directly to one trade. A few need a decision:

• Detach & reset items. These are often handled by a different trade than the category suggests. Decide who owns them.

• General items such as cleaning, dumpsters, and protection. Assign these to your own overhead or a general labor line, not to a sub.

• Custom (green) line items. These won't always have a standard category, so check them by hand.

When you're done, every line item in the approved scope should belong to exactly one trade.

Step 3: Total the approved dollars per trade, split into material and labor

Add up the approved line items for each trade. This is the revenue for that trade: the most the carrier has agreed to pay for that work. In Xactimate, this is the Recap by Category.

Then split each trade's total into material and labor. Every Xactimate line item carries that split, and you'll need it in the next step.

Step 4: Set each trade's budget and track gross profit

Your profit on each trade is what's left after you pay for the work:

Gross profit = trade revenue − sub invoice − materials you buy directly

How you use the material and labor split depends on who supplies the materials:

• The sub supplies and installs. Their invoice covers material and labor, so compare it against the trade's full revenue.

• You buy the materials. The sub invoices for labor only, so compare their invoice against the labor column. The material column becomes your materials budget.

Before invoices come in, many contractors use a placeholder, such as 50% of each trade's revenue, to estimate gross profit. Replace it with the real invoice as soon as you have one.

Here's what that looks like on a simplified residential water loss:

O&P and material sales tax sit below the trade lines and aren't paid out to subs.

Every revenue number in that table comes from the approved scope. When an invoice comes in high, you can see exactly which trade it hits, and whether the problem is the sub's price or a short scope you need to supplement.

Step 5: Issue work orders and collect sub invoices

Each work order should list the exact line items, quantities, and rooms for that trade. Subs price a defined scope, and you compare each invoice against that trade's revenue, or against its labor if you're buying the materials.

When the invoice and the budget are built from the same approved line items, a gap between them means something. Either the sub's price is high or the approved scope is short.

Step 6: Update when supplements are approved

When a supplement is approved, assign each new line item to a trade and add it to that trade's budget and work order. If you don't, your budget starts drifting from the approved scope again.

Common Mistakes When Budgeting from a PDF Estimate

• Budgeting from the wrong version. The first estimate you received isn't the approved scope if a revision or supplement came after it.

• Assigning line items to trades by memory. Without category codes, two people will assign the same line differently.

• Leaving lines unassigned. Any line that isn't assigned to a trade won't make it into a budget or onto a work order.

• Missing custom items. Green items carry non-standard pricing and descriptions, and they're easy to miss in a PDF.

• Rounding quantities. Small rounding errors across hundreds of lines add up to real money on a large loss.

How J&J Remodeling Builds Budgets from Approved Scope

J&J Remodeling, a Georgia-based general contractor, builds work orders and budgets for every job in DASH, their job management platform. Each work order lays out a subcontractor's scope and budget.

Before ClaimsFlow, their production managers built those work orders from PDFs. They combed through each insurance-approved scope, assigned every line item to a trade by hand, and built budgets one job at a time. William Ledbetter, J&J's Head of Estimating, spent two to five hours retyping a single estimate into Xactimate.

"Rewriting an estimate takes a ton of time. You have to type up every single line item one by one — sometimes hundreds of them — and then add quantities and adjust prices."

After Hurricane Helene, those PDFs piled up into a backlog that would have taken three to four months to clear.

Now William converts approved PDF scopes to ESX with ClaimsFlow and sends them into DASH, where work orders and budgets are built from the line items, with trade data intact. He processed 177 files in 10 days and saves 12–20 hours a week. Production managers no longer build work orders by hand.

"At the end of the day, ClaimsFlow is really saving the project manager's ass from doing things out of budget."

Build Your Next Budget from the Real Estimate

An accurate budget starts with the approved scope and trade data for every line item. The PDF gives you the first. ClaimsFlow gives you the second by converting the PDF back into an Xactimate ESX file, with every line item, quantity, price, category code, and material and labor split in place.

[IMAGE: Converted ESX open in Xactimate — line items grouped by category with material and labor columns visible]

Try it on your next approved scope at claimsflow.io.