{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Deposit Reconciliation Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Deposit Reconciliation Sheet","index":0,"n_rows":92,"n_cols":12,"rows_kept":92,"cut":false,"hidden":false,"merged":[[16,7,16,9],[17,1,17,3],[17,7,17,9],[20,1,20,3],[21,1,21,3],[20,7,20,9],[16,1,16,3],[21,7,21,9],[14,1,14,3],[14,7,14,9],[6,7,6,9],[11,1,11,3],[7,1,7,3],[7,7,7,9],[8,1,8,3],[8,7,8,9],[9,1,9,3],[9,7,9,9],[10,7,10,9],[11,7,11,9],[0,0,0,10],[1,0,1,10],[2,0,2,10],[5,1,5,3],[6,1,6,3],[5,7,5,9],[31,7,31,9],[43,7,43,9],[23,1,23,3],[22,1,22,3],[22,7,22,9],[27,1,27,3],[27,7,27,9],[25,1,25,3],[23,7,23,9],[25,7,25,9],[50,6,50,10],[86,7,86,9],[70,7,70,9],[71,7,71,9],[62,1,62,2],[63,1,63,2],[65,1,65,2],[68,7,68,9],[65,7,65,9],[66,7,66,9],[67,7,67,9],[64,1,64,2],[64,7,64,9],[62,7,62,9],[63,7,63,9],[76,7,76,9],[46,0,46,1],[46,3,46,4],[69,7,69,9],[47,0,47,1],[47,3,47,4],[48,0,48,1],[61,1,61,3],[48,3,48,4],[54,8,54,9],[61,7,61,9],[55,8,55,9],[56,8,56,9],[49,0,49,1],[49,3,49,4],[53,8,53,9],[50,0,50,4]]}
["Lake Superior State University"]
["Food Services"]
["Deposit Reconciliation Sheet"]
["Date:"]
["Detail Code","NORRIS CONCESSIONS",null,null,"Amount",null,"Detail Code","LAKER CAFÉ",null,null,"Amount"]
["FSSS","Cash Sales",null,null,0,null,"FSCC","Cash Sales",null,null,0]
["BBSS","Laker Bucks Sales",null,null,0,null,"BBCC","Laker Bucks Sales",null,null,0]
["BRSS","Bar Sales",null,null,0,null,"MECC","Meal Exchange Laker Café",null,null,0]
["MESS","Meal Exchange Norris Concessions",null,null,0,null,null,null,null,null,0]
["FSC1","Cash Short/(Over)",null,null,0,null,"FSC2","Cash Short/(Over)",null,null,0]
["FSTX","Tax",null,null,0,null,"FSTX","Tax",null,null,0]
["DCSS","MC/VISA/DISC",null,null,null,null,"DCCC","MC/VISA/DISC CC"]
[null,"Batch # & Date",null,null,0,null,null,"Batch # & Date",null,null,0]
[null,"Batch # & Date",null,null,0,null,null,"Batch # & Date",null,null,0]
["DASS","AmericanExpress",null,null,null,null,"DACC","AmericanExpress"]
[null,"Batch # & Date",null,null,0,null,null,"Batch # & Date",null,null,0]
["DPSS","PayPal Net - Norris Concessions",null,null,0]
["PFSS","PayPal Fees - Norris Concessions",null,null,0]
[]
["Detail Code","GRAB N GO",null,null,null,null,"Detail Code","QUARTERDECK"]
["FSCA","Cash Sales",null,null,0,null,"FSQD","Cash Sales",null,null,0]
["BBCA","Laker Bucks Sales",null,null,0,null,"BBQD","Laker Bucks Sales",null,null,0]
["MECA","Meal Exchange Grab n Go",null,null,0,null,"MEQD","Meal Exchange Quarterdeck",null,null,0]
["FSC3","Cash Short/(Over)",null,null,0,null,"FSC4","Cash Short/(Over)",null,null,0]
["FSTX","Tax",null,null,0,null,"FSTX","Tax",null,null,0]
["DCCA","MC/VISA/DISC GNG",null,null,0,null,"DCQD","MC/VISA/DISC QD",null,null,0]
[null,"Batch # & Date",null,null,null,null,null,"Batch # & Date"]
["DACA","AmericanExpress",null,null,null,null,"DAQD","AmericanExpress"]
[null,"Batch # & Date",null,null,0,null,null,"Batch # & Date",null,null,0]
[]
["Detail Code","GALLEY",null,null,null,null,"Detail Code","MISCELLANEOUS",null,null,"Amount"]
["BBGA","Laker Bucks Sales",null,null,0,null,"FSMC","Sales-Miscellaneous",null,null,0]
["MEGA","Meal Exchange Galley",null,null,0]
["WCGS","Sundry Sales",null,null,0,null,null,null,"Galley Sales per Cash Register",null,0]
["WCGF","Snack Food Items",null,null,0,null,null,null,"Galley - Plus Meals",null,0]
["WCRB","Brand Display Rebates",null,null,0,null,null,null,"Meal Exchange",null,0]
["WCTX","Tax",null,null,0,null,null,null,"Laker Bucks Sales",null,0]
["WCC2","Cash Short/(Over)-Galley",null,null,0,null,null,null,"Anchor Dollars Sales",null,0]
["DCGA","MC/VISA/DISC Galley",null,null,null,null,null,null,"Net Cash Sales for Galley",null,{"$f":"K34-K35-K36-K37-K38","v":0}]
[null,"Batch # & Date",null,null,0]
[null,"Batch # & Date",null,null,0]
[null,"Batch # & Date",null,null,0]
[null,"Batch # & Date",null,null,0]
["DCGA","American Express Galley"]
[null,"Batch # & Date",null,null,0]
[]
["Total Cash Activity","Total Cash Activity",null,{"$f":"E6+E8+E11+K6+K11+E21+K21+E25+SUM(E34:E37)+K25+K32","v":0}]
["Less Cash Short/Over","Less Cash Short/Over",null,{"$f":"E10+K10+E24+K24+E38","v":0}]
["Less Credit Cards & PayPal",null,null,{"$f":"E13+E14++E16+K13+K14+K16+E26+E29+K26+K29+SUM(E40:E43)+E45+E17+E18","v":0},null,null,"Total Bonus Pts Activity from Cbord Report"]
["Total Available for Deposit",null,null,{"$f":"ROUND(D47-D48-D49,2)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(K49<>SUM(E7+K7+E32+K22+E22),\"Laker Bucks OUT OF BALANCE\",\"\")","v":""}]
[]
["Currency",0]
["Coin",0,null,null,null,null," ","CANADIAN","AMOUNT",null,"Can Percent"]
["Checks",0,null,null,null,null,null,"CASH COUNT"]
["Canadian",{"$f":"ROUND(I57,2)","v":0},null,null,"Counted by:_________________",null,null,"CAN DISCOUNT",{"$f":"I55-I57","v":0}]
["Deposit to CSB",{"$f":"SUM(B53:B56)","v":0},null,null,"Date:_________________",null,null,"US AMOUNT",{"$f":"I55*K55","v":0}]
[]
["To be posted by Cashiers at Student Service Counter on TFAMISC"]
["FOOD SERVICES:  A00181974"]
["Detail Code","Description",null,null,"Amount",null,"Detail Code","Description",null,null,"Amount"]
["DBFS (D)","Deposit to CSB-Food Services",null,null,{"$f":"B57","v":0},null,"FSSS  (C.)","Cash Meals NC CONCESSIONS",null,null,{"$f":"E6","v":0}]
["DCSS (D)","MC/VISA/DISC NC CONC",null,{"$f":"D13","v":0},{"$f":"E13","v":0},null,"FSCC  (C.)","Cash Meals LAKER CAFÉ",null,null,{"$f":"K6","v":0},"A"]
["DCSS (D)","MC/VISA/DISC NC CONC",null,{"$f":"D14","v":0},{"$f":"E14","v":0},null,"FSCA  (C.)","Cash Meals GRAB N GO",null,null,{"$f":"E21","v":0},"B"]
["DASS (D)","AMEX NC CONC",null,{"$f":"D16","v":0},{"$f":"E16","v":0},null,"FSQD  (C.)","Cash Meals Quarterdeck",null,null,{"$f":"K21","v":0}]
["DCCC (D)","MC/VISA/DISC LAKER CAFÉ",null,{"$f":"J13","v":0},{"$f":"K13","v":0},null,"BBSS  (C.)","Laker Bucks NC CONCESSIONS",null,null,{"$f":"E7","v":0}]
["DCCC (D)","MC/VISA/DISC LAKER CAFÉ",null,{"$f":"J14","v":0},{"$f":"K14","v":0},null,"BBCC  (C.)","Laker Bucks LAKER CAFÉ",null,null,{"$f":"K7","v":0}]
["DACC (D)","AMEX LAKER CAFÉ",null,{"$f":"J16","v":0},{"$f":"K16","v":0},null,"BBCA  (C.)","Laker Bucks GRAB N GO",null,null,{"$f":"E22","v":0}]
["DCQD (D)","MC/VISA/DISC QD",null,{"$f":"J27","v":0},{"$f":"K26","v":0},null,"BBQD  (C.)","Laker Bucks Quarterdeck",null,null,{"$f":"K22","v":0}]
["DAQD (D)","AMEX QD",null,{"$f":"J29","v":0},{"$f":"K29","v":0},null,"BBGA  (C.)","Laker Bucks Galley",null,null,{"$f":"E32","v":0}]
["DCCA (D)","MC/VISA/DISC GNG",null,{"$f":"D27","v":0},{"$f":"E26","v":0},null,"BRSS (C.)","Bar Sales NC Concessions",null,null,{"$f":"E8","v":0}]
["DACA (D)","AMEX GNG",null,{"$f":"D29","v":0},{"$f":"E29","v":0},null,"MESS (C.)","Meal Exchange NC Concessions",null,null,{"$f":"E9","v":0}]
["FSBB (D)","Laker Bucks",null,null,{"$f":"E7+K7+E22+K22+E32","v":0},null,"MECC (C.)","Meal Exchange Laker Café",null,null,{"$f":"K8","v":0}]
["FSME (D)","Meal Exchange ",null,null,{"$f":"E33+E9+E23+K8+K23","v":0},null,"MECA (C.)","Meal Exchange Grab n Go",null,null,{"$f":"E23","v":0}]
["FSC1 (+D/-C)","Cash Short/(Over) NC CONC",null,null,{"$f":"E10","v":0},null,"MEQD (C.)","Meal Exchange Quarterdeck",null,null,{"$f":"K23","v":0}]
["FSC2 (+D/-C)","Cash Short/(Over) LAKER CAFÉ",null,null,{"$f":"K10","v":0},null,"FSTX   (C.)","Tax-Food Services",null,null,{"$f":"E11+K11+E25+K25","v":0}]
["FSC3 (+D/-C)","Cash Short/(Over) GRAB N GO",null,null,{"$f":"E24","v":0},null,"FSMC  (C.)","Sales-Miscellaneous",null,null,{"$f":"K32","v":0}]
["FSC4 (+D/-C)","Cash Short/(Over) QUARTERDECK",null,null,{"$f":"K24","v":0},null,"MEGA (C.)","Meal Exchange Galley",null,null,{"$f":"E33","v":0}]
["WCC2 (D)","Cash Short/(Over)-Galley",null,null,{"$f":"E38","v":0},null,"WCGS (C.)","Sundry Sales",null,null,{"$f":"E34","v":0}]
["DCGA (D)","MC/VISA/DISC Galley",null,{"$f":"D40","v":0},0,null,"WCGF (C.)","Snack Food Items",null,null,{"$f":"E35","v":0}]
["DCGA (D)","MC/VISA/DISC Galley",null,0,0,null,"WCRB (C.)","Brand Display Rebates",null,null,{"$f":"E36","v":0}]
["DCGA (D)","MC/VISA/DISC Galley",null,0,0,null,"WCTX (C.)","Tax Galley",null,null,{"$f":"E37","v":0}]
["DCGA (D)","MC/VISA/DISC Galley",null,0,0]
["DAGA (D)","AMEX Galley",null,{"$f":"D45","v":0},{"$f":"E45","v":0}]
["DPSS (D)","PayPal Net - Norris Concessions",null,null,{"$f":"E17","v":0}]
["PFSS (D)","PayPal Fees - Norris Concessions",null,null,{"$f":"E18","v":0}]
[]
["Cashier:____________________",null,null,"Total Debits",{"$f":"SUM(E62:E74)+(IF(E75>0,E75,0)+IF(E76>0,E76,0)+IF(E77>0,E77,0)+IF(E78>0,E78,0)+IF(E79>0,E79,0))+SUM(E80:E86)","v":0},null,null,null,null,"Total Credits",{"$f":"SUM(K62:K87)+(IF(E75<0,-E75,0)+IF(E76<0,-E76,0)+IF(E77<0,-E77,0)+IF(E78<0,-E78,0)+IF(E79<0,-E79,0))","v":0}]
["Date Posted:________________"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K88-E88","v":0}]