Why the pay application is the most important document you send
Every dollar a contractor earns on a job comes in through a pay application. A clean one gets approved and paid on the first pass. A messy one, with lines over 100%, math that doesn’t foot or a previous-payments figure that doesn’t match the last approval, gets sent back, and the payment clock starts over.
The industry’s standard layout has two parts: a one-page application summary that says how much is due, and a continuation sheet that shows the progress on each line of the schedule of values. This builder produces both from one table, carries the numbers from one period to the next, and does the arithmetic that most often goes wrong.
How the builder works
- Set up the schedule of values. Each line has an item number, a description and a scheduled value. Approved change orders are separate lines marked CO; they add up to line 2 of the summary.
- Enter progress for the period. Choose % complete to type each line’s percent complete to date (the builder works out the dollars billed this period), or $ this period to type the amount directly. Materials stored on site and not yet installed go in the stored column.
- Set retainage. One rate for completed work and one for stored materials, as your contract allows.
- Enter previous certificates. That’s line 6 from your last approved application.
- Check and send. Lines billed past their scheduled value are flagged, and so is an application that works out to a credit.
When the period is approved, Start the next application moves this period’s billing into Previous, carries line 6 into Previous certificates, bumps the application number and leaves stored materials in place until you bill them as installed.
The totals follow the standard continuation-sheet math:
- Total completed and stored = previous + this period + stored materials
- Percent complete = total completed and stored ÷ scheduled value
- Balance to finish = scheduled value − total completed and stored
- Retainage = (previous + this period) × retainage on work + stored × retainage on stored materials
A worked example
Brightline Electric is billing application 4 on the Riverside Medical Office Building to the GC, Summit Builders, for the period ending September 30, 2026. The schedule of values has 11 base-contract lines and one approved change order for EV charger circuits. Retainage is 10% on work and on stored materials.
This period, the service and distribution gear line goes from 30% to 70% complete ($38,400 of work) and the switchboard sections sitting in the electrical room, $18,500, are billed as stored materials. Lighting fixtures are 10% installed with $31,000 of fixtures stored on site.
| Line | Application summary | Amount |
|---|---|---|
| 1 | Original contract sum | $527,000.00 |
| 2 | Net change by change orders | $12,800.00 |
| 3 | Contract sum to date | $539,800.00 |
| 4 | Total completed and stored to date | $383,480.00 |
| 5 | Retainage ($33,398 on work + $4,950 on stored) | $38,348.00 |
| 6 | Total earned less retainage | $345,132.00 |
| 7 | Less previous certificates for payment | $186,273.00 |
| 8 | Current payment due | $158,859.00 |
| 9 | Balance to finish, including retainage | $194,668.00 |
The job is 71% complete and stored. Stored materials account for $49,500 of the total, so billing them brings in $44,550 this month (after 10% retainage) that would otherwise wait until the gear and fixtures are installed.
Line 9 includes retainage. Of the $194,668 left to collect, $38,348 is money already earned and held back.
Tips for pay applications that get paid
- Build the schedule of values to match how you’ll measure progress. Separate rough-in and trim, and floors or areas, so percent complete is easy to defend.
- Keep general conditions and mobilization reasonable. Front-loading helps cash flow, but an unbalanced schedule of values is the first thing a reviewer questions.
- Bill stored materials with backup. Delivery tickets, photos and an invoice make approval routine.
- Match line 7 to the last approved application, not your last request. If the GC reduced it, carry their number.
- Watch lines approaching 100%. Billing past a scheduled value needs a change order, not a bigger percentage.
- Send it on the day your contract says. Many contracts have a cut-off date; a day late can mean a month late.
The Excel workbook
The Excel download has two sheets. The continuation sheet keeps live formulas for total to date, percent complete, balance and retainage, and the summary sheet pulls its totals from it, with the retainage rates in their own cells. Change a rate or a line and the whole application recalculates.
Related tools
Retainage and payment timing decide your cash position; see the whole picture with the cash flow and retainage forecaster. Check your state’s retainage cap and prompt pay deadlines with the retainage and prompt payment rules, and price the extra work you’ll add as change order lines with the change order pricing calculator.