Mark salaries paid and export the bank file
You will have an Excel file of the month’s net salaries with each employee’s bank details for your bank’s bulk transfer, and every row marked paid once the transfer is done.
Payroll › Salary payments is the payment register. It lists every approved row for the month with the employee’s Bank, Account, bank code (shown as IFSC), IBAN, Status and Net. Export it to Excel to prepare the bank’s bulk upload, then mark the rows paid when the money has gone.
The bank details are read from Bank Info on each employee record, so a blank cell here is fixed there, not on this screen.
Before You Start
- The month is approved on Payroll › Payroll; only approved rows appear here.
- Every employee being paid by transfer has Bank Name, Branch Name, Account No and IBAN Code filled under Bank Info on their record; the bank code is the local routing code for your country (IFSC in India, sort code, routing number, BSB).
- The salary bank account exists under Books › Bank & Cash.
Steps
- Open Payroll › Salary payments and choose the month.
- Scan the Bank, Account, IFSC and IBAN columns for blanks. Fix any gap on the employee record under Bank Info, then reload.
- Click Excel export. The file has one row per employee with the bank fields and Net.
- Rearrange the columns to your bank’s bulk-transfer template and upload it in your bank portal. Banks differ; keep a saved mapping from this export to your bank’s format.
- Pay cash salaries from the cash account and keep the signed receipt.
- Once the bank confirms the transfer, return to Salary payments and mark paid on each row, or on all of them together. Pick the bank or cash account the money left and the payment date.
- Check Status reads paid for every row and the month is closed.
Columns on Salary payments
Column | Meaning | Comes from |
|---|---|---|
Employee | The person being paid | Employee record |
Bank | Bank Name | Bank Info |
Account | Account No | Bank Info |
IFSC | The bank code for routing; the label follows the Indian term but holds whatever code your bank needs | Bank Info |
IBAN | IBAN Code where your country uses one | Bank Info |
Status | Waiting or paid | This screen |
Net | The approved amount for the month | Payroll run |
mark paid | Records the payment | This screen |
Excel export | Downloads the register | This screen |
What This Changes
- Marking paid lowers the bank or cash account you chose; the entry appears in the Bank Book or Cash Book and the Day Book.
- The employee’s Current Balance no longer shows the salary as owed; the Single Employee Statement shows the payment line.
- The dashboard’s Bank Accounts and Cash In Hand tiles fall by the total paid.
- The exported Excel file is a copy; exporting changes nothing in the app.
Tips
- Export once, upload once. If a transfer fails for one employee, fix the account details and pay that person singly; do not re-export and re-upload the whole file.
- Pay cash salaries the same day and mark them paid at once; a gap between the two is where cash-box differences come from.
- Keep the bank’s confirmation file with the month; attach it to a Journal Voucher or an Expense if your accountant wants it inside the books.
Frequently asked questions
Need Help?
Chat with the NShine ERP support team on WhatsApp at +91 79950 87755, or ask from inside the app. Last checked 9 November 2026 against app.nshineerp.com.
