Contents of this article are applicable to the following users
Tier: Growth, Scale
Product: PayrollAny
Platform: Web
Access Level: Owner
Generate an HSBC Malaysia bank file directly from a finalised Malaysia payroll. StaffAny prepares the required file format and transfers your payment details so you can upload the file to HSBC for salary disbursement.
This guide will cover how to:
Before you start
Set your Business Entity bank to HSBC Bank. Go to Payroll > Settings > Business Entities and confirm the bank is set to HSBC Bank.
Configure the required HSBC fields on your Business Entity. Go to Payroll > Settings > Business Entities, open your entity, and fill in these fields:
HSBC Connect Customer ID — required. Your HSBC Connect customer identifier.
HSBCnet Customer ID — required. Your HSBCnet customer identifier.
Payment Set Code — required. A 3-character alphanumeric code (e.g. C01). Defaults to C01. Enter in uppercase or StaffAny will capitalise it automatically. If you need to use a different payment set code, update this field before downloading the bank file.
Make sure included staff have a valid bank account number and account holder name. StaffAny excludes payment rows with an amount of zero or less.
Make sure the payroll has been finalized. Click the green button on payroll list to finalize the payroll.
Also make sure that once your payroll has been finalized, the payment has also been created for this payroll. Go to Payroll > Payments, and navigate to the payroll month. Check if the payment has been created.
Generate the HSBC bank file
Go to Payroll > Payments.
Find the payment for the payroll you want to process.
Click Download Bank Files.
In the modal, select the Value Date for the bank file. You can select today, a past date, or a future date. Weekend dates are not available.
Click Download Bank Files to generate and save the file.
A .zip file is downloaded to your device. Inside the zip, the HSBC bank file is a .csv file. The file uses UTF-8 encoding with Windows CRLF line endings, which is required by HSBC for successful upload.
FAQ
Why can I not generate the HSBC bank file?
The most common reasons are: the payroll has not been finalised, the Business Entity bank is not set to HSBC Bank, or one of the required HSBC fields (HSBC Connect Customer ID, HSBCnet Customer ID, or Payment Set Code) is blank. Check all three in Payroll > Settings > Business Entities.
What is the Payment Set Code and what should I enter?
The Payment Set Code is a 3-character alphanumeric code that identifies the payment type in the HSBC file format. The default value is C01. If your HSBC account requires a different code (e.g. C10), update the Payment Set Code field on your Business Entity before downloading the bank file. The code is stored in uppercase.
Why are some staff members missing from the bank file?
Staff with a payment amount of zero or less are excluded from the bank file.
I updated the Payment Set Code. Do I need to re-download the bank file?
Yes. The bank file always fetches the Payment Set Code from the current Business Entity settings at the time of download. If you change the code, re-download the bank file from the Payments page.