Allow API Access to run the Bank Reconciliation Report
In lieu of being able to interact with the Bank Feed information directly via the API - it would be useful to be able to run the Bank Reconciliation Report directly from the API.
The use case in mind is:
I would like to set up a proactive notification when there are incoming amounts that are not reconciled in Xero in order to prompt someone to go in to Xero and manually reconcile those items. This will help prevent our customers from getting automated invoice reminders when they've paid.
We're not at the point yet where someone is in Xero everyday to see the incoming payments - so an email notification I can customise (in terms of frequency, content, etc) would be really useful.
Owen Conti
shared this idea
-
Alesha Scott
commented
As we continue scaling our operations to manage accounting for hundreds of organizations in Xero and generate weekly reconciliation reports for each one, access to this API is absolutely essential. Until this functionality becomes available, we need a report that provides the same information.
If we can retrieve bank balances directly from financial institutions and compare them against bank balances in Xero across all organizations in bulk, we can quickly identify which accounts require bank statement lines to be uploaded. This eliminates the need to manually review every account individually, saving significant time and effort.
In addition, having visibility into bank statement line transactions with an "Unreconciled" status would allow us to generate a consolidated report of items that need to be recorded in Xero. This would enable us to process these transactions at scale rather than relying on our current manual workflow of extracting data from Xero and compiling it into lists for processing. The existing process is extremely time-consuming, inefficient, and difficult to scale.
-
Michael Garrett
commented
Adding a 2026 perspective: vision-capable LLMs (Claude Haiku, GPT-4V) have made automated structured extraction from receipt PDFs trivially cheap. For small businesses building personal receipt-matching tools, the bottleneck has shifted entirely to the Xero side - programmatic access to unreconciled statement lines for one's own org.
The current workaround is to manually export the Bank Reconciliation Detail report from the UI then parse the xlsx. Functional, but adds a manual click per tranche and prevents unattended/scheduled runs.
If full Finance API access couldn't be opened due to bank-feed contracts, a scope-limited alternative would still unlock significant automation: Standard OAuth only, single-tenant, the connecting org's own data only, read-only. The data is already mine via the UI - this would just make it accessible programmatically for the org I own.
Use case: receipt-matching pipeline for small org not outsourcing bookkeeping.