Unreconciled items in the bank feed via the API
Allow the count and or the list of unreconciled items in the bank feed to be exposed via the API
-
B R commented
I would strongly support Xero reconsidering this position. The current response seems to treat all access to unreconciled bank statement lines as broad redistribution of raw bank data to third-party apps, but that is not the only use case being requested here. Many customers are asking for read-only access to their own bank statement lines, inside their own Xero tenant, under their own OAuth consent, for internal automation and reconciliation workflows. If the data can already be viewed in Xero and exported manually by the customer, it is difficult to understand why the same customer cannot access it through a controlled API scope with appropriate limits, audit logging, app review, security addendum, or certification requirements.
MYOB appears to support this type of customer-side workflow through its Business API, where bank statement transactions already present in the customer file can be retrieved via API. That suggests this is not an unreasonable or unusual accounting platform capability. I understand Xero has legal, banking and risk considerations, but the current all-or-nothing position materially limits Xero as a financial platform for SMEs who want to build better AP, reconciliation, reporting and AI-assisted workflows around their own data. A restricted, customer-authorised, read-only pathway would be a much more practical balance than forcing customers to bypass Xero and source the same banking data elsewhere.
-
Joel Mansford commented
I have just spent hours thinking I was missing something, I was writing something to pull unreconciled bank transactions then, using an LLM, email people responsible for each supplier.
The lack of this in the API blocks CRITICAL possible automation. -
Peter McCarroll commented
No, we've been waiting 15 years! With Xero now actively blocking screen scrapers and not allowing AIs to download reports, this is a critical failure. Everything should be available via the API/MCP!!
-
Faye Dexter commented
How is this not available yet?
-
Sven Weisswange commented
now waiting almost 7 years. it sucks
-
Andrew
commented
Even better would be an API that just gave read access to all bank statement lines, including the text of the particulars, as that is very useful when deciding whether we have an appropriate gift aid declaration on file (donations are often paid by a family member other than the one who is the actual contact).
-
Ryan Barker commented
Seems I'm not the only one. This would be super handy.
-
Beau Gaudron
commented
If this was possible its a good start to the automation of other workflows via the API, without it many of them are just not reliable.
Things like are there uncoded transactions to the end of a BAS period / end of Month would be very helpful
-
Ash
commented
Pick up your game, Xero! We need this
-
Teoneonline commented
please add this feature
-
M
commented
I see this thread has been receiving votes for 6 years!!!
I cannot see why this Xero data is not available from the API.
This is Xero data like any other.
The request here is to be able to obtain the list of transactions that Xero beleives to not yet be reconciled.When will it be provided please.
-
Julià Pujol commented
4 years people asking for it, yet no one cares from Xero. Unbeilable
-
Georgios Diamantopoulos commented
I mean, Jesus. How is it that Xero only cares about what's going on inside Xero and we can't build any serious integrations?
-
Jeff Stephenson
commented
Clients who want to report cashflow are asking for this feature
-
M
commented
Please add this feature to the API. This is a large gap in the current offering.
-
Nicky Ward commented
how on earth is this not a feature ? get it sorted Xero
-
TC
commented
I need to be able to share bank transactions that have not been coded. The API not sharing this data has ended a few days work. Posting here incase Xero wakes up to this omission
-
Alex Soul commented
Just came here to check if any progress or decision has been made.... sadly, still nothing :(
-
Niall Hartigan
commented
Very big omission!! Xero is great for an individual business but really lacks when trying to consolidate Orgs... The API could compensate for this but this one is a must have to be able to prepare consolidated cash statements and to provide credit card spend oversight for people managers. Surely this one is 101?
-
Daniel Blaney commented
This would enable so much automation around nudging end users on bank reconciliation. We have clients who want email/Slack/Teams notifications for this and it's just not possible currently.
I'm not convinced anyone at Xero is monitoring uservoice any more but worth a try.