Contacts - Supplier Statement "Detailed Ledger" (Running Balance Statement)
We need a new report for suppliers that functions as a true detailed ledger with a running balance.
The Problem: When we need to reconcile an account with a supplier, there is no single, clean report that shows a simple chronological history of all bills and payments. We can run a "Supplier Transaction Report," but it's often not in a simple, statement-style format that's easy to read or send to the supplier.
We need the Accounts Payable equivalent of the "Detailed Ledger" statement that is also needed for customers.
The Request (Solution): Please create a new report, "Supplier Detailed Ledger," that:
Lists all transactions chronologically (Bills, Supplier Credits, and Payments Made).
Shows payments we have made as their own individual line items (e.g., "Jan 20: Payment Made - R2,500").
Maintains a "Running Balance" column that shows the amount we owe after each transaction.
This report is essential for internal AP reconciliation and for resolving account discrepancies with suppliers. It provides a clear, simple, and auditable trail of all activity in one place. This is a standard and necessary report that many competitors offer, and its absence in Xero creates manual work in Excel.
Thank you.
Jasmine Bradley
shared this idea
Hi Jasmine, thanks for sharing this idea with us. We can see why this would be helpful for some users. Currently, Xero offers the Supplier bill activity report and the contacts Activity statement. While this information is available on the account transaction report,it is not available in a Statement format. We've moved this idea to Gaining support so that other users who want this idea implemented can vote for it as well. You may share this idea with your colleagues to get more traction!
