Skip to content
← Xero Developer Ideas

Settings and activity

1 result found

  1. Import bank statement lines via the API

    998 votes

    We're glad you're here

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

    We’ll send you updates on this idea

    240 comments  ·  Accounting API » Banking  ·  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
    working on it  ·  AdminKelly (Admin, Xero Developer Centre) responded

    Thanks for your continued feedback and patience on this long-standing request. Our team has started to build this out, and we’re looking forward to sharing more as development and testing progresses.

    This release will support ingestion of bank statement data via the Bank Feeds API for accounts where a bank feed has not been established and allow customers to automate the current manual file upload process.

    As part of this work, we’ll be running a beta with a small group first (from mid June) so we can test the experience and gather feedback before broader availability. We’ll continue to post updates here as we reach key milestones.

    An error occurred while saving the comment
    Colin commented  · 

    Hi Andrew,
    I've used a solution called Pentaho's Data Integration to read my bank statements and create a Xero compatible CSV file. It has a community edition meaning you can download and setup for free. You can also create recurring jobs using windows task scheduler so all our accounts guys have to do is drop the downloaded statement into a folder, then "magically" a formatted file appears, ready for upload.

    Once the Xero team finally releases this feature, I'll modify my Pentaho integration to push the files into Xero automatically.