Article #724 Setting the Project Control System (PCS) Cost Management Module: Actual Payment Made and Received Management

One of the key challenges that face organizations involved in delivering construction projects is getting paid for completed and approved work in place promptly. Payment delays will have a drastic effect on the project’s success and could lead to contract termination. The issue of delayed payments applies to both cases, payments to be made also known as accounts payable (A/P), and payments to be received also known as accounts receivable (A/R).

Payments Made Against Commitment Contracts

To manage the actual payments made for approved interim progress invoices and miscellaneous invoices, the PMWeb Accounts Payable (A/P) Payment Batches module will be used. The module will create a new transaction for each A/P payment batch. There is a need to identify whether the payments will be made for specific projects or programs, a portfolio of projects, and all or particular vendors. If the selection is for a specific project, then there is also the option to select for which period this payment will be assigned.

Of course, there is the need to specify the amounts of payments that will be made through the A/P payments batch and payment method, which could be either bank transfer, cheque, cash, or any other accepted method. The A/P payment batch can be further defined by selecting values for type, category, and other user-defined fields.

WS 724 PCS Payment Management 1

The ‘Pay Invoices’ option will be selected to identify the approved invoices that meet the selection criteria for the A/P payment batch record. This will enable selecting which invoices to be paid and the amount of payment to be made for each. However, this can be manually completed by unselecting those invoices that will not be paid, then either adding the amount to be paid or the percentage of the amount to be paid on each invoice.

Nevertheless, selecting the option ‘Auto Pay’ will distribute the payment as per the order of the listed due invoices. PMWeb will automatically calculate the amounts of payments applied to invoices and the unapplied balance. The user can modify these amounts or percentages applied against each approved invoice.

WS 724 PCS Payment Management 2

After accepting the payments to be made against approved invoices, the PMWeb A/P payments batch module will list all those paid invoices. For each paid invoice, whether it is an interim progress invoice for one of the awarded contracts or a miscellaneous invoice, the list will detail the related program, project, commitment contract, if applicable, invoice reference and number, vendor, payment date, invoice description, and other details.

WS 724 PCS Payment Management 3

When selecting any of these paid invoices, the PMWeb A/P Payment module will be launched to display all details relevant to the paid invoice. This module will be used to approve payment to the vendor, for which its status must be changed to approved. This approval will be attained by stating the review and approval workflow assigned to the PMWeb A/P Payment module. The workflow will include the sequence of the tasks needed for approving the payment while adhering to the approval authority levels embedded in the workflow.

Approval of the payment requires providing details for the data fields related to the cost account or CBS level the payment will be posted against, the period for which this payment relates to the payment method, and other needed details.

WS 724 PCS Payment Management 4

At this point, when the field ‘Linked A/P Invoice’ is selected, PMWeb will automatically display the paid interim progress invoice or miscellaneous invoice. The PMWeb modules for progress invoices and miscellaneous invoices have a payment tab for which all details on actual payments made against the approved invoice will be captured. The payment tab will display all payments made against the approved interim progress invoice or miscellaneous invoice. For PMWeb instances that integrate with financial or ERP systems like Oracle EBS, SAP, MS Dynamics, and others, the payment details will be sent to PMWeb.

WS 724 PCS Payment Management 5

The PMWeb A/P Payments module will become the single repository that has details of all actual payments made against approved interim progress invoices and miscellaneous invoices. These payments are either done directly in the A/P Payments module, A/P Payment Batches module, or imported from financial and ERP systems. The paid payments data will become available to be reported to provide real-time status of all payments made to contractors, subcontractors, suppliers, and other vendors.

Captured Interest Payments Due on Delayed Payments

Depending on the delayed payment sub-clauses of the agreement between the Project Owner and the Contractor, the Contractor may be entitled to claim financing charges if he does not receive the payment within the due duration of issuing of an interim payment certificate (IPC) by the Contractor to the Engineer. If payment is not made within the stated payment period, the contractor has two options, either give notice of its intention to suspend the works or give notice of its intention to terminate the contract. During any period of suspension, financing charges continue to accrue on the unpaid amount.

