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.
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
-
James Masters commented
Absolutely vital. Unbelievable that Xero does not allow autoreconciliation of statements against invoices where the reference is an identical match. Such a basic and obvious requirement. We have not yet looked around to see if any other accounting package will do this but if we find a competitor that will do it, we will move to them.
-
natalie newsome commented
Could we have a keyboard shortcut for "OK" in reconciliation please. Just that alone would be very helpful.
-
Adii Pienaar commented
I've got a prototype of a Xero-connected tool that leverages AI to handle reconciliation in bulk and real-time. Happy to share what we've built. Ping me: adii[at]pienaar.io
(By way of introduction... I'm co-founder of WooCommerce, and a Xero user for the last 10 years where I was bookkeeper/CFO for the companies I founded after Woo.)
-
Natalie Ford commented
Hi Kelly @ Xero, as per my comment on a duplicate idea for this, many of us are paying someone thousands to simply click OK all day. Improving the suggested matches is nice but it also creates more OKs to click! Please implement this bulk OK feature urgently. It is so needed and you seem to have overlooked the immense value of this relatively simply implementation.
-
Optimus Fintech commented
For financial or payment reconciliation practices, here is another new software to ease your productivity. Website link: https://optimus.tech/
-
Matt Jones commented
I'm about to find a different solution than Xero, insane that I have to click thousands of time a month for the same transaction just from different customers. Not to mention having to fill in the WHO in order to get the OK button. Can't take it anymore.
-
Angela Barbay commented
We are reconciling 300+ credit card receipts per day. Invoices are generated automatically, however when the banking facility statement is imported with the payments we have to click OK for each transaction. 95% are correctly suggested matches based on the reference information in the system. Please consider adding this feature or an alternate solution in the very near future.
-
velan bookkeeping commented
It seems like you're asking about reconciling bank transactions and using the term "Bulk 'OK'" in that context. Reconciliation in banking typically refers to the process of comparing your financial records with those of your bank to ensure they match
know more: https://www.velan-bookkeeping.com/ -
Jenelle Daley commented
When reconciling manually entered transactions in bank accounts, ability to reconcile in bulk rather than having to do individually.
-
Melanie Currie commented
Please add option to select multiple transactions on the Reconcile screen for the bank, so similar transactions can be coded and posted together without a match (ie, bank fees)
-
Yumei Lin commented
Being able to auto reconcile/cash code the bank transaction when you import the bank transaction or the bank transactions processed through Xero
-
Karen Cronin commented
It depends on your business model and banking arrangements
Reconciliation is crucial to mine and bank feeds not always appropriate.
Xero seems to only fit one style of operating. -
Claire Taylor commented
Thanks for the update
I realise there is a lot of work needed in the background that we dont see but put simply for me a tick box beside transactions like in bills and sales and to be able to select all the transactions with 'OK' is really what I would like to save time in the reconciliation....
-
Tak Wun Wong commented
I just clicked "OK" 5381 times. I think I might have developed carpal tunnel.
-
Hui ying Cheow commented
My client not using bank feed, they just provide me their bank statement, so I need to key in manually. When bank reconciliation, it really take time !! We need to click all the transaction itself and mark as reconciliation. Quick book and others account software can just tick all the transaction you need and approve after you check and tally with your bank statement. Xero really need to improve, very not convenience for manually key in user. Quick book and others software cannot scan bill and upload like XERO, if not I already change to others software.
-
Bradley Whitford commented
Bank Rules - Auto Reconciliation.
If there is an option for "auto-reconciliation", in Bank rule creation it will save time.
For example. We have created a bank received rule that says that if the "CITIZENS" condition is met, the item shall be recorded as "4200 - Merchandise". Instead of it shows as "Apply rule".
It should be automatically posted and reconciled. -
Mike Malone commented
Most ecommerce clients have a direct feed from PayPal producing hundreds of OK's in bank rec. from invoices generated by their respected sales platforms.
If date and amounts match we need to be able to auto allocate, leaving only those identified as (other possible) unreconciled.
-
Naomi Harris commented
great invaluabe idea
-
Jennifer Martin commented
Yes need this for quickly matching credit card feeds, which match via an add-on application.
-
Samuel Boyd commented
Yes, I need to bulk reconcile bank transfers - particularly from bank accounts to my paypal account. Would be an easy fix, and save hours of hassle.