Before you make decisions based on the profit in your P&L, make sure it ties to your WIP report.
For contractors recognizing revenue as work progresses, the Work-in-Progress (WIP) report supports the revenue and job costs in the financial statements. If the WIP and Profit and Loss (P&L) statement don’t reconcile, you need to understand why.
Maybe payroll hit the wrong job. Maybe a completed project dropped off the schedule. Maybe the revenue adjustment never got posted. You want those answers during the monthly close, before you rely on the numbers to bid work, hire people, or buy equipment.
Your accounting team needs to understand how construction accounting works well enough to explain the connection between these reports.
The WIP shows each job’s contract value, costs incurred, estimated costs to finish, earned revenue, and billings. The P&L shows the company’s revenue, costs, and overhead for a specific period.
The revenue and job costs should reconcile across the two reports for the same period and the same jobs. That includes jobs completed during the period, even if they’re no longer on your active-job WIP. Service work or other activity outside the WIP needs to be accounted for separately.
There’s a timing issue here that gets missed: a typical WIP shows totals from the beginning of each job. Your monthly or year-to-date P&L covers a shorter period.
Suppose a job has $600,000 of earned revenue to date, and $450,000 had already been recognized at the end of last year. That job contributes $150,000 of revenue to this year’s P&L. Comparing the full $600,000 to year-to-date revenue won’t work.
Use the same approach for costs. Then explain any remaining differences, such as indirect costs, allocation entries, or costs outside the job schedule.
Suppose you have a $1 million contract. You’ve earned $500,000 of revenue based on progress, but you’ve billed $650,000.
You’re overbilled by $150,000. If your books treat the entire $650,000 as earned revenue without a WIP adjustment, revenue and profit are overstated by $150,000, assuming the costs are otherwise correct.
The billing may be perfectly valid. You just haven’t earned all of that revenue yet.
Underbilling runs the other direction: earned revenue exceeds what you’ve billed. Without the appropriate adjustment, your P&L may understate the work you’ve earned revenue on.
That’s why the invoice total alone can’t tell you how much profit the company made.
Start with complete, accurate job costs. Record costs through the reporting cutoff, including necessary accruals, and put them on the right jobs. Check labor, materials, subcontractors, equipment, and applicable cost allocations.
Also review costs paid through related entities. If a sister company paid an invoice for your job, that cost still needs to reach the correct company’s books and job cost report.
Missing costs can throw off both the job’s reported margin and its calculated progress.
The original bid isn’t automatically your best estimate of what the job will cost today.
Review what’s left to buy, subcontract, and install. Ask about labor productivity, delays, rework, and anything else that changes the cost to finish. Update contract values for changes that qualify for recognition, and review pending change orders and claims before including them in revenue.
Your WIP can tie perfectly and still be wrong if the estimates are stale.
Calculate earned revenue using the appropriate method for each contract. For jobs measured on a cost-to-cost basis, the current estimate of total costs helps determine progress and earned revenue.
Convert the cumulative WIP amounts into the period you’re reporting. For a monthly P&L, subtract the prior month-end amounts. For a year-to-date P&L, subtract the prior year-end amounts.
Include completed jobs and any activity tracked outside the WIP. Compare the resulting revenue and costs to the relevant P&L accounts, and investigate the differences.
Reconcile each job’s earned revenue to its billings. The ending underbilling and overbilling balances belong on the balance sheet as assets and liabilities, respectively.
The adjustment needed to bring those balances current also affects recognized revenue on the P&L. If invoices were initially recorded as revenue, an increase in underbillings generally increases revenue; an increase in overbillings generally reduces it.
Account for adjustments already on the books so you don’t record the same amount twice. After posting, rerun the reports and confirm that the balances reconcile.
Accounting should confirm that the reports tie. Project managers should confirm that the estimates reflect what’s happening on the jobs.
If a job’s projected margin changed, document why. If underbillings keep growing, find out whether billing is behind, a change order is unresolved, or the estimate needs another look. Keep those explanations with the reconciliation.
An overbilled job only provides cash when the customer pays. An underbilled job may have earned revenue that you can’t collect yet. Neither position, by itself, tells you what’s available to cover next week’s payroll.
Review the WIP alongside receivables, retainage, expected collections, and upcoming payments. That’s how you connect reported profit to the cash the business needs.
Your bank and bonding company also rely on your financial statements. A reconciliation they can follow helps support the numbers you’re asking them to trust.
Before you close the month, have someone confirm that revenue, job costs, and the overbilling and underbilling balances reconcile—and that the estimates behind them have been reviewed. Keep the reconciliation with the financial statements so the next person can follow it.
For a complete reconciliation with source reports, a journal entry, and before-and-after financial statements, work through How to Prepare a WIP Report from QuickBooks Online. The example separates prior-year activity from current-year results and ties the finished WIP to the P&L and balance sheet.
If your WIP doesn’t tie to your P&L—or getting it there turns into a scramble every month—Levvigo can help. We work with contractors on job costing, WIP preparation, and financial reporting.
We’ll help you find the gaps, make the corrections, and build a monthly process your accounting team can maintain.
Book a call with Levvigo to talk through your WIP and accounting needs. Learn more about our outsourced construction accounting.