We did for a long time too.
With the introduction of LiveCA's NoCode Development team, we've now figured this out.
In Xero, you can't search for a group of payments, then decide where each one should go. While Find/Recode is handy for bills, here are a list of items you can't search for in Find and Recode.
Luckily, Xero has an API that allows you to not only search for records, you can also update them. Ergo (always wanted to use that in a sentence), we can slap a bunch of searches, conditions and apps together to make this work without being a super developer.
In this particular example, a prior accountant mapped Chargebee Stripe payments to the wrong account, so we had to move them to their respective CAD and USD stripe clearing accounts.
Here are the steps we took using Integromat to bulk reallocate payments in Xero:
Here's Mat Kennedy, our Product Manager of the NoCode Development team, with a walkthrough video.
The amount of times we've had to manually remove and then re-apply a payment over the last few years has been heartbreaking knowing this is possible. Now we can adjust a few conditions on this scenario and be done so much quicker.
If you're looking to solve a problem like this and are in the market for a new accounting firm in Canada, please reach out.
Chad co-founded LiveCA and currently oversees the NoCode Development and Sales teams.