Employee bank details not exporting to excel - Accounts Premier 2014
Options
[Deleted User]
Posts: 0 ✭
I am trying to export employee bank details (and address, TFN, etc..) to excel.
I tried to get this info by running an Employee Contact List report and then modifying the headings, but bank details (bsb, acc name, acc number) were all blank. I found I could get the information I need by running a Statement of Payments report, and again modifying the headings. Now just to export to excel, right...?
When I export to excel (either as a new excel sheet or as .csv file) the basic employee info comes over (name, address, tfn, etc), but all columns for bank info (bsb, acc name, acc number) are blank.
Very annoying. Is there some sort of employee data protection I need to change or something..? Can anyone help...??
Over to you team...!!
I tried to get this info by running an Employee Contact List report and then modifying the headings, but bank details (bsb, acc name, acc number) were all blank. I found I could get the information I need by running a Statement of Payments report, and again modifying the headings. Now just to export to excel, right...?
When I export to excel (either as a new excel sheet or as .csv file) the basic employee info comes over (name, address, tfn, etc), but all columns for bank info (bsb, acc name, acc number) are blank.
Very annoying. Is there some sort of employee data protection I need to change or something..? Can anyone help...??
Over to you team...!!
0
Comments
-
Hi James,
Unfortunately (to my knowledge) we have never been able to get the list of employee bank details in a report!
The only way some of my clients have done it is via previewing the ABA file when creating the ABA file for upload to the bank.
Kind regards,
Sally McIntosh (sally@samsolutions.com.au)
2 -
Hello, James, we have a cloud based Payment solution where we have ,aba files created , and we are able to extract this information in report form to view which can be exported to excel , pdf .
SO, the concept is same, getting bank info from .aba file. we need to discuss further with you.
contact us , if you are interested.
Cosmic Accounting Group
Accountants and Tax Agents 22397009
0 -
Hi James,
This is purposely built into the software under Privacy & Confidentiality legislation - as Sally says, previewing the ABA file will provide the details.
If you are doing the exercise for importing to your banking software, you should look at Exporting ABA files from Reckon Accounts - much quicker and no re-keying required, much less room for data entry errors.
cheers,
Kelly Day1 -
Thanks very much for your responses. Yes the only way could find to get the info out was from creating an ABA file (with fake payroll data) and then could copy and paste from there to excel.
Must be a privacy setting on Reckon designed to protect bank details I guess...?
Thanks everyone for the input..
1
Categories
- All Categories
- 6.4K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 5.9K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.3K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 2.9K Reckon One
- 7 📢 Reckon One - Announcements
- 10 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 307 Point of Sale
- 1.9K Personal Plus and Home & Business
- 62 About Reckon Community