Bank Reconciliation - Suggest the Most Recent Bill
Currently, Xero’s bank reconciliation often suggests matching a transaction with a random bill - rather than the most recent one.
I.e, a transaction dated 24 Feb may be matched with a bill dated 30 Mar, even though a bill for 24 Feb exists.
It would be more accurate and efficient if Xero prioritized suggesting the most recent bill prior to or closest to the transaction date, instead of a seemingly random one.
This would be useful for us who enter multiple future-dated bills for budgeting/forecasting and would make the matching process more intuitive and time-saving.
Lana Tsybizova
shared this idea
Hi Lana, thanks for the feedback. We understand that when you’re reconciling bank transactions, it helps when matching is quick and straightforward so you can reconcile with less searching.
For your request to automatically suggest the most recent bill on a statement line, Xero uses a matching process to surface the most relevant option based on the available data.
It first looks for transactions with an exact amount match to the bank statement line. From there, it compares details like supplier name and reference to rank the closest matches. If there are a few similar options, it will generally prioritise the bill with the closest due date rather than the most recently created one.
Because of this logic behaviour, and since you can still select a different bill using Find & Match when needed, we’ve marked this as Existing Functionality.
