Skip to content

Sample — synthetic data

Revenue Control Assessment Report — SAMPLE

Northfield Electrical Contractors (SAMPLE) is a fictional company. This report was produced by Main’s real engine from its synthetic exports (data as of August 31, 2026). Nothing here describes a real company, project or result.

Download the sample report (PDF, SAMPLE data). We email it to you.

We keep your address as a request and a person at Main may follow up.

Next step: a Revenue Control Assessment, $750 for up to five projects, each finding reviewed by a person before it goes in the report. Book a review call

Prepared for
Northfield Electrical Contractors (SAMPLE)
Data as of
August 31, 2026
Produced by
Main engine · SAMPLE dataset

The SAMPLE exports behind this report

These 13 files are the fictional Northfield exports the engine read. They show the format Main expects: ordinary CSV exports from a job-cost system, a billing platform and spreadsheets, with your own column names. Every file is synthetic and labelled SAMPLE.

Executive summary

Verify what you've earned. Reconcile what you've billed. Understand your margin. See what's holding up cash.

Projects reviewed
5
Project value represented
$19,867,746
Revenue items in buckets
13

Four control areas

Each section is reported on its own; the counts are never added together. Main supports the controller's and CPA's work — it does not prepare or attest financial statements or determine revenue-recognition policy.

Revenue and cash

Findings by bucket

Approved changes not found on billing

None in this release
0 revenue items

An observation: approved work the records do not show as billed, or show billed for less. Approved is not always billable now, and the amount is not a verified amount owed.

Empty in this release: Main does not yet place a finding here on its own. Approved changes it could not match to billing are listed under Record conflicts.

Record conflicts

$138,862
8 revenue items

Two records disagree. The amount is the size of the disagreement, not money owed.

Commercial exposure

$199,723
3 revenue items

Pending changes, retainage and amounts whose status depends on context.

Cash delayed

$192,905
2 revenue items

Properly billed, not yet collected.

The four amounts are different kinds of money and are never added together. 13 revenue items in total; each appears in exactly one bucket. Amounts are as found in the SAMPLE records; no person reviewed or verified them.

Partially assessed · 10 findings

Revenue Integrity

Change orders, schedule of values and billing reconciled against each other.

Each finding shows why Main flagged it. Open any item to see its lineage and the exact rows behind it; hover or tap a difference to highlight the records it comes from.

Sample Strong evidenceRequires confirmation

$27,860.00

Reconciliation discrepancy — allocation unknown. No bill line names change order CO-09. The gap is $27,860.00.

Fulton & 9th Mixed-Use (SAMPLE) · Record conflicts

Why Main flagged this

  1. Change requested$27,860.00
  2. Approved$27,860.00
  3. Reported by Ledgerline Billing Platform (SAMPLE)$27,860.00
  4. Not on the schedule of values or billedMissing

Check: Reconciliation discrepancy — allocation unknown · Record conflicts

Source evidence

  1. Source recordNorthfield_SAMPLE_CO_Log.csv · row 30$27,860.00CO log: CO-09 approved 2026-06-12
  2. Checked againstNorthfield_SAMPLE_PayApp_Summary.csv · row 1331 linespay app 8 (period to 2026-06-30) checked: no line references CO-09, none matches its amount or description
  3. Checked againstNorthfield_SAMPLE_PayApp_Summary.csv · row 1432 linespay app 9 (period to 2026-07-31) checked: no line references CO-09, none matches its amount or description
  4. Checked againstNorthfield_SAMPLE_PayApp_Summary.csv · row 1532 linespay app 10 (period to 2026-08-31) checked: no line references CO-09, none matches its amount or description

What Main knows

  • CO-09 was approved for $27,860.00 on 2026-06-12.
  • 3 pay applications with periods ending 2026-06-30 through 2026-08-31 were checked.
  • No SOV line, pay-app line or invoice references it, and no line matches its amount or description.

What Main cannot determine

  • Whether the work has been performed yet.
  • Whether it was billed through a channel not included in this data.

Why this matters to your cash 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 — confirm with your team first
  1. Compare CO-09 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.

How an item moves once your team acts (illustration):

  • Unreviewed
  • Customer confirmed
  • Verified resolved
Sample Strong evidenceRequires confirmation

$27,000.00

Your records show 2 different original contract values for this project, a gap of $27,000.00.

Fulton & 9th Mixed-Use (SAMPLE) · Record conflicts

Why Main flagged this

Primary record$8,752,000.00Ledgerline Billing Platform (SAMPLE) — BillingPlatform_Contracts.csv · row 5
Compared records (2)$8,725,000.00projects list — Projects.csv · row 5pay app 7 — PayApp_Summary.csv · row 12
Difference$27,000.00The size of the disagreement, not money owed.
  1. Contract value recorded$8,725,000.00
  2. Reported by Ledgerline Billing Platform (SAMPLE)$8,752,000.00

Check: Contract value differs between records · Record conflicts

Evidence, what Main knows and cannot determine, recommended action

Source evidence

  1. Source recordNorthfield_SAMPLE_BillingPlatform_Contracts.csv · row 5$8,752,000.00Ledgerline Billing Platform (SAMPLE)
  2. Checked againstNorthfield_SAMPLE_Projects.csv · row 5$8,725,000.00projects list
  3. Checked againstNorthfield_SAMPLE_PayApp_Summary.csv · row 12$8,725,000.00pay app 7

What Main knows

  • 6 records state this project's original contract value; 2 different values appear.

What Main cannot determine

  • Which value matches the executed subcontract.

Possible explanation

Digit transposition (possible cause — confirm): $8,752,000.00 and $8,725,000.00 contain the same digits in a different order (a keying transposition).

