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
-
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.