Using PMWeb, the Project Owner, as well as the Contractor, can keep track of the payment status of interim payment certificates as well as the exposure for financing charges for delayed payment of IPC. The information captured in the PMWeb progress invoices and payments modules will become the basis for having a real-time tracking report for the status of payment against approved interim progress certifications and the exposure for additional finance charges due to delayed payments. The report will track the “Late Payment Certification by Engineer” by reporting the Contractor IPC issuance date, IPC due Date to Employer from Engineer, Actual Date of IPC from Engineer to Employer, and Engineer’s Delay to Issue IPC in days. In addition, the report will track the “Late Actual Payment by Employer” by reporting the Payment Due Date, Actual Date of Full Payment as per IPC, Delay in payment, payment amount made, and balance IPC payment not made by Employer.

The report will also include the calculations for the estimated interest finance charges per period associated with the Engineer’s failure to issue the IPC for payment within 28 days from submission and the estimated interest finance charges per period associated with the Project Owner’s failure to make payment within 56 days from submission. The interest finance charges will be applied on the delayed portion of the approved interim payment certificate amount only.

The calculated interest finance charges for the two types of payment delays detailed above will be added to the commitment contract using the PMWeb change order module to keep track of those additional costs. Similar to all other PMWeb modules, supportive documents can be added to change orders as well as workflow can be assigned to formalize the review and approval process. The report can be also modified to display the actual notification reference and date issued by the Contractor. This will be used to calculate the date after which suspension/ reduced rates Progress is permitted under the relevant sub-clause of the contract agreement and the date after which termination is possible.

WS 724 PCS Payment Management 6

Payments Received Against Income Invoices

Actual funds received against invoices or requisitions made against revenue or income contract agreements are captured in the PMWeb Accounts Receivable (A/R) Payment module. For Project Owners, revenue or income contracts are those used for selling the project assets, which could include, for example, office space, warehouses, storage facilities, residential flats and houses, and others. In addition, those could be assets for which the beneficiaries or end users are other departments in the organization, like building a retail space for which the beneficiary will be the retail departments. Revenue or income could also be generated from term lease agreements or operating agreements.

For public-private partnerships and other types of build-operate projects, the revenue or income will be the payments received from the government when these projects go into operation. The revenue or income contracts are the prime contract agreements signed with the Project Owner for contractors.

The PMWeb A/R Payment module will be used to capture the details of all payments received from the project beneficiary or buyer. Those will include the project name, contract agreement reference, requisition reference, the cost account or CBS the received payment will be associated with, payment period, payment method, payment date, and other needed details.

WS 724 PCS Payment Management 7

Should there be a need to have more details on the requisition that the actual payment was received for, selecting the requisition filed will automatically drill down to that relevant requisition. This will enable the PMWeb user to review the requisition details for which the payment was received.

 

WS 724 PCS Payment Management 8

Payments Reporting

One of the ready-to-use reports available in PMWeb is the Aging Report for Accounts Receivable. For each project, the report will list the income or revenue contracts that are part of the project. The report will list the approved requisitions and their payment status for each of these contracts. Depending on the payment terms associated with each income or revenue contract, the report will detail the aging bracket for each invoice. Assuming that payment terms are 30 days from invoice approval dates, these brackets will be current or less than 31 days, 31-60 days, 61-90 days, 91-120 days, and more than 121 days.

724 9

Another out-of-the-box report is the one that provides all details of accounts payable-made payments. The report includes the data fields for program, project, contract, and progress invoice paid. The report also includes the data fields for the progress period, invoice amount, payment amount, CBS the payment is associated with, payment method, payment date, and payment type and category. A similar report is also available for accounts receivable collected payments.

724 10

In addition, a report can be created to combine the actual payments made and actual payments received. This report provides the cash exposure a project could be exposed to and for which there will be a requirement to secure funds to finance this exposure. This cash-in cash-out report will provide a single version of the truth of what collections need to be made to ensure that the project is self-financed. The option of delaying the release of due payments might not be viable as all contract agreements consider this an action that would lead to a contract breach. In addition, the Project Owner will be required to make payments for interest charges for delayed payments.

WS 724 PCS Payment Management 11

Contact us