Skip to content

Settings and activity

3 results found

  1. 43 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Matthew Bloch supported this idea  · 
  2. 71 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Matthew Bloch supported this idea  · 
  3. 279 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Thank you for the continued feedback and for your patience on this long‑running request. We know that programmatic bank reconciliation and AI‑driven workflows are increasingly important to many of you, and we understand the frustration that this capability is not available via the Xero API.


    After reviewing this again with our legal, risk and banking teams, we have confirmed that we will not be adding the ability to reconcile bank statement lines via the API or to expose unreconciled bank statement data via the public API.


    There are a few key reasons for this decision:

    1. Regulatory and contractual obligations on raw bank data. Unreconciled bank statement lines are “raw” banking data – unmodified information that comes directly from banks. In markets such as Australia, this data is treated as banking data under consumer data rights regimes. Sharing it on to third parties (including via an open API) would require us…
    An error occurred while saving the comment
    Matthew Bloch commented  · 

    To Aaron, if you are only ever reconciling one payment for multiple receivables, you can do this via the API. If you submit a BatchPayment with all your invoices lined up against the payment, the reconciliation screen will show that payment in green and let you match it up with one click.

    (the same applies for payables)

    What doesn't work is where you receive a payment for multiple invoices, minus the amount of a bill. It's annoying because you can mark these off against the payment manually, so Xero clealy understands that it's possible. But you can't yet automate it.

    An error occurred while saving the comment
    Matthew Bloch commented  · 

    Hi! I'm also frustrated by the lack of a reconciliation API.

    But when Xero say that "reconciling [via an API] requires fine grained access to bank statement data" - they're wrong!

    Sure you can design the API to expose a BankTransactions endpoint, and you'd hit the contractual objection that has apparently blocked this idea for years. That'd be easy and nice and useful but OK - we can't have that.

    Instead - add a new API end point for a "ReconcilationHint" - this could be an extension to the manual Bank Rules, or something new.

    As developers with access to external data, we know that a particular bank transfer will have come in for a certain amount, within certain dates.

    We could tell Xero via this new API "hey, when you see a transaction for £100.00 within a week of September 1st, go ahead and mark it off against Invoices 1, 2, 8 and 47".

    Xero could say "thanks, I see 1, 2, 8 & 47 add up to £100, I'll bear that in mind!"

    Then when it comes to the manual reconciliation, process Xero can take that as a firm instruction to mark those off automatically (or to auto-select them in the current manual process).

    That would at least fulfil *my* reconcilation wishlist, where I need to mark off invoices and bills against a single bank transfer, which the current front-end makes particularly painful. I don't need access to the bank feeds, and I suspect with some more creative API design, they could pick off other use cases in the same way.

    There would be some more design work to do, and would might need another reconciliation front-end - like what if a hinted reconciliation *hasn't* come in? That's a useful thing to know - but even if you could just query previous hints to see if they've been matched, that'd be everything a developer needs to build fully automated reconciliation.