AIA G702 and G703 Data Extraction for Subcontractor Pay Applications to Excel

Subcontractor pay applications arrive as PDFs and scans. Upload them below and get the G702 summary and every G703 schedule of values line as rows in Excel or CSV, ready to check against your budget before you approve payment.

Accepts PDF, JPG, PNG, BMP, HEIC and TIFF

Upload your receipts and invoices

G702 lines 1 to 9 and G703 columns A to G
Retainage and change orders kept
Up to 50 pay apps per upload

Why Pay Application Review Eats the Last Week of Every Month

Every subcontractor on a commercial job bills on the same AIA form, filled out in a different PDF editor, a different spreadsheet or by hand. The project accountant retypes the numbers into Excel, Sage or a draw spreadsheet before anyone can check them, and the deadline for the owner billing does not move.

Thirty Subs, Thirty Layouts of the Same Form

The AIA document is standard, the files are not. One sub prints G703 from a spreadsheet, another fills a PDF form, a third scans a handwritten copy from the job trailer. Template based tools break on the variation.

The Schedule of Values Is the Slow Part

A G702 is one page. The G703 continuation sheet behind it can run to dozens of lines across several pages, each with scheduled value, previous work, this period, stored materials and retainage. That is where the keying time goes.

Overbilling Hides in Percent Complete

A line billed at 80 percent when the work in place is closer to 60 is only visible when the numbers sit next to your own budget and the last approved application. On paper it slips through.

Totals That Do Not Tie Out

The G703 column totals should equal the G702 summary lines. When a sub edits one page and not the other, the mismatch is invisible until somebody adds it up by hand.

Subs Will Not All Use the Portal

Pay application portals work when every sub adopts them. Smaller trades push back on per contract fees and logins, so the GC keeps receiving PDFs by email anyway.

Lenders and Owners Want the Same Data Again

The draw request to the construction lender or owner needs the same line detail rolled up. Retyping it a second time doubles the chance of an error in the one document that releases money.

From a Stack of Pay App PDFs to One Reviewable Spreadsheet

ReceiptOCR reads each pay application with a field set built for contractor billing. You get the G702 summary as one row per application and the G703 schedule of values as line rows, shown beside the source page so you can correct anything before export.

The Whole G702 Summary

Original contract sum, net change by change orders, contract sum to date, completed and stored to date, retainage percent and amount, previous certificates, current payment due and balance to finish.

Every G703 Line as a Row

Item number, description of work, scheduled value, work completed from previous applications, this period, materials presently stored, total completed and stored, percent complete and retainage.

Change Orders Kept Separate

Lines that are change orders carry their change order number in their own column, so you can filter base contract work from approved changes.

PDFs, Scans and Photos

Pay apps exported from accounting software, filled PDF forms, scanned signed copies and phone photos from the field are all read. Long continuation sheets stay in one record.

A Month of Pay Apps in One Batch

Upload up to 50 files at once, one pay application per file, and download a single spreadsheet with one summary row per subcontractor.

Review Before Export

Every extracted value sits next to the page it came from. Fix a smudged figure once and the corrected value is what lands in Excel or CSV.

Why Choose ReceiptOCR?

  • No templates to build per subcontractor
  • Works on the AIA form and on contractor made look alikes with the same columns
  • Excel and CSV downloads for Sage, Procore imports or your draw spreadsheet
  • Starter is $49 a month, or $288 a year billed yearly
  • Priced by pages processed, never per project or per subcontractor

How to Extract AIA G702 and G703 Data to Excel

Four steps. Plan your time around the review, not the upload.

1

Choose the Contractor Invoices Field Set

In your account pick the ready made field set named Construction and Contractor Invoices. It tells the engine to look for contract sums, change orders, retainage and schedule of values columns.

2

Upload the Pay Applications

Drop in one pay app or up to 50 files at once, each file holding the G702 and its G703 continuation pages. PDFs, scans and photos all work.

3

Review the Summary and Lines

Check the G702 totals and each G703 line against the page. Look hardest at percent complete on the lines you would question on a site walk.

4

Export to Excel or CSV

