I suggest you ...

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

126 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    salosalo shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    10 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Jiro OlcottJiro Olcott commented  ·   ·  Flag as inappropriate

        Yes! this feature is important to us. We have a main UK based Head Office (Xero UK Version) and 7 subsidiaries in different countries (Xero Global Version). We use one bank (HSBC) for all our accounts (UK based). We automatically upload all the bank statements into the Head Office company then distribute the banks statements to each subsidiary for reconciliation. It has to be done this way since the HSBC Partner Feed only works for Xero UK Version and not for the Xero Global Version.

      • RodRod commented  ·   ·  Flag as inappropriate

        this would be great so we would be able to develop a solution for non supported banks or other importing method.

      • Matthew GertnerMatthew Gertner commented  ·   ·  Flag as inappropriate

        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!

      • sysretsysret commented  ·   ·  Flag as inappropriate

        this would be great so we would be able to develop a solution for Swiss based banks

      • Andrew TiptonAndrew Tipton commented  ·   ·  Flag as inappropriate

        Yes please, this would allow me to integrate with banks which are very unlikely to ever be supported by Yodlee.

      • PrimePrime commented  ·   ·  Flag as inappropriate

        Yes please! This would also allow us to get a Stripe integration going.

      • Matthew GertnerMatthew Gertner commented  ·   ·  Flag as inappropriate

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

      • norbu09norbu09 commented  ·   ·  Flag as inappropriate

        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.

      Feedback and Knowledge Base