Why this matters to your cash The original contract value drives every pay app and your WIP schedule. If the records disagree, billing may be based on the wrong number.

What to do next — confirm with your team first
  1. Find the value in the signed subcontract.
  2. Correct each record that shows a different value.
  3. Check that the next pay app uses the right contract sum.
Sample Strong evidenceRequires confirmation

$5,400.00

Pay app 6 for the period ending Jul 31, 2026 has a figure that does not add up; the gap is $5,400.00.

Riverside Medical Office Building (SAMPLE) · Record conflicts

Why Main flagged this

Main recomputed
  1. Previously billed$120,323.00
  2. This period$73,066.00
  3. Stored$0.00
  4. = Completed to date (recomputed)$193,389.00
Reported on the pay application$198,789.00PayApp_Lines.csv · row 52
Difference$5,400.00The size of the disagreement, not money owed.
  1. Billed$493,787.70
  2. Invoiced$493,787.70

Check: Pay app discrepancy · Record conflicts

Evidence, what Main knows and cannot determine, recommended action

Source evidence

  1. Source recordNorthfield_SAMPLE_PayApp_Lines.csv · row 52$198,789.00line 6 "Branch Rough-In - Level 2": previously billed $120,323.00 + this period $73,066.00 + stored $0.00 = $193,389.00, but completed to date shows $198,789.00

What Main knows

  • Line 6 "Branch Rough-In - Level 2": previously billed $120,323.00 + this period $73,066.00 + stored $0.00 = $193,389.00, but completed to date shows $198,789.00.

What Main cannot determine

  • Which figure is correct (the arithmetic only shows that they cannot all be).

Why this matters to your cash 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 — confirm with your team first
  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.

More Revenue Integrity findings 7

$22,400.00 Approved change order CO-08 for $22,400.00 was billed on its own invoice (4424) but is not on your schedule of values. The $1,120.00 difference is the 5% retainage held.Eastbrook Middle School Renovation (SAMPLE) · Record conflicts Strong evidenceRequires confirmation

Why Main flagged this

  1. Change requested$22,400.00
  2. Approved$22,400.00
  3. Invoiced$21,280.00
  4. Reported by Ledgerline Billing Platform (SAMPLE)$22,400.00

Check: Change order log and schedule of values disagree · Record conflicts

Source evidence

  1. Source recordNorthfield_SAMPLE_CO_Log.csv · row 16$22,400.00CO log: CO-08
  2. Related recordNorthfield_SAMPLE_AR_Invoice_Register.csv · row 25$21,280.00invoice 4424 references CO-08

