HRPay File Generator User Manual
Contents
1. e You can indicate future payment date here The transaction will be processed on the mentioned date 8 Testing File e Always select NO e No testing is allowed for Statutory Body payments 9 Confidential e Yes detail in the file is not viewable by anyone except those who has confidential rights e No detail in the file is viewable by anyone who has access to SALARY COPYRIGHT 2009 Enterprise Banking Solution Maybank Page 7 of 16 mayeank net Online Enterprise Cash Management e No value same as N 10 EPF Registration File e Yes file is for EPF registration purposes e No file is for EPF contribution payment B EMPLOYER DETAILS 1 Contribution Month and Year e Mandatory e Format MMYYYY e g 052009 for contribution May 2009 2 Company Contact Person e Mandatory e Contact Person for EPF to contact for any inquiries e Maximum length allowed is 25 characters inclusive of space 3 Company Contact Number e Mandatory e Phone Number of Contact Person for EPF to contact for any inquiries e Maximum length allowed is 15 characters inclusive of space 4 EPF Employer Reference No e Mandatory e The registered EPF Employer Reference No e Maximum length allowed is 9 characters without space 5 EPF Employer Name e Mandatory e Company name which is registered with EPF for the mentioned EPF Employer Reference No e Maximum length allowed is 40 characters inclusive of space 6 Company State Code e Mandat2. by anyone who has access to SALARY e No value same as N B EMPLOYER DETAILS 1 Contribution Month and Year e Mandatory e Format MMYYYY e g 052009 for contribution May 2009 2 SOCSO Employer Reference No Mandatory e Maximum length allowed is 9 characters inclusive of space O EMPLOYEE DETAILS Staff Name e Mandatory m e Maximum length allowed is 40 characters inclusive of space 2 Staff New IC Old IC Passport Number e Mandatory at least 1 of the above must have a value e New IC format 801231018888 without dash 3 SOCSO Employee Reference No e Optional 4 Employee Amount e Mandatory e Format 00 00 5 Employer Amount e Mandatory e Format 00 00 After completing filling up the file details employer details and employee details follow the step below 1 Click Generate SOCSO File 2 Please select the folder location to save the generated file in the new window You may rename the file name The file name cannot be duplicated Click OK COPYRIGHT 2009 Enterprise Banking Solution Maybank Page 11 of 16 mayeank net Online Enterprise Cash Management How to generate an IRB File A FILE DETAILS 1 Client Code e Value will be given by the bank e Maximum length allowed is 10 characters inclusive of space 2 PIR Reference No e Mandatory field e File reference determined by you E g SALARY 31122009 e Maximum length allowed is 20 characters inclusive of space 3 Debit Account Number e Ma
3. mayeank net Online Enterprise Cash Management HRPay File Generator Disclaimer By using the HRPay File Generator you expressively agree to the following Terms and Conditions details below HRPay File Generator is a product of Enterprise Banking Solution Malayan Banking Berhad 1 Under no circumstances including but not limited to negligence shall bank be liable for any direct indirect incidental special of consequential damages arising out of the use of or inability to use HRPay File Generator The transaction generated via the HRPay File Generator will not be deemed as an official payment instruction to the bank It will be the user responsibility to verify confirm and authorize the payment instruction after the uploading of the generated file Payment instruction uploaded and authorized via Maybank2e net will be deemed as an official payment instruction to the bank Any dispute on the transaction will be based on the authorized transaction uploaded into Maybank2e net Bank will not be responsible for the inability to use the HRPay File Generator if there are any amendment to the layout and the coding You should only use the value given by bank for these field below a Client Code File generated from the HRPay File Generator will be processed in batch mode only COPYRIGHT 2009 Enterprise Banking Solution Maybank Page 1 of 16 mayeank net Online Enterprise Cash Management User Manual Settings You must set the
4. s Account Statement e Maximum length allowed is 40 characters inclusive of space 7 Payment Date e Mandatory field e Format YYYYMMDD Example 20081231 e You can indicate future payment date here The transaction will be processed on the mentioned date 8 Testing File e Optional field e Yes file is for testing purpose e No file is an actual salary file 9 Confidential e Yes detail in the file is not viewable by anyone except those who has confidential rights COPYRIGHT 2009 Enterprise Banking Solution Maybank Page 5 of 16 mayeank net Online Enterprise Cash Management e No detail in the file is viewable by anyone who has access to SALARY e No value same as N B EMPLOYEE SALARY DETAILS 1 Staff Name e Mandatory field e Name of the account holder that you want to pay to e Maximum length allowed is 40 characters inclusive of space 2 Staff Bank e Mandatory field e The bank which you want to pay to e Please use the Bank Code listed on Bank Code List sheet 2 Staff Account No e Mandatory field e The bank account number of the person company that you want to pay to 3 Company Staff No e Optional field e Your staff s company number 4 Staff New IC Old IC Passport No e Mandatory field at least 1 of the above must have a value e New IC format 801231018888 without dash 5 Salary Amount e Mandatory field e Format 00 00 e Salary amount to be paid to the staff After completing fil
5. Macro security setting to low before you start using HRPay File Generator This is a one time exercise For Microsoft Office XP 1 Oe E Open the Microsoft Excel application On the Tools menu point to Macro and click Security The Security dialog box will appear Click on the Security tab Click on the Low and click OK Save the File Generator excel file Close the Microsoft Excel application and reopen the saved version For Microsoft Office 2003 OO Stee Ye iN Open the Microsoft Excel application On the Tools menu point to Macro and click Security The Security dialog box will appear Click on the Security tab Click on the Low and click OK Save the File Generator excel file Close the Microsoft Excel application and reopen the saved version For Microsoft Office 2007 ae OS Open the Microsoft Excel application Please ensure that you will be able to see Developer menu Otherwise please turn on the developer menu by doing the below step a Click on the Office icon button on the top left b Click on Excel Option button at the bottom of the dialog box c Tick on the box for Show developer tab in the Ribbon d Click OK On the Developer menu click Macro Security The Trust Center dialog box will appear Click on the Macro Setting from the left menu Select Mark Enable all macros and click OK Save the File Generator excel file Close the Microsoft Excel application and reopen the sav
6. aybank Page 16 of 16
7. e given by the bank e Maximum length allowed is 10 characters inclusive of space 2 PIR Reference No e Mandatory field e File reference determined by you E g SALARY 31122009 e Maximum length allowed is 20 characters inclusive of space 3 Debit Account Number e Mandatory field e the company account number to pay from 4 Mode of Processing e Optional e Batch it will be processed by the batch processing windows e Realtime only allow maximum 10 salary payments to be made in 1 file e No value same as Batch 5 Debit Reference e Optional e Transaction Reference determined by you This value will be shown in your company s Account Statement e Maximum length allowed is 14 characters inclusive of space 6 Debit Description e Optional e Transaction Description determined by you This value will be shown in your company s Account Statement e Maximum length allowed is 40 characters inclusive of space 7 Payment Date e Mandatory field e Format YYYYMMDD Example 20081231 e You can indicate future payment date here The transaction will be processed on the mentioned date 8 Testing File e Always select NO e No testing is allowed for Statutory Body payments COPYRIGHT 2009 Enterprise Banking Solution Maybank Page 10 of 16 mayeank net Online Enterprise Cash Management 9 Confidential e Yes detail in the file is not viewable by anyone except those who has confidential rights e No detail in the file is viewable
8. ed version COPYRIGHT 2009 Enterprise Banking Solution Maybank Page 2 of 16 mayeank net Online Enterprise Cash Management Security Feature You may set a security password to the HRPay File Generator However you must store the password safely as there is NO WAY to unlock the file TO PASSWORD PROTECT THE HRPAY FILE GENERATOR For Microsoft Office XP and Microsoft Office 2003 1 Onthe File menu click Save As 2 Onthe Tools menu click General Options 3 Do either or both of the following a Ifyou want users to enter a password before they can view the workbook type a password in the Password to open box and then click OK b If you want users to enter a password before they can save changes to the workbook type a password in the Password to modify box and then click OK When prompted retype the new password again and click OK 5 Click Save If prompted click YES to replace the existing workbook For Microsoft Office 2007 Qin Click on the Microsoft Office button point to Prepare and click Encrypt Document In the Password box type a password and click OK In the Reenter Password box type the same password again and click OK ee ie Save the file COPYRIGHT 2009 Enterprise Banking Solution Maybank Page 3 of 16 mayeank net Online Enterprise Cash Management TO REMOVE OR CHANGE THE PASSWORD For Microsoft Office XP and Microsoft Office 2003 1 Onthe File menu click Save As On the Too
9. elow 1 Click Generate IRB File 2 Please select the folder location to save the generated file in the new window You may rename the file name The file name cannot be duplicated Click OK COPYRIGHT 2009 Enterprise Banking Solution Maybank Page 14 of 16 mayeank net Online Enterprise Cash Management How to generate an ZAKAT File A FILE DETAILS 1 Client Code e Value will be given by the bank e Maximum length allowed is 10 characters inclusive of space 2 PIR Reference No e Mandatory field e File reference determined by you E g SALARY 31122009 e Maximum length allowed is 20 characters inclusive of space 3 Debit Account Number e Mandatory field e the company account number to pay from 4 Mode of Processing e Optional e Batch it will be processed by the batch processing windows e Realtime only allow maximum 10 salary payments to be made in 1 file e Novalue same as Batch 5 Debit Reference e Optional e Transaction Reference determined by you This value will be shown in your company s Account Statement e Maximum length allowed is 14 characters inclusive of space 6 Debit Description e Optional e Transaction Description determined by you This value will be shown in your company s Account Statement e Maximum length allowed is 40 characters inclusive of space 7 Payment Date e Mandatory field Format YYYYMMDD Example 20081231 e You can indicate future payment date here The transaction will be p
10. ling up the file details and Employee salary details follow the step below 1 Click Generate SALARY File 2 Please select the folder location to save the generated file in the new window You may rename the file name The file name cannot be duplicated 3 Click OK COPYRIGHT 2009 Enterprise Banking Solution Maybank Page 6 of 16 mayeank net Online Enterprise Cash Management How to generate an EPF File A FILE DETAILS 1 Client Code e Value will be given by the bank e Maximum length allowed is 10 characters inclusive of space 2 PIR Reference No e Mandatory field e File reference determined by you E g SALARY 31122009 e Maximum length allowed is 20 characters inclusive of space 3 Debit Account Number e Mandatory field e the company account number to pay from 4 Mode of Processing e Optional e Batch it will be processed by the batch processing windows e Realtime only allow maximum 10 salary payments to be made in 1 file e No value same as Batch 5 Debit Reference e Optional e Transaction Reference determined by you This value will be shown in your company s Account Statement e Maximum length allowed is 14 characters inclusive of space 6 Debit Description e Optional e Transaction Description determined by you This value will be shown in your company s Account Statement e Maximum length allowed is 40 characters inclusive of space 7 Payment Date e Mandatory field e Format YYYYMMDD Example 20081231
11. ls menu click General Options In the Password to open or Password to modify box clear the password Click OK and then click Save Click YES to replace the existing workbook Oe Pa For Microsoft Office 2007 Ca 1 Click on the Microsoft Office button i point to Prepare and click Encrypt Document 2 Inthe Password box double click the asterisk and then clear the password 3 Click OK and save the file COPYRIGHT 2009 Enterprise Banking Solution Maybank Page 4 of 16 mayeank net Online Enterprise Cash Management How to generate a SALARY File A FILE DETAILS 1 Client Code e Value will be given by the bank e Maximum length allowed is 10 characters inclusive of space 2 PIR Reference No e Mandatory field e File reference determined by you E g SALARY 31122009 e Maximum length allowed is 20 characters inclusive of space 3 Debit Account Number e Mandatory field e the company account number to pay from 4 Mode of Processing e Optional e Batch it will be processed by the batch processing windows e Realtime only allow maximum 10 salary payments to be made in 1 file e Novalue same as Batch 5 Debit Reference e Optional e Transaction Reference determined by you This value will be shown in your company s Account Statement e Maximum length allowed is 14 characters inclusive of space 6 Debit Description e Optional e Transaction Description determined by you This value will be shown in your company
12. ndatory field e the company account number to pay from 4 Mode of Processing e Optional e Batch it will be processed by the batch processing windows e Realtime only allow maximum 10 salary payments to be made in 1 file e Novalue same as Batch 5 Debit Reference e Optional e Transaction Reference determined by you This value will be shown in your company s Account Statement e Maximum length allowed is 14 characters inclusive of space 6 Debit Description e Optional e Transaction Description determined by you This value will be shown in your company s Account Statement e Maximum length allowed is 40 characters inclusive of space 7 Payment Date e Mandatory field e Format YYYYMMDD Example 20081231 e You can indicate future payment date here The transaction will be processed on the mentioned date 8 Testing File e Always select NO e No testing is allowed for Statutory Body payments COPYRIGHT 2009 Enterprise Banking Solution Maybank Page 12 of 16 mayeank net Online Enterprise Cash Management 9 Confidential e Yes detail in the file is not viewable by anyone except those who has confidential rights e No detail in the file is viewable by anyone who has access to SALARY e No value same as N B EMPLOYER DETAILS 1 Contribution Month and Year e Mandatory e Format MMYYYY e g 052009 for contribution May 2009 2 IRB Payment Region e Mandatory e The region which the company resides in 3 IRB Em
13. ory e The state which the company resides in C EMPLOYEE DETAILS 1 Staff Name e Mandatory e Maximum length allowed is 40 characters inclusive of space Staff New IC Old IC Passport Number e Mandatory at least 1 of the above must have a value e New IC format 801231018888 without dash N COPYRIGHT 2009 Enterprise Banking Solution Maybank Page 8 of 16 mayeank net Online Enterprise Cash Management 3 EPF Employee Reference No e Mandatory e Maximum length allowed is 8 characters inclusive of space 4 Employee s Initial e Optional 3 characters e This value is passed to EPF if there is any discrepancies 5 Employee Identifying Key e Optional 11 characters e This will be the reference passed to EPF if there is any discrepancies 6 Employee Amount e Mandatory e Format 00 00 7 Employer Amount e Mandatory e Format 00 00 8 Member s Wages e Mandatory e Format 00 00 e The employee s salary wages After completing filling up the file details employer details and employee details follow the step below 1 Click Generate EPF File 2 Please select the folder location to save the generated file in the new window You may rename the file name The file name cannot be duplicated Click OK COPYRIGHT 2009 Enterprise Banking Solution Maybank Page 9 of 16 mayeank net Online Enterprise Cash Management How to generate an SOCSO File A FILE DETAILS 1 Client Code e Value will b
14. ployer IT Group e Optional e Employer IT Group are the alphabets portion in the Employer Tax Ref No e E g E12345678 09 0 E is the Employer IT Group 4 IRB Employer Ref No e Mandatory e ignore the alphabets and dash e E g E 12345678 09 0 1234567809 is the Employer Tax Ref No O EMPLOYEE DETAILS Staff Name e Mandatory m e Maximum length allowed is 40characters inclusive of space 2 Staff New IC Old IC Passport Number e Mandatory at least 1 of the above must have a value e New IC format 801231018888 without dash 3 SOCSO Employee Reference No e Optional 4 Employee IT Group e Optional e Employee IT Group are the alphabets portion in the Employee Tax Ref No e Eg G1234567809 SG is the Employee IT Group 5 Employee Tax Reference No e Mandatory e ignore the alphabet and dash COPYRIGHT 2009 Enterprise Banking Solution Maybank Page 13 of 16 mayeank net Online Enterprise Cash Management e E g E 1234567809 1234567809 is the Employee Tax Ref No 6 Wife Code e Optional e As given by LHDN 7 PCB Amount e Mandatory e PCB is the same as CP39 Format 00 00 e If no amount please key in 0 8 CP38 Amount e Mandatory e CP38 is the amount instructed by LHDN to employer to perform tax deduction for employee Format 00 00 e If no amount please key in 0 After completing filling up the file details employer details and employee details follow the step b
15. rocessed on the mentioned date 8 Testing File e Always select NO e No testing is allowed for Statutory Body payments COPYRIGHT 2009 Enterprise Banking Solution Maybank Page 15 of 16 mayeank net Online Enterprise Cash Management B EMPLOYER DETAILS 1 Contribution Month and Year e Mandatory e Format MMYYYY e g 052009 for contribution May 2009 2 Zakat Employer Reference Number e Mandatory e Maximum length allowed is 10 characters inclusive of space 2 Zakat Payment Region e Mandatory e The region of which the employer resides in 4 Zakat Employer Name e Mandatory e Employer name registered with Zakat e Maximum length allowed is 100 characters inclusive of space C EMPLOYEE DETAILS 1 Staff Name e Mandatory e Maximum length allowed is 40 characters inclusive of space 2 Staff New IC Old IC Passport Number e Mandatory at least 1 of the above must have a value e New IC format 801231018888 without dash 3 Employee Amount e Mandatory e Format 00 00 4 Zakat Classification e Mandatory e Choose the zakat classification HARTA or PENDAPATAN After completing filling up the file details employer details and employee details follow the step below 1 Click Generate Zakat File 2 Please select the folder location to save the generated file in the new window You may rename the file name The file name cannot be duplicated Click OK COPYRIGHT 2009 Enterprise Banking Solution M
Download Pdf Manuals
Related Search