Reconcile via the API
Be able to reconcile bank statement lines via the API.
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.
Hugh Mc Manus commented
+1 For this also. What a shame this is not available.
Not sure how open banking would help with this since I would then have to register as a data recipient just to get access to my own transactions in my own bank account. As mentioned by Charlie even the limited data would help.
My use case is to find the un-reconciled transactions so that I can search in my communication system for the invoice sent to me to make sure I have a record of it stored.
Oh well I will have to stick with the automation tools provide until this is available.
+1 for this, it seems unfathomable that we are unable to access unreconciled bank lines; even limited data such as the reference, date, amount and ID (xero) would suffice. This would at least allow us to advise accountants/verify. Ideally, we should be able to then allocate via the api.
The current use case this is prohibiting is reconciling a third-party payment provider. We already upload/create the invoices in Xero and are aware of the exact amounts, bank reference and date of the transaction but are unable to reconcile these. It's imperative due to volume and accuracy to be able to reconcile these automatically as credits are deducted from payments received, thus information isn't directly available in Xero making reconciliation difficult.
We need to be able to build a reconciliation feature to enable an important use-case for our customers. Please enable this.
Dominic Dicoco commented
This is really needed. It would only be of benefit to Xero to allow developers access to your platform.
Marvin Osswald commented
i've got about 50000 transactions from online e-commerce i have to reconcile at the moment. Fair, it's historic data but i expect about 50 new ones a day. This would be the easiest to automate from my platform as my e-commerce system knows exactly what tracking category to attach. Manually i'm not even sure if its viable.
I'd love to vote on it but can't, you guys have a great api and a very good product please don't have it ruined by politics...
Russell Williams commented
Come month end, we have over 170 Xero Subscriptions that need to be reviewed and activity statement summaries created. Without an ability to confirm that the Xero Subscription has been reconciled for the month against all their bank feed this is impossible. So even if the full feed can't be sent through, can some information that will enable read only analytics access determine if all bank feed transactions have been actioned and reconciled for month end processing?
Graham Belmont commented
We need this - even a read-only version - so badly! Whyyyyyyyyyyyyy can't you add this!!!
How is this not available???
Bank statement sync and this are very much needed.
reconciliation api would be brilliant
Rajesh Prasadh commented
Need an api through which i can keep my xero account updated with my transactions on a daily basis.
timothy ji commented
Can we provide the sync bank statement api first? we don't need get history, only need sync the new bank statement.
Richard Christian commented
What is happening here? All I want to do is allow my staff to see what payments have been received in the last day so they can release equipment. Very basic. But I go through paying the subscription and setting up the whole thing just to find that obvious and needed option is not available??
Alex Soul commented
Please add an option to view Uncoded Statement Lines. There is a report for it already - can we access this report over API?
hari salabashyan commented
Reconciliation via the API is critical business functionality. Please consider enabling this feature.
Nicolas Emmerich commented
Since we can't vote, consider this comment a vote.
Brendan Gooden commented
Reconciliation via the API is critical to our business operations. Please implement ASAP and listen to your customers!
Alex Soul commented
Hi, I need to be able to count how many transactions are still unreconciled and from how long ago. I need to ensure that our bookkeepers are doing a Great Job and there should not be any unreconciled transactions pending there for longer than X days. I am not able to keep checking this myself on a daily basis.... so, a basic API access to at least READ-ONLY would be highly beneficial for this checks
Is there perhaps a way to just initiate the reconciliation process and identify how many, if any, statement lines remain unreconciled?
Shane Russo commented
Can you please provide an update to this feature?
Reconciliation via the API is critical to my business. Without it I will need to look at alternate products to Xero.