Ideal Online Documentation

28562 G/L LISTINGS, REPORTS AND FORMS
GL5-14 Worksheet

 

PURPOSE

 

The worksheet program prints all of your general ledger accounts, each account's debit or credit balance as at the period specified as well as worksheet columns for adjustments, profit & loss adjustments and balance sheet adjustments.

 

Worksheet is accessed from:

  • G/L Main menu.

 

PROCEDURE

 

When you select Worksheet 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.

 

ENTER G/L PERIOD (MMYY)

 

Enter the month and year to report on.

 

THE DESCRIPTIVE DATE WILL BE 'AS AT JUNE 27, 2007'
** ENTER THE DESCRIPTIVE DATE DESIRED (CR IF THE ABOVE IS OK):

 

Enter a report description of up to 49 characters.

 

[Enter] to accept the default description.

 

PRINT ZERO BALANCES ? (Y/N)

 

"Y" to print accounts with zero balances.

 

"N" to not print accounts with zero balances.


** NUMBER OF COPIES ? (CR=ONE): __

 

Enter the number of copies to print.

 

[Enter] to print one copy only.

 

** PRESS CR TO CONTINUE:

 

[Enter] to continue to the print selection screen.

 

[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 Worksheet printout follows.

  



                                           IDEALWARE - SOLE DIVISION
06/28/07  17:50:15                                                                                       PAGE: 1
                                      DIVISIONAL TRIAL BALANCE WORKSHEET
                                  AS AT JUNE 28, 2007  (ACCOUNTING PERIOD 6)

-------------------------------------------------------------------------------------------------------------------
                        |          TRIAL BALANCE      |   ADJUSTMENTS     |  PROFIT AND LOSS  |   BALANCE SHEET   |
ACCOUNT                 |       DEBIT  :       CREDIT |  DEBIT  :  CREDIT |  DEBIT  :  CREDIT |  DEBIT  :  CREDIT |
------------------------|--------------:--------------|---------:---------|---------:---------|---------:---------|
00-1100   CASH FLOATS   |       300.00 :              |         :         |         :         |         :         |
------------------------|--------------:--------------|---------:---------|---------:---------|---------:---------|
00-1101   PETTY CASH    |       500.00 :              |         :         |         :         |         :         |
------------------------|--------------:--------------|---------:---------|---------:---------|---------:---------|
00-1110   BANK          |              :   187,048.64 |         :         |         :         |         :         |
------------------------|--------------:--------------|---------:---------|---------:---------|---------:---------|

...

------------------------|--------------:--------------|---------:---------|---------:---------|---------:---------|
00-6470   EMPLOYEE TRAIN|     1,822.03 :              |         :         |         :         |         :         |
------------------------|--------------:--------------|---------:---------|---------:---------|---------:---------|
00-7000   INTEREST      |    33,396.99 :              |         :         |         :         |         :         |
------------------------|--------------:--------------|---------:---------|---------:---------|---------:---------|
00-7200   MISC INCOME   |              :    11,074.50 |         :         |         :         |         :         |
------------------------|--------------:--------------|---------:---------|---------:---------|---------:---------|
00-7210   MISC EXPENSES |     3,493.88 :              |         :         |         :         |         :         |
------------------------|--------------:--------------|---------:---------|---------:---------|---------:---------|
DIVISION TOTALS         | 1,394,796.88 : 1,394,796.88 |         :         |         :         |         :         |
===================================================================================================================