Supplier bank account list report needed

sandrah
sandrah Member Posts: 42 Reckoner Reckoner

I need to print off a supplier bank account list to compare it with information in our bank account. How can this be done?

Comments

  • Acctd4
    Acctd4 Accredited Partner Posts: 4,216 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    It used to be possible to add these columns to a Supplier List report but unfortunately - since the introduction of bank feeds - the only way to generate this info is - after making ABA payments - using the Bank (Online) Report 😥

    It's not ideal but the only workaround at this stage is to create Custom Fields & enter the bank details there too as these can be displayed:

    image.png


  • Alexis McKeown
    Alexis McKeown Reckon Staff Posts: 596 Reckon Staff Reckon Staff

    Hello @sandrah,

    Unfortunately, there is no direct way of doing this as the banking information on suppliers is considered a "Sensitive Information" field in Reckon Accounts, preventing it from being printed on reports (even Custom Reports).

    There is a small workaround that you could do. You can go into the "Additional Info" for your Supplier, go into the Custom Fields, and select "Define Fields".

    You can then define a Custom Field as "Banking Information", ticking off the "Supplier" field. You can then add in banking information into this new field.

    Once you do that, you can then run a "Supplier Contact List" (found under Reports -> Suppliers & Payables -> Supplier Contact List). If you modify the report, you can then select this "Banking Information" field in the Columns, which will generate this information.

    Kind regards,

    Alexander McKeown

    Reckon Senior Technical Support

    Alexis McKeown

    Reckon Senior Technical Support
    Working hard since 2018
  • Acctd4
    Acctd4 Accredited Partner Posts: 4,216 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited September 2023

    @Alexander McKeown It always baffles me that this info is considered “sensitive” as it’s disclosed on supplier’s invoices & no-one can access the supplier’s bank account from it - one would need their login details for that! 🤔😬

    The Bank Details columns used usedto be reportable many years ago 😩