Reconciliation: Find and Match - add filters for date ranges
In the Find and Match screen, add a filter for a date range rather than having to scroll thru all the outstanding transactions.
-
Heather Barclay commented
In the bank reconciliation window, it would be really helpful if the "find and match" feature allowed searching by date range as well as name, reference and amount. This is particularly important where there are a high volume of individual payments of the same amount over a long period of time. This would speed up clean-up work significantly.
-
Jonathan Bell commented
I need to reconcile multiple payments against a single payment physically received into the bank account (EFTPOS settlement). I would like to be able to search by date instead of "Search by name or reference / Search by amount". I know I can sort by date either ascending or descending, but it is no substitute as there is a limit of 50 transactions per page, and the function only sorts the current page of transactions, not all of them, so effectively has no use.
-
Paula Baldwin commented
This suggestion got lost in the Bulk OK Reconciling idea, but this is more specific to matching a payment to multiple supplier invoices when reconciling said payment.
Each month, my client pays a couple of suppliers, a total of 10-20 invoices each.
To have the ability to enter a date range of invoices paid ie: all Feb 2023 invoices, in Xero when reconciling the payment, is a necessity - I'm not sure why it hasn't been thought of before.
Please Xero, add "select date range" filter to the Find & Match option - there's plenty of room in the "1. Find & select matching transactions" box, beside the "Search by name or reference" and "Search by amount" options.
-
Emily Bell commented
It would be great if in the reconcile function you could filter out the transactions by date to find items you would like to reconcile easier if there are a lot.
-
Timea Hoskins commented
Also would be good if tracking categories was part of this filter. Where tracking categories are used for example as trading entities it will help to ensure the correct invoice is reconciled if suppliers invoice for multiple entities.
-
Luke Goodin commented
This also needs an option to filter payment type so only Eftpos come up to filter out direct debits
-
Luke Goodin commented
This is the most time critical and time costly activity. This would streamline this slow activity tremendously
Thanks for looking into this