Having trouble creating ABA files

Rosie
Member Posts: 121 Reckoner

I am trying to create ABA files for payroll and creditors payments and am coming across two problems.
The first is that when I go into Online Banking to create my ABA file I have ticked all payroll transactions for the pay period but when I preview the ABA file only nine out of the eighty or so pays are showing. I have had a look in the employee setup but cant find anything common that would be causing this.
The other issue is that when I import the ABA file to NAB online it comes up saying it needs to be repaired and when I look at the payment file it has not selected a bank account for the payment to come out of and I need to do it manually. It also has no payment description even though I typed it on the Online banking page.
Any help would be really appreciatted as I can't find any information to help with this online.
I have set the bank account up for online banking including the APCA number, branch code and account number and have tried ticking and not ticking include branch record.
Thanks in advance, Rosie
The first is that when I go into Online Banking to create my ABA file I have ticked all payroll transactions for the pay period but when I preview the ABA file only nine out of the eighty or so pays are showing. I have had a look in the employee setup but cant find anything common that would be causing this.
The other issue is that when I import the ABA file to NAB online it comes up saying it needs to be repaired and when I look at the payment file it has not selected a bank account for the payment to come out of and I need to do it manually. It also has no payment description even though I typed it on the Online banking page.
Any help would be really appreciatted as I can't find any information to help with this online.
I have set the bank account up for online banking including the APCA number, branch code and account number and have tried ticking and not ticking include branch record.
Thanks in advance, Rosie
0
Comments
-
It appears they are importing into Reckon correctly now after some fiddling and trial and error but still unsure why so many payroll entries are being excluded from the ABA file.
Any help would be great, Thanks.0 -
Hi Rosie,
Here are some things to watch out for: Make sure all the employees have their Pay Method set to Bank Online. Also with suppliers make sure the bill payments and cheques have the Payment Method set to Bank Online. If you have more than one account in the chart of accounts with the same account number and BSB make sure one of those accounts has a - in the BSB, for example the BSB 111222 would be entered like that in the first account and in the second account as 111-222. This way they dont conflict.
Maybe it would be helpful to setup a dummy online account, create some dummy cheques with the Online Banking payment method, and see if you can get the ABA preview to work correctly with this dummy account. If that works, check if you did anything different with the other account.
If you are still having difficulties maybe creating a new account and merging the existing account into the new account might help.
Is the Online Banking working for you now or are you still having difficulties?
Regards,
Shane.0 -
Hi Shane, Thanks for your reply. Unfortunately we have six bank accounts that are set up for online banking and all with the same BSB.
It does seem to be working ok now. I uploaded a dummy creditors payment and payroll payment from each account and it worked. The only problem I seem to be having now is that not all employees are showing in the ABA file. I ran a payroll summary report and the ones that showed are the only ones showing online banking details on this report so it must be something to do with their bank details although I'm not sure why.
I will keep playing around with it today and hopefully get it working.
Thanks, Rosie0
This discussion has been closed.