Ideal Online Documentation

28551 G/L LISTINGS, REPORTS AND FORMS
GL5-04 General Ledger Report

 

PURPOSE

 

The general ledger report prints the opening balance, transactions and closing balance for each general ledger account for a selected period or year.

 

General Ledger Report is accessed from:

  • G/L Main menu.

 

PROCEDURE

 

When you select General Ledger Report from the G/L Main menu the following prompts display.

 

COMPANY OR DIVISION LEVEL REPORT ? (C/D):

 

"C" to print the company consolidated report.

 

This includes all divisions within the company.

 

 

"D" to print a dvisional report.

 

This will print the report for a selected division. You are prompted to select the desired division.

 

 

ENTER DIVISION NUMBER (CR FOR ALL):

 

Enter a specific division.

 

[Enter] to include all divisions.

 

** STARTING G/L ACCOUNT: _

 

Enter the first account code to include.

 

[Enter] for first G/L account.

 

** ENDING G/L ACCOUNT: _

 

Enter the last account code to include.

 

[Enter] for last G/L account.

 

** MONTH-END, RANGE OR YEAR-END REPORT ? (M/R/Y): M

 

[Enter] to accept the default "M".

 

"M" to print month to date figures for the selected period.

 

You are prompted to select the desired period.

 


ENTER G/L PERIOD: YYMM

 

Enter the desired year and month.

 

For each account the report will print the opening period balances, all of the period's transactions and the closing period balances.

 

 

"R" to print a range of period figures.

 

You are prompted to select the desired range of periods.

 

 

** ENTER G/L STARTING PERIOD: 200706 2007 PERIOD 6

 

Enter the desired starting period to include.

 

[Enter] to accept the default current period.

 

** ENTER G/L ENDING PERIOD: 200706 2007 PERIOD 6

 

Enter the desired ending period to include.

 

[Enter] to accpet the default current period.

 

"Y" to print year to date figures for the selected year.

 

You are prompted to select the desired fiscal year.

 

 

ENTER FISCAL YEAR NUMBER (CR FOR 2007):

 

Enter the desired fiscal year.

 

[Enter] for the current fiscal year.

 

For each account the report will print the opening year balances, all of the year's transactions and the closing year balances.

 

 

** DESCRIPTIVE DATE: FOR THE MONTH ENDED JUNE 30, 2007
ENTER THE DESCRIPTIVE DATE DESIRED (CR IF THE ABOVE IS OK):

 

Enter the descriptive date desired.

 

[Enter] to accept the default descriptive date.

 

SHOW SUB-ACCOUNTS SEPARATELY ? (Y/N): N

 

[Enter] to accept the default "N".

 

"N" to summarize each account to a single total.

 

"Y" to print each account's sub-account detail.

 

** PRINT ACCOUNTS WITH NO TRANSACTIONS BUT A BALANCE FORWARD ? (Y/N): Y

 

[Enter] to accept the default "Y".

 

"Y" to print accounts with no transactions but a balance forward.

 

"N" to not print these accounts.


** CONDENSED OR FULL PAGE FORMAT ? (C/F): C

 

[Enter] to accept the default "C".

 

"C" to print condensed format.

 

If you select "C" the following prompt is displayed.

 

 

** SKIP JOURNAL CODE AND SEQUENCE# ? (Y/N): Y

 

[Enter] to accept the default "Y".

 

"Y" to skip transaction journal code and sequence number.

 

This will enable the report to fit on the width of a screen, or 80 characters wide.

 

 

"N" to not skip the journal code and sequence number.

 

"F" to print fullpage format.

 

** PRESS F1 TO CONTINUE:

 

[F1] to continue to the print selection menu.

 

[F4] to exit to menu.

 

PRINTER SELECTION & CONFIGURATION

┌────────────────────────────────────────────────────────────────────────────────┐
│08/14/07                *****  PRINTER SELECTION  *****                         │
│                                                                                â”‚
│                                                                                â”‚
│** MAKE SURE PRINTER IS READY BEFORE PRESSING CR .....                          â”‚
│                                                                                â”‚
│1. PRINTER NAME ................................. P1  OKIDATA 390               â”‚
│                                                                                â”‚
│2. CHARACTERS PER INCH ? (10,12,17) ............. 10                            â”‚
│   SINGLE OR DOUBLE DENSITY ? (S,D) ............. S   SINGLE DENSITY            â”‚
│                                                                                â”‚
│** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS): _            â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
** PRESS CR TO SET PRINTER, OPTION# TO CHANGE, F4 TO END (BYPASS):

 

"1" to change printers.

 

"2" to change the CPI and/or print density.

 

[Enter] to print.

 

[F4] to not print and exit to the menu.

 

[F5] to display a list of printers for selection.

 

An example General Ledger Report follows.

  



                                                  IDEALWARE             
06/27/07  01:32:29                                                                                        PAGE: 1
                                        COMPANY GENERAL LEDGER REPORT
                                      FOR THE MONTH ENDED JUNE 27, 2007

------------------------------------------------------------------------------------------------------------------
ACCOUNT        PERIOD  JRN.    DATE    SOURCE  SEQ#  REF#    DESCRIPTION                    DEBIT           CREDIT
------------------------------------------------------------------------------------------------------------------

00-1100   CASH FLOATS                                        BROUGHT FORWARD               300.00 *

00-1101   PETTY CASH                                         BROUGHT FORWARD               500.00 *

00-1110   BANK - CURRENT                                     BROUGHT FORWARD                            187,770.32
                94/10  01    10/01/94  011117  7957  VO      I/V ORDER ENTRY             3,461.73
                94/10  01    10/03/94  011119  7958  VO      I/V ORDER ENTRY             7,962.03
                94/10  01    10/04/94  011120  7961  VO      I/V ORDER ENTRY            11,253.17

...

                94/10  J/E   10/31/94  LJ0264  0001  M/C     M/C SALE REFUNDED AS VISA   4,500.00
                94/10  J/E   10/31/94  LJ0265  0002  LJ264   TO REVERSE PREV J/E                          9,000.00

...

                94/10  PC    10/14/94  PC0098  8110  PC      A/P CHEQUE PRINTING                        490,820.40 
                94/10  PC    10/20/94  PC0099  8309  PC      A/P CHEQUE PRINTING                        179,277.67
                94/10  PC    10/30/94  PC0100  8878  PC      A/P CHEQUE PRINTING                        200,128.40
                94/10  PI    10/20/94  PI0413  8412  PI      A/P INVOICE POSTING                         19,988.16
                94/10  PI    10/25/94  PI0417  8543  PI      A/P INVOICE POSTING          7,823.26

...

                94/10  RC    10/03/94  RC0460  7803  RC      A/R CASH RECEIPTS POSTING  33,343.67
                94/10  RC    10/04/94  RC0461  7805  RC      A/R CASH RECEIPTS POSTING  28,270.20

...

                94/10  RJ    10/11/94  RJ0360  7780  RJ      A/R ADJUSTMENT POSTING                       4,070.69
                94/10  RJ    10/13/94  RJ0363  7959  RJ      A/R ADJUSTMENT POSTING                       1,691.68
                94/10  RJ    10/24/94  RJ0366  8410  RJ      A/R ADJUSTMENT POSTING                       1,357.31
                94/10  RJ    10/24/94  RJ0367  8444  RJ      A/R ADJUSTMENT POSTING        720.00
                                                                                       
                                                                                                     -------------
                                                                                                        187,048.64 



                                                                                     -------------    ------------
TOTAL FOR IDEALWARE:                                 ACCOUNTS: 125                   16,394,796.88 ** 1,894,796.88