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
-
Matias commented
I created https://bankfeedapi.com to address this. It's in beta and free to join right now. Hope it helps 🤩
-
Alvaro Aguilar Artinano commented
Please add this ASAP. Key feature.
-
Abhay commented
Please add this ASAP. Key feature.
-
Steve commented
please add this feature
-
Yulian Koval commented
Critical need
-
Julià Pujol commented
This is absolutely ridiculous. Get access to developers now - this is a key feature - can't believe it.
-
Jonas Lauber commented
What ?!? How can such an important feature not be implemented ?!? This just doesn't make any sens. I'll be looking for another tool then.
-
Chris Macneill commented
I've been asking for this for 5 years, yet in that time the oh so overworked Xero developers have managed to implement all sorts of GUI tweaks that I DON'T need, but can't seem to find time to make available the features I and many, many others are literally screaming for.
-
Jan Troler commented
Same use case as Santi Azpilicueta, just critical:
The plain use for this feed is custom bank accounts, such as Merchant accounts that are not Stripe.
The chances of each the myriad individual merchant account (that is not Stripe) to ever get to integrate with Xero are very low... Please open the API for bank statements!
-
Santi Azpilicueta commented
The plain use for this feed is custom bank accounts, such as Merchant accounts that are not Stripe.
The chances of each the myriad individual merchant account (that is not Stripe) to ever get to integrate with Xero are very low... Please open the API for bank statements!
-
Aaron Angel commented
"Instead of Xero building a feed for each individual bank – a process that could take months per bank – financial institutions will be able to build to Xero’s API as quickly as in a few days."
I don't know why Xero thinks banks are going to cater to Xero users with custom applications; they aren't. Banks are looking for ease of maintenance and broad appeal. Maintaining code to integrate with multiple niche third-party products serves neither of those purposes.
Most importantly, Xero should ditch Yodlee. Xero talks about security in updates to this suggestion, but what the security of giving your banking password to a third-party? Yodlee is a web-scrapper, and their product is brittle. I have lost count of the number of times their product has broken. I have also lost count of the number of times their developers, completely oblivious to the fact that humans need sleep, have twiddled around with my account, triggering MFA calls back to back to back in the middle of the night. They've even persisted after I changed my password to the point that they locked me out of my banking account. Their product still periodically breaks. Why does Xero still do business with such a company?
Xero would do better to join some open banking efforts and support existing work being done in this area. Telling users banks can "build to Xero" is like saying water can flow upward. Sure, it could happen. Will it solve the present problem? No.
-
Edward commented
I developed an automated bank statement importer for a client (as many suggested in this thread) and I'm building an API on top of it, in the hopes it helps others. If you are interested in using it, let me know 👉 https://forms.gle/yndBZfc56cZgYuSp7
-
William B commented
Not being able to access bank statement lines makes the API completely useless in my opinion. That's the ONLY thing I need it for.
-
Galinos Giaglis commented
The least you can do - apart from being ashamed of yourselves for not having done that SO many years now - is act and finally release an API.
The PSD2 Open Banking is here a year now and you are not providing a most useful help for no apparent legitimate reason.
-
Andrew commented
If others haven't seen it Xero have announced a feature in HubDoc that will convert PDF bank statements to CSV - https://www.xero.com/blog/2022/07/import-transaction-data-into-xero/
This won't be of any use for us, and probably not for a lot of other people on this thread, but it may help some. Interestingly, if enough people use this feature and then get fed up having to manually import the CSV files, it could give fresh impetus for some way to automate that import process (either via the API as we would like, or even something simple like the ability to select multiple files when you're using the manual upload option!)
-
Andrew Gould commented
If you are not going to allow me access to the bank feeds api because i am not a financial institution then you need to get serious about your customers who use xero and are frustrated by your lack of any real genuine response to any bank feed issue. I have noticed by searching your forums that you never fix any bank feed issue. Is there no-one at xero with knowledge of how to query the database with a json and repair these issues. I am sure as in my case it is only a matter of setting the bank connection from active to inactive and ensuring that anything else such as connection is made available to be activated. I just want access so that I can attempt to do what you won't. By the way doesn't Xero even read these comments?
-
Mohamad EL-Bawab commented
We, too, the API will save us a ton of manual work formatting our e-commerce provider (Fast Spring) statement into a Xero-compliant format file to import into Xero before we can reconcile.
-
Richard King commented
This feature would greatly improve our internal processes and make running our business more efficient.
-
Honey Bee Cafe commented
Thread open for years. Over 2 Years since Xero responded! Happy to spend tens of thousands of adverts to get new customers. Happy to put prices up so we pay for those ads. Completely ignorant of what their actual customer base wants. It isnt even a difficult thing to implement lefts face it so no real excuse here! Come on Xero listen to what your existing customers WANT not what you think. Beginning to wish I had gone elsewhere...
-
Streem Connect commented
Can somebody please explain what the point of this API actually is? Not being able to access bank statement lines or import from alternative feeds makes the whole thing redundant. End of