Auto Bank Rec - Mass upload auto-coding
While using JAX moving forward is great, what about when I'm bringing on a new client to Xero and I have hundreds of thousands of back transactions to upload and code?
I've added details to the CSV upload for me to use Cash coding to work through them (adding Xero COA code to the front of the description so when it is sorted alphabetically by description, it is sorted by COA code). However, it still can take a significant amount of time.
If JAX could read one of the input fields and if it contains the COA code, then put it in that category automatically, that would save me some time.
I've done about 6 conversions to Xero this year for existing companies; this would have been helpful.
A tool to help convert and bring in new clients would help us, as advisers, get them converted faster, with more detail, and less hassle.
Chris Foxcroft-Hibbs, CPA
shared this idea
Thanks for sharing your idea, Chris. Appreciate how automated coding via an import file would be helpful when onboarding a new client.
Our product team are paying close attention to feedback coming from our beta users. We'll keep a close eye on others that'd like to see this too, and share if there are any plans.
-
Ben Jackson
commented
Just a suggestion on this one, if you manually import and code the first month or two worth of transactions via cash coding, then turn on auto reconcile and import the remainder, this will hugely speed up your process.
Auto-Reconcile at this point only works when the transactions are pulled into the bank, and so giving it some information with a month or two, and then importing the remainder can really speed up your process.
When I did this, I worked on a quarterly process, i.e. quarter 1, reconcile everything, quarter 2, import and then reconcile any stragglers, quarter 3, import, reconcile any stragglers, etc -
Hamish Dunn
commented
I can see the value, when managing multiple accounts. I only manage 4 accounts, so 🤷🏼♂️