Chapter 1
Preparing for GAAP Checklist

1.1 Preparing for GAAP Reporting

The following is a sequence of steps which a district should consider as they prepare for the GAAP startup year. A number of these steps reflect decisions that should be addressed in a "Board Policy" Manual. This is a document which needs to be prepared early in the planning stage in cooperation with the district board of education, the superintendent, the treasurer, and possibly others.

1.1.1 GAAP and Pre-GAAP Periods

This guide will refer to "GAAP reporting", a district being on "GAAP", or the "Pre-GAAP" period. The definitions of these terms follows:
Term Meaning
GAAP Generally Accepted Accounting Principles
GAAP Reporting Producing an annual general purpose financial statement which contains a balance sheet or producing a complete annual financial report (CAFR)
Being on GAAP This means that the district has started the period of GAAP reporting and the GAAP flag on the EISMNT/DATSCN record has been set to "Yes".
Pre-GAAP Period The period of time when the GAAP flag on the EISMNT/DATSCN record is set to "No"

1.1.2 Board Policy Issues

1.1.3 Checklist of Steps

Prior to Beginning of First Reporting Year

  1. Run the USAS program USASDAT and set the EIS pending file flag if you wish to have the software transfer p.o. data from the invoice file directly to the EIS pending file. If an appraisal company will be doing an inventory, an appropriate time to set the pending file flag in USASDAT would be as soon as the inventory is finished so as to catch all new items which were acquired after the inventory. Then hold these items on the pending file, and enter them on the EIS system after the appraisal tape is returned and loaded. If no appraisal is being done, set the pending file flag and begin entering items on the system as soon as possible.
  2. Contact the system manager to load an appraisal tape if you are starting up from scratch and/or to create the initial EIS files and set an initial value for the "Fiscal Year Closed" field on the configuration record in EISMNT/DATSCN.
  3. The district needs to determine what they are going to use for capitalization limits, and enter this data in the EISMNT/DATSCN program.
  4. All of the locally defined codes need to be in place in the EISMNT program.
  5. If the district is utilizing the life limit field in the capitalization criteria, they should verify that an asset's life expectancy has been entered correctly on screen 2 of the item record. Use EISSCN/ITMSCN to make modifications.
  6. The district should verify that the original cost has been entered for each item which is to be included on the GAAP reports, and update it if necessary using the EISSCN/ITMSCN program.
    Items which will be excluded from the GAAP reports are those items which do not meet the capitalization limits, items with a status of "disposed of", "inactive", or "old tag item", and items coded as operating leases. In addition, items may be included/excluded from the GAAP reports based on the entity ID field.
  7. The current fund, function, and asset class should be entered on the item record (screen 1) for each item which is to be included on the GAAP reports. Use the EISSCN/ITMSCN program for updates. It may be possible to enter the asset class by using the EISCHG program, but the fund and function will probably have to be entered on an item by item basis.
  8. If the district has any leased assets, they should make sure that these assets are correctly coded with an acquisition method of "leased" and whether it is an operating or capital lease (lease type field). Use screen 3 in the EISSCN/ITMSCN program. Operating leases are excluded from the GAAP schedules.
  9. Depreciation information must be entered and updated for proprietary fund assets. Use screen 2 in the EISSCN/ITMSCN program. Life-to-date depreciation should be updated using the EISDEPR program if changes are made to depreciation fields and it is necessary to recalculate the depreciation for the item from the beginning. The program EISCLS (fiscal year closing) will compute the actual depreciation at the end of the fiscal year.
  10. The district should add any new items which have been acquired prior to going on GAAP by using the Add option in the EISSCN/ITMSCN program.
  11. The district should post disposition transactions to dispose of any items which have been disposed of prior to going on GAAP. Use the Add option in the EISSCN/DSPTRN program.

    Note

    If these steps aren't done prior to beginning the first fiscal year on GAAP, the GAAP schedules may still be generated, but the GAAP change schedule will not be accurate. These fields should ideally be updated prior to beginning on GAAP reporting so that the beginning balance information may be stored properly.
  12. At this point, the district should follow the "Fiscal Year Closing Procedure" to close out the fiscal year. The last step of this procedure is to contact the system manager if the district is beginning on GAAP reporting this year.

During the First Reporting Year

