nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Employee bank details not exporting to excel - Accounts Premier 2014

[Deleted User]

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...!!

Comments

Sally McIntosh, Accredited Consultant

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)

cosmic

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.

Kelly Day

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 Day

[Deleted User]

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..