Contents of this article apply to the following users
Tier: N/A
Product: Payroll
Platform: Web
Access Level: Owner
Generate an Alliance Bank Malaysia Berhad payment workbook directly from a finalised Malaysia payroll. StaffAny prepares the required payment columns and default values so you can review the workbook before submitting it to the bank.
This guide will cover how to:
Before you start
Finalise the payroll first. Bank files cannot be generated for a payroll that is not finalised.
Confirm the Business Entity bank is Alliance Bank Malaysia Berhad. Go to Settings > Business Entity and configure your entity bank.
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.
Generate the Alliance Bank file
Go to Payroll > Payroll List.
Open the relevant finalised payroll. If your payroll has not been finalised yet, you can do so by clicking on the finalise payroll button on the action column.
Go to payment, and create payment for the payroll you have finalized.
From the Payments page, you can download the bank file by clicking Download Bank Files from the Actions column.
The downloaded Excel workbook uses the filename pattern AllianceBank_{BusinessEntityName}[_{paymentIdentifier}].xlsx and contains a worksheet named Sheet1.
Review the generated workbook
The workbook includes these columns in order:
Payment Mode: LIC
Beneficiary Name: the staff member's account holder name
Beneficiary Account / DuitNow ID Number: the staff member's account number
Beneficiary Bank Code / DuitNow ID Type: the bank code without a trailing XXX
Amount: formatted to two decimal places
Payment Description: SALARY {MONTH}{YY}, for example SALARY FEB26
Payment Reference, Beneficiary New IC No, Beneficiary Old IC No, Beneficiary Business Registration, and Beneficiary Address: blank
Beneficiary Others: CASA
Review the workbook and follow Alliance Bank's submission process. StaffAny creates the file; bank portal upload and approval steps are outside StaffAny.
FAQ
Why can I not generate the file?
The payroll may not be finalised, may be an imported/manual payrun, or may not have the required bank and staff bank details.
Why are some staff members missing?
Rows with a payment amount of zero or less are excluded from the Alliance Bank workbook.
Can I use this for more than one payroll?
Yes. StaffAny supports combined and uncombined payroll bank-file flows. The downloaded filename may include a payment identifier when one is available.