What a standalone model, claim sheet or ERP export loses: one progress claim read before and after its context

Short answer

Read alone, each system tells the truth and hides the reason. The design model shows two issues of a parking deck, but not which issue fed which payment application. The spreadsheet shows 3,250 feet of cable tray billed, but not that 450 feet sit in both issues. The ERP shows a certified amount cut the following month, but not why. Only the joined history shows one length counted twice, caught by a field count and written back.

Visual briefFull-size diagram
A claim record reading 3,250 feet certified has three empty slots (which model issue, overlap and reason for the cut) that fill as context pieces drop in from the model platform, the claim sheet and the field count.
Illustrative claim for a fictional electrical contractor. Each slot is filled by a different system; the 450-foot overlap appears only when all of them are joined.

This before-and-after reading belongs to the quantity-to-progress-claim guide. It takes one Illustrative pay period and reads it three ways in isolation, then once more with everything side by side.

Before: three exports, each internally consistent

Illustrative. A fictional 260-person electrical contractor is fitting cable tray on deck P2 of a hospital parking structure. Halfway through, the architect moves the EV charging layout, and the design team reissues the deck. A reviewer handed each export separately would see this.

From the design model. Issue C of deck P2 shows 2,800 feet of tray in the east bay. Issue D, released three weeks later, carves a new ramp bay out of the east bay and draws 450 feet of tray there. Two tidy drawing sets, each correct for its date.

From the Excel workbook. Row one: east bay, 2,800 feet. Row two: ramp bay, 450 feet. Total billed as installed: 3,250 feet. The cells pull from exported quantity lists. Nothing on the sheet says which issue a row came from.

From the ERP. Payment application certified on 3,250 feet. Next period: a negative line of 450 feet, with an amount and a posting date.

Each looks normal. The drawings show routine design change. The workbook shows a finished deck. The ledger shows an adjustment like dozens of others that year. No single file contains a mistake a reader could point to.

After: one pay period with every source side by side

Line the exports up by deck, bay and month, and add the field count that triggered the cut.

MonthDesign modelExcel workbookField countERP
Month 1Issue C: east bay, 2,800 feetNothing billed yetTray going inNothing
Month 2Issue D: 450 feet of east bay runs redrawn as ramp bayEast bay 2,800 from issue C plus ramp bay 450 from issue DNo countCertified on 3,250 feet
Month 3UnchangedRamp bay row deletedCounted: 2,800 feet in placeCut by 450 feet

Now the reason appears. The ramp bay tray was never extra material. It was the same runs already billed under the east bay, redrawn under a new bay name. The workbook added both. Nobody put issue C beside issue D before billing, so the owner's certifier approved 3,250 feet, and the foreman's count exposed it a month later.

The connected version teaches far more than any lone file, for the reason set out in why data quality beats quantity: three accurate fragments explain less than one sequence with its error and repair labeled.

The gap table: what goes missing and who holds it

This table is the asset to bring to a first conversation. It names each lost fact, the place it normally sits and the person who can say whether it survives.

Lost when one export is read aloneWhat it explainsWhere it livesWho can confirm it
Which model issue fed each billed lineWhether a total mixes two drawing setsA revision column on the workbook, if one existsProject controls lead
What changed between issue C and issue DThat ramp bay runs were redrawn, not addedModel version history and its compare viewDesign manager or BIM lead
How quantities were pulledWhether the export named its issueQuantity export files and their namesEstimator
What was physically in placeThe true length against the billField count or measurement recordsSite manager or foreman
Why the certified amount was cutThat the cut corrected a double countERP adjustment note or letters to the certifierFinance or commercial manager
Each month's bill as submittedThe state before correctionOne saved workbook per month, if keptProject controls lead

The model rows are usually the easiest to answer. Autodesk Construction Cloud became part of Autodesk Forma in March 2026, with Autodesk Docs renamed Forma Data Management and Autodesk Takeoff renamed Forma Takeoff, and Autodesk says existing project data was not migrated or changed. In Autodesk Docs, one version of a file can be compared with another in the viewer, for formats including RVT, DWG, PDF and IFC, so issue C and issue D can usually still be put side by side. Forma Takeoff, Autodesk's quantity takeoff tool, is one common source of the exported lists. None of that says which issue a billed line used, which is why the first row is the fragile one. The cut's reason is the other: it often lives in correspondence with the certifier, not the ledger, and may not outlast a mailbox clean-up.