The remainder of these steps may be done after the district has begun the fiscal year. These are things the district may want to update before the end of the first GAAP reporting year when the schedules will be run.

  1. The district may desire to enter historical acquisition transactions for at least their larger assets. This is so that the GAAP Schedule by Source will be more accurate (the source is determined by the acquisition method and fund portion of the account code entered on the acquisition transaction(s)). Items without acquisition transactions will be reported on a line "Prior to System Startup" on the GAAP Schedule by Source.
    Note that not all information need be entered on these historical acquisition transactions. All that is mandatory for the GAAP Schedule by Source to be generated is the tag number, acq. date, acq. type = A (Acquired), fund portion of the account code, and amount. The system will allow you to leave the remainder of the account code blank as well as the vendor and p.o. information.
  2. The acquisition method should be verified and updated if necessary. Donated or leased assets may need the acquisition method updated so that they may be correctly reflected on the GAAP Schedule by Source. Use screen 2 in the EISSCN/ITMSCN program.
  3. If the district has any entities they need to exclude from reporting or need to report separately, they should fill in the entity id field for those items associated with that entity. Use screen 1 in the EISSCN/ITMSCN program. This field can be used when it is time to generate the GAAP schedules in order to generate the reports for specific entities or exclude specific entities from the GAAP reports.

1.2 Fields Necessary for GAAP Reporting

The fields listed in the following table need to be completed on the item records before the GAAP flag on the configuration record in EISMNT/DATSCN has been set to "Y". That is, the district is still in the pre-GAAP period.
Field Notes
Fund Classification of asset by fund.
Fund Type Stored on the local code file for each fund code defined. This defines the fund as Governmental, Proprietary, or Fiduciary.
Function/Activity Classification of asset by function/activity.
Asset Class Classification of asset by class (type).
Status Only items coded as Active, New Items, Excess Asset Not in Use, or Excess Asset Held for Sale will be considered as active for the GAAP reports. Items with a status of Disposed Of, Inactive, or Old Tag Item will not be included (although disposed of items are included as a decrease on the GAAP change schedules).
Original Cost Historical cost of the item is reported on the GAAP reports.
Acquisition Method Indicates if the item is purchased, donated, or leased. This is necessary for the GAAP schedule by source.
Lease Type Capital or operating. Necessary for an item whose method is leased to determine whether it should be included on the GAAP reports (operating leases are excluded from GAAP reports).
Depreciation Information Depreciation is required for assets of proprietary funds. It is not necessary for General Fixed Assets.
Acquisition Transaction Information Acquisition transactions are necessary once on GAAP for the change schedule. Important fields for this schedule are the date, type, amount, fund, function, and class at time of acquisition, and the adjustment flag.
Historical acquisition information is utilized for the GAAP schedule by source. It is recommended that historical acquisition transactions be entered for at least the larger assets of the district. However, the schedule by source will provide a line "Prior to System Startup" for items with insufficient acquisition information on file. Note, all that is really necessary when entering historical acquisition transactions is the date (approximate), type, amount, and fund portion of the account code.
Disposition Transaction Information Disposition transactions are necessary once on GAAP reporting. Important fields for these transactions are the date, adjustment flag, and the fund, function, class, and original cost at the time of disposition.
Transfer Transaction Information Transfer transactions are necessary once on GAAP reporting. Transfer transactions are used to change an item's fund, function, or asset class. All of the fields are necessary for the reports.

1.3 Fiscal Year Closing

The following sequence of steps should be completed at the end of each fiscal year whether the district is on GAAP or not. This procedure can be done at any time after June 30; it has absolutely no relation to when the district closes the fiscal year for Uniform School Accounting System (USAS).

You should continue to add items received prior to July 1 to the system before using this procedure. If items were ordered prior to June 30, but are not received until after that date, they may properly be posted in the next fiscal year. You can continue to add items to the pending file even though they may not be posted until later.

Note

If the depreciation data has been changed so that it is necessary to completely recalculate the life-to-date (LTD) depreciation from the beginning for a number of items, you may need to run the program EISDEPR. However, if you have been tracking depreciation for some time, then this program should not be used. Contact your system manager before using the EISDEPR program.
  1. Run any year-end reports desired. The following are suggested:
    EIS101,102---GAAP schedules.
    EIS103(only if on GAAP)---GAAP Change Schedule.
    EIS104(only if on GAAP)---Depreciation Change Schedule.
    EIS303---Inventory Master Listing Report, to obtain an updated
    master list. This report is optional, depending on the
    wishes of the district.
    EIS304---Brief Asset Listing Report, to make available for the
    auditors. Run three times, sorting first by fund, sorting
    next by function, and lastly by class. Use just the
    "active" Status Codes: A,N,EH,EN. Also select both
    capitalized and non-capitalized items.
    EIS305---Book Value Report, to obtain depreciation information.
    Use the date 06/xxxx for the report (where xxxx is the
    fiscal year being closed). Use just the "active" Status
    Codes: A,N,EH,EN. Select capitalized items only.
    EIS401---Insurance Value Report, to be run if the district maintains
    current replacement cost and/or insurable value of the
    inventory item records.
    EIS801---EIS Audit Report, to obtain an official audit report for the
    auditors.
  2. Run the fiscal year closing program EISCLS. Type


        $ RUN OECN$EIS:EISCLS 
    

    at the $ prompt or from the menu system


        Menu>EIS 
        Menu>EISCLS
    

    This program will update the life-to-date depreciation for the current fiscal year being closed. A summary report, EISDEP.TXT, of the current year's depreciation posted by fund will be generated. The program will also update the fiscal year closed field on the EISMNT/DATSCN record. If the district is currently on GAAP, the program will also update the beginning balances for the new fiscal year and generate the report EISCLS.TXT.

  3. If you are going to begin GAAP reporting for the coming fiscal year, contact your system manager. The system manager will run a one-time GAAP program which will set the GAAP flag to "Y" on the EISMNT/DATSCN record and set the beginning balances for the first GAAP year. Do NOT perform any additional processing until your system manager has instructed you to continue.

