Reconciliation - Ability to reconcile clearing, control, and non-bank accounts in Xero
Ability to reconcile clearing,control and non-bank accounts in Xero.
Purpose: To save time rather than having to copy and paste into excel to reconcile the balance.
Hello everyone, appreciate all your feedback here. To be upfront, we don’t have any plans to develop the ability to reconcile clearing, control and non-bank accounts in the near future.
Some of the technology improvements going on across Xero will create more opportunities for us to explore extending some of the more complex functionality from one part of Xero to another. However, we are some way off from this yet.
That being said, there is the Account transaction report that could be handy in providing a view of both sides of a transaction in Xero. You can include the related account as a column in the report - See more in our help article on this.
Alternatively, if you’re using an external system, you could look into the Xero App store.
Appreciate there are also lots of ways others are using Xero’s to fit their needs - If you have another way you’re achieving this, welcome to share it here :)
-
Donnie Buchanan commented
please please
-
Wise Sync [Support] commented
+1 for reconciliation bliss
-
Delwyn Shaw commented
This is a vital feature which has been missing from Xero for far too long
-
Jacinta Hoare commented
c'mon Xero, its 2022 already and we have been asking for this for over ten years now.
-
Amanda Bradbrook commented
Awesome work Xero! Can’t wait
-
Electra Frost commented
This would really help with crypto clients too.
-
Sally Farrant commented
Can believe I can’t do this in Xero. It’s such a pain and takes so much time every month to reconcile balance sheet accounts
-
Claire Buckley commented
This would be an amazing feature
-
Heather Kennedy commented
This is the main reason I have way more QBO clients than XERO. Without being able to reconcile within the software it's like stepping back to the dark ages (Excel).
-
Megan Murphy commented
This was the first feature I ever contacted support about, back in 2013. I couldn't believe it wasn't available then, and I really can't believe it's still not available now. The countless hours spent by staff in this office reconciling clearing accounts each week is beyond ridiculous.
-
Kelly Vardy commented
Each time I have to download an account transaction report to do this I think fondly of how easy it was in QuickBooks.
-
Tanya Spence commented
Look at the date that this was lodged. 10years and still crickets regarding this feature
-
Chris Rose commented
Clients need these accounts correctly reconciled. This should be done daily. Remember it was reconciliation and the revolution of the single ledger that made Xero awesome. Continue the awesomeness please!
-
Kylie Gorzalka commented
Huge time saver - would use daily
-
Lauren Harvey commented
Ditto Heather and Luke 👍🏻👍🏻
-
Alastair Abbott commented
Such a needed functionality.
-
Katherine Hawkins commented
This is a much needed feature to reconcile these types of accounts in a timely manner. Especially when clearing accounts are required for workflows.
-
Edward Henry FIPA FFA commented
I have a major clearing account to reconcile which would be so much easier if it was in Xero instead of having to export it to Google Sheets each month
-
Heather Smith commented
You make some very valid points Luke.
"I've never understood why this wasn't there in Xero from day one!" I think it "the dream of automatic coding" was the reason it was left out.
Thank you for your vote and comment.
-
Luke Abbott commented
This is such a useful function of so many accounting systems and I've never understood why this wasn't there in Xero from day one!
The ability to fully reconcile transactions within a control account (not a dummy bank account that you can't import journals into) should definitely be high up the list. We find ourselves reconciling multiple control accounts each month by exporting to Excel at month end and laboriously working through to match things off. (Some accounts contain 3,500-4,000 lines!!) If we could reliably match throughout the month as we go it would save hours at month end.