Enhanced Reporting - General Ledger Report

Created by Travis Lander, Modified on Mon, 18 Nov at 7:24 PM by Travis Lander

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

General Ledger Configuration

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

General Ledger Filter

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:

General Ledger Export Configuration