Pay apps in from every sub, line items out

Construction pay applications to Excel, every line item.

Thirty subcontractors send AIA G702/G703 pay apps as PDFs, scans and photos. ParserBee reads every one and gives you one row per schedule of values line, with the G702 totals, ready to check in your own spreadsheet.

25 pages free
One row per G703 line
Scans and photos too
Line items from AIA G702/G703

How do I get line items from AIA G702/G703 pay applications into Excel?

Build one pay application Parser Template from a sample, then upload every subcontractor's pay app and download one Excel file. Each G703 line becomes a row; the G702 totals sit on the first row of each pay app.

  • Contractor, application number, period and project
  • All nine G702 lines, from contract sum to balance to finish
  • Every G703 line, across every page of the continuation sheet
  • Change order lines and stored materials kept apart
From app no. 6 to app no. 7

How a construction pay application adds up, line by line.

Each month a subcontractor adds this period's work and stored materials to every G703 line, takes off retainage, and the result has to match line 8 of the G702. ParserBee reads every one of these numbers into your sheet, so you check the math instead of typing it. Build the template from one pay app, then run the month's stack in Data Lab, up to 100 files at once.

Billing week

Thirty subcontractors, one billing week, every number keyed in by hand.

Most pay application software either helps subcontractors create pay apps or runs a portal that every subcontractor must bill through. If your pay apps still arrive as PDFs, the numbers still have to reach your spreadsheet before anyone can check them.

Hundreds of numbers per pay app

A G703 with 25 lines has nine columns of figures. Thirty subcontractors on a job means thousands of values to key in every month.

Every sub sends it differently

A clean AIA PDF from one, a scan with handwritten figures from another, a spreadsheet printed to PDF from a third.

The math has to tie

The G703 total must match line 4 of the G702, and this month's previous column must match last month's approval. Checking by eye is slow.

G702 lines and G703 columns

Every box on the AIA forms, mapped to a column in your sheet.

Line numbers and column letters as printed on AIA's G702 and G703 (1992 editions). The field names are what the AI typically proposes; rename them to match your own sheet.

G702 lineOn the formField
1Original contract sumoriginal_contract_sum
2Net change by change ordersnet_change_orders
3Contract sum to datecontract_sum_to_date
4Total completed and stored to datetotal_completed_stored
5Retainage (5a completed work, 5b stored material)retainage_total
6Total earned less retainagetotal_earned_less_retainage
7Less previous certificates for paymentprevious_certificates
8Current payment duecurrent_payment_due
9Balance to finish, including retainagebalance_to_finish
G703 columnOn the formField (one row per line)
AItem numberline_items.item_number
BDescription of workline_items.description
CScheduled valueline_items.scheduled_value
DWork completed, from previous applicationline_items.previous_application
EWork completed, this periodline_items.this_period
FMaterials presently storedline_items.materials_stored
GTotal completed and stored to date (D + E + F)line_items.total_to_date
G ÷ CPercent completeline_items.percent_complete
HBalance to finish (C - G)line_items.balance_to_finish
IRetainage, where the rate varies by lineline_items.retainage
Before you approve

Automate pay app review with five checks.

ParserBee reads the numbers; the checks run where your job costs already live, in Excel, Google Sheets or your ERP after a CSV import. With every line in the same columns, each check below is one formula, and together they catch the math errors that get a pay app sent back.

  • Each line adds upprevious + this period + stored = total to date
  • G703 ties to the G702sum of line totals = G702 line 4
  • Previous matches last monthprevious = last month's previous + this period
  • Retainage is at the contract rateline 5 = rate x (D + E) + rate x F
  • No line billed past 100%total to date <= scheduled value
Pay application construction tools

Construction pay application software, or a reader for the pay apps you already get?

Pay app portals such as GCPay run the whole submit, approve and pay cycle, but every subcontractor has to bill through them. ParserBee reads the pay apps you already get. Portal facts from GCPay's and Siteline's own websites, checked November 2026. Check their sites for current terms.

Pay app portalTyping into Excel
Who uses itParserBeeThe GC, owner, lender or accountant who receives pay appsPay app portalSubcontractors submit, the GC reviews and paysTyping into ExcelWhoever has time this week
What subs must changeParserBeeNothing. They keep sending PDFs, scans or photosPay app portalEvery sub signs up and bills through the portalTyping into ExcelNothing
Line items in ExcelParserBeeYes, one row per G703 line, from every subPay app portalFrom the portal's own reports and exportsTyping into ExcelYes, typed by hand
Approvals, lien waivers and paymentsParserBeeNo. Those stay in your current processPay app portalYes, the main job of these toolsTyping into ExcelNo
Set-upParserBeeOne sample pay app, about 20 secondsPay app portalA rollout to every subcontractorTyping into ExcelNone
PriceParserBeeFrom $29 a month for 250 pages; 25 pages freePay app portalCustom quote (GCPay and Siteline publish no prices)Typing into ExcelStaff hours
Pick something else if

Three jobs a pay app portal does better.

You are the subcontractor

To create and submit pay apps, use pay app software such as Siteline or the GC's own portal. ParserBee reads pay apps; it does not fill them in.

Every sub already bills in a portal

If all your subcontractors submit through GCPay, Procore or a similar portal, the line items are already data. Export them from there.

You need approvals and payments

ParserBee does not route approvals, collect lien waivers or pay anyone. It feeds the spreadsheet or system where you do that.

Pay app rows go to
ExcelCSVGoogle SheetsAirtableZapierMaken8nYour ERP, via CSV importREST API
The rest of the job file

Sub invoices, COIs and delivery tickets from the same jobs.

83 ready-made document parser templates across 16 industries. Building your own app? The document parsing API returns the same fields as JSON.

Subcontractor invoices

Supplier and sub invoices with every line, for job costing.

Invoice OCR software →

Certificates of insurance

Insurer, policy numbers, limits and expiry dates for every sub.

Certificate of insurance tracking →

Delivery tickets

Supplier, items and quantities delivered to site.

Delivery note data extraction →

Work orders

Job, location, tasks and sign-off from paper work orders.

Work order data extraction →

Timesheets

Crew hours by day and job from scanned timesheets.

Timesheet data extraction →

Vendor quotes

Bid line items side by side before you award a package.

Vendor quote data extraction →
FAQ

Construction pay application questions

Get next month's pay apps into one spreadsheet.

Try ParserBee free for 25 pages. No credit card. Build your pay application template from one sample in about 20 seconds.