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; } } }

Can I print a supplier listing which includes bank account numbers so that we have master supplier d

Sandra_6859676

Supplier Bank Accounts

Comments

John G

Hi Sandra,

Welcome to the Reckon community.

You will only be able to see details on a supplier's bank account if you have paid them with Bank Online, as showing bank details is an Online Banking function - Report > Banking > Bank (Online) Report.

A Custom Transaction Detail Report can also be modified to show bank account details.

An alternative is to export your customer list to an IIF file and modify that file to show you the required supplier details.

Hope one of these methods provides the results you are after.

regards,
John

Hamilton Christian-School

Hello John

Our auditors (Deloitte) have again this year asked if we can create an exception report that will identify any NEW or CHANGED supplier bank account details - preferably an automated report that could be sent to a line manager on a periodic basis (eg weekly) or when a 'Bank Online' payments batch is generated (especially if it included payments to any of the new/changed accounts).

Regards

Gavin

John G

Hi Gavin,

Welcome to the Reckon Community.

The functionality you seek is beyond the scope of Accounts Business.

The best you can do in this respect is to export the Supplier List to an IIF file, modify it in Excel for the information required and keep it. Create new export files as needed and compare to the previous report.

regards,
John

Hamilton Christian-School

Thanks, John

I'm doing something similar now, but both systems (yours and mine) are reliant on manual processes and data that could be easily manipulated or omitted before being given to a line manager.

Perhaps the need for a more robust automated report could be noted as a future enhancement. I note this is now standard for our (IMS) payroll system and suggest that is because of audit requirement.

Regards

Gavin

John G

Thanks Gavin,

Accounts Business does have an Audit Trail for transactions that lists all changes from the date of creation, but that does not cover other information.

I'll send the idea up to our product management for consideration.

Thanks for your input.

cheers,
John

Sandra_6859676

Hi John

That would be great if you could bring it up with your project management for across the QB range and not necessarily just for the online banking process. Our auditor has marked this as HIGH RISK because we don't check an exception report of bank account number changes. There is little we can do when Reckon doesn't have the facility to do it (other than creating a manual time consuming process of going through the long list from the IIF file on a periodic basis - it isn't in a very easily readable format either). We do put all bank account numbers in the Supplier details.

Thanks for this.

Sandra

Hamilton Christian-School

Sandra, I'm flat out this week but would love to touch base sometime; if you are interested please email me gavin.baxter@hcswaikato.school.nz.