Assurance Dashboard - Add Reporting Functionality
The assurance dashboard has been around for a while and it's great to have a number of checks accessible in the same place. However, there doesn't appear to have been much development in this area i.e. we are still not able to export out reports from the Assurance Dashboard.
A client reached out today looking for an easy to run report showing bank account number changes. This is an important item to check on for businesses, particularly entities that have bank accounts loaded into Xero by multiple people, use batch payments etc. Accessing this information through the assurance dashboard is clunky, it shows that bank account numbers have been edited but takes a few clicks to get into the detail as to what was edited. I suggested the client use the 'history and notes' functionality, selecting contact as the item and searching for the keywords 'bank account number changed'. This pulled the detail on the bank account numbers changed ie. bank acct 03-1750 changed to 06-9250 (screenshot attached) but doesn't show the contact name, so further clicks are required to obtain this detail.
Recommendations:
1. Create reports for the assurance dashboard, particularly a standalone 'bank accounts that have been changed' report
2. Both the Assurance Dashboard and the History and Notes Areas do not allow data to be exported, in either pdf or excel. It would be great if this functionality could be added, perhaps as an interim measure until reporting is able to be developed under these areas.
3. Further development in both the Assurance Dashboard and History and Notes areas, to make these easier to use and to pull detailed data, without having to click through layers of summary data
Thanks
Caitlin Ottley
shared this idea
Hi everyone, appreciate the feedback on my last question. I've slightly amended the title of this idea. As a bit of an update from when I last posted we have actually made an update in History & Notes as I know some of you were interested in - You can now Export to PDF or Excel from this screen and you'll find there are filter options to help you zone into the items you're most interested in looking at.
-
Tracy Mekler
commented
Either filters or the ability to export would be helpful. The list is just alphabetical by contact name. Accounts are changed all the time, so being able to sort by recent would save a lot of time.
-
Glenn Trotman
commented
Currently in Accounting - Advanced - History and Notes, we can see individual transaction changes. Would be good to be able to export all, so we can also see in 1 report.
-
jeff gillies
commented
In addition to the above, it would be good if your could sort the exceptions by date modified as I'm more interested in the exceptions in the period I am reviewing. Alternatively setting a date range to filter the data in the reports to only show data and exceptions in the period specified