Skip to content
Resources

AIA Billing in QuickBooks: Progress Billing Basics for Contractors

Learn how AIA G702/G703 progress billing connects to QuickBooks, including schedules of values, retainage, change orders, and monthly reconciliation.

What QuickBooks does—and does not do—for AIA billing

If you are searching for “aia billing quickbooks,” you probably need two things to work together: the payment application your customer requires and the accounting records your business relies on. Those are related, but they are not the same document. Getting that distinction right helps prevent rejected applications, duplicate revenue, and confusing receivable balances.

AIA G702 is the Application and Certificate for Payment. It summarizes the contract amount, approved changes, work completed, retainage, previous certificates for payment, and the current payment requested. G703 is the continuation sheet. It supports that request with a line-by-line schedule of values, showing completed work, stored materials, and remaining balances.

QuickBooks can handle customer invoices, receivables, payments, and job-related accounting. Some editions and plans support progress invoicing against estimates. That feature alone does not produce a complete G702/G703 billing package or manage every contract’s retainage requirements. Contractors commonly prepare applications in separate billing software or a controlled spreadsheet, then record the corresponding receivable in QuickBooks.

Use properly licensed AIA documents when the contract requires them. If the customer accepts another format, confirm its requirements before building your billing process.

Build the schedule of values before the first application

Your schedule of values divides the contract into billable components. For a roofing contractor, those might include mobilization, tear-off, insulation, membrane, flashing, and closeout. A general contractor may organize the schedule by trade or cost division. Follow the customer’s required format and obtain acceptance before the first billing deadline.

The original schedule should total the original contract amount. Approved change orders then increase or decrease the revised contract value. Keep pending changes separate so an internal forecast does not accidentally become a request for payment the customer has not authorized.

In QuickBooks, set up a consistent customer and job or project structure using the features available in your version. An estimate can provide a starting point for progress invoices, but your accounting items do not have to duplicate every cost code. What matters is a clear mapping between the schedule of values, the invoice, and the job reports.

Write down the billing rules in one place. These details determine whether an otherwise accurate application gets processed on time.

  • Application cutoff date, submission deadline, and required portal or delivery method.
  • Accepted schedule of values and change-order billing requirements.
  • Retainage rates, including any differences for labor, materials, or later project stages.
  • Stored-material documentation, supporting invoices, and any required approvals.
  • Required attachments and signatures; confirm legal questions about waivers or contract terms with your attorney.

Calculate the application from cumulative job progress

AIA-style progress billing is cumulative. Each application shows where the job stands through the current period, not just what happened this month. For each schedule line, update work completed from previous applications, work completed this period, and eligible materials presently stored. When previously stored materials are installed, move them into completed work without counting them twice.

G703 rolls those lines into total completed and stored to date. G702 summarizes that total, deducts retainage, and subtracts previous certificates for payment to calculate the current payment due. Previous certified amounts are not the same as cash collected. An unpaid prior invoice still belongs in accounts receivable; it should not be requested again as new work.

For example, assume a $500,000 contract with no changes and a uniform 10% retainage rate. If completed work and eligible stored materials total $200,000, retainage is $20,000 and earned less retainage is $180,000. If previous certificates total $135,000, the current payment due is $45,000. That calculation does not change simply because a prior payment has not arrived.

Have the project manager verify physical progress and the office verify the math. Percent complete for billing also should not be assumed to equal cost-based percent complete in your work-in-progress reporting.

Record the billing in QuickBooks without duplicating it

Once the application has passed your internal review, record the billing in QuickBooks according to a consistent accounting policy. Tie the entry to the customer, project, application number, and billing period. Keep the application and supporting documents attached or accessible through a reliable file reference.

The accounting setup should distinguish the current collectible amount from retainage withheld. For an accrual-based setup, that commonly means tracking current accounts receivable separately from retainage receivable. The exact workflow depends on your QuickBooks version and reporting needs; have your accounting provider establish and test it rather than improvising a negative invoice line each month.

Using the example above, suppose the previous cumulative gross billing was $150,000, with $15,000 retained. The new period adds $50,000 of gross billing: $45,000 currently due and $5,000 additional retainage. Recording only $45,000 without accounting for the withheld amount can leave billed activity and retainage understated.

Do not create a second sale when sending the customer’s required payment application. The application and QuickBooks invoice represent the same billing event. Likewise, a payment should be applied to the existing receivable, not recorded again as income. Billing also does not automatically determine earned revenue for financial reporting; reconcile it with your WIP process.

  • Use one application number across the billing package, invoice reference, and tracking log.
  • Document customer reductions or revisions and update the records without leaving duplicate invoices.
  • When retainage becomes billable, transfer it through the established workflow rather than recording the same revenue again.

Reconcile applications, receivables, and cash every month

A submitted application is not necessarily an approved application, and an approved application is not cash in the bank. Track those stages separately. Otherwise, your cash forecast can assume a payment is coming even though the package is waiting on a correction, signature, or supporting document.

At month-end, compare the application register with QuickBooks by project. Cumulative gross billings, retainage, current receivables, credits, and payments should explain the balance. Investigate differences instead of carrying them forward. Common causes include unposted change orders, revised applications that never reached accounting, and payments applied to the wrong job.

Keep a separate retainage schedule showing the amount held, release conditions, and expected timing. Retainage is not ordinary overdue receivables, but it still needs an owner and follow-up. Review billing against job costs and committed costs as well: a correctly prepared application can still belong to a job with a shrinking margin.

  • Submitted: What was sent, when, and with which attachments?
  • Approved: What amount did the customer accept, and what remains disputed?
  • Recorded: Does QuickBooks match the supported billing and retainage balances?
  • Collected: Which invoices were paid, and what needs follow-up?

When to get help

Get help when your applications and QuickBooks regularly disagree, retainage cannot be explained by job, or the owner has to rebuild the billing history to answer a collection question. Those are usually signs that the workflow needs clearer ownership, better account mapping, or a dependable monthly reconciliation.

Contractor Plus Books provides accounting and fractional CFO support for established contractors. A 20-minute financial review can help you see where your numbers stand and identify whether billing, receivables, retainage, or job reporting needs attention. There is no need to replace a working system just to make the process more consistent.

Contractor Plus Books is not a CPA firm. Confirm tax-treatment questions with your CPA and contract interpretation or waiver questions with your attorney.

Want this reviewed against your actual numbers?

Your financial reports should answer questions.
Not create more of them.

Talk through your cash flow, job margins and reporting in a free 20-minute review. Agree the next step before any paid work — or model a contract's cash impact first with the free analyzer.

Not ready to talk? Take the 3-minute Financial Health Check.

Book a Free 20-Minute Financial Review