How do I track retainage in QuickBooks for construction projects?
QuickBooks Online has no built-in retainage feature. This catches a lot of contractors off guard because retainage is standard in construction, typically 5-10% withheld from each progress billing until the project is substantially complete. Without proper tracking, your books will overstate what you’re owed, understate what you owe subs, and make it nearly impossible to know your true cash position on any given project.
The fix requires two new accounts in your chart of accounts. First, create a current asset account called Retainage Receivable. This tracks the portion of your invoices that customers are holding back. Second, create a current liability account called Retainage Payable. This tracks the portion you’re withholding from subcontractor payments.
For retainage receivable, the cleanest approach in QBO is adding a negative line item on each progress invoice. Bill the customer for the full amount of work completed, then add a line item for the retainage deduction mapped to your Retainage Receivable account. If you completed $50,000 of work and the contract calls for 10% retainage, the invoice shows $50,000 in services and a negative $5,000 line for retainage. The customer pays $45,000 and the $5,000 sits in Retainage Receivable as an asset on your balance sheet. When the project wraps up and retainage is released, you create a final invoice pulling that accumulated balance out of Retainage Receivable and into Accounts Receivable.
For retainage payable, the process works in reverse. When a subcontractor bills you $20,000 and you’re holding 10%, enter the full bill but create a journal entry or bill credit moving $2,000 to the Retainage Payable account. You pay the sub $18,000 now. When you release their retainage at project completion, create a new bill against Retainage Payable and pay it out.
Every retainage entry should be assigned to the specific job or project. This is where construction job costing and retainage tracking overlap. If you’re not tagging retainage entries to the right job, your project-level financial reports won’t reflect the full picture. You might think a job is profitable when there’s still $30,000 in retainage payable sitting out there waiting to be released.
Reconcile your retainage accounts monthly. Pull up the Retainage Receivable balance and make sure it matches what customers actually owe you. Do the same with Retainage Payable against what you’re holding from subs. Stale balances in either account usually mean a project closed out but the retainage entries were never reversed. Over time this creates a mess that’s hard to untangle.
The setup itself takes maybe thirty minutes if you know what you’re doing. The ongoing discipline of applying it correctly at every billing cycle is the harder part. Miss a retainage entry on one invoice and your receivables are overstated until someone catches it. If you’re running multiple projects with different retainage percentages, the tracking gets complicated fast.
Most contractors we work with didn’t set this up themselves. They either skipped retainage tracking entirely and dealt with the confusion, or tried workarounds that broke their reporting. If your books don’t currently reflect retainage accurately, getting that corrected is worth the effort. Knowing exactly how much cash is tied up in retainage across all your active projects changes how you plan and bid future work. Our small business bookkeeping services include setting up these accounts correctly from the start so every progress billing flows through the right places automatically.
Your Valley of the Sun Bookkeeper
The Next Step:
A Quick Conversation
Tell us what's going on with your books. We'll listen, ask a few questions, and give you a clear quote with no surprises.
More Questions
Should I report booth rental income on Schedule C or Schedule E as a salon owner?
In most cases, Schedule C. If you provide shared amenities like wash stations, a waiting area, reception, or supplies, the IRS considers that active business income rather than passive rental income.
Read answerHow do I account for tip income and tip reporting requirements at my salon?
Your obligations depend on whether your stylists are W-2 employees or booth renters. Employees must report all tips to you, and tips over $20 per month are subject to FICA. Booth renters handle their own tip reporting on Schedule C.
Read answerWhat is AIA billing and how do I record G702/G703 pay applications in my books?
AIA billing is the standard progress billing format used in construction, built around the G702 Application for Payment and G703 continuation sheet. Record the full application amount as revenue, track retainage as a separate receivable, and keep change orders as distinct line items so your financials reflect your true position on each project.
Read answerHow should a salon track product inventory and retail sales separately from services?
Set up separate income accounts for Service Revenue and Retail Product Sales in your accounting software. Track inventory as an asset and record cost of goods sold when products are sold. Monthly physical inventory counts help catch shrinkage.
Read answerWhat quarterly estimated tax obligations does a 1099 real estate agent have in Arizona?
You owe federal quarterly estimates through Form 1040-ES if you expect to owe $1,000 or more, plus Arizona state estimates through Form 140ES. Plan to set aside 25 to 30 percent of your net commission income to cover income tax and self-employment tax.
Read answerHow should I account for dental lab fees and whether to pass them through to the patient?
Lab fees are a direct cost of the procedure and belong in cost of goods sold, not general overhead. Whether you absorb them, pass them through, or mark them up depends on your fee structure and insurance contracts.
Read answer