Reconcile via the API
Be able to reconcile bank statement lines via the API.
Firstly, apologies – it’s obvious from the continuing comments that we declined this request too hastily and without the explanation it deserved.
We know that reconciling would be a valuable API feature, but reconciling requires fine grained access to bank statement data and unfortunately we’re not able to share that data via the API for commercial reasons.
At Xero we’re passionate about having an open API and providing small businesses with open access to their data. Unfortunately, many of the partners we rely on for statement data don’t share the same ideals.
Hopefully change is coming in the form of open banking. However, it will be a long time before we can openly share statement data via the API and provide a decent reconciliation experience to third-party apps. For that reason we will unfortunately leave this request as ‘declined’.
For the immediate future, we’re busy doing some really cool stuff to improve the in-product experience and automating bank rec as much as we can. We already have bank rules, auto-match, suggestions and cash coding but there’s lots more coming this year.
Again, we apologies for our lack of transparency on this thread. We do value the feedback on UserVoice and have shipped features with over 3000 votes in the last 12 months. We definitely dropped the ball on this one though.
Richard Christian commented
What is happening here? All I want to do is allow my staff to see what payments have been received in the last day so they can release equipment. Very basic. But I go through paying the subscription and setting up the whole thing just to find that obvious and needed option is not available??
Alex Soul commented
Please add an option to view Uncoded Statement Lines. There is a report for it already - can we access this report over API?
hari salabashyan commented
Reconciliation via the API is critical business functionality. Please consider enabling this feature.
Nicolas Emmerich commented
Since we can't vote, consider this comment a vote.
Brendan Gooden commented
Reconciliation via the API is critical to our business operations. Please implement ASAP and listen to your customers!
Alex Soul commented
Hi, I need to be able to count how many transactions are still unreconciled and from how long ago. I need to ensure that our bookkeepers are doing a Great Job and there should not be any unreconciled transactions pending there for longer than X days. I am not able to keep checking this myself on a daily basis.... so, a basic API access to at least READ-ONLY would be highly beneficial for this checks
Is there perhaps a way to just initiate the reconciliation process and identify how many, if any, statement lines remain unreconciled?
Shane Russo commented
Can you please provide an update to this feature?
Reconciliation via the API is critical to my business. Without it I will need to look at alternate products to Xero.
August Stoyanov commented
There are no commercial reasons stopping you from providing data to custom connection apps. This is not sharing. We own the data and can do whatever we like with it. The bank provides us with the statement for free.
Greg Elliott commented
It looks like voting is closed so please add my vote to this.
One of my first tasks for the new year was to investigate and establish an API for the bank rec. We have a customer who pays each invoice individually (approx 500/mth and growing) and uses their own internally generated number as the bank ref. We built an automated process which extracts the invoice number matching the customer's payment ref. The final step was to automate matching on the bank rec via an API. Sadly it looks that won't be happening with Xero ☹️
August Stoyanov commented
Why is the documentation pointing to this issue here and then voting is closed? It is crazy not to have this feature, and even crazier to suggest that to provide it you need to give us access to "their data". It is our data, not theirs! We only need the data you are showing on the statement line anyway. Please reconsider! Or give us a believable explanation.
William B commented
what is the point of a 'bank feed' service that has an API, but you can't use the API to access the bank feed?!!!! this is totally pointless. I wasted a week trying to understand what the hell I am meant to use this for.
Joel Kallman commented
It's been almost a year since my last request and it looks like many others want this functionality. This is extremely valuable functionality for businesses and addon integrations.
Please provide a mechanism to read bank statements and reconcile over the API. If your agreements with certain banks are restricting your ability to offer this functionality, please offer it only for those banks that allow it. I'd gladly switch all of my businesses to those institutions if it meant we could automate this functionality.
Khayam Ezzat commented
This feature is available on FreeAgent. It is a mystery as to why this not included in a product as mature as Xero. If it were built that means I can allow someone who I don't want to give unfettered access to the accounting system or necessarily understand accounting deeply, a screen to match payments to clients which the system can allocate to invoices on the API. The lack of this feature means I cannot migrate my nursery business to Xero.
Can we at least have the transactions exposed? I personally dont need the reconciliation feature, but having the transactions available would go a long way for my situation. (Like they used to be in the report API then stopped in late 2021)
Lola Chang commented
We're working with NZ & AU banks to improve their bank app offerings. Enabling their SMB customers to do reconciliation straight in their bank apps soon after transactions happen would be a win-win for everyone - the banks, Xero, their customers, accountants and advisors. Right now the infrequency of SMBs logging into Xero to do reconciliation causes problems for everyone needing up to date data to help SMBs stay viable and thrive. Perhaps this could be a restricted access feature instead of being unavailable to all?
Emily Spence Thomas commented
I'm adding another vote for access to reconcile bank statements via the API, this would improve productivity for so many people, PLEASE reconsider this.
Galinos Giaglis commented
In Europe we are currently working with PSD2 Open Banking for ALL banks. All CRM and ERP vendors have to ingest open banking data with direct connections. We are not even asking you to do this.
We are asking you to open the API and let us do the work by just submitting what we get from the bank.
This is completely preposterous ok your end to INCREASE prices while you continue offering a lesser product or adding features that in most cases are not useful to the majority of your audience
jason orrock commented
Another voice added the request to this obvious feature.
You have the API why not extend it to cover this function and keep a log of this tagged API based state change or something?
We have a lot of automation we work on with e-commerce and this causes a lot of issues especially with high volumn sales.
Joel Kallman commented
We would be able to automatically reconcile about ~90% our transactions if we had the ability to utilize the Bank Statements API. This would be **extremely** valuable for us and our business.
Please provide a mechanism to read bank statements and reconcile over the API.