# Pine Property Services: progress billing, retainage, change order and lien waiver documents

The payment pack for one construction contract at the second application: the schedule of values, an AIA-style continuation sheet and summary with retainage on both completed work and stored material, the change orders that moved the contract sum, the retainage ledger, the conditional and unconditional lien waivers, the certificate for payment, and the job costing, work order, material, daily log and inspection records underneath them.

All parties, amounts and identifiers are fictional. Fixed snapshot: 2026-09-08. Every record is derived from the shared operating model `trades-property`, so identifiers join across this set and across the business-kit fixtures that use the same model.

## Reconciliation identities this set asserts

- The schedule of values totals 3858.00, the original contract sum.
- Original contract sum plus 255.00 of change orders gives the 4113.00 contract sum to date on line 3.
- The continuation sheet totals 3248.00 completed and stored and 324.80 of retainage, exactly lines 4 and 5 of the summary.
- Retainage is 10 percent of the completed and stored figure to the cent, including the negative retainage on the credit change order.
- Line 6 less line 7 equals the 1582.20 current payment due, which is the amount on the conditional lien waiver and the certificate.
- The two lien waivers total 2923.20, the whole of the earned value less retainage, so nothing certified is unwaived.
- estimate_total minus actual_total is 85.00 on every work order, 1020.00 in total.

## Files

| File | Format | Validity | What it is |
| --- | --- | --- | --- |
| `schedule-of-values.csv` | csv | valid | Schedule of values |
| `application-for-payment-002-continuation.csv` | csv | valid | Application for payment continuation sheet |
| `application-for-payment-002-summary.csv` | csv | valid | Application for payment summary |
| `application-for-payment-002-retainage-rate.csv` | csv | invalid | Application for payment whose retainage was withheld at the wrong rate |
| `schedule-of-values.xlsx` | xlsx | valid | Payment application workbook |
| `change-orders.csv` | csv | valid | Approved change order register |
| `change-order-CO-001.pdf` | pdf | valid | Change order PDF |
| `retainage-ledger.csv` | csv | valid | Retainage ledger |
| `lien-waiver-register.csv` | csv | valid | Lien waiver register |
| `lien-waiver-conditional-LW-2026-002.pdf` | pdf | valid | Conditional lien waiver PDF |
| `certificate-for-payment-002.pdf` | pdf | valid | Certificate for payment PDF |
| `job-cost-report.csv` | csv | valid | Job cost report, estimate against actual |
| `job-cost-report.json` | json | valid | Job cost report JSON |
| `cost-code-summary.csv` | csv | valid | Cost code budget against actual |
| `work-order-export.csv` | csv | valid | Work order export |
| `work-order-export.json` | json | valid | Work order export JSON |
| `material-purchases.csv` | csv | valid | Material purchase register |
| `daily-log.csv` | csv | valid | Site daily log |
| `inspection-register.csv` | csv | valid | Completion inspection register |
| `properties-export.csv` | csv | valid | Property register with job costs |
| `maintenance-schedule.csv` | csv | valid | Planned maintenance schedule |
| `construction-reconciliation.json` | json | reference | Construction reconciliation assertions |

## Deliberate defects

These files are broken on purpose. Each one is a single named mutation of a correct file in the same directory, so a parser under test can be checked against both.

- **`application-for-payment-002-retainage-rate.csv`** Line 5a states 10 percent of 3108.00, which is 310.80, but carries 155.40. Line 8 is therefore 162.40 overstated. Every other line still adds up, so line-by-line arithmetic checks pass and only a check against the stated rate catches it; the contractor is paid 162.40 of money the contract says is retained.

## Notes and limits

- Summary line 9, balance to finish including retainage, is 1189.80 while the continuation sheet's balance_to_finish column totals 865.00. They differ by the 324.80 of retainage and both are correct; the column excludes retainage and the line includes it. This is the most common false positive in a payment application check.
- The credit change order carries a negative scheduled value and a negative retainage. That is correct: retainage follows the certified amount in both directions.
- Materials are bought when the work order is raised, so the scheduled work orders carry recorded material cost with no labour against them yet.
- The lien waiver and the certificate are fixture documents with fictional parties. They are not legal instruments and nothing here is legal advice.
- The contract, properties, managers and merchants are all fictional.