What Main knows

  • CO-08 is approved for $22,400.00.
  • It was invoiced on 1 standalone invoice totaling $21,280.00. The $1,120.00 difference is the 5% retainage held.
  • No SOV or pay-app line carries it, so contract sum to date excludes it.
  • Also flagged for this item: Invoice 4424 has $21,280.00 unpaid, 37 days past its due date as of Aug 31, 2026 (your data's as-of date).

What Main cannot determine

  • Whether the GC accepts change billing outside the payment application.
  • Whether the GC has disputed or scheduled the payment.

Why this matters to your cash Because the change is not on the schedule of values, the contract total on your pay apps is too low. The GC may not accept change billing outside the pay app.

What to do next — confirm with your team first
  1. Ask the GC whether they accept CO-08 billed on its own invoice.
  2. If not, add CO-08 to your schedule of values.
  3. Bill it on the pay app and credit the separate invoice.
$14,725.50 Reconciliation discrepancy — allocation unknown. No bill line names change order CO-06. The gap is $14,725.50.Eastbrook Middle School Renovation (SAMPLE) · Record conflicts Strong evidenceRequires confirmation

Why Main flagged this

  1. Change requested$14,725.50
  2. Approved$14,725.50
  3. Reported by Ledgerline Billing Platform (SAMPLE)$14,725.50
  4. Not on the schedule of values or billedMissing

Check: Reconciliation discrepancy — allocation unknown · Record conflicts

Source evidence

  1. Source recordNorthfield_SAMPLE_CO_Log.csv · row 14$14,725.50CO log: CO-06 approved 2026-05-22
  2. Checked againstNorthfield_SAMPLE_PayApp_Summary.csv · row 723 linespay app 3 (period to 2026-06-30) checked: no line references CO-06, none matches its amount or description
  3. Checked againstNorthfield_SAMPLE_PayApp_Summary.csv · row 823 linespay app 4 (period to 2026-07-31) checked: no line references CO-06, none matches its amount or description
  4. Checked againstNorthfield_SAMPLE_PayApp_Summary.csv · row 923 linespay app 5 (period to 2026-08-31) checked: no line references CO-06, none matches its amount or description

What Main knows

  • CO-06 was approved for $14,725.50 on 2026-05-22.
  • 3 pay applications with periods ending 2026-06-30 through 2026-08-31 were checked.
  • No SOV line, pay-app line or invoice references it, and no line matches its amount or description.

What Main cannot determine

  • Whether the work has been performed yet.
  • Whether it was billed through a channel not included in this data.

Why this matters to your cash 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 — confirm with your team first
  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.
$2,700.00 Your change order log shows CO-03 at $21,940.00, but your schedule of values carries $19,240.00, a gap of $2,700.00.Cedar Point Biosciences Lab Fit-Out (SAMPLE) · Record conflicts Strong evidenceRequires confirmation

Why Main flagged this

Primary record$21,940.00Change-order log — CO_Log.csv · row 38
Compared record$19,240.00SOV line 22 "CO #03 - Lab casework power revisions per ASI-05" references CO-03 — SOV.csv · row 121
Difference$2,700.00The size of the disagreement, not money owed.
  1. Change requested$21,940.00
  2. Approved$21,940.00
  3. On the schedule of values$19,240.00
  4. Billed on a pay app$9,620.00
  5. Billed on a pay app$19,240.00
  6. Billed on a pay app$19,240.00
  7. Billed on a pay app$19,240.00
  8. Reported by Ledgerline Billing Platform (SAMPLE)$21,940.00

Check: Change order log and schedule of values disagree · Record conflicts

Source evidence

  1. Source recordNorthfield_SAMPLE_CO_Log.csv · row 38$21,940.00CO log: CO-03
  2. Checked againstNorthfield_SAMPLE_SOV.csv · row 121$19,240.00SOV line 22 "CO #03 - Lab casework power revisions per ASI-05" references CO-03

What Main knows

  • The CO log shows CO-03 at $21,940.00.
  • The SOV line referencing it total $19,240.00.

What Main cannot determine

  • Which record reflects the executed change order amount.

Why this matters to your cash 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 — confirm with your team first
  1. Find the change-order document for CO-03.
  2. Check which amount is right.
  3. Correct the log or the schedule of values so they match.
$360.00 Your change order log shows CO-02 at $12,480.00, but Ledgerline Billing Platform (SAMPLE) shows $12,840.00, a gap of $360.00.Riverside Medical Office Building (SAMPLE) · Record conflicts Strong evidenceRequires confirmation

Why Main flagged this

Primary record$12,840.00Ledgerline Billing Platform (SAMPLE) — BillingPlatform_ChangeOrders.csv · row 3
Compared record$12,480.00CO log — CO_Log.csv · row 3
Difference$360.00The size of the disagreement, not money owed.
  1. Change requested$12,480.00
  2. Approved$12,480.00
  3. On the schedule of values$12,480.00
  4. Billed on a pay app$6,240.00
  5. Billed on a pay app$12,480.00
  6. Billed on a pay app$12,480.00
  7. Billed on a pay app$12,480.00
  8. Reported by Ledgerline Billing Platform (SAMPLE)$12,840.00

Check: Two systems disagree · Record conflicts

Source evidence

  1. Source recordNorthfield_SAMPLE_BillingPlatform_ChangeOrders.csv · row 3$12,840.00Ledgerline Billing Platform (SAMPLE)
  2. Checked againstNorthfield_SAMPLE_CO_Log.csv · row 3$12,480.00CO log

What Main knows

  • The CO log and Ledgerline Billing Platform (SAMPLE) disagree on CO-02.

What Main cannot determine

  • Which system reflects the executed change order.

Possible explanation

Digit transposition (possible cause — confirm): $12,840.00 and $12,480.00 contain the same digits in a different order (a keying transposition).

Why this matters to your cash When two systems disagree, one of them is out of date or keyed wrong. Billing or collection may then be based on the wrong figure.

What to do next — confirm with your team first
  1. Find the change-order document for CO-02.
  2. Check which system matches it.
  3. Correct the other system.
$38,416.00 Reconciliation discrepancy — allocation unknown. No bill line names change order CO-04. Line 23 may cover the $38,416.00 gap.Riverside Medical Office Building (SAMPLE) · Record conflicts Needs your input

Why Main flagged this

  1. Change requested$38,416.00
  2. Approved$38,416.00
  3. Reported by Ledgerline Billing Platform (SAMPLE)$38,416.00
  4. Possible match on schedule line 23 (confirm)Missing

Check: Reconciliation discrepancy — allocation unknown · Record conflicts

Source evidence

  1. Source recordNorthfield_SAMPLE_CO_Log.csv · row 5$38,416.00CO log: CO-04 approved 2026-06-18
  2. Possible matchNorthfield_SAMPLE_SOV.csv · row 24$38,416.00possible match by amount: line 23 "EV Charger Circuits - Parking Lot" scheduled $38,416.00
  3. Possible matchNorthfield_SAMPLE_PayApp_Lines.csv · row 46$38,416.00possible match by amount: line 23 "EV Charger Circuits - Parking Lot" scheduled $38,416.00
  4. Possible matchNorthfield_SAMPLE_PayApp_Lines.csv · row 69$38,416.00possible match by amount: line 23 "EV Charger Circuits - Parking Lot" scheduled $38,416.00
  5. Possible matchNorthfield_SAMPLE_PayApp_Lines.csv · row 93$38,416.00possible match by amount: line 23 "EV Charger Circuits - Parking Lot" scheduled $38,416.00

What Main knows

  • CO-04 is approved for $38,416.00 on 2026-06-18.
  • The project's approved change orders agree with the G702 net change by change orders on pay app 7.
  • Line 23 matches by amount.

What Main cannot determine

  • Whether line 23 is CO-04 billed under another description.

Why this matters to your cash 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 — confirm with your team first
  1. Compare CO-04 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.
$16,385.00 Change request PCO-18 for $16,385.00 has been waiting for an answer for 78 days as of Aug 31, 2026 (your data's as-of date).Fulton & 9th Mixed-Use (SAMPLE) · Commercial exposure Strong evidenceRequires follow-up

Why Main flagged this

  1. Change requested$16,385.00
  2. Pending$16,385.00
  3. Reported by Ledgerline Billing Platform (SAMPLE)$16,385.00

Check: Change request waiting for an answer · Commercial exposure

Source evidence

  1. Source recordNorthfield_SAMPLE_CO_Log.csv · row 322026-06-14CO log: PCO-18 status pending

What Main knows

  • PCO-18 was submitted on 2026-06-14 and is still pending in the CO log.

What Main cannot determine

  • Whether the GC has responded outside the CO log.

Why this matters to your cash Work on a pending change is not paid until the GC approves it. The longer a request waits, the harder it can be to get it approved and paid.

What to do next — confirm with your team first
  1. Ask the GC for a written status on PCO-18.
  2. If the work is done, send the backup again and ask for a decision date.
  3. Record the answer in your change order log.
$9,860.40 Change request PCO-07 for $9,860.40 has been waiting for an answer for 60 days as of Aug 31, 2026 (your data's as-of date).Cedar Point Biosciences Lab Fit-Out (SAMPLE) · Commercial exposure Strong evidenceRequires follow-up

Why Main flagged this

  1. Change requested$9,860.40
  2. Pending$9,860.40
  3. Reported by Ledgerline Billing Platform (SAMPLE)$9,860.40

Check: Change request waiting for an answer · Commercial exposure

Source evidence

  1. Source recordNorthfield_SAMPLE_CO_Log.csv · row 402026-07-02CO log: PCO-07 status pending

What Main knows

  • PCO-07 was submitted on 2026-07-02 and is still pending in the CO log.

What Main cannot determine

  • Whether the GC has responded outside the CO log.

Why this matters to your cash Work on a pending change is not paid until the GC approves it. The longer a request waits, the harder it can be to get it approved and paid.

What to do next — confirm with your team first
  1. Ask the GC for a written status on PCO-07.
  2. If the work is done, send the backup again and ask for a decision date.
  3. Record the answer in your change order log.

Assessed · 7 findings

Margin Integrity

The customer's WIP / job-cost schedule checked and explained as an independent control.

Northfield SAMPLE uses cost-to-cost percentage of completion. Main recomputes only under the declared method and shows the customer’s figure, Main’s figure and the exact difference; differences below the materiality threshold are recorded, not raised.

Sample Requires review

$36,000.00

This project is under-billed by $36,000.00 as of August 2026, and the gap has grown for 3 periods.

Fulton & 9th Mixed-Use (SAMPLE) · Margin Integrity · 2026-08

Why Main flagged this

How the $36,000.00 breaks down (from the supplied records)

  1. Recomputed underbilling$36,000.00
  2. Approved changes not on the billed contract (CO-09)earned share of $27,860.00$9,346.58
  3. Timing difference (CO-11)earned share of $11,240.00$3,770.84
  4. Work represented in supplied records but not yet billedpay-application completed-to-date above the WIP billed-to-date$0.00
  5. Unexplained remaindernot explained by the supplied records$22,882.58

Not counted Pending/unapproved change exposure (PCO-18, PCO-19): $28,445.00 — listed separately; never counted as earned revenue or as explaining the underbilling.

Contributing factors table, evidence, what Main knows and cannot determine

Potential contributing factors

FactorAmountHow it is treated
Approved changes not on the billed contract (CO-09)$27,860.00Earned share $9,346.58
Timing difference (CO-11)$11,240.00Earned share $3,770.84
Work represented in supplied records but not yet billed$0.00Shown as found
Pending/unapproved change exposure (PCO-18, PCO-19)$28,445.00Listed separately — never counted as earned revenue or as explaining the underbilling
Unexplained remainder$22,882.58Not explained by the supplied records

What Main knows

  • Recomputed underbilling at 2026-08: earned $2,980,261.00 − billed to date $2,944,261.00 = $36,000.00.
  • Underbilling grew in each of the last 3 periods: 2026-05 $4,000.00 → 2026-06 $13,500.00 → 2026-07 $24,500.00 → 2026-08 $36,000.00.
  • Potential contributing factor — approved changes not on the billed contract (CO-09): $27,860.00; earned share at 33.6% complete $9,346.58.
  • Potential contributing factor — timing difference (CO-11, approved within 10 days of the period end; expected on the next payment application): $11,240.00; earned share $3,770.84.
  • Potential contributing factor — work represented in supplied records but not yet billed: $0.00.
  • Pending/unapproved change exposure (PCO-18, PCO-19): $28,445.00 — Pending/unapproved changes are listed separately; they are never counted as earned revenue or as explaining the underbilling.
  • Unexplained remainder: $22,882.58.

What Main cannot determine

  • Whether the approved-but-unbilled work is complete and billable under the subcontract.
  • Any reason for the underbilling that is not in the supplied records.

Source evidence

  1. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 17$36,143.192026-08
  2. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 17$2,944,261.002026-08
  3. Change order logNorthfield_SAMPLE_CO_Log.csv · row 30$27,860.00CO-09 approved 2026-06-12, not on pay application #10
  4. Change order logNorthfield_SAMPLE_CO_Log.csv · row 35$11,240.00CO-11 approved 2026-08-26, not on pay application #10
  5. Pending changeNorthfield_SAMPLE_CO_Log.csv · row 32$16,385.00PCO-18 pending — not counted
  6. Pending changeNorthfield_SAMPLE_CO_Log.csv · row 34$12,060.00PCO-19 pending — not counted

Why this matters to your cash Under-billing means you have done more work than you have billed. That cash is tied up until you bill it.

What to do next — confirm with your team first
  1. Start with any approved changes listed below that are not billed yet.
  2. Bill approved work on the next pay app.
  3. Ask the project manager about any part that is not explained.

More margin findings 6

$9,415.00 The contract value on your WIP schedule differs from your change order log by $9,415.00 for August 2026.Eastbrook Middle School Renovation (SAMPLE) · Margin Integrity · 2026-08 Requires review

What Main knows

  • WIP 2026-08: contract $2,947,300.00 + approved changes $62,491.75 = $3,009,791.75.
  • Change-order register at 2026-08-31: original $2,947,300.00 + approved changes $71,906.75 = $3,019,206.75.
  • Billing (pay application #5, period to 2026-08-31): contract sum to date $2,982,081.25.
  • Of the WIP-vs-billing difference, $37,125.50 is approved change value in the register that is not on the billed contract sum (CO-06, CO-08) — reported under Revenue Integrity; the remaining -$9,415.00 is between the WIP and the register.
  • The difference equals the approved amount of CO-07 in the register.
  • The same difference appears in periods 2026-06, 2026-07, 2026-08.

What Main cannot determine

  • Which figure the customer intends as the contract value of record (WIP schedule, change-order log or billing system).

Source evidence

  1. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 9$62,491.752026-08
  2. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 9$2,947,300.002026-08
  3. Change order logNorthfield_SAMPLE_CO_Log.csv · row 15$9,415.00CO-07 approved 2026-06-19
  4. BillingNorthfield_SAMPLE_PayApp_Summary.csv · row 9$2,982,081.25pay application #5

Why this matters to your cash The WIP contract value drives earned revenue. If it is off, your margin and billing position are off too.

What to do next — confirm with your team first
  1. Check which change orders the WIP schedule includes.
  2. Add any approved change that is missing, or take out one that is not approved.
  3. Update the WIP schedule.
$214,000.00 Estimated margin on this project moved from 16.0% to 11.1% between May 2026 and August 2026, a drop of $214,000.00.Riverside Medical Office Building (SAMPLE) · Margin Integrity · 2026-08 Requires review

What Main knows

  • 2026-05 → 2026-06: margin 16.0% → 16.0% (gain $0.00). Supplied values that changed: approved changes +$38,416.00; cost to date +$195,289.01; committed cost +$97,477.26; estimated cost to complete −$163,019.57. Estimated total cost +$32,269.44, of which $0.00 matches a recorded current-budget revision.
  • 2026-06 → 2026-07: margin 16.0% → 13.5% (fade $109,000.00). Supplied values that changed: approved changes +$21,870.00; current budget +$127,370.80; cost to date +$496,440.65; committed cost +$338,998.74; estimated cost to complete −$369,069.85. Estimated total cost +$127,370.80, of which $127,370.80 matches a recorded current-budget revision.
  • 2026-07 → 2026-08: margin 13.5% → 11.1% (fade $105,000.00). Supplied values that changed: pending changes (not revenue) +$6,215.00; current budget +$42,000.00; cost to date +$365,397.33; committed cost +$230,158.94; estimated cost to complete −$260,397.33. Estimated total cost +$105,000.00, of which $42,000.00 matches a recorded current-budget revision.
  • Estimated margin = (contract + approved changes − (cost to date + estimated cost to complete)) ÷ (contract + approved changes); pending changes are excluded.

What Main cannot determine

  • Main cannot determine why the estimate changed — PM explanation required.
  • The reason for any budget revision is not in the supplied records.

Source evidence

  1. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 2$3,069,725.762026-05: estimated margin 16.0%
  2. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 3$2,906,706.192026-06: estimated margin 16.0%
  3. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 4$2,537,636.342026-07: estimated margin 13.5%
  4. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 5$2,277,239.012026-08: estimated margin 11.1%
  5. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 5$3,781,443.042026-08
  6. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 5$3,050,816.882026-08

Why this matters to your cash A change in margin can mean costs are moving faster than the budget. Finding the cause early gives you time to act.

What to do next — confirm with your team first
  1. Ask the project manager what changed in cost or scope.
  2. Check whether a change order should cover any new cost.
  3. Update the estimate to complete if needed.
$144,145.60 Estimated margin on this project moved from 20.0% to 12.6% between May 2026 and August 2026, a drop of $144,145.60.Cedar Point Biosciences Lab Fit-Out (SAMPLE) · Margin Integrity · 2026-08 Requires review

What Main knows

  • 2026-05 → 2026-06: margin 20.0% → 20.0% (gain $0.00). Supplied values that changed: approved changes −$3,860.00; current budget −$3,088.00; cost to date +$134,266.44; committed cost +$51,853.78; estimated cost to complete −$137,354.44. Estimated total cost −$3,088.00, of which $3,088.00 matches a recorded current-budget revision.
  • 2026-06 → 2026-07: margin 20.0% → 16.5% (fade $69,145.60). Supplied values that changed: approved changes +$7,318.00; pending changes (not revenue) +$9,860.40; cost to date +$75,000.00; committed cost +$75,000.00. Estimated total cost +$75,000.00, of which $0.00 matches a recorded current-budget revision.
  • 2026-07 → 2026-08: margin 16.5% → 12.6% (fade $75,000.00). Supplied values that changed: pending changes (not revenue) +$3,940.00; cost to date +$75,000.00; committed cost +$75,000.00. Estimated total cost +$75,000.00, of which $0.00 matches a recorded current-budget revision.
  • Estimated margin = (contract + approved changes − (cost to date + estimated cost to complete)) ÷ (contract + approved changes); pending changes are excluded.

What Main cannot determine

  • Main cannot determine why the estimate changed — PM explanation required.
  • The reason for any budget revision is not in the supplied records.

Source evidence

  1. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 18$1,328,153.342026-05: estimated margin 20.0%
  2. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 19$1,190,798.902026-06: estimated margin 20.0%
  3. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 20$1,190,798.902026-07: estimated margin 16.5%
  4. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 21$1,190,798.902026-08: estimated margin 12.6%
  5. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 21$1,553,220.602026-08
  6. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 21$1,226,901.042026-08

Why this matters to your cash A change in margin can mean costs are moving faster than the budget. Finding the cause early gives you time to act.

What to do next — confirm with your team first
  1. Ask the project manager what changed in cost or scope.
  2. Check whether a change order should cover any new cost.
  3. Update the estimate to complete if needed.
$150,000.00 The estimated cost to complete on this project has stayed at $1,190,798.90 for 2 periods while costs kept moving.Cedar Point Biosciences Lab Fit-Out (SAMPLE) · Margin Integrity · 2026-08 Needs context

What Main knows

  • The PM-supplied estimated cost to complete is $1,190,798.90 in each of 2026-06, 2026-07, 2026-08.
  • Over the same periods: cost to date moved $150,000.00 (threshold $119,079.89); approved changes moved $7,318.00; committed cost moved $150,000.00.

What Main cannot determine

  • Main cannot determine whether the estimated cost to complete is current — PM explanation required.
  • An unchanged estimate can be correct; this is a prompt to confirm it, not a finding that it is wrong.

Source evidence

  1. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 19$1,190,798.902026-06
  2. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 20$1,190,798.902026-07
  3. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 21$1,190,798.902026-08

Why this matters to your cash An estimate that is not updated can hide a cost problem. It may also be right; this is a prompt to check it.

What to do next — confirm with your team first
  1. Ask the project manager to confirm the estimate is current.
  2. Update it if it is not.
  3. Note the date it was last reviewed.
$38,416.00 The contract value on this project changed by $38,416.00 between May 2026 and June 2026, but the cost budget did not change.Riverside Medical Office Building (SAMPLE) · Margin Integrity · 2026-06 Requires review

What Main knows

  • WIP approved changes moved $38,416.00 from 2026-05 to 2026-06; the current budget is $3,612,072.24 in both periods.
  • Change orders approved in that interval: CO-04 $38,416.00 "Add (6) Level 2 EV charging stations - parking lot".

What Main cannot determine

  • Whether the change carries cost that has not been budgeted yet, or has no cost impact that the records do not document — PM explanation required.

Source evidence

  1. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 3$3,612,072.242026-06
  2. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 3$52,002.002026-06
  3. Change order logNorthfield_SAMPLE_CO_Log.csv · row 5$38,416.00CO-04 approved 2026-06-18

Why this matters to your cash A change that adds work usually adds cost. Without a budget update, the margin may look better than it is.

What to do next — confirm with your team first
  1. Ask the project manager whether the change has cost.
  2. If it does, add that cost to the budget.
  3. If it does not, note why.
$21,736.51 Your WIP schedule and your general ledger differ by $21,736.51 for August 2026.Portfolio · Margin Integrity · 2026-08 Requires review

What Main knows

  • 2026-08 billings in excess of costs: WIP $185,899.18, general ledger $164,162.67 (accounts 2400), difference $21,736.51.
  • Account mapping confirmed by: Controller (SAMPLE), kickoff call.
  • The difference equals the WIP over billings of 24-118 — that project's entry may be posted to a different account or not posted (possible cause — confirm).

What Main cannot determine

  • Whether the WIP adjusting entry for the period was posted, and to which accounts.

Source evidence

  1. General ledgerNorthfield_SAMPLE_Trial_Balance.csv · row 20$164,162.672400 Billings in Excess of Costs 2026-08
  2. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 13$0.002026-08
  3. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 17$0.002026-08
  4. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 5$21,736.512026-08
  5. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 9$0.002026-08
  6. WIP scheduleNorthfield_SAMPLE_WIP_Schedule.csv · row 21$164,162.672026-08

Why this matters to your cash Your WIP schedule should tie to your books. If it does not, an entry may be missing or posted to a different account.

What to do next — confirm with your team first
  1. Check that the WIP entry for the period was posted.
  2. Check which accounts it was posted to.
  3. Post or correct the entry.

Reported vs recomputed — latest period per project

Logistics Center Building C - Warehouse (SAMPLE)2026-08 · Cost-to-cost 8 checks · Agrees: 8
WIP valueCustomer reportedMain recomputed / recordsDifferenceStatus
% complete100.00%100.00%0.00%Agrees
Earned revenue$1,734,779.00$1,734,779.00$0.00Agrees
Over billings$0.00$0.00$0.00Agrees
Under billings$0.00$0.00$0.00Agrees
Approved changes (vs CO register)$50,579.00$50,579.00$0.00Agrees
Billed to date (vs pay applications)$1,734,779.00$1,734,779.00$0.00Agrees
Retainage (vs ledger)$173,477.90$173,477.90$0.00Agrees
A/R (vs invoice register)$0.00$0.00$0.00Agrees
Fulton & 9th Mixed-Use (SAMPLE)2026-08 · Cost-to-cost 8 checks · Agrees: 8
WIP valueCustomer reportedMain recomputed / recordsDifferenceStatus
% complete33.55%33.55%0.00%Agrees
Earned revenue$2,980,404.19$2,980,261.00$143.19Agrees (below threshold)
Over billings$0.00$0.00$0.00Agrees
Under billings$36,143.19$36,000.00$143.19Agrees (below threshold)
Approved changes (vs CO register)$158,470.00$158,470.00$0.00Agrees
Billed to date (vs pay applications)$2,944,261.00$2,944,261.00$0.00Agrees
Retainage (vs ledger)$294,426.10$294,426.10$0.00Agrees
A/R (vs invoice register)$1,081,460.35$1,081,460.35$0.00Agrees
Riverside Medical Office Building (SAMPLE)2026-08 · Cost-to-cost 8 checks · Agrees: 8
WIP valueCustomer reportedMain recomputed / recordsDifferenceStatus
% complete41.26%41.26%0.00%Agrees
Earned revenue$1,799,089.49$1,799,024.14$65.35Agrees (below threshold)
Over billings$21,736.51$21,801.86-$65.35Agrees (below threshold)
Under billings$0.00$0.00$0.00Agrees
Approved changes (vs CO register)$73,872.00$73,872.00$0.00Agrees
Billed to date (vs pay applications)$1,820,826.00$1,820,826.00$0.00Agrees
Retainage (vs ledger)$182,082.60$182,082.60$0.00Agrees
A/R (vs invoice register)$828,896.40$828,896.40$0.00Agrees
Eastbrook Middle School Renovation (SAMPLE)2026-08 · Cost-to-cost 8 checks · Agrees: 7 · Requires review: 1
WIP valueCustomer reportedMain recomputed / recordsDifferenceStatus
% complete92.43%92.43%0.00%Agrees
Earned revenue$2,781,950.51$2,781,955.25-$4.74Agrees (below threshold)
Over billings$0.00$0.00$0.00Agrees
Under billings$2,995.26$3,000.00-$4.74Agrees (below threshold)
Approved changes (vs CO register)$62,491.75$71,906.75-$9,415.00Requires review
Billed to date (vs pay applications)$2,778,955.25$2,778,955.25$0.00Agrees
Retainage (vs ledger)$140,067.76$140,067.76$0.00Agrees
A/R (vs invoice register)$1,068,291.15$1,068,291.15$0.00Agrees
Cedar Point Biosciences Lab Fit-Out (SAMPLE)2026-08 · Cost-to-cost 8 checks · Agrees: 8
WIP valueCustomer reportedMain recomputed / recordsDifferenceStatus
% complete30.09%30.09%0.00%Agrees
Earned revenue$586,407.08$586,318.55$88.53Agrees (below threshold)
Over billings$164,162.67$164,251.20-$88.53Agrees (below threshold)
Under billings$0.00$0.00$0.00Agrees
Approved changes (vs CO register)$36,093.75$36,093.75$0.00Agrees
Billed to date (vs pay applications)$750,569.75$750,569.75$0.00Agrees
Retainage (vs ledger)$75,056.98$75,056.98$0.00Agrees
A/R (vs invoice register)$309,941.77$309,941.77$0.00Agrees

WIP to general ledger tie-out (trial balance)

PeriodLineWIPGeneral ledgerDifferenceStatus
2026-06Contract revenue for the month (WIP earned change vs GL)$1,585,234.60——Context required
2026-06Billings in excess of costs (WIP over billings vs GL)$46,626.21$46,626.21$0.00Agrees
2026-06Costs in excess of billings (WIP under billings vs GL)$13,784.77$13,784.77$0.00Agrees
2026-07Contract revenue for the month (WIP earned change vs GL)$2,115,949.42$2,115,949.42$0.00Agrees
2026-07Billings in excess of costs (WIP over billings vs GL)$72,118.71$72,118.71$0.00Agrees
2026-07Costs in excess of billings (WIP under billings vs GL)$50,474.69$50,474.69$0.00Agrees
2026-08Contract revenue for the month (WIP earned change vs GL)$1,236,177.29$1,236,177.29$0.00Agrees
2026-08Billings in excess of costs (WIP over billings vs GL)$185,899.18$164,162.67$21,736.51Requires review
2026-08Costs in excess of billings (WIP under billings vs GL)$39,138.45$39,138.45$0.00Agrees

Assessed · 3 findings

Cash Conversion

Receivables and retainage: what is holding up cash.

Sample Needs your inputRequires confirmation

$173,477.90

$173,477.90 of retainage is still held on this project, and the records show no release request or release terms.

Logistics Center Building C - Warehouse (SAMPLE) · Commercial exposure

Why Main flagged this

Retainage held — this project vs the other projects in the supplied data (median 4.0%)
  • Logistics Center Building C - Warehouse (SAMPLE)10.0% of contract held
  • 24-1023.3% of contract sum to date
  • 24-1184.2% of contract sum to date
  • 24-1314.7% of contract sum to date
  • 24-1403.9% of contract sum to date
  1. Retainage held$159,773.90
  2. Retainage held$173,477.90
  3. Retainage held$173,477.90
  4. Retainage held$173,477.90
  5. Retainage not yet releasedMissing

Check: Retainage held with no release request · Commercial exposure

Evidence, what Main knows and cannot determine, recommended action

Source evidence

  1. Source recordNorthfield_SAMPLE_Retainage_Ledger.csv · row 13$173,477.90retainage ledger as of 2026-08-31; release info blank
  2. Checked againstNorthfield_SAMPLE_PayApp_Summary.csv · row 11$1,734,779.00pay app 8: 100.0% of contract sum to date
  3. Other project, for comparisonNorthfield_SAMPLE_Retainage_Ledger.csv · row 17$294,426.10other project in this data 24-102: project retainage $294,426.10 = 3.3% of contract sum to date
  4. Other project, for comparisonNorthfield_SAMPLE_Retainage_Ledger.csv · row 5$182,082.60other project in this data 24-118: project retainage $182,082.60 = 4.2% of contract sum to date
  5. Other project, for comparisonNorthfield_SAMPLE_PayApp_Summary.csv · row 9$138,947.76other project in this data 24-131: project retainage $138,947.76 on pay app 5 = 4.7% of contract sum to date
  6. Other project, for comparisonNorthfield_SAMPLE_Retainage_Ledger.csv · row 21$75,056.98other project in this data 24-140: project retainage $75,056.98 = 3.9% of contract sum to date

What Main knows

  • $173,477.90 of retainage is held.
  • Billed 100.0% complete as of Jun 30, 2026 (62 days before Aug 31, 2026, your data's as-of date).
  • 10.0% of contract held vs a median of 4.0% on this company's 4 other projects in the supplied data (2.4x).
  • The ledger records no release terms or release request.

What Main cannot determine

  • The contract release conditions (substantial vs final completion, closeout documents, owner release).
  • Whether a release request has already been sent.

Why this matters to your cash Retainage is money you have earned. If no one asks for it, it can sit unpaid long after the work is done.

What to do next — confirm with your team first
  1. Check your contract for when retainage is due.
  2. Ask the GC what they need to release it, such as closeout papers.
  3. Send a written release request and set a follow-up date.
$151,032.37 Invoice 4429 has $151,032.37 unpaid, 37 days past its due date as of Aug 31, 2026 (your data's as-of date).Cedar Point Biosciences Lab Fit-Out (SAMPLE) · Cash delayed Strong evidenceRequires follow-up

Why Main flagged this

  1. Billed$151,032.37
  2. Invoiced$151,032.37
  3. Not yet paidMissing

Check: Invoice past due · Cash delayed

Source evidence

  1. Source recordNorthfield_SAMPLE_AR_Invoice_Register.csv · row 30$151,032.37A/R invoice 4429: $151,032.37 − $0.00 paid = $151,032.37 open

What Main knows

  • Invoice 4429 for $151,032.37 shows $0.00 paid and $151,032.37 open.
  • It is 37 days past its Jul 25, 2026 due date as of Aug 31, 2026 (67 days after invoice date).

What Main cannot determine

  • Whether the GC has disputed or scheduled the payment.

Why this matters to your cash This is cash you have billed but not received. The older it gets, the harder it can be to collect. Main counts 37 days from the due date to Aug 31, 2026. An A/R aging report counts from the invoice date — 67 days to Aug 31, 2026 — so it lists this invoice in its 61-90 column.

What to do next — confirm with your team first
  1. Ask the GC when invoice 4429 will be paid.
  2. Ask whether anything is holding it up, such as a missing lien waiver.
  3. Write down the answer and set a follow-up date.
$41,872.15 Invoice 4420 has $41,872.15 unpaid, 68 days past its due date as of Aug 31, 2026 (your data's as-of date).Fulton & 9th Mixed-Use (SAMPLE) · Cash delayed Strong evidenceRequires follow-up

Why Main flagged this

  1. Billed$283,838.40
  2. Invoiced$283,838.40
  3. Payment received$241,966.25
  4. Balance not yet paidMissing

Check: Invoice past due · Cash delayed

Source evidence

  1. Source recordNorthfield_SAMPLE_AR_Invoice_Register.csv · row 21$283,838.40A/R invoice 4420: $283,838.40 − $241,966.25 paid = $41,872.15 open
  2. Related recordNorthfield_SAMPLE_Payments_Received.csv · row 21$241,966.25payment 2026-07-06

What Main knows

  • Invoice 4420 for $283,838.40 shows $241,966.25 paid and $41,872.15 open.
  • It is 68 days past its Jun 24, 2026 due date as of Aug 31, 2026 (98 days after invoice date).

What Main cannot determine

  • Whether the GC has disputed or scheduled the payment.

Why this matters to your cash This is cash you have billed but not received. The older it gets, the harder it can be to collect. Main counts 68 days from the due date to Aug 31, 2026. An A/R aging report counts from the invoice date — 98 days to Aug 31, 2026 — so it lists this invoice in its Over 90 column.

What to do next — confirm with your team first
  1. Ask the GC when invoice 4420 will be paid.
  2. Ask whether anything is holding it up, such as a missing lien waiver.
  3. Write down the answer and set a follow-up date.

Not assessed

Closeout Integrity

Closeout documents and final billing.

Not assessed

Not assessed — closeout data was not supplied for this assessment.

Appendix

Methodology, limitations and data handling

Methodology

  • Main put the supplied exports into one standard form (dates, amounts, change-order identifiers) with deterministic code and kept every original row so each figure can be traced to its file, sheet and row.
  • Each economic dollar stream — usually a scope change — was given one identity (one traced item) and followed from request and approval through the schedule of values, billing by period, invoicing, collection and retainage. Every amount belongs to exactly one traced item, so nothing is counted twice.
  • Deterministic rules compared what should exist with what each record says. No AI model computed any amount, date, aging or reconciliation result. Where another line could plausibly explain a gap, the item is marked “Needs your input” and the candidate line is cited.
  • This SAMPLE report was produced automatically from fictional data; no person reviewed it. In a paid assessment, a person at Main reviews each finding before it goes into the report.
  • Where a WIP / job-cost schedule was supplied, Main recomputed it only under the customer's declared percent-complete method and only when the inputs were present, showing the reported figure, the recomputed figure and the exact difference side by side. Differences below the materiality threshold are recorded but not raised as findings.

Limitations

  • This assessment used the supplied exports only. Conversations, side agreements and offline approvals are not visible to Main.
  • Each item requires business confirmation. "Strong evidence" means the records themselves show the discrepancy, not that any party is at fault or that an amount is owed.
  • Main is an operational technology and service provider. This report is not legal, accounting or tax advice.
  • Main is not a CPA firm and does not perform audits, reviews, compilations or other attest services; it provides financial data reconciliation and analysis of where records disagree to support your team and your CPA.
  • Main supports the controller's and CPA's work — it does not prepare or attest financial statements or determine revenue-recognition policy.
  • Main checks the WIP schedule as supplied. It never generates cost-to-complete estimates, never decides revenue-recognition policy and never changes a reported figure; where it cannot reproduce a figure from the supplied inputs it says methodology/context required.

Data handling

Files were stored encrypted with a key specific to this organization, accessed only by invited users and by Main staff through logged workspace sessions, and are scheduled for deletion after the engagement; full retention details are being finalized.

Your readout

Which section of this report mattered most to you, and why?