AIA G703 & Progress Billing Extraction

Schedule of Values OCR: Convert AIA G703 to Excel and CSV

DocuOCR reads the schedule of values on an AIA G703 continuation sheet and pulls every line item, scheduled value, work completed, materials stored, percent complete, balance to finish, and retainage into a clean Excel, CSV, or JSON file, so reviewing a pay application takes minutes instead of an afternoon of retyping.

Built for the G703 schedule of values you receive and have to check, not a blank template to fill out.

  • AIA G703 and custom SOV layouts
  • One row per line item, columns intact
  • Percent complete, materials, retainage
  • Export to Excel, CSV, or JSON
Upload a G703, no signup

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload a document to extract

Drop in a schedule of values to see the line items DocuOCR pulls out, ready to export to Excel.

SOC 2 Type II
256-bit encryption
US data handling
Confidence scores
AIA G703
plus custom schedule of values layouts
Scanned
OCR for faxed or photographed sheets
Line by line
every SOV item read individually
Retainage
percent and stored materials kept separate

// In short

Schedule of values OCR reads the itemized cost breakdown on an AIA G703 continuation sheet and turns it into structured data. DocuOCR extracts every line item, the description of work, scheduled value, work completed from previous applications, work completed this period, materials presently stored, total completed and stored to date, percent complete, balance to finish, and retainage, then exports them to Excel, CSV, or JSON so a general contractor, owner, project manager, or lender can review a pay application in minutes. It reads the schedule of values you receive; it does not generate a blank SOV template.

// How it works

How to convert a schedule of values to Excel

Upload, read, review, export. No template to build, no retyping the line items, no adding up the columns by hand to check them against the G702.

  1. 1. Upload the schedule of values

    Drop in the G703 or your own SOV as a PDF, scan, or photo. Process a single sheet or a whole stack of subcontractor schedules of values at once.

  2. 2. AI reads every line item

    DocuOCR reads the header and each SOV row, the description, scheduled value, previous, this period, materials stored, total to date, percent, balance to finish, and retainage, and the column totals.

  3. 3. Review flagged values

    Every field gets a confidence score and your own validation rules, so a line that does not add up or a total that does not tie to the G702 is flagged before you approve the draw.

  4. 4. Export to Excel or your system

    Send the line items to Excel, CSV, or JSON, or push them into Procore, Sage, Foundation, QuickBooks, or your own project accounting.

g703.pdf -> Excel rows
# incoming G703 SOV  ->  clean line-item rows
{
  "document_type": "schedule_of_values_g703",
  "application_no": 7,
  "period_to": "2026-05-31",
  "line_items": [
    { "item": "03300", "description": "Cast-in-place concrete", "scheduled_value": "142,000.00", "pct_complete": 65, "retainage": "9,230.00" }
    /* more line items, columns aligned */
  ],
  "totals_tie_to_g702": true,
  "confidence": 0.98
}
# export -> .xlsx | .csv | .json
// What we extract

Every column on the AIA G703

DocuOCR reads both the sheet header and every line item on the schedule of values, plus the totals row, so nothing has to be keyed by hand.

From the sheet header and totals

  • Project name and location
  • Architect's project number
  • Application number and application date
  • Period to date
  • Contractor name
  • Original contract sum and change orders
  • Column totals for each field
  • Total retainage and balance to finish
  • Grand total completed and stored to date

From each line item row

  • Item number
  • Description of work
  • Scheduled value
  • Work completed from previous applications
  • Work completed this period
  • Materials presently stored
  • Total completed and stored to date
  • Percentage complete
  • Balance to finish and retainage

The schedule of values usually arrives with the rest of the pay package. DocuOCR also reads the G702 and G703 pay application summary, certified payroll (WH-347) reports, and conditional and unconditional lien waivers. See the full construction document processing software for the whole draw workflow.

// Who it is for

Teams that review a schedule of values

If G703 sheets and subcontractor schedules of values land on your desk every month and someone has to read and check them, this is for you.

General contractors

Roll up each subcontractor schedule of values and check the scheduled values, percent complete, and stored materials before you certify the project pay application.

Owners and project managers

Verify the SOV behind every G702 draw and keep a clean, searchable record of how the contract sum is being billed line by line.

Construction lenders and inspectors

Confirm the schedule of values ties out and retainage is held correctly before releasing funds on each draw.

Estimators and cost engineers

Pull a submitted SOV into Excel to compare line-item pricing across bids or reconcile it against your own estimate.

Construction accountants and back office

Move the line items straight into Procore, Sage, Foundation, or QuickBooks instead of retyping the whole grid.

Construction tech platforms

Add schedule-of-values extraction to your product through one REST API instead of building the table parsing yourself.

// Reading, not filling out

For the schedule of values you receive, not a blank template

