You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

Description

A Subcontractor Agreement Report gives a clear summary of a subcontractor’s financial and work progress details. It helps reconcile the subcontractor’s contract, completed work, and financial records. The report is 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

Structure

Generate - Executes the report based on the selected filters or parameters.

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

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

Print Button- Opens a print preview or directly sends the report to a printer.

Fit to Screen/Zoom Button- Adjusts the report layout to fit within the screen or zooms into specific areas.

Search Button (Magnifying Glass)- An alternate or advanced search tool for locating specific records or entries.

Edit Mode Button- Enables editing mode for the report or screen.

Save disk- Allows formatting or exporting options to be saved to the desk as per required formats, such as to Excel or PDF.

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

Columns

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

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

  • Contract - Defines the category or nature of the subcontract (e.g., Civil Works, MEP, Supply, or Service).

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

  • Qty - Quantity of work or material defined in the agreement.

  • Amount (Cur) - Gross contractual value before applying any deductions.

  • Discount Amount (Cur) - Commercial discount, if any, agreed on the gross amount.

  • Payment Application- 

    1. Quantity - Quantity of work claimed in this payment period

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

    3. VAT (Cur) - Value-added tax calculated on the net amount.

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

    5. Retention VAT (Cur) - VAT amount applicable to the retained portion.

    6. Progress % - Percentage of work completed for each line item, based on certified quantities.

  • Payment Certificate (PC)

    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. 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

  • No labels