A subcontractor builds a schedule of values that splits the subcontract sum into billable lines, then each month reports percent complete per line, adds stored materials and approved change orders, and deducts retainage. AI can read the subcontract's billing rules and check the logic, but the arithmetic belongs in a spreadsheet, and the contract decides every requirement.
Pay applications get bounced for dull reasons: a schedule that does not add up to the contract sum, a percentage that went backwards, a change order billed before it was approved, stored materials with no paperwork. None of that needs clever software. It needs the payment clause read first, a clean spreadsheet and a second pair of eyes, which is the job AI does well.
The two documents behind every pay application
A pay application has a summary page and a continuation sheet. The summary is the G702 pattern: a handful of lines that take the contract sum to a payment due. The continuation sheet is the G703 pattern: one row per line of the schedule of values, with columns for what has been billed and what remains. Many contracts require their own version of these forms or an online system, but the fields are almost always the same, so learning them once covers every format.
AIA's instruction pages for the continuation sheet define columns A to I. The table restates them in plain words, and the quoted rules come from AIA's G703 instructions and its subcontractor-version instructions.
| Column | What it holds | Rule from the instructions |
|---|---|---|
| A and B | Item number and description of each portion of the work | Completed with column C when you set up the schedule |
| C | Scheduled value of each line | Initially the total should equal the original contract sum |
| D | Work completed in earlier applications | Carried forward from the previous application |
| E | Work completed this period | Includes stored materials that have now been installed |
| F | Materials presently stored | Stored materials for which payment is sought |
| G | Total completed and stored to date | D + E + F; percent complete is G divided by C |
| H | Balance to finish | C minus G |
| I | Retainage | Normally used only where variable retainage applies line by line; not needed for a constant rate on the whole contract |
The summary page then works down nine lines: original contract sum, net change by change orders, contract sum to date, total completed and stored to date, retainage, total earned less retainage, less previous certificates for payment, current payment due, and balance to finish including retainage. AIA's G702 instructions have the continuation sheet's totals transferred to the summary, so the two pages must agree, and the previous-certificates line should match what was actually approved last time. The retainage rate comes from your contract, and rules on retainage differ from place to place, so ask an adviser if the contract leaves it unclear.
The Complete Excel Course with AI Integration
From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.
By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner
Buy nowRead the payment clause before you open a spreadsheet
Every pay application is built to a set of rules that live in the subcontract, not in any form. Two firms using the same form can have completely different obligations. Before you build anything, find the answers to the questions in this table and write them on one page.
| What to find | Why it changes the application |
|---|---|
| Billing date and cut-off date | Decides which work you may claim and when the application is due |
| Required form or online system | Some contracts name the form, others a portal, and a wrong format is a common reason for return |
| Who approves the schedule of values, and when | The first application usually cannot go in until the schedule is accepted |
| Retainage rate and the trigger for release | Sets one of the nine summary lines and your cash timing |
| Rules on stored materials | Whether you can claim them, with what proof, and whether insurance is needed |
| Change order approval rule | Decides whether an extra can go on this month's application |
| Attachments required with each application | Lien waivers, insurance certificates and payroll records, if the contract asks for them |
| Payment terms | When the clock starts and whether you are paid only after the main contractor is |
The last row is the one that surprises people. Some subcontracts make your payment depend on the main contractor being paid first, and the wording differs between contracts in ways that matter. That is a question for a lawyer, not an AI model, and it is why the contract's terms come before any form, spreadsheet or prompt.
Build the schedule of values from your estimate, not a blank page
The schedule of values is your price, broken into lines you will bill against for the whole job. Once the main contractor accepts it, every later application draws against the same line numbers, and the values in column C do not change except through approved change orders. AIA's instructions say that, initially, the scheduled values should total the original contract sum, so the first check on any schedule is whether the lines add up to the number in the subcontract.
Start from your estimate, which already knows what the work costs. Group the estimate's cost codes into lines you can measure from site. For a drywall subcontract, a line called "Metal framing, level 1" works because a foreman can say how much is done. A line called "Labour" does not. Aim for roughly 8 to 15 lines on a job of this size. Fewer lines hide progress, and many more make every application a data-entry chore. If the main contractor supplies its own breakdown, use its line names so the two documents match.
The temptation is to front-load: to inflate early lines such as mobilisation so the first applications bill ahead of the work. Reviewers expect it and check the first schedule for it. A schedule they judge front-loaded comes back redlined, and the first payment waits while you rebuild it. A mobilisation line of 4% of the contract sum with real costs behind it is easy to defend, while 15% is not.
Change orders get their own lines. When CO-1 is approved, add a new row with its own scheduled value and track it from zero, rather than raising an existing line. That keeps the original schedule intact and makes the net change by change orders on the summary page a simple sum of those new rows.
A worked application: a $240,000 drywall subcontract, period 3
The figures are illustrative. A drywall subcontractor holds a $240,000 subcontract for a two-level office fit-out, bills monthly, and has 10% retainage withheld at a flat rate. One change order, CO-1 for a fire-rated partition at $6,400, has been approved in writing. This is period 3, and the continuation sheet looks like this.
| No. | Item (A and B) | C Scheduled | D Previous | E This period | F Stored | G Total | % (G/C) | H Balance |
|---|---|---|---|---|---|---|---|---|
| 1 | Mobilisation, submittals, insurance | 9,600 | 9,600 | 0 | 0 | 9,600 | 100% | 0 |
| 2 | Metal framing, level 1 | 30,000 | 30,000 | 0 | 0 | 30,000 | 100% | 0 |
| 3 | Metal framing, level 2 | 30,000 | 18,000 | 9,000 | 0 | 27,000 | 90% | 3,000 |
| 4 | Insulation and fire-stopping | 19,200 | 0 | 5,760 | 0 | 5,760 | 30% | 13,440 |
| 5 | Board and tape, level 1 | 36,000 | 14,400 | 14,400 | 0 | 28,800 | 80% | 7,200 |
| 6 | Board and tape, level 2 | 36,000 | 0 | 3,600 | 0 | 3,600 | 10% | 32,400 |
| 7 | Ceiling grid and tile | 38,400 | 0 | 0 | 11,520 | 11,520 | 30% | 26,880 |
| 8 | Final finishing and touch-up | 33,600 | 0 | 0 | 0 | 0 | 0% | 33,600 |
| 9 | Punch list and closeout | 7,200 | 0 | 0 | 0 | 0 | 0% | 7,200 |
| 10 | CO-1 fire-rated partition | 6,400 | 0 | 3,200 | 0 | 3,200 | 50% | 3,200 |
| Totals | 246,400 | 72,000 | 35,960 | 11,520 | 119,480 | 48.5% | 126,920 |
Lines 1 to 9 add up to the original $240,000, and line 10 takes the schedule to $246,400. Each total of column G is D + E + F, and column H is C minus G, so the balance column is a free check: 246,400 minus 119,480 is 126,920. Now the summary page.
| Summary line | Amount | How it is reached |
|---|---|---|
| Original contract sum | $240,000 | From the subcontract |
| Net change by change orders | $6,400 | CO-1 |
| Contract sum to date | $246,400 | Sum of the two lines above |
| Total completed and stored to date | $119,480 | Total of column G |
| Retainage | $11,948 | 10% of $119,480 |
| Total earned less retainage | $107,532 | $119,480 minus $11,948 |
| Less previous certificates for payment | $64,800 | $72,000 billed earlier, less 10% retainage |
| Current payment due | $42,732 | $107,532 minus $64,800 |
| Balance to finish, including retainage | $138,868 | $246,400 minus $107,532 |
One contract choice changes the answer. If this subcontract applies retainage only to work installed and not to stored materials, retainage drops to 10% of ($72,000 + $35,960) = $10,796, and the current payment due rises to $43,884, a swing of $1,152. Nothing on the form tells you which reading applies, so find it in the contract before you press send. Some contracts also lower the rate partway through, for example from 10% to 5% once the job passes 50% complete. Whether the lower rate applies to work already billed is a contract question as well.
Measuring percent complete without arguments
A percentage that cannot be traced to something on site is the first thing a reviewer questions. Pick a measuring method per line, write it down once, and use the same method every month. Three methods cover most lines.
| Line | Method | Evidence this period | Result |
|---|---|---|---|
| 3 Metal framing, level 2 | Installed quantity against budget quantity | 4,500 of 5,000 linear feet of track and studs, from the daily logs | 90% |
| 4 Insulation and fire-stopping | Count of completed items | 36 of 120 penetrations sealed, from the inspection checklist | 30% |
| 5 Board and tape, level 1 | Weighted steps: hang 40%, tape 35%, finish 25% | All 20 zones hung and taped, 4 of 20 finished: 40% + 35% + 5% | 80% |
| 6 Board and tape, level 2 | Weighted steps, same weights | 5 of 20 zones hung, none taped: 40% × 5/20 | 10% |
| 10 CO-1 partition | Share of linear feet complete | One of the two partition runs finished | 50% |
The weights for hanging, taping and finishing are the firm's own estimate of effort, agreed with the main contractor when the schedule is accepted, so changing them mid-job is a negotiation, not an editing choice. Do not bill a line at 100% until the work is complete and accepted, because a line that shows 100% while a foreman is still on site is how reviewers lose trust in everything else on the page.
Check your percentages against your own records before anyone else does. If the daily logs show framing on level 2 on only nine of 22 working days, a 30-point jump in that line needs a reason in the notes. This is a comparison job, which is where AI earns its keep, and the prompts below show how.
Stored materials and retainage: the two lines that draw queries
Stored materials sit in column F. AIA's instructions say to enter the value of materials presently stored for which payment is sought, and the amount moves to column E once the materials are incorporated into the work. The instructions also note that mere payment by the owner for stored materials does not deduct anything from column F. In plain terms, a delivered but uninstalled product stays visible on the sheet until it is installed, and it must not be counted twice.
In our example, $11,520 of ceiling grid and tile arrived on site and sits in a locked container: 30% of line 7. The documents behind it are a delivery ticket, the supplier's invoice and a dated photo of the container. Main contractors commonly ask for photos, and some contracts also want insurance certificates or proof of ownership for materials stored away from the site. Ask the main contractor early what it needs, because the answer varies by contract. Next month, as tile is installed, the installed value moves from F to E and the line's total in G stays consistent.
Retainage has two shapes. A constant rate applies to the whole contract, and the instructions say column I need not be completed in that case. A variable rate applies line by line, and column I records it. In both cases the rate and the release trigger come from the subcontract. Many subcontracts tie release to final completion, after the punch list closes, and our line 9 exists to make that moment a visible, billable event. The tutorial on tracking retainage and chasing its release with AI reminders covers the follow-up in detail.
Where AI helps check the package, and where it must stay out
An AI model reads text well and adds numbers badly, so the split is straightforward. The spreadsheet calculates, the AI compares and questions, and a person decides. Language models predict text rather than calculate, so a total that looks right can still be wrong. If you are building the sheet's formulas with a chatbot's help, the ChatGPT for Excel guide covers that side.
| Good jobs for AI | Keep AI out of |
|---|---|
| Reading the payment clause and listing every requirement, with quotes | Calculating totals, retainage or payment due |
| Comparing the application with daily logs, photo captions and the change-order log | Choosing the retainage rate or deciding when it is released |
| Flagging logic problems in an export of the sheet: percentages that fall, lines over 100%, a schedule that does not match the contract sum | Interpreting what a clause means legally, such as payment depending on the main contractor being paid |
| Drafting the cover note that explains the month's changes | Treating a verbal go-ahead as an approved change order |
| Drafting a polite follow-up when payment is late | Sending anything to the main contractor without a person reading it |
Keep names and addresses out of what you paste. Use "the main contractor" and "the project" in place of real names, and paste values, not the whole file. The tutorial on subcontractor paperwork chasing covers the wider paperwork routine that sits around each application.
Prompts: extract the rules, then audit the numbers
The first prompt turns a dense clause into a checklist before you build the application.
Read the payment clause below. Produce a checklist for preparing a monthly pay application: billing and cut-off dates, required form, schedule of values approval, retainage rate and release, stored materials, change orders, attachments, payment timing.
For each item quote the exact words of the clause. If the clause does not say, write NOT STATED. Do not interpret legal effect.
CLAUSE: [paste, with names replaced]An illustrative result, with the quotes shortened here: billing is monthly, with work counted to the 25th and the application due by the 28th; retainage is 10% of each application with release at final completion, and a reduction is NOT STATED; stored materials need the main contractor's written approval, and insurance for off-site storage is NOT STATED; each application needs a conditional lien waiver for the current period, an unconditional one for the previous period and a current insurance certificate; payment is due within seven days after the main contractor receives payment from the owner.
What to do with it: check every quote against the contract, because models can misquote. Send a written question to the main contractor about each NOT STATED item. And take the payment timing line to a lawyer if you do not fully understand it, since a clause that links your payment to someone else's has real consequences.
Check the pay application data below for internal inconsistencies. Use only the rules I list. Do not recalculate any totals; report conflicts only, with the line number.
Rules: percent complete must never fall from the previous period; no line may exceed 100%; the schedule must equal the contract sum plus approved change orders; a change order may be billed only if its approval date is on or before the cut-off date; every stored materials amount needs a document reference.
DATA: [paste the continuation sheet values, the change-order log and the daily-log summary]In an illustrative run, the model reports four things. CO-1's approval date in the log is two days after the cut-off, so billing it this period needs the main contractor's agreement. Line 7 carries $11,520 of stored materials with no document reference. Line 3 rose 30 points in the month while the daily-log summary shows level 2 framing on nine of 22 working days, so the foreman should confirm the quantity. And the previous total of $72,000 matches the last certified application, which is a pass.
Look at what the model did and did not do. It never added anything. It compared dates, references and rules, and it caught two problems a tired person at the end of the month would miss. You then fix each one in the spreadsheet, rerun the formulas and keep the changes in a short note for the cover email.
Five ways a pay application gets bounced
These are the failures that cost a month of cash. Each one shows up the same way: a short message from the main contractor and a payment that does not arrive when you expected it.
| Failure | How it shows up | Fix |
|---|---|---|
| Front-loaded schedule of values | The reviewer redlines the schedule, returns it and the next payment is delayed | Rebuild the lines from estimate costs and keep mobilisation proportionate |
| Previous period does not match the last certified application | A comment that column D differs from what was approved | Start each application from the last approved file, never from a retyped copy |
| Change order billed before it was approved | The line is struck out with "no signed change order" | Bill only approved change orders, and keep the log beside the application |
| Stored materials without paperwork | The column F amount is removed | Attach the delivery ticket, invoice and photo, and ask about insurance in advance |
| Missing attachment | The application is called incomplete, and the clock on payment may not start | Run the requirements checklist from the extraction prompt before you submit |
The last row deserves a caution. In some subcontracts the payment period runs from receipt of a complete application, so an application returned as incomplete can push the payment date back by the time it takes to fix and resubmit. Whether yours works that way is in the payment clause, which is why that clause comes first.
The final application and the release of retainage
The last application is where the money held back finally becomes billable. It usually needs more than the numbers: a completed punch list, a final lien waiver, warranties, operation and maintenance manuals and as-built drawings, if the contract asks for them. The extraction prompt already told you what the contract requires, so turn that list into a closeout checklist at the start of the job, not at the end.
For our example, suppose the job finishes with only CO-1 added, so the contract sum to date stays $246,400. Retainage held at 10% is $24,640. The final application bills the balance of the work plus that retainage, and the amount of retainage should match the total of the amounts withheld on every earlier application. A mismatch of even a small figure is worth chasing, because it usually means one earlier application used a different base. The main contractor's release of your retainage may depend on the owner releasing theirs, so put a reminder in your calendar for the date the contract says release is due, and follow up from there. The construction final account tutorial shows the wider closing arithmetic.
Cash timing: when the money actually lands
An approved application is not a payment. Suppose the period ends on the 25th, you submit on the 28th, the main contractor bills the owner five days later, the owner pays 30 days after that, and your contract pays you seven days after the main contractor is paid. The money lands about 45 days after the period ended.
That is a funding gap. If your costs run $28,000 a month, a 45-day lag means roughly $28,000 ÷ 30 × 45 = $42,000 of your own money is out at any time, before counting retainage, which stays out longer. For a small subcontractor, the gap can limit how much work it takes on more than the margin does. A forecast built from the contract's real dates shows it before it hurts. The tutorial on building a construction cash flow forecast in a spreadsheet with AI shows how, and the cost side of the same picture is in the guide to job costs, WIP and retainage checks.
Accounting software can carry some of this load. Intuit's pricing page lists a construction financials solution on the QuickBooks Online Advanced plan, which was $340 a month at regular list price. Intuit's product pages, as of October 2026, described job costing, AIA billing, change orders and WIP reports and did not mention retainage, so test it with one real application before you rely on it. A well-built spreadsheet with the checks above does the same job for a small firm at no cost, and you can move to software later with the schedule of values already in good shape.
The habit that pays off most is small. Build the schedule once from your estimate, copy each application from the last approved one, let the spreadsheet do every sum, and give the AI the comparison jobs it is good at. Do those four things and most of the bounces in the table above never happen.
Pay application questions subcontractors ask
What is the difference between a pay application and an invoice?
An invoice asks for a sum. A pay application reports progress line by line against an agreed schedule of values, shows previous billings, change orders, stored materials and retainage, and usually has to be reviewed and approved before payment falls due. Many subcontracts also require supporting paperwork, such as lien waivers and insurance certificates, with each application, so read the payment clause for the full list.
Can I bill for materials I have bought but not installed?
Only if the subcontract allows it and you can document the materials. The G703 form has a column for materials presently stored, and billing for them often needs photos and supplier invoices, and on some contracts proof of insurance for off-site storage. If the contract is silent, ask the main contractor in writing before you include stored materials in an application.
What is front-loading on a schedule of values?
Front-loading means giving early lines, such as mobilisation, more value than the work they represent, so the first applications bill ahead of progress. Reviewers look for it in the first submission, and if they find it they can redline the schedule, return it and delay the next payment. Build lines from your estimate's real costs and keep mobilisation proportionate.
Can ChatGPT fill in a G702 or G703 for me?
It can explain the form, draft a cover note and check your sheet for logic errors, but it should not calculate the figures. Do the arithmetic in a spreadsheet with formulas, check it, and then ask the AI to look for inconsistencies. Use whichever form your main contractor requires, because many contracts name a specific form or electronic system.
Further reads
- Construction Payment Notice Template: Draft With AI, Check the Deadlines — Notices and deadlines when a payment runs late.
- AI Tools for Contracting Businesses: Subcontracts and Change Orders — Subcontract and change-order tools for a contracting business.
- Construction Job Costing With AI: Find Which Jobs Actually Made Money — Check whether each job actually made money.
- Electrical Change Orders Written With AI: Ask for Extra Work Clearly — Write change orders that get approved before the work.
- General Contractor AI: Turn Site Messages Into Change Orders — See change orders from the main contractor's side.
- AI for Building Contractors: Chasing Subcontractors and Progress Updates — What the main contractor chases subcontractors for.
- Best AI for a Small Construction Company's Financials and QuickBooks — Accounting software choices for a small construction firm.
- CIS Deduction Statement Template: Fill It From Your Payment Sheet With AI — The fields, the 14-day deadline and a payment-sheet method for a CIS deduction statement per subcontractor each month, with AI doing the checking.
- Lien Waivers for Small Contractors: Track Conditional and Final Releases — A three-tab sheet that matches each conditional and final lien waiver to the payment it covers, with red-flag formulas and a worked HVAC example.
- Painting Invoice Template: Deposits, Progress Billing and Chasing With AI — Deposit, stage and final invoices for a painting job, with change-order lines and a reminder ladder that AI helps you write.
- Paving Contract Template: Payment, Base and Weather Clauses With AI — Payment-stage, base-condition, weather and warranty clauses for a paving job, plus prompts that give a lawyer a usable first draft.
- Subcontractor Management: Track Insurance Expiry and Onboarding With AI — A document pack checklist, an expiry tracker with working formulas and four reminder emails, with AI reading certificates and a person approving them.
- Can ChatGPT Draft a Subcontractor Agreement? Clauses to Check — Drafting prompts for a subcontractor agreement in ChatGPT, plus the six clauses a solicitor must check before you rely on it.
- Pay When Paid Clause: A Subcontractor's Check Before Signing — A subcontractor's pre-signing checklist for pay-when-paid clauses, with a cash-flow example and a sample clause review.
- AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.
Sources: AIA Contract Documents instruction pages for the G702 application and the G703 and G703S continuation sheets; Intuit's QuickBooks Online pricing and construction pages.