Spreadsheet: 1872b6cb-4c97-41c7-9c68-08c87d8189ef
Sheet: Sheet1

Instructions: |  |  |  | "Line a" |  | Total fiscal year ending dollar balances are found on the last or total page of the Annual Inventory Report of Property MDB 020 printout.  If no value enter "None".
 |  |  |  | "Line b" |  | Adjustments that will increase the values on "Line a".  Only 4th Qtr Rejected Transactions or Posting Errors.
 |  |  |  | "Line c" |  | Adjustments that will decrease the values on "Line a".  Only 4th Qtr Rejected Transactions or Posting Errors.
 |  |  |  | "Line d" |  | TOTAL FISCAL YEAR-END -  the program will automatically calculate this line.
 |  |  |  | "SUMMARY OF INVENTORIES" - the program will auto fill this section. |  |  |  |  |  |  |  | PRINTING IS ON LEGAL SIZE PAPER
 |  |  |  | Submit  the form electronically with the page(s) of MDB Report 020, which contains the year-end dollar values entered on the SPO-017B, in PDF format.
 |  |  |  | SUBMIT ELECTRONICALLY BY SEPTEMBER 15TH TO: |  |  |  |  |  | [EMAIL] |  |  |  | (May be emailed directly to IMO in PDF format.  Check with your FO/ASO)
STATE OF HAWAII
STATE PROCUREMENT OFFICE
ANNUAL  SUMMARY  OF  INVENTORIES  REPORT
DEPARTMENT (DIV., SUB-DIV.,BR., ISLAND.) |  |  |  |  |  |  | PROPERTY  [NAME] (Full Name & Title) |  |  | PREPARED  BY (Full name) |  |  |  | DATE PREPARED |  | FISCAL  YEAR  ENDED
 |  |  |  |  |  |  |  |  |  | Phone:
ORG. CODE |  |  |  |  |  | R   E   C   A   P   I   T   U   L   A   T   I   O   N       O   F       I   N   V   E   N   T   O   R   I   E   S
D | D | S | I | LOC. | L |  |  |  | VEHICLES, EQUIPMENT |  | BUILDINGS  AND  IMPROVEMENTS |  |  |  | LAND AND IMPROVEMENTS
E | I | / | S | CODE | i |  |  |  | Property Code 3,4,5,6 & 7 |  |  |  | Property Code 2 |  | Property Code 1 & 8
P | V | D | L |  | n |  |  |  | Carrying  Value | Carrying  Value | Carrying  Value |  |  | Carrying  Value | Carrying  Value | Carrying  Value
T |  | I |  |  | e |  |  |  | On  Hand | Removed | On  Hand |  |  | Removed | On  Hand | Removed
 |  | V |  |  |  | Org Code Total from Annual
 |  |  |  |  | a | MDB  020  Computer Printout
 |  |  |  |  |  | ( As  of end of  4 th  Qtr )
 |  |  |  |  |  | Rejects or Posting Errors |  |  |  | Not Applicable |  |  |  | Not Applicable |  | Not Applicable
 |  |  |  |  | b | 4 th Qtr - ADDITIONS  From
 |  |  |  |  |  | Attached SPO-017A
 |  |  |  |  |  | Rejects or Posting Errors
 |  |  |  |  | c | 4 th Qtr - DELETIONS  From
 |  |  |  |  |  | Attached SPO-017A
 |  |  |  |  |  | Total  -  Fiscal Year - End
 |  |  |  |  | d | June 30,
 |  |  |  |  |  | FORMULAS  = |  |  | NET | TOTAL | NET |  |  | TOTAL | NET | TOTAL
 |  |  |  |  |  |  |  |  | ( a + b - c = d ) | ( a + c = d ) |  |  | ( a + b - c = d ) | ( a + c = d ) | ( a + b - c = d ) | ( a + c = d )
S U M M A R Y   O F   I N V E N T O R I E S |  |  |  |  |  |  |  |  |  |  |  | C E R T I F I C A T E    O F    P R O P E R T Y  C U S T O D I A N
Line | CLASSIFICATION |  |  |  |  |  |  | NET |  | TOTAL
 |  |  |  |  |  |  |  | Carrying Value of Property |  | Carrying Value Removed
 |  |  |  |  |  |  |  |  |  |  |  | I, |  |  | , hereby swear and certify that
 | Carrying Values are from Line d |  |  |  |  |  |  |  |  |  |  | I am the Property Custodian responsible for creating the inventory attached hereto, that I know the contents thereof, that the same is full,  true and complete,  and the items enumerated therein are at present under my control and the value set opposite the various items is true and correct, to the best of my knowledge and belief.  I am also swear and certify that I am responsible for the care, custody, or control (including but not limited to sign for: disposal applications, annual physical inventory certifications and transfer of properties) of all state property pertaining to the stated organization and location code(s).
1 | Vehicles, Equipment, Controlled Items,
 | Weapons, Arts & Historical Treasures
 |  | ( Property Codes 3,4,5,6, & 7 )
2 | Buildings and Building Improvements
 |  | ( Property Code 2 )
3 | Land, Land Improvements & Infrastructures
 |  | ( Property Codes 1 & 8 )
 |  |  |  |  |  | TOTALS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Property Custodian Signature                                                           Date
SPO-017B (Rev 08/13)