/accounting/reports/general-ledger
📷 Screenshot: General Ledger grouped by date, showing the filter row, group-by control, and the running balance column — to be added.
When to use it
- To audit the activity on a single account over a period.
- To find a specific voucher (invoice, bill, payment, journal) by its reference number.
- To review everything that ran through the books for one customer, vendor, or employee.
- To reconcile a balance: pick one account and read the opening balance, each movement, and the running balance down to the closing figure.
How to run it
Set a From and To date for the window, or pick a period preset (This Month, Last Month, This Quarter, Year to Date). The report refreshes automatically.Filters
- Account — choose a single account to see only its lines (this is what unlocks the running balance and opening/closing summary — see below). Leave it on All accounts to see every account’s postings.
- Reference — free-text search on the voucher / source number to find a specific document.
- Compare — attach a Prior period or Prior year comparative summary.
- Include opening — include the opening-balance row at the start of the window (on by default).
- Group — change how rows are organised (see below).
Grouping
The Group control reorganises the same rows:- By date (default) — straight chronological list.
- No grouping — chronological, ungrouped.
- By account — collapsible sections per account, each with its own debit/credit subtotal.
- By party — sections per customer/vendor/employee, with subtotals; lines with no linked party roll up under Unlinked.
- By voucher — sections per source document, with subtotals; manual journals roll up under Manual.
📷 Screenshot: The Group segmented control with “By account” selected, showing collapsible subtotal sections — to be added.
Reading the columns
The account summary (single account only)
When you’ve filtered to one account, the report also surfaces an opening balance, the period’s net activity, and a closing balance for that account — the same figures the Trial Balance would show for it, but with every line that built them laid out beneath.Paging through large ledgers
The General Ledger can be very long, so it loads a page of rows at a time (up to 250 per page). Use Previous / Next to move through pages. The header shows how many rows match your filters in total. Changing any filter returns you to the first page.Drilling in
Click through from a grouped row or an account to open the Account Ledger drawer, or follow a voucher to its source document. The Trial Balance and other statements also link into the General Ledger — clicking an amount there opens this report pre-filtered to that account and window.Exporting
Export offers CSV, Excel (.xlsx), and PDF of the rows currently shown. The export carries Date, Voucher #, Voucher Type, Account Code, Account Name, Party, Description, Debit, Credit, and Running Balance. The PDF is laid out in landscape to fit all ten columns and includes your business name and the period in the header.Tip: keyboard shortcuts — press p to jump to the period field, g to cycle the grouping, and e to export the current view as CSV.
Tips and gotchas
- Running balance needs a single account. If the Running Balance column looks blank or meaningless, you’re viewing more than one account — pick one in the Account filter.
- Export captures the current page of rows, not the entire matching set. For a complete dump of a huge ledger, use the server-side CSV export (see the overview).
- The ledger includes reversals so the audit trail is complete; the running balance accounts for them.
- For a closed/locked period the figures come from the frozen snapshot taken at close.
Related
- Reports overview
- Trial Balance — the balances these lines roll up into
- Aged Receivables & Payables