Bank Reconciliation Report - Ability to run for multiple bank accounts at once
In the new format Bank Reconciliation report, can we please add a 'select' option for the bank account field, similar to the 'Account Transactions' report and how we can 'select' multiple CoA codes to look at at the same time?
I have a client that has 30+ bank accounts, and having to run the bank reconciliation report 30 times to check if they are reconciling/have errors is very painful.
Hey community, just following on from Kelly’s update a few weeks ago, you can now add multiple bank accounts to the Bank Reconciliation report 🎉
In the new Bank Reconciliation report pack, you can now click ‘Add report’ to add in a new Bank Rec Summary report for each of your accounts - removing the need to run the report again each time you change bank accounts.
Thanks again for all your feedback on this one 😊
Tracy Woodfield commented
What feedback was given that necessitated the change the Bank reconciliation report in the first place?
Laurinda Sanders commented
This would be great. I too am struggling with having to check 10+ bank accounts and running multiple reports is so time consuming.
Would be great if the Bank Summary report showed both the Xero bank balance and the Imported statement balance so at least we knew which accounts needed further investigation.
Edtech - Dana Taylor commented
Very important to have this functionality
Nellie Shaw commented
Yes totally agree. The new bank reconciliation reports are not an improvement and will take so much more time at month end to run and check.
Harry So commented
Like everyone, we have the same problem. Our 13 bank accounts are easily handled by the current Reconciliation Reports which automatically includes them as 13 separate pages without breaking a sweat. But upon its retirement by Xero on Jul 31, the new report can only be run for 1 account each time. I tried to modify that as a custom report by adding 12 more with each account pre-selected. Then I found out after updating the first and then moved to the second and updated again, both sheets show the results for the same account. How can this be an improvement? Is there a way to report all 13 accounts in one go? I have a similar problem with the new P&L report if I need to compare tracking categories. With 6 branches (category A) and 33 activities (category B), that means 198 reports instead of 1 report with the old version. With improvements like these, we can remove the word "disaster" from all dictionaries.
Kirsty Tapper commented
Not sure if this is any temporary help to anyone, but I run the "reconciliation reports" (and delete the other reports) - as you can publish all the the bank accounts at once :)
Jeanette Korporaal commented
I agree - this is very frustrating!
Kerry Cameron commented
Previous report is far more useful to bookkeepers. The new report tells us very little. Agree with others that the report only shows one bank account not multiple.
Don’t fix things that work perfectly without consultation with the people that use your product.
Libby Swanson commented
Yes please! Don’t see the point of the new report being able to add more reports but they can only report on the same bank. Was so excited when this came out that I would be able to create a report pack with monthly reporting requested by clients of pl, bs, and bank recs - what client only has one bank/CC account?
Dianna Davies commented
So annoying to have to now run multiple reports then combine to get one report to send out to clients and add to my work papers. Such a waste of my time. Not sure how a single report is an improvement
Charles Klvana commented
Just fix it, I mean seriously
Jacalyn Fenech commented
Agree with Terry - Fix the reports
Xero also needs to REMOVE the word Reconcile on the Bank Feed
It it FALSE it is only matched NOT RECONCILED
Naomi Chant commented
Terry Smith commented
We have hundreds of licencees at Pure Bookkeeping using the old Reconciliation Reports and the Bank Reconciliation [New Pack Report} should be able to replicate that report. This is what I was led to believe in a Demo done by Xero.
Julie Thornton commented
Yes, this needs to be a feature!
Pamela Lambie commented
The new bank reconciliation report can only be run for ONE account at a time. It would be good if there could be either:-
1. The option to add in Bank reconciliation summary report for EACH account as a separate page to then save as a custom report
2. A separate 'amount' column for each bank account (similar to a cost centre option) with say only a description as a 'blue link' which can be clicked on for further information
Anna Scott commented
Yes I agree this feature would be very handy, especially now we have to export each report to pdf rather than just publishing it in xero.
Rosalind Brenssell commented
Would be so much easier and i'm sure wouldn't be too difficult to create?
Carol Conyers commented
We have a number of bank accounts. You used to be able to run the report for all bank accounts together. Having to run them individually is not efficient!
Jenny Draper commented
This is a monumental Flaw in this report !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
It is imperitive thatwe can do this "new" reconciliation report for MULTIPLE BANK ACCOUNTS _ how is it a good idea that we do this 20, 30 or 40 sSEPERATE TIMES.
*************PLEASE DO NOT , repeat NOT remove the GOOD, EFFECTIVE "old" reports until this is corrected