Why Work in Progress Schedules Are So Important

WIP blogs“Can you send me a WIP that goes with this statement?”
“Can you send me the fiscal year-end statement with WIP?”

I’m sure you’ve heard those questions or some variation of them too many times to count. But have you ever wondered why we specifically ask for a Work in Progress schedule (WIP)?

Let’s look at the reasons your underwriter is so WIP-obsessed.

First, The WIP Is The Source of All The Information Found on The Balance Sheet And Income Statement

The revenue and profits that are shown on the income statement are taken directly from the WIP. The balance sheet lists Cost and Estimated Earnings in Excess of Billings (aka underbillings or UB for short) and the Billings in Excess of Costs and Estimate Earning (aka overbillings or OB for short). Those two numbers are also taken directly from the WIP schedule. Underwriters can get a deeper understanding of the income statement and balance sheet by looking at the WIP.

The Next Logical Question Is: HOW Does Looking At the WIP Provide A Deeper Understanding of The Balance Sheet And Income Statement?

To answer that, let’s consider each document separately.

Income Statement

Let’s say an underwriter looks at an income statement and sees that the gross profit for the year is quite a bit lower than in prior years. Without looking at the WIP, the underwriter might conclude the company was struggling to make money on all their jobs last year. But the WIP can show the underwriter that all the jobs were as profitable as years before except for one large job lost that lost money. If that one job is big enough and the loss severe enough, it can drag down the overall gross profit number that is given on the income statement.

A situation where the total gross profit is dragged down by just one job is viewed much less negatively than a situation where the company saw reduced job profitability across the board. Every contractor will have a bad job here and there without it being an indication of a decline in the health of the operation. Furthermore, the next time the underwriter meets with the account, he can ask specific questions about the losing job which will give him a greater understanding of how the company operates.

Balance Sheet

Two accounts on the balance sheet that underwriters zero in on are underbillings and overbillings.

To get an idea of how the WIP helps underwriters, you first need to know that while UB are an asset, they aren’t always good, and while OB are a liability, they aren’t always bad. It’s easy to get really deep in the underwriting weeds, but I won’t do that to you. For simplicity’s sake just remember that UB can be a sign that the gross profit on a job is declining and OB can be a sign that the gross profit on a job is improving.

Because the WIP lists each job individually, the underwriter can examine each job’s UB or OB. A job that is in its early-to-middle stages and showing an UB is usually not cause for alarm. It is likely that the contractor has incurred costs and hasn’t had a chance to submit a progress billing to the owner. In the underwriting world, we call these UBs “timing related.” They also can signal an unapproved change order on the job. These are almost always approved, and the contractor bills for it as soon as the contract allows.

However, if a job is nearing completion and there is a large UB, it can be a sign that the gross profit on the job has declined but the contractor has not recognized the decline. So why does this matter when looking at the balance sheet? Well, over the course of the job, the company recognized some profit on the job, and that flowed into retained earnings which became part of working capital and equity. Once the loss is finally recognized by the contractor, those previously recognized profits will get backed out of retained earnings. This means that at the time the WIP was produced, the working capital and net worth of the company were OVERstated. Working capital and net worth are the two key numbers underwriters use when determining how much surety credit to give a contractor.

As previously mentioned, OBs are a liability but not always negative. A job that is nearing completion and showing a sizeable OB may be a situation where the gross profit on the job is increasing. Remember the full name of OB: “billings in excess of COSTS and estimated EARNINGS.” As the name suggests, these are expenses and profits that the contractor has already billed for and therefore are probably sitting in cash or in accounts receivable (which will soon become cash). Some of this cash will go back into the jobs to cover costs, but some of it will be retained by the company as earnings. This means that at the time the WIP was produced, the working capital and net worth of the company were UNDERstated.

The above examples highlight how WIPs give an underwriter a deeper understanding of the numbers on the income statement and balance sheet, but they are far from the only benefits underwriters get from a WIP.

Unbonded Jobs

As you know, underwriters do a pretty good job of tracking the progress of bonded jobs by sending out project status reports. But what about all those unbonded jobs? Well, since the WIP lists all jobs, they give the underwriter the ability to track how the unbonded jobs are performing. You may be asking yourself, “Why does the underwriter care about unbonded jobs since he has no liability on them?” Well, an unbonded job has just as much potential to bankrupt a company as a bonded job does. Problems on an unbonded job affect a contractor’s ability to complete all of their other jobs, both bonded and unbonded. By seeing how all jobs are performing, the underwriter can spot trouble and take action to avoid or mitigate losses on bonded jobs.

Evaluating Internal Financial Statements

WIPs are also a great tool for assessing the quality of internally produced financial statements. As mentioned, the WIP shows the total balances of both overbillings and underbillings. Those balances also show up on the balance sheet.

When looking at a financial statement produced by a CPA, the overbilling and underbilling balances on the WIP are identical to the ones on the balance sheet. The same should be true of an internally produced statement — but often this is not the case. There are a number of reasons why this may be. Perhaps the company’s accounting software is not designed for construction accounting. Or maybe the person in charge of internal accounting is making errors. It could also be a situation where field supervisors are imputing job cost and billing data incorrectly.

Whatever the cause, such a discrepancy between the balance sheet and income statement causes the underwriter to question the accuracy of the whole financial statement. If an underwriter must use an internally produced statement that is known to contain some degree of inaccuracy, they may be more inclined to be conservative rather than aggressive. Conversely, if the underwriter has great confidence in the accuracy of the internally produced statement, they may be willing to be a bit more aggressive in their decision-making.

These are just a few examples to explain why underwriters love WIPs. While the list is far from complete, hopefully it is enough to help you understand why we underwriters are so persistent in requesting them.

If you have any questions about WIPs, or anything regarding surety, contact an appointed agent, or reach out to an Old Republic Surety branch nearest you.

Erik Mueller

Erik is the bond manager of the Minneapolis, Minnesota, contract branch office (located in Hudson, Wisconsin). He has been in the surety industry since 2007. Before joining Old Republic Surety Company, he was a surety risk advisor at Bearence Management Group and an account executive at Travelers. He has a bachelor's degree in history and social studies from Minnesota State University.