Free AIA-style G702/G703 Excel template (formula-linked)
The short answer: below is a free Excel workbook, one G702-style certificate and one G703-style continuation sheet, formula-linked the way the real forms tie. Column G computes from D + E + F and the balance from C − G. The column totals carry to the certificate’s Lines 3 and 4, and retainage flows through Lines 5 to 9. Fill in your schedule of values and the math follows.
Formula-linked G702 + G703 in one workbook, with the tie-checks built in. Enter your email and the .xlsx downloads immediately.
Download the .xlsx directly if you would rather skip the email.
First-party only. Occasional pay-app checking tips, unsubscribe anytime, and we never share your address.
What’s inside
A single .xlsx workbook with two sheets. The first is the continuation sheet: one row per schedule-of-values line, with the standard columns A through I. The second is the certificate: the nine payment lines, which read their figures from the continuation sheet rather than being typed in again. It opens in Excel, Google Sheets, LibreOffice, and Numbers, and the formulas are ordinary arithmetic, so nothing breaks on the way in.
The design rule is that you only type what is genuinely input: the scheduled value of each line, the work completed this period, and materials stored. Everything derived is a formula: totals to date, percent complete, balance to finish, retainage, and the payment due. That matters because the most common way a pay application goes wrong is someone overwriting a derived cell with a number that looked right at the time.
The continuation sheet, column by column
These are the G703 columns and the arithmetic each one carries. Three of them are pure formulas, and those three are what make the sheet self-checking.
| Column | What it holds | In the template |
|---|---|---|
| A | Item number | You type it |
| B | Description of work | You type it |
| C | Scheduled value | You type it |
| D | Work completed from previous application | Prior period’s D + E |
| E | Work completed this period | You type it |
| F | Materials presently stored | You type it |
| G | Total completed and stored to date | = D + E + F |
| H | Percent complete | = G ÷ C |
| I | Balance to finish | = C − G |
Column F is materials not already counted in D or E. Billing stored material that has also been billed as completed work is a double count, and it is one of the errors that survives a casual read. When that material is installed in a later period it moves out of F and into E.
The certificate, line by line
The certificate summarises the sheet. In the template every line below except the two inputs is computed, so the payment due at the bottom is only ever as good as the schedule of values above it.
| Line | What it is | In the template |
|---|---|---|
| 1 | Original contract sum | You type it |
| 2 | Net change by change orders | Nets from the change-order block |
| 3 | Contract sum to date | = Line 1 + Line 2 |
| 4 | Total completed and stored to date | = total of Column G |
| 5a | Retainage on completed work | = rate × completed work |
| 5b | Retainage on stored material | = rate × stored material |
| 5 | Total retainage | = 5a + 5b |
| 6 | Total earned less retainage | = Line 4 − Line 5 |
| 7 | Less previous certificates for payment | Prior application’s Line 6 |
| 8 | Current payment due | = Line 6 − Line 7 |
| 9 | Balance to finish, including retainage | = Line 3 − Line 6 |
Line 4 is the handshake. The total of Column G on the continuation sheet must equal Line 4 on the certificate. If those two numbers disagree, one of the documents is wrong and the payment amount cannot be trusted. It is the single most useful check on a pay application, and in the template it cannot fail because Line 4 is the column total. On a document someone else prepared, it fails often. There is a whole guide on how the two forms fit together in G702 vs G703, and a filled-in one in the worked schedule-of-values example.
How to use it
- Enter the schedule of values once: item number, description, and scheduled value for every line. Add rows as needed and extend the total row to cover them.
- Confirm the scheduled values add up to the contract sum. If Column C doesn’t total to Line 3, the schedule of values is incomplete before any work has even been billed.
- Each period, fill in only Column E (work completed this period) and Column F (materials stored). Everything else recalculates.
- Roll forward at the start of the next period: this period’s D becomes the prior D + E, and Line 7 becomes the prior application’s Line 6.
- Glance at Column H before sending. Anything over 100% means a line is billed beyond its scheduled value, which needs a change order rather than a bigger number.
What a template can’t do
A formula-linked workbook protects the pay applications you build. It does nothing for the ones that arrive from a subcontractor’s own spreadsheet, as a scan, or as a PDF export of a system you’ve never seen. Those are where the errors actually live: a derived cell typed over with a constant, a transposed digit in a total, retainage taken at the wrong rate, a Column D that doesn’t match what last month’s application reported, or quiet front-loading of the early line items. None of it is visible until someone re-adds the columns by hand.
The checks are always the same handful: every line’s G = D + E + F, Column G totalling to Line 4, retainage at the contract rate, Line 8 equalling Line 6 − Line 7, and this period carrying forward from the last. You can run them by hand with the review checklist, and you should know what gets a pay app rejected before you certify one. Or upload the document to PayAppCheck and every identity is checked to the cent, with each mismatch flagged to the exact cell.
Questions people ask about the template
No. The official G702 and G703 are copyrighted documents licensed through AIA Contract Documents, and this is not a copy of them. It is an independently built workbook that follows the same column and line structure and the same arithmetic, so the numbers it produces are directly comparable. If your contract requires the official forms, buy them from the AIA and use this to check the math.
Yes. Enter an email and the .xlsx downloads immediately. There is no trial, no card, and no limit on how you use it, including on commercial projects.
Yes. The formulas are ordinary arithmetic and cell references with no macros, so the workbook imports into Google Sheets, LibreOffice Calc, and Numbers without anything to fix up afterwards.
As many as you need. Insert rows in the continuation sheet and extend the total row to include them. The certificate reads the column total, so it picks up the new lines automatically.
The rate is a single input cell, commonly 5% or 10% depending on the contract, and Lines 5a and 5b compute from it. Some contracts reduce or release retainage partway through the job, which the sheet supports by changing the rate for the period.
A template cannot verify a document it did not produce. Upload the PDF or Excel file to PayAppCheck and every identity is recalculated from the extracted numbers: per-line totals, column totals, the Column G to Line 4 tie, retainage, and the carry-forward against the previous application. Any mismatch is flagged to the exact cell.
Templates keep your own pay apps honest. For inbound ones, upload the PDF or Excel: every identity above is checked and each mismatch flagged to the exact cell.
Try PayAppCheck freeNo card required. The free tier is the trial.PayAppCheck is software, not a law or accounting firm. Not legal, accounting or tax advice. Verify lien, notarization, and retainage requirements against your contract, your state statute, and your accountant.