Thanks for your support and rating of the idea here, community.
While there's 'building on beautiful' work across Bank Reconciliation pages at present, the team have also been making improvements to improve and increase automation when reconciling your accounts. Though this doesn't directly relate to sort and filter capability, this should help improve your experience when reconciling accounts with Xero - doing more of the heavy lifting for you by matching or suggesting reconciliations.
Being open, the platform in it's current form cannot cater for sort or filtering through all statement lines in an account (some businesses that have 000's of unreconciled lines!) which is where the building on beautiful work is critical - However, we're exploring possible improvements that could make navigating through unreconciled lines simpler such as bringing the navigation to the top of the page and increasing the number of statement lines that are shown on a single page.
So to keep things clear - there is no direct work planned for sort and filtering of bank statement lines right now, but we'll continue to develop and share enhancements that simplify reconciliation in Xero with you all.
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.
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.
Linda Bates commented
Come on pleeeease Xero - sort out the fundamental basics with the day to day stuff for the bookkeepers!!
Cash coding & reconcile tabs: we need the ability to search and filter out transactions the way we can with statement & transactions view to help us speed up the time spent reconciling bulk items. The sort option in cash coding currently leaves a lot to be desired!
Also it's about time we have the ability to find & match credit notes from the reconciliation screen.
Lesley Christian commented
I completely agree! Why do we have to click next page when it could quite easily scroll. Such a simple idea and very powerful for bank reconciliation Sort and filter would also be helpful and speed up reconciliation too.
Please implement these ideas Xero.