General Ledger Reports

Created by Travis Lander, Modified on Wed, 30 Aug, 2023 at 5:10 PM by Sanjayan Arulsakaran

Description

The General Ledger gives the starting and ending balance per ledger account for a date period, along with the activity (journal entries) during that period.

The General Ledger is split into two options: Summary or Detail.

General Ledger Summary

The Summary General Ledger Page will show the full list of Ledger Accounts with with their starting balance, ending balance, and activity for the selected date range.

The Journal's Posted Date is used to determine if it is included.

Inputs

Start Date - Beginning date to use
End Date - Last date to use
Journal Status - Status of Journals to include (Draft, Posted, All)
Currency - Select the currency in which you would like to view this report.
Consolidated - Toggle ON to include the activity for the selected Location in the Location Picker, and all Locations that roll up to that selected Location. Toggle OFF to only include activity for the selected Location in the Location Picker.

Actions

In addition to the standard table functions, you can expand each Ledger Account row to view the Journal Entries included in the Activity column, (e.g. view the list of Journal Entries who's posted date is inside that date range).

To expand the row, click the icon:

General Ledger Detail

The General Ledger Detail page contains a running balance for a single ledger account

Inputs

Start Date - Beginning date to use
End Date - Last date to use
Ledger Account - Account to show transactions for.
Currency - Currency in which you hope to generate this report.
Journal Status - Status of Journals to include (All, Draft, Posted)

Note: The Reports are limited to 500 transactions per Ledger Account listed in the Summary or 500 transactions for the Ledger Account in the Detail. For Reports with more than 500 transactions for the date range, use the Journal Report to get the full list of transactions to excel, where you can manipulate the data to show starting and ending balances.