How to Do AIA Billing in QuickBooks (and the Easier Way)

Does QuickBooks do AIA billing?

Not natively. QuickBooks Online and QuickBooks Desktop are general ledger and invoicing systems — they handle customers, items, invoices, and payments well, but neither product has a built-in Schedule of Values, a G703 continuation sheet, or a G702 cover sheet with a retainage column. There is no QuickBooks screen where you mark a line item 65% complete and get an AIA-formatted pay application out the other end.

That is not a knock on QuickBooks. It is excellent accounting software for what it is built to do — managing the books, running payroll, reconciling bank feeds. AIA progress billing is a construction-specific workflow that most general ledger tools, QuickBooks included, simply were not designed around.

The workarounds contractors actually use

• •Excel alongside QBO. Someone on the team maintains a G702/G703 template in Excel — often downloaded from the AIA or built years ago — tracks the Schedule of Values and percent complete there, then keys the certified total into QuickBooks as a single invoice line or a lump-sum item.
• •Third-party AIA add-ons. A handful of construction-specific add-ons plug into QuickBooks to generate AIA-formatted pay applications, syncing some data back and forth via QuickBooks' API.
• •Manual retainage tracking. Retainage held per pay app usually lives in its own spreadsheet column or a QuickBooks other-current-asset account that has to be updated by hand every period and reconciled against what the G703 says was withheld.

Where the workaround breaks down

The spreadsheet-plus-QuickBooks approach works, technically, but it creates the same three problems on every job: double entry, retainage drift, and Schedule of Values drift.

Double entry means every pay period, someone builds the pay app in Excel and then re-enters the result in QuickBooks as an invoice — two places to make a mistake, and two places that can quietly disagree by the third or fourth billing cycle. Retainage drift happens because the 5% or 10% withheld on the G703 has to be tracked separately in QuickBooks, and if a contract's retainage rate drops partway through the job (a common clause once work is 50% complete), someone has to remember to change both. Schedule of Values drift is the worst one: change orders get approved and added to the job, but the Excel SOV and the QuickBooks job/item list update on different schedules, so the pay application and the books tell two different stories about what the contract is actually worth.

None of this is usually a single catastrophic error. It is a slow accumulation of small reconciliation gaps that someone has to hunt down at year-end or, worse, that an architect catches when a G703 does not tie out to prior certificates.

A cleaner way: generate the pay app, sync the totals

Field PM keeps the Schedule of Values, percent-complete billing, retainage, and change orders in one place, purpose-built for AIA progress billing — then syncs the resulting totals to QuickBooks (Online and Desktop), along with Sage Intacct, Xero, NetSuite, and Acumatica, so your books stay in your accounting system without a second round of data entry.

In practice that means: your Schedule of Values lives in Field PM and updates automatically when a change order is approved. Each period, you update percent complete per line (or pull it from field progress), add stored materials, and Field PM generates the G702/G703 as a certified-ready PDF with retainage already calculated. When the pay app is approved, the invoice total and retainage held sync to QuickBooks as an invoice against the job — no re-keying the number, and no separate spreadsheet for retainage to drift out of sync with what was actually billed.

What this looks like on a real pay application

Say a job has a $500,000 contract sum with 10% retainage. This period, work completed and stored across all SOV lines totals $220,000. Total Earned Less Retainage = $220,000 − (10% × $220,000) = $198,000. Subtract $150,000 already certified in prior pay apps, and the current payment due is $48,000.

In Field PM, that math runs automatically from the SOV and the period's percent-complete entries — the G702 cover and G703 continuation sheet are generated together. Once the pay app is certified, the $48,000 (and the $22,000 retainage balance) syncs to QuickBooks as the invoice and the job's financials, so your accountant sees a QuickBooks invoice that matches the certified pay application exactly, without anyone typing the number twice.