Change-order revenue audit

Approved work.Unbilled revenue.Now visible.

VARIQ reconciles your change-order register against your invoices, line by line — and shows the approved work that may never have been billed, with the source row behind every dollar.

To the cent
Integer math
Deterministic
No AI guesses
Row-level
Evidence
01The leak

Approved in one register. Billed from another.

The gap between them is where revenue goes quiet — not through fraud, but because nobody has time to compare two spreadsheets line by line.

01
Never invoiced

An approved change order with no invoice against it, anywhere.

02
Short-billed

Invoices that net below the approved value after credits and voids.

03
Broken references

The right CO under the wrong project, or a reference with a typo.

04
Hidden duplicates

The same invoice keyed twice — inflating billed totals and masking gaps.

02How it works

Two exports. One reconciliation.

Watch the sample project reconcile. The same fixed rules run on your own registers — about ten minutes from upload to findings.

  1. 01Upload

    Both registers are read, row by row.

  2. 02Map

    Columns recognised: reference, amount, status.

  3. 03Reconcile

    Each approved CO is matched to its invoices by project and reference.

  4. 04Flag

    Gaps, duplicates and broken references are surfaced — never auto-applied.

  5. 05Total

    Only approved, unbilled value is counted.

Live reconciliationSample data
Change-order register
CO-101
Approved
10,000.00Short · 4,000.00
CO-102
Approved
8,000.00No invoice · 8,000.00
CO-103
Pending
12,000.00Excluded · pending
CO-104
Approved
5,000.00Reconciled
CO-105
Cancelled
9,000.00Excluded · cancelled
Invoice register
INV-5001
→ CO-101
6,000.00 
INV-5002
→ CO-104
3,000.00 
INV-5003
→ co 104
2,000.00Ref normalised
INV-5001
→ CO-101
6,000.00Duplicate · not counted
INV-5004
→ —
750.00Missing CO ref
INV-5005
→ CO-102
2,500.00Other project · not applied
Approved CO value
$23,000.00
3 approved change orders
Flagged above
3
for review · not counted
Potentially unbilled
$0.00
8,000 + 4,000 · every row cited
03The product

Totals first. Then every finding, ranked.

Built for the finance lead who has to defend a number. Every line traces back to the row it came from.

app.variq · Harbor Tower — Electrical
SAMPLE DATA
Potentially unbilled
$12,000.00
2 approved COs
Approved CO value
$23,000.00
3 of 6 change orders
Needs review
4
flagged, not counted
All categoriesSort: priority9 findings · 13 source rows
IDCOFindingAmountEvidenceConfidence
F-001CO-102Approved, not invoiced$8,000.00change_orders.csv · r3Verified
F-002CO-101Partially invoiced$4,000.00invoices.xlsx · r2Verified
F-003CO-101Duplicate invoice ID$6,000.00invoices.xlsx · r5Review
F-004CO-102Project ID mismatch$2,500.00invoices.xlsx · r7Review
F-005CO-103Pending — excluded$12,000.00change_orders.csv · r4Verified
F-006CO-104Fully reconciled$5,000.002 invoices matchedVerified
04Why it matters
Sample data
$0
$5,000,000 approved change orders × 1% left uninvoiced
How approved work goes quiet
01Approved

The GC signs the change order in the field. Work proceeds.

02Recorded

It lands in the CO register — one spreadsheet, one owner.

03Billed elsewhere

Invoices are raised from a different system, by a different person.

The gap

Nobody compares the two. Approved value is never invoiced.

Reads both registers

Your CO export and your invoice export — nothing else needed.

Calculates to the cent

Integer arithmetic, fixed rules. No AI guesses in the money.

Shows the evidence

Every finding cites its file and row, so you can defend it.

Counts only what's owed

Pending, rejected and cancelled work is shown, never totalled.

05What it detects

Every finding arrives with its receipt.

Open the sample audit
Approved · not invoiced
$8,000.00

Approved for $8,000. No invoice in the register references it.

CO-102 · change_orders.csv · row 3
Partially invoiced
$4,000.00

Approved $10,000, net invoiced $6,000. The $4,000 remainder is flagged.

CO-101 · invoices.csv · row 2
Reference mismatch
$—

Invoice cites the right CO under a different project ID. Flagged, never auto-applied.

CO-102 · invoices.csv · row 6
Pending · excluded
$—

Awaiting approval. Shown for visibility, never counted as money owed.

CO-103 · change_orders.csv · row 4

Sample data

06Pricing

One project. One fixed fee.

No subscription. Preview your own audit free — pay only to unlock the full findings and exports.

Beta AccessFirst 3 customers
$199One-time

One complete project audit at the beta rate.

  • One complete project audit
  • Potential billing discrepancy detection
  • Summary findings report
  • PDF export
VARIQ Pro
$999Per month

For firms auditing projects every month.

  • 2 complete project audits per billing month
  • Detailed reconciliation and discrepancy detection
  • Advanced downloadable reports
  • Full audit history
  • Priority email support
  • Subscription management
07Questions

Straight answers.

Find what slipped through.

Upload two registers. See what may be unbilled — with the evidence to prove it.