Batch Payments: Reference from the Bill instead of Contacts
When generating a batch payment for multiple bills, the reference column of the batch payment is driven from the reference field within the supplier contact.
When a batch payment is made the reference is automatically set from contacts rather than the reference on the invoice. This means that in the reference column of the batch payment the invoice reference is required to manually added, doing this also updates the contact which means this process has to be completed every month otherwise you end up exporting payments with the previous months invoice reference as the payment reference.
The simplest fix is just make the reference for the payment driven from the reference on the invoice, as this is the information the supplier wants to see when the payment hits their bank statement.
Hi everyone, rounding back we appreciate there hasn't been much explanation before now on why this idea is not planned.
Coming across from our previous forums this has been reviewed by many of our team in product. To start, and explain logic behind the scenes - Xero allows references to be pulled from either:
- what's been entered as a reference for the contact, or
- the bill reference
Batch payments is designed to cater for businesses that require the same reference for every invoice via the reference entered in the Contact record.
👉For example utility companies needing an account number entered as a bill reference; so that the utility company knows who paid them.
If you need to have all the payee references be pulled from the bill instead of the contact record then you can remove the reference from the contact field when processing your batch. Moving forward all of the bills selected for the batch payment will have their reference pulled into payee details.
While we’ll continue to enhance the flows and visuals through the batch experience, we don’t have any intentions of changing the way in which the reference’s here behave at this time. Thanks
-
Lianne Taylor commented
Agree dwith this and also when making a batch supplier payment we can see the payment sum but the "Payment Ref" within the accounts transactions detail box is blank so cannot see which supplier it is until we drill down into it, not ideal and takes extra time.
-
Kylie Parry commented
This is really frustrating. Surely it would be better to populate the reference as the invoice number. Please fix!!
-
Mandy Steininger commented
Unfortunately, in this case, NZ ...
-
Soonam Hwang commented
@Mandy
If you are in AU and if it doesn't work then the posting you referred is correct as the function is broken.
If you are in NZ and if it doesn't work then you are in the wrong country as NZ Xero never had that function ever even though hundreds of clients complained about it for ages. -
Bill Brown commented
It is extremely easy to test the supposed fix in the Demo Company and show that it DOES NOT WORK. Simply take a demo Contact, enter and save any example "Particulars, Code, Reference" details in it's Financial details, then remove them and save it again.
Now try to make a batch payment to a bill for that Contact.
It will NOT bring the Bill Reference into the Batch Payment "Particulars, Code, Reference" screen for that contact.
It is extremely frustrating that this still has not been addressed.
It really should be a setting the tenant can CHOOSE, to decide what data goes into these fields during a batch payment, via the Organisation settings. -
Mandy Steininger commented
Have a look at this post here: https://central.xero.com/s/question/0D53m00005rQv83CAC/payee-reference-in-batch-payment-not-picking-up-bill-reference
It seems it should work already, but doesn't because of a bug?
-
Kate Yapp commented
This would be such a time saving feature, please look at this in the next update.
-
Nicole Sullivan commented
Any updates on when this feature will be available? Very painful / manual currently.
-
Richard Smith commented
It would be extremely helpful and time saving if the invoice reference transferred over automatically.
Or even just being able to copy and paste the reference would help a lot.
Get it sorted please Xero. -
Shelley Nicholson commented
Yes please, I can't believe this is even an issue with an accounting package to be honest. It would save sooo much time. Can't wait for the change ;) <3
-
Angela Beaumont commented
This would be extremely helpful. It seems that a lot of people feel the same way. Utility companies are a very small part of our remittances whereas we pay a large amount of invoices to print and other such companies who require a remittance advice. Please reconsider implementing this.
-
James Hammond commented
I would love this! At the moment it is also a manual process for me, and it would save so much time.
-
Sarah Griffiths commented
This would save so much time!
-
Kathleen Ison commented
This suggestion makes a lot of sense and has been expressly requested by many of the suppliers that we pay (to have invoice number i.e. invoice reference number in the reference field of the payment they receive)
-
Finance - Illawarra Campus & Co commented
I have been searching for a solution to this. Look forward to Xero improving this feature, as so much time is wasted manually entering the reference in batch payments.
-
Amber McPherson commented
This is a critical feature and I am super surprised the functionality isn't already there. Please look at prioritizing this !
-
Kathy Macdonald commented
This shouldn't be locked for voting - I agree that it is quite annoying that the invoice reference cannot be automatically included in batch payments. It is the easiest way for suppliers to know which invoices have been paid by us.
I find this quite strange especially given if it was the other way around (i.e. someone paying into our account), Xero would use this feature to automatically match invoices in our system that have been paid by customers.
Would really appreciate this. Even if it's like a placeholder text or something like that, so that the invoice reference can be put through.
Thanks.
-
Rachel Pike commented
This would be a very much appreciated feature. I waste so much time having to manually enter the payee reference into my batch payments.
-
Soonam Hwang commented
This idea has been posted again and again since at least 5 years and finally dismissed by whom called himself the Xero project manager David with ridiculous reason that its not on their priority plan which meant they didnt care what the customers said on their stupid product.
-
Baden Turley commented
Not sure why this is locked for voting