SAMPLE · fictional records
Revenue X-Ray: Harbor View Clinic Fit-Out (SAMPLE)
Status: Incomplete (1)
Not reviewed by a person: this is a SAMPLE report on fictional records.
What we could not check
These records were missing, could not be read, or have no backup document. The checks they feed could not run on them, so nothing below says those checks passed for them.
- Materials stored on pay app 6, line 5 (HVAC equipment): $12,000.00: No backup document (Xray_SAMPLE_PayApp_Lines.csv row 76). Blocks: Pay-app math. Send the supplier invoice or delivery ticket for the $12,000.00 of materials stored on pay app 6, line 5 (HVAC equipment).
Dollars found at each gap (SAMPLE, not reviewed by a person)
| Gap | Amount |
|---|---|
| Approved, not yet billed | $75,899.00 |
| Billed, not yet paid | $10,250.50 |
| Retainage still held | $105,120.40 |
Each gap adds up the findings on it. Two findings can describe the same dollars, so the gaps are never added together.
The nine checks
| Check | Result | Findings |
|---|---|---|
| Pay-app math | Issues found | 5 |
| Previous billing vs the last approved pay app | Issues found | 3 |
| Approved change orders on the SOV or billed | Issues found | 3 |
| Change orders billed twice | Issues found | 3 |
| Lines over 100% | Issues found | 3 |
| Retainage rate and to-date amount | Issues found | 2 |
| Billed vs paid per pay app (short pays) | Issues found | 3 |
| Retainage past the release date you confirmed | Issues found | 1 |
| Documents you marked as required but missing | Issues found | 3 |
Money Map
| Stage | Amount | Confirmation |
|---|---|---|
| Work | $1,350,050.00 | Imported |
| Change requested | $1,350,050.00 | Imported |
| Approved | $1,345,250.00 | Imported |
| Billed | $1,003,204.00 | Imported |
| Paid | $763,278.50 | Imported |
| Retainage released | $0.00 | Imported |
| Gap | Amount | Confirmation | Findings | Source rows |
|---|---|---|---|---|
| Change orders not yet sent to the GC | $0.00 | Imported | 0 | |
| Change orders waiting for approval | $4,800.00 | Imported | 0 | Xray_SAMPLE_CO_Log.csv row 10 |
| Approved, not yet billed | $342,046.00 | Imported | 14 | Xray_SAMPLE_CO_Log.csv row 7; Xray_SAMPLE_PayApp_Summary.csv row 6; Xray_SAMPLE_PayApp_Summary.csv row 7; Xray_SAMPLE_PayApp_Lines.csv row 28; Xray_SAMPLE_PayApp_Lines.csv row 26; Xray_SAMPLE_CO_Log.csv row 9 and 26 more |
| Billed, not yet paid | $137,205.10 | Imported | 6 | Xray_SAMPLE_Request.json row 4; Xray_SAMPLE_Request.json row 3; Xray_SAMPLE_Request.json row 5; Xray_SAMPLE_PayApp_Summary.csv row 6; Xray_SAMPLE_AR_Invoices.csv row 6; Xray_SAMPLE_Payments_Received.csv row 7 and 10 more |
| Retainage still held | $102,720.40 | Imported | 2 | Xray_SAMPLE_Retainage_Ledger.csv row 7; Xray_SAMPLE_PayApp_Summary.csv row 7; Xray_SAMPLE_PayApp_Summary.csv row 6; Xray_SAMPLE_Contract_Summary.csv row 2; Xray_SAMPLE_Request.json row 1 |
Findings (22)
Pay app discrepancy: $13,200.00
Pay app 3 for the period ending Mar 31, 2026 has a figure that does not add up; the gap is $13,200.00.
Check: Pay-app math
Evidence
- Xray_SAMPLE_PayApp_Lines.csv row 28: 30% (line 6: % complete shows 30.00% but completed / scheduled is 20.00%)
- Xray_SAMPLE_PayApp_Lines.csv row 26: $30,600.00 (payapp_carry_forward_mismatch: line 4 "HVAC ductwork": previously billed shows $30,600.00 but pay app 2 carried $32,100.00)
Also on this item: An amount on pay app 3 does not carry forward from pay app 2; the gap is $1,500.00.
Why it matters
A pay app whose numbers do not add up can be sent back by the GC. That can delay payment for the whole period.
What to do next
- Open pay app 3 and check the figures listed below.
- Find which figure is wrong.
- Correct it, and send a revised pay app if the GC already has it.
Prepared next step
Draft for you to approve. Nothing has been sent.
Check payment application 3 — Harbor View Clinic Fit-Out (SAMPLE) Pay app 3 for the period ending Mar 31, 2026 has a figure that does not add up; the gap is $13,200.00. 1. Open pay app 3 and check the figures listed below. 2. Find which figure is wrong. 3. Correct it, and send a revised pay app if the GC already has it.
Pay app discrepancy: $1,000.00
Pay app 4 for the period ending Apr 30, 2026 has a figure that does not add up; the gap is $1,000.00.
Check: Pay-app math
Evidence
- Xray_SAMPLE_PayApp_Lines.csv row 38: $15,800.00 (line 2: balance to finish shows $15,800.00 but scheduled - completed = $14,800.00)
- Xray_SAMPLE_PayApp_Summary.csv row 5: $321,679.00 (payapp_carry_forward_mismatch: previous payments shows $321,679.00 but pay app 3 earned less retainage was $322,479.00)
- Xray_SAMPLE_AR_Invoices.csv row 5: $197,963.00 (receivable_aging: A/R invoice 2207-04: $197,963.00 − $196,712.50 paid = $1,250.50 open)
- Xray_SAMPLE_Payments_Received.csv row 6: $196,712.50 (receivable_aging: payment 2026-06-03)
Also on this item: An amount on pay app 4 does not carry forward from pay app 3; the gap is $800.00.
Why it matters
A pay app whose numbers do not add up can be sent back by the GC. That can delay payment for the whole period.
What to do next
- Open pay app 4 and check the figures listed below.
- Find which figure is wrong.
- Correct it, and send a revised pay app if the GC already has it.
Prepared next step
Draft for you to approve. Nothing has been sent.
Check payment application 4 — Harbor View Clinic Fit-Out (SAMPLE) On payment application 4 for Harbor View Clinic Fit-Out (SAMPLE), line 2: the balance to finish does not equal the scheduled value less completed to date. The line shows $15,800.00; the calculation from the same line gives $14,800.00. Confirm the figures with the project accountant before the next application is submitted.
Pay app discrepancy: $500.00
Pay app 2 for the period ending Feb 28, 2026 has a figure that does not add up; the gap is $500.00.
Check: Pay-app math
Evidence
- Xray_SAMPLE_PayApp_Lines.csv row 14: $17,600.00 (line 3 "Above-ground plumbing": previously billed $0.00 + this period $18,100.00 + stored $0.00 = $18,100.00, but completed to date shows $17,600.00)
- Xray_SAMPLE_AR_Invoices.csv row 3: $104,166.00 (receivable_aging: A/R invoice 2207-02: $104,166.00 − $101,166.00 paid = $3,000.00 open)
- Xray_SAMPLE_Payments_Received.csv row 3: $101,166.00 (receivable_aging: payment 2026-04-03)
Why it matters
A pay app whose numbers do not add up can be sent back by the GC. That can delay payment for the whole period.
What to do next
- Open pay app 2 and check the figures listed below.
- Find which figure is wrong.
- Correct it, and send a revised pay app if the GC already has it.
Prepared next step
Draft for you to approve. Nothing has been sent.
Check payment application 2 — Harbor View Clinic Fit-Out (SAMPLE) On payment application 2 for Harbor View Clinic Fit-Out (SAMPLE), line 3: previously billed plus this period plus stored does not equal completed to date. The line shows $17,600.00; the calculation from the same line gives $18,100.00. Confirm the figures with the project accountant before the next application is submitted.
Pay app discrepancy: $300.00
Pay app 6 for the period ending Jun 30, 2026 has a figure that does not add up; the gap is $300.00.
Check: Pay-app math
Evidence
- Xray_SAMPLE_PayApp_Summary.csv row 7: $903,183.60 (earned less retainage shows $903,183.60 but completed & stored - retainage = $902,883.60)
- Xray_SAMPLE_PayApp_Lines.csv row 78: $28,050.00 (payapp_carry_forward_mismatch: line 7 "Building automation controls": previously billed shows $28,050.00 but pay app 5 carried $25,800.00)
Also on this item: An amount on pay app 6 does not carry forward from pay app 5; the gap is $2,250.00.
Why it matters
A pay app whose numbers do not add up can be sent back by the GC. That can delay payment for the whole period.
What to do next
- Open pay app 6 and check the figures listed below.
- Find which figure is wrong.
- Correct it, and send a revised pay app if the GC already has it.
Prepared next step
Draft for you to approve. Nothing has been sent.
Check payment application 6 — Harbor View Clinic Fit-Out (SAMPLE) On payment application 6 for Harbor View Clinic Fit-Out (SAMPLE), line null: earned less retainage does not equal completed and stored less retainage. The line shows $903,183.60; the calculation from the same line gives $902,883.60. Confirm the figures with the project accountant before the next application is submitted.
Pay app discrepancy: $85.00
Pay app 5 for the period ending May 31, 2026 has 2 figures that do not add up; the largest gap is $85.00.
Check: Pay-app math
Evidence
- Xray_SAMPLE_PayApp_Lines.csv row 61: $810.00 (line 9: retainage shows $810.00 but 5% of completed to date is $725.00)
- Xray_SAMPLE_PayApp_Summary.csv row 6: $40,291.00 (summary retainage shows $40,291.00 but line retainage totals $40,376.00)
Why it matters
A pay app whose numbers do not add up can be sent back by the GC. That can delay payment for the whole period.
What to do next
- Open pay app 5 and check the figures listed below.
- Find which figure is wrong.
- Correct it, and send a revised pay app if the GC already has it.
Prepared next step
Draft for you to approve. Nothing has been sent.
Check payment application 5 — Harbor View Clinic Fit-Out (SAMPLE) On payment application 5 for Harbor View Clinic Fit-Out (SAMPLE), line 9: the retainage does not match the retainage rate. The line shows $810.00; the calculation from the same line gives $725.00. Confirm the figures with the project accountant before the next application is submitted.
Reconciliation discrepancy — allocation unknown: $18,400.00
Reconciliation discrepancy — allocation unknown. No bill line names change order CO-06. The gap is $18,400.00.
Check: Approved change orders on the SOV or billed
Evidence
- Xray_SAMPLE_CO_Log.csv row 7: $18,400.00 (CO log: CO-06 approved 2026-04-28)
- Xray_SAMPLE_PayApp_Summary.csv row 6: 19 lines (pay app 5 (period to 2026-05-31) checked: no line references CO-06, none matches its amount or description)
- Xray_SAMPLE_PayApp_Summary.csv row 7: 19 lines (pay app 6 (period to 2026-06-30) checked: no line references CO-06, none matches its amount or description)
Why it matters
The records do not show which billing line carries this change. A person has not yet confirmed that this amount is owed.
What to do next
- Compare CO-06 with your schedule and billing lines.
- Write down which line carries it, with the proof.
- Do this before you decide if any amount can be billed.
Prepared next step
Draft for you to approve. Nothing has been sent.
Review change CO-06 — Harbor View Clinic Fit-Out (SAMPLE) The change order log shows CO-06 (Relocate rooftop fan EF-3 for new skylight) approved for $18,400.00 on April 28, 2026. No billing line names it yet, so this is a difference to check. A person has not yet confirmed that this amount is owed. change CO-06 on Harbor View Clinic Fit-Out (SAMPLE) needs context from the project manager: Whether the work has been performed yet.
Change only partly billed: $3,780.00
Change order CO-07 is marked billed in your log, but only $2,520.00 has been billed, leaving $3,780.00 unbilled.
Check: Approved change orders on the SOV or billed
Evidence
- Xray_SAMPLE_CO_Log.csv row 8: billed (CO log: CO-07)
- Xray_SAMPLE_PayApp_Lines.csv row 88: $2,520.00 (pay app 6 line 17)
Why it matters
Your change order log says this change is done, so no one may be watching the rest. The unbilled part may never be collected.
What to do next
- Ask the project manager how much of the work is complete.
- Bill the remaining $3,780.00 on the next pay app once the work is done.
- Update the status of CO-07 in your log so it matches the billing.
Prepared next step
Draft for you to approve. Nothing has been sent.
Add an approved change to the next payment application — Harbor View Clinic Fit-Out (SAMPLE) CO-07 is marked billed but only $2,520.00 of $6,300.00 has been billed — requires confirmation. Please review the evidence in Main Revenue and confirm the next step.
Change order log and schedule of values disagree: $500.00
Your change order log shows CO-04 at $12,500.00, but your schedule of values carries $12,000.00, a gap of $500.00.
Check: Approved change orders on the SOV or billed
Evidence
- Xray_SAMPLE_CO_Log.csv row 5: $12,500.00 (CO log: CO-04)
- Xray_SAMPLE_SOV.csv row 16: $12,000.00 (SOV line 15 "CO-04 Lab exhaust duct reroute at corridor C" references CO-04)
Why it matters
When the log and the schedule of values disagree, you may bill too little, or bill more than the GC will pay.
What to do next
- Find the change-order document for CO-04.
- Check which amount is right.
- Correct the log or the schedule of values so they match.
Prepared next step
Draft for you to approve. Nothing has been sent.
Reconcile change CO-04 — Harbor View Clinic Fit-Out (SAMPLE) the CO log shows $12,500.00 and the schedule of values shows $12,000.00 for change CO-04 on Harbor View Clinic Fit-Out (SAMPLE). Confirm which record is correct and update the other system so both agree before the next billing.
Change on more than one billing record: $11,000.00
Change order CO-08 appears at full value on 2 separate billing records, an extra $11,000.00.
Check: Change orders billed twice
Evidence
- Xray_SAMPLE_CO_Log.csv row 9: $11,000.00 (CO log: CO-08)
- Xray_SAMPLE_SOV.csv row 19: $11,000.00 (line 18 "CO-08 Dental vacuum pump and piping")
- Xray_SAMPLE_SOV.csv row 20: $11,000.00 (line 19 "CO-08 Dental vacuum pump and piping")
Why it matters
If the same change is billed twice, the GC may reject the pay app or ask for money back later. Fixing it now avoids a dispute.
What to do next
- Look at each billing record listed below.
- Check whether one of them was reversed or credited.
- If not, remove the extra line or issue a credit on the next pay app.
Prepared next step
Draft for you to approve. Nothing has been sent.
Correct a payment-application calculation — Harbor View Clinic Fit-Out (SAMPLE) CO-08 ($11,000.00) appears on 2 separate billing records — requires confirmation. Please review the evidence in Main Revenue and confirm the next step.
Change on more than one billing record: $9,450.00
Change order CO-03 appears at full value on 2 separate billing records, an extra $9,450.00.
Check: Change orders billed twice
Evidence
- Xray_SAMPLE_CO_Log.csv row 4: $9,450.00 (CO log: CO-03)
- Xray_SAMPLE_SOV.csv row 14: $9,450.00 (line 13 "CO-03 Add backflow preventer at main service")
- Xray_SAMPLE_SOV.csv row 15: $9,450.00 (line 14 "CO-03 Add backflow preventer at main service")
- Xray_SAMPLE_CO_Log.csv row 4: $9,450.00 (billing_above_change_value: CO log: CO-03)
- Xray_SAMPLE_PayApp_Lines.csv row 84: $9,450.00 (billing_above_change_value: pay app 6 line 13)
- Xray_SAMPLE_PayApp_Lines.csv row 85: $9,450.00 (billing_above_change_value: pay app 6 line 14)
Why it matters
If the same change is billed twice, the GC may reject the pay app or ask for money back later. Fixing it now avoids a dispute.
What to do next
- Look at each billing record listed below.
- Check whether one of them was reversed or credited.
- If not, remove the extra line or issue a credit on the next pay app.
Prepared next step
Draft for you to approve. Nothing has been sent.
Correct a payment-application calculation — Harbor View Clinic Fit-Out (SAMPLE) CO-03 ($9,450.00) appears on 2 separate billing records — requires confirmation. Please review the evidence in Main Revenue and confirm the next step.
Change on more than one billing record: $7,200.00
Change order CO-05 appears at full value on 2 separate billing records, an extra $7,200.00.
Check: Change orders billed twice
Evidence
- Xray_SAMPLE_CO_Log.csv row 6: $7,200.00 (CO log: CO-05)
- Xray_SAMPLE_SOV.csv row 17: $7,200.00 (line 16 "CO-05 Emergency eyewash stations in soiled utility rooms")
- Xray_SAMPLE_AR_Invoices.csv row 8: $7,200.00 (invoice 2207-C05)
Why it matters
If the same change is billed twice, the GC may reject the pay app or ask for money back later. Fixing it now avoids a dispute.
What to do next
- Look at each billing record listed below.
- Check whether one of them was reversed or credited.
- If not, remove the extra line or issue a credit on the next pay app.
Prepared next step
Draft for you to approve. Nothing has been sent.
Correct a payment-application calculation — Harbor View Clinic Fit-Out (SAMPLE) CO-05 ($7,200.00) appears on 2 separate billing records — requires confirmation. Please review the evidence in Main Revenue and confirm the next step.
Line billed over 100%: $7,400.00
Pay app 6 line 8 shows $81,400.00 completed on a line scheduled at $74,000.00, which is $7,400.00 over 100%.
Check: Lines over 100%
Evidence
- Xray_SAMPLE_PayApp_Lines.csv row 79: $81,400.00 (pay app 6 line 8 "Medical gas systems")
- Xray_SAMPLE_PayApp_Lines.csv row 79: $74,000.00 (pay app 6 line 8 scheduled value)
Why it matters
A line billed past its scheduled value is often sent back by the GC. If a change order raised the line, the schedule of values should show it.
What to do next
- Check whether a change order or a revised schedule of values covers line 8.
- If one does, add it to the schedule of values.
- If not, correct the line on the next pay app.
Prepared next step
Draft for you to approve. Nothing has been sent.
Check payment application 6 — Harbor View Clinic Fit-Out (SAMPLE) Pay app 6 line 8 shows $81,400.00 completed on a line scheduled at $74,000.00, which is $7,400.00 over 100%. 1. Check whether a change order or a revised schedule of values covers line 8. 2. If one does, add it to the schedule of values. 3. If not, correct the line on the next pay app.
Line billed over 100%: $1,820.00
Pay app 6 line 10 shows $53,820.00 completed on a line scheduled at $52,000.00, which is $1,820.00 over 100%.
Check: Lines over 100%
Evidence
- Xray_SAMPLE_PayApp_Lines.csv row 81: $53,820.00 (pay app 6 line 10 "Testing, balancing and startup")
- Xray_SAMPLE_PayApp_Lines.csv row 81: $52,000.00 (pay app 6 line 10 scheduled value)
Why it matters
A line billed past its scheduled value is often sent back by the GC. If a change order raised the line, the schedule of values should show it.
What to do next
- Check whether a change order or a revised schedule of values covers line 10.
- If one does, add it to the schedule of values.
- If not, correct the line on the next pay app.
Prepared next step
Draft for you to approve. Nothing has been sent.
Check payment application 6 — Harbor View Clinic Fit-Out (SAMPLE) Pay app 6 line 10 shows $53,820.00 completed on a line scheduled at $52,000.00, which is $1,820.00 over 100%. 1. Check whether a change order or a revised schedule of values covers line 10. 2. If one does, add it to the schedule of values. 3. If not, correct the line on the next pay app.
Line billed over 100%: $1,264.00
Pay app 6 line 12 shows $17,064.00 completed on a line scheduled at $15,800.00, which is $1,264.00 over 100%.
Check: Lines over 100%
Evidence
- Xray_SAMPLE_PayApp_Lines.csv row 83: $17,064.00 (pay app 6 line 12 "CO-02 Upsize chilled water branch to imaging suite")
- Xray_SAMPLE_PayApp_Lines.csv row 83: $15,800.00 (pay app 6 line 12 scheduled value)
Why it matters
A line billed past its scheduled value is often sent back by the GC. If a change order raised the line, the schedule of values should show it.
What to do next
- Check whether a change order or a revised schedule of values covers line 12.
- If one does, add it to the schedule of values.
- If not, correct the line on the next pay app.
Prepared next step
Draft for you to approve. Nothing has been sent.
Check payment application 6 — Harbor View Clinic Fit-Out (SAMPLE) Pay app 6 line 12 shows $17,064.00 completed on a line scheduled at $15,800.00, which is $1,264.00 over 100%. 1. Check whether a change order or a revised schedule of values covers line 12. 2. If one does, add it to the schedule of values. 3. If not, correct the line on the next pay app.
Retainage ledger does not match the pay apps: $2,400.00
Your retainage ledger and your pay apps do not agree on the retainage held; the gap is $2,400.00.
Check: Retainage rate and to-date amount
Evidence
- Xray_SAMPLE_Retainage_Ledger.csv row 7: $102,720.40 (retainage ledger)
- Xray_SAMPLE_PayApp_Summary.csv row 7: $1,003,204.00 (pay app 6 completed & stored; 10% = $100,320.40)
- Xray_SAMPLE_PayApp_Summary.csv row 6: 5% (retainage_rate_drift: pay app 5 stated rate)
- Xray_SAMPLE_Contract_Summary.csv row 2: 10% (retainage_rate_drift: project contract rate)
Also on this item: Pay app 5 holds retainage at 5.0%, but the contract rate is 10.0%; on the work billed so far that is a gap of $40,291.00.
Why it matters
If the ledger is off, you may ask for the wrong amount of retainage at closeout. Some of it could go unclaimed.
What to do next
- Add up the retainage from the pay apps and any change invoices.
- Correct the ledger to match.
- Note any reduction or release that was agreed outside these records.
Prepared next step
Draft for you to approve. Nothing has been sent.
Review Retainage: ledger shows $102,720.40 held but pay app 6 computes $100,320.40 (10% of $1,003,204.00) — requires confirmation — Harbor View Clinic Fit-Out (SAMPLE) Retainage: ledger shows $102,720.40 held but pay app 6 computes $100,320.40 (10% of $1,003,204.00) — requires confirmation on Harbor View Clinic Fit-Out (SAMPLE) needs context from the project manager: Whether retainage was adjusted (reduced or released) outside these records.
Pay app paid short: $6,000.00
Pay app 5: $239,887.00 was received of the $245,887.00 due, which leaves $6,000.00 short.
Check: Billed vs paid per pay app (short pays)
Evidence
- Xray_SAMPLE_PayApp_Summary.csv row 6: $245,887.00 (pay app 5 current payment due)
- Xray_SAMPLE_AR_Invoices.csv row 6: $245,887.00 (invoice 2207-05 for pay app 5)
- Xray_SAMPLE_Payments_Received.csv row 7: $122,943.50 (payment on invoice 2207-05 received Jul 2, 2026)
- Xray_SAMPLE_Payments_Received.csv row 8: $116,943.50 (payment on invoice 2207-05 received Jul 10, 2026)
Why it matters
Money held back without a written reason is easy to lose track of. The longer it waits, the harder it can be to collect.
What to do next
- Check the remittance for pay app 5 for a deduction or backcharge.
- If there is no written reason, ask the GC about the difference.
- Write down the answer and set a follow-up date.
Prepared next step
Draft for you to approve. Nothing has been sent.
Follow up on an unpaid invoice — Harbor View Clinic Fit-Out (SAMPLE) Hi there, Pay app 5 (period to May 31, 2026): $239,887.00 received of $245,887.00 due on the pay app, $6,000.00 short — requires confirmation. Please review the evidence in Main Revenue and confirm the next step. Thanks so much — happy to walk through it on a call if that is easier.
Pay app paid short: $3,000.00
Pay app 2: $101,166.00 was received of the $104,166.00 due, which leaves $3,000.00 short.
Check: Billed vs paid per pay app (short pays)
Evidence
- Xray_SAMPLE_PayApp_Summary.csv row 3: $104,166.00 (pay app 2 current payment due)
- Xray_SAMPLE_AR_Invoices.csv row 3: $104,166.00 (invoice 2207-02 for pay app 2)
- Xray_SAMPLE_Payments_Received.csv row 3: $101,166.00 (payment on invoice 2207-02 received Apr 3, 2026)
Why it matters
Money held back without a written reason is easy to lose track of. The longer it waits, the harder it can be to collect.
What to do next
- Check the remittance for pay app 2 for a deduction or backcharge.
- If there is no written reason, ask the GC about the difference.
- Write down the answer and set a follow-up date.
Prepared next step
Draft for you to approve. Nothing has been sent.
Follow up on an unpaid invoice — Harbor View Clinic Fit-Out (SAMPLE) Hi there, Pay app 2 (period to Feb 28, 2026): $101,166.00 received of $104,166.00 due on the pay app, $3,000.00 short — requires confirmation. Please review the evidence in Main Revenue and confirm the next step. Thanks so much — happy to walk through it on a call if that is easier.
Pay app paid short: $1,250.50
Pay app 4: $196,712.50 was received of the $197,963.00 due, which leaves $1,250.50 short.
Check: Billed vs paid per pay app (short pays)
Evidence
- Xray_SAMPLE_PayApp_Summary.csv row 5: $197,963.00 (pay app 4 current payment due)
- Xray_SAMPLE_AR_Invoices.csv row 5: $197,963.00 (invoice 2207-04 for pay app 4)
- Xray_SAMPLE_Payments_Received.csv row 6: $196,712.50 (payment on invoice 2207-04 received Jun 3, 2026)
Why it matters
Money held back without a written reason is easy to lose track of. The longer it waits, the harder it can be to collect.
What to do next
- Check the remittance for pay app 4 for a deduction or backcharge.
- If there is no written reason, ask the GC about the difference.
- Write down the answer and set a follow-up date.
Prepared next step
Draft for you to approve. Nothing has been sent.
Follow up on an unpaid invoice — Harbor View Clinic Fit-Out (SAMPLE) Hi there, Pay app 4 (period to Apr 30, 2026): $196,712.50 received of $197,963.00 due on the pay app, $1,250.50 short — requires confirmation. Please review the evidence in Main Revenue and confirm the next step. Thanks so much — happy to walk through it on a call if that is easier.
Retainage held past its release date: $102,720.40
$102,720.40 of retainage is still held 31 days after the release date you confirmed, Jun 30, 2026.
Check: Retainage past the release date you confirmed
Evidence
- Xray_SAMPLE_Retainage_Ledger.csv row 7: $102,720.40 (retainage ledger balance on Jun 30, 2026)
- Xray_SAMPLE_Request.json row 1: 2026-06-30 (release date confirmed by a person)
Why it matters
Retainage is money you have earned. Once the release date has passed, it should be asked for in writing.
What to do next
- Check what the GC needs before release, such as closeout papers or final waivers.
- Send a written release request.
- Set a follow-up date.
Prepared next step
Draft for you to approve. Nothing has been sent.
Retainage on Harbor View Clinic Fit-Out (SAMPLE) Hi there, Could you help us confirm the release schedule for the retainage held on Harbor View Clinic Fit-Out (SAMPLE): $102,720.40 as of July 31, 2026. Please tell us what is needed for release (closeout documents, punch list, final waivers) so we can get it to you. Thanks so much — happy to walk through it on a call if that is easier.
Required document not provided: $0.00
Certified payroll for June 2026 is on your list of required documents, and it was not provided.
Check: Documents you marked as required but missing
Evidence
- Xray_SAMPLE_Request.json row 4: Certified payroll for June 2026 (marked as required)
Why it matters
A missing document can hold up approval or payment of a pay app.
What to do next
- Find Certified payroll for June 2026, or ask who prepares it.
- Add it to this job's records.
- If it is not needed for this job, take it off the list.
Prepared next step
Draft for you to approve. Nothing has been sent.
Review Certified payroll for June 2026: you marked this document as required, and it was not provided — requires confirmation — Harbor View Clinic Fit-Out (SAMPLE) Certified payroll for June 2026: you marked this document as required, and it was not provided — requires confirmation on Harbor View Clinic Fit-Out (SAMPLE) needs context from the project manager: Whether it exists and was not uploaded, or still has to be prepared.
Required document not provided: $0.00
Conditional lien waiver for pay app 6 is on your list of required documents, and it was not provided.
Check: Documents you marked as required but missing
Evidence
- Xray_SAMPLE_Request.json row 3: Conditional lien waiver for pay app 6 (marked as required)
Why it matters
A missing document can hold up approval or payment of a pay app.
What to do next
- Find Conditional lien waiver for pay app 6, or ask who prepares it.
- Add it to this job's records.
- If it is not needed for this job, take it off the list.
Prepared next step
Draft for you to approve. Nothing has been sent.
Review Conditional lien waiver for pay app 6: you marked this document as required, and it was not provided — requires confirmation — Harbor View Clinic Fit-Out (SAMPLE) Conditional lien waiver for pay app 6: you marked this document as required, and it was not provided — requires confirmation on Harbor View Clinic Fit-Out (SAMPLE) needs context from the project manager: Whether it exists and was not uploaded, or still has to be prepared.
Required document not provided: $0.00
Signed change order CO-07 is on your list of required documents, and it was not provided.
Check: Documents you marked as required but missing
Evidence
- Xray_SAMPLE_Request.json row 5: Signed change order CO-07 (marked as required)
Why it matters
A missing document can hold up approval or payment of a pay app.
What to do next
- Find Signed change order CO-07, or ask who prepares it.
- Add it to this job's records.
- If it is not needed for this job, take it off the list.
Prepared next step
Draft for you to approve. Nothing has been sent.
Review Signed change order CO-07: you marked this document as required, and it was not provided — requires confirmation — Harbor View Clinic Fit-Out (SAMPLE) Signed change order CO-07: you marked this document as required, and it was not provided — requires confirmation on Harbor View Clinic Fit-Out (SAMPLE) needs context from the project manager: Whether it exists and was not uploaded, or still has to be prepared.
Not reviewed by a person: this is a SAMPLE report on fictional records.
This report compares your own records with each other. It is not legal or accounting advice.

