Bank Account Changes Report Showing Contact's Name - Downloadable as a PDF
Would like a report showing a list of bank account number changes. This would show original bank account number, new bank account number, contact's name, date the bank account number was amended and who amended the bank account number and to be able to print this as a pdf. This would be of great benefit because of fraud and also our Auditor has asked if we can produce a list of bank account number changes for a selected period.
Hi everyone, while we don't have a direct report for this, some changes we've made to History & Notes in Xero will help in achieving what you're in need of here.
You can run the History & Notes, filtering by Type = Contact and typing 'Bank account number' in the Search to just view results for this action.
If needed you'll be able to export your results to PDF or Excel.
Though the contact name doesn't show on screen, you can right click on the Contact in the report to open the contact's record in a new browser tab, that allows you to inspect details without navigating away from your History & Notes results.
-
Ruth Grealy
commented
I've had auditors with me this week requesting that I supply a report from Xero outlining any/all changes to bank account details of suppliers and contacts. Being unable to comply isn't the best feeling. I am hoping that Xero will develop the capability to provide an audit report in the near future.
-
Reece Jory
commented
Note you can achieve this somewhat using the History and Notes Report (under Advanced menu in accounting). Filter on Contact as the item and then search Bank Account. While it doesn’t show the contact name it does have a hyperlink to the contact that was changed. A reasonable solution until such information is available in a proper report format.
-
Carla Strachan
commented
This is part of good business and reduces risk of fraud. It would be amazing to have such a report.
Thanks
-
Peter van Hout
commented
It is essential that a business owner checks and approves changes to bank account numbers when these are made for any existing or new contacts to avoid fraud being completed by someone.
-
Anna Rutherfurd
commented
This would be very helpful report to help protect fraud risks for clients, and very much supported by auditors to have available.
-
Maxine Bird
commented
For schools that are audited this is critical to ensuring that the bank account changing is transparent and clearly able to be audited.
-
Emma Rosenblatt (Accounts)
commented
This would be an excellent feature.
-
Jill Gatcum
commented
Would be very helpful to show the auditors
-
Coy's Constructions
commented
Yes! Absolutely critical. It's one of the most common aspects of fraud - changing bank details. We need to be able to track this.
-
Sheryl McGregor
commented
Yes this would be a great inprovement for audit and compliance
-
Cheryl Weijermars
commented
Auditors are asking for this
-
Kelly Prevost
commented
It is critical internal control to have this information available. It is great to have the notification emails when employee bank details are changed. Why at least can't we have the same for Suppliers? It would be so easy for an accounts administrator to change the bank details of a supplier to their own account. My clients are crying out for this notification. If we could produce an audit report with all bank account changes detailing who made the changes this would be fantastic.
-
Anne Reid
commented
Great audit trail.
-
Carol Stephenson
commented
Its a great audit trail. Quick Reference.
-
Elvis Pronoso
commented
This would make the existing report more sense
-
Kelli Tevaga
commented
Required for audit trail.
-
Pip Palmer
commented
Would be great for internal controls and for the auditors to be able to test some of the changes
-
Andrea Buxton
commented
Quite an important report and required for audit. The work around to get this information is not ideal.
-
Sandy Dunn
commented
We are the financial service provider for 328 NZ schools and this report would be of great assistance during the year for internal control systems and also at audit time. Maree's request is fully supported by us.
-
Ian McMillan
commented
Requirement for auditor, so very crucial