Guide

Uninstalled materials and percent complete on a custom home

Why a big delivery can overstate progress, and how to fix it on the WIP schedule.

Short answer: When cabinets, windows or other big packages are delivered but not yet installed, their cost should not push up percent complete. Under ASC 606, if the item meets four tests, leave its cost out of the cost-to-cost measure and recognize revenue equal to its cost, at zero margin, until it goes in.

Why a big delivery distorts percent complete

Most builders who measure progress on a custom home use cost-to-cost: cost to date divided by total estimated cost. It is simple and it ties to the books, which is why it drives most WIP schedules. Our WIP schedule guide walks through the full calculation.

The weak spot is timing. Say the cabinet and window packages arrive at the end of the month and the bills are entered the same week. Cost to date jumps, so percent complete jumps, so earned revenue and earned profit jump. But nobody on site did more work that month. The house is not further along just because a truck showed up. If you report that jump, the job looks more profitable today than it is, and the margin seems to shrink later when the install labor comes in.

Job management software follows the same math. Buildertrend, for example, documents its WIP report percent complete as actual costs divided by projected costs, so a delivered package moves it the day the bill is entered. That is fine as a starting point, but the adjustment below has to be made on the WIP schedule itself.

What ASC 606 says, in plain words

ASC 606 is the revenue standard that applies to contracts with customers, including a contract to build a home on the client's lot. When you use an input method like cost-to-cost, the standard says to leave out costs that do not show progress. Baker Tilly lists wasted materials, rework and uninstalled materials as the usual examples.

For uninstalled materials there is a specific rule. The AICPA revenue recognition guide, published on PwC Viewpoint, lists four tests in ASC 606-10-55-21(b). If all four are met, you recognize revenue for the item only up to its cost:

  • The good is not distinct. A window package is part of the house you promised, not a separate thing the client bought.
  • The customer gets control well before the install. Materials delivered to the client's site ahead of the crew that installs them.
  • The cost is significant compared to the total expected cost of the house.
  • You buy it from a third party and are not significantly involved in designing or making it. PwC notes that if you are deeply involved in designing a custom item, buying it can count as real progress. Shop-built millwork you design may land on that side.

When the tests are met, the cost comes out of both the top and the bottom of the percent complete math, and you add revenue equal to the cost with no margin. RevenueHub walks through the standard's own elevator example in the same way. The total profit on the house does not change. Only the timing does: the margin on that package is earned as it is installed.

Want your WIP percent complete you can defend? Request a Relationship Assessment.

Where this applies on a home builder's books

  • Custom homes under contract where revenue is recognized over time on a percent complete basis. This is where the adjustment matters.
  • Spec homes are different. There is no customer contract while you build, so costs sit in inventory and revenue comes at closing. See spec home accounting.
  • Completed contract reporting, which home construction contracts can often use for taxes, does not use percent complete at all. See percentage of completion vs completed contract.

Whether your financial statements must follow ASC 606, and which items pass the four tests, are judgment calls for your CPA. It matters most when a lender or surety asks for reviewed or audited statements. Even for internal reports, though, the adjustment gives a truer read on margin while the house is open.

A SAMPLE calculation (made-up numbers)

SAMPLE only. A custom home contract is $900,000 with total estimated cost of $750,000, so expected profit is $150,000. Cost to date is $300,000, which includes a $60,000 cabinet and window package delivered but not installed.

  • Without the adjustment: $300,000 / $750,000 = 40% complete. Earned revenue is $360,000 and earned profit is $60,000.
  • With the adjustment: progress on everything else is ($300,000 minus $60,000) / ($750,000 minus $60,000) = $240,000 / $690,000, about 34.8%. Revenue on that work is $840,000 (the $900,000 contract minus the $60,000 package) times $240,000 / $690,000, about $292,174. Add $60,000 of revenue for the package at zero margin. Earned revenue is about $352,174 and earned profit about $52,174.

The difference is about $7,800 of profit that has not been earned yet. On a WIP schedule that also changes over or under billing, because billings are compared to earned revenue. See over and under billing.

How to track it month to month

  1. Set a threshold. Agree with your CPA on what counts as significant, so you are not adjusting for every lumber drop.
  2. Flag the bills. When a qualifying package is billed, note it on the bill or in a short list by house: vendor, cost code, amount, delivery date.
  3. Confirm install status at month end. Ask the project manager which flagged items are now installed. Remove those from the list.
  4. Add a column to the WIP schedule for uninstalled materials by house, and run the adjusted percent complete from it.
  5. Keep the support. Delivery tickets and the project manager's sign-off are what a reviewer will ask for.

The cost stays coded to the right house and cost code in QuickBooks Online the whole time. Nothing is moved in the job cost report. The change lives in the WIP math and in the month-end entry your CPA uses for earned revenue.

Common mistakes

  • Leaving the cost out of the measure but forgetting the zero-margin revenue, which understates revenue.
  • Never taking an item off the list after it is installed.
  • Treating materials stored off site, or still at the supplier, the same as items delivered to the client's lot. Control is one of the tests.
  • Using the adjustment to smooth results on items that do not meet the tests.

How we help

Our team builds the monthly WIP schedule for each open house, tracks uninstalled packages with your project manager and shows earned profit and over or under billing on a basis your CPA can review. Our founder reviews every close. We quote a flat monthly price for each builder, starting at $1,500 a month, with typical engagements between $2,500 and $8,500 a month. Start with a $1,500 Margin Review for written findings. See WIP schedules, fractional controller, pricing or request a Relationship Assessment.

Sources

Common questions

What are uninstalled materials in construction accounting?

Significant materials bought from a third party and delivered to the job, such as cabinets, windows or equipment, that are not installed yet. Their cost can overstate progress under cost-to-cost percent complete.

Do uninstalled materials count toward percent complete?

Under ASC 606, not when the item meets all four tests in 606-10-55-21(b). Leave its cost out of the measure and recognize revenue equal to the cost, at zero margin, until it is installed.

Does this change the total profit on the house?

No. Total profit is the same. The adjustment only moves the margin on that package to the period when it is installed.

Does this apply to spec homes?

No. A spec home has no customer contract while it is built. Its costs sit in inventory and revenue is recorded at closing.

Which items qualify on a custom home?

It depends on the four tests and on what your CPA treats as significant. Delivered window, cabinet and equipment packages are common candidates. Items you design in detail may not qualify.

Can you track this on our WIP schedule?

Yes. Our team keeps an uninstalled materials column by house and confirms install status with your project manager each month.

Related

By John Mos, Founder. Updated . We do not give tax or legal advice. Please ask your CPA or attorney.

See where your margin goes, house by house.

Tell us about your homes and your books. If we are a fit, we start with a $1,500 Margin Review: written findings and a fixed quote in 10 business days, credited to your onboarding fee if you sign up.