Reconcile via the API
Be able to reconcile bank statement lines via the API.
- Update October 2015 -
Unfortunately reconciliation via the API is not a planned feature for the short-medium term.
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/
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.
Hello everyone, we know this has been a longstanding request, but a number of security and licensing issues have prevented us from providing this.
Gareth Lawrence commented
A must have
Please either improve the memory function to remember payeee name from bank lines or allow reconciliation via the API
Alex Rich commented
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.
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.
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
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
+1 vote from me
We are using the API extensively to integrate with our POS system and this would make life easier.
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.
Add votes from me. We pay bills for our clients and it would be great to reconcile them once the checks actually hit the bank account.
Another couple of votes from me. We run some software to import Stripe transactions on behalf of clients and it would be great to then automatically reconcile them
Kim Richardson commented
We process direct deposits through an external payment source, we set a merchant reference and the bank posts the reference number. Would be great to be able to auto reconcile this via an API that can match up the payment.
Jacob Gur commented
The problem with the suggested solution is that you still can't match the specific invoices with the deposit. The clearing account is basically treated as a pool of money.
This feature is VERY important to our business. We receive lump deposits which are related to several clearing accounts. It is impossible for us to manually break down every deposit and determine the proportion associated with each clearing account. An API would be the only solution. I believe this would make Xero a very powerful tool.
Adam Law commented
This is very important to me even as a sole operator
Peter McCarroll commented
In addition, or as a substitute, we also need to be able to create payment batches through the API (groups of invoices/bills under a single Payment transaction in the bank ledger). This would alleviate a huge issue people are asking for here.
Ross Stanley commented
As a manufacturer who sells product to supermarkets, we experience high volumes of invoices and credit notes (over a hundred per week) which are covered by a single payment from the supermarket's head office (for the month). In these cases the UI provided by Xero for this task is totally inadequate.
What accounting software package are other manufacturers using that solves this problem?
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?
What they said.
Ian Bishop-Laggett commented
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.
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!