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 :)
-
Sharon Ryan commented
Hello Xero admins - is this reconciliation feature being looked at yet. The idea and request was submitted in 2012 and here we are in 2024 with still no ability to reconcile clearing accounts within Xero. We appreciate that it is something else to add HOWEVER it is and always has been readily available in one of your major competitors that it surely cant be that difficult to create? ....... it really is the one MAJOR disappointment of this program.
-
Lee Hoskin commented
Is there a way to Reconcile multiple Cash transactions instead of having to go into each invoice and Reconcile individually. Really time consuming and unnecessary if not.
-
JJ Eldrege commented
Reconciliation of balance sheet accounts, such as payroll liabilities. I reconcile balance sheet accounts on a quarterly basis to make sure liabilities are being paid timely and correct.
-
Optimus Fintech commented
To achieve full accuracy in financial reconciliation practices, you can check the following page to track the working source:
-
Colleen Jooste commented
Hey Xero, i have moved three smallish companies to Xero and i absolutely love the product. I would like to move my holding company but there is one shortfall. Disbursement recons. recovery of payments from clients. platform should be the same as bank recons, allocate a payment to a reference allocate an invoice to a reference and march the transactions to ensure recovery from the client. again just like the bank recons. match match match. any disbursement that does not match a recovery is a query and should be investigated. please help this would really change my Xero world.
-
Naomi Hodgson commented
Myob has this function...
-
Alex Lacota commented
We are now Xero certified!!
We have a brand new website at https://www.rechound.com which contains pricing, FAQ and a bunch of resources on how you can finally reconcile any balance sheet account in Xero. You can now also sign up for a free 30 day trial :)
Let me know if you have any questions or would like to get in touch!
You can message us on the website or at info@rechound.com -
Alex Lacota commented
Hi all,
Hopefully we are only a month or so away from release!
If you'd like to become a Beta tester we still have some space - just shoot an email to info@rechound.com and we can get you set up. There's no obligation here at all, pretty much just free RecHound until we go live! :)For more information we have a new blog post here:
https://www.rechound.com/post/may-updateCheers!
Alex -
Darren Chua commented
Beside the invoice number, reference, cost centre field, allow the admin user to add several customised field can solve many problems. User can add a reconciliation number field and pairing themselves as reconciled
-
Nella Barnard commented
Hallo
I think it will be a great new feature, if you are able to reconcile your loan accounts in all you separate entities on separate Xero’s. A report linking and matching entries in different loan accounts in all your entities.
-
Alex Lacota commented
An update on how our app is tracking for those still after this feature:
-
Support @KIS commented
I watched your You Tube Video and it looks fantastic. Huge thank you for developing this. It is a game changer. I would love to test drive it when you are ready.
-
Alex Lacota commented
Well that was a bit of work!
We now have our proof of concept completed for our application - see the video below for an idea of what we have been developing!
Very eager to hear your thoughts on this. Thanks to you all for your support and feedback thus far :) -
Savvy Office Solutions 1 commented
Once the multiply bank reconciliations program is working could the product tema create another non bank reconciliation report.
-
Support @KIS commented
Alex Lacota, that is very exciting news. Can't wait to see it when it's done.
-
Alex Lacota commented
I have exciting news! After relentless work with the API, we believe we are 95% of the way towards our proof of concept for line by line reconciliations!
We aim to build out our UI over the coming months and have beta testing available in the new year. We aim to have a website up and running soon with the option to join a mailing list for updates - periodic updates will be posted here as well but we aim for the mailing list to be our main form of communication. I will let you all know as soon as this is available.
Thanks again for all your input on this topic, it has really helped shape the development for this product :)
-
Paul Downward commented
I would agree with Peter! Reconciliations are not only for bank accounts. All clearing accounts such as PAYGW, GST, Super payable need to be reconciled to "nil" to ensure nothing has been left unpaid. dumping them to excel is a workaround but its time Xero introduced this feature.
-
Robert Ross-Edwards commented
This functionality would be very beneficial, I am in retail and all clearing accounts tor Amex etc there are hundreds of transactions, that need marking off, line by line.
Far easier to know what has not been reconciled than look at spreadsheet with hundreds of lines and mark off individually.
Alternatively could allow manual journal entry to bank accounts, which would allow the use of the functionality, and not use bank feeds. This could be done on account by account basis, like allowing payments to non bank accounts -
Alex Lacota commented
Really appreciate all the feedback from everyone on this.
As I mentioned, the core functionality of the application will be to manage the completion and approval of balance sheet reconciliations, as there is no current process for this within Xero, and is required from a governance perspective.
I will be pushing to have line by line reconciliations added to the functionality of this application, but although currently untested, I do foresee some major roadblocks here due to the API functionality within Xero, specifically within the parameters running the journal API, (eg in order to pull out the transactions for a month per GL account, it appears that you need to run a data dump of every single journal ever posted. This would cause a timeout for many businesses.)I will periodically post updates on this thread in regards to how we are tracking on this solution.
Thanks again!
Alex -
Russ Willing commented
Hi Alex
Yep. I'm seeking line by line reconciliation too.