Free template
The WIP schedule template — the math's built in.
QuickBooks Online doesn't produce a WIP schedule, so yours lives in a spreadsheet. Make it the good one: enter five numbers per job and the template computes % complete, earned revenue, and over/(under) billing — in the format lenders and sureties expect.
One open job
$500,000 contract · 60% complete → $300,000 earned
$200,000 billed
Underbilled: (100,000) — the contractor is financing the client's project
What's inside
The math, computed
% complete (cost-to-cost), earned revenue, over/(under) billing, cost to complete, and estimated gross profit — from five inputs per job.
Three warning flags
Underbilled jobs, blown estimates, and fully-billed-but-open jobs get flagged automatically — the situations sureties ask about.
QuickBooks pull instructions
The second tab maps every input to the exact QBO report it comes from, sub-customer by sub-customer.
Month-end tie-out checklist
Earned revenue to the P&L, over/(under) to the balance sheet, and the flip check that catches margin fade early.
Rather never key numbers into a spreadsheet again?
Direct QuickBooks Online sync is built and in Intuit's production review. Today you import QuickBooks' own report exports (or our template) and export the over/under billing journal entry as a file QuickBooks imports in one step.