Explain how a French public works payment statement is built each month.
Turn cumulative measurements into the month's work, line by line.
Find the three common errors in a drafted statement.
1 / 4
Cumulative first
Under CCAG-Travaux 2021 (article 12.1.1) the contractor sends, before the end of each month, a draft statement of the total value of the work done since the contract was notified. It is cumulative. The month's work is that total less the total of the month before. Building it this way means an error made in April is corrected in May, not carried forever.
1 Cumulative to end of month
2 Cumulative to the month before
3 This month
2 / 4
Measurements drive the money
With unit prices, each line is quantity times the contract unit price (BPU). The quantities come from the measurement records (attachements), agreed with the project manager. The ERP holds each line as a percentage of the contract quantity, so the record's quantity is entered as progress, not as money.
Example. Steelwork at 42 % of the contract tonnage is 42 % of that line's contract value.
3 / 4
Three errors to look for
A drafted statement goes wrong in predictable ways: it bills the cumulative quantity as if it were the month's, it bills material delivered as if it were installed, or it uses the price of the next line. The first and second overstate; the third can go either way.
Cumulative billed as monthlyOverstates
Delivered billed as installedOverstates
Wrong line's unit priceEither way
4 / 4
Report the gap, signed
The gap is the draft less the verified amount, each line with its sign. A line where the draft is low reduces the gap; it does not cancel it. The gap is what the draft would have got wrong, and it is what you report.
Example. Draft high on two lines and low on one: add the two, subtract the one.
Rebuild a month from the records
Another lot, another month. Type your answer first.
Not to scale
The problem
Line A (roof sheeting): cumulative to last month €18,000, to this month €27,000. The draft bills €27,000 for the month.
Line B (cladding): the draft bills €12,500, the value of panels delivered; panels installed are worth €9,500.
Line C (gutters): the draft bills €3,100, using line D's unit price; at its own price it is €4,650. Other lines are correct at €41,600.
1 Cumulative now
2 Cumulative before
3 Month
1 Cumulative now
2 Cumulative before
3 Month
Step 1 of 3
Line A this month
What is line A worth this month?
Hint: Cumulative less last month's cumulative.
€27,000 − €18,000 = €9,000.00. The draft billed the whole cumulative.
€9,500€41,600
A €9,000
B €9,500
C €4,650
Others €41,600
€9,500€41,600
A €9,000
B €9,500
C €4,650
Others €41,600
Step 2 of 3
Verified month
What is the verified work for the month, at initial prices?
Hint: A for the month, B installed, C at its own price, plus the rest.
By how much does the draft differ from the verified month?
Hint: Draft total less verified total.
Line A €9,000.00 too high, B €12,500 − €9,500 too high, C €4,650 − €3,100 too low: net €19,450.00.
In short. Build the statement cumulatively, take the month as the difference, bill what is installed at each line's own price, and report the signed gap.
Check yourself
Question 1 of 3
Cumulative value to end of June €148,000; to end of May €97,500. What is June's work?
€148,000 − €97,500 = €50,500.
Question 2 of 3
Cladding panels are on site but not fixed. What goes on the statement as work done?
The line pays for cladding installed, as measured.
Materials on site are not work done on this line.
Question 3 of 3
The draft is high on two lines and low on one. What is the gap?