Plenty of tools help a contractor build and submit an SOV. DocuOCR sits on the other side of that exchange: it reads the finished schedules of values that arrive from your subs or on each pay application so you can review them fast.

Reading a G703 by hand means retyping every line item and adding up the columns to check they tie back to the G702. On a job with many subs that is hours a month, and one line that does not foot can hold up a draw.

See the full construction document processing software

Manual entry or basic OCR

  • Retype every line item by hand
  • Columns for percent and retainage get merged
  • Cannot read scanned or faxed G703 sheets
  • No check that the totals tie to the G702
  • Hours per stack of pay applications

DocuOCR

  • Reads every line item automatically
  • Keeps scheduled value, percent, and retainage separate
  • OCR reads scanned, faxed, and photographed sheets
  • Flags rows that do not foot or tie to the G702
  • Minutes per stack, at any volume

Accuracy runs 95 to 99 percent on clean sheets, and every value carries a confidence score with optional validation rules, so uncertain reads are flagged for review rather than trusted blindly. DocuOCR structures the data so you can verify the draw; it does not approve the pay application for you.

// Security

Your project financials stay private

A schedule of values carries contract values and billing detail, so it is handled under enterprise-grade controls, with encryption in transit and at rest, role-based access, audit logs, and optional automatic purge after extraction.

SOC 2 Type II
256-bit encryption
Role-based access
US data handling
// FAQ

Schedule of values FAQ

The questions people ask most about the schedule of values, the AIA G703, and getting it into Excel.

What is a schedule of values in construction?

A schedule of values, or SOV, is an itemized breakdown of the total contract sum into individual line items of work, each with the dollar amount budgeted for it. The contractor prepares it at the start of a project, and it becomes the basis for every progress billing: as work gets done, each line shows the percent complete and the amount earned. On AIA jobs the schedule of values lives on Document G703, the continuation sheet attached to each G702 application for payment.

What is the AIA G703 continuation sheet?

AIA Document G703 is the continuation sheet that carries the schedule of values behind an AIA G702 application for payment. It lists each item of work in its own row, with the scheduled value, work completed from previous applications, work completed this period, materials presently stored, total completed and stored to date, the percentage complete, the balance to finish, and retainage. The column totals on the G703 feed the summary figures the contractor certifies on the G702.

What is the difference between AIA G702 and G703?

The G702 is the one-page application and certificate for payment: it summarizes the contract sum, change orders, total completed to date, retainage, and the current payment due, and carries the signatures. The G703 is the continuation sheet behind it, the schedule of values, where every line item of work is listed with its scheduled value and how much of it is complete. G702 is the summary and certification; G703 is the detailed line-item breakdown the summary is built from.

How do I convert a schedule of values to Excel?

Upload the schedule of values PDF or a scan and DocuOCR reads every line item, then exports a clean Excel file with one row per item and each column, description, scheduled value, previous, this period, materials stored, total to date, percent, balance to finish, and retainage, kept separate. You can also export CSV for an import or JSON for the API. It reads scanned and photographed G703 sheets, not only digital PDFs, so a sub who emails a scan still lands as tidy spreadsheet rows.

What columns are on a schedule of values?

A standard AIA G703 schedule of values has an item number and a description of work, the scheduled value for that item, work completed from previous applications, work completed this period, materials presently stored, the total completed and stored to date, that total as a percentage of the scheduled value, the balance to finish, and retainage. The bottom row totals each column so the figures tie back to the G702 summary. DocuOCR extracts every one of these columns.

Who prepares the schedule of values?

The contractor prepares the schedule of values, usually the general contractor at the start of the project, allocating the contract sum across the line items of work as required by the general conditions of the contract. The architect or owner reviews and approves it before the first pay application. On jobs with subcontractors, each sub often submits its own schedule of values that the general contractor rolls into the overall SOV and reviews on every draw.

Can you extract an AIA G703 to Excel?

Yes. DocuOCR is built to read the AIA G703 grid, one row per line item, and pull the scheduled value, work completed, materials stored, percent complete, balance to finish, and retainage into a clean Excel or CSV file with the columns intact. Because the totals row is extracted too, you can check that the line items add up to the certified totals on the G702. Digital, scanned, and photographed G703 sheets all work.

Does DocuOCR create a blank schedule of values template?

No. DocuOCR does not generate a blank SOV template for you to fill in. It works on the other side of that task: it reads the schedule of values you already have, a subcontractor submission, a G703 attached to a pay application, or an SOV a previous system produced, and turns it into structured spreadsheet data you can review, compare, or import. Once your SOV is in Excel you can of course reuse that structure on the next project.

Convert your next schedule of values free

Upload a G703, watch the line items come back as clean Excel rows with the scheduled values, percent complete, and retainage kept separate, and scale per page when you go live.