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.

I think the xero designers may be confused on this request. From the comments, I don't see people wanting to reconcile the bank statment, I think it's the individual payments. Yes, the bank statement should always be done by a human.

I think this request more clearly defines what is needed: https://xero.uservoice.com/forums/5528-xero-accounting-api/suggestions/35787817-reconcile-individual-payments-not-bank-statement

<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!

We have a SAAS product line and Stripe sends a single payout through every day with dozens of payments attached to it. This is increasing for us every month.

Please *PLEASE* reconsider adding this to the API, or at least give me some way to programmatically do this. I cannot fathom paying a team of bookkeepers to sit and match hundreds of payments every single day.

At https://www.yodeck.com we are using Stripe and Silversiphon for importing Stripe transactions to our Xero account, so we have tons of transactions that match perfectly. So, we created the "Xero Reconcile Robot" that automatically reconciles a) transactions matching bank rules and b) transactions that perfectly match reference codes with the payment/invoice.

It works perfectly. We will soon publish it on Chrome Web Store for others to use.

+ 1
This was the main reason we were looking to move to Xero so we can reconcile the payments received from Stripe automatically...

Are you serious?!?!
Shopify integration means you get batch payments and the only way to do reconciliation is manually by hand look up what invoices were paid on a certain payout and then manually search for them plus the fees adjustment and perform reconciliation. Thats a ton of effort.

Can you explain the "long time before we can openly share statement data via the API" ?
There are records within Xero of bank transactions, ie Shopify payout Sept 1 $2,004.31 and that is all that is needed (with an ID) to then match that to what Shopify states are the related invoices in that payout.

For clarity:
- Banks are not permitting you to provide access to our bank records that you're able to import?
- Is this limited to certain banks? I'm with Bank of Melbourne, who do I need to change my bank to so my banking information is my banking information?
- Alternatively, can Xero create the ability to import the Shopify Payouts CSV and do the matching for us?
Regards,
Mark Terrill @ Smartfire BBQ

Is there not a way to just give like FITID, Memo, and Description, and allow one to even add notes to the transaction?

Bank txn parsing in AU has been a nightmare for decades, I have no idea how other countries do it but the amount of frivolous "busy work" considered "normal" by the industry is ridiculous, not only the monopolising of data but even their in-house data practices, not even providing unique hashing for txn rows, plain text EFT logs, short field date formats in wild configurations mm/dd/yy for example, 6 digit passwords. plain text csv retention for 2 years only.... it's archaic, the equivalent of telegram in the digital age. Took me 6 months of harassing CBA in 2008 to find out that they even HAD a deprecated product for a business to gain access to their own statement data via automation, $1000/m, their own datasec staff suggesting i just scrape Netbank "it's how I do it, it works." bUsInEsS cOnTiNuItY.... May cryptos blow all these gatekeepers to dust.

I would require this feature to move to Xero. As it stands we will end our migration from Sage and sty where we are. Will look into some of the systems mentioned in comments thanks.

If you dropped the ball - time to pick it up

Reconciling is the task that takes time and is so easy to automate

Mybe you do not realise it

For bank uploads I have created a script that simulates a browser window, logs in to Xero, navigates to the right pages and puts the right file in the upload box. Then it logs out.

I guess now I need to make another script that logs in, opens all the "reconcile" pages and clicks the buttons as needed.

Thanks!

Thanks for the update Adam, ironically I think you will find that the data in the bank statement is not your partner's to but is actually the user's data. This data ownership issue should be even more evident now with recent GDPR changes etc. So if this is the main reason for not proceeding with this feature, I'd encourage you to fight harder for user's rights. Cheers.