EIS

Fiscal Year-end

Closing Procedures

and Updates

May 14, 2009

2

Disclaimer

• These are generic procedures intended for use by ITC’s in creating their own local procedures. Districts should use the procedures provided to them by their ITC.

Overview

New Capital Assets EMIS Requirement

New EISEMS Program

EIS fiscal yearend closing procedure

3

New Capital Assets EMIS Requirement

New reporting requirement for Period H (July)

Open July 2 – Sept. 25

Total Original Costs by Asset Class Total Depreciation by Asset Class Presented same as in notes to GAAP

financial statements

4

5

ABalance at

6/30/08

BAdditions

C

ReductionsA + B - CBalance at

6/30/09

Governmental Activities

Nondepreciable Capital Assets

Land $568,026 $ 0 $ 0 $ 568,026

Construction in Progress 0 2,567,899 0 2,567,899

Total Nondepreciable Capital Assets ❶ 568,026 2,567,899 0 3,135,925

Depreciable Capital Assets

Land Improvements 298,799 175,745 0 474,544

Buildings and Building Improvements 17,014,793 886,154

017,900,947

Furniture, Fixtures, and Equipment 276,124 42,478 (69,454) 249,148

Vehicles 2,023,796 181,110 (199,314) 2,005,592

Total Depreciable Capital Assets ❷ 19,613,512 1,285,487 (268,768) 20,630,231

Less Accumulated Depreciation

Land Improvements (20,291) (14,669) 0 (34,960)

Buildings and Building Improvements (3,816,987) (180,484) 0 (3,997,471)

Furniture, Fixtures, and Equipment (201,807) (12,868) 65,968 (148,707)

Vehicles (1,082,903) (143,775) 199,314 (1,027,364)

Total Accumulated Depreciation ❸ (5,121,988) (351,796) 265,282 (5,208,502)

Depreciable Capital Assets, Net ❹ = ❷+ ❸

14,491,524 933,691 (3,486) 15,421,729

Governmental Activities

Capital Assets, Net ❶ + ❹ $15,059,550 $3,501,590 ($3,486) $18,557,654

EMIS Fields Required

Capital Assets Code (QC971) Specifies which row of statement One record reported for each code (row) with

non-zero amounts

Old Balance (QC972) Additions (QC973) Deductions (QC974)

6

Capital Assets Codes

NDC Capital Assets not being depreciated, Construction in Progress NDL Capital Assets not being depreciated, Land DBI Depreciable Capital Assets, Buildings and Building

Improvements DBK Depreciable Capital Assets, Books DFE Depreciable Capital Assets, Furniture, Fixtures and Equipment DIN Depreciable Capital Assets, Infrastructure DLI Depreciable Capital Assets, Land Improvements DVE Depreciable Capital Assets, Vehicles

7

Capital Assets Codes (Cont.)

LBI Accumulated Depreciation, Buildings and Building Improvements

LBK Accumulated Depreciation, Books LFE Accumulated Depreciation, Furniture, Fixtures and

Equipment LIN Accumulated Depreciation, Infrastructure LLI Accumulated Depreciation, Land Improvements LVE Accumulated Depreciation, Vehicles See EMIS Guide, Ch. 4 for definitions of each category

8

New EISEMS Program and .COM Procedure

EISEMS.COM procedure Prompts for Entity ID’s to include or exclude Runs EIS103 for Original Cost amounts Runs EIS104 for Depreciation amounts Compiles results into EISEMS.SEQ file

Ch. 5 EMIS Sequential file with Capital Assets infoLoad into EMIS in normal manner

Generates summary reportSimilar to sample on slide 5

9

EISEMS Functionality

Governmental assets only Fund type = “G” From EISMNT/FNDSCN for “current fund”

Excluded/Error if no or invalid Asset Class For Asset Class 01xx

Uses “Depreciation Method” to determine Code

10

EISEMS Asset Class Mappings

01xx = NDL if Depreciation Method = N 01xx = DLI, LLI Land Improvements 02xx = DBI, LBI Buildings/Improvements 03xx = DFE, LFE Furniture/Fixtures/Equip. 04xx = DVE, LVE Vehicles 05xx = DIN, LIN Infrastructure 06xx = DBK, LBK Books 08xx = NDC Construction in Progress

11

EIS Items to Check

“Land” items have Deprec. Method = “N” Fund types all entered and accurate

EISMNT/FNDSCN

Capitalized items all have accurate “Class” EISSCN/ITMSCN screen 1 Check with EISRPT/EIS304 Recommend sorting by AC,IC

12

EIS Fiscal Year-End Closing Procedure

Finish all current year processing. Items received prior to June 30th (2009) should be added to EIS for FY2009, Any items received after June 30th can be added to the EIS pending file for FY2010.

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 on some of these tags for some time, then this program might cause problems.

13

Districts with a Life Limit specified for the capitalization criteria may choose to run an EIS304 Brief Asset Listing to verify all items meeting the dollar capitalization criteria also have a valid Life Limit and are on file as capitalized assets.

In EIS304, select non-capitalized items and choose to select only items with an original cost equal or higher than the capitalization threshold. Items not meeting both of the capitalization limits will not be capitalized; therefore, this will produce a listing of any items that currently are not capitalized that most likely should be.

14

Enter capitalization option: (C,N,B,?) <B> _ NInclude or Exclude Lot Items by Quantity? (I,E,N,?): <N> _Enter selection option (1-9,*,?): <*> _Do you wish to select items by original cost? (Y,N,?) <N> _ YEnter original cost: < .00> ________.__ 1000

EIS Fiscal Year-End Closing Procedure

Fiscal Year-End Closing Procedure

15

When all items have been entered, run the recommended list of reports (this includes all necessary GAAP schedules).

All recommended FYE reports are explained in the upcoming slides.

16

EIS101 – Schedule of Fixed Assets by Source…..provides a summary of the original cost of capitalized items by their source or the fund the items were originally charged to when purchased.

Source means “the fund the items were originally charged to when purchased”. EIS101 uses the PO information from the acquisition record (ACQTRN) to identify the source fund used in purchasing the items.

Output file: EIS101.TXT EIS102 – Schedule of Fixed Assets by Function and

Class….produces a schedule of fixed assets by function and class. Can be generated by function and class, class or a summary by function and class. Creates a summary and detail report

The Book Value on the report is the Original Cost minus the Total Deprecia Output files: EIS102S.TXT and EIS102D.TXT

Fiscal Year-End Closing Procedure

Contains “changes” in capital asset balances during the current fiscal year The EIS103 creates three reports as listed below:

The EIS103S is a summary report listing the beginning balance, acquisitions, dispositions, transfers in, transfers out, adjustments, and the ending balance in separate columns horizontally across the report.

EIS103D is a detailed schedule of changes. This report lists any individual tag numbers that may have incurred acquisitions, dispositions, transfers, or adjustments.

EIS103E is an error report. The summary and detail reports will page break on each fund type: fiduciary,

governmental, proprietary, and undefined.

The GAAP flag must be set to “Y” to be able to generate this report. For FYE, it is recommend to generate the report 3 different ways (AC, FC &

FD). Specific entities can be included or excluded (i.e. NOGAAP)

17

EIS103

18

+ +- - + =

19

Totals by Fund Type on the EIS101, EIS102, and EIS103 should match when balancing out for the fiscal year-end. Any errors reported on the EIS103E report

should be resolved prior to closing the fiscal year.

EIS GAAP Reports

Contains changes in depreciation of fixed assets during the fiscal year The EIS104 creates two reports as listed below:

EIS104S is a summary report listing the beginning depreciation, continuing items, acquisitions, dispositions, transfers, adjustments and ending depreciation balance in separate columns horizontally across the report. The following equation is used in determining the ending depreciation

EIS104D is a detailed schedule of changes. This report lists any individual tags numbers that may have incurred acquisitions, dispositions, transfers or adjustments

Reports will page break on each fund type: fiduciary, governmental, proprietary and undefined

The GAAP flag must be set to “Y” in order to generate a valid report. For FYE, it is recommended to generate the report 3 different ways (AC, FC &

FD) May be used as a depreciation balancing tool with the EIS305.

20

EIS104

+ +

-

+- -+ =

22

EIS303 – Inventory Master Listing…..includes all data on file for items; VERY LARGE report – it can produce a complete listing of all items or of specified subsets (i.e. generate a report of just depreciation information for all items); don’t recommend printing out a hard copy of the report.

EIS304 – Brief Asset Listing….. a one line per item listing of all items on file or subsets; The following EIS304 reports are recommended…they include capitalized items only and Status Codes of “A, N, EH, and EN” (with the exception of the disposition report).

Brief Asset Listing by fund Brief Asset Listing by function Brief Asset Listing by asset class Acquisitions for current fiscal year Dispositions for current fiscal year

Suggested Non-GAAP Reports

23

EIS305 – Book Value (Depreciation) Report…..shows depreciation information listing original cost, salvage value, book value, % of depreciation, and last year of useful life.

The date 06/xxxx (where xxxx is FY being closed) is used for the reporting date. The following EIS3045 reports are recommended…they include capitalized items only and Status Codes of “A, N, EH, and EN” (with the exception of the disposition report).

Book Value Report by function Book Value Report by class Depreciation for current FY dispositions by function Depreciation for current FY dispositions by class

Suggested Non-GAAP Reports

24

EIS401 – Insurance Values Report…..lists insurable values and replacement cost information for items; insurable values listed reflect the insurance classifications assigned to the item categories in EISMNT/CATSCN; Recommended if the district maintains current replacement cost and/or insurable values on the inventory item records.

EIS801 – Audit Report…..tracks changes made to the EIS files For FYE, select the Official Option and keep on file for

the auditors used for an official audit trail

Suggested Non-GAAP Reports

After checking EIS103/EIS104, run the EISEMS program (if on GAAP) EISEMS.SEQ file needs submitted via EMIS (period H)

Make a copy of the EIS files and other appropriate files. Run EISCLS

Creates EISCLS.TXT which includes ending balances by Fund, Function and Asset Class. (These are the beginning balances for the next year)

Creates an EISDEP.TXT which is a summary report of the current year’s depreciation posted by fund.

Advances EIS last FY closed flag in EISMNT/DATSCN by one year Adds one year’s worth of depreciation to LTD depreciation field Updates beginning balance fields for new FY

Once EISCLS is complete, they may start entering inventory for the new fiscal year.

25

Fiscal Year-End Closing Procedure

26

If not on GAAP, ITC needs to assist in helping the district start up on GAAP by running EISGAAP.

EISGAAP: run only once and at the beginning of the GAAP startup year. Sets GAAP flag in EISMNT/DATSCN to “Y” Creates beginning information fields for each asset (EISITM.IDX) Generates a beginning balance report for the GAAP startup year

Once EISGAAP is complete, they may start entering inventory for the new fiscal year.

Fiscal Year-End Closing Procedure

27

Questions?