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
-
Andrey Polounine
commented
I hope Xero make a button to turn off batch payment line merging if we need to.
Really starting to struggle now with Councils not accepting remittances for rates and Kiwibank not allowing manual batch edits.
I am forced to upload separate batches for every single property and also ask my directors to authorise every single batch individually.I even had to develop my own software to generate bank batch files independent of Xero!
-
Andrey Polounine
commented
Currently when creating a Batch payment, you enter the Particulars, Code, Reference and Payment amount individually for each single line.
But the moment you press Make Payment and Export the Batch File, multiple lines for one Supplier are merged, keeping the details only from the first line.We should be given the option for Xero NOT to merge payment lines.
I struggled with this for years, taking a screenshot of my Xero batch, then having to edit it in online banking to make it look like it did before Xero merged it.
This manual process is highly prone to mistakes.
But I want the supplier to see which invoices are being paid. Because the times I didn't split the payment, the supplier mis-allocated the payments and it took even longer to work through messy reconciliation.I know many would suggest I send Remittance Advices instead.
But I believe we should be given the freedom to choose whether we want the payments merged or not depending on our preference, using a tickbox at the point of making the batch payment.I don't always have the supplier's email address for remittances.
And I want them to be able to immediately see which invoices are being paid without going through separate communication that potentially goes to another staff member.Surely accounting software is there to make processes easier not harder.
This has been one of the few remaining advantages competing software has over Xero. -
Lisa Hoyles
commented
100% agree that this should be an active feature. Time is wasted entering the relevant information into the batch payment which prints as it's been prepared and then once exported into the bank and you remember (again) that payments to the same supplier are consolidated into one payment. So you go through again and record as much info as the bank fields will allow. This is particularly frustrating when paying memberships or affiliation fees to National Bodies where it is imperative that each payment is recorded separately. Not sure how I am going to tackle this when I get to it next month. Possibly individual payments each person :(
-
Joanne Taylor
commented
This would save so much time for both parties. Having to do multiple separate payments is time consuming.
Really need the option to keep multiple payments as separate lines. -
Shinichi Sasaki
commented
This function should be able to be set per supplier. Some accept receiving the total amount of their invoices, but others want to receive it according to their invoice numbers.
At the moment, after uploading the ABA file to the bank, I have to split the amount, which is time-consuming and prone to human errors.
-
Freya Pieroz
commented
This would save a lot of time - currently, I have to create multiple batch payments when there are multiple invoices for the same supplier, because it's easier than trying to explain why the payment for the total amount owing only had one bill reference on it...
-
Anthony Linnett
commented
Some suppliers prefer to receive separate deposits for each bill, with each transaction reference matching the bill reference number.
This avoids the need for the supplier to reconcile the deposit manually based on the PDF remittance advice.
Please develop a supplier configuration option that, when enabled, makes multiple bill payments to the supplier function as described above instead of the default consolidation behaviour.
-
Julie Gosley
commented
This is the reason that I have a couple of clients on other software that I will not move over to Xero until this is fixed. With 20+ transactions for some suppliers, each with different references, any workaround is not worth the switch.
-
Wei Shi
commented
This feature is critical. Extremely frustrated with not having the option to separate lines.
-
Francisco Durney
commented
Hello,
Any update here from Xero??? This is really important!!
-
Matt McPhee
commented
Add this to the list of crazy Xero omissions!
I have only just realised that my suppliers have been struggling to reconcile these lump sum payments made against multiple invoices, even though I spend ages copying invoice numbers into the reference field (another mental commission!)
-
Inge McCarthy
commented
This is very inconvenient when you have multiple accounts to the same supplier.
Despite the payments having different reference values the Batch file is aggregated.
I would like there to be seperate lines on the batch file for each Reference.Our work around currently is to have multiple Supplier contacts for each of the accounts.
-
Nhlanhla Sibisi
commented
I would like to export batch payments but instead of a summed up amount for a supplier I would like to have separated invoice line items.
Eg, 5 invoices for OF should result in 5 lines on the CSV import for the bank instead of 1 line with the total.
-
Jonathan Cheng
commented
Perhaps data from each transaction can be separated with say a comma? It would also be great if data is auto populated since invoice numbers, reference etc is already there
-
Freya Pieroz
commented
When I create a batch payment for multiple bills to a single vendor, Xero currently groups all those payments into one when creating the .aba file and labels the grouped payment with the payment reference from one of the payments in the batch.
I would like to be able to create an .aba file with each separate bill paid on a separate line with a separate payment reference, to make it easier for the vendor matching those payments to the bills they sent us. Especially since sometimes, when I am sending payments to related entities or to other clients of mine, that person reconciling those payments is me.