<< Click to Display Table of Contents >> Navigation:  Report Dashboard > General Ledger Detail - Report Writer > Description and Usage

The General Ledger Detail Report provides a list of all General Ledger accounts and activity for a specified time period. This report will sort first by account number sequence and then by date. This report should be printed and filed for audit purposes once per month. This report may also be printed at any time. This report should be run during Year End Close Procedures.

 

The General Ledger Detail Report contains the Account Number and Description, Transaction Date, any Memo and Reference detail, Journal Type, Batch and Sequence Numbers, and the total for each entry. The report also contains Beginning and Ending Balances for each account and a subtotal for each month’s activity. It also provides totals for each account type (Assets, Liabilities, Income/Revenue, Expenses, Other Income/Revenue and Other Expenses).

 

The Report Writer application allows the user to filter, sort and manipulate this report so that they may customize the data extracted out of the system. See the additional documentation on Report Writer for more information on these options.

 

 

General Ledger Detail - Report Writer

 

 

 

Listed below is an explanation of each column:

 

•Comp# (Company Number): Lists the company number where the General Ledger account number is retained.

 

•Account: Lists the General Ledger account number from the Chart of Accounts.

 

•Description: Lists the General Ledger account description from the Chart of Accounts.

 

•Beginning Balance: Beginning Balance of the account for the date range chosen.

 

•Ending Balance: Ending Balance of the account for the date range chosen.

 

•Date: Transaction Date for each entry made to the account number.

 

•Memo: Pulls from the Memo field used in Transaction Entry for additional information.

 

•Reference: Pulls from the Reference field used in Transaction Entry for additional information.

 

•Journal: Journal Type of each entry, which is determined by the entry source.

 

•CSNum: Displays the assigned CS Number of the individual who made the General Ledger entry.

 

•Batch: Unique number assigned by the system that represents which batch the entries were posted to. This number will change each time the Transaction Edit List is moved to permanent file.

 

•Seq.: Unique number assigned by the system that represents the order in which the entries affected the General Ledger account number.

 

•Amount: Dollar amount of each entry.

 

•Activity/End Balance: Consists of two totals. The first total represents the subtotal for each month's activity. The second total represents the ending balance for the date range selected.

 

•Type Total: Total for each account type that will print after all accounts are listed for each type of account.