Invoice – Unique payment reference field for Reconciliation
Dear Xero,
Please!.. Ideally, accurate references on all source documents should be able to link them to their Payment transactions in Xero. However, it can be extremely difficult and time-consuming - especially with Spend/Receive Money transactions.
It would be incredibly helpful for a column of 'Link ID's' to be displayed on all detailed reports.
Doesn't need to be fancy, just a Unique ID.
This link ID would need to be automatically generated by Xero, and, have the ability to change dynamically in the case a payment is removed (as one of many examples).
It would help to see the account movements relating to individual Bills/Invoices with a simple pivot table.
Thanks for your consideration!
Callum Fountain
shared this idea
Hi Callum, appreciate you highlighting how a unique payment reference field could support reconciliation workflows. Your suggestion about displaying Link IDs on detailed reports to track account movements is a valuable feedback.
This idea has now moved to Gaining Support, which means it’s open for community support through votes and comments. We encourage other members who would find this helpful to add their votes and share their experiences.
In the meantime, a practical workaround is to use the “Reference” field consistently. When creating invoices, include a unique reference code for the payment (for example, PAY-1001), and when receiving payments, enter the same reference in the “Reference” field. This ensures that the data will appear in the Reference column in both the Receivable Invoice report and the Account Transactions report when run for the relevant bank account, making it easier to track and reconcile payments.
We’ll update this thread when the idea gains traction and is reviewed further by the product team.
