Bank Reconciliation - Match multiple payments to one invoice
Ability to match multiple transactions to one invoice, then reconcile it.
Purpose: It’ll save users’ time when they’re doing reconciliation and matching the transactions.
-
Ian Rochester commented
its a common business practice to pay for an invoice in instalments. Im surprised this featuresisnt in the system.
it would save time wasted in 'creative accounting' to achieve the desired result -
Sheila Thompson commented
I asked for this over a year ago!!!!
-
Adrian Bennetton commented
I vote for this. We have Wise digital cards for our employees to use on business when abroad. Each use of the card results in a Wise bank transaction. Each day these Wise transactions come into Xero via Bank Feed. During a business trip one employee might have ten or more Wise bank transactions. The employee enters each use of the Wise digital card as a separate line in draft bill. The single bill with all use of the digital is approved. However to reconcile the bill involve Find and Match then split for each payment which takes a long time. It would be nice to have a facility to select multiple bank tractions against a single bill to reconcile.
This would save us a lot of time during the bank reconciliation process.
-
Jessica Williams commented
I have one particular supplier where their bill is around $80K monthly and we pay it off in $1-$2K payments at a time. The ability to select all 70-80 transactions at a time to reconcile to the one invoice rather than search, split then reconcile each individual transaction would save SOOOO much time!.
-
Davina S commented
For clarity, The issue is not being able to select multiple bank account credits at once to reconcile against one issued invoice. Customers regularly split payment amounts to comply with bank limits. Currently I have to select each CR and reconcile as split payment and then repeat. I need option of tick selecting more than one transaction to match against the one invoice. This would save considerable time and duplicated effort. Similar to how we can take one DR from bank rec and match to multiple bills by tick selecting.
-
Mercy Ubani commented
Great suggestion and would be an absolute time saver.
I normally have multiple credit card transactions that I would like to be able to reconcile against a single bill received from our job management software. It would be great to be able to 'select multiple' and match to single bill without going through the 'split bill' process for each individual transaction as well described by https://productideas.xero.com/users/6396911824-alison-whelan
I think this idea would go hand in hand with sorting and filtering of the bank reconciliation screen (link below) depending on how that idea is being developed. It would be great to be able to search for transactions that meet a specific criteria, e.g., contains certain keywords in the description or a payee name > select all > match.
-
Marie Paiser commented
Bulk Allocate payments to a singular invoice. When reciveing multiple payments all realting to one invoice, it would save huge amounts of time to be able to bulk select the payments and allocate to a singular invoice. Can this be a feature please?
-
Alain Hollenthoner commented
I'm fed up with Xero and decided to move on. There is zero usable development or progress.
6 years after PSD2 has been implemented in Europe, there's still no bank feeds available. The tax determination logic is flawed. I could go on and on.We will switch to an Open Source ERP (name starts with O) and say goodbye to Xero.
-
Sheila Thompson commented
Absolute JOKE !!!
-
Nick Hulme commented
We have been waiting years for this. Xero obviously don't look at these comments. They are too busy updating reports that worked perfectly well as they were, rather than work on something new that users need.
-
Sheila Thompson commented
Its nearly a year since this was suggested and nothing has been done about it.
-
Jodanna Huxley commented
This would save me hours of work each month. Seems a real oversight that this is not already available!
-
James Dell commented
This is the most time consuming part of my processing. My entire monthly bookkeeping time is doubled purely due the post office issuing 1 invoice for the whole months transactions and reconciling with xero is so tedious and time consuming. Please add this feature.
-
Duanne Watkins commented
To pay a large invoice as a micro company I have to transfer only £50K at a time from my bank account to make up the £100K + amount. So sometimes three + bank transfers over three days to meet the invoice amount have to be made. But I have to get my accountant to Reconcile them as there is no way to do this from the Reconcile Page. Come on XERO
-
Duanne Watkins commented
PLEASE PLEASE PLEASE add this feature, requested since at least 2021 !!!!! Does Xero every look at this and reply??
-
Glen White commented
Just FYI,
this same suggestion has been made here:
https://productideas.xero.com/forums/939198-for-small-businesses/suggestions/45890518-reconcile-splitting-a-payment-select-multiple -
Glen White commented
I think this is essentially the same suggestion as this idea.
https://productideas.xero.com/forums/939198-for-small-businesses/suggestions/44960404-reconciliation-match-multiple-payments-to-one-in -
Glen White commented
This would be useful to match multiple statement lines against bills as well.
-
Alison Whelan commented
Receiving over 150 receipts on the same day for a single sales invoice can take hours to reconcile. It takes about 7 clicks of the mouse for each entry, as you have to search and then 'split' each time. It is ridiculous.
You can match multiple invoices to a single receipt, but not the other way round.
The obvious page to do this would be under Cash Coding, where you can select the items in bulk.
Why is this still not being addressed, as it is clearly something many have been asking for for a long time.
-
Casey Sun commented
BANK RECON - In the bank reconciliation , please add this feature , combine 2 bank statement lines (on the left hand side) to match with 1 invoice in Xero (on the right hand side)..