I suggest you ...

Reconcile via the API

Be able to reconcile bank statement lines via the API.

220 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…)
    xeroAdminxero (Admin, Xero) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    under review  ·  xeroAdminxero (Admin, Xero) responded  · 

    Reconciliation via the API is not a planned feature for the short-medium term as we look to address other feature requests.

    For some of your scenarios consider using the approach described in our guide for handling payment processor receipts in Xero could be a whole lot more efficient. http://developer.xero.com/documentation/api-guides/handling-payment-processor-receipts-in-xero/

    Even if you have a statement line for every invoice payment (rather than a statement line equalling many payments) you could utilise a clearing account to pay off invoices and then use Xero cash/fast coding to code all the bank statement lines of a similar pattern to the clearing account.

    While we will continue listening to requests on this thread, there are a number of significant issues that prevent us from working on this for the time being.

    24 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...
      • Anonymous commented  ·   ·  Flag as inappropriate

        Any updated on this as it seems the community really requires this feature?
        We too have a use case where this missing feature prevents us from full integration into Xero.

        Can someone from Xero please comment or give any updates on this request?

      • Ian Bishop-LaggettIan Bishop-Laggett commented  ·   ·  Flag as inappropriate

        Like many of the comments above, we have a front end that records invoices, payments and the allocation between the two. It is also possible to know to which statement line those payments belong. Credits cards appear on the bank statement as one line, but we know which payments make up that line and to be able to mark them as reconciled to that line would be great. It's a very manual task at the moment.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Hi there - we're developing an app at the moment that will receive hundreds of transactions per day, and there's no way that we'd be able to manually reconcile all of them. We've only just come up against this limitation in Xero and it's real show stopper.

        Please API reconciliation would really help!

      • Anonymous commented  ·   ·  Flag as inappropriate

        We currently import over a thousand lines from a paypal account a week. The largest account Xero has is 1000 reconciliation. So it seems to me that Xero is concerned about the number of transactions in their resources. With paypal I'd love to see the option of not importing every payment and fee - but rather every days total fee and received. The only problem with this is for money spent. I need all money spent imported. Doing this manually would make me very :-(

      • Craig LukeCraig Luke commented  ·   ·  Flag as inappropriate

        We use your suspense account suggestion, and it's an absolute pain to reconcile large numbers of transactions. Please, please add reconciling to your API and reduce the time we have to spend manually reconciling things!

      • Andrew SmithAndrew Smith commented  ·   ·  Flag as inappropriate

        We have about 7,000 client invoices with matching bank lines (credit card and cheque account incoming amounts). This week Xero basically konked out, and we can no longer reconcile through the site. Support tells us that Xero is only designed for 500 transactions a month.

        I'm not sure whether Reconciling via the API would work, but I can successfully retrieve invoices and bank transactions, so I can only assume that it would be possible.

        It is a sad, sad day as we have to contemplate another accounting page that doesn't have Xero's limitations.

      • Josh StuartJosh Stuart commented  ·   ·  Flag as inappropriate

        +1.

        At least allow an auto reconciliation flag for any matching rules. We have 1000's of micro transactions each week to our Paypal account and right now it's a pain to manually approve in the bank feeds.

      • nicknick commented  ·   ·  Flag as inappropriate

        +1
        we are making payments with reference numbers, and the invoices that they apply too. it would greatly help us if we could reconcile the data via the api.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Yes please, full reconciliation is a killer otherwise as has been pointed out by other commentators here

      • Evan WilliamsEvan Williams commented  ·   ·  Flag as inappropriate

        +1 for us here at Tradevine. We would love to be able to a.) Reconcile large batch PayNow payments against individual invoices and b.) just generally reconcile payments that match up to invoices with matching amounts and purchase references.

      • Scott BarberScott Barber commented  ·   ·  Flag as inappropriate

        I would be very keen to allow reconciliation through the API. I can see the potential to allow more sophisticated "bank rules" or even to allow automatic bank rules being applied via an "add on" interface through the API.

        I think there is potential to make the interface to coding bank statements a lot smarter to allow bank rules to be more robust and push more information through to the final journals. e.g. "Copy description", or to allow more generic rules to be created.

      • Anonymous commented  ·   ·  Flag as inappropriate

        We receive money via a direct debit clearing house and currently allocate this payment against hundreds of invoices. We plan to build a system to hand this allocation and reconciliation for us.

      • Tim CullTim Cull commented  ·   ·  Flag as inappropriate

        My use case is also a SaaS app. We'd have hundreds of transactions each month from a subscription payment provider (like Recurly) that we can create invoices for, but then have to reconcile by hand.

      • Anonymous commented  ·   ·  Flag as inappropriate

        We make a SaaS app and we have hundreds of transactions paid by PayPal every month. It is super easy to generate a Xero invoice (via API) for each transaction, and it is super hard to reconcile all all these invoices with the lines in the PayPal statement. We know exactly how to match statement lines with invoices (we put PayPal transaction IDs as reference on an invoice), yet there is no way to automate it with Xero. All we need is a way to tell Xero to reconcile particular bank account statement line with the given invoice.

      • Anonymous commented  ·   ·  Flag as inappropriate

        We provide SaaS app and we have hundreds of transactions paid by PayPal every month. It is super easy to generate an invoice for each transaction, and it is super hard to reconcile all these invoices with the lines in PayPal statement. We know exactly how to match statement lines with invoice (invoice has the PayPal transaction ID as reference), yet there is no way to automate it with Xero. All we need is (1) a way to to retrieve a list of Bank Account transactions, (2) a way to tell Xero to reconcile bank account transaction with the invoice.

      • David CollenDavid Collen commented  ·   ·  Flag as inappropriate

        I import my invoices and bank transactions directly from my Web Store. I'd like to be able to reconcile these automatically against my bank feeds, eg from Paypal using the transaction ID

        Please consider implementing this functionality via the API, it really would be useful.

      • BrianBrian commented  ·   ·  Flag as inappropriate

        This sort of feature is becoming critical for us. We have a large number of invoices that are paid each day into our bank account via a batch payment. Currently this means manually finding each invoice and matching it with the bank statement. This is a major pain and waste of time and is only going to get worse as our business grows.

        Please consider adding API support to allow us to feed in a list of invoice numbers in a batch and match that automatically with the bank statement.

      ← Previous 1

      Feedback and Knowledge Base