Template
AIA Progress Billing Template:G702 Lines, G703 Schedule of Values Columns, Stored Materials, Nevada's 5 Percent Retention Cap and a Filled Las Vegas Reroof Application
AIA progress billing template: G702 lines, G703 schedule of values columns, stored materials and Nevada's 5% retention cap, filled for a Las Vegas reroof.
An AIA progress billing template is a pay application built on AIA Document G702, the Application and Certificate for Payment, and its G703 continuation sheet. G703 records work completed and materials stored on each schedule-of-values line; G702 carries the totals through retainage and earlier payments to the amount due. The sample bills a commercial reroof in Las Vegas, Nevada.
The form sits with the free field service templates of FieldRanger, field service software that runs inside HubSpot. The field and column tables come as a free .xlsx download with no sign-up: a Template sheet holds the continuation sheet from row 12, an Application sheet holds lines 1 to 9, and a Sample sheet holds the filled application. The workbook follows the G702 and G703 layout; it is not an AIA document. AIA sells the editable G702 itself "as a single-use document or as part of an ACD subscription" (AIA Contract Documents, G702 sample, read November 13, 2026). The labels quoted here are as printed on AIA's published sample of G702-1992.
Pay application, invoice and estimate on a long job
A pay application is not an invoice for finished work. An invoice template bills a job once, after it is done, line by line at the agreed prices. A pay application bills a job in periods, each for the value of work put in place since the last one. The architect or the owner's representative certifies it before the owner pays.
The schedule of values links the two ends of the job. It starts from the accepted price on the estimate template, regrouped into lines a person walking the site can measure. Every later application is a percentage of each line. The method and its vocabulary are set out in the guide to progress billing; this page sets out the form, and its .xlsx download carries it.
G702 application and certificate fields
G702 is one page with four parts: the header, the contractor's application, the contractor's signed and notarized certification, and the architect's certificate. Lines 1 to 9 are arithmetic on G703 and on the contract.
| Part | Printed label | What goes in it |
|---|---|---|
| Header | TO OWNER | The owner named in the contract |
| Header | PROJECT | Project name and address |
| Header | FROM CONTRACTOR | The contractor named in the contract |
| Header | VIA ARCHITECT | The architect or owner's representative who certifies |
| Header | APPLICATION NO | Sequential number, starting at 1 |
| Header | PERIOD TO | Last day of the billing period |
| Header | CONTRACT FOR | The scope, in a few words |
| Header | CONTRACT DATE | Date of the owner-contractor agreement |
| Header | PROJECT NOS | Owner's, architect's and contractor's project numbers |
| Header | Distribution to | Boxes for owner, architect, contractor, field and other |
| Application | 1. ORIGINAL CONTRACT SUM | The signed contract sum |
| Application | 2. NET CHANGE BY CHANGE ORDERS | From the change order summary |
| Application | 3. CONTRACT SUM TO DATE (Line 1 ± 2) | Line 1 plus or minus line 2 |
| Application | 4. TOTAL COMPLETED & STORED TO DATE (Column G on G703) | G703 column G total |
| Application | 5a. % of Completed Work (Columns D + E on G703) | Retainage rate times D plus E |
| Application | 5b. % of Stored Material (Column F on G703) | Retainage rate times F |
| Application | Total Retainage (Lines 5a + 5b, or Total in Column I of G703) | Sum of 5a and 5b |
| Application | 6. TOTAL EARNED LESS RETAINAGE (Line 4 minus Line 5 Total) | Line 4 less total retainage |
| Application | 7. LESS PREVIOUS CERTIFICATES FOR PAYMENT (Line 6 from prior Certificate) | Line 6 of the last certified application |
| Application | 8. CURRENT PAYMENT DUE | Line 6 less line 7 |
| Application | 9. BALANCE TO FINISH, INCLUDING RETAINAGE (Line 3 minus Line 6) | Line 3 less line 6 |
| Application | CHANGE ORDER SUMMARY | Additions and deductions approved in previous months by owner, approved this month, totals and net changes |
| Certification | CONTRACTOR | Signature, date, state, county, notary and commission expiry |
| Certificate | AMOUNT CERTIFIED | The architect's figure, signature and date |
The contractor's certification states that the work billed "has been completed in accordance with the Contract Documents" and that "all amounts have been paid by the Contractor for Work for which previous Certificates for Payment were issued". The second clause is a statement about subcontractors and suppliers, made under oath before a notary. The architect's certificate adds an instruction that governs any disagreement: "Attach explanation if amount certified differs from the amount applied. Initial all figures on this Application and on the Continuation Sheet that are changed to conform with the amount certified."
G703 continuation sheet columns
G703 holds one row per line of the schedule of values. AIA's instructions set out what each column holds (AIA Contract Documents help center, Instructions: G703-1992 Continuation Sheet, checked November 13, 2026).
| Column | Heading | AIA instruction | Formula |
|---|---|---|---|
| A | Item no. | Part of identifying "the various portions of the Project and their scheduled values" | Typed |
| B | Description of work | "The breakdown may be by sections of the Work or by Subcontractors and should remain consistent throughout the Project." | Typed |
| C | Scheduled value | Totaled on the last page; "Initially, this total should equal the original Contract Sum." | Typed |
| D | Work completed, from previous application | "the amount of completed Work covered by the previous application" | =D12 of the last application + E12 of the last application |
| E | Work completed, this period | "the value of Work completed at the time of this application", including materials incorporated | Typed |
| F | Materials presently stored | "the value of Materials Presently Stored for which payment is sought"; recalculated each period | Typed |
| G | Total completed and stored to date | "the total of columns D, E and F" | =D12+E12+F12 |
| G ÷ C | Percent | "dividing column G by column C" | =IF(C12=0,"",G12/C12) |
| H | Balance to finish | "the difference between column C (Scheduled Value) and column G" | =C12-G12 |
| I | Retainage | "normally used only for contracts where variable retainage is permitted on a line-item basis" | =G12*rate, or blank |
Column D excludes the stored materials from the previous application. AIA's note on column D keeps the previous column F out of it. Stored material is either still stored, and back in F, or installed this period, and in E. Change orders are listed separately, "either on their own G703 form or at the end of the basic schedule", and the total of column C moves with them.
Nevada retention limits on a private pay application
The contract sets the retainage rate, and in Nevada a statute sets its ceiling on private work. Under NRS 624.609(2)(a)(1), an owner authorized by the agreement to withhold retention may hold an amount that "must not exceed 5 percent of the amount of the payment to be made". Subsection 5 bars the owner from withholding "more than the retention amount" except on the grounds subsections 2 to 4 allow (Nevada Revised Statutes, chapter 624, checked November 13, 2026). The same chain runs down a tier: under NRS 624.624, retention a contractor holds from a lower-tiered subcontractor "must not exceed 5 percent of the payment".
The timing rules sit in the same sections. Without a payment schedule in the agreement, NRS 624.609(1)(b) requires payment "within 21 days after the date the prime contractor submits a request for payment". Under NRS 624.620, money remaining unpaid, retention included, "is payable to the prime contractor within 30 days after" occupancy or use by the owner, or after the work of improvement becomes available for its intended use. Availability counts only if the contractor gave a "written notice of availability on or before the day on which the prime contractor claims" it, or a certificate of occupancy was issued.
Two exclusions limit where these rules apply. NRS 624.622(4) states that NRS 624.609 to 624.622 "do not apply to an agreement between" two kinds of parties. The first is a prime contractor and a natural person who owns a single-family residence, for qualified services on it. The second is "A public body and a prime contractor for the performance of work and labor on a public work". A commercial reroof for a private owner sits inside them.
Filled AIA progress billing template: warehouse reroof in Las Vegas, Nevada
The project replaces the roof on a 48,000-square-foot tilt-up warehouse that stays occupied throughout. The contract is $486,000 at 5 percent retention, the Nevada ceiling; change order 1 added $9,720 for 1,800 square feet of rotted deck found at tear-off. This is application 2, for October 2026. The companies, project and figures are samples; the form, the arithmetic and the retention rule come from the sources above.
| Field | Sample entry |
|---|---|
| TO OWNER | Example Industrial Holdings LLC |
| PROJECT | Warehouse reroof, 4400 Example Way, Las Vegas, NV 89118 |
| FROM CONTRACTOR | Example Commercial Roofing LLC |
| VIA ARCHITECT | Example Roof Consulting, the owner's roof consultant acting in the architect's role |
| APPLICATION NO | 2 |
| PERIOD TO | October 31, 2026 |
| CONTRACT FOR | Tear-off and replacement with tapered insulation and 60-mil TPO membrane |
| CONTRACT DATE | August 17, 2026 |
| PROJECT NOS | 26-114 / RC-2611 / R-0387 |
| CHANGE ORDER SUMMARY | Previous months: $0 · approved this month: CO-1, addition $9,720 · net changes: $9,720 |
| A | B: Description of work | C: Scheduled value | D: Previous | E: This period | F: Stored | G: Total to date | G ÷ C | H: Balance |
|---|---|---|---|---|---|---|---|---|
| 1 | Mobilization, bonds and insurance | $24,000 | $24,000 | $0 | $0 | $24,000 | 100.0% | $0 |
| 2 | Tear-off and disposal | $72,000 | $21,600 | $36,000 | $0 | $57,600 | 80.0% | $14,400 |
| 3 | Tapered polyiso insulation and cover board | $118,000 | $17,700 | $53,100 | $0 | $70,800 | 60.0% | $47,200 |
| 4 | TPO membrane, 60 mil, fully adhered | $156,000 | $0 | $46,800 | $31,200 | $78,000 | 50.0% | $78,000 |
| 5 | Sheet metal edge and coping | $48,000 | $0 | $9,600 | $14,400 | $24,000 | 50.0% | $24,000 |
| 6 | Curbs, drains and penetrations | $38,000 | $0 | $7,600 | $0 | $7,600 | 20.0% | $30,400 |
| 7 | Warranty, closeout and punch list | $30,000 | $0 | $0 | $0 | $0 | 0.0% | $30,000 |
| 8 | CO-1: deck replacement, 1,800 sq ft | $9,720 | $0 | $9,720 | $0 | $9,720 | 100.0% | $0 |
| Total | $495,720 | $63,300 | $162,820 | $45,600 | $271,720 | 54.8% | $224,000 |
| Line | Calculation | Amount |
|---|---|---|
| 1. Original contract sum | Signed contract | $486,000 |
| 2. Net change by change orders | CO-1 | $9,720 |
| 3. Contract sum to date | $486,000 + $9,720 | $495,720 |
| 4. Total completed and stored to date | Column G | $271,720 |
| 5a. 5% of completed work | 5% × ($63,300 + $162,820) | $11,306 |
| 5b. 5% of stored material | 5% × $45,600 | $2,280 |
| Total retainage | $11,306 + $2,280 | $13,586 |
| 6. Total earned less retainage | $271,720 − $13,586 | $258,134 |
| 7. Less previous certificates for payment | Line 6 of application 1: $63,300 − $3,165 | $60,135 |
| 8. Current payment due | $258,134 − $60,135 | $197,999 |
| 9. Balance to finish, including retainage | $495,720 − $258,134 | $237,586 |
Stored materials and the change order on application 2
Two lines on this application need paper the architect will ask for. Lines 4 and 5 bill $45,600 of membrane rolls and coping metal delivered to the roof and not yet installed. Column F carries them as stored, and the consultant checks them against delivery tickets and a count on the roof before certifying. When the rolls go down in November, their value moves out of column F and into column E, and the November application's column D picks up only what was installed.
Change order 1 sits at the end of the schedule as its own line, as AIA's instructions describe. It was approved this month, so the change order summary shows it under "Total approved this month" and line 2 moves from $0 to $9,720. A second deck area flagged in the last week of October is not on the sheet at all. It is not approved, and an unapproved change billed in column E gives the architect a figure to strike.
The retention figure shows what the statute is worth on this one application. At 5 percent, the owner holds $13,586 to date. At a 10 percent contract rate, used here only for comparison, the owner would hold $27,172, and the current payment would fall from $197,999 to $187,578. Under NRS 624.609, that figure is over the ceiling for this owner.
Pay application procedure from schedule of values to certified payment
- Agree the schedule of values with the owner and the architect before the first application, with lines that can be measured on site and a separate line for closeout.
- At each period end, walk the job and record the value completed on each line in column E and materials stored on site in column F, with delivery tickets for every stored item.
- Carry last period's D plus E into column D, and drop last period's F, which is now either stored again or installed.
- Add approved change orders as lines at the end of the schedule, and enter them in the change order summary for the month approved.
- Compute column G, the percentage and column H, then carry the totals to G702 lines 4 and 5, applying the contract's retention rate within the state's ceiling.
- Take line 7 from the last certified line 6, not from the last amount applied for.
- Sign before a notary and send G702 and G703 together to the architect.
- When the certificate comes back, compare the amount certified with line 8, and read every initialed change on both sheets before the next application is built on them.
Contractor invoicing software and progress billing
Progress billing and retainage are not built in FieldRanger. FieldRanger generates the invoice from a completed work order, which fits a job billed once at completion. It does not produce a G702, a G703, a schedule of values or retainage. A contractor billing AIA pay applications keeps them in a spreadsheet laid out as above, or in construction billing software built for them.
What FieldRanger does on such a job sits before and beside the pay application. The estimate is built from the HubSpot deal or contact record, or in FieldRanger, where it stays tied to the deal. A won deal becomes a job with its context carried over, and job status shows on the HubSpot deal record. Job completions, notes and updates are logged to the HubSpot timeline. Photos taken on the job sync to the customer's HubSpot record. Each day is its own job, so a reroof that runs ten weeks is a series of daily jobs rather than one multi-day job; multi-day jobs are not built. Invoices and payments sync with QuickBooks. What the FieldRanger invoice holds, and what it leaves out, is on the contractor invoicing software page.
Frequently asked questions
What is an AIA progress billing template?
A pay application laid out as AIA Document G702, the Application and Certificate for Payment, with its G703 continuation sheet. G703 lists the schedule of values with work completed and materials stored on each line; G702 carries the totals through retainage and previous certificates to the current payment due.
Is there a free AIA G702 and G703 template in Excel?
The page offers a free .xlsx download with no sign-up, laid out on G702 and G703: a Template sheet for the continuation sheet, an Application sheet for lines 1 to 9, and a Sample sheet with the Las Vegas application. It is not an AIA document; AIA sells the editable G702 and G703 documents as single-use documents or by subscription.
How is retainage calculated on a G702?
Line 5a applies the retainage rate to completed work, columns D plus E of G703; line 5b applies it to stored material, column F. In the Las Vegas sample, 5 percent of $226,120 and of $45,600 gives $13,586 in total.
What is the maximum retainage in Nevada?
On private work covered by NRS 624.609, the retention an owner withholds must not exceed 5 percent of each payment, and NRS 624.624 sets the same ceiling for retention a contractor holds from a lower-tiered subcontractor. The sections do not apply to public works or to a natural person's single-family residence.
Does FieldRanger do progress billing or AIA pay applications?
No. Progress billing and retainage are not built in FieldRanger; it generates invoices from completed work orders. AIA pay applications stay in a spreadsheet or in construction billing software.
Application 2 at $197,999
The consultant has two things to verify before certifying $197,999: $45,600 of rolls and coping counted on the roof, and change order 1 signed in October. Nevada's ceiling keeps the retention at $13,586, payable within 30 days after the new roof is available for its intended use, on a written notice of availability given that day. The estimate that seeds the schedule of values has its own form in the free field service templates. FieldRanger's plans, on pricing, fit the service calls and small jobs that bill once at completion, and its 14-day Start free trial is open without a card.
FieldRanger runs field service inside HubSpot
Estimates, scheduling and dispatch, a technician app and invoicing on the HubSpot records sales already keeps. Every plan starts with a free trial.
Book a demo