General Ledger
The General Ledger shows the complete transaction history for a single account, including a running balance. Use it to drill into a specific account and see every journal entry that has affected it over a given period.
Accessing the General Ledger
Section titled “Accessing the General Ledger”Navigate to Finance > General Ledger from the main menu.
Running a report
Section titled “Running a report”The General Ledger is an on-demand report. Configure the parameters and click Run to generate it.
- Select an account from the Account dropdown. The dropdown shows the account code, name, and category for each account.
- Set the From Date (defaults to the start of the current year).
- Set the To Date (defaults to today).
- Click Run.
The report loads all journal entries for the selected account within the date range and calculates a running balance.
Metrics
Section titled “Metrics”Once the report is generated, the following are shown:
| Metric | Description |
|---|---|
| Account | The code and name of the selected account |
| Entries | The number of journal entries in the period |
| Net Movement | The net change in the account balance over the period (green if positive, red if negative) |
Table columns
Section titled “Table columns”| Column | Description |
|---|---|
| Date | The transaction date of the journal entry |
| Period | The fiscal year period (format: YYYY-PP) |
| Reference | The source document type and number (e.g. “POS Sale #42”, “Client Invoice #7”) |
| Notes | Any notes recorded on the journal entry |
| Amount | The entry amount (green if positive, red if negative) |
| Balance | The running account balance after this entry |
A summary row is pinned to the bottom of the table showing the total amount and closing balance for the period.
Sorting
Section titled “Sorting”Click any column header to sort the report by that column.