The exact error that you receive will depend on the bank software or portal. You may encounter one of the following errors or a similar variation.
Invalid data record count.
The total amount doesn't balance to the sum of the transactions.
Total value of credit transactions is not equal to the value in the trailer record.
The number of transaction records does not equal the number of records specified in the trailer record.
Sum of all credit transactions in batch doesn't match credit total.
The number of records in the file doesn't match the count.
These errors can occur if an employee's Account Name is missing from the Employee's Bank Details. When the Account Name is missing the employee's bank transaction will be included in the EFT Audit Report but excluded from the file.
To find the missing record, review the EFT Audit Report looking for a record that has no Account Name. Take note of the Employee Code. Ensure you have a copy of the employee's transaction (e.g. Transaction Report) before proceeding with the steps below, as you will need to re-key the transaction.
To insert the Account Name:
Restore to the backup taken before the EFT file was generated.
Go to Payroll, Transactions, Processing, Extended Timesheet.
Enter the Employee.
Highlight the entry in Transaction Summary and click Delete Selected.
Next, go to Payroll, Maintenance, Employees, Employees.
Edit the Employee.
Select Bank Details and Edit the bank record.
Enter the Account Name, click OK.
Click OK to save the employee record.
Go back to Payroll, Transactions, Processing.
Open the transaction, e.g. Timesheet, Manual Calculation.
Enter the Employee and re-key the transaction.
Take a Backup, labelled Before EFT.
Go to Payroll, Transaction, Import and Export, EFT Export.
Enter the required parameters and click Preview to check the EFT Audit Report or EFT File to create the file. You will need to create the file when ready.
Upload the new ABA file in your Bank Software.