Hi community, We're excited that enhancements to your bank reconciliation experience in Xero are in the process of being rolled out! Some may notice you can now effortlessly search and filter statement lines based on your preferred criteria, giving you ultimate control and efficiency. Plus you’ll be able to view more statement lines on your screen - up to 50 unreconciled statement lines on one page. 🚀
Worth noting here with the interest in getting a narrower view of statement lines that need reconciling on a given or between certain dates - you’ll find with the more option to the right of Search you’ll be able to set a date range and filter down your view 😁
If you don't quite have the new features yet, I can assure you they are coming soon, as we ramp up the release of this to everyone over the next few weeks. I'll return to confirm once live for you all!
-
Charlene Croukamp commented
This will be very helpful
-
Prizm Vinyl Corporation commented
Search by date or amount right from the reconcile screen rather than having to go to the bank statements tab.
-
sammy cooper commented
just one simple search bar resolves a long time searching
-
sammy cooper commented
quickbooks are so much more on the ball i was going to move another company to xero but liking quickbooks as its less time consuming with reconciliation and vat
-
Stephen Burford commented
this would be very handy, to gather all payments from one supplier and then simply go through their invoices to check gst amounts in one hit. one by one this is very painful. Also great for locating or splitting invoices.
-
Charlotte Gaskell commented
I wish that Xero would listen and, act upon, the so many requests to improve the bank reconciliation pages. Within other accounting packages I can sort by by date and amount; and filter by contents of memo, in fact all that I need. With Xero on the bank reconciliation pages none of these is covered. I am not impressed at all. These requests have been raised years ago and still nothing is done!
-
Admin Operator commented
How Annoying & Time consuming is Xero - Sort and Filter to the Main reconciliation screen, the number of lines per page - scroll back to the botton to go to the next page plus for Bills & Invoices with payments applied having to remove the payment !!!!! What I have noticed is we are all wasting our breath posting thing that are ESSENTIAL, day after day, minute after minute - Units of measures, 30 60 90days etc - all Basic requirement - no customer service you can phone - "Building on Beautiful" how about just Building the BASICS ?
-
Roger Harrison commented
Should be possible to set the parameters of the bank reconciliation rather than having to start at the earliest every time.
Quickbooks has that feature.
Not having it adds a lot of extra work each time one logs in.
-
Jack Milner commented
+1 to all comments prior.
There should at least be a feature to 'show more' so that there isn't only 10 items on the screen to go through and reconcile. It's available on cash coding, bank statements and account transactions tabs, but not the reconcile tab.
Even if they made it so you could search for specific line items (like you already can) and either reconcile from that screen, or click into it and reconcile it from there.
-
Mel Fenemore commented
Some great points made by Gavin Ander and others!!
I give up hope that there is any direct work taken out on any ideas that are not only useful but fundamental to making this a workable programme!
Every quarterly update is just another disappointment from a programme that clearly doesn't engage with accountants, bookkeepers or it's users!
-
Johan Potgieter commented
the usual ********. Why does this Product Ideas site even exist?
I have yet to discover a product idea that is taken seriously.
It is clearly just a place where we voice our frustrations, without any result.
Like screaming at the ocean.Xero, thank you for giving us the platform of Product Idea Rejections
-
Paula Wyeth commented
I encountered a file this week where a search function would have been incredibly helpful. The client sends about 150-200 expenses from DEXT to Draft Bills in Xero for me to open, check, approve and find the payment that matches. I don't know which account he has paid them from and sometimes they are paid from a credit card that isn't linked to Xero (he has his reasons for this but makes it more difficult from a bookkeeping perspective). He also makes mistakes with the amounts that come through from DEXT as he converts some to Aus dollars (DEXT) and the AUD amount doesn't always match to the bank feed amount in Xero. If I had a simple search for the all Xero linked bank accounts by supplier name, or amount, or date range, I could quickly work out if these expenses have been paid from a Xero linked bank account or not. At the moment I am scrolling multiple cash coding screen pages in multiple bank accounts in Xero just to work out if they have been paid from a Xero linked bank account.
If this was in MYOB it would be more simple for me due to the ability to view all bank accounts in one screen and allocate or match to a bill. I prefer Xero to MYOB, no issue there, however one area of MYOB that I find super easy is the bank transactions screen that lists all bank feeds for all bank accounts in one screen as I can search/find transactions so quickly. I have attached a screen shot as an example. With the right hand side drop down there are additional options for extra line items, transfers etc. Makes matching transfers very easy when all bank accounts are listed together.
I am a happy Xero user but I really feel this is a feature request that would be helpful to so many.
Kind regards
Paula -
Nathan Apter commented
It's essential to offer sorting and filtering features on a list, especially for individuals managing thousands of transactions. Your argument that some people have a high volume of transactions to reconcile only emphasizes the importance of these features.
Any database can sort and filter thousands (millions) of records in seconds or less. I'm curious what kind of storage system these records are stored in, that is unable to sort/filter/index thousands of records.
-
Paul-John Mudie commented
+1 Gavin Ander
-
Paul Howlett commented
Logging in to +1 Gavin Ander.
-
Ronan Browne commented
Well said Gavin Ander (and everyone prior to this!)
I am writing this short message to show that ‘like’ for what Gavin says.
We are all blue in the face trying to get you, XERO, to listen to us and our extremely sensible suggestions, wants and pleas. Yet, so little ever happens. It is as if the people in control of XERO don’t actually do any accounting. A little bit like a group of librarians running Formula 1…!
-
Gavin Ander commented
You know Xero, this is somewhat frustrating... I think if you were ever asked to "scratch an itch" you would scratch everywhere but where the "itch" actually was. You would then tell the person this was all part of your relationship 'building on beautiful' strategy.
With comments like "Though this doesn't directly relate to sort and filter capability, this should help improve your experience when reconciling accounts with Xero". Basically, you are saying what users are asking for is not going to happen.
I agree with Lesley Christian & Paula Wyeth. We urgently need:
1. Sort and filter function on the reconciliation screen
2. One page of reconciliation transactions, or with at least the ability to increase the number of lines shown.
3. Have the ability to "like" people comments in these threads so users can show their support for the various comments. -
Sebastien Lahtinen commented
On the Reconcile tab of bank accounts, reconciling would be often easier by doing all transactions for one supplier at the same time rather than in date order.
Provide a search field which dynamically filters the pages of unreconciled transactions and only shows matching ones. Allow anything to be typed in there which is available on that page
including Payee, Reference, Description, Transaction Amount. The most common use case for me would be filter by Payee/Description. -
Andrew Syme commented
"the platform in it's current form cannot cater for sort or filtering through all statement lines in an account"
BUT it does this already on the Statement Lines Tab ??
Can you please explain your statement. -
Gail Cook commented
If the option to select a date range or page number instead of having to click through numerous pages of transactions to get to the date that you want would be helpful and would not think it is a big deal to implement.