Skip to content

SAMPLE · fictional records · not reviewed by a person

SAMPLE · fictional records

Revenue X-Ray: Harbor View Clinic Fit-Out (SAMPLE)

GC: Bramblewood Builders (SAMPLE) · Records as of July 31, 2026

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)

GapAmount
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

CheckResultFindings
Pay-app mathIssues found5
Previous billing vs the last approved pay appIssues found3
Approved change orders on the SOV or billedIssues found3
Change orders billed twiceIssues found3
Lines over 100%Issues found3
Retainage rate and to-date amountIssues found2
Billed vs paid per pay app (short pays)Issues found3
Retainage past the release date you confirmedIssues found1
Documents you marked as required but missingIssues found3

Money Map

StageAmountConfirmation
Work$1,350,050.00Imported
Change requested$1,350,050.00Imported
Approved$1,345,250.00Imported
Billed$1,003,204.00Imported
Paid$763,278.50Imported
Retainage released$0.00Imported
GapAmountConfirmationFindingsSource rows
Change orders not yet sent to the GC$0.00Imported0
Change orders waiting for approval$4,800.00Imported0Xray_SAMPLE_CO_Log.csv row 10
Approved, not yet billed$342,046.00Imported14Xray_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.10Imported6Xray_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.40Imported2Xray_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

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

  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.

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

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

  1. Open pay app 4 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.

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

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

  1. Open pay app 2 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.

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

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

  1. Open pay app 6 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.

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

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

  1. Open pay app 5 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.

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

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

  1. Compare CO-06 with your schedule and billing lines.
  2. Write down which line carries it, with the proof.
  3. 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

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

  1. Ask the project manager how much of the work is complete.
  2. Bill the remaining $3,780.00 on the next pay app once the work is done.
  3. 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

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

  1. Find the change-order document for CO-04.
  2. Check which amount is right.
  3. 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

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

  1. Look at each billing record listed below.
  2. Check whether one of them was reversed or credited.
  3. 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

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

  1. Look at each billing record listed below.
  2. Check whether one of them was reversed or credited.
  3. 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

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

  1. Look at each billing record listed below.
  2. Check whether one of them was reversed or credited.
  3. 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

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

  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.

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

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

  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.

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

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

  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.

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

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

  1. Add up the retainage from the pay apps and any change invoices.
  2. Correct the ledger to match.
  3. 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

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

  1. Check the remittance for pay app 5 for a deduction or backcharge.
  2. If there is no written reason, ask the GC about the difference.
  3. 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

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

  1. Check the remittance for pay app 2 for a deduction or backcharge.
  2. If there is no written reason, ask the GC about the difference.
  3. 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

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

  1. Check the remittance for pay app 4 for a deduction or backcharge.
  2. If there is no written reason, ask the GC about the difference.
  3. 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

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

  1. Check what the GC needs before release, such as closeout papers or final waivers.
  2. Send a written release request.
  3. 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

Why it matters

A missing document can hold up approval or payment of a pay app.

What to do next

  1. Find Certified payroll for June 2026, or ask who prepares it.
  2. Add it to this job's records.
  3. 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

Why it matters

A missing document can hold up approval or payment of a pay app.

What to do next

  1. Find Conditional lien waiver for pay app 6, or ask who prepares it.
  2. Add it to this job's records.
  3. 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

Why it matters

A missing document can hold up approval or payment of a pay app.

What to do next

  1. Find Signed change order CO-07, or ask who prepares it.
  2. Add it to this job's records.
  3. 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.

Source rows (SAMPLE files)

  • Xray_SAMPLE_AR_Invoices.csv row 2: GC Bramblewood Builders (SAMPLE) · Job # X-2207 · Invoice # INV-2207-01 · Description Progress billing - pay app 1 (period to 2026-01-31) · Pay App # 1 · Invoice Date 02/05/2026 · Due Date 03/07/2026 · Terms (days) 30 · Invoice Amount 54,090.00 · Amount Paid 54,090.00
  • Xray_SAMPLE_AR_Invoices.csv row 3: GC Bramblewood Builders (SAMPLE) · Job # X-2207 · Invoice # INV-2207-02 · Description Progress billing - pay app 2 (period to 2026-02-28) · Pay App # 2 · Invoice Date 03/05/2026 · Due Date 04/04/2026 · Terms (days) 30 · Invoice Amount 104,166.00 · Amount Paid 101,166.00
  • Xray_SAMPLE_AR_Invoices.csv row 4: GC Bramblewood Builders (SAMPLE) · Job # X-2207 · Invoice # INV-2207-03 · Description Progress billing - pay app 3 (period to 2026-03-31) · Pay App # 3 · Invoice Date 04/05/2026 · Due Date 05/05/2026 · Terms (days) 30 · Invoice Amount 164,223.00 · Amount Paid 164,223.00
  • Xray_SAMPLE_AR_Invoices.csv row 5: GC Bramblewood Builders (SAMPLE) · Job # X-2207 · Invoice # INV-2207-04 · Description Progress billing - pay app 4 (period to 2026-04-30) · Pay App # 4 · Invoice Date 05/05/2026 · Due Date 06/04/2026 · Terms (days) 30 · Invoice Amount 197,963.00 · Amount Paid 196,712.50
  • Xray_SAMPLE_AR_Invoices.csv row 6: GC Bramblewood Builders (SAMPLE) · Job # X-2207 · Invoice # INV-2207-05 · Description Progress billing - pay app 5 (period to 2026-05-31) · Pay App # 5 · Invoice Date 06/05/2026 · Due Date 07/05/2026 · Terms (days) 30 · Invoice Amount 245,887.00 · Amount Paid 239,887.00
  • Xray_SAMPLE_AR_Invoices.csv row 7: GC Bramblewood Builders (SAMPLE) · Job # X-2207 · Invoice # INV-2207-06 · Description Progress billing - pay app 6 (period to 2026-06-30) · Pay App # 6 · Invoice Date 07/05/2026 · Due Date 08/04/2026 · Terms (days) 30 · Invoice Amount 137,654.60 · Amount Paid 0.00
  • Xray_SAMPLE_AR_Invoices.csv row 8: GC Bramblewood Builders (SAMPLE) · Job # X-2207 · Invoice # INV-2207-C05 · Description CO-05 Emergency eyewash stations in soiled utility rooms - billed separately · Pay App # · Invoice Date 05/08/2026 · Due Date 06/07/2026 · Terms (days) 30 · Invoice Amount 7,200.00 · Amount Paid 7,200.00
  • Xray_SAMPLE_CO_Log.csv row 4: Job # X-2207 · CO # CO-03 · Description Add backflow preventer at main service · Status Approved · Date Submitted 03/02/2026 · Date Approved 03/20/2026 · CO Amount 9,450.00
  • Xray_SAMPLE_CO_Log.csv row 5: Job # X-2207 · CO # CO-04 · Description Lab exhaust duct reroute at corridor C · Status Approved · Date Submitted 03/16/2026 · Date Approved 04/02/2026 · CO Amount 12,500.00
  • Xray_SAMPLE_CO_Log.csv row 6: Job # X-2207 · CO # CO-05 · Description Emergency eyewash stations in soiled utility rooms · Status Approved · Date Submitted 03/30/2026 · Date Approved 04/15/2026 · CO Amount 7,200.00
  • Xray_SAMPLE_CO_Log.csv row 7: Job # X-2207 · CO # CO-06 · Description Relocate rooftop fan EF-3 for new skylight · Status Approved · Date Submitted 04/09/2026 · Date Approved 04/28/2026 · CO Amount 18,400.00
  • Xray_SAMPLE_CO_Log.csv row 8: Job # X-2207 · CO # CO-07 · Description Nurse call room humidifier tie-in · Status Billed · Date Submitted 04/24/2026 · Date Approved 05/12/2026 · CO Amount 6,300.00
  • Xray_SAMPLE_CO_Log.csv row 9: Job # X-2207 · CO # CO-08 · Description Dental vacuum pump and piping · Status Approved · Date Submitted 05/04/2026 · Date Approved 05/20/2026 · CO Amount 11,000.00
  • Xray_SAMPLE_CO_Log.csv row 10: Job # X-2207 · CO # CO-09 · Description Pharmacy compounding room pressure monitor · Status Pending · Date Submitted 07/01/2026 · Date Approved · CO Amount 4,800.00
  • Xray_SAMPLE_Contract_Summary.csv row 2: Job # X-2207 · Job Name Harbor View Clinic Fit-Out (SAMPLE) · General Contractor Bramblewood Builders (SAMPLE) · Original Contract 1,240,000.00 · Retainage % 10.00%
  • Xray_SAMPLE_PayApp_Lines.csv row 14: Job # X-2207 · Application # 2 · Period To 02/28/2026 · Line # 3 · Description Above-ground plumbing · Scheduled Value 176,000.00 · Previously Billed 0.00 · This Period 18,100.00 · Materials Stored 0.00 · Completed to Date 17,600.00 · % Complete 10.00% · Balance to Finish 158,400.00 · Retainage 1,760.00 · CO Ref
  • Xray_SAMPLE_PayApp_Lines.csv row 26: Job # X-2207 · Application # 3 · Period To 03/31/2026 · Line # 4 · Description HVAC ductwork · Scheduled Value 214,000.00 · Previously Billed 30,600.00 · This Period 33,600.00 · Materials Stored 0.00 · Completed to Date 64,200.00 · % Complete 30.00% · Balance to Finish 149,800.00 · Retainage 6,420.00 · CO Ref
  • Xray_SAMPLE_PayApp_Lines.csv row 28: Job # X-2207 · Application # 3 · Period To 03/31/2026 · Line # 6 · Description Hydronic piping · Scheduled Value 132,000.00 · Previously Billed 13,200.00 · This Period 13,200.00 · Materials Stored 0.00 · Completed to Date 26,400.00 · % Complete 30.00% · Balance to Finish 105,600.00 · Retainage 2,640.00 · CO Ref
  • Xray_SAMPLE_PayApp_Lines.csv row 38: Job # X-2207 · Application # 4 · Period To 04/30/2026 · Line # 2 · Description Underground plumbing · Scheduled Value 148,000.00 · Previously Billed 111,000.00 · This Period 22,200.00 · Materials Stored 0.00 · Completed to Date 133,200.00 · % Complete 90.00% · Balance to Finish 15,800.00 · Retainage 13,320.00 · CO Ref
  • Xray_SAMPLE_PayApp_Lines.csv row 61: Job # X-2207 · Application # 5 · Period To 05/31/2026 · Line # 9 · Description Pipe and duct insulation · Scheduled Value 58,000.00 · Previously Billed 5,800.00 · This Period 8,700.00 · Materials Stored 0.00 · Completed to Date 14,500.00 · % Complete 25.00% · Balance to Finish 43,500.00 · Retainage 810.00 · CO Ref
  • Xray_SAMPLE_PayApp_Lines.csv row 76: Job # X-2207 · Application # 6 · Period To 06/30/2026 · Line # 5 · Description HVAC equipment · Scheduled Value 238,000.00 · Previously Billed 119,000.00 · This Period 23,700.00 · Materials Stored 12,000.00 · Completed to Date 154,700.00 · % Complete 65.00% · Balance to Finish 83,300.00 · Retainage 15,470.00 · CO Ref
  • Xray_SAMPLE_PayApp_Lines.csv row 78: Job # X-2207 · Application # 6 · Period To 06/30/2026 · Line # 7 · Description Building automation controls · Scheduled Value 86,000.00 · Previously Billed 28,050.00 · This Period 10,650.00 · Materials Stored 0.00 · Completed to Date 38,700.00 · % Complete 45.00% · Balance to Finish 47,300.00 · Retainage 3,870.00 · CO Ref
  • Xray_SAMPLE_PayApp_Lines.csv row 79: Job # X-2207 · Application # 6 · Period To 06/30/2026 · Line # 8 · Description Medical gas systems · Scheduled Value 74,000.00 · Previously Billed 66,600.00 · This Period 14,800.00 · Materials Stored 0.00 · Completed to Date 81,400.00 · % Complete 110.00% · Balance to Finish -7,400.00 · Retainage 8,140.00 · CO Ref
  • Xray_SAMPLE_PayApp_Lines.csv row 81: Job # X-2207 · Application # 6 · Period To 06/30/2026 · Line # 10 · Description Testing, balancing and startup · Scheduled Value 52,000.00 · Previously Billed 20,800.00 · This Period 33,020.00 · Materials Stored 0.00 · Completed to Date 53,820.00 · % Complete 103.50% · Balance to Finish -1,820.00 · Retainage 5,382.00 · CO Ref
  • Xray_SAMPLE_PayApp_Lines.csv row 83: Job # X-2207 · Application # 6 · Period To 06/30/2026 · Line # 12 · Description CO-02 Upsize chilled water branch to imaging suite · Scheduled Value 15,800.00 · Previously Billed 14,220.00 · This Period 2,844.00 · Materials Stored 0.00 · Completed to Date 17,064.00 · % Complete 108.00% · Balance to Finish -1,264.00 · Retainage 1,706.40 · CO Ref CO-02
  • Xray_SAMPLE_PayApp_Lines.csv row 84: Job # X-2207 · Application # 6 · Period To 06/30/2026 · Line # 13 · Description CO-03 Add backflow preventer at main service · Scheduled Value 9,450.00 · Previously Billed 9,450.00 · This Period 0.00 · Materials Stored 0.00 · Completed to Date 9,450.00 · % Complete 100.00% · Balance to Finish 0.00 · Retainage 945.00 · CO Ref CO-03
  • Xray_SAMPLE_PayApp_Lines.csv row 85: Job # X-2207 · Application # 6 · Period To 06/30/2026 · Line # 14 · Description CO-03 Add backflow preventer at main service · Scheduled Value 9,450.00 · Previously Billed 9,450.00 · This Period 0.00 · Materials Stored 0.00 · Completed to Date 9,450.00 · % Complete 100.00% · Balance to Finish 0.00 · Retainage 945.00 · CO Ref CO-03
  • Xray_SAMPLE_PayApp_Lines.csv row 88: Job # X-2207 · Application # 6 · Period To 06/30/2026 · Line # 17 · Description CO-07 Nurse call room humidifier tie-in · Scheduled Value 6,300.00 · Previously Billed 0.00 · This Period 2,520.00 · Materials Stored 0.00 · Completed to Date 2,520.00 · % Complete 40.00% · Balance to Finish 3,780.00 · Retainage 252.00 · CO Ref CO-07
  • Xray_SAMPLE_PayApp_Summary.csv row 3: Job # X-2207 · Application # 2 · Period To 02/28/2026 · Status Approved · Retainage % 10.00% · Original Contract Sum 1,240,000.00 · Net Change by Change Orders 24,600.00 · Contract Sum to Date 1,264,600.00 · Total Completed & Stored to Date 175,840.00 · Retainage 17,584.00 · Total Earned Less Retainage 158,256.00 · Less Previous Certificates 54,090.00 · Current Payment Due 104,166.00
  • Xray_SAMPLE_PayApp_Summary.csv row 5: Job # X-2207 · Application # 4 · Period To 04/30/2026 · Status Approved · Retainage % 10.00% · Original Contract Sum 1,240,000.00 · Net Change by Change Orders 78,500.00 · Contract Sum to Date 1,318,500.00 · Total Completed & Stored to Date 577,380.00 · Retainage 57,738.00 · Total Earned Less Retainage 519,642.00 · Less Previous Certificates 321,679.00 · Current Payment Due 197,963.00
  • Xray_SAMPLE_PayApp_Summary.csv row 6: Job # X-2207 · Application # 5 · Period To 05/31/2026 · Status Approved · Retainage % 5.00% · Original Contract Sum 1,240,000.00 · Net Change by Change Orders 106,800.00 · Contract Sum to Date 1,346,800.00 · Total Completed & Stored to Date 805,820.00 · Retainage 40,291.00 · Total Earned Less Retainage 765,529.00 · Less Previous Certificates 519,642.00 · Current Payment Due 245,887.00
  • Xray_SAMPLE_PayApp_Summary.csv row 7: Job # X-2207 · Application # 6 · Period To 06/30/2026 · Status Submitted · Retainage % 10.00% · Original Contract Sum 1,240,000.00 · Net Change by Change Orders 106,800.00 · Contract Sum to Date 1,346,800.00 · Total Completed & Stored to Date 1,003,204.00 · Retainage 100,320.40 · Total Earned Less Retainage 903,183.60 · Less Previous Certificates 765,529.00 · Current Payment Due 137,654.60
  • Xray_SAMPLE_Payments_Received.csv row 3: Date Received 04/03/2026 · Job # X-2207 · Invoice # INV-2207-02 · Amount 101,166.00
  • Xray_SAMPLE_Payments_Received.csv row 6: Date Received 06/03/2026 · Job # X-2207 · Invoice # INV-2207-04 · Amount 196,712.50
  • Xray_SAMPLE_Payments_Received.csv row 7: Date Received 07/02/2026 · Job # X-2207 · Invoice # INV-2207-05 · Amount 122,943.50
  • Xray_SAMPLE_Payments_Received.csv row 8: Date Received 07/10/2026 · Job # X-2207 · Invoice # INV-2207-05 · Amount 116,943.50
  • Xray_SAMPLE_Request.json row 1: value 2026-06-30
  • Xray_SAMPLE_Request.json row 3: name Conditional lien waiver - pay app 6 · label Conditional lien waiver for pay app 6 · payAppNo 6
  • Xray_SAMPLE_Request.json row 4: name Certified payroll - June 2026 · label Certified payroll for June 2026
  • Xray_SAMPLE_Request.json row 5: name Signed change order CO-07 · label Signed change order CO-07
  • Xray_SAMPLE_Retainage_Ledger.csv row 7: Job # X-2207 · As Of 06/30/2026 · Retainage Held to Date 102,720.40 · Retainage Released 0.00 · Retainage Balance 102,720.40 · Release Terms 10% held; phase 1 release date set with the GC (see the X-Ray request)
  • Xray_SAMPLE_SOV.csv row 14: Job # X-2207 · Line # 13 · Description CO-03 Add backflow preventer at main service · Type Change Order · Change Order CO-03 · Scheduled Value 9,450.00
  • Xray_SAMPLE_SOV.csv row 15: Job # X-2207 · Line # 14 · Description CO-03 Add backflow preventer at main service · Type Change Order · Change Order CO-03 · Scheduled Value 9,450.00
  • Xray_SAMPLE_SOV.csv row 16: Job # X-2207 · Line # 15 · Description CO-04 Lab exhaust duct reroute at corridor C · Type Change Order · Change Order CO-04 · Scheduled Value 12,000.00
  • Xray_SAMPLE_SOV.csv row 17: Job # X-2207 · Line # 16 · Description CO-05 Emergency eyewash stations in soiled utility rooms · Type Change Order · Change Order CO-05 · Scheduled Value 7,200.00
  • Xray_SAMPLE_SOV.csv row 19: Job # X-2207 · Line # 18 · Description CO-08 Dental vacuum pump and piping · Type Change Order · Change Order CO-08 · Scheduled Value 11,000.00
  • Xray_SAMPLE_SOV.csv row 20: Job # X-2207 · Line # 19 · Description CO-08 Dental vacuum pump and piping · Type Change Order · Change Order CO-08 · Scheduled Value 11,000.00