Automatic Bank Reconciliation - Enhance Matching Logic to Prioritise Source Documents
While reviewing auto-reconciled transactions I can see that JAX is taking the last time the transaction was reconciled - suggest JAX should be looking at the last few times the transaction was reconciled as it is common to cash code (create) a spend or receive money ini the essence of time when the normal process is to match to a source document. The risk here is that a spend or receive money could be used when there is a source document in the system that is awaiting payment or part payment situation
Hi Melanie, we appreciate the importance of accurate reconciliation, especially in cases where bills or invoices are awaiting payment or partial payment.
Currently, JAX looks at your previous reconciliation history to suggest matches. Your suggestion to consider multiple past reconciliations rather than just the last one is helpful — it can improve the accuracy of auto-reconciliation.
One of the key strengths of this feature is that it learns from your reconciliation activity - If a suggested match isn’t correct and you manually adjust it or use the ‘Remove & Redo’ function, JAX will gradually learn the right match over time, helping improve future suggestions.
You can also improve auto-reconciliation performance by:
- Building a strong reconciliation history: Regular reconciliations help JAX learn your patterns.
- Keeping contacts and chart of accounts up to date: Accurate information helps improve matching accuracy.
- Setting up bank rules: Rules for recurring transactions give JAX explicit guidance on how to reconcile automatically.
We’re using feedback like yours to refine the matching logic in JAX, with the goal of prioritising source documents while making auto-reconciliation smarter and more efficient.
We'll update the status here to Feedback, but please be assured JAX’s matching logic will adapt and be shaped by reconciliation behaviour over time. Being consistent in how you reconcile similar statement lines will help JAX learn and improve the matches it suggests. Thanks!
-
Michelle Skinner
commented
I prefer to have the source documents and only if the receipt is lost will I post without it.
But I have found that JAX is creating a spend money when I've not yet entered the source document. Then when I enter the source document, because it's already coded to spend money, it's not finding the bill to match to.
It's not providing a time saving at this stage, I've had to turn it off for a lot of my client's accounts, as I'm concerned regarding too many errors coming through from mismatching. -
Carolyn Searle
commented
new jax and auto reconciling - this doesn't help if trying to match the bank receipts with bills and invoices waiting to be paid - xero auto reconciles them before they can be matched so it doesn't really make the process quicker