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.
This is needed at least to import budget actuals with link to their tracking IDs, in order to compare budgets in an external analytical tool.
Agree with everyone here, it is needed in the API endpoints
oshada perera commented
We are a telco company and will able to get the obvious invoices get reconciled. So that bookkeeper doesn't have to bother with obvious ones.
Data matching is hit and a miss, therefore we have seen that bookkeeper keep on pressing ok sometimes even for incorrect matches.
If we can get reconciling done via api, and leave human intervention for non obvious ones that's going to save alot of hassle
Michael Schwartz commented
This is a necessity
Nick McGrath commented
"commercial reasons".... i.e. force people to use GoCardless and Stripe for automatic reconcilling type functionality to get fees and commissions, rather than make free transactions via direct deposit/bank transfer too easy for the customer...
I understand the decline for this type of feature but it could be done without sensitive data breached. Example: a feature in the api where you can only POST the data to xero. If a match with payment reference matching, invoice, reference, account name or account number is matched with a total
amount match found inside xero it will reconcile and just return a success with the invoice that was reconiled or no success message if failed to find anything. This way no bank data information is passed outside of xero.
Pete Everett commented
Suryakant Patel commented
is there any aip, where we can get unreconcile list? I aware of api method "GetBankTransactionsAsync" but its not return all bank unreconcile items list, its returns only "Account Transactions" list
Stephanie Hope commented
Yes please to this! We want to be able to auto-match transactions so a reconciliation endpoint is needed.
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.
Another +1 vote for this so we can auto-match transactions
Phil Dominick commented
+ Vote for this as we need this data to auto match transactions
We'd also love API access to reconciliation data! Consider this a +1
Anon Also commented
We need a solution for this asap!!!! Please open this up and not decline.
Anon Also commented
<reconciling requires fine grained access to bank statement data> This is 100% incorrect. All that is needed is the date, amount, and who it's from (contactID), plus the ability to match it with one or many charges. The charges are available in the API already.
Can you please expand your thinking on this? It doesn't make sense and is frustrating the executives in our company as they're continually having to monitor this frustrating manual process. I convinced them to switch to your software and now I look like a complete idiot since you closed this. Ugh!
Hi, this feature is a must for us. Would completely eliminate the need for a very time-consuming and error-prone manual reconciliation process. We often receive a single payment for 100+ invoices, and reconciling this manually in Xero is ridiculous.
Mason Chase commented
We have made an app that assist an accounting firm and large team to import statement, manage tasks for transaction and reconcile them,
this feature is very important for us to automate since Xero design has limitation and we can't achieve this goal without API
I would like an extract from xero of the actual bank statement lines as a way of quantifying any large un-reconciled items for cash flow purposes as opposed to actually reconciling outside of Xero