Batch Payments - Keep multiple payments to the same payee as separate lines
Currently when creating batch payment files, multiple bills to the same payee are combined into a single line with only one set of bank payment details (although they appear separate on the batch payment screen in Xero).
Sometimes different bank reference details are needed for each payment, and sending the details in a remittance advice is inappropriate - it would be helpful if the lines could remain separate rather than combined so that unique bank reference details could be added against each line for the same payee
-
John Brennan
commented
Useful for me at times
-
Tarryn Hatherall
commented
I have found that our bank (commonwealth) would not allow this to work.
We have a married couple that work here with the same bank account, I tried to have them both on the same pay run, they came across to the bank as individuals from the batch file, however the payment couldn't be completed, it just errored out because two lines where for the same account. now I have to do a separate unscheduled pay run for the wife each week. So while Xero may be able to separate each bill for the same vendor within the batch, your bank may not process it. -
Henriette Rutherford
commented
100% agree
-
Casey Marshall
commented
When processing a batch file and importing into the bank we have multiple bills to pay (up to 40) from one company. but when doing it in one batch it groups them to become only one payment. However we and the company we are paying need these to all be individual and it seems crazy doing 40 different batch payments.
-
Jonathan Parker
commented
Should be an option/button to select when your on the new batch payment screen to Consolidate Invoices by Payee for export if your worried about bank fees etc. Its a simple fix that would save so much hassle and explanation. With all the new technology, this not being an option is a step backwards, Looking at it from the Creditors point of view, if the Creditor receiving the money also has Xero or similar, they have to manually allocate each of their invoices against the payment in their Bank Rec, rather than it auto allocating if it was individual invoice payments. Thus wasting more time.
-
Steve Dixon
commented
For us this would mean paying multiple bank charges for each line, so if required should be an option to remove consolidation of payments (to pay as multiple lines), or leave as consolidated to reduce bank charges. We email a remittance advice anyway so supplier gets detail behind payment.
-
Tina McGrath
commented
I am glad this is getting traction! It feels like such a basic functionality that causes so many "work arounds" and headaches. I hope it can be addressed soon! :)
-
Jeremy Morse
commented
PS Baffling that this is a known bug and still hasn't been addressed- ie that there's not the option to 'opt out' of collated payments. Or if it is, that this isn't as intuitively obvious as other Xero features.
-
Jeremy Morse
commented
Boosting this idea. Please Xero, please!
We make payments for rental tenancies and (not surprisingly) their processes allocate inward payments according to the details on the payment reference. When Xero 'helpfully' collates those payments into a single line, our creditors' automated systems (not surprisingly) apply the payment to the SINGLE LINE REFERENCED IN THE PAYMENT, even when we have wasted our time correctly entering that detail to the invoices in the first place.And please don't tell us that this is what remittance advices are for, because we're talking about sophisticated high-transaction-volume entities who have automated systems for a reason.
It's not 'I'm quitting Xero if this isn't fixed' kind of bad, but it's pretty darn annoying to deal with.
-
Michelle Dorfling
commented
100% agree with this. Just spent a lot of time on the phone trying to get a supplier to reallocate payments received which would not have happened if Xero did not combine multiple bills for one supplier in bank batches.
-
Sharon Barnes
commented
Pay many councils, would be helpful if make a button to turn off batch payment line merging if needed.
-
Tina McGrath
commented
Hi, Like others we are forced to create multiple batch files and it is creating a lot of additional unnecessary work for the team. please implement as soon as possible. :)
-
Nancy WEI
commented
Agree,
Xero, please update.
-
Chen Luo
commented
This would be super helpful - can we be notified if this is implemented?
-
James McKay
commented
This would be super helpful, an extra yes vote from me.
-
Shao-Wei Yap
commented
100% AGREE
Come on Xero, lift your game.
-
Shao-Wei Yap
commented
ABSOLUTELY A MUST!
On an Export Batch File the multiple payments to one supplier are combined with the top reference (eg the invoice number) showing as the reference even though there might be 10 payments to the same supplier.
WHY?
-
Chris Stokes
commented
When making a payment via "bills to pay" the Payee Reference is lost when payments are grouped. When grouped this should revert to the supplier reference, we pay lots of larger UK business (Travis Perkins/Screwfix/Trade UK) who require the customer reference number to be included in the payment otherwise it isnt allocated.
In addition, when you request someone else to pay the bill the references are lost. As a result I have to send them the payment request and a seperate email with the references that they need to re-add. -
Steve Dixon
commented
TOTALLY AGREE :)
The bank system we use is Lloydslink, so not Bacs and we can do a custom import, but each field has to be separated in CSV format, we can configure length of field and order, etc, but it cant split the concatenated fiel that Xero produces (sort and account all in the same field).
Is there a way to split this in the Xero export? -
Minnie Russnak
commented
they used to do this in CSV - but some dum dum has switched this export function off (but the button still exists) and now you cant export batch payments (especially useful for expenses) so Im now having to MANUALLY create batch files -
XERO confidence in this system.
just think of my life now - MANUALLY creating expense reports .... my soul is empty