1.3.1 Fiscal Year Closing Report

Projection Report - EISDEP.TXT

Running the EISCLS program will produce a summary depreciation report such as the following:


 
 
Date: 07/23/92                            SAMPLE CITY SCHOOLS                            Page:    1 
Time:  9:29 am                  Depreciation Posting Report - Projection                  (EISCLS) 
                                         EIS GAAP Flag is OFF 
 
                              Depreciation        Book Value       Depreciation         Book Value 
                               Posted for        After Posting      Posted for         After Posting 
 Fund  Description             All Items          All Items      Capitalized Items    Capitalized Item 
 
       Undefined                    0.00           18,132.36              0.00            14,445.46 
 001   GENERAL FUND             2,100.01        1,722,472.79          1,629.40         1,385,429.68 
 006   FOOD SERVICE               187.24            2,376.14            180.17             2,229.58 
 572   CHAPTER 1                  158.29           10,474.00             80.08             6,238.15 
                   Total:       2,445.54        1,753,455.29          1,889.65         1,408,342.87 
 


Note that this report indicates how the GAAP flag is set and displays the total depreciation for the year being closed and the current book value for both capitalized items and for all items.

Projection Report - EISCLS.TXT

Running the EISCLS program will also produce an ending balance report such as the following, if the district is on GAAP reporting:


 
Date: 10/13/94               SAMPLE CITY SCHOOLS                   Page:    1 
Time:  1:30 pm        Ending Balances by Fund - Projection         (EISCLS) 
    Fund      Description                                Ending Balance 
              Undefined                                      14,445.46 
    001       GENERAL FUND                                1,407,945.33 
    006       FOOD SERVICE                                    5,322.44 
    572       CHAPTER 1                                       6,735.16 
                                      Total:              1,434,448.39 
                                                                      
Date: 10/13/94               SAMPLE CITY SCHOOLS                   Page:    2 
Time:  1:30 pm      Ending Balances by Function - Projection       (EISCLS) 
    Function  Description                                Ending Balance 
              Undefined                                      12,487.06 
    1110      ELEMENTARY TEACHERS                           277,468.92 
    1130      H.S. TEACHERS                                 222,697.98 
    1226      D.H. TEACHERS                                   3,283.94 
    1270      CHAPTER 1                                       6,735.16 
    2122      COUNSELING                                      4,346.66 
    2134      HEALTH SERVICES                                     0.00 
    2190      PLAYGROUND, STUDY HALL                          3,141.60 
    2220      LIBRARY                                       207,453.02 
    2222      Invalid                                         1,499.30 
    2223      AUDIO VISUAL                                   17,417.12 
    2310      BOARD OF EDUCATION SERVICES                         0.00 
    2411      SUPERINTENDENT                                 21,219.14 
    2421      PRINCIPAL                                      52,105.56 
    2510      TREASURER                                       7,702.10 
    2700      MAINTENANCE                                   126,504.52 
    2820      BUSES                                         338,200.00 
    3120      CAFETERIA                                     105,818.16 
    4500      ATHLETIC                                       23,736.15 
    4600      SCHOOL & PUBLIC SERVICE                         2,632.00 
                                      Total:              1,434,448.39 
                                                                      
Date: 10/13/94               SAMPLE CITY SCHOOLS                   Page:    3 
Time:  1:30 pm        Ending Balances by Class - Projection        (EISCLS) 
    Class     Description                                Ending Balance 
              Undefined                                      12,487.06 
    0200      BUILDING & IMPROVEMENTS                         4,820.25 
    0300      FURNITURE,FIXTURES,EQUIPMENT                1,417,141.08 
                                      Total:              1,434,448.39