Ledger Reports
Go to: Financials → Reports → Ledger Reports
General ledgers
| Report | Use it for |
|---|---|
| General Ledger | Complete accounting activity across accounts with source-document detail |
| Accounts Ledger | Account-wise activity grouped by account, including currency view |
| Expense Ledger | Expense-account activity in a focused expense layout |
Common filters include dates, accounts, Cost Centers, Projects, document/reference details, and currency options. CSV and PDF are available according to each report.
Receivables and payables
| Report | Use it for |
|---|---|
| Accounts Receivable | Customer balances and outstanding amounts |
| Accounts Receivable Aging | Customer outstanding split into age buckets, with party drill-down |
| Accounts Payable | Supplier balances and outstanding amounts |
| Accounts Payable Aging | Supplier outstanding split into age buckets, with party drill-down |
Aging depends on invoice due dates and outstanding amounts. Reconcile unexpected values with the invoice and Payment Reconciliation.
Customer reports
| Report | Use it for |
|---|---|
| Customer Ledger | Customer transactions and running balance |
| Customer Advance Ledger | Advances received and later used |
| Customer Tax Ledger | Tax recorded on customer sales |
Supplier reports
| Report | Use it for |
|---|---|
| Supplier Ledger | Supplier transactions and running balance |
| Supplier Advance Ledger | Advances paid and later used |
| Supplier Tax Ledger | Tax recorded on supplier purchases |
Employee reports
| Report | Use it for |
|---|---|
| Employee Balance Report | Outstanding employee receivables and payables |
| Employee Payment History | Completed payments made to or received from employees |
Employee balances can originate from payroll, advances, expense claims, benefits, deductions, or direct financial entries. Use the HR source document to correct HR-owned activity.
Troubleshooting a balance
- Match the report date and organization currency.
- Open the party/account ledger.
- Identify the source document and status.
- Check Payment Entry allocation and reconciliation history.
- Check returns, credit/debit notes, advances, and write-offs.
- Reverse or correct the source rather than editing report output.
A party ledger and its control account should reconcile for the same filters. Missing Party values on manual journals are a common cause of differences.