Construction Draw Schedule & AIA G702/G703 Billing
AIA G702 Application for Payment, G703 Continuation Schedule of Values, retainage %, and change order log.
What This Workbook Does
G703-style continuation sheet: scheduled value, previous work, this period, stored materials, total to date, % complete, balance to finish and retainage per line
G702-style application summary that recalculates from the continuation sheet: contract sum to date, retainage, earned less retainage, previous certificates and current payment due
Change order register; approved change orders feed the contract sum
Retainage rate, contract sum and application number set once in Settings
Dashboard with original and revised contract sum, billed to date and retainage held
Follows the AIA G702/G703 layout and math; not an official AIA Contract Document
Worksheets Included
6 TabsUniversal Windows & Mac support with dynamic arrays
Runs in browser on office.com with free Microsoft account
Pure .xlsx formulas. Never blocked by corporate IT antivirus
Receive both a clean blank file and pre-filled sample rows
Free G702 / G703 Pay Application Template (Excel)
Fillable Excel workbook with the G702 summary and G703 continuation sheet linked by formulas. Retainage and current payment due calculate automatically. No signup, no macros.
What is the G702?
The Application and Certificate for Payment: a one-page summary of the contract sum, change orders, work completed to date, retainage held, previous payments and the amount due this period. The architect or lender certifies it.
What is the G703?
The Continuation Sheet: the schedule of values broken into line items, showing for each one what was billed before, what was done this period, materials stored, percent complete, balance to finish and retainage. Its totals feed the G702.
G703 Continuation Sheet Example
Pay application #3 on a $250,000 office build-out with 10% retainage.
| A Item | B Description | C Scheduled value | D Previous | E This period | F Stored | G To date | % G÷C | H Balance | I Retainage |
|---|---|---|---|---|---|---|---|---|---|
| 1 | General conditions | $25,000 | $10,000 | $5,000 | $0 | $15,000 | 60.0% | $10,000 | $1,500 |
| 2 | Demolition | $15,000 | $15,000 | $0 | $0 | $15,000 | 100.0% | $0 | $1,500 |
| 3 | Framing & drywall | $60,000 | $20,000 | $18,000 | $2,000 | $40,000 | 66.7% | $20,000 | $4,000 |
| 4 | Electrical | $45,000 | $10,000 | $12,000 | $3,000 | $25,000 | 55.6% | $20,000 | $2,500 |
| 5 | HVAC | $55,000 | $5,000 | $15,000 | $5,000 | $25,000 | 45.5% | $30,000 | $2,500 |
| 6 | Finishes | $50,000 | $0 | $5,000 | $0 | $5,000 | 10.0% | $45,000 | $500 |
| Totals | $250,000 | $60,000 | $55,000 | $10,000 | $125,000 | 50.0% | $125,000 | $12,500 | |
G702 Summary for the Same Application
How to Fill Out a G702 and G703 in Excel
- Build the schedule of values on the G703: one line per trade or phase, with a scheduled value that adds up to the contract sum.
- Each billing period, enter work completed this period and materials presently stored for every line. Work from previous applications carries forward.
- Column G (completed and stored to date) is D + E + F; percent complete is G ÷ C; balance to finish is C − G; retainage is G × the retainage rate.
- Carry the G703 totals to the G702: total completed to date, retainage, and total earned less retainage.
- Subtract what was certified on previous applications to get the current payment due, then sign and submit with lien waivers if your lender requires them.
Just need the numbers for one draw? Use the free construction draw calculator.
AIA, G702 and G703 are trademarks of The American Institute of Architects. This workbook follows the same pay application layout and math but is not an official AIA Contract Document; if your contract requires the official form, obtain it from AIA Contract Documents.
Frequently Asked Questions
Does this template require enabling macros or VBA code?
No. All Datasheetly templates are 100% macro-free (.xlsx). They rely on native modern Excel formulas (XLOOKUP, SUMIFS, LET), never trigger antivirus blocks, and are completely safe for corporate computers.
Are there any recurring subscriptions or extra fees?
None whatsoever. You make a single one-time payment of $9 and own the DRM-free Excel workbook files forever. No monthly recurring charges, no per-seat fees, and no cloud lock-in.
What software versions are required to run this workbook?
Datasheetly workbooks are engineered for modern Microsoft Excel: Microsoft 365 (Windows & Mac), Microsoft Excel 2021+, and Excel for Web (free online via office.com with any Microsoft account). Because our models leverage modern dynamic array formulas (LET, XLOOKUP, FILTER, SUMIFS) and native Excel structured tables, they are designed exclusively for Excel. Older legacy releases (Excel 2019/2016) and third-party spreadsheet viewers do not support these modern formula engines.
Do I receive clean blank files for my company data?
Yes! In your download vault, you receive two separate workbooks: a Sample Data Workbook (with realistic pre-filled rows to inspect formulas) and a Clean Blank Workbook (with all formulas and formats ready for your live data).
What if the template doesn't meet my business needs?
Every purchase is backed by our 30-Day Defect & Satisfaction Guarantee. If any formula fails or the template does not perform as documented, simply contact support for an immediate resolution or refund.
Customer Reviews & Ratings
Real feedback from verified purchasers and small business operators.
Be the First to Review This System
Tested this workbook in your company operations? Share your review or formula suggestions directly with our engineering team to help fellow operators.
Datasheetly spreadsheet workbooks and templates are operational productivity calculation tools provided for informational purposes only. They do not constitute certified public accounting (CPA), legal, tax, or medical advice. Templates are not certified or intended for the storage of protected health information (PHI) under HIPAA regulations or fiduciary client trust accounts without independent compliance review. Users are advised to review all financial and operational outputs with a licensed CPA, attorney, or qualified professional before taking formal financial or operational actions.