| Legler Systems Company | | | GL Reports | | | Contact Us | | | Help | | | Home | | |
The General Ledger reports can be requested at any time, sorted and printed on a line printer or a laser printer. Most general ledger reports are 120 characters wide (landscape), while some audit control reports are 80 characters wide (portrait). Also, these general ledger reports can be written to a temporary disk file for subsequent viewing in a separate report window by using procedure 92V or 92W.
A new 2018 option (Sys-Opt-44 in DB03) converts all uppercase letters to upper and lowercase letters when general ledger reports are printed for easier reading.
The standard general ledger reports are General Journal Report, Detail Account Report, Working Trial Balance, financial statements (Income Statement, Balance Sheet, and Cash Flow Statement), Fixed Journal Report and Budget Detail Report. Each of these standard reports have several variations based upon selection parameters entered online by the user. Preprinted forms can be used for the Financial Statements. Some 39 accounting and management reports printed by the General Ledger System from Legler Systems are identified below.
PROC S B General Ledger Report name and description
-- - - ---------------------------------------------------------
1. 02 N Y General Journal Report by entry period range.
2. 02 N Y General Journal Report by batch number (4).
3. 02 N Y General Journal Report by source type code (4).
4. 02 N Y General Journal Report by journal code (4).
5. 02 N N General Journal Summary by account code, source type code
and accounting period (5).
6. 03 N N Journal Posting Report - Preliminary.
7. 03 N N Journal Posting Report - Final.
8. 04 N Y Detail Account Report by entry period range.
9. 04 N Y Detail Account Report by account code (4).
10. 04 N Y Detail Account Report by department number (4).
11. 04 N Y Detail Account Report by source type code (4).
12. 04 N N Detail Account Summary by account code (5).
13. 05 N Y Working Trial Balance for all account codes.
14. 05 N Y Working Trial Balance for revenue and expense accounts.
15. 05 N Y Working Trial Balance for balance sheet accounts.
16. 05 N Y Working Trial Balance Summary by account (5).
17. 06 N N Closing Voucher Report - Create Preliminary.
18. 06 N N Closing Voucher Report - Create Final.
19. 06 N N Closing Voucher Report - Process (close period).
20. 07 N N Financial Statements - Income Statement - (2-4 columns).
21. 07 N N Financial Statements - Balance Sheet - (2-4 columns).
22. 07 N N Financial Statements - Cash Flow Statement - (2-4 columns).
23. 08 N Y Financial Operating Report - revenue accounts (4).
24. 08 N Y Financial Operating Report - expense accounts (4).
25. 08 N Y Financial Operating Report - Income Statement (4).
26. 09 N N Account Adjustment Report by batch - Preliminary (4).
27. 09 N N Account Adjustment Report by batch - Final (4).
28. 11 N N Year-End Balance Report - Preliminary.
29. 11 N N Year-End Balance Report - Final.
30. 12 N N Reversing Journals Report.
31. 13 N N GLS Batch Input Report - Preliminary.
32. 13 N N GLS Batch Input Report - Final.
33. 14 N N Fixed Journal Report.
34. 16 N N GLS Purge Control Report by period range - Counts only.
35. 16 N N GLS Purge Control Report by period range - File update.
36. 17 N Y Budget Detail Report by department - actual data (4).
37. 17 N Y Budget Detail Report by department - budget data (4).
38. 18 Y Y Chart of Accounts by department number (4).
39. 18 Y Y Chart of Accounts by Account-Type code (4).
--------------------------------------------------------------------------
Notes:
1. Column "PROC" refers to the online procedure number on the GL menu.
2. Column "S" means sort by account number, account type or Alphasort
when "Y", otherwise "N" means no record sorting.
3. Column "B" indicates both online processing and batch job processing
is available when "Y", otherwise "N" means no batch processing,
only online processing.
4. These general ledger reports can be printed for a single account code
or all account codes.
5. Summary reports are printed when the "Entry Correct" prompt = "S".
--------------------------------------------------------------------------
In addition to the standard general ledger reports identified above, custom general ledger reports can be created, sorted and printed by procedure DB12 in the Database Control System, where the user specifies the data content and report format.
The online procedures that print these general ledger reports are described in the General Ledger Menu document.