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.

Hi

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

Regards
Mason

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

This is a cluster****. Basically, we can import bank statement lines from a csv, and even if we know *exactly* which records they should be matched to, we're forced into a massively time-consuming and error prone process. We can't even match by custom fields in the statement lines, so even if the bank statement is imported with precise matching data, the system instead makes error-prone suggestions, that end up as accounting errors.

Completely crazy guys! You need to do better here. I'm currently hunting for an accounting solution that has the flexibility to do this job correctly.

QUOTE: "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."

Isn't this data that the bank freely shares via it's statement export? Data that I upload myself into XERO ( I have no automatic bank feeds ). Surely I'm allowed to access my own data, that I uploaded?

Hi, the Xero bank statement functionality is great but ideally I want to pull these bank statement lines into my system via an API as the matching to a Bill needs to get done on my side. I already have functionality that then allows me to Post the reconciled payment through, but in order to prevent duplications I would want to be able to delete the Bank Statement line using the API. Is this possible? Is there anyway I can at least read the unreconciled Bank Statement Lines?

+1

You should remove the link from this page as the request is "declined":

https://developer.xero.com/documentation/api/bankstatements

I guess if I was Xero or their providers I would also decline the request.

Basically if you open up recon to API users the API users could exploit it to their own benefit bypassing Xero. Also I guess one could throw the "there is a security risk" at Xero and decline these requests too.

Hi! I'm also frustrated by the lack of a reconciliation API.

But when Xero say that "reconciling [via an API] requires fine grained access to bank statement data" - they're wrong!

Sure you can design the API to expose a BankTransactions endpoint, and you'd hit the contractual objection that has apparently blocked this idea for years. That'd be easy and nice and useful but OK - we can't have that.

Instead - add a new API end point for a "ReconcilationHint" - this could be an extension to the manual Bank Rules, or something new.

As developers with access to external data, we know that a particular bank transfer will have come in for a certain amount, within certain dates.

We could tell Xero via this new API "hey, when you see a transaction for £100.00 within a week of September 1st, go ahead and mark it off against Invoices 1, 2, 8 and 47".

Xero could say "thanks, I see 1, 2, 8 & 47 add up to £100, I'll bear that in mind!"

Then when it comes to the manual reconciliation, process Xero can take that as a firm instruction to mark those off automatically (or to auto-select them in the current manual process).

That would at least fulfil *my* reconcilation wishlist, where I need to mark off invoices and bills against a single bank transfer, which the current front-end makes particularly painful. I don't need access to the bank feeds, and I suspect with some more creative API design, they could pick off other use cases in the same way.

There would be some more design work to do, and would might need another reconciliation front-end - like what if a hinted reconciliation *hasn't* come in? That's a useful thing to know - but even if you could just query previous hints to see if they've been matched, that'd be everything a developer needs to build fully automated reconciliation.

Hi Adam,

How about an update on the "Declined" post from last year? I haven't noticed any of the somewhat vague "really cool stuff" that was promised.

Automated reconciliation via APIs and/or access to actual bank feed data is an absolute must. Try working with KiwiBank, I'm sure they'd be more receptive to change and having a competitive advantage and maybe kick the "kangeroo" banks into action on this.

I don't understand what the issue is. Banks already allow manual download of formatted data for bank transactions and automated banks feeds, so how can they restrict Xero as a 3rd party from providing access to that information via API? It's the same information, just accessed in a different way.

Banks are merely the custodian of information, it is the customer's that own it and banks should not be putting artificial barriers in the way of improving productivity.

Regards

Chris Macneill
Network Engineer / Software Developer
Zelan Ltd.

+1 I would love to have this.

We have developed zeevou.com, a hospitality management system seeking to automate as many processes as possible for hosts. Right now, the lack of this functionality is forcing hundreds of hosts who use Xero to have to reconcile their booking payments manually. We may need to start sending our customers to one of your competitors.

For commercial reasons?
Okay, well tell your partners this:

You guys just lost one potential customer to Plaid,
so better hop on board because you're getting left behind.

Cheers!

+1 for this … we issue about 2000 checks per month and while the reconciliation screen properly matches about 75% of them, it is still a lot of manual work to click 2000 "OK" buttons; plus, the other 25% are cases where the check number is supplied in the bank feed but the match is uncertain or not found. Was looking into automating w/ a script and disappointed that this isn't accessible.

We have automated bank feeds and our invoices pushed to the api contain the same reference as appears on each of our bank feeds for each transaction again we have hundreds of orders each day and to manually reconcile each against the various bank feeds is a nightmare. Surely the unique reference on each line of our bank statement which matches exactly the reference we provide on our invoices which are pushed via the api from our ecommerce platform can be automatically matched and reconciled via the api?

Not pleased to see this has been declined.
What about just allowing access to the bank statement lines via the API (i.e. without the ability to reconcile)?
We currently pay £3 per month for our bank feed to be imported in to Xero, accessing it via the API would be very advantageous.

Bankfeeds.io is a tool that will help import and reconcile Stripe payments into Xero.

We really need this! We're using Xero with Shopify and as our sales grow reconciling is taking longer and longer to do manually. Shopify Payments sends us a single payout daily that covers dozens or sometimes hundreds of transactions. We need to match the single bank statement deposit with the many transactions that were synced over from Shopify.

This should be EASY to do programmatically because every transaction has an ID and we know from the Shopify payout which transactions should be included. It takes a human many clicks and manual sorting to do this process.

Please allow reconciliation via API!!

At SMTAX (www.smtax.co.za). We have a workaround solution to this problem.

The process works similar to the below:

1. Provide us with accountant access to Xero (We are a Gold Xero Partner)
2. Send us the CSV file - you can automate this process.
3. We will reconcile all the payments
4. Notification is sent to you once allocation is complete

Regards
SMTAX

Try out the Xero Reconcile Robot:

https://chrome.google.com/webstore/detail/xero-reconcile-robot/omchihoemeblabnbpbamimnopopfllfi

At https://www.yodeck.com we are using Stripe combined with SilverSiphon for automatically importing Stripe transactions into Xero. We get hundreds of transactions each day. With the Xero Reconcile Robot we have made it as easy as it can get to automatically reconcile matching transactions.