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" |
Prior to Beginning of First Reporting Year
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. |
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.
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. |
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.
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. |
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.
$ RUN OECN$EIS:EISCLS
|
Menu>EIS
Menu>EISCLS
|
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
|