Skip to content
← For small businesses

Enter your idea

For small businesses: Accounting features

Categories

(thinking…)

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.

123 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Natascha Natke shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
delivered  ·  AdminEthan M (Admin, Xero) responded  · 

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 😊

Show previous admin responses (2)
Comments are closed An error occurred while saving the comment
  • Tracy Woodfield commented  ·   ·  Report

    What feedback was given that necessitated the change the Bank reconciliation report in the first place?

  • Laurinda Sanders commented  ·   ·  Report

    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.

  • Nellie Shaw commented  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    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 :)

  • Kerry Cameron commented  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    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

  • Jacalyn Fenech commented  ·   ·  Report

    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

  • Terry Smith commented  ·   ·  Report

    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.

  • Pamela Lambie commented  ·   ·  Report

    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  ·   ·  Report

    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  ·   ·  Report

    Would be so much easier and i'm sure wouldn't be too difficult to create?

  • Carol Conyers commented  ·   ·  Report

    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  ·   ·  Report

    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

← Previous 1