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.
-
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)..
-
Sandra Hamer
commented
Is this being looked any time soon?
-
Taz Birdi
commented
This is needed ASAP please
-
Jessica Shelley
commented
I agree with this!
-
Iana Taran-Freitas
commented
Add a feature to select multiple payments and reconcile them to one invoice.
For example if the line items could be selected from the cash coding tab and then a button saying reconcile to invoice. Would save a lot of time for invoices that have a lot of part payments -
Sheila Thompson
commented
I agree with the below comment from Nich Hulme. The appearance is not important. You have recently changed something that pops up when I am posting a payment now with the full Purchases Overview taking up the whole screen which I did not want and it now makes my job much harder when posting payments and sending remittances. It was fine the way it was. 'If it's not broken, don't fix it'!
-
Nick Hulme
commented
Please stop tinkering with the appearance and concentrate on the functionality. It is obvious that there is a demand for this feature. Please get on and sort it. You already have part of what is wanted in other areas of Xero eg credit notes on the Purchase Ledger. Part of the problem is that Xero searches for the amount with no option to make it search on the name of the customer. This only helps when you get to the last of many payments being allocated against a single invoice.
-
Sandra Hamer
commented
They are too busy changing all the views and reports :-(
-
Sheila Thompson
commented
Is anything being done about this problem? No feedback!
-
Nick Hulme
commented
We are in the same boat. We have over 2,000 transactions each month to match up to our sales invoices and it usually takes around two days to allocate them all. We do not want to move away from Xero, but are looking at alternatives as we know this volume will increase and we do not have this amount of time available each month.
-
Leslie Peters
commented
I currently receive up to 200 payments on a single invoice and it takes hours to match. Critical. Considering software change.
-
Jo Carrazzo
commented
On a singular day we may have 20 lines of a bank statement that relate to payment of only one invoice.
Split payments take time if we need to split it 20 times. It would be so much easier and save us so much time if we could reconcile it in bulk. -
Geraint Allport
commented
My practice software produces an itemised invoice with different items with different VAT rates listed. Payments via credit card are made on a daily basis. It would be enormously helpfulll to be able to simply tag all the payments on the bank statement and then reconcile in bulk against the relevant single invoice. Perhaps a quick check that the amounts tagged match the invoice?
-
Nick Hulme
commented
It currently takes us days to reconcile the payments at month end. An essential task but very long winded at the moment. If we could get this down to half a day, our valuable time saved could be spent on something more important.
-
Sandra Hamer
commented
This feature would make things so much easier for us too. Even if they can make it recognise the name instead of trying to matching the amounts, it would be so much quicker. We have thousands of payments on account which need matching to one monthly invoice. It takes days to do and is so time consuming. It could be something similar to the way Xero picks up credits and lets you allocate them to an invoice. Come on Xero, make our lives easier!
-
Sheila Thompson
commented
We need to match multiple payments to one invoice. Maybe, going forward, you could look at making this feature available. Potentially we coud have 150 receipts in one month that all need to be allocated to 1 or 2 invoices and having to reconcile each receipt individually takes a lot of time. Once this job gets behind, as it has in our case, it becomes an almost impossible task. We need to be able to select multiple statement lines at once to allocate as a lump.
-
Judith Skilbeck
commented
Sorry, confused, at the point of reconciling in the bank I cannot see the ability to split for these circumstances, is that something that is only available in some versions or is it hidden in a drop down? Its the solution others are putting forward but many of us seem unable to do it.
-
Tony Doyle
commented
We have a client who pays one invoice by line, so they make 20 payments against one invoice.
Current solution:
- Click on "find and match"
- Enter search term to search for invoice
- Select tick box for invoice
- Click split
- Accept split on popup box
- Click ok to confirm
- Repeat all steps above 19 more times!It would be so much quicker and less repetitive to be able to tick a box that allows you select multiple payments against one invoice, just as you can select multiple invoices against a one payment.
-
Zuzi Seoka
commented
This should be a standard in Xero! In our line of work, clients make multiple payments to one invoice and it boggles me that Xero cannot handle this.
-
Sandra Hamer
commented
This would be a critical addition for us, as we spend a lot of time each month splitting invoices to allocate multiple payments. We cannot change the way we invoice or collect payments.