Worksheet

The system will produce a worksheet to use in preparing your adjusting entries. You will normally run the worksheet after you have entered your transactions each period. This worksheet will show the temporary balances and you can make any necessary adjustments and then process the adjustments into the system. The worksheet will show whether or not the books are in balance and will show the profit or loss to date.

You can also produce a worksheet to be used in preparing a new budget. This worksheet will show the account balances for the past two years, along with last years budget.


10/31/00                                                  Your City Name

15:36:01                                            GENERAL LEDGER WORKSHEET

                                                         October 31, 2000



     ACCOUNT                                     TRIAL BALANCE          ADJUSTMENTS      PROFIT AND LOSS       BALANCE SHEET

     NUMBER     DESCRIPTION                   DEBIT        CREDIT   DEBIT

                                                                               CREDIT   DEBIT       CREDIT    DEBIT     CREDIT





  1    100      CASH-OPERATING ACCOUNT      7263.85
*
*
*
|        *
*
*
1    110      CASH-CUSTOMER DEPOSIT      20260.00
*
*
*
|        *
*
*
1    120      CASH-BOND FUND              3590.00
*
*
*
|        *
*
*
1    130      DEPRECIATION FUND          23425.00
*
*
*
|        *
*
*
1    150      SAVINGS                    12000.00
*
*
*
|        *
*
*
1    200      ACCOUNTS RECEIVABLE -      19620.35
*
*
*
|        *
*
*
1    250      INVENTORY                  16125.00
*
*
*
|        *
*
*
1    300      PLANT, PROPERTY, & EQU   2176850.00
*
*
*
|        *
*
*
1    310      ACCUMULATED DEPRECIATI                -1300175.00
*
*
*
|        *
*
*
1    400      ACCOUNTS PAYABLE                        -17670.35
*
*
*
|        *
*
*
1    410      FICA TAXES PAYABLE                        -510.41
*
*
*
|        *
*
*
1    420      FEDERAL WITHHOLDING PA                    -286.20
*
*
*
|        *
*
*
1    430      STATE WITHHOLDINGS PAY                     -75.50
*
*
*
|        *
*
*
1    490      OTHER PAYROLL DEDUCTIO                    -260.00
*
*
*
|        *
*
*
1    500      BONDS PAYABLE                          -126420.00
*
*
*
|        *
*
*
1    600      FUND BALANCE                           -798795.72
*
*
*
|        *
*
*
**NET INCOME OR LOSS      34,941.02



  1    700      WATER REVENUE                          -107335.60
*
*
*
|        *
*
*
1    710      SEWER REVENUE                           -52888.95
*
*
*
|        *
*
*
1    720      SANITATION                              -20514.10
*
*
*
|        *
*
*
1    730      OTHER                                     -356.00
*
*
*
|        *
*
*
1    800      SALARIES                   62870.00
*
*
*
|        *
*
*
1    810      PAYROLL TAXES               3524.76
*
*
*
|        *
*
*
1    820      SUPPLIES                    7630.76
*
*
*
|        *
*
*
1    830      REPAIRS                    14219.91
*
*
*
|        *
*
*
1    840      UTILITIES                  11242.70
*
*
*
|        *
*
*
1    850      DEPRECIATION               28000.00
*
*
*
|        *
*
*
1    860      CHEMICALS                  16776.50
*
*
*
|        *
*
*
1    870      OTHER                       1889.00
*
*
*
|        *
*
*
WORKSHEET PROOF TOTALS      2,425,287.83 -2,425,287.83