Inspectable evidence | Synthetic data

Invoice Routing Completeness Control

Pay Application 002. This artifact demonstrates how a coordinator can reconcile the request to the commitment, identify missing support, and hold routing until the package is administratively complete.

Portfolio reconstruction: PA-002, its values, dates, parties, and support records are fictional. The control demonstrates administrative review and exception handling.
Pay applicationPA-002
Gross request$142,500
Retainage$7,125
Net request$135,375
Revised commitment$523,000
Routing statusHold, two required records missing
Control objective: Prevent an incomplete pay application from entering the approval queue. The coordinator verifies record consistency, required attachments, arithmetic, and routing sequence, then sends substantive review to authorized personnel.

Financial reconciliation

Request-to-commitment check

The values below show the administrative reconciliation performed before routing. They do not constitute certification or payment approval.

Original commitment$485,000
Approved changes$38,000
Revised commitment$523,000
Gross billed to date$260,500
Remaining commitment$262,500
Important boundary: Only approved CO-001 is included in the revised commitment. Pending PCN-002 and PCN-003 are excluded from billing until authorized.

Routing gates

What controls the next step

A complete package can advance for review. An incomplete package stays visible, with the missing requirement, owner, and due date recorded.

Complete

Identity and commitment

The project, vendor, billing period, original commitment, approved change, and revised commitment match the source records.

Complete

Billing calculation

The schedule of values, five percent retainage, prior billing, current request, and billed-to-date total are present and arithmetically consistent.

Complete

Progress support

Progress reports, photographs, and quantity support are attached for Construction Manager review.

Missing

Certified payroll

The required payroll package is absent. The contractor owns the correction and the pay application cannot advance.

Missing

Conditional lien release

The executed release through the billing period is absent. The coordinator records the hold and requested resubmission date.

After completion

Authorized routing

Construction, project, finance, and owner reviewers receive the package only after the two missing records are verified.

Completeness matrix

Evidence, gate, and ownership

The matrix makes the hold reason specific and prevents a vague status such as "pending" from hiding the next required action.

RequirementEvidenceStatusRouting gateOwner and next action
Commitment valuesCommitment register and CO-001CompleteFinancial reviewFinance Analyst to confirm revised commitment
Schedule of valuesPA-002 billing detailCompleteProject reviewConstruction Manager to validate progress
Retainage and prior billingPA-001, invoice tracker, five percent calculationCompleteFinancial reviewFinance Analyst to check contract terms and duplicate billing
Certified payrollRequired payroll packageMissingDo not routeGeneral Contractor to submit by Oct 12
Conditional lien releaseExecuted release through billing periodMissingDo not routeGeneral Contractor to submit by Oct 12
Approval sequenceConstruction, project, finance, and owner routing mapCompleteApproval routingCoordinator routes only after missing support is closed
Final payment recordAuthorized payment confirmationNot startedPost-payment controlCoordinator updates the tracker after system confirmation

Controls built into the routing process

  • Commitment reconciliation: The pay application is checked against the original commitment, approved changes, revised commitment, prior billing, and remaining balance.
  • Pending-change exclusion: Proposed changes are not treated as billable until approved and incorporated into the commitment record.
  • Required-document gate: Missing payroll and lien-release records stop routing rather than becoming informal follow-up items after approval begins.
  • Specific ownership: Each missing item has one owner and one due date.
  • Approval separation: Administrative verification does not replace field-progress validation, financial review, or owner authorization.
  • System-of-record discipline: The tracker is marked paid only after confirmation from the authorized accounting or project platform.

The downloadable CSV contains the detailed verification record, routing gates, owners, dates, and coordinator notes.