Extract data from pay applications
A pay application is the monthly invoice a contractor submits to get paid for work put in place, and on most jobs it is the AIA G702 Application and Certificate for Payment with a G703 continuation sheet behind it. Owner, architect, and lender read the same numbers before releasing funds: the contract sum to date, the work completed this period and to date, the retainage held back, and the current payment due. Behind it, the G703 breaks the contract down by line item and column, so the architect can certify that the percentages complete are real before signing the certificate for payment. Progress billing is a chain of arithmetic that has to foot. On application number 6 for the period ending 2026-06-30, an original contract sum of $2,800,000 plus $45,000 in net change orders gives a contract sum to date of $2,845,000. Continuation-sheet line items report $2,060,000 completed and stored to date: the $1,610,000 completed and stored through prior periods, plus $395,000 of work completed this period and $55,000 of newly stored materials. At 5% retainage the held-back amount is $103,000, leaving $1,957,000 earned less retainage. Subtract the $1,529,500 certified on prior applications and the current payment due is $427,500, with a balance to finish, including retainage, of $888,000. Reading the G702 and its G703 continuation, Talonic returns the project, contractor, owner, and architect, the contract sum to date, the totals completed and retained, and the current payment due as fields, and keeps the schedule of values as a table whose columns foot to the summary. Ironwood Builders Inc. billing Cedar Commons Housing Partners LP for Cedar Commons Apartments, Building C, at 410 Industrial Parkway, Columbus, Ohio, certified by Halvorsen Design Group, loads into an accounts-payable and lien-waiver workflow as structured data. Captured labels are the publicly-described ones, not the copyrighted AIA form text, and the payment itself is never certified.
What gets extracted from pay applications
How extraction works for pay applications
Signed G702 forms arrive with a G703 continuation behind them, alongside accounting-system exports and scanned certificates, and the continuation-sheet columns are numbered but rarely aligned the same way twice. Talonic maps the application to the pay-application schema in the Field Registry, which follows the G702 summary and the G703 columns so the contract sum to date, the total completed and stored, the retainage, and the current payment due each resolve to their own figure. Line items on the continuation sheet keep a scheduled value, work completed in previous and current periods, materials stored, and a balance to finish, checked so the columns foot: previous plus this period equals the total completed and stored, and total earned less retainage minus prior certificates equals the current payment due. Retainage is split into a percentage and an amount, and the balance to finish on the summary includes retainage while the same figure on the continuation sheet excludes it, differing by exactly the retainage held. Provenance travels with every value as a confidence reading and a pointer to the source line under DIN SPEC 91491, so an owner can trace the current payment due back to the line items before releasing funds. Publicly-described labels are read, not the copyrighted AIA text, and the amount due is never certified.
Sample extraction
AIA G702 application number 6 with its G703 continuation sheet
{
"document_number": "6",
"document_date": "2026-07-05",
"period_from": "2026-06-01",
"period_to": "2026-06-30",
"project_name": "Cedar Commons Apartments, Building C",
"project_location": "410 Industrial Parkway, Columbus, OH 43215",
"contractor_name": "Ironwood Builders Inc.",
"owner_name": "Cedar Commons Housing Partners LP",
"architect_name": "Halvorsen Design Group",
"original_contract_sum": 2800000,
"net_change_by_change_orders": 45000,
"contract_sum_to_date": 2845000,
"total_completed_and_stored_to_date": 2060000,
"work_completed_this_period": 395000,
"retainage": 103000,
"retainage_percentage": 5,
"total_earned_less_retainage": 1957000,
"less_previous_certificates": 1529500,
"current_payment_due": 427500,
"balance_to_finish": 888000,
"percent_complete": 72.4,
"schedule_of_values": [
{
"item_number": "03",
"description_of_work": "Concrete",
"scheduled_value": 480000,
"work_completed_previous_periods": 480000,
"work_completed_this_period": 0,
"materials_presently_stored": 0,
"total_completed_and_stored": 480000,
"percent_complete": 100,
"balance_to_finish": 0,
"retainage": 24000
},
{
"item_number": "05",
"description_of_work": "Metals",
"scheduled_value": 520000,
"work_completed_previous_periods": 470000,
"work_completed_this_period": 40000,
"materials_presently_stored": 0,
"total_completed_and_stored": 510000,
"percent_complete": 98.1,
"balance_to_finish": 10000,
"retainage": 25500
},
{
"item_number": "06",
"description_of_work": "Wood and plastics",
"scheduled_value": 610000,
"work_completed_previous_periods": 300000,
"work_completed_this_period": 120000,
"materials_presently_stored": 30000,
"total_completed_and_stored": 450000,
"percent_complete": 73.8,
"balance_to_finish": 160000,
"retainage": 22500
},
{
"item_number": "09",
"description_of_work": "Finishes",
"scheduled_value": 735000,
"work_completed_previous_periods": 150000,
"work_completed_this_period": 95000,
"materials_presently_stored": 0,
"total_completed_and_stored": 245000,
"percent_complete": 33.3,
"balance_to_finish": 490000,
"retainage": 12250
},
{
"item_number": "23",
"description_of_work": "Mechanical (HVAC)",
"scheduled_value": 500000,
"work_completed_previous_periods": 210000,
"work_completed_this_period": 140000,
"materials_presently_stored": 25000,
"total_completed_and_stored": 375000,
"percent_complete": 75,
"balance_to_finish": 125000,
"retainage": 18750
}
],
"change_order_log": [
{
"change_order_number": "CO-004",
"change_order_date": "2026-06-12",
"description": "Added corridor fire-rating assembly",
"amount": 45000,
"days_added": 5,
"approved_by": "Architect"
}
]
}Frequently asked
Does the current payment due foot to the schedule of values?
Yes. The G703 line items sum to $2,060,000 completed and stored; less 5% retainage of $103,000 leaves $1,957,000 earned less retainage; less the $1,529,500 certified on prior applications, the current payment due is $427,500.
How is retainage handled?
The retainage percentage and the retainage amount are kept as distinct figures, and per-line retainage foots to the total held. The balance to finish on the summary includes retainage ($888,000) while the same figure on the continuation sheet excludes it ($785,000), differing by exactly the $103,000 held.
Does it separate this-period from to-date amounts?
Yes. Work completed this period and work completed to date are captured as distinct figures, checked so the previous $1,610,000 completed and stored, plus $395,000 of work completed this period and $55,000 of newly stored materials, equals the $2,060,000 completed and stored to date.
Does Talonic certify the payment?
No. Talonic returns the applied amounts as written and does not act as the certifying architect or judge whether the work claimed was actually performed.
Ready to extract from your own pay applications?
Author note
Reviewed by Talonic engineering, construction schema review · last reviewed 2026-07-08