Inventory Fiscal Year End Checklist

Owned by Sara Glore
Last updated: Mar 21, 2024
3 min read

This procedure outlines the steps to be taken to close Inventory for the fiscal year in the Redesign.

Pre-Closing Procedures

The following pre-closing procedures can be completed any time prior to closing the fiscal year. 

 1. Please ensure all pending items received prior to June 30th are entered as assets for the fiscal year.  If the PO items were ordered prior to June 30, but are not received until after June 30th, they should be added as assets in the next fiscal year.  Items can be pulled into the pending file,  even though they may not be posted in Inventory until next year, as needed.
 2. If the depreciation data has been changed so that it is necessary to completely recalculate the life-to-date (LTD) depreciation for several items, you may select the desired items from Transactions>Items grid and select 'Depreciate'.  

 3. Ensure items that meet or exceed the entity's capitalization threshold are marked as 'capitalized'. 

Fiscal Year-End Closing

  •  4. When all assets have been entered, run any fiscal year-end reports desired. The following are suggested:

GAAP Reports

  • Fixed Asset By Source (Classic's EIS101)

  • Fixed Asset By Function/Class Report (Classic's EIS102) - All Options

  • Schedule of Change in Fixed Assets Report (Classic's EIS103) - Only if on GAAP

    • Schedule of Change in Fixed Assets by asset class (summary & detail)

    • Schedule of Change in Fixed Assets by function (summary & detail)

    • Schedule of Change in Fixed Assets by fund (summary & detail)

  • Schedule of Change in Depreciation Report (Classic's EIS104) - Only if on GAAP

    • Schedule of Changes in Depreciation by asset class (summary & detail)

    • Schedule of Changes in Depreciation by function (summary & detail)

    • Schedule of Changes in Depreciation by fund (summary & detail)

Non-GAAP Reports

  • Asset Listing by Grant/Source (Classic's EIS203)

  • Brief Asset Listing Report (Classic's EIS304): The following EIS304 reports are recommended. The five reports should include capitalized items only and Status Codes of "Active, New, Excess Asset Held for Sale, and Excess Asset Not in Use" (with the exception of the disposition report)

    • Brief Asset Listing sorted by fund

    • Brief Asset Listing sorted by function

    • Brief Asset Listing sorted by asset class

    • Acquisitions for current fiscal year

    • Dispositions for current fiscal year

  • Book Value Report (Classic's EIS305): Recommended to run the following using current Fiscal Year (xxxx) for the reporting date. The four reports should include capitalized items only and Status Codes of Active, New, Excess Asset Held for Sale, and Excess Asset Not in Use for the full reports, and Status Code Disposed for the disposition reports.

    • Book Value Report sorted by function

    • Book Value Report sorted by class

    • Depreciation for current FY dispositions by function

    • Depreciation for current FY dispositions by class

If you DO NOT wish to close Inventory for the year until auditor review, you may hold off on completing the rest of the Inventory closing procedures until the audit is finished. However please note you will not be able to enter inventory for the new year until you have completed ALL of the closing steps.

  • Audit Report (Classic's EIS801): Run the official report

    • Recommend running the official option for ALL report types (leave 'select report type' blank to include all of them) and enter a date range for the entire fiscal year (Start Date 07/01/xxxx and Stop Date 06/30/xxxx).

  • Fiscal Year Ending Balances Report (Classic's EISCLS report)

  • Depreciation Posting Report (Classic's EISCLS EISDEP projection report)

  • 5. Go to Core>Configuration and verify the email address.

  • You may enter multiple email addresses separated by a comma.

  • 6. Under Core>Fiscal Years, close the current fiscal period by clicking

The Inventory FYE Report bundle will automatically generate when the posting period is closed. The bundle will be emailed in a zipped format to the email addresses listed in Core>Configuration

Closing the year will update the life-to-date depreciation amounts for the current fiscal year being closed and also update the fiscal year closed field in Core>Configuration.  If the entity is currently on GAAP, the program will also update the beginning balances for the new fiscal year

  • 7. Under Core>Fiscal Years, click Create to create the new fiscal year period. The existing dollar and life limit thresholds will carry over to the new year. Click the open folder to open the new year and to make it the current period.

 

If you are going to begin GAAP reporting for the coming fiscal year, please contact your ITC to enable GAAP. Otherwise, you are ready to begin processing for the new fiscal year.

  • Core>Configuration Enable GAAP option (Classic's EISGAAP equivalent)

    • JIRA issue #INV-332;  Estimated release 1.24.0