{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Survey","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Survey","index":0,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[[34,1,34,2],[38,1,38,2],[41,1,41,2],[26,1,26,2],[19,1,19,2],[19,3,21,3],[10,1,10,2],[23,1,23,2],[30,1,30,2],[16,1,16,2],[0,1,0,2],[5,1,5,2],[12,1,12,2],[12,3,14,3],[6,1,6,2],[11,1,11,2]]}
[null,"SAFEGUARDING CASH/CHECKS SELF ASSESSMENT SURVEY"]
[null,"DEPT:"]
[null,"CFO:"]
[null,"DATE:"]
[]
[null,{"$f":"IF(D45>13, \"UNIT AT RISK\",\"UNIT NOT AT RISK\")","v":"UNIT NOT AT RISK"}]
[null,"The purpose of this survey is to assess your department's risk with the safeguarding of cash and checks. If it is determined that your department is at risk, please contact Tricia Canty tscanty@buffalo.edu to assist you in developing stronger procedures to mitigate potential risk to your department."]
[]
[]
[]
[null,"Please answer the following questions                                                                                                                      (after completion of the survey, green bar in cell C6 will turn to red if your department is at risk):"]
[]
[1,"How frequently do you receive checks in your office?"]
[]
[]
[]
[2,"How frequently are deposits made after checks are received?"]
[]
[]
[3,"How are checks received in your office?"]
[]
[]
[]
[4,"How is cash received in your office?"]
[]
[]
[5,"How would you describe the logging of checks in your office?"]
[]
[]
[]
[6,"How would you describe your restrictive endorsement procedure?"]
[]
[]
[]
[7,"How do you secure cash/checks that are received in your office?"]
[]
[]
[]
[8,"Do you have proper segregation of duties? "]
[]
[]
[9,"Do you have a written procedure for the receipt of cash/checks in your office?"]
[]
[]
[null,null,null,{"$f":"SUM(D13:D44)","v":0}]

{"sheet":"Sheet2","index":1,"n_rows":51,"n_cols":2,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
[]
[1,"We do not receive checks"]
[null,"We receive 2-7 checks a month"]
[null,"We receive 8-15 checks a month"]
[null,"We receive over 15 checks a month"]
[]
[2,"Immediately upon receipt (daily)"]
[null,"Within a week of receipt (weekly)"]
[null,"Within two weeks of receipt (bi-weekly)"]
[null,"By the end of the month  (monthly)"]
[]
[3,"Through US postal mail or interoffice mail via LOCK BAG"]
[null,"Checks  are hand delivered to staff member responsible for logging checks and receipt is issued"]
[null,"Through interoffice mail "]
[null,"Checks are accepted by any staff member or left on employee's desk/chair/office, NO receipt is issued"]
[]
[]
[4,"We do not receive cash"]
[null,"Cash is received, logged, secured and receipt issued"]
[null,"Cash is received, secured and receipt issued "]
[null,"Cash is received and secured"]
[]
[]
[]
[5,"We log ALL checks"]
[null,"We log some checks"]
[null,"We do not have a check logging system in place"]
[]
[]
[]
[6,"We stamp ALL checks \"For Deposit Only\" immediately upon receipt"]
[null,"We stamp some checks \"For Deposit Only\" immediately upon receipt"]
[null,"We send all checks via interoffice mail to another department to restrictively endorse"]
[null,"We do not restrictively endorse any checks"]
[]
[]
[7,"We secure all cash/checks immediately in a safe in a secure location until deposit is made"]
[null,"Cash/checks are held in a locked drawer/cabinet until deposit is made"]
[null,"Cash/checks are kept in a desk drawer until deposit is made"]
[null,"There is no formal procedure for securing cash/checks until deposit is made"]
[]
[]
[]
[8,"The person who receives checks in the office logs the checks but DOES NOT make the deposit or reconcile"]
[null,"The person who receives checks in the office  logs the checks and makes deposit but DOES NOT reconcile"]
[null,"The person who receives checks in the office  logs the checks, makes deposit and reconciles with management oversight"]
[null,"The person who receives checks in the office logs the checks, makes deposit and reconciles"]
[]
[9,"We have a written procedure for the receipt of cash/checks in our office"]
[null,"We are working on a written procedure for the receipt of cash/checks in our office"]
[null,"We do not have a written procedure in place for the receipt of cash/checks in our office"]