Exporting Supplier Bank Details

Big Hat

Hi

Is there a way of exporting Supplier Bank Details ie Account Name, BSB, Account Number from Reckon Hosted or Desktop?

Tanvi_kataria

Hi John @Big Hat

Yes, you can certainly have that exported from the software. In order to have that exported, you have to generate a report and modify that with the appropriate columns.

Please check this out -

• Create a Report - Transaction List by Supplier

• Modify Report

• Choose columns - Account, BSB (Branch Code), Account Number, Account Name etc. and it will generate a report as attached -

I hope this helps. Please reach out if you have any query. Thank you!

Regards

Tanvi

Reeta

Hi @Big Hat ,

There is another way as well , if you have paid the supplier using the online banking feature, you can still retrieve the details by following these steps:

1. Go to -Reports
2. Select -Banking
3. Then choose -Bank (Online) Report

Additionally, you can modify " Transaction detail report" as mentioned by Tanvi above.

I hope this answer your query.

Kind regards,
Reeta

Big Hat

thank you

But it looks like the fields only relate to payroll

Big Hat

thank you

The client has not been using online banking

Reeta

Hi @Big Hat ,

My apologies, as for the screenshot above , I’ve only made online payments for wages, which is why it’s displaying that way. I also tested creating an online payment for another supplier, and it successfully populated the banking details.

Unfortunately, if the client isn’t using the online banking feature, they’ll need to follow the steps provided by Tanvi.

Hope this helps.

Regards,

Reeta

Big Hat

Thank you

The steps by Tanvi dont seem to work either as I think the fields relate to Payroll and possibly Online Payments the same as your suggestion

Acctd4

@Big Hat Unfortunately, Reckon removed the ability to report bank details in list format many years ago, once they developed the online banking feature 😩

Now, you can only display the bank detail column data - for actual ABA files created - in the Bank (Online) Report 😔 & it can also only be saved to PDF, but not printed (or vice versa, can’t remember which one! 🤦🏻‍♀️)

It’s frustrating as this was useful data to have/check. I’m assuming Reckon felt it was more “secure” to remove it, which is crazy as Suppliers display this detail on invoices & unauthorised access requires more than Name, BSB & Acct No anyway! 🙄🤨