Report_Workflow_Concepts

General Ledger Reports & Prints WFPC

The Reports & Prints menu provides a wide variety of reports and prints with General Ledger information.

You can access the following programs from the GL Reports and Prints menu:

The Trial Balance/Detail Ledger allows you to print a trial balance (summary) displaying GL account number, description, beginning balance, activity and the resulting ending balance for the current GL period. It also prints a detail ledger (detail), which also displays GL account number, description, and rest of the information as the trial balance, but breaks down the activity by journal entry for the current GL period. The layout of the trial balance (in terms of totals) is set up in the Trial Balance Total Breaks F/M.

You have the option to print either a trial balance or a detail ledger.

Report information includes the following:

Trial Balance: the GL account number and description, beginning balance, activity and the resulting ending balance.

Detail Ledger: the Trial Balance information, but breaks down the activity by journal entry. Additional information printed on the detail ledger includes date of entry, journal number, entry number, memo and transaction amount. The total number of account numbers listed is also included.

NOTE: This report is always out of balance by the amount of retained earnings for the 1st period of the year.

The Journal Print allows you to print a list of journal entries for the current or next General Ledger period, as well as any prior period entries made through the Prior Period Journal Entry that have not been updated by the Prior Period Update. These journal entries are those entered through the Journal Entry program or posted automatically from other modules.

Journal entries are printed in journal and then entry order. Included on the journal print is all journal information originally field plus journal totals.

Report information includes the following: the journal number, entry number, entry date, memo, line numbers containing GL account number and description and amount posted. The total number of entries listed is also included. Should an entry, and consequently a journal total, be out of balance, this entry will be noted.

NOTE: During the first period of the fiscal year, the journal print will be out of balance due to the entry posted to retained earnings when the year was closed.

Templates that store "current period" (or similar values like "system date") resolve to the "current period at the time the report is run" rather than what the "current period" was at the time the template was created. For example: If you save a template for the Journal Print and select "Current Period" for the Period field, when that template is selected to run again (either manually or via Job Stream) the period is determined using the current period in the Company Periods & Ending Dates F/M (GLF970) when the report is run not the period when the template was created.

The Ending Balances Print allows you to print a report of the ending balances for account numbers for up to six successive periods. You can also select the ending period to print. The balances can be printed for up to six periods and for a single branch or department.

Because of limitations due to paper size, a maximum of six periods’ ending balances can be printed at any one time. The printout is broken down according to the breaks set up through the Trial Balance Total Breaks F/M.

Report information includes the following: GL account number, description, period and the ending balances for each of the periods selected. The total number of account numbers listed is also included.

Templates that store "current period" (or similar values like "system date") resolve to the "current period at the time the report is run" rather than what the "current period" was at the time the template was created. For example: If you save a template for the Ending Balances Print and select "Current Period" for the Ending Period field, when that template is selected to run again (either manually or via Job Stream) the ending period is determined using the current period in the Company Periods & Ending Dates F/M (GLF970) when the report is run not the period when the template was created.

The Budgets Print program allows you to print the budgets from the Budget F/M of account numbers selected for up to six successive periods. You can also select the ending period to print. Information in the budget file is created through the Budget F/M program.

Templates that store "current period" (or similar values like "system date") resolve to the "current period at the time the report is run" rather than what the "current period" was at the time the template was created. For example: If you save a template for the Budgets Print and select "Current Period" for the Ending Period field, when that template is selected to run again (either manually or via Job Stream) the ending period is determined using the current period in the Company Periods & Ending Dates F/M (GLF970) when the report is run not the period when the template was created.

Report information includes the following: GL account number, description, period, and budget figures for the periods selected. Because of limitations due to paper size, a maximum of six periods’ budgets can be printed at any one time. The printout is broken down according to the breaks set up through the Trial Balance Total Breaks F/M. The total number of account numbers listed is also included.

The Chart of Accounts prints a list of up to all General Ledger account numbers. GL account numbers are entered through the Account F/M program. Report information includes the following: GL account number, type of account, description and summary management type. The total number of account numbers listed is also included.

The Trial Balance Breaks Layout prints a layout of how the trial balance is to print. The layout is determined by the user, from the Trial Balance Total Breaks F/M. The data created by the Trial Balance Total Breaks F/M program determines the layout of this program. Report information includes the following: GL account number, description, amount and total group number. The total number of account numbers listed is also included.

The Yearly Trial Balance/Detail Ledger allows you to print a trial balance (summary) displaying GL account number, description, beginning balance, activity and the resulting ending balance for the periods that contain journal history. Another formatting option allows you to print a detail ledger (detail format) displaying GL account number, description, as well as the rest of the information in the trial balance, but breaks activity down by journal entry for the periods that contain journal history. You have the option to print either a trial balance or a detail ledger.

Report information includes the following:

Trial Balance: GL account number, description, period, beginning balance, activity and the resulting ending balance.

Detail Ledger: same Trial Balance information, but breaks down the activity by journal entry. Additional information printed on the detail ledger includes date of entry, journal number, entry number and memo.

The total number of account numbers listed is also included.

The Yearly Journal Print lists journal entries for the periods that contain journal history. This report provides a complete printout of all journal entries for as many closed periods that are stored in the yearly general ledger file (set in the general ledger Static Control F/M). This program prints yearly journal entries made by the Journal Entry program or posted automatically from other modules. Report information includes the following: each period, journal number, entry number and the journal entry in its entirety. Also printed are entry totals, journal totals and period totals. The total number of entries listed is also included.

The GL Code List prints a list of the various GL codes: journals, departments, report group codes and report formats. Each code is entered into the system through its own file maintenance program and used throughout the General Ledger module. Journal numbers are used for posting journal entries, departments may be embedded within the General Ledger account numbers, and report group codes and report formats are used for printing financial reports. Report information includes each code and the information stored with the code. The total number of codes listed is also included.