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
-
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.
-
Barry Murphy commented
Can't understand why this doesnt exist.
I've been looking for a method to have our woocommerce plugin connect to Xero API, look at un-reconciled transactions in the Paypal account and assign them to invoices in Xero. Unfortunately with the way that Paypal transactions work, we dont have the exact exchange rate from when they transfer from an international currency to NZD, so we generate the invoice In Xero with the current exchange rate. This means no imported PayPal feed transactions match unless they are NZD. -
Henry Alfie commented
I completely understand the importance of this feature. At the moment, I find myself relying on manual CSV uploads, which is both time-consuming and inefficient. For more streamlined solutions, Xact Accountants could be a great resource:(https://xactaccountants.co.uk/).
-
Niels commented
Read Xero's replies people. The bank feeds are a source of revenue for them - that's why it's a closed institutional API only.
We'll never get open access on our end of the API.
-
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!