Full ledger statement for one account with running balance over a date range.
What it shows. Every posted journal line affecting the chosen account: date, voucher type and number, party, note, debit, credit, and running balance. Works for cash/bank, customers, suppliers, expense accounts, taxes, and general ledger accounts.
When to use it. Use to reconcile a bank or cash account, review customer or supplier movement, or audit activity on any ledger. For purchase invoices, debit notes, expenses, purchase expenses, and prepaid expenses, Voucher No shows the Supplier Invoice Number when one was entered — making it easier to match ledger lines to the supplier’s bill.
How amounts are calculated. Opening balance is derived from the account closing balance minus period movement (or from pre-period journals when filtered by brand). Running balance follows the account’s debit-normal or credit-normal type. Results are paginated (500 lines per page).
Notes. Advanced filters can limit to one transaction type, an exact amount, or a brand. Foreign-currency accounts can show extra Debit* and Credit* columns.
Voucher No. Shows the document’s own bill number by default, with the internal ID in brackets. When the source document has a Supplier Invoice Number (purchase invoice, debit note, expense, purchase expense, or prepaid expense), that supplier number is shown instead of the system bill number — so you can match the ledger to the supplier’s invoice during reconciliation. Excel export also includes a separate Supplier Inv No column.
What is shown per line?
Every journal line hitting the selected account with running balance.
Can I use for customer account?
Use customer sub-ledger reports in Sales/Purchase for AR/AP; this is GL account.
Why balance mismatch?
Opening balance date, unapproved journals, or wrong account selected.
Include cancelled?
Typically approved only — verify status filter.
Link to voucher?
Drill from journal reference to source RV/PV/expense where linked.
Why do I see the supplier’s invoice number in Voucher No?
For purchase and expense documents that store a Supplier Invoice Number, the report prefers that number over the system bill number so bank and supplier reconciliation is easier. If no supplier number was entered, the system bill number is shown.