{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["CFRE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"CFRE","index":0,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,8],[6,0,6,1],[34,5,34,7],[4,2,4,4],[2,0,2,8],[1,0,1,8],[24,4,24,6],[26,4,26,8],[25,4,25,8],[27,4,27,8]]}
["Lake Superior State University"]
["Center for Freshwater Research & Education"]
["Deposit Reconciliation Sheet"]
[]
[null,"Activity Date:"]
[]
["Description",null,"Amount",null,"Fund","Orgn","Acct","Prog","Activ."]
[null,"Clothing Sales (incl tax)",0,null,1000,10064,5570,"GF"]
[null,"Sundry Sales (incl tax)",0,null,1000,10064,5571,"GF"]
[null,"Donations(Gifts)",0,null,"85000U",null,1272]
[null,"Sales Tax (Clothing)",0,null,1000,null,2140]
[null,"Sales Tax (Sundry)",{"$f":"ROUND(C9-(C9/1.06),2)","v":0},null,1000,null,2140]
[null,"Total Sales (incl tax)",{"$f":"SUM(C8:C10)","v":0}]
[]
[]
[null,"Total Cash/Checks Collected",0]
[null,"PayPal Net - CFRE Sales",0]
[null,"PayPal Fees - CFRE Sales",0]
[null,"Donation Kiosk - Cash",0]
[null,"Donation Kiosk - MVD",0]
[null,"Donation Kiosk - AmEx",0]
[null,"Cash (Over)/Short",{"$f":"C13+C29-(SUM(C16:C21))","v":0},null,1000,10437,7303,40]
[null,"Net Deposit to Central Savings Bank",{"$f":"C16+C19","v":0}]
[]
["Code","Enter FOAPAL","Amount",null,"Description and Payer"]
["MISC"]
["MISC"]
["MISC"]
[null,null,{"$f":"SUM(C26:C28)","v":0}]
[]
["Preparer:"," ",null,null,"Date:"]
[null," "]
["To be posted by Cashiers at Student Service Counter on TFWMISC"]
["CFRE:  A00264627"]
["Detail Code",null,"Amount",null,"Detail Code","Description",null,null,"Amount"]
["DBCF (D)","Deposit to CSB - CFRE",{"$f":"C23","v":0},null,"CFCG","CFRE Sales - Clothing",null,null,{"$f":"C8-C11","v":0}]
["DPCF (D)","PayPal Net - CFRE Sales",{"$f":"C17","v":0},null,"CFSS","CFRE Sales - Sundries",null,null,{"$f":"C9-C12","v":0}]
["PFCF (D)","PayPal Fees - CFRE Sales",{"$f":"C18","v":0},null,"CFTX","CFRE Sales Tax",null,null,{"$f":"C11+C12","v":0}]
["DCCK (D)","Donation Kiosk-MVD",{"$f":"C20","v":0},null,"CFCS","Cash Over - CFRE",null,null,{"$f":"(IF(C22<0,-C22,0))","v":0}]
["DACK (D)","Donation Kiosk-AmEx",{"$f":"C21","v":0},null,"MISC","MISC CFRE Activity",null,null,{"$f":"C29","v":0}]
["CFCS","Cash Short - CFRE",{"$f":"(IF(C22>0,C22,0))","v":0},null,"FNCL","Foundation Clearing",null,null,{"$f":"C10","v":0}]
[]
[]
[null,"Total Debits",{"$f":"SUM(C36:C41)","v":0},null,null,null,null,"Total Credits",{"$f":"SUM(I36:I43)","v":0}]
["Cashier:____________________"]
["Date Posted:________________"]