ECPUser Guide
ECPUser Guide
ECPUser Guide
PB enterprise
Online Cash Management Service
User Guide
Version 1.2
Page 1 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
Table of Contents
1. Bulk Payment and Bulk Payroll (also known as PB ECP) ......................................................... 3
1.1. Rules ....................................................................................................................................... 3
1.2. ECP Menu Navigation ............................................................................................................ 3
1.3. Stop Payment Instruction ........................................................................................................ 4
1.4. Standard Processing Fee ......................................................................................................... 4
1.5. ECP Processing Windows and Crediting Times ..................................................................... 4
2. ECP Step by Step Guide ............................................................................................................. 5
2.1. Step 1: Upload the ECP File ................................................................................................... 5
2.2. Step 2: Confirm the Uploaded File ......................................................................................... 6
2.3. Step 3: Submit the Uploaded File ........................................................................................... 7
2.4. Step 4: Maker Checks the ECP File Status ............................................................................. 8
2.5. Step 5 – Submit the Transaction ........................................................................................... 13
2.6. Step 6 – Transaction Approval.............................................................................................. 14
2.7. Step 7 - Print Payment Advice (optional) ............................................................................. 15
2.8. Step 8 – Reports and Beneficiary Email/SMS Notification .................................................. 17
3. Stop Payment ............................................................................................................................ 18
3.1. Step 1 – Find your Transaction in Transaction Approval Status .......................................... 18
3.2. Step 2 – Click on the Stop Payment button within the Reference No. ................................. 19
3.3. Step 3 – Specify the Reason of Stop Payment and proceed .................................................. 19
3.4. Step 4 – Authorize/approve the stop payment instruction .................................................... 20
4. Bulk Payment/Payroll (ECP) Filenames ................................................................................... 21
4.1. Filenames for Bulk Payroll (ECP Payroll) ............................................................................ 21
4.2 Filenames for Bulk Payment (ECP Payment) ....................................................................... 22
5. Bulk Payment/Payroll (ECP) Excel Format .............................................................................. 23
6. Bulk Payment/Payroll (ECP) Text Format ............................................................................... 25
7. Bulk Payment/Payroll (ECP) Feedback File Format ................................................................ 28
8. PB ECP Beneficiary E-mail Notification Template.................................................................. 31
9. PB ECP Beneficiary SMS Notification Template .................................................................... 31
Page 2 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
ii. PB enterprise offers two types of bulk services, ECP Payment and ECP Payroll.
o ECP Payroll – Generally used by a company’s Human Resource department
for salary payments. Debiting of funds from the Current Account is in lump
sum.
o ECP Payment – Generally used by a company’s Finance department for
supplier payments. Debiting of funds from the Current Account is by
individual transaction.
iii. Customers may request for different users to have access to ECP Payroll and ECP
Payment. This means that ECP Payroll users are not able to see transactions
performed through ECP Payment and vice versa.
iv. Customers are required to upload a file based on the ECP format through PB
enterprise. Refer to Section 5 onwards for the File Formats.
v. Three methods of payment can be combined in a single file (Intrabank, IBG and
RENTAS).
vi. ECP reports can be downloaded under the “Reports” menu of PB enterprise.
vii. Funds must be made available in the debiting account before the approved
processing window.
Page 3 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
b. To access the Stop Payment function, navigate to the Transaction Approval Status
screen, locate your transaction and click on the Stop Payment button.
c. Ensure that the Stop Payment instruction is fully approved within the required time.
If this is not done within the required time, there is no other way for the Bank
to stop your payment
Page 4 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
Navigation: File Upload > ECP Payment/ECP Payroll > ECP Payment/Payroll
Upload > Initiate
Not Required - Beneficiary bank will not check the ID of the selected
account
*ID Checking is mandatory for all RENTAS transactions at all times
even if “Not Required” is selected
5 Payment The payment purpose will be displayed to the approver(s) of the
Purpose transaction and in the Current Account statement
6 Next Upon clicking “Next”, if the general format of the file is invalid, an
error message will be prompted to the Maker indicating the reason
the upload failed. If there are no issues, the screen will navigate to
the Confirmation page
Page 5 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
Navigation: File Upload > ECP Payment/ECP Payroll > ECP Payment/Payroll
Upload > Initiate > Confirmation
a. If the file uploaded meets the ECP format requirements, the confirmation page will
display the information provided by the customer from the previous step.
Page 6 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
Navigation: File Upload > ECP Payment/ECP Payroll > ECP Payment/Payroll
Upload > Initiate > Confirmation > Acknowledgement
a. The file is accepted by the system for validation therefore, the Status is “Pending
Validation”
b. The Maker is required to view the status of the validation and decide the next
course of action at the “ECP File Status” page.
c. The Maker can also choose to print the page or upload another file
Page 7 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
a. The ECP File Status screen will display the status of all the ECP files that have been
uploaded
b. Maker is required to click on the Reference No. to view the file and confirm the details
that they have uploaded before the transaction can be approved.
Page 8 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
a. In this scenario, all the records are invalid. As such, the only option for the Maker is to
take no further action or to Remove File.
b. Remove File is used if the Maker wants to upload the same filename and unique record
id again else, a new filename and unique record ID needs to be provided
c. Maker is able to “Download Error Report” to view the details and explanation of the
records with errors
Page 9 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
Page 10 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
Page 11 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
Example 3: ECP File Status – Records are mixed with both valid and invalid results
Page 12 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
a. After the Maker confirms that they want to submit the file for approval, click on
“Submit” and the Maker will be presented with an acknowledgement page.
Page 13 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
b. There is a special approval rule for PB ECP whereby the file can be approved even after
the selected payment date has lapsed. The system will prompt the user that the payment
date has lapsed and if the user would like to change the payment date to the next
available date. To illustrate this, refer to the screenshots below.
i. Payment Date Lapsed Screen 1: The Effective Date is 03-Jan-2018 but today’s
date is 17-Jan-2018. It is already past the date originally selected by the Maker
ii. Payment Date Lapsed Screen 2: After clicking Approve, the following message
will appear.
Page 14 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
iii. Payment Date Lapsed Screen 3: If the approver clicks on “OK”, notice that the
payment date has changed from 03-Jan-2017 to 17-Jan-2017
a. Print Payment Advice will generate a PDF file containing payment advices based on
the file uploaded by the customer upon request
b. For example, if there are 150 transactions contained in the ECP file, a Payment advice
with 150 pages will be generated.
c. Payment advices is only generated for successfully debited transactions. All payment
advices can only be requested/downloaded for up to 90 calendar days from the payment
date. After 90 calendar days, there is no way to retrieve/download any payment
advise.
Page 15 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
f. Sample of the payment advice PDF file is illustrated below. This example shows that
the payment advice has 6 pages meaning the file contain 6 successful transactions.
Page 16 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
b. The beneficiary email and SMS notification will be sent to the beneficiaries
approximately within 30 minutes after the processing window. The receipt of the email
and SMS is subject to the beneficiary’s network/mobile/internet service provider.
c. The difference between the Status Report and the T+2 status report is that the T+2 status
report will incorporate any IBG rejection items that have been returned into the status
instead of displaying the returned item as “Processed”. T+2 reports are always
generated 2 days after the payment date.
Page 17 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
3. Stop Payment
a. It is possible to stop a file that has already been approved as long as it has not been
processed yet
b. The Stop Payment instruction can only be executed through PB enterprise 30 minutes
before the selected processing window.
c. If the stop payment instruction is received and not fully approved within 30 minutes
before the selected processing window, the transaction will be processed and the stop
payment instruction will be considered as expired. In this scenario, there is no other
way for the Bank to stop your payment
d. The Stop Payment button can be located under the Transaction Approval Status page.
Any role has the function to initiate the Stop Payment instruction.
Page 18 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
3.2. Step 2 – Click on the Stop Payment button within the Reference No.
a. A pop-up screen will show with the Stop Payment button. If the button is not
displayed, it means that the allowed time to Stop Payment has lapsed.
Page 19 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
Page 20 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
PB enterprise Bulk Payroll (HR) File Name Format Sample File Name
Upload Payroll File (Excel) <10 digit Account No.><PR><DDMMYY><Serial No starting 3111111111PR17111701.xls
with 01>.xls or
or 3111111111PR17111701.xlsx
<10 digit Account No.><PR><DDMMYY><Serial No starting
with 01>.xlsx
*DDMMYY is the actual payment date
Upload Payment File (Text) <10 digit Account No.><PM><DDMMYY><Serial No starting 3111111111PM17111701.txt
with 01>.txt
*DDMMYY is the actual payment date
PB ECP Payroll Status Feedback File (PRSFF) PRSFF<uploaded filename>.txt PRSFF3111111111PR17111701.txt
Page 21 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
PB enterprise Bulk Payment (non-HR) File Name Format Sample File Name
Upload Payment File (Excel) <10 digit Account No.><PM><DDMMYY><Serial No starting 3111111111PM17111701.xls
with 01>.xls or
or 3111111111PM17111701.xlsx
<10 digit Account No.><PM><DDMMYY><Serial No starting
with 01>.xlsx
*DDMMYY is the actual payment date
Upload Payment File (Text) <10 digit Account No.><PM><DDMMYY><Serial No starting 3111111111PM17111701.txt
with 01>.txt
*DDMMYY is the actual payment date
PB ECP Payment Status Feedback File (PSF) PSF<uploaded filename>.txt PSF3111111111PM17111701.txt
PB ECP Payment Status Report (PSR) PSR<uploaded filename>.pdf PSR3111111111PM17111701.pdf
or or
PSR<uploaded filename>.csv PSR3111111111PM17111701.csv
Payment IBG Return Feedback File (IBG) IBG<uploaded filename>.txt IBG3111111111PM14081701.txt
Payment IBG Return Report (IBR) IBR<uploaded filename>.pdf IBR3111111111PM14081701.pdf
or or
IBR<uploaded filename>.csv IBR3111111111PM14081701.csv
PB ECP Payment Status Report (T+2) PSR<uploaded filename>T2.pdf PSR31111111PR14081701T2.pdf
or or
PSR<uploaded filename>T2.csv PSR31111111PR14081701T2.csv
or or
PSR<uploaded filename>T2.txt PSR31111111PR14081701T2.txt
Page 22 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
Page 23 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
Page 24 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
Page 25 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
Page 26 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
Footer - 51 bytes
No. Trailer Field Format From M/O Remark
Position
Page 27 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
Page 28 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
18
Total Fee –
N 12 278 289 Total Fee for Intrabank
Intrabank
Total Processed -
19 N 6 290 295 Total Processed Records for IBG
IBG
20 Service Fee – IBG N 12 296 307 Service Fee for IBG
21 SMS Fee – IBG N 8 308 315 SMS Fee for IBG
22 Total Fee – IBG N 12 316 327 Total Fee for IBG
Total Processed - Total Processed Records for
23 N 6 328 333
RENTAS RENTAS
Service Fee –
24 N 12 334 345 Service Fee for RENTAS
RENTAS
SMS Fee –
25 N 8 346 353 SMS Fee for RENTAS
RENTAS
Total Fee –
26 N 12 354 365 Total Fee for RENTAS
RENTAS
Footer - 51 bytes
From To
No Trailer Field Format Length Remark
Position Position
1 Footer Identifier A 1 1 1 Default : F
Total Record
2 N 10 2 11 Total number of records
Count
Page 29 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
Page 30 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll
Page 31 of 31