Inventory tracking is required for the DHS grants. Inventory must be maintained from the initial purchase through 3 years following the close of the grant period.

To download a copy of the inventory click the link above.

1. When the form has opened click on the file.

2. Click "Save As".

3. Close the web browser.

4. Open the inventory you just saved to your computer.

* HINT * Save the inventory somewhere easily accessible to your computer.

The first page seen on the spreadsheet is called the totals page.

1. The first task is to add your grant amount to the Total Allocated row under the proper grant name (this can be found on your award letter)
2. You now can navigate to each spreadsheet by either clicking the grant name above the allocated amount or clicking on the appropriate tab at the bottom, (if you do not see any tabs you will need to maximize the window)

To standardize the process some columns can only be filled in by the drop down box, you can active this by clicking on the cell and then clicking the down arrow on the right side and selecting the proper item.

As spreadsheets are filled out you will be able to see your progress on the Totals table, in which all the amounts for each grant will automatically add together. You should match the amounts to your own accounting recorded to ensure that you inventory matches up with your paper work.

When updates to the inventory are made we will send out an email informing all Grant Points of Contact of the change.

• You will need to open the updating spreadsheet by clicking the update button below, (Enable Macros) and follow the directions.
• Any request for password will be "ADEM"
• When the version update has completed you will see the header on the Totals page change to match the new version number indicated at the top of this page.

UPDATE

Updated inventory spreadsheets will need to be submitted to ADEM at least bi-annually (by July 31 and January 31); however you may submit more often as changes occur. Please submit these spreadsheets to ADEM via email. This will provide for duplicate records of your inventory, your copy to be maintained at the county level and ours maintained for all jurisdictions here at ADEM

When sending this document to ADEM please put "Inventory for (your jurisdiction)" in the subject line and send it to Kathy Hedrick. Any questions concerning the inventory may be directed to Kathy Hedrick at (501) 683-6700.

Thank you!