Batch Payments - Include Line separators in CSV export
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.
-
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.
-
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.