Download the batch as a spreadsheet with summary rows and line rows, then compare it with your budget and the last approved application before you certify payment.

AIA G702 and G703 Data Extraction in Detail

What comes out of each form, what you still check, and how this compares with the other ways contractors handle pay apps.

General Contractor Project Accountants

You receive pay apps from every trade each month and need them in one spreadsheet to review and roll into the owner billing.

Construction Lenders and Draw Reviewers

You check each draw request against the schedule of values and need the line detail of every sub pay app without retyping it.

Owner Representatives

You approve the GC application and want the sub level detail behind it in a form you can sort, filter and compare month to month.

Construction CPAs and Bookkeepers

You track billings, retainage receivable and payable across several jobs for contractor clients who send you PDFs.

Short answer: AIA G702 and G703 data extraction reads a subcontractor pay application, takes the summary figures from the G702 Application and Certificate for Payment and every schedule of values line from the G703 Continuation Sheet, and writes them as spreadsheet rows. ReceiptOCR does this for PDFs, scans and photos in batches of up to 50, with every value shown beside its source page for review, from $49 a month.

What data is on an AIA G702 and G703?

The G702 is the one page summary the contractor signs and the architect certifies. The G703 continuation sheet is the schedule of values behind it, one line per item of work. The extraction maps them like this.

Form and lineWhat it holdsExtracted as
G702 line 1Original contract sumOriginal Contract Sum
G702 line 2Net change by change ordersNet Change Orders
G702 line 3Contract sum to date, line 1 plus or minus line 2Contract Sum To Date
G702 line 4Total completed and stored to date, the column G total on the G703Completed To Date
G702 line 5Retainage on completed work and on stored materialRetention Percent and Retention Amount
G702 line 7Less previous certificates for paymentPrevious Certificates
G702 line 8Current payment dueCurrent Payment Due
G702 line 9Balance to finish, including retainageBalance To Finish
G703 columns A and BItem number and description of workItem Number, Description, Change Order Number
G703 column CScheduled valueScheduled Value
G703 columns D and EWork completed from previous application and this periodPrevious Work Completed, This Period
G703 column FMaterials presently stored, not in D or EMaterials Stored
G703 column G and percentTotal completed and stored to date, D plus E plus F, and G divided by CCompleted And Stored To Date, Percent Complete
G703 column IRetainage, when the rate varies by lineRetainage

Two figures are not separate fields, on purpose. G702 line 6, total earned less retainage, is line 4 minus line 5, and G703 column H, balance to finish, is column C minus column G. Both are one formula in the spreadsheet, and computing them yourself is a free check that the printed numbers are consistent. The header also gives you contractor, application number, application date, period to, project name and number, and contract or PO number.

How do you check a pay application after extraction?

With the lines in a spreadsheet, the review that used to take an afternoon becomes a few filters. These are the checks project accountants and draw reviewers run first.

  • G703 ties to G702. Sum column G across the lines and compare it with G702 line 4. Do the same for retainage against line 5. A difference means a page was edited without the other.
  • Previous matches last month. Column D on this application should equal column G on the last approved one, line by line. A jump means work was rebilled or the sub reset a line.
  • Percent complete against the field. Sort by percent complete and compare the high lines with what the superintendent reports. Front loaded billing on early trades shows up here.
  • Stored materials have backup. Every nonzero column F should come with an invoice or a bill of sale and proof of insurance or storage, depending on your contract.
  • Retainage at the contract rate. Divide the retainage by completed work per line. A line held at 5 percent on a 10 percent contract is easy to spot in a column and easy to miss on paper.

Ways to get pay application data into a spreadsheet compared

RouteStarts fromWhat it costs youBest for
Retyping into Excel or your accounting systemThe PDFStaff time, every line and every month, and the typos that come with itA handful of subs on one small job
A pay application portal that subs bill throughSubs entering their own data in the portalPlatform fees, often charged per contract or per project, plus the work of getting every sub onboardedLarge GCs that can require every trade to use it
Native export from the sub billing softwareA file from each subAsking every sub for a spreadsheet in your format, and getting it from someSubs that already bill from construction accounting software
ReceiptOCR AIA G702 and G703 data extractionThe PDF, scan or photo the sub already sends$49 a month for 2,500 pages on Starter, $149 for 10,000 on PlusGCs, lenders and owner reps who receive pay apps as files

