Overview

The General Ledger is a report that provides a comprehensive view of all transactions for all accounts within a specified date range.

The General Ledger report can be found under the Accounting section of the Main Menu.

To generate the report, simply enter the desired date range in the Date Range drop-down and click the Go button.

This range typically covers a specific period, like the current financial year or a tax reporting period, and the drop-down offers quick selection options to make the process easier.

You can select from one of the following Date Range options:

1. Current Week (starting from the Sunday of the current week)
2. This Month
3. Last Month
4. This Quarter
5. Last WQuarter
6. Current FY (Financial Year)
7. Last FY(Financial Year)
8. Custom - The custom range allows you to specify Dates for the start and end dates of the report

You can also filter on a specific account if you want to only look at one or a few at a time. This will speed up the report and reduce the amount of data presented, making it easier to review. If you leave the account selection field empty, you’ll run the report for all accounts.

Note that accounts will only show transactions if they exist. In other words, if an account doesn’t appear, there are no transactions for that account for the specified date range.

If you’re expecting to find a transaction and it doesn't appear, double-check the date range or the account. It’s possible that the transaction has been allocated to the wrong account.

The General Ledger is colour-coded, making it easier to identify different account types when scrolling through a long report.

You can export the General Ledger report as a CSV file for further manipulation or analysis in a spreadsheet.

The following fields are included on the General Ledger report:

1. ID - This is the ID that the transaction is associated with.
   For example, if a transaction represents a line item from an invoice, the ID will be the number (ID) of that invoice.
2. Date - This is the date that the transaction is recorded.
   For example, if a transaction is a line item from an expense, this date will be the date of the expense.‍
3. Description - This is the description of the document that the transaction relates to. e.g. if this transactions if from an Invoice then this will be the Invoice Title
4. Debit ‍
5. Credit
6. Balance
   The Balance column shows you the balance based on the Opening Balance plus or minus any transactions that have been entered for this Account since the beginning of time (Note that the beginning of time in Beeswax Terms is anything after 2000).

‍