Pay application checker
Paste your continuation sheet, type the G702 summary lines, and see exactly which figure your GC will kick back, before you send it. Free, no signup, nothing uploaded.
Check a pay application
Select the rows in Excel or Google Sheets, from column A to column I, copy and paste here. Expected order: item, description, scheduled value (C), from previous application (D), this period (E), materials presently stored (F), and optionally total completed (G), %, balance to finish (H) and retainage (I). Header rows are ignored and a “Grand total” row is checked against the lines.
2. Application summary (G702-style). Fill in what's printed on your application; leave a line blank to skip it.
What it checks
A G702/G703-style pay application is over-determined: almost every figure can be worked out from the others. That is what makes it easy for a GC or architect to spot a mistake, and it's what this checker uses. It recomputes:
- Every line of the continuation sheet: G = D + E + F, H = C − G, and the % column = G ÷ C at the precision you printed.
- Retainage on each line (column I) at the rates you enter: the work rate × (D + E) plus the stored rate × F.
- The grand total row against the sum of the lines above it, column by column.
- The summary: line 3 = 1 + 2, the column C total = line 3, line 4 = the column G total, 5a and 5b at your rates, 5 = 5a + 5b, line 5 = the column I total, 6 = 4 − 5, 8 = 6 − 7 and 9 = 3 − 6.
- Lines billed over 100% of their scheduled value and negative stored materials.
Each printed figure is checked against the printed figures it comes from, so one wrong number shows up once instead of breaking everything below it. A difference that divides evenly by 9 is flagged as a possible swapped-digit typo.
Why a few cents matter
Retainage can be rounded on the job total or line by line, and the two methods can differ by a few cents. If the G702 page uses one and the continuation sheet the other, line 5 won't equal the column I total, and many GCs send the whole application back. That can mean another month before you're paid. When line 5a matches one method, the checker says which, so you can make column I match. For other common reasons pay apps get rejected, see why pay applications get rejected.
What it doesn't do
It checks arithmetic, not your contract. It can't know whether a line's percent complete is right, whether stored materials are allowed on your job, or what retainage rate your subcontract or state law sets. Line 7 has to come from your last approved certificate. If your contract sets a different retainage rate on some lines, the column I check will flag those lines; ignore it there.
Fixing it for next month
The checker finds the problem; it doesn't rebuild the sheet. Drawsheet builds the G702/G703-style application from your schedule of values. It recalculates as you type and rounds retainage once so column I always adds up to line 5. It also prints both pages. Building and checking are free at any size, and printing is free up to 15 lines. Pro ($12 for 7 days, $24/month or $199/year) adds every line up to 3,000, the Excel workbook and one-click next month. See pricing.
General information, not legal or accounting advice. Your contract decides retainage, stored-materials and change-order rules.
FAQ
Is my pay application uploaded?
No. The checker is JavaScript running in this browser tab. What you paste is never sent to us or anyone else, and nothing is saved. Reloading the page clears it.
Does it work with the official AIA G702 and G703?
Yes. It checks the numbers, not the form. Copy the figures from an AIA document, a GC's own form or your own spreadsheet, as long as it uses the same columns (C to I) and summary lines (1 to 9). AIA, G702 and G703 are trademarks of The American Institute of Architects, which is not affiliated with Drawsheet.
Why does it say line 5 should equal the column I total?
On a G702/G703-style application the retainage on the summary page is the retainage on the continuation sheet. If they differ, even by cents, the two pages disagree. It's usually rounding: retainage worked out on the job total on one page and line by line on the other.
My sheet has no % column or no column I. Is that OK?
Yes. The checker detects a % column after G from the % signs. Leave out G, %, H or I and it skips those checks and works them out from C, D, E and F.
Can I paste a CSV instead?
Yes. Comma-separated rows work too. Put amounts that contain thousands commas in quotes, as Excel does when it saves a CSV. Copying straight from Excel or Google Sheets is easiest.