If every subcontractor on your jobs already bills through a portal, you have structured data and do not need extraction. Most mid size GCs live somewhere in between: the larger trades use the portal and the smaller ones email PDFs. Extraction covers the PDFs, so the whole month ends up in the same spreadsheet.

How many pay applications does a plan cover?

Plans count pages. A typical pay application is one G702 page plus one to four G703 pages. At four pages each, Starter at 2,500 pages a month covers about 600 pay applications, and Plus at 10,000 pages covers about 2,500. A single file on Starter can run to 25 pages, which fits all but the longest continuation sheets. For supplier invoices and material receipts on the same jobs, the construction invoice processing page covers the field set for those, and contractors tracking their own job costs use the construction expense tracker.

Does it work on pay applications that are not the official AIA form?

Yes. Many subs bill on their own spreadsheet that copies the AIA columns, or on a lookalike exported from accounting software. The engine reads by meaning, not by position, so a sheet titled Continuation Sheet with scheduled value, previous, this period, stored and retainage columns extracts the same way. Pay applications that use a different structure entirely, such as unit price billing with quantities and unit rates, are better handled with your own template, which you can define on any paid plan.

What the Extraction Guarantees and What It Leaves to You

9
G702 Summary Lines Covered
50
Pay Applications per Batch Upload
$49
Starter Plan per Month, No Per Project Fee

Security & Privacy

  • Every value is read from the pay application and shown beside its source page
  • Change order lines keep their change order number in a separate column
  • Computed figures such as balance to finish are left to your formulas, so you can check the sub math
  • The extraction never certifies payment. Approval stays with the architect, owner or lender

AIA G702 and G703 Data Extraction FAQ

Yes. AI extraction reads the G702 summary and each G703 line from PDFs, scans and photos, including forms filled in different editors. ReceiptOCR returns them as Excel or CSV rows with every value shown beside the page for review. Clean digital PDFs read best; faint scans of handwritten forms need a closer review.

Upload the pay application PDF with the Construction and Contractor Invoices field set selected, review the extracted lines, and download Excel. Each G703 line becomes a row with item number, description, scheduled value, previous work, this period, stored materials, total to date, percent complete and retainage.

The G702 is the Application and Certificate for Payment, a one page summary of contract sum, change orders, work completed, retainage and payment due. The G703 is the Continuation Sheet, the schedule of values that breaks the totals down line by line. The G703 column totals feed the G702 summary.

Yes. Upload up to 50 files in one batch, one pay application per file, and download a single spreadsheet with a summary row for each application and line rows for each schedule of values. Plans count pages, so a four page pay app uses four pages of your allowance.

Yes, scans and phone photos are read, including handwritten figures on a printed form. Accuracy drops with faint, skewed or photocopied pages, so review those lines against the image before export. Asking subs for a digital PDF is still the best way to reduce review time.

The export is Excel or CSV. Most teams paste or map that file into their own import template or draw spreadsheet. ReceiptOCR does not connect directly to Sage 300 CRE or Procore, so the last step is a file import you control.

It extracts both sets of numbers so you can check them in one step. Sum column G and the retainage column and compare them with G702 lines 4 and 5. Totals are read as printed, never forced to match, so a sub that edited one page and not the other shows up.

Yes. Lenders and draw inspectors use the same extraction to turn the GC application and the sub pay apps behind it into rows, then compare percent complete and stored materials with the inspection report before releasing funds.

The Construction and Contractor Invoices field set is included on every paid ReceiptOCR plan. Starter is $49 a month, or $288 a year billed yearly, for 2,500 pages. Plus is $149 a month for 10,000 pages. There is no per project or per subcontractor fee.

Stop typing receipts by hand

Upload your receipts and invoices and get a clean Excel or CSV file in minutes.

Extract my receipts now

Free to try, no sign up required