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
- Update September 2016 -
We appreciate that this is a highly demanded feature but it is not on the current roadmap.
We’re looking at tackling some big features in the next 3-6 months including practice-level auth (XeroHQ API), webhooks and a new developer portal. That means an API for importing bank statement lines is unlikely to be built in the forseeable future.
Once we’ve shipped some of those higher priority features we’ll re-evaluate the status of this one.
This should be your high priority feature. Please think again
Josh Goodall commented
If there's no API, how are Silver Siphon doing feeds from Stripe / PIN? A mechanical Xero user-agent pushing up CSV files?
David Earl commented
Disaster. Having just started trying to use the API, I find I cannot do this most basic of things, and have to do it manually by file transfer.
In general I've found the API to be terribly lacking in all sorts of areas. If you used the API to implement your own UI, you wouldn't get into this mess, you'd implement things as a matter of course. Clearly you *have* an API of sorts, but its just not the secured, public one.
Please edo this as soon as you can.
Jason Lane commented
Wow. This is the second feature that I've found lacking from Xero, and I'm so disappointed to find that this feature request has ALSO been languishing for years, with no hope in sight. It's so frustrating, because there's so much I love about Xero, but I'm really starting to wonder where your development efforts and priorities lie. They certainly don't seem to be aligned with what your customers are asking for.
Pls add this feature
Please do this
Adam, thanks for your update. But "planned" means "planned", not "we’re actively listening to your feedback and watching these pages".
If it's not on Xero's roadmap, then it should not be marked as planned.
If you're going to say something is "planned" when in fact it's not on the roadmap, then you really shouldn't be surprised when people get annoyed.
Nick Dorogavtsev commented
So.. there are solutions.. now ones that work entirely with the API for secure access.
this is a simple integration - syncs Stripe transactions, fees, transfers, refunds etc as a Bank Feed into your xero account.
While a direct integration would be great, this is almost real-time transaction data into xero.
Greg Gage commented
We have been using the CSV import option for years, in the hopes that this feature would be implemented. I agree with the previous posters, that the response has been abysmal. Someone from Xero has copied and pasted the same response 3 times, in what can only be seen as an elaborate ruse to convince the community that you are actively looking into this issue, and we should hear back in 6-9 months.
I understand that schedules can slip. But it would be nice to give us an honest answer as to why this is a security risk any more than other APIs. Or a licensing issue? Both of these seem to not make sense.
Given that this highly popular request has been getting kicked further and further down the road for years - and I do mean *years* - I guess we shouldn't expect ever to see it in our lifetimes.
What's the point of using a platform like uservoice if you just ignore the feedback?
Tim Evans commented
Can you please look into this ASAP, we have 350 organisations we would like to post bank transactions to on a regular basis.
Either update the API or give the ability to do the manual import of a bank statement at a 'practice' level instead of each individual organisation.
UBS and Deutsche Bank integration would be fantastic!
Neil Brown commented
I agree that this needs to be added. I have over 150 bank accounts and the current api does automatic import fails due to the volume of transactions. I need to be able to import on my own to speed up the process
Would highly appreciate a integration with Deutsche Bank in Germany.
I'd like to run my business on Bitcoin and be my own 'bank' and import my own 'statements'.
Markus Schmitz commented
Being able to import bank statements via the API (either by automated file upload or line by line) is essential for us. This will lead to such a dramatic improvement of our accounting procedures!
Yoddle does not support any bank in my country and I would not expect them to do so soon.
Is there a way to sponsor in Xero such an development? Maybe by temporary increasing the monthly fee for a while?
Thanks for the article on existing API options but none of them have anything at all to do with importing statement lines.
It's been more than a year, and I think it's time this one got pushed to the top of Xero's to-do list.