What Is a Ledger Report?
A Ledger report is a customized report that you create to view transaction details for a company. You can report on transaction activity in the current year, the last year, the next year or a selected year.
Define the report options using Ledger Report Setup (GL50.1) and run the report using General Ledger Report (GL290). The options you define for a ledger report :
-
which transactions are selected for the report
-
which transaction fields print
-
how selected transactions are sorted, totaled, and printed
You can include beginning balances, transaction activity, and ending balances on the report. The title areas and report totals for the report are pre-defined, and the report prints one 78-character detail line for each transaction based on the fields you select for printing and the sequence number you assign to each field.
Ledger reports can be used to create audit work papers or transaction listings to analyze business issues. You filter Ledger reports to limit the transaction activity that is included.
Example
The controller of LGE, Incorporated needs a listing of all general ledger transactions greater than $100,000. She defines a Ledger report to create the listing. She filters the report to include only transactions with a dollar amount over $100,000.
To further organize the report, she defines the order in which she wants the columns to appear on the report and includes totals by source code. The following sample shows a portion of the Ledger report that she created.
GL290 Date xx/xx/xx Company 4321 - LGE Corporation USD Page 1
Time 10:26 LGEREPORT - LGE General Ledger Report Sort Accounting Unit, Account
For Period 01 - 01 Ending January 31, xxxx Type Amounts
Activity Transactions Only
Accounting Unit 101 Corporate Resp Controller Level 01-01
Transaction Desc Sy Jrnl Ent SC Debit Credit Balance
----------------------------------------------------------------------------- ----- ------ -------
Account 11200-0000 Cash-Checking 0.00
Monthly Sales GL N 1 JE 100.00
Misc. Medical Expens GL N 32 JE 1,150.00
Adjustment to Beg. B GL N 35 JE 1,150.00
Cash from Cash Sales GL N 49 JE 5,000,000.00
Monthly Sales GL N 51 JE 100.00
Total Activity Account 5,001,350.00 1,150.00 5,000,200.00
11200-0000 Cash-Checking Total 5,000,200.00
------------------------------------------------------------------------------------------------------------------------------
Account 11300-0000 Cash-Other 0.00
Monthly billing GL N 4 JE 800.00
Misc. Cash Sales GL N 8 JE 2,000,000.00
Total Activity Account 2,000,000.00 800.00 1,999,200.00
11300-0000 Cash-Other Total 1,999,200.00
------------------------------------------------------------------------------------------------------------------------------
Account 11400-0000 Cash-Payroll 0.00
Deposited Cash for P GL N 49 JE 5,500,000.00
Total Activity Account 5,500,000.00 5,500,000.00
11400-0000 Cash-Payroll Total 5,500,000.00
------------------------------------------------------------------------------------------------------------------------------
Account 12100-0000 Accounts Receivable-Trade 0.00
6 mos advance billin RJ N 3 JE 3,000.00
post revenue to acti GL N 14 JE 1,000,000.00
Adjustment to Beg. B GL N 35 JE 3,000.00
Total Activity Account 1,003,000.00 3,000.00 1,000,000.00
Account 15300-0000 Miscellaneous Inventory 0.00
ER200 PO N 2 PO 69.00
ER200 PO N 2 PO 86.00
ER200 PO N 2 PO 150.00
ER200 PO N 2 PO 25.00
Total Activity Account 330.00 330.00
15300-0000 Miscellaneous Inventory Total 330.00
==============================================================================================================================
Company 4321 Totals:
Debit Transactions 39,205,420.00
Credit Transactions 39,205,420.00
Debit Balances 22,628,456.00
Credit Balances 22,628,456.00