The General Ledger report allows users to look at all transactions of an account for any date range.
You can download the General Ledger Report here.
Once you've downloaded the report, read our guide on importing the report into your database here.
After the report has been imported into your database, you may access it by navigating to Reports > Accounting.
Once you've selected the General Ledger report, you will see the option to select your date range, denoted by the calendar icon titled Date Range. Once you've selected the Date Range icon, you will be able to set your date parameters.
You can also decide whether or not balances with a 0 value will show up in your report by selecting or deselecting the Show Zero Balance checkbox.
Next, you will be presented with a pop-up window that will allow you to set the specific date range you'd like to set. This will include three tabs you can choose from: Simple, Advanced, and Date Range.
The Simple tab lets you choose from a list of pre-set conditions, such as "Today," "Yesterday," "Last Quarter," ect.
With the drop-down menu at the top of the window, you can also choose whether the date you're selecting is within, after, on or after, before or on and before the condition you've selected.
On the Advanced tab, you will be able to fully customize the dates you want to look at. For instance, you can specify by days. weeks, months, quarters, or years, and you can add in a custom value.
The Date Range tab provides a start and end date for you to specify, with the option to select directly from a calendar.
Once you are done filtering your dates, select Apply, and your summary of accounts will appear in the report.
Below is an explanation of each field on the form:
Type: This column will display the account name and include rows for the beginning balance, total balance, and all transactions that have occurred within the account.
Date: This displays the date of each transaction listed.
Payee: This column will display the person who made the transaction.
Ref Number (Reference Number): If you've assigned a reference number to a journal entry, it will appear in this column.
Memo: If you've assigned a memo to either an entry or transaction, it will appear in this column.
Split: If an expense or bill is split between two different payees, the other payee will appear in this column.
Amount: The value associated with any transaction or entry will display in this column.
Balance: This column displays the current balance of an account.
Once you're done, you can either export the report as an Excel spreadsheet with the Download Excel button, or you can print your report with the Print button.