header2

General Ledger

General Ledger Detail Report

 

General Ledger Detail Report provides a detailed record of all activity within an account for a given period(s) or by date range. It includes for each account a beginning balance, debits, credits, net posting, ending balance, posting date, source, batch number, and posting remarks. This report is an invaluable auditing tool to isolate operator errors. This report can be produced at any time, but it is highly recommended that it be printed prior to period ending.

  

The General Ledger Detail Report should also be run at the end of the fiscal year.  The report is also called, when printed at the end of a fiscal year, a Detail General Ledger.  This program will also print zero balance/zero activity accounts, if asked to do so.

 

 

Report Setup

 

Enter Starting and Ending date. Enter the date range for the report to print.  An actual date will need to be entered.  There is no option for all dates.

 

Enter Starting and Ending G/L Account. Enter the General Ledger account(s) for the report to print.  The report can print one account, a range of accounts, or all accounts.  It is recommended that all accounts be selected for the end of the month printing of the General Ledger.  This report is usually called a Detail General Ledger.  This will give the working papers a detail accounting of all activity in the General Ledger for the accounting period.

 

Source Journal. This report can be set up to print for a particular Source Journal.  For an explanation of Source Journals, refer to Daily General Ledger Transaction Audit on the G/L menu.  The detail report can print one Source Journal or all source Journals.  It is recommended that for the end of the month Detail General Ledger, all Source Journals be selected.

 

Include Zero Activity. This report can print only those accounts with activity or for all accounts, whether or not activity took place.  It is recommended that for the end of the month Detail General Ledger, enter "Y".  If the detail report is for the reconciliation of a single account, enter "N"

 

This is a good General Ledger account reconciliation report.  This is the report that should be printed if the Balance Subsidiary Ledgers, on the G/L menu, show a variance for either Accounts Payable or Accounts Receivable.

 

The report displays the account number, the beginning balance, the debit and credit activity with a total column called net change and an ending balance.

 

REMEMBER:  The General Ledger is updated by batches.  If a reconciling item is found in the General Ledger Detail Report, the auditing of the reconciling item will be in the binders holding the registers for the Source Journal referenced.

 

General Ledger Detail Report - GLE 8

DPG124

RECORD USED AND FILE NAME

AVAILABLE CRITERIA

INFO DISPLAYED (IN  COLUMN SEQUENCE)

SORTS BY

System Control - SD00

Select by Period or Date (Date Only.  Period Disabled)

Page divisions by G/L Account Number

Page divisions by G/L account

G/L Account Master - GL10

Start-End Dates

Period

number then by oldest transaction

Transaction History - GL12

Start-End Account Numbers (Individual, Range or All)

Date

first.

 

Source Journal (Individual or All)

Journal

 

 

 

Posting Comment

 

 

 

Beginning Balance

 

 

 

Debit

 

 

 

Credit

 

 

 

Net Change

 

 

 

Ending Bal (Ending Balance)