Description
The General Ledger report is designed to give a quick view of financial activity impacting each Location within SoftLedger. The report displays starting and ending balances, and the net change from activity between those balances. To review further, you can click into any balance to see the Journal Lines that comprise the balance in view, as well as export to excel to get the detailed line items making up the activity during the period per Ledger Account.
Report Configuration Settings
Location: Includes journal lines for this location only (doesn't include children). Defaults to the Location in the Location Picker if left blank.
Start Date: Includes journal lines on or after this date. Defaults to the start of the fiscal year based on the date in the Date Picker.
End Date: Include journal lines on or before this date. Defaults to the Date in the Date Picker.
Journal Status:
All: Include all journal lines (Default)
Posted: Only include posted journal lines
Draft: Only include draft journal lines
Hide Zero Activity: Exclude ledger accounts that have no activity during the date range.
Export Configuration: Select the columns to be included for the detail in the journal lines of an excel export
Report View
Columns
All columns are visible by default and can be sorted, hidden, pinned, and re-ordered.
Number | Ledger Account Number (default sort) |
Name | Ledger Account Name |
Type | Ledger Account Type (Asset, Revenue, etc.) |
Sub-Type | Ledger Account Sub-Type |
Report Group | Ledger Account Report Group |
Starting Balance | Sum of the journal lines (debit-credit) prior to (not including) the Start Date |
Debit | Sum of the debit journal lines from the Start Date through End Date (inclusive) |
Credit | Sum of the credit journal lines from the Start Date through End Date (inclusive) |
Net Change | Sum of Debit-Credit columns |
Ending Balance | Sum of Starting Balance and Net Change columns |
Filtering
The General Ledger report can be filtered by the below fields:
Number
Name
Type
Report Group
Enter Ledger Account Name or Number within the Search Accounts field next to the magnifying glass icon.
Balance Drill Down
Clicking into the Ending Balance of any cell for any Ledger Account will display the Journal Lines associated with the balance displayed.
Saving Report
The following report configurations are included when saving a report:
Location
Start Date
End Date
Journal Status
Hide Zero Balances
Export Configuration
Filter text
Column Positioning (pinning/sorting/order)
Export
Exporting the report will show the summary rows as well as the journals lines that make up the balance. The report will include a running balance for each account as well. Each account will show a maximum of 10,000 journal lines. If there are more lines than that, it will be truncated and noted in the export.
If a specific Ledger Account has more than 10,000 rows making up the balance, adjust the date period to a smaller date period to capture all rows in an export.
When exporting, customize which columns are included by clicking into the Export Configuration button:
