This article will show you how to generate a bank file. The bank file is a file to which you will provide your company's bank the instruction to transfer salary from your company's bank account to the staff.
The steps are:
Step 1: Click on .
Step 2: Click on .
Step 3: You should see this page. Click on the
button as indicated below.
Step 4: Enter all the relevant information. Note that different banks would require different information. If unsure, kindly check with your company's bank.
*Note that each bank requirement of information might differ.
- Originating Bank → Indicate which bank your company is using.
- Bank Submission Format → Select the correct bank file format. Wrong format will result in failure. Check with bank if unsure.
- Originating Account Number→ Your company’s bank number.
- [Generate Branch Code] → Click here after you have entered the bank account number. Must see Branch Code and Branch name.
- Originating Account Name → Company’s account name in the bank.
- Effective Transfer Date → Enter Value date.
- Message Sequence/Batch No. → Batch No. This is only meant for this bank.
- DBS IDEAL Login ID → This is only meant for this bank.
- Month → Indicate the month you are generating this bank file.
- Generate By → Select whether you are generating by pay period or payrun date.
- Pay Period → Select the pay period for this Bank file
- Employees Selected → You can filter the employees included in this bank file.
Step 5: (Optional) If you wish to check all the amount and the staff's bank information, click on . The system will display the staff names, their bank accounts and the amount that will be transferred to them.
Step 6: Click on to generate the bank file.
A confirmation message will appear at the upper right corner of the screen..
Step 7: Once completed, you should see something like this
Step 8: Click on to download the file. NOTE: Please do not rename the file you have downloaded. It is also recommended that the downloaded file is not opened so as to avoid it from being accidentally modified.
Step 9: Login to your bank portal and upload this file to the bank.
📌 Important Reminder:
Please do not open or edit the downloaded bank file (Excel/CSV or TXT format) before uploading it to your bank. Opening the file may cause automatic reformatting of certain fields, which could unintentionally alter account numbers, payment references, or other critical details.