Contract Management Reports
Overview
This section shows the different Reports available in the Contract Management module. For each Report, the Output is first presented, and then the procedure for generating the Report is made available
Contract Listing Report
Overview
This report shows a List of Contracts each one with contract information such as ID, Short Description, Type, Vendor, Start Date, End Date, Status, Total Amount, Physical Current Progress, and Payment Current Progress.
Some additional filters are available such as Contract Status, Institution, Vendor, Contract Type, Funding Source, Project, Fiscal Year, and Start Date Period.
Sort criteria by any column are possible.
Navigation
Contract Management ► Contract Management Reports ►Contract Listing Report
Definition Of Report Fields
| Field | Description |
Institution | If selected, the report will include the selected Institution unit and all Institutions below the selected unit |
Vendor | Name of Vendor. |
Contract Type | Contract Type. Ex: Big Works, Goods, Services, etc. |
Initial Execution Fiscal Year | Filter criteria to filter the report by Fiscal Year. |
Start Date From | Start date of the Contract. |
Start Date To | Filter criteria to filter the report by Start Date. |
Contract Status | Filter criteria to filter the report by Contract Status. |
Comments | Users can give additional comments on the report. |
Sort | Criteria determining how the report information will be sorted are selected from the field |
Contracts Summary by Institution Report
Overview
This report shows a list of Institutions each one with summary information of its Contracts such as Contracts Quantity, Total Amounts, and Already Paid Amount, etc
Navigation
Contract Management ► Contract Management Reports ► Contracts Summary by Institution Report
Contract Line Item Drop screen fields and Tab
Field | Description |
Vendor | Filter criteria to filter the report by Vendor |
Contract Type | Filter criteria to filter the report by Contract Type |
Initial Execution Fiscal Year | Filter criteria to filter the report by Fiscal Year |
Start Date From | Filter criteria to filter the report by Start Date From |
Start Date To | Filter criteria to filter the report by Start Date To |
Contract Status | Filter criteria to filter the report by Contract Status |
Comment | Additional comments to be added to output report |
Amounts Rounding | Filter criteria to filter the report by Amounts Rounding |
Sort By | Filter criteria to sort the report by the selected criteria |
Id | Filter criteria to sort the report by Id |
Funding Source Tab | Filter criteria to filter the report by Funding Source |
Project Tab | Filter criteria to filter the report by Project |
Contracts Summary by Institution Unit Report
Overview
This Report shows a List of Institutions Units which belong to the same Institution. The Report shows each Institution Unit with summary information of its Contracts such as Contract Quantity, Total Amount, and Already Paid Amount.
Navigation
Contract Management ► Contract Management Reports ► Contracts Summary by Institution Unit Report
Contracts Summary by Institution Unit Report screen fields and Tab
| Field | Description |
Institution | Filter criteria to filter the report by Institution |
Vendor | Filter criteria to filter the report by Vendor |
Contract Type | Filter criteria to filter the report by Contract Type |
Initial Execution Fiscal Year | Filter criteria to filter the report by Fiscal Year |
Start Date | Filter criteria to filter the report by Start |
Contract Status | Filter criteria to filter the report by Contract Status |
Comments | Additional comments to be added to output reports |
Sort By | Filter criteria to sort the report by the selected criteria |
Institution Id | Filter criteria to sort the report by Institution Id |
Funding Source Tab | Filter criteria to filter the report by Funding Source |
Project Tab | Filter criteria to filter the report by Project |
Contracts Summary by Vendor Report
Overview
This report shows a list of Vendors each one with summary information of its Contracts such as Contracts Quantity, Total Amounts, and Already Paid Amount
Navigation
Contract Management ► Contract Management Reports ► Contracts Summary by Vendor Report
Contracts Summary by Vendor Report screen fields and Tab
| Field | Description |
Institution | Filter criteria to filter the report by Institution |
Vendor | Filter criteria to filter the report by Vendor |
Contract Type | Filter criteria to filter the report by Contract Type |
Initial Execution Fiscal Year | Filter criteria to filter the report by Fiscal Year |
Start Date | Filter criteria to filter the report by Start |
Contract Status | Filter criteria to filter the report by Contract Status |
Comments | Additional comments to be added to output reports |
Sort By | Filter criteria to sort the report by the selected criteria |
Institution Id | Filter criteria to sort the report by Institution Id |
Funding Source Tab | Filter criteria to filter the report by Funding Source |
Project Tab | Filter criteria to filter the report by Project |
Contracts Summary By Funding Source Report
Overview
This Report shows a List of Funding Sources, each one with Contract summary information such as Total Planned Amount, Contracts Quantity, Contracts Total Amount, etc.
Navigation
Contract Management ► Contract Management Reports ► Contracts Summary by Funding Source Report
Contracts Summary by Institution Unit Report screen fields and Tab
| Field | Description |
Institution | Filter criteria to filter the report by Institution |
Vendor | Filter criteria to filter the report by Vendor |
Contract Type | Filter criteria to filter the report by Contract Type |
Initial Execution Fiscal Year | Filter criteria to filter the report by Fiscal Year |
Start Date | Filter criteria to filter the report by Start |
Contract Status | Filter criteria to filter the report by Contract Status |
Comments | Additional comments to be added to output reports |
Sort By | Filter criteria to sort the report by the selected criteria |
Funding Source | Filter criteria to filter the report by Funding Source |
Project | Filter criteria to filter the report by Project |
| Rounding Option | Filter criteria to filter the report by Rounding Option. |
Cash Outflow Projection Report
Overview
This report provides month-wise breakdown of planned, actual and balance of the payments during a fiscal year for each managed contract under the Institution. The report displays grouping level by Institution in which it summarizes planned, actual and balance of the payments information of the managed contracts against vendors for each specific Institution.
Navigation
Contract Management ► Contract Management Reports ► Cash Outflow Projection Report
Cash Outflow Projection Report screen Fields
Field | Description |
Fiscal Year | Fiscal year used as filter criteria. |
Comment | Users can add comments for future reference. |
| Institution | Institute to be selected along with fiscal year for filtering records. |
Contract Payment Follow Up Report Labels
Overview
The Contract Payment Follow Up Report Labels Report shows payment information of contracts line items and drops.
A screenshot of the Tracking of Contacts Report feature is available here. Image is shown as reference material; position and names for labels, fields, and buttons are subject to the parameter, rendering control configuration and installed the revision.
Users access the report from within the menu through this navigation path: Contract Management ► Contract Management Reports ► Tracking of Contracts.
Filters
The following table lists and describes all filter for the Contract Payment Follow Up Report Labels Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.
| Field | Description |
|---|---|
| Contract ID | This field refers to id of managed contract for the report. |
Visible Fields
A sample of the Contract Payment Follow Up Report Labels Report output is available here. The following table lists and describes all visible fields for the Contract Payment Follow Up Report Labels Report, in their default order. Note that some fields depend on system parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.
| Field | Description |
|---|---|
| Contract | This section of the report shows details of the selected contract in the report filter. |
| Line Item Detail | The Line Item Detail section shows the details of the contract line item. |
| Drop ID | The Drop Id section contains details of the drops related to the contract line item. |
| Payment Details | Payment Detail section shows the payment details related to the drops. |
Buttons
The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Contract Payment Follow Up Report Labels.
| Button Image | Description |
|---|---|
 | This button allows users to generate the report as PDF. |
 | This button allows users to generate the report as MS Excel. |
 | This button allows users to generate the report as MS Excel (XLSX format). |
 | This button allows users to generate the report as RTF. |
 | This button allows users to generate the report as MS Word. |
 | This button allows users to generate the report as ODT. |
 | This button allows users to generate the report as ODS. |
Contracts Summary by Project Report
Overview
This report shows a list of Projects each one with summary information of their Contracts such as Contracts Quantity, Contracts Total Amount, and Already Paid Contracts Amount
Navigation
Contract Management ►Contract Management Reports ►Contracts Summary by Project Report
Contracts Summary by Project Report screen fields and Tab
| Field | Description |
Institution | Filter criteria to filter the report by Institution |
Vendor | Filter criteria to filter the report by Vendor |
Contract Type | Filter criteria to filter the report by Contract Type |
Initial Execution Fiscal Year | Filter criteria to filter the report by Fiscal Year |
Start Date | Filter criteria to filter the report by Start |
Contract Status | Filter criteria to filter the report by Contract Status |
Comments | Additional comments to be added to output reports |
Sort By | Filter criteria to sort the report by the selected criteria |
Funding Source Tab | Filter criteria to filter the report by Funding Source |
Planned Payments By Fiscal Period Report
Overview
This report generates information about the planned contract payments during a year (fiscal periods) for each managed contract and institution. It also displays the total of amount corresponding to the planned contract payments for each fiscal period during a fiscal year.
Navigation
Contract Management ► Contract Management Reports ► Planned Payments By Fiscal Period Report.
Planned Payments By Fiscal Period Report Fields
Field | Description |
Fiscal Year | Fiscal Year to which Planned Contract Payment relates, to be selected from dropdown box. |
Institution | Related Institution to be selected from lookup button. |
Comments | Comment on the report to be entered by users in this field. |
Sort By: Institution | Sorting of report by Institution either in Ascending Order or Descending Order is done from Upward or downward button. |
Sort By: Managed Contract | Sorting of report by Managed Contract either in Ascending Order or Descending Order is done from Upward or downward button. |
Planned Versus Actual Payments By Fiscal Period Report
Overview
This report shows information about the planned and actual contract payments during a year (fiscal periods) for each managed contract and institution.
A screenshot of the Planned Versus Actual Payments By Fiscal Period Report is available here. Image is shown as reference material; position and names for labels, fields, and buttons are subject to the parameter, rendering control configuration and installed the revision.
Users access the report from within the menu through this navigation path: Contract Management ► Contract Management Reports ► Planned Versus Actual Payments By Fiscal Period Report.
Filters
The following table lists and describes all filter for the Monthly Report of Non-Tax Revenue Collections Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.
| Field | Description |
|---|---|
| Fiscal Year | The field refers to the fiscal year for the report. |
| Institution | This field allows users to select an institution to see a report for a specific institution. |
| Comment | The field allows users to add a custom comment to the generated report. |
| Sort By | This feature allows users to sort the report data by Institution, Managed Contract, Institution Description, and Managed Contract Description. |
Visible Fields
A sample of the Planned Versus Actual Payments By Fiscal Period Report output is available here. The following table lists and describes all visible fields for the Planned Versus Actual Payments By Fiscal Period Report, in their default order. Note that some fields depend on system parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.
| Field | Description |
|---|---|
| ID | It refers to Managed Contract id. |
| Description | It shows a short description of the respective Managed Contract. |
| Payment Type | It shows the contract payment type planned or actual. |
| Fiscal Periods | This is a summary of the fiscal period column for the managed contracts belonging to the Institutions. The amount for different fiscal periods shows in their respective column of the fiscal period. |
| Total | This column shows the sum of all fiscal period column amounts. |
Buttons
The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Planned Versus Actual Payments By Fiscal Period Report.
| Button Image | Description |
|---|---|
 | This button allows users to generate the report as HTML. |
| This button allows users to generate the report as PDF. |
| This button allows users to generate the report as MS Excel. |
| This button allows users to generate the report as MS Excel (XLSX format). |
| This button allows users to generate the report as MS Word. |
| This button allows users to generate the report as ODT. |
| This button allows users to generate the report as ODS. |
Contract General Information Report
Overview
This Report shows general information for a Contract, such as ID, Reference Number, Short Description, etc.
Navigation
Contract Management ► Contract Management Reports ► Contract General Information Report
Contract General Information Report screen field and Tab
Field | Description |
Contract | Filter criteria to filter the report by Contract. |
Contract Line Items Report
Overview
This Report shows the List of Line Items or Activities within a Contract
Navigation
Contract Management ► Contract Management Reports ► Contract Line Items Report
Contract Line Items Report screen fields and Tab
Field | Description |
Contract | Filter criteria to filter the report by Contract |
Line Item Status | Filter criteria to filter the report by Line Item Status |
Line Item Type | Filter criteria to filter the report by Line Item Type |
Comments | Additional comments to be added to output reports |
Sort By | Filter criteria to sort the report by the selected criteria |
Contract Drops Report
Overview
This Report shows the List of Drops or Work Items within a Contract.
Navigation
Contract Management ► Contract Management Reports ► Contracts Drops Report
Contracts Drops Report screen fields and Tab
Field | Description |
Contract | Filter criteria to filter the report by Contract |
Line Item | Filter criteria to filter the report by Line Item |
Status | Filter criteria to filter the report by Status. |
Comments | Additional comments to be added to output reports |
Sort By | Filter criteria to sort the report by the selected criteria |
Delivery Date From | Filter criteria to filter the report by Delivery Date From |
Delivery Date To | Filter criteria to filter the report by Delivery Date To |
Contract Inspections Report
Overview
This Report shows the List of Physical Inspections within a Contract. Each Physical Inspection with the following information: Inspection ID, Inspection Status, Planned Date, Inspection Date, Drop Physical Progress, Line Item ID to which belongs, Drop ID to which belongs, Inspector Responsible, and Comments.
Some additional filters are available such as Inspection Status, Planned Date Period, Inspection Date Period, Drop, and Line Item.
Navigation
Contract Management ► Contract Management Reports ► Contract Inspection Report
Contract Inspection Report screen fields and Tab
Fields | Description |
Contract | Filter criteria to filter the report by Contract. |
Line Item | Filter criteria to filter the report by Line Item. |
Line Item Drop | Filter criteria to filter the report by Line Item |
Inspection Status | Filter criteria to filter the report by Inspection Status |
Comments | Additional comments to be added to output reports. |
Planned From Date | Filter criteria to filter the report by Planned From Date. |
Planned To Date: | Filter criteria to filter the report by Planned To Date. |
Inspection From Date | Filter criteria to filter the report by Inspection From Date. |
Inspection To Date | Filter criteria to filter the report by Inspection To Date |
Sort By | Filter criteria to sort the report by the selected criteria |
Inspection Id | Filter criteria to sort the report by Inspection Id. |
Contract Payments Report
Overview
This report shows a list of Payments including Normal Planned Payments and Payment Advances within a Contract.
Navigation
Contract Management ► Contract Management Reports ► Contract Payments Report
Contract Payments Report screen fields
Field | Description |
Contract | Filter criteria to filter the report by Contract |
Payment Status | Filter criteria to filter the report by Payment Status |
Planned Date From | Filter criteria to filter the report by Planned Date From |
Planned Date To | Filter criteria to filter the report by Planned Date To |
Payment Date From | Filter criteria to filter the report by Payment Date From |
Payment Date To | Filter criteria to filter the report by Payment Date To |
Payment Type: | Filter criteria to filter the report by Payment Type |
Funding Source | Filter criteria to filter the report by Funding Source |
Payment Method | Filter criteria to filter the report by Payment Method |
Comments | Additional comments to be added to output reports |
Payment Details | Filter criteria to filter the report by Payment Details. |
Sort By | Filter criteria to sort the report by the selected criteria |
Payment Id | Filter criteria to sort the report by Payment Id. |
Contract Payment Detail Report
Overview
This Report shows the detailed information of a Payment, such as; ID, Type, Status, Planned Date, Payment Date, etc. The report also contains Payment Detail information; a list of payment details associated with the payment. Each Payment Detail is associated with a Drop of the Contract.
Navigation
Contract Management ► Contract Management Reports ► Contract Payment Detail Report
Contract Payment Detail Report screen fields
Field | Description |
Payment | Filter criteria to filter the report by Payment |
Contract Payment Retentions Report
Overview
This Report shows a List of Payment Retentions within a Contract
Navigation
Contract Management ► Contract Management Reports ► Contract Payment Retentions Report
Contract Payment Retentions Report screen fields
Fields | Description |
Contract | Filter criteria to filter the report by Contract. |
Line Item | Filter criteria to filter the report by Line Item |
End Date From: | Filter criteria to filter the report by End Date From |
End Date To | Filter criteria to filter the report by End Date To. |
Status | Filter criteria to filter the report by Status. |
Comments | Additional comments to be added to output reports. |
Sort By | Filter criteria to sort the report by the selected criteria |
Payment Retention Id | Filter criteria to sort the report by Payment Retention Id |
Payment Summary by Contract Report
Overview
This Report shows a List of Contracts each one with summary information of their Payments such as Contract Total Amount, Planned Payments Amount, Already Paid Amount, etc
Navigation
Contract Management ► Contract Management Reports ► Payment Summary by Contract Report
Payment Summary by Contract Report screen fields
| Field | Description |
Institution | Filter criteria to filter the report by Institution |
Vendor | Filter criteria to filter the report by Vendor |
Contract Type | Filter criteria to filter the report by Contract Type |
Initial Execution Fiscal Year | Filter criteria to filter the report by Fiscal Year |
Contract Status | Filter criteria to filter the report by Contract Status |
Comments | Additional comments to be added to output reports |
From date | Filter criteria to filter the report by Start Date From |
To Date | Filter criteria to filter the report by Start Date To |
Sort By | Filter criteria to sort the report by the selected criteria |
Funding Source Tab | Filter criteria to filter the report by Funding Source |
Project Tab | Filter criteria to filter the report by Project |
Contract Physical Tracking Report
Overview
This Report shows the current situation of Physical Progress of a Contract. It includes Line Items, Drops, and Inspections each one with percentage of progress based on Physical Inspections or Receptions
Navigation
Contract Management ► Contract Management Reports ► Contract Physical Tracking Report
Contract Physical Tracking Report screen fields
| Fields | Description |
Contract | Filter criteria to filter the report by Contract ID |
Contract Payment Tracking Report
Overview
This Report shows the current situation of Payment progress in a Contract. It includes Line Items, Drops, and Payments each one with amounts and percentages of progress based on completed Payments
Navigation
Contract Management ► Contract Management Reports ► Contract Payment Tracking Report
Contract Payment Tracking Report screen fields
| Fields | Description |
Contract | Filter criteria to filter the report by Contract ID |
Contract Complete Tracking Report
Overview
This Report shows the current situation of Physical and Payment Progress in a Contract. It includes Line Items and Drops each one with amounts and percentages of progress based on Physical Inspections and completed Payments.
Navigation
Contract Management ► Contract Management Reports ► Contract Complete Tracking Report
Contract Complete Tracking Report screen fields
| Fields | Description |
Contract | Filter criteria to filter the report by Contract ID |