{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Sheet1","index":0,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[[24,5,24,7],[14,0,14,3],[21,5,22,7],[0,0,0,7],[1,0,1,7],[2,0,2,7],[21,0,23,3],[4,5,5,7],[11,5,12,7],[20,1,20,2]]}
["Lake Superior State University"]
["ID Office"]
["Deposit Reconciliation Sheet"]
["Date:",null,null,null,null,"Enter all numbers as positive unless noted otherwise"]
[null,null,null,null,null,"Anchor Dollars Activity - Must match activity on End of Day Report on Auxiliary System"]
["IDBB","Laker Bucks Sales",null,0]
["IDBP","Block Plans",null,0,null,null,"Anchor Dollars Additions",0]
[null,null,null,null,null,null,"Anchor Dollars Deductions",0]
[null,null,null,null,null,"IDLG","Total Anchor Dollars Activity",{"$f":"H7-H8","v":0}]
[null,"Total Daily Cash Activity",null,{"$f":"SUM(D6:D8)+H7","v":0}]
[null,"Less Credit Cards",null,{"$f":"D31+D34","v":0}]
[null,"Available for Deposit",null,{"$f":"D10-D11","v":0},null,"Anchor Dollars Sales from End of Day Report-Must match Anchor Dollars Deductions"]
[null,"Difference",null,{"$f":"ROUND(D37-D12+D20,2)","v":0}]
[null,null,null,null,null,"LGSS","Anchor Dollars-Norris Conc",0]
["Difference must be zero or accounted for below:",null,null,null,null,"LGCC","Anchor Dollars-Laker Café",0]
["IDCS","Cash Short/(Over)",null,0,null,"LGCA","Anchor Dollars-Grab n Go",0]
["IDEX","Canadian Exchg Loss/(Gain)",null,0,null,"LGQD","Anchor Dollars-Quarterdeck",0]
["IDPR","Payroll Additions",null,0,null,"LGGA","Anchor Dollars-Galley",0]
["IDLG","Other: Enter Reason Below",null,0,null,null,"Total Deduction for Sales",{"$f":"SUM(H14:H18)","v":0}]
[null,"Total Adjustments",null,{"$f":"SUM(D16:D19)","v":0},null,"IDLG","Other Deduct: Explain Below",0]
["Reason:",{"$f":"IF(D19<>0,IF(A22<>0,\"\",\"ENTER EXPLANATION\"),\"\")","v":""},null,null,null,null,{"$f":"IF(H20>0,(IF(F22<>0,\"\",\"ENTER EXPLANATION\")),\"\")","v":""}]
[]
[]
[null,null,null,null,null,"Total Anchor Dollars Deductions",null,{"$f":"H19+H20","v":0}]
[null,{"$f":"IF(D13<>0,\"OUT OF BALANCE\",\"\")","v":""},null,null,null,{"$f":"IF(H24=H8,\"\",\"DEDUCTIONS OUT OF BALANCE\")","v":""}]
[null,null,null,null,null,"Can % Rate","CANADIAN","AMOUNT"]
[null,"Currency",null,0,null,null,"CASH COUNT",0]
[null,"Coin",null,0,null,null,"CAN DISCOUNT",{"$f":"H27-H29","v":0}]
[null,"Checks",null,0,null,null,"US AMOUNT",{"$f":"H27*F27","v":0}]
[null,"Canadian",null,{"$f":"H29","v":0}]
[null,"MC/VISA/DISC",null,0]
[null,"Batch #","Date (MMDD)"]
[]
[null,"AMEX",null,0]
[null,"Batch #","Date (MMDD)"]
[null,null,null,null,null,"Counted by:___________________________________"]
[null,"Deposit to CSB",null,{"$f":"D28+D29+D30+D27","v":0},null,"Date:_____________________________"]
[]
["To be posted by Cashiers at Student Service Counter on TFAMISC"]
["ID OFFICE: A00181976"]
["Detail Code","Description",null,"Amount",null,"Detail Code","Description","Amount"]
["DBID (D)","Deposit to CSB-ID Office",null,{"$f":"D37","v":0},null,"IDLG  (C.)","Anchor Dollars Activity",{"$f":"H7+H20","v":0}]
["DCID (D)","MC/VISA/DISC-ID Office",null,{"$f":"D31","v":0},null,"LGSS  (C.)","Anchor Dollars-Norris Conc",{"$f":"H14","v":0}]
["DAID (D)","AMEX-ID Office",null,{"$f":"D34","v":0},null,"LGCC  (C.)","Anchor Dollars-Laker Café",{"$f":"H15","v":0}]
["IDLG (D)","Anchor Dollars Activity",null,{"$f":"H8+D19","v":0},null,"LGCA  (C.)","Anchor Dollars-Grab n Go",{"$f":"H16","v":0}]
["IDCS (+D/-C)","Cash Short/(Over)-ID Office",null,{"$f":"D16","v":0},null,"LGQD  (C.)","Anchor Dollars-Quarterdeck",{"$f":"H17","v":0}]
["IDEX (+D/-C)","Can Exchange Loss/(Gain)",null,{"$f":"D17","v":0},null,"LGGA  (C.)","Anchor Dollars-Galley",{"$f":"H18","v":0}]
["IDPR (D)","Anchor Dollars Payroll Additions",null,{"$f":"D18","v":0},null,"IDBB  (C.)","Laker Bucks Sales",{"$f":"D6","v":0}]
[null,null,null,null,null,"IDBP  (C.)","Block Plan Sales",{"$f":"D7","v":0}]
[]
[null,null,null,null,null,null,"Total Credits",{"$f":"SUM(H42:H49)","v":0}]
[null,"Total Debits",null,{"$f":"SUM(D42:D50)","v":0}]
[]
["Cashier:____________________"]
["Date Posted:________________"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}