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.

Who even reads this forum, or listens to customers in the dev team?

Seems only accountants matter now, even the stripe implementation was a dogs breakfast. and still doesn't reflect the dual rate stripe charge. (1.75% or 2.9%)... #sigh

This makes NO SENSE when accountants have this functionality in the form of a billion checkboxes to bulk reconcile, but forget the end user, they don't matter

We have over a million transactions a year, so we currently had to rewite a lot of Xero into our own app so we can reconcile EXTERNALLY.

You guys are a joke for not implementing this.

We have the option of HACKING the ajax calls to implement this ourselves, or moving to MYOB, who have this, as do sassu.

seems your product manage spends too much time smoking pot and not WORKING.

+1

wow, this is one of the top ideas to implement and you just ignoring it?
great customer support ;)

The ability to reconcile transactions with the API is essential for Xero, it is one of the features that is most useful I imagine for a lot of companies.

I think you should re-consider allowing reconciliation via the API. I'm sure your reticence would be around allowing regular users to not have to interact with the UI, however with so many integrations that use payment gateway (stripe, payment express, chargify....) you get a many to one relationship where 1 payment needs to be reconciled against many invoices and this is a major productivity block. Xero claims to support over 1000 invoices per month, I don't want my staff manually reconciling 50+ invoices per business day when the data to reconcile them is already available else where. Please reconsider allowing reconciliation via the API for use-cases like this.

We would definitely use this feature. Xero developers, please re-consider this.

Certainly want it, to help reconcile those stripe fees.

I am more interested in being able to bulk "unreconcile" transactions. If a facility existed to make this functionality to be able to be selected by account it would be really useful. In our case, PayPal transactions number thousands and loads have the incorrect tax code. This would really help to allow them to be recoded easily.

+1

We use Stripe to process credit card payments. When Stripe transfers over the balance into our bank account, doing the reconciliation in Xero is complicated and time-consuming. We've used the API to create Spend Money transactions for the Stripe fees and then Bank Transfer transactions from our Stripe "bank account" to our Checking account. These transactions are not auto-reconciled and it's a manual and time-consuming process to reconcile them. I believe reconciling via API could solve that problem. Or creating a ToAccountIsReconciled and FromAccountIsReconciled parameter on the BankTransfer endpoing would solve that as well.

We would definitely use this feature. Xero developers, please re-consider this.

+1 we would definitely use this

You should do a survey! You would need to explain the benefits.
- This feature is a matter of " you don't know what you don't know" . If people really understood the value of this feature then everyone would be using it.
- This could potentially save businesses (consolidated) millions of hours of manually reconcilliations
- It would help eliminate human error and monotonous tasks

The other issue with this is that it it the partners and developers who want the feature , but if the end user understood the potential of automating reconcilliations and the time it would save.. then everybody would use it. Unfortunately for the value to be fully realised is a 2 step process:

1) the software or recon screens need to be developed ( for example matching credit card transactions and programmatically working out exchange variances )

2) The end user uses the addon to reduce the amount of manual reconcilliation / matching - and at the same time reduces human error.

+1

+1. Let's get 'er done!