Progress claim reconciliation system map: the keys that join project controls, ERP and certificates

Short answer

Reconstructing progress claim reconciliation across systems takes three keys stored in every system that matters: the schedule of values line ID or cost code, the claim number with its version, and the certificate or payment schedule number that references the claim. With those, measured work in project controls, claims in workbooks, reasons in document control and amounts in the ERP join into one case. Where a key is missing, someone matches by amount and date, and that is where histories often break.

Visual briefFull-size diagram
Five systems drawn as nodes, field measurement, project controls, claim workbooks, document control and ERP, with three linking keys, line ID, claim number with version, and certificate number, traveling between them to join one variation case.
Illustrative system map for a fictional contractor; real systems and keys differ by company and configuration.

This system map is part of the progress claim reconciliation guide. The guide is about what to inventory before a migration; this page maps where each record lives today and what holds them together.

Five systems that each hold one piece

A typical contractor spreads one claim across five places. None of them holds the whole story.

  1. Field measurement. Quantities, pour records, inspection dates and progress photos, captured by site engineers, sometimes in an app, often in workbooks.
  2. Project controls. Schedule of values lines with budget and percent complete; variations pending and approved.
  3. Claim workbooks. The submitted claim, version by version, usually exported from project controls and edited before sending.
  4. Document control or email. The client's certificate or payment schedule, with the reason for any reduction, plus surveyor queries.
  5. ERP. Progress invoices, certified amounts, receivables and retention.

The reason text in item 4 exists for a regulatory reason in some places. In New South Wales a payment schedule must state the scheduled amount and the reasons if it is less than the amount claimed, within the contract time or 10 business days, whichever is earlier. On U.S. federal fixed-price work, FAR 52.232-5 requires each payment request to be substantiated and certified, which pushes measured quantities into writing.

The map: system, record, linking key, owner

This is the page's evidence asset. Each row is a record class; the key column is what lets it join the next.

SystemRecordLinking key it carriesOwnerCommon break
Field measurementMeasured quantity, pour or inspection recordLine ID or cost code, measurement dateProject engineerKept in a personal workbook with no line ID
Project controlsSchedule of values line, percent completeLine ID, contract or job numberProject controls managerCodes renamed mid-project
Project controlsVariation registerVariation number, line ID once approvedCommercial managerPending variations claimed under a temporary line
Claim workbooksClaim versionsClaim number and version, line IDsCommercial managerEarlier versions overwritten
Document controlCertificate or payment scheduleCertificate number, claim numberCommercial managerReason text only in a PDF, not indexed
ERPProgress invoice and certified amountInvoice number, job number, sometimes claim and certificate numbersFinancial controllerInvoice carries no claim or certificate reference
ERPRetention and releaseJob number, certificate numberFinancial controllerRelease events booked outside the job

Retention needs its own row because its timing differs. FAR 52.232-27 makes progress payments due 14 days after a proper payment request is received, while retained amounts follow a separate timeline, so a job can be closed for billing and open for retention.

One variation joined end to end (Illustrative)

Illustrative; the contractor, project and figures are fictional. A 520-person civil and building contractor adds fire-stopping to a hospital car park after a design change. The work is instructed as variation 14 before it is priced.

StepSystemRecordKey that joins it to the next step
1Project controlsVariation 14 registered as pending, temporary line V14Variation number
2Field measurementFire-stopping installed on two levels, datedTemporary line V14
3Claim workbooksClaim 11 v1 includes V14 at the full quoted amountClaim 11, version 1, line V14
4Document controlPayment schedule 11 certifies nothing on V14, reason "variation not yet approved"Certificate 11 references claim 11
5Project controlsVariation 14 approved at a revised price; line V14 mapped to permanent line 7.4Mapping table V14 to 7.4
6Claim workbooksClaim 12 v1 claims line 7.4Claim 12, line 7.4
7ERPInvoice for claim 12 carries certificate 12 and job numberCertificate number

Step 5 is the hinge. If the mapping from the temporary line to the permanent line was never recorded, steps 1 to 4 and steps 6 to 7 look like two unrelated events. The change order data page explains what the variation records themselves contain.

Scoring a client's map in one conversation

Ask the construction accountant and the project controls manager to rate each key. Record the rating, not the data.

KeyStrongWeakMissing
Line ID or cost codeStable, or renamed with a mapping tableRenamed, mapping in someone's headNot used on measurements
Claim number and versionEvery version savedFinal version onlyClaims not numbered
Certificate numberOn the ERP invoiceIn document control onlyCertificates filed by date
Variation mappingTemporary to permanent line recordedRecorded in emailNot recorded

Two or more "strong" ratings, including the line ID, suggest a case can be joined without guesswork. Product export features differ by vendor and configuration, so do not assume them: ask the administrator whether superseded versions export, and ask finance whether invoices carry claim numbers. The general shape of instruction-to-output links is covered in recognizing linked task instructions and completed outputs, and accountants who run month-end close may recognize the same reference discipline from general ledger reconciliation.

Who confirms the map, and who decides

The project controls manager and financial controller confirm the keys; the commercial director knows which contracts have clean histories. The CEO decides whether a licensing discussion fits, with input from the CFO, and counsel reviews client confidentiality and government contract terms. For SourceX, an introduced company needs 50+ full-time employees at peak (contractors excluded), a documented operating history, rights to license and an authorized contact. 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 90% of the data is in English.

What stays unknown until SourceX reviews it: buyer interest, the rights result, what must be removed and any offer. SourceX licenses approved business data directly from companies for AI training and evaluation, and manages the agreement, rights review, data preparation, delivery and payout. Partners sign the Channel Partner Agreement before submitting introductions; the first valid introduction within the 90-day window is credited when the company submits a verified application. For a single case read step by step, see the worked exception example; to hand the map's results to a decision-maker, use the referral brief template.

Next step

Refer a company. Earn up to $100,000. Default reward: 25% of Actual Supplier Payout, capped at $100,000 cumulatively per referred company. Eligibility and payment conditions apply, and a signed Schedule A or addendum can differ. A lead, meeting or signature alone does not trigger payment.

If a client's map scores strong on the line ID and at least one other key, register as a partner, check the contractor against who qualifies and read the program terms before the introduction.

  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 rewardYour 25% of the actual supplier payout. 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 key matters most?

The schedule of values line ID or cost code, because every other record hangs off it. If it was renamed mid-project without a mapping, every later join has to be rebuilt by hand.

Can the ERP alone reconstruct the history?

Usually not. The ERP holds certified amounts and retention well, but rarely the measured quantity, the superseded claim versions or the certificate's reason text.

Should the partner test the joins on a sample?

No. The partner asks whether each key exists and who maintains it. Testing joins on real records is work for the company and, later, SourceX's review.

Sources

  1. acquisition.gov/far/52.232-5
  2. nsw.gov.au/housing-and-construction/compliance-and-regu…
  3. acquisition.gov/far/52.232-27
  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 90% 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