Skip to content

I suggest you ...

← Accounting API

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

2,394 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
salo shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Streem Connect commented  ·   ·  Report

    Can somebody please explain what the point of this API actually is? Not being able to access bank statement lines or import from alternative feeds makes the whole thing redundant. End of

  • Michael Lubbe commented  ·   ·  Report

    We would love if the bank statements will be available for our forrensic accounting app.

  • Anonymous commented  ·   ·  Report

    To sum up for those who are coming to this issue fresh. You currently cannot access the statement lines from the "Bank Statements" tab via their API. You can access some of the lines through other API end points, but not the whole list.

    For context, this has been an issue since 2009. That's over a decade ago.

    It has over 2,000 votes to be resolved, more votes than any other issue, combined.

    Their competition, Sage, allows for it (https://developer.sage.com/api/accounting/api/banking/).

    This leaves me to think that Xero have painted themselves into a corner with the contract they have signed with their banking data providers, and are not allowed to.

    It's a real shame, and a huge black eye on a platform that otherwise is becoming an industry standard.

  • Daniele Ricci commented  ·   ·  Report

    Is it really required to say why having this API to automate the process would be better than having to do it manually?

  • Lance commented  ·   ·  Report

    This would be really nice to have, we currently have people doing this manually, I'd rather have them doing something more meaningful with their time.

  • Anonymous commented  ·   ·  Report

    We need this! It would be a game changer

  • Abitama Satria commented  ·   ·  Report

    (Edit: public bank statements API will be very useful for non-financial institute, eg. accounting firm)

    I couldn't agree more with Mason Chase's and Anonymous's comment (from June 22, 2019). This API will help developers and, in turn, help every Xero user in speed up their reconciliation process. Not even mentioning they whose bank don't have a direct feed into Xero.

    I know the pandemic is still there, but I hope you can come up with this soon enough.

  • Faisal commented  ·   ·  Report

    It would be a best decision ever

  • Gerhardvr commented  ·   ·  Report

    Not having an API that we can utilise in the case where our financial institutions are not partnered with Xero, is crucial. Frankly, for Xero to assume that South African banks, for example, would like to integrate into Xero is the pinnacle of self grandeur. SA bank couldn't care less about Xero, since Xero doesn't really feature in the bigger scheme of things in South Africa.

    We receive daily bank statements from our banks in various formats (SWIFT etc) and have the ability to process these files into a format that can manually be loaded into Xero. However, manually loading them into Xero is a useless exercise. We receive statement files from our banks every time a transaction goes through our bank account. We want to load the data into Xero as we receive the data. This simply cannot be done manually. The only option is an API which is not available.

    Frankly, this is most probably going to cause us to seriously look at migrating away from Xero.

    Looking at how many comments this thread has had since Jan 2021, I suggest you seriously review your stance on this point.

  • Anonymous commented  ·   ·  Report

    The sad irony about Open Banking is the removal of Irish banking institution feeds from Xero due to Brexit and the inability of the end user to utilise any API to plug the gap. This is wholly insufficient and we're currently looking at how to migrate away from Xero as we're exposed without any ability to move forward with either semi-automatic or fully automatic bank statement feed imports.

  • Mark Ogilvie commented  ·   ·  Report

    Irish customers are losing bank feeds due to Brexit, with Xero being registered in the UK.
    Our site at https://tools.parolla.ie can convert bank statements to Xero readable format, but if I had access to an API endpoint that created statement lines it could also import the lines directly to Xero.

  • Tim Andrews commented  ·   ·  Report

    Yes please we need this to help our customers

  • Anonymous commented  ·   ·  Report

    +1 - using custom accounts for payment processors!

  • Mike Cox commented  ·   ·  Report

    I really would like this feature as I have several custom bank accounts e.g. suppliers who take an upfront payment and then chip away at that balance invoice by invoice. I need to account for this on Xero and I need to be able to upload the transactions so that I can manage this money.

1 3 5 … 9 10

Accounting API: Banking

Categories

Feedback and Knowledge Base

(thinking…)