Introduction
A creditor ledger provides a detailed view of what your business owes suppliers. It helps you track payables, monitor outstanding bills, and manage cash flow effectively. In Xero, you can easily create this report through the Account Transactions feature.
How to Generate a Creditor Ledger in Xero?
Step 1: From the dashboard, go to Reporting, then select Account Transactions.
Step 2: In the Account field, type and select Accounts Payable.
Step 3: Choose the appropriate date range or reporting period to view transactions within that timeframe.
Step 4: In the Grouping/Summarising section, select Group by Contact.
Step 5: Click Update.
Step 6: Review the report to view all bills, payments, and balances for each supplier.
Step 7: To keep a record or share it, click Export and choose PDF or Excel.
Frequently Asked Questions (FAQs) about Creditor Ledger in Xero
Q: What does the Creditor Ledger show?
A: It displays all supplier-related transactions for Accounts Payable, including bills, payments, and outstanding balances.
Q: How can I view only one supplier’s transactions?
A: Use the Filter option and select a specific Contact to narrow the report to that supplier.
Q: Can I view overdue bills in this report?
A: This report shows all payable transactions. To view overdue balances by aging period, use the Aged Payables Summary or Detail report instead.
Q: Can I include or exclude specific transaction types?
A: Yes. Under Filter, you can display only bills, credit notes, or payments depending on what you want to review.
Q: Does the report update automatically?
A: Yes. The creditor ledger reflects real-time data, so any new bills or payments entered in Xero will appear when you refresh or rerun the report.
Conclusion
Creating a creditor ledger in Xero gives you a clear overview of all supplier activity and outstanding payables. Grouping by contact helps you see exactly what’s owed to each supplier, supporting better cash flow planning and timely payment management.