Demo audit · DEMO-HARBOR
6 change orders and 7 invoices, run through the live reconciliation engine.
Potentially unbilled approved
$12,000.00
Approved change-order value
$23,000.00
Net invoiced (approved COs)
$11,000.00
Discrepancies
6
Needing review
4
Fully reconciled
1
| # | Project | CO | Category | Amount | Description | Evidence | Confidence | Review |
|---|---|---|---|---|---|---|---|---|
| F-001 | DEMO-HARBOR | CO-102 | Approved, not invoiced | $8,000.00 | Change order CO-102 is approved for $8,000.00 but no net invoiced value was found against it. | demo_change_orders.csv · row 3 | verified | Open |
| F-002 | DEMO-HARBOR | CO-101 | Partially invoiced | $4,000.00 | Change order CO-101 is approved for $10,000.00; net invoiced is $6,000.00. Difference of $4,000.00 is potentially unbilled. | demo_change_orders.csv · row 2 demo_invoices.csv · row 2 | verified | Open |
| F-003 | DEMO-HARBOR | CO-101 | Duplicate invoice ID | $6,000.00 | Invoice INV-5001 appears more than once. Only the first row (row 2) is counted toward invoiced value; confirm whether this is a duplicate entry or a separate invoice. | demo_invoices.csv · row 2 demo_invoices.csv · row 5 | Needs review | Open |
| F-004 | DEMO-MARINA | CO-102 | Project ID mismatch | $2,500.00 | Invoice INV-5005 references CO-102 under project DEMO-MARINA, but that change order exists under project DEMO-HARBOR. Not applied automatically. | demo_invoices.csv · row 7 demo_change_orders.csv · row 3 | Needs review | Open |
| F-005 | DEMO-HARBOR | CO-106 | Inconsistent status | $1,500.00 | Change order CO-106 is "Rejected" but has invoices totalling $1,500.00. Inconsistent status — possible credit required or status error. | demo_change_orders.csv · row 7 demo_invoices.csv · row 8 | Needs review | Open |
| F-006 | DEMO-HARBOR | — | Missing CO reference | $750.00 | Invoice INV-5004 has no change-order reference, so it was not applied to any change order. If it relates to a change order, add the reference and re-run. | demo_invoices.csv · row 6 | Needs review | Open |
| F-007 | DEMO-HARBOR | CO-103 | Pending approval | $12,000.00 | Change order CO-103 is "Pending Approval". Not approved, so excluded from the potentially unbilled total. | demo_change_orders.csv · row 4 | verified | Open |
| F-008 | DEMO-HARBOR | CO-105 | Cancelled / rejected | $9,000.00 | Change order CO-105 is "Cancelled". Excluded from the potentially unbilled total. | demo_change_orders.csv · row 6 | verified | Open |
| F-009 | DEMO-HARBOR | CO-104 | Fully reconciled | $5,000.00 | Change order CO-104 is fully invoiced across 2 invoice(s). 1 invoice(s) not marked paid — a collections matter, not unbilled revenue. | demo_change_orders.csv · row 5 demo_invoices.csv · row 3 demo_invoices.csv · row 4 | normalized | Open |
View the source registers
demo_change_orders.csv
| row 2 | DEMO-HARBOR | CO-101 | [FICTIONAL] Add 4 sub-panels, level 3 | 10,000.00 | 10,000.00 | Approved | 2026-03-02 | Fictional Builders Co. |
| row 3 | DEMO-HARBOR | CO-102 | [FICTIONAL] Relocate rooftop disconnects | $8,000 | 8,000 | Approved | 2026-03-10 | Fictional Builders Co. |
| row 4 | DEMO-HARBOR | CO-103 | [FICTIONAL] Additional EV chargers (awaiting GC sign-off) | 12,000 | Pending Approval | 2026-03-18 | Fictional Builders Co. | |
| row 5 | DEMO-HARBOR | CO-104 | [FICTIONAL] Emergency lighting upgrade | 5,000 | 5,000 | Approved | 2026-03-20 | Fictional Builders Co. |
| row 6 | DEMO-HARBOR | CO-105 | [FICTIONAL] Lobby feature lighting (owner cancelled) | 9,000 | 9,000 | Cancelled | 2026-03-25 | Fictional Builders Co. |
| row 7 | DEMO-HARBOR | CO-106 | [FICTIONAL] Temporary power extension (rejected) | 1,500 | Rejected | 2026-04-01 | Fictional Builders Co. |
demo_invoices.csv
| row 2 | DEMO-HARBOR | INV-5001 | CO-101 | 6,000.00 | 2026-03-30 | Paid |
| row 3 | DEMO-HARBOR | INV-5002 | CO-104 | 3,000.00 | 2026-04-02 | Paid |
| row 4 | DEMO-HARBOR | INV-5003 | co 104 | 2,000.00 | 2026-04-15 | Issued |
| row 5 | DEMO-HARBOR | INV-5001 | CO-101 | 6,000.00 | 2026-03-30 | Paid |
| row 6 | DEMO-HARBOR | INV-5004 | 750.00 | 2026-04-20 | Issued | |
| row 7 | DEMO-MARINA | INV-5005 | CO-102 | 2,500.00 | 2026-04-22 | Issued |
| row 8 | DEMO-HARBOR | INV-5006 | CO-106 | 1,500.00 | 2026-04-25 | Issued |
Findings are potential discrepancies identified by automated comparison of the uploaded registers. They require verification against contracts, approvals, invoices and accounting records. This report does not establish legal entitlement and does not guarantee collection or recovery of any amount.
