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
-
Marcin Łukasik commented
This is absolutely a must-have. There are many banks with no automatic feeds. We have a UK company with bank accounts in Ireland, Poland, Canada, etc. and we have to upload everything manually. PITA.
On top of all this, I would really like to see automatic reconciliation via the API.
Sometimes it can really be done. When for instance I edit paid invoices in bulk (so store reconciliation ID, remove payment, edit invoice, attach payment, restore reconciliation using the ID stored). -
Tomasz Lotocki commented
This is so surprising that you do not have this functionality. Yes some banks have feeds but for instance mu cash account does not have one and will never have one. I could have easily sync it via API but it does not exist...
-
Dale Nursten commented
Agreed, I really need this functionality. Currently I am having to upload CSV files which is very slow and tedious!
-
Thomas Morgana commented
This would be critical in allowing us to develop partnerships with Xero integrators.
-
Property Credit commented
Please! We need this.
-
Connor Hood commented
The fact that Xero does not give me any ability to automatically import bank statement lines via the API absolutely blows my mind. Very strongly considering moving all of our businesses away from Xero.
Have you considered the dozens of banks in Indonesia, for example, that will never get around to supporting whatever bank feed API you have? Come on Xero, we spend thousands of dollars per year with you all.
-
Timothy Potter commented
This would really bridge the gap with EU accounts since Xero is way behind QuickBooks with this.
Their current reasoning is that they don't have an EU banking data licence, but opening the API to allow others to use services like fintable.io that do have an EU data licence would bridge this gap.
I do know there was a service created using automation that created an API that then automated upload of a CSV file to create this, but Xero blocked access by bankfeedapi.com
This is such a shame considering someone built what Xero haven't prioritised and Xero haven't adopted it and instead blocked it...
-
Jo Campbell commented
Most companies have multiple bank accounts. being able to consolidate through Xero API would be massive for us
-
Andrew Forte commented
This would save so much time on xero for hundreds of accountants. Please. any time lines? This has so many requests?
-
A Brewood commented
Several of our clients, as well as our own Xero accounts, use a Bank Account in Xero that isn't actually linked to a real bank account.. so there won't ever be a bank feed for them..
E.g. a BACS control account. Several times a month we have to create statements and import them manually into Xero.. it would be so much easier to submit these via the API.. -
Anonymous commented
A lot of banks in the middle east are not supported by Xero and we need to ensure that we can at least able to import via API
-
Nathan A commented
Why wouldn't this be part of the API? Makes no sense. Please add it.
-
Justyn commented
How can this have been requested so many times over more than 14 years?
We wish to use this to import statement lines from a non-bank payment processor (Upwork). Currently this can only be done manually with the CSV bank feed importer.
You are deliberately wasting our time by refusing to allow automatic importing. -
lucas shao commented
This feature is so useful! I have had enough of manually importing bank statements, which is time-consuming and laborious. Please launch this function as soon as possible. Thank you!
-
Mark Francis Beltran commented
A thousand times Yes, please! This is critical for my client who receives bulk payments. Even with batch reconciliation as a feature in Xero, it is still a nightmare to split payments, This will help with this.
-
Dennis Eagles commented
absolutely critical functionality, and somewhat embarrassing to Xero that this basic process is restricted to 'Financial Institution Partners' who can use the Bank Feed API.
-
Steve Venton commented
This thread has been open since 2010. My bank is in Africa and it does not have a Bank feed. Therefore I have to employ someone to *manually* import bank statements. This is prone to error AND it is a security risk because they see how much everyone else in the company is paid. We must automate this task. Please implement it urgently.
-
Miguel Garcia commented
For anybody that has a bank account without feed, without this you'll need to manually import the statements daily for the Accounting Team to work. Being able to simply upload via API would be really helpful
-
Simon Frost commented
It blows my mind that this has been requested for so many years and has thousands of votes, but you're still restricting it just to financial institutions. Why? What's the logic there? What difference does it make to Xero if we are able to use this one particular API?
-
Paul C commented
Xero, can you at least provide a rough timescale for this please? Your customers have their own software development to plan out so it helps a lot to know when to expect features like this!