Inventory Fiscal Year End Checklist
Individual ITCs may supply slightly different instructions depending on the policies and procedures of the ITC. Therefore, these procedures are intended to be general guidelines only.
Pre-Closing Procedures
The following pre-closing procedures can be completed any time prior to closing the fiscal year.
Why this is important: Prior to November 2025, the Schedule of Change in Fixed Assets used the item’s original cost to calculate totals. Now, this report uses acquisition amounts. These figures should be the same. If they are not, this can cause differences with current report figures when compared to figures generated prior to the change. For more information about identifying and correcting items in this situation click here.
Fiscal Year-End Closing
The Inventory FYE Reports Bundle includes most of the suggested reports listed below; however, the selection options for bundled reports are pre-determined. If you prefer to run additional reports manually to customize your selections, the following reports are suggested.
| GAAP Reports | Versions Recommended to Run: |
|---|---|---|
Fixed Asset By Source |
| |
Fixed Asset By Function/Class Report | All three options | |
Schedule of Change in Fixed Assets Report | Schedule of Change in Fixed Assets by asset class (both summary & detail) Schedule of Change in Fixed Assets by function (both summary & detail) Schedule of Change in Fixed Assets by fund (both summary & detail) | |
Schedule of Change in Depreciation Report | Schedule of Changes in Depreciation by asset class (both summary & detail) Schedule of Changes in Depreciation by function (both summary & detail) Schedule of Changes in Depreciation by fund (both summary & detail) | |
| Non-GAAP Reports | Recommended to Run: |
Audit Report | Official Report Generate 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). If the report does not complete for the full fiscal year dates, smaller date ranges can be used. Running this report manually is optional. A copy of this report is included in the FYE Report Bundle.
| |
Asset Listing by Grant/Source |
| |
Book Value Report | Using the 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.
| |
Brief Asset Listing Report | 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.
| |
Fiscal Year Ending Balances Report |
| |
Depreciation Posting Report |
|
This step is meant to provide guidance on GAAP reports (or related reports) that can be reviewed to balance Original Cost, Depreciation, and review current FY changes for capitalized items. This is not intended to be an exhaustive list. Districts may take additional balancing steps as needed to ensure all transactions have been appropriately entered and balanced prior to closing the fiscal year.
The GAAP reports exclude:
Items that do not meet capitalization criteria.
Items which have a status of: "disposed of", "inactive", or "old tag item."
Items coded as operating leases.
The Fixed Assets reports compile totals related to the items' original cost values. The Fixed Assets by Source pulls these values from the acquisitions. The Fixed Assets by Function and Class pulls these values from the items. Balancing these reports confirms all is in balance between the item and acquisition records.
This report confirms changes to the Original Cost/Beginning Value from the start to the end of the year. Confirm the Beginning Value matches to the prior year Ending Balance. Any differences should be identified.
Summary Report columns | Beginning Value | Acquisition Amount | Disposition Amount | Transfer In Amount | Transfer Out Amount | Adjustment Amount | Ending Balance |
|---|---|---|---|---|---|---|---|
Description | Total Original Cost amount as of the start of the FY. Calculated using all acquisition amounts dated prior to FY start that are marked to Update Original Cost | Total of acquisitions entered in the current year. Could be new items entered or additional items added to existing items. | Total of all dispositions entered in the current year. Items are disposed for the total original cost. | Original Cost amount of transfers into this group in the fiscal year. (Fund/Function/Asset Class based on report parameters) | Original Cost amount of transfers out of this group in the fiscal year. (Fund/Function/Asset Class based on report parameters) | Includes the amount for any transactions that have the error adjustment flag checked and any items that changed capitalization status in the FY. Cap Changes may be due to an individual item becoming capitalized (acquisitions added that meet the threshold) or the Cap Criteria changing. | Total Original Cost amount as of the end of the FY. Beginning Value + Acquisition - Disposition + Transfer In - Transfer Out + Adjustments = Ending Balance. |
Balancing Notes | Confirm the Beginning Value of the current year balances to the Ending Balance of the prior FYE report. | Run a detail version of the report to view all acquisitions included in this total. | Run a detail version of the report to view all dispositions included in this total. | Run a detail version of the report to view all transfers in included in this total. | Run a detail version of the report to view all transfers out included in this total. | Run a detail version of the report to view all adjustments included in this total. | This should balance to the Beginning Value of the next year FY report. |
This report confirms changes to the LTD Depreciation from the start to the end of the year. Confirm the Beginning Depreciation matches to the prior year Ending Depreciation. Any differences should be identified.
Summary Report columns | Beginning Depreciation | Continuing Items | Acquisition | Disposition | Transfer In Amount | Transfer Out Amount | Error Adjust | Ending Depreciation |
|---|---|---|---|---|---|---|---|---|
Description | Total LTD Depreciation as of the start of the FY. Calculated using the total acquisition amount for the fiscal year the depreciation is being calculated for. | Fiscal to date depreciation for all items that were capitalized at the beginning of the year. | Depreciation for acquisitions entered in the current year. Could be new items entered or additional items added to existing items. | Depreciation for dispositions entered in the current year. Depreciation for items includes LTD Depr + FYTD Depr. | Depreciation amount for transfers into this group in the fiscal year. (Fund/Function/Asset Class based on report parameters) | Depreciation amount for transfers out of this group in the fiscal year. (Fund/Function/Asset Class based on report parameters) | Depreciation (LTD + FYTD) for transactions that have the error adjustment flag checked and any items that changed capitalization status in the FY. Cap Changes may be due to an individual item becoming capitalized (acquisitions added that meet the threshold) or the Cap Criteria changing. | Total Depreciation amount as of the end of the FY (LTD Depr + FYTD Depr). Beginning Depr + Continuing Items +Acquisition - Disposition + Transfer In - Transfer Out + Adjustments = Ending Depr |
Balancing Notes | Confirm the Beginning Depreciation of the current year balances to the Ending Depreciation of the prior FYE report. |
| Run a detail version of the report to view all acquisitions included in this total. | Run a detail version of the report to view all dispositions included in this total. | Run a detail version of the report to view all transfers in included in this total. | Run a detail version of the report to view all transfers out included in this total. | Run a detail version of the report to view all adjustments included in this total. | This should balance to the Beginning Depreciation of the next year FY report. |
This report is a Non-GAAP report but it can be helpful to review detail at the item level to compare to GAAP report totals.
The Book Value Report can be generated for GAAP items using the following parameters:
Current year
Capitalized items only
Status Codes: Active, New, Excess Asset Held for Sale, and Excess Asset Not in Use
Original Cost: Compares to Ending Balance on Summary Schedule of Change in Fixed Assets
LTD Depr: Compares to Beginning Depreciation on Summary Schedule of Change in Depreciation
Total Depr: LTD Depr + YTD Depr columns add to this total. Compares to Ending Depreciation on Summary Schedule of Change in Depreciation
Book Value: Original Cost minus Total Depreciation
This report generates for all items capitalized in the current year. Items that became capitalized during the current fiscal year will be included. The Book Value report doesn’t separate the LTD Depreciation for newly capitalized items (and is not intended to). This may result in a difference when balancing LTD Depreciation totals to the Beginning Depreciation on a Summary Schedule of Change in Depreciation report. The amounts for those items will be reflected in the Adjustments column on the Schedule of Change report and should be taken into account when reconciling totals between the 2 reports.
The Inventory FYE Report bundle will automatically generate when the posting period is closed. The bundle will be sent to the System>Document Storage page. A list of reports included in the bundle is listed here.
Document Storage has been released. Once the Inventory application is set up and connected to the district’s Inventory, any generated Report Bundles will be sent to the Document Storage found under the System menu. If the fiscal year was closed prior to Document Store being available, a FYE bundle will be generated and sent to the email 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 GAAP is enabled, the program will also update the beginning balances for the new fiscal year.
If a period is not closed before opening the next period, the beginning balance and LTD depreciation figures in the new period will not be accurate until the prior period is closed. Any reports generated in the new period containing LTD depreciation or beginning balance figures will not be accurate until the prior period is closed.