Import bank statement lines via the API
Be able to import bank statement lines into a bank account in Xero. This would be useful for custom bank accounts or banks that do not have a direct feed into Xero
-
Prasad Herekar commented
We are using XERO for our accounting and we want to automate bank reconciliation. We are a retail business and we have many transactions.
-
Lohitya Sethuraman commented
would be incredible to have access to this endpoint
-
Dermot
commented
This would be incredibly useful to our organisation.
You provide this facility via the API Explorer.
https://api.xero.com/finance.xro/1.0/BankStatementsPlus/statements
It strange that this is feature is missing when we have to give Xero permission to access our bank account and then you restrict access to our data unless you are a "Financial Services partners".
-
Omer Hayat commented
yes please
-
Louis Reynders commented
Please add this feature !
-
Sher Ghan commented
You should have this buddy. thanks
-
Patrick Carroll commented
Am I correct in saying we are unable to even pull the bank statement balance from Xero, and we can only take the GL balance, which will be way out of wack if there are unreconciled transactions? We need to be able to pull statement balance - please please sort out this critical API. Or hopefully correct my understanding
-
Jan commented
It took 16 years to get a team to go into "discovery mode" on this most voted request?
-
Matias Chiappino commented
+1000000 for this feature
-
Prioticket BV
commented
How is it possible that one of the most user-friendly, focused, and almost-perfect accounting platforms — Xero — lacks a basic but critical feature: the ability to import bank statement lines?
Why? What is the purpose of an accounting system if you can’t import bank statements?
We’re eager to adopt Xero across multiple accounting firms and legal entities in various countries. But we simply can't move forward, without the ability to import statement lines, it's operationally impossible.
What’s especially frustrating is that there are countless middleware solutions built on the open banking standard, like Ponto, that already provide secure, compliant access to transaction data from hundreds of banks. Supporting even one of these would instantly unlock this functionality for thousands of users. Why not enable integration with just one?
Every other accounting system we’ve used has significant flaws, and none come close to Xero’s overall design and usability. But without reliable bank statement import — unless you're tied to the very few Xero supported bank feeds, Xero becomes unusable.
This isn’t just a missing feature. It’s a total blocker for any serious company looking for a future proof accounting system.
-
Michael Leah commented
Need to to get immediate bank payments
-
James Jesudason commented
Even making it possible to submit a CSV file through the API would be a step forward. Restricting this API is making us consider moving to a different accounting system with more comprehensive APIs.
-
Nora Faith commented
That’s a great initiative—direct API imports for bank statement lines would definitely enhance efficiency, especially for institutions without native integration. For those managing complex financial data or hedging strategies, a tool like https://chathamratecapcalculator.com/ can help assess cap agreements and rate exposures alongside accounting workflows. Combining such tools with API-driven systems could offer an even more powerful solution.
-
Jonathan
commented
I actually understand why you can't allow programmatic access to data you are importing from banks (due to contracts with the likes of Yodlee/Plaid).
I do not understand why you can't provide APIs for adding our own bank statements. I could do what I want to do, export a CSV and upload it to Xero - why not just let us do it via API though.
I suppose if you do support this, you SHOULD support letting us manage these bank statement lines via API as well, but with a big red asterisk that says "WE CAN'T LET YOU READ/MODIFY/DELETE DATA WE PAY FOR". I'm fine with that for now.
-
jim tng commented
Please add this feature. Originally requested in 2009!
-
Ilmo Koo commented
This is very core API we need in South Korea because we do not have many authorized bank feeds.
-
Simon Chan commented
We do need this feature. it is very clear and useful.
-
David Richardson
commented
+1 for this feature so we can make using Xero more efficient for many of of client use cases.
-
Andy Slack commented
I would like to +1 this feature.
I am trying to automate my book keeping as much as possible. My use-case is chasing stakeholders for invoices which we have payments for but no linked Invoice.
I would like to send them a Slack message with the invoice request, the user would then add the invoice via Slack and it would add it to xero and link it to this payment.
-
Timothy
commented
I raised this on 17 June 2024 over on Xero product ideas and they've asked my post to be moved over to this thread on the API section of the Xero suggestions:
Allow Xero bank feed API for petty cash accounts. Currently Xero has a bank feed API, but this is restricted to banking institutions only.
Considering Xero encourages accountants to make automations to improve their work, I think opening the bank feed API is a missed opportunity. This would increase productivity so much by allowing automating petty cash and expense systems automations.
This would also allow users to choose to make their own bank feeds using open banking for EU accounts (since Xero does not have their own licence for this it shouldn't prevent accountants partnering with licenced companies to provide their clients bank feeds).
bankfeedapi.com have made a very simple, but effective proof of concept of an end user bank feed api that can be automated between a licenced bank feed aggregator like fintable.io and Xero to produce a bank feed.
Xero have since blocked access to bankfeedapi.com due to how it accesses Xero (I agree since it mimics being a Xero user to emulate uploading a CSV statement), but I feel that someone going to the extent of making that api shows how Xero is behind other software that currently provide EU bank feeds.
I use Xero for all my UK clients and I have started onboarding clients in Spain currently on manual records. If Xero do not at least provide an api for petty cash style accounts in the near future, I will have to start onboarding my Spanish clients onto QuickBooks instead so they can get a bank feed.
It's such a shame as the technology is already there and it is purely Xero's own policy putting it far behind other software providers for EU countries.