Page History

...

A Subcontractor Agreement Report provides gives a structured overview clear summary of a subcontractor’s financial and progress data related to a subcontractor’s contractual scope. It acts as a reconciliation tool aligning contractual commitments, executed work progress details. It helps reconcile the subcontractor’s contract, completed work, and financial records. The report is primarily mainly used by finance, project control, and audit teams to verify:-

• Contract quantities and values

• Work progress versus agreed scope

• Retention and VAT computations

• Consistency between certified work and invoiced amounts

...

Find- Allows users to search within the report for specific text or values.

Collapse/Expand Groups – - Show or hide grouped sections in the report.

...

Send- Used to email or forward the report directly to another user or contact.

Columns

• Project Name –  - Identifies the project under which the subcontract is executed.

• Subcontractor Name –  - Specifies the contractor responsible for executing the work.

• Contract Type – Defines the category or nature of the subcontract (e.g., Civil Works, MEP, Supply, or Service).Qty – -The contract linked to the subcontractor agreement.

• Subcontractor agreement - Refers to the formal document agreement with the subcontractor.
• Subcontractors WBS -Work Breakdown Structure assigned to the subcontractor.
• Agreement

1. 1. Qty - Quantity of work or material defined in the agreement.
   2. Amount (Cur)

...

1. 1. - Gross contractual value before applying any deductions.
   2. Discount Amount (Cur)

...

1. 1. - Commercial discount, if any, agreed on the gross amount.

...

• Payment Application- 

1. 1. Quantity -Quantity of work claimed in this payment period
   2. Amount (Cur)

...

1. 1. - Value after applying discount; used as the base for VAT and retention.
   2. VAT (Cur)

...

1. 1. - Value-added tax calculated on the net amount.
   2. Retention (Cur)

...

1. 1. - Portion of the net amount withheld as a performance or quality guarantee.
   2. Retention VAT (Cur)

...

1. 1. - VAT amount applicable to the retained portion.
   2. Progress %

...

1. 1. - Percentage of work completed for each line item, based on certified quantities.

• Payment Certificate (PC)

1. 1. Qty - Amount of work certified for this payment.
   2. Amount (Cur) - Contractual value of the certified work.
   3. VAT (Current) - VAT on the certified work for this period.
   4. Retained - Portion of the certified amount held back (retention).
   5. Retention VAT (Cur) - VAT on the retained amount.
   6. Progress % - % of total project/work approved so far.

• Invoiced

1. 1. Qty - Quantity invoiced by the subcontractor.
   2. Amount (Cur) - Amount invoiced, excluding VAT.
   3. VAT (Current) - VAT on the invoiced amount.
   4. Retention (Cur) - Retention deducted from the invoice.
   5. Retention VAT (Cur) - VAT on the retention amount.
   6. Progress % - % of total contract value invoiced to date.

Filters and Parameters

Report date - Select on date of the report

Entity – - Selects a specific legal entity or company unit; the report shows data for the chosen entity only.

Project – - Filters the report to a selected project

Image Modified