Gains:
- Ability to process progress and progress payment data into AI in a structured format with manufacturing item, actual quantity and unit price
- Ability to verify AI-generated progress payment amounts, deductions and cumulative calculations with arithmetic and contract rules
- Ability to engineer AI output before signing, preserving the commercial confidentiality of progress payment data
Progress payment is an official document in which the productions carried out by a contractor in a certain period are calculated with the unit prices in the contract and the amount of payment is determined. The progress report shows the physical realization of the work (what percentage has been completed according to plan). These documents directly determine the flow of money and contractual obligations; An accounting error means underpayment or overpayment, legal dispute and financial loss. progress payment; It includes the quantity × unit price multiplication of hundreds of manufacturing items, deductions (advance, guarantee, penalties), offset of previous progress payments and cumulative amounts. AI speeds up these repetitive calculations, streamlines tables, and helps in consistency checking. But he can make mistakes in arithmetic and contract rules; Each amount must be verified by the engineer before signing. In this unit, we will see how to produce progress and progress reports safely with AI.
Establishing Progress Payment Data Correctly
When setting up the progress payment account in AI, give the following structure:
- Manufacturing item (pose): What was made? Exposure number and description.
- Contract quantity and unit price: The total quantity in the contract and the unit price of the item.
- Actual quantity in this period: The manufacturing quantity measured and determined on-site.
- Cumulative amount: Total made to date (previous + this period).
- Deductions: Advance deduction, collateral deduction, delay penalty, withholding tax, etc.
The progress payment logic is layered: first the item-by-item amount (quantity × unit price), then the subtotal, then the cumulative deducting the previous progress payment, then the deductions. Each layer must be verified separately.
A simple example:
Item: C25/30 concrete, unit price 2.500 TL/m³ Cumulative construction: 180 m³ → 180 × 2.500 = 450.000 TL In the previous progress payment: 120 m³ → 120 × 2.500 = 300.000 TL This period: (180 − 120) × 2.500 = 60 × 2.500 = 150.000 TLItem: Ø12 reinforcement, unit price 32 TL/kg This period: 4.200 kg → 4.200 × 32 = 134.400 TLThis period manufacturing subtotal = 150.000 + 134.400 = 284.400 TL (−) Collateral deduction 5% = 284.400 × 0.05 = 14.220 TL (−) Advance offset (if any) = ... Net amount to be paid = subtotal − deductions
When AI produces such a calculation, check each line independently: is the multiplication correct, does the cumulative add up, does the deduction rate comply with the contract.
Attention: The most frequent and expensive mistakes in progress payment occur in cumulative offset: this period amount is found by deducting the previous progress payment from the cumulative amount. If the AI sets up this offset incorrectly, the same manufacturing may be paid twice or underpaid. Verify the equality cumulative − previous = this period in each item.
Weak Prompt / Strong Prompt
WEAK:"Calculate this progress payment."(Position, unit price, cumulative, previous progress payment, deduction is uncertain.)STRONG:"Produce progress payment table for the following items. Columns:Pos | Unit price | Cumulative quantity | Cumulative amount | Previous progress payment amount | This period amount. Items:- Concrete: 2.500 TL/m³, cumulative 180 m³, previous 120 m³- Reinforcement: 32 TL/kg, cumulative 12.400 kg, previous 8.200 kgRules:- This period amount = cumulative amount − previous progress payment amount- Show subtotal and 5% collateral deduction SEPARATELY at the end- Write the intermediate step of all multiplications I will verify the arithmetic and cumulative logic of each line myself.”
Progress Payment Verification
Pen arithmetic. Check the quantity × unit price multiplication on each item independently. Here is the simple but most common mistake.
Cumulative logic. This period amount = cumulative amount − previous progress payment amount. Verify this equality in each item; Prevents double payments or underpayments.
For unit price. Is the unit price used the same as the price in the contract? AI may use incorrect or outdated prices.
Deduction rules. Are the collateral, advance offset and penalty rates in accordance with the contract? Are the deduction order and base correct?
Total consistency. Does the total of the item amounts equal the subtotal, subtotal minus deductions equal to the net amount?
control
What to look for
frequent error
pencil multiplication
Is the quantity × unit price correct?
arithmetic error
cumulative
Cumulative − previous = this period
Double/missing payment
unit price
Contract price?
Incorrect/old price
deduction
Are the ratio and base correct?
wrong deduction
Total
Does it keep the subtotal and net amount?
Addition error
Progress Report and Privacy
The progress report compares actual production to plan (e.g. 40% planned, 34% actual → 6 points late). AI quickly prepares this comparison and causal summary. In addition, progress and progress data are very commercially sensitive: unit prices, profit margins, subcontractor information should not be shared with competitors. Uploading this data to a public AI service is a serious privacy violation; institutional approval and appropriate instrumentation are essential (see introduction and ethics unit).
Tip: Rather than having AI do the progress calculation, it is safer to set up the calculation in your own spreadsheet (Excel) and ask the AI only for the formula logic, consistency check, or report text. That way, digital responsibility stays with you, AI is in a support role, and sensitive data doesn't get out.
Three Mini Cases
Case 1 – Cumulative error. In a progress payment, AI calculates the amount of the concrete item for this period based on the entire cumulative amount, without deducting the previous progress payment: 450,000 TL. The engineer realizes that the previous 300,000 TL should be deducted and corrects this period to 150,000 TL. The check prevents an overpayment of 300,000 TL.
Case 2 – Incorrect unit price. AI uses the current market price for an equipment item instead of the contract price. The engineer looks at the contract and corrects it with the correct unit price. Progress payment is based on the contract price; not market price.
Case 3 – Delay report. For the monthly progress report, the project manager asks the AI for a planned/actual percent comparison and a brief executive summary. AI produces a clear table and summary; The manager adds the reasons for the delay (weather, supply) with his own information and completes the report. Low-risk, time-saving use.
Copiable prompt templates
CUMULATIVE LOGIC CHECK PROMPT: "Check the equation 'cumulative amount − previous progress payment amount = this period amount' for each item in the following progress payment table. Mark the rows that do not match and show the correct this period amount. Table: [paste]"
DETECTION VERIFICATION PROMPT:"Check the following deductions in the progress payment according to the contract rules: margin rate [%..], advance offset [...], penalty, if any.- Verify the rate of each deduction and the basis to which it is applied- Check that the order of application is correct- Show the net payable amount step by step. Data: [paste]"
Common mistakes
- Calculating this period amount without deducting the previous progress payment from the cumulative (double payment).
- Not checking item multiplications (quantity × unit price) independently.
- Using current/market price instead of contract unit price.
- Failure to verify the deduction rate, base or sequence according to the contract.
- Not checking the consistency of subtotal and net amount.
- Uploading sensitive progress data to an unapproved external AI service.
In summary
- Configure progress payment data as exposure, unit price, cumulative quantity, previous progress payment, and deduction.
- This period amount = cumulative amount − previous progress payment; Verify this equality in each item.
- Check each item multiplication and totals independently.
- Confirm the unit price and deduction rules in the contract.
- Safest way: set up the account in your own table and use AI as control/report support.
- Vesting and progress data are trade secrets; protect confidentiality, verify output before signing.
Application task
Set up a progress payment scenario for several manufacturing items (you determine the unit price, cumulative and previous progress payment amounts). Ask AI for a table with columns for exposure, unit price, cumulative amount, previous progress payment and this period amount, as well as subtotal and collateral deduction. Then: (1) check each item multiplication independently, (2) verify the equality “cumulative − previous = this period”, (3) check the deduction rate and base, (4) check the consistency of the subtotal and net amount. Note any arithmetic or logic error you find.
checklist
- [ ] I structured the progress payment data with exposure, unit price, cumulative and previous progress payment.
- [ ] I verified the quantity × unit price multiplication on each item.
- [ ] I checked the equation "Cumulative − previous = this period" in each item.
- [ ] I confirmed the contract unit price and deduction rules.
- [ ] I audited the subtotal and net amount consistency.
- [ ] I worked without uploading sensitive data to external service.
- [ ] I engineered the printout before it was signed.