Phrases that reveal a missing column

A partner never sees these tables. What a partner hears in conversation are phrases that point at a missing column, and each maps to a row above.

What the project controls lead saysWhat it usually means
"We overwrite the workbook each month"Bills as submitted are gone; only the ERP keeps the history
"The quantity export is just called final"The issue behind a number has to be guessed from dates
"Finance handles adjustments"The reason for a cut may sit outside project files
"We compare drawing issues before every bill"A double count would likely be caught and noted
"Old BIM 360 jobs were archived"Earlier model versions may be missing for early bills

None of these rules a contractor out. Each locates a gap, and the record chain page names the key that would have closed it. The completeness checklist scores whether the trail is complete enough to discuss, and what data is missing from AI training explains why missing reasons matter to buyers.

Describing the gap without opening a file

What SourceX needs from a partner is which columns of the after table the contractor can still fill, for which jobs and years. That is metadata: whether each month's workbook is kept, whether it names the model issue, how far model history goes back and where reasons for cuts are written. It is the kind of signal covered in measuring referral quality instead of volume.

Before introducing, confirm: 50+ full-time employees at peak (contractors excluded), documented operating history, rights to license, and an authorized contact: the CEO, with the COO or commercial director often as sponsor. Companies in the U.S., Canada and the EU qualify, as do companies in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia when at least 70% of the data is in English.

Unknown until SourceX reviews the opportunity: whether the designer, owner or contractor holds rights to each model, client confidentiality terms, SourceX's current data needs and any offer. Partners never handle raw records. Other system guides are in the systems hub.

Next step

Refer a company. No cap on rewards. Default reward on a company's first qualifying transaction: the greater of $50,000 plus 5% and 15% of Actual Supplier Payout, with no cap; further qualifying transactions first agreed within 12 months of the first Closing pay 15%. Eligibility and payment conditions apply, including the USD 100,000 Minimum Transaction, and a signed Schedule A or addendum can differ. A lead, meeting or signature alone does not trigger payment.

If a contractor can say which columns of the after table it still holds, and on which jobs, register as a partner, confirm it against who qualifies and read the program terms before introducing its commercial lead.

  1. Step 1Share your linkSend your personal link to a company you know.
  2. Step 2Company appliesThe company applies itself at /apply.
  3. Step 3Company signs and is paidThe company signs, delivers its data and is paid by SourceX under its agreement.
  4. Step 4You get your rewardthe greater of $50,000 plus 5% and 15% of the actual supplier payout, with no cap. A reward becomes payable after SourceX has paid the referred company under its signed agreement and the payout conditions in the program terms are met, including finance approval and your tax and payment details.

Common questions

Which single export loses the most?

The ERP export. It holds the most authoritative numbers, the certified claim and the paid amount, but almost none of the reasons behind them. A cut in the following period looks like an ordinary adjustment.

Is the Excel claim sheet worth mentioning if it is messy?

Yes. It is often the only record of how counted quantities became a claim. A partner should note whether each month's sheet is kept and whether it names the model issue, not judge how tidy it is.

Does a corrected double count count against the company?

Not necessarily. A known error with its discovery and correction recorded shows how a contractor catches its own mistakes. What matters is that the company can describe it, not that its history is flawless.

Sources

  1. adsknews.autodesk.com/en/news/autodesk-construction-cloud-is-now-a…
  2. autodesk.com/products/forma-takeoff/overview
  3. knowledge.autodesk.com/support/docs/learn-explore/caas/CloudHelp/cl…
  4. refer.sourcex.si/terms

Free resources

Know a company with valuable proprietary data?

Become a referral partner, get your link and introduce the company’s CEO (in an owner-run company, usually the owner). Referral partners can join from most countries. We can't work with partners in countries or regions under U.S. sanctions or on U.S. restricted-party lists. The companies you introduce should be based in the U.S., Canada and the EU, or in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia with at least 70% of their data in English.

Refer a company →

I own a business

Explore licensing your company's data directly to SourceX for AI training and evaluation. Start a short assessment; no uploads needed.

Start an assessment