General ledger
Chronological detail of movements by account with a running accumulated balance and filters by account and cost center.
The General Ledger lists every POSTED journal entry line chronologically. It is the report with the highest level of detail: one row per movement, with date, journal entry number, account, description, debit, credit and - when you filter by a specific account - the running accumulated balance.
Reading time: ~5 min
When to use this
- You need to audit all the impacts on a specific account within a range.
- You are going to explain where an account's balance comes from and want to see the movement in detail.
- The accountant asks for an exported general ledger for internal or external review.
- You want to trace the movements of a specific cost center.
Before you start
- The Accounting module is active and your role includes
accounting:read. To export PDF or CSV you needreports:export. - There are journal entries in POSTED status within the range. Draft entries are not included.
- If you are going to filter by cost center, the journal entry lines must have the corresponding cost center assigned.
Step by step
- Open Accounting → General Ledger from the side menu. The URL preserves the filters, so you can copy it and share the link to the exact view.
- Set the range with From and To. It loads the current month by default.
- (Optional) Filter by Account in the selector. When you choose an account:
- The report adds the Running Balance column that shows the accumulated total line by line.
- An Opening balance appears at the start of the range as a starting point.
- (Optional) Filter by Cost Center to see only movements assigned to that center.
- Review the table:
- Date - the journal entry date.
- Entry - the journal entry number (clickable link that opens the detail).
- Account - code and name.
- Description - the line text, truncated to 60 characters with a tooltip on hover.
- Debit / Credit - the amount in the corresponding column; the other one shows
-.
- Pagination is cursor-based. Press Next to move forward and First page to return to the start. The first 50 lines are shown per page.
- To download, choose the Format (PDF or CSV) and press Download. The export respects the active filters.
Running balance: when it appears
The Running Balance column is shown only when the Account filter is active. Without a filter, mixing balances from different accounts makes no accounting sense, so the column is hidden. This is by design.
Expected result
- Chronological list of POSTED movements in the range.
- When filtered by account, a visible opening balance and a Running Balance column that grows or decreases line by line.
- Each journal entry number is a link to the journal entry detail.
- PDF or CSV file with the range and applied filters.
Common errors
| Error | Cause | Solution |
|---|---|---|
| The Running Balance column does not appear | You have not applied an account filter | Select a specific account in the Account filter |
| Today's movements are missing | The day's entries are still in Draft | Record the pending entries from Journal entries |
| The cost center filters to zero lines | The journal entry lines have no cost center assigned | Edit the entries and assign the cost center to the corresponding lines |
| The Download button does not appear | The reports:export permission is missing | Ask the administrator to assign you the permission |
| I only see 50 lines | It is the default page size | Press Next or export to CSV / PDF to see everything |
Frequently asked questions
How do I find a specific movement?
Filter by the Account where the movement should be and use the date range to narrow the period. The journal entry number in each row is clickable and takes you to the full entry with all its lines.
Can I export the ledger to Excel?
Yes. The CSV format downloads all the ledger lines with the active filters (account, cost center, range). It opens directly in Excel or Google Sheets. The PDF format is also available for formal presentations.
Why does the running balance not appear?
The Running Balance column is shown only when you have a specific account selected in the filter. Without that filter, mixing balances from different accounts makes no accounting sense.
Do draft entries appear in the ledger?
No. Only entries in POSTED status are listed. If you are looking for a recent movement that does not appear, verify that the entry is posted in Accounting → Journal entries.
Can I filter by more than one account at a time?
Currently the filter supports one account at a time. For a summary of several accounts side by side, use the Trial Balance, which lists all accounts with the period's balances.
Related
Trial balance
Opening balances, period movements and closing balances by account to verify the integrity of the accounting ledger.
Fiscal configuration
Electronic issuer data (RNC, legal name, trade name, branch), environment selector, and certificate decision. Mandatory base to issue electronic fiscal vouchers.