Skip to content

I suggest you ...

← Accounting API

Reconcile via the API

Be able to reconcile bank statement lines via the API.

711 votes
AdminXero Developer Platform (CEO / Founder, Xero Developer Centre) shared this idea  ·   ·  Report…  ·  Admin →
declined  ·  AdminXero Developer Platform (CEO / Founder, Xero Developer Centre) responded  · 

Hi everyone,

Firstly, apologies – it’s obvious from the continuing comments that we declined this request too hastily and without the explanation it deserved.

We know that reconciling would be a valuable API feature, but reconciling requires fine grained access to bank statement data and unfortunately we’re not able to share that data via the API for commercial reasons.

At Xero we’re passionate about having an open API and providing small businesses with open access to their data. Unfortunately, many of the partners we rely on for statement data don’t share the same ideals.

Hopefully change is coming in the form of open banking. However, it will be a long time before we can openly share statement data via the API and provide a decent reconciliation experience to third-party apps. For that reason we will unfortunately leave this request as ‘declined’.

For the immediate future, we’re busy doing some really cool stuff to improve the in-product experience and automating bank rec as much as we can. We already have bank rules, auto-match, suggestions and cash coding but there’s lots more coming this year.

Again, we apologies for our lack of transparency on this thread. We do value the feedback on UserVoice and have shipped features with over 3000 votes in the last 12 months. We definitely dropped the ball on this one though.

Cheers,
Adam

Show previous admin responses (8)
Signed in as (Sign out)
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Report

    Yes a must have feature! Xero you shouldn't be taking all these comments lightly

  • Anonymous commented  ·   ·  Report

    Oops I flagged as inappropriate by mistake...!!! undo undo

  • Anonymous commented  ·   ·  Report

    Reconcile via the API, yes! WE MUST HAVE THIS.

  • Sina Bahrami commented  ·   ·  Report

    Is there a way of pulling all (including the unreconciled) transactions via an API? At the moment, I'm only able to pull the reconciled ones via the "banktransactions" API.

  • Mark commented  ·   ·  Report

    I'll chime in with my specific use case, just in case it's helpful to Xero in the future. When my customer pays me via Stripe, I listen for the Stripe Webhook and fire off a Receive-type BankTransaction to Xero. I mark it as reconciled when I create it because I run a cron job every hour that compares the balance of the Stripe bank account in Xero against the balance of Stripe in Stripe itself. Therefore, I'm practicing continuous reconciliation rather than reconciling periodically. Unfortunately, sometimes when my customers pay me by ACH through Stripe, their payment bounces do to insufficient funds. In those cases, I'd like to delete that BankTransactionID in Stripe to keep the balances reconciled.

  • Talal commented  ·   ·  Report

    Must have ASAP. Clients want this.

  • Richard Howard commented  ·   ·  Report

    Seriously needs to be a feature. Automating the reconciliation process cuts hours of work each week (if not more) if this task is automated (we are copy-pasting what the API could do for us!).

  • Anonymous commented  ·   ·  Report

    What can you do with the Xero API in terms of reconciling bank lines?
    From an accountants perspective, is it possible build a web app that would display the unreconciled lines?

  • Mark Stephenson commented  ·   ·  Report

    For us to continue using xero as we continue to grow (1000 users to 12000 in a year) we need to be able to automatically reconcile stripe payments. Allowing reconciliation through the API will give us the ability to automate this very laborious task.

  • Anonymous commented  ·   ·  Report

    Please either improve the memory function to remember payeee name from bank lines or allow reconciliation via the API

  • Alex Rich commented  ·   ·  Report

    We are considering changing from Xero to something else. Pushing 'Reconcile' for all incoming payments is a big waste of time when our payment system could automatically reconcile them as they are applied to customer accounts.

    I can't imagine what the 'significant issues' that prevent Xero from working on it are.

    Some people (like us) use Xero only for our tax obligations and 'big picture' reports. It's easy for the Accountants to collaborate with us, but not everyone uses Xero Invoicing and links their customer accounts to Xero.

  • Anonymous commented  ·   ·  Report

    We receive an average of 20 transactions a day into Xero through Stripe, in 2 different currencies, and reconciling them is a really time-consuming process and one that seems perfect for automation considering how repetitive it is!

    Allowing this feature would allow us to save lots of time and money spent on bookkeeping.

  • Anonymous commented  ·   ·  Report

    Please guys can you add this feature. We want to have different staff members reconciling payments but as xero is setup our staff will be able to see the full state of accounts which is not acceptable.

    We want to be able to isolate an account and allow access to specific users on our internal software to reconsile incoming payments to open invoice's

    This feature is a must for our growing business. Either this or some upgraded user types in xero that would allow us to give access to reconcile one account without been able to see everything else..

  • Johnny Oshika commented  ·   ·  Report

    A lot of our reconciliations are repetitive, and being able to do this automatically through the API would be a huge time saver.

  • Colin MacLeod commented  ·   ·  Report

    +1 vote from me
    We are using the API extensively to integrate with our POS system and this would make life easier.

  • Anonymous commented  ·   ·  Report

    I need this because I have a lot multi-currency transactions that I need to reconcile - the currency value from my bank statement doesn't always match the receipt so I was hoping to do this programmatically with an algorithm that makes smart assumptions about the most likely transaction -> receipt reconciliation.

1 2 … 7 9 11

Accounting API: Banking

Categories

Feedback and Knowledge Base

(thinking…)