Skip to content
← For small businesses

Enter your idea

For small businesses: Accounting features

Categories

(thinking…)

Reconciliation - Bulk 'OK' for reconciling bank transactions

Ability to select multiple/all transactions during reconciliation.

Purpose: To save users time from having to reconcile the transactions one by one.

238 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

AdminXero Team (Admin, Xero) 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
submitted  ·  AdminKelly Munro (Community Manager, Xero) responded  · 

Thanks for all sharing and supporting how bulk reconciling transactions and suggestions that have been matched to statement lines in your bank would help your business.

It's great to see the trust you've built in Xero's capabilities to match and help you save time from manually finding and creating transactions to reconcile your bank.

Along with building on the foundations of our platforms, the teams efforts at present have been on improving the ability to create suggested transactions for more statement lines in your org - With a lot of this being backend logics there's not a heap you'll see from the front side of things but Xero's reconcile engine is getting stronger and overtime you should find even less need to create transactions in your org, yourself.

With this work underway there is no development for being able to reconcile transactions that have the 'OK' presented option atm, but we keep this top of mind as we continue to make Xero reconciliation even more powerful.

For now, cash coding in Xero can help save time with bulk reconciliations where you'll find Xero's suggested create transactions, and any bank rules you've set up are also presented - Find out more on how this works on Xero Central 

Show previous admin responses (1)

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Rachid Wehbi commented  ·   ·  Report

    You CAN actually do it with cash coding, but you need to turn that feature on in your account.

    https://www.meruaccounting.com/blog/xero-use-cash-coding/

    then you can see all the matching items that have been identified through bank rules and select them all and 1-click reconcile all of them.

    It works, but you still need to manually shift-click all matching transactions which is clunky.

    Still not as elegant or functional as if you had ONE button that says [Reconcile Bank Rule Transactions] and you're don.

    For those that are afraid that it might "mess things up" to auto reconcile in bulk... Well... just make sure your rules are right and tight :)

    Thank you for Aileen for suggesting Cash Coding.

  • Nikki Velinsky commented  ·   ·  Report

    It would really save time, especially for those accounts which don't have a bank feed, to be able to multi select several transactions in the account transaction tab and reconcile. We can already multi select to remove and redo, surely we could have a reconcile option too?

  • Annette White commented  ·   ·  Report

    I think this would be a great improvement but maybe it should be an 'advisor only' feature to avoid a big mess.

  • Tak Wun Wong commented  ·   ·  Report

    I also have to click the OK buttons thousand times. This would be such a time saver.

  • Pamela Lambie commented  ·   ·  Report

    Find & match for bank receipts - there is a tick box for 'select all on this page' ie. 50 - can another box be added for 'select all' (ideally providing the number of invoices in brackets eg 632) - this would allow users to search for a particular customer / reference (of which there may be hundreds / thousands of transactions) & reconcile with one tick

  • Pamela Lambie commented  ·   ·  Report

    Find & match for receipts - there is a tick box for 'select all on this page' ie. 50 - can another box be added to 'select all' (noting the number in brackets eg 632) - this would allow users to search for a particular customer / reference (of which there may be hundreds / thousands of transactions with one tick )

  • Russell Martin commented  ·   ·  Report

    This would save so much time. We have to click "OK" on literally thousands of transactions each month.

    Please build this!

  • Susan Lucas commented  ·   ·  Report

    When setting up a bank rule it would be great to have the option to toggle a setting for "automatic reconciliation" of anything that meets the bank rule criteria. Having to click OK through hundreds of similar transactions per day (e.g., online sales) is not efficient. Quickbooks Online has this feature and it is most helpful. Thank you!

  • Paula Baldwin commented  ·   ·  Report

    Each month, suppliers, who have 20+ transactions, are paid. To have the ability to enter a date range of invoices paid, for Xero to then select just the transactions in this date range, would make reconciling one payment to a supplier so quick when reconciling - I'm not sure why it hasn't been thought of before.

    Please Xero, add "select date range" filter to the Find & Match option - there's plenty of room in the "1. Find & select matching transactions" box, beside the "Search by name or reference" and "Search by amount" options.

  • [Deleted User] commented  ·   ·  Report

    Doesn't the use of the the shift button and choosing multiple transactions then use press reconcile do this in bulk? But if the user doesn't have access to the cash coding option they wont be able to do this.

  • Luke Trimble commented  ·   ·  Report

    This idea has been shared multiple times and needs to be put in place ASAP. We have been waiting years for it.

  • Samuel Knowlton commented  ·   ·  Report

    This is essential for integrating with a transaction source like Stripe where you might have thousands of transactions coming in. Clicking 'OK' for each one is not practical.

1 3 Next →