Overview

The General Ledger report gives you all the transactions for all accounts within a selected Date Range.

To generate a General Ledger report, simply go to Reports and click on General Ledger.

This will take you to the General Ledger report page where you will be able to enter the Date Range that you would like to run the report for. Usually this will be for a specific period, such as the Current Financial Year, or a Tax Reporting period. This is why there are quick selection options available in the Date Range drop down.

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

1. Last 7 Days
2. Last 30 Days
3. This Month
4. Last Month
5. This Financial Year
6. Last Financial Year
7. Custom - The custom range allows you to specify Dates for the start and end dates of the report

You can also specify a particular Account if you wish to only look at one or a few Accounts at a time. This will help speed up the report as well as reduce the amount of data that is presented. This can help reduce the amount of scrolling required to review the report. If you leave the this account selection field empty then you will 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 then there are no transactions for this Account for this Date Range.

If you're expecting something then double check the Date Range or the  Account. It is possible that the transaction you're expecting has been allocated to the wrong account.

The General Ledger has been set up so that each Account is colour Coded. This helps identify the various account types when scrolling through what can be a long report.

You can export the General Ledger report to 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 to. e.g. if a transaction represents a line item from an Invoice then the Id will be the Number (ID) of that Invoice.
2. Date
   This is the date that the transaction is recorded. e.g. 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).

‍