Contents of this article are applicable to the following users
Tier: NA
Product: PayrollAny
Platform: Web
Access Level: Owner
StaffAny PayrollAny supports generating an Affin Bank file directly from your payrun or payment, allowing you to upload the file to Affin Bank for salary disbursement via IBG (Interbank GIRO).
This guide will cover how to:
Prerequisites
Before generating the Affin Bank file, ensure the following are set up:
Organisation bank account — The Business Entity must have Affin Bank Berhad set as its bank, with a valid bank account number configured.
Employee bank accounts — Each employee to be paid must have their bank account number and account holder name added in StaffAny.
Malaysia Identification Information — Each employee must have their citizenship status (Malaysian Citizen, Permanent Resident, or Non-Resident) set in their employee profile. This populates the Resident Indicator field in the bank file.
Generate the Affin Bank File
From the Payment
You can also generate the Affin Bank file from the Payments page when using the combined payment flow.
Go to Payroll > Payments and open the payment you want to process.
Click Download Bank File, and set the value date.
The file will be downloaded to your device.
File Format
The Affin Bank file is exported in .xlsx format and contains the following columns:
Column | Description |
Record Type | 01 for detail rows; 99 for the trailer (summary) row |
Payment Mode | IBG |
Payroll Date | Value date in DDMMYYYY format |
Customer Ref | Employee ID |
Payroll Amount | Net take-home pay, to 2 decimal places |
Debiting AccNo | Organisation's Affin Bank account number |
Staff's Bank Code | Employee's bank SWIFT code |
Staff Acc No | Employee's bank account number |
Staff Name | Employee's account holder name |
ID Checking Required | N (fixed value) |
Resident Indicator | Y for Malaysian Citizens and Permanent Residents; N for Non-Residents |
Employees with a net take-home pay of zero or less are automatically excluded from the file.
FAQ
Why is an employee missing from the Affin Bank file?
An employee is excluded if their net take-home pay is zero or below, or if their bank account details are not set up in StaffAny. Ensure the employee's bank account number, account holder name, and citizenship status are completed before generating the file.
Why does the Resident Indicator show N for an employee?
The Resident Indicator is set to N for employees who are not Malaysian Citizens or Permanent Residents. To update this, go to the employee's profile and update their citizenship status under Malaysia Identification Information.
What file format does the Affin Bank file use?
The Affin Bank file is exported as an .xlsx (Microsoft Excel) file, ready for upload to Affin Bank's internet banking portal.
Does the Affin Bank file support combined payments across multiple employees?
Yes. When generating the file from Payroll > Payments, the file includes all eligible employees in the combined payment batch.
Related Articles