WIP Reporting: What It Is and Why Your Bonding Company Needs It
A WIP report is a job-by-job financial statement that shows how much revenue you have earned on each active project based on actual completion, how...
A WIP report is a job-by-job financial statement that shows how much revenue you have earned on each active project based on actual completion, how much you have billed to date, and whether those two numbers are aligned. Surety underwriters use it to set your single-project and aggregate bonding limits.
Your bonding agent asked for a WIP schedule. You asked your bookkeeper. They sent a spreadsheet that looked close but wasn’t right, and the surety flagged it. Now your bonding capacity is on hold and there’s a project you want to bid that you can’t touch yet.
This article explains what a WIP report is, how it is calculated, what your bonding company is actually looking for when they read it, and why most QuickBooks setups can’t produce one without extra work.
Key takeaways
- A WIP schedule is not a P&L. It is a job-level calculation that shows earned revenue versus billed revenue on every active contract.
- The cost-to-cost method is the standard surety underwriters require. Percent complete equals costs incurred to date divided by total estimated cost at completion.
- Overbilling appears as a current liability. Underbilling appears as a current asset. Both affect your bonding capacity.
- A missing or inaccurately prepared WIP schedule produces a lower bonding limit, which caps the size of work you can bid.
- QuickBooks cannot generate a formatted WIP schedule from the reports menu. It requires job costing data posted at the job level from day one.
What is a WIP report in construction?
A WIP schedule is a formatted financial statement, typically one row per active job, that calculates three things: how much revenue you have earned based on how far each project has progressed, how much you have billed the project owner to date, and whether billing is ahead of or behind what you have actually earned. As ConstructionCFO.net describes it, a WIP schedule for a surety is “a job-by-job statement calculated from actual job costing data on the cost-to-cost method, showing contract value” and the financial status of each open project.
It is built from job costing data, meaning costs have to be allocated to specific jobs inside your accounting system from the start. It cannot be reverse-engineered from your bank account or assembled from memory after the fact.
A properly formatted WIP schedule contains these columns at minimum:
- Contract value. The total agreed contract price, including approved change orders.
- Estimated cost at completion. Your current best estimate of total job costs, updated as the project progresses.
- Cost incurred to date. Actual costs posted to the job through the reporting date.
- Percent complete. Calculated using the cost-to-cost method (explained below).
- Earned revenue. Percent complete multiplied by contract value.
- Billed to date. Total invoices submitted to the project owner.
- Over/under-billing. The difference between billed to date and earned revenue.
As PremierCS puts it, a WIP report “tells you whether each job is making or losing money, whether your billing is ahead of or behind earned revenue.” That last column is the one a surety underwriter reads first.
How is a WIP report different from a P&L?
Your P&L shows total company revenue and expenses across a reporting period. It tells you whether the business made money last quarter. It does not tell you whether Job 7 is three weeks from burning through its contingency or whether Job 12 has $47,000 in underbilled change orders sitting uncollected.
As Deltek explains, a WIP report “is a tool used by contractors to track the cost of a project and how much money each phase costs.” Smith Howard describes it as tracking “the financial status of ongoing projects, providing details on incurred costs, recognized revenue, and projected” completion costs. Your P&L has none of that job-level detail.
A bonding company will not accept a P&L as a substitute for a WIP schedule. They are looking at different data entirely.
How do you calculate a WIP schedule?
The cost-to-cost method is the standard surety underwriters expect. It calculates percent complete by dividing costs incurred to date by your total estimated cost at completion. That percentage applied to the contract value gives you earned revenue.
The formula:
(Cost Incurred to Date / Total Estimated Cost at Completion) x Contract Value = Earned Revenue
This is not what you have invoiced. It is what you have legitimately earned based on how far the project has actually progressed. AlterSurety notes that WIP reporting “serves as an early warning system by tracking actual job totals for the completed percentage of the job.” That early warning function depends entirely on the cost-to-cost calculation being accurate.
A concrete job-level example showing both scenarios
Take a single project: $500,000 contract value, $250,000 estimated cost at completion, $100,000 in costs incurred to date.
Percent complete: $100,000 / $250,000 = 40%
Earned revenue: 40% x $500,000 = $200,000
Now look at two billing scenarios.
Scenario A, overbilling: You have billed the owner $240,000. Billed to date exceeds earned revenue by $40,000. You are overbilled by $40,000.
Scenario B, underbilling: You have billed the owner $160,000. Earned revenue exceeds billed to date by $40,000. You are underbilled by $40,000.
Both scenarios produce a $40,000 variance. Neither is neutral on a WIP schedule.
In Scenario A, the $40,000 overbilling is recorded as a current liability on your balance sheet, labeled “billings in excess of costs and estimated earnings.” You have collected cash for work you have not yet performed. In Scenario B, the $40,000 underbilling is recorded as a current asset, labeled “costs and estimated earnings in excess of billings.” You have earned revenue you have not yet invoiced.
Why overbilling and underbilling both matter to your surety
Overbilling signals to a surety underwriter that you may have already spent owner money on project costs that have not yet been incurred. That raises a solvency question: if the project stalls or you default, the owner is out cash for work that was never done. Underwriters view chronic overbilling across multiple jobs as a cash management and execution risk.
Underbilling signals poor billing discipline or a company financing its own projects out of operating cash while waiting to invoice. Across multiple jobs, that pattern suggests cash flow pressure. The surety is asking: can this contractor keep all of these projects moving without running short?
Why does your bonding company need a WIP schedule?
A surety sets two limits for every bonded contractor: a single-project limit and an aggregate limit. The single-project limit is the largest contract value they will bond. The aggregate limit is the total value of all bonded work in progress at the same time.
Both limits are calculated from the underwriter’s read of your WIP schedule. JMCO notes that contractors should “maintain work in progress (WIP) schedules” that are “detailed and up to date, as they provide insight into complete analyses” of financial capacity. A missing, stale, or inaccurately prepared WIP schedule does not result in the underwriter giving you the benefit of the doubt. It results in a lower limit.
A lower limit means smaller jobs. If you want to bid a $3M project but your single-project limit is set at $1.5M because your WIP schedule was missing or built on incomplete data, you cannot submit a bid.
As LiveFlow reports, “your WIP schedule is the primary financial document surety underwriters use to set your single and aggregate bonding limits.” The over/under-billing column is where they start.
What the underwriter is actually looking for
Sureties are looking for three things when they review a WIP schedule.
First, that you can complete all active jobs without running out of money. They are looking at your aggregate underbillings, your estimated costs to complete, and your cash position relative to the total work remaining.
Second, that your billing is aligned with actual project progress. Chronic overbilling across multiple jobs is a red flag. It tells the underwriter your cash position may be propped up by advances you have not yet earned.
Third, that your total in-progress workload is within your financial and operational capacity. If your aggregate WIP schedule shows $8M in work in progress and your financials suggest you can only handle $4M, the underwriter will cut your capacity.
A WIP schedule that is three months stale or built from summary-level accounting data rather than actual job costs fails all three tests. ConstructionCFO.net confirms that sureties require the schedule to be built from actual job costing data using the cost-to-cost method, not from estimates or billing summaries.
The growth consequence most contractors miss
If your WIP schedule understates the completion percentage on active jobs because your cost data is incomplete or posted at the wrong level, your earned revenue looks lower than it actually is. That makes your aggregate schedule look heavier. You appear more capacity-constrained than you are, and your bonding room shrinks.
You may have $2M in legitimate bonding capacity that the surety cannot see because the books don’t reflect it. You decline bids, or lose them, on projects you had the financial capacity to win. A poorly maintained WIP schedule doesn’t just create a compliance problem. It creates a direct revenue ceiling.
Does WIP appear on a P&L or balance sheet?
WIP does not appear as a line item on your profit and loss statement. It affects how revenue is recognized under percentage-of-completion accounting, but the balance sheet positions created by WIP calculations show up as assets or liabilities.
Underbillings, earned revenues not yet invoiced, appear as a current asset. The account is typically labeled “costs and estimated earnings in excess of billings.” You have done the work. You just haven’t billed for it yet.
Overbillings, collections received for work not yet performed, appear as a current liability. The account is typically labeled “billings in excess of costs and estimated earnings.” You have the cash. You still owe the work.
Most contractors have never seen either of these line items on their balance sheet. That’s because their bookkeeper isn’t producing them. If your balance sheet doesn’t have these accounts, your financials aren’t fully reflecting the state of your active projects, and your bonding company knows it.
Why can’t QuickBooks just generate a WIP report?
QuickBooks Online can track costs by job if job costing is configured correctly from the beginning. It cannot produce a formatted WIP schedule from the reports menu. Producing that schedule requires exporting job cost data, calculating percent complete using the cost-to-cost formula, computing earned revenue for each job, pulling billing totals from your invoicing records, calculating the over/under-billing variance, and formatting the result in the structure a surety underwriter expects to see.
That is not a report you run with two clicks. It is a structured calculation that has to be performed and formatted correctly every time.
A bookkeeper who doesn’t specialize in construction accounting may not know the difference between a job cost report and a WIP schedule. They are not the same document and they don’t answer the same questions.
What breaks when job costing data is wrong at the source
If costs have been posted at the company level rather than the job level, the WIP calculation is corrupted before it starts. Percent complete will be wrong because the cost-incurred-to-date figure is wrong. Earned revenue will be wrong. The over/under-billing positions for every job on the schedule will be wrong.
The surety underwriter will see all of it. A WIP schedule built on unreliable source data doesn’t get adjusted favorably by the underwriter. It gets flagged, and your bonding limits get cut.
This is not a formatting problem. It is a data problem that starts the first month costs are categorized without a job code. By the time a surety asks for a WIP schedule, there may be 12 months of job costing data to reconstruct before the numbers are trustworthy.
Three questions to ask before hiring a construction bookkeeper
When evaluating whether a bookkeeper can actually produce a surety-ready WIP schedule, ask these three questions.
First: do they set up job costing inside your accounting software from day one, or do they categorize expenses at the company level and sort it out later? If it’s the latter, the WIP data won’t be there when you need it.
Second: do they know the cost-to-cost method and can they calculate percent complete on each active job every month? A general bookkeeper who has never worked with a GC may not have produced a WIP schedule before.
Third: can they format the schedule the way a surety underwriter expects to see it, with all required columns and current data? Sending a raw job cost export is not the same as sending a properly formatted WIP schedule.
How Accountally builds WIP schedules for general contractors
Accountally builds and maintains WIP schedules for general contractors as part of monthly close. The surety gets an updated schedule every quarter, sourced from actual job costing data, using the cost-to-cost method underwriters require. When a new construction client comes on board, the Royal Revenue System process includes a review of the existing job costing structure, identification of any gaps that would corrupt the WIP calculation, and production of the first clean WIP schedule before month two. That schedule is built to meet what bonding companies require, not assembled after the fact from summarized records.
If your current setup doesn’t include job-level cost tracking, that is the first problem to fix. Everything downstream, including your WIP report and your bonding capacity, depends on it.
For more on how job costing works for a general contractor, see construction accounting services. For the full picture of what a monthly engagement includes for a GC, see monthly bookkeeping for contractors.
Frequently asked questions
What is a WIP schedule in construction?
A WIP schedule is a job-by-job financial statement that shows, for each active contract, the total contract value, costs incurred to date, percent complete (calculated using the cost-to-cost method), earned revenue, amount billed to date, and the resulting overbilling or underbilling position. Surety underwriters use it to evaluate a contractor’s financial capacity and set single-project and aggregate bonding limits. It is distinct from a profit and loss statement, which shows total company performance with no job-level detail.
How does bonding work for a construction company?
A surety company extends two credit limits to a bonded contractor: a single-project limit and an aggregate limit. The single-project limit is the largest individual contract the surety will bond. The aggregate limit is the total value of all bonded contracts in progress at any one time. Both limits are set based on the surety’s review of the contractor’s financial statements, most importantly the WIP schedule. A current, accurate WIP schedule built from verified job costing data is the primary input the underwriter uses to determine bonding capacity.
Does WIP appear on a P&L or balance sheet?
WIP does not appear as a line item on your profit and loss statement. The balance sheet positions created by WIP calculations show up as assets or liabilities. Underbillings, earned revenues not yet invoiced, appear as a current asset typically labeled “costs and estimated earnings in excess of billings.” Overbillings, collections received for work not yet performed, appear as a current liability typically labeled “billings in excess of costs and estimated earnings.” If neither account exists on your balance sheet, your financials are not fully reflecting the state of your active projects.
What does WIP mean in corporate accounting versus construction?
In corporate or manufacturing accounting, WIP refers to partially completed inventory in a production process. In construction, WIP refers specifically to the active contract backlog: jobs that have started and are in progress but not yet complete. The calculation method is entirely different. Construction WIP is measured using the cost-to-cost percentage-of-completion method, not an inventory valuation. When a surety underwriter asks for your WIP schedule, they are asking for the construction-specific version.
How often does a WIP schedule need to be updated?
Sureties typically require quarterly WIP updates at minimum. For contractors with multiple active jobs, monthly updates are better. A WIP schedule that is six months old gives the underwriter an inaccurate picture of your current job load and billing position. If your books are closed monthly and job costs are posted in real time, producing an updated WIP schedule at any point is straightforward. If job costs are only reconciled quarterly, the WIP schedule will always be at least that far behind.
If your bonding company has asked for a WIP schedule and you’re not sure your books can produce one, that’s worth addressing before the next bid opportunity arrives. Schedule a free consultation at accountally.com/schedule-emme/. We’ll review your current setup, tell you exactly what it would take to produce a surety-ready WIP schedule, and give you a clear picture of what monthly construction bookkeeping looks like when it’s set up correctly. No fire drills before the next bid deadline.