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


-
Rod commented
this would be great so we would be able to develop a solution for non supported banks or other importing method.
-
Matthew Gertner commented
I commented on this almost a year ago. Since then our assistant has been importing our bank statements daily by hand. It would be really nice to have this API!
-
sysret commented
this would be great so we would be able to develop a solution for Swiss based banks
-
Andrew Tipton commented
Yes please, this would allow me to integrate with banks which are very unlikely to ever be supported by Yodlee.
-
Prime commented
Yes please! This would also allow us to get a Stripe integration going.
-
Matthew Gertner commented
Our bank (Raiffeisenbank) doesn't have a supported feed, so I configured it to send us bank statements daily by email. I think spent a couple of hours hacking together a Python script that downloads the emails and parses the bank statements. The missing step is to import the statements into Xero via the API (I can easily generate OFX, QIF or CSV). Unfortunately I gather that there is no way to import a statement using the API.
We'll import manually for now but since we are receiving new statements from the bank everyday, it would be fantastic if my script could simply import them automatically (essentially simulating the automatic feed).
-
norbu09 commented
it would open up the import of bank feeds and other bank like accounts (like prepaid accounts) that actually have an API but will never be included in xero natively. i have to create a CSV from those feeds now and then manually import them, that feels quite wrong.
-
mdonseif commented
-
mdonseif commented
You might wan't to transver SWIFT-Style mt941 Bank transactions into OFX by using https://github.com/hudora/pyBookkeeping/blob/master/bookkeeping/mt940toOFX.py - not perfect but works since Xero can nicely import OFX data.
But then again: Importing OFX via the API does not work.