Inventory Fiscal Year End Checklist

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.

1. Add all new items for the fiscal year.
If using Pending Items, 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. Enter Acquisitions and Dispositions that occurred in the fiscal year.
3. Items that changed Fund, Function, or Asset Class can be updated using Transfers.
4. Generate and review the Acquisition/Original Cost Mismatch Report. This report helps to identify items that have an original cost value (on the item record) different than the total of qualifying acquisitions. When an item is created, the original cost is added for each acquisition marked to “update the original cost” so these totals would always match. Differences can only occur for items migrated from the Classic system that had missing acquisitions not added on migration.
Select Report Type: Can choose Fund, Function, or Asset Class
Select Item Statuses: Active, Excess Asset Held For Sale, Excess Asset Not in Use, New Item. (Disposed of items for the current fiscal year may also need to be reviewed but starting with the active items may help determine if these transaction types exist)

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

 5. When all assets have been entered, run any fiscal year-end reports desired.

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:

 

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.


The Audit Report is generated based on the system dates (timestamp), not transaction dates. If no activity occurred within the date range entered, this report can show No Data Returned. For districts that have recently started using the Inventory application, the audit report will show activity only for dates after they began entering data in the software.

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.

  • 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

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.

  • Brief Asset Listing sorted by fund

  • Brief Asset Listing sorted by function

  • Brief Asset Listing sorted by asset class

  • Acquisitions for the current fiscal year

  • Dispositions for the current fiscal year

Fiscal Year Ending Balances Report

 

Depreciation Posting Report

 

6. Balancing GAAP Reports

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.

Original Cost amounts on the following should match when balancing for FYE
Fixed Assets by Source
Fixed Assets by Function and Class - Original Cost
Schedule of Change in Fixed Assets - Ending Balance

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.

 

Schedule of Change in Fixed Assets

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

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.

Schedule of Change in Depreciation

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

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.

Book Value 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.

 

7. Under Core>Fiscal Years, close the current fiscal period by clicking the Close icon. 
  • 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.

8. 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. 
9. You are ready to begin processing for the new fiscal year.