The construction industry presents some unique accounting and financial reporting requirements when it comes to construction work-in-progress (WIP) schedules. To keep a solid pulse on contract financial status and results, it is important that these schedules are accurate and up to date. Here are five of the more common mistakes we encounter when working with clients:
1. Inaccurate inputs for the WIP schedule
Achieving 100% accuracy can be challenging as the WIP schedule depends on four main inputs. The four inputs include:
- Projected total cost
- Contract value
- Job-to-date cost
- Job-to-date billings
A miscalculation in any of these can cause inaccuracies in your work-in-progress reporting of revenues and contract assets and liabilities.
2. Estimated under/overbilling costs that don’t match contract scope or reflect actual costs
Has the project scope changed without including the corresponding change order? This can result in overstated contract revenues and underbillings. Are total estimated costs greater than they should be? This can result in overstated overbillings and understated contract revenues which, if it happens consistently, can materially skew reported revenues and gross margin.
3. Change orders and billings that are improperly included or excluded
The main determination if a change order should be included in WIP schedule calculations is if it is a continuation of an existing contract and is signed and legally enforceable or at least has a mutually agreed-upon scope and is awaiting price agreement. If so, the projections should be updated to include the change order. This can get complicated, though, so be sure to check with your accountant if there is a question.
4. Not reconciling the WIP schedule to the financial statements
It is important to understand the WIP schedule and how it ties into financial reporting. The general ledger or internal financial statements should be reconciled with supporting external sources as well as internal calculations or spreadsheets, including the WIP schedule. This includes reconciling contract assets, contract liabilities, and related income statement accounts.
5. Not including all contracts on the WIP schedule–including open and closed jobs
The WIP schedule should include all contract amounts, no matter how big or how small, or whether they are open or closed. Open vs. closed jobs should be noted as such on the schedule. It is a best practice to include job numbers for each contract; this way jobs can be tracked month over month, or year over year, and a gain/loss fade analysis can be performed.
BerryDunn’s Construction team partners with clients to provide meaningful insights on best practices in building capacity, stabilizing cash flow in growth, reducing tax liabilities, capturing reimbursable local taxes, and navigating state nexus. Learn more about our team and services.