{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["HC"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"HC","index":0,"n_rows":57,"n_cols":9,"rows_kept":57,"cut":false,"hidden":false,"merged":[[9,5,9,6],[0,0,0,7],[1,0,1,7],[4,1,4,3],[5,1,5,3],[6,1,6,3]]}
["LAKE SUPERIOR STATE UNIVERSITY HEALTH CARE CENTER"]
["Deposit Reconciliation Sheet"]
[null,null,null,"Date"]
[]
[]
[]
[]
[]
["ACCOUNT","PAYMENT CATEGORY",null,"AMOUNT"]
["HCPB","BC/BS",null,0,"+","CASH RECONCILIATION"]
["HCPU","Medicaid/UPHP",null,0,"+","Cash on Hand",40]
["HCPM","Medicare ",null,0,"+","Checks",0]
["HCPC","Insurance (Commercial)",null,0,"+","Large Bills",0]
[null,"Virtual CC",null,0,"+","20's",0]
["HCPS","Secondary Insurance",null,0,"+","10's",0]
["HCPL","Local Payor",null,0,"+","5's",0]
["HCPY","Patient Payments",null,0,"+","1's",0]
["HCPZ","Other Payments",null,0,"+","Coin",0]
[null,null,null,null,null,"Less Csh on Hand",-40]
[null,"Total Payments",null,{"$f":"SUM(D10:D18)","v":0},null,null,0]
[null,null,null,null,null,"Deposit to CSB",{"$f":"SUM(G11:G20)","v":0}]
[]
[]
["DCHC","MC/VISA/DISC",null,null," "]
["Batch & Date",null,null,null,null,"Deposit to Central Savings Bank (CSB)"]
["DCHC",null,null,null,null,"equals the cash and checks available for"]
["Batch & Date",null,null,null,null,"deposit."]
["DCHC",null,null,null," "]
["Batch & Date",null,null,null,null,"\"Out of Balance\" will display if Deposit to"]
["DCHC",null,null,null,null,"CSB plus Total Credit Cards are not equal."]
["Batch & Date"]
["DCHC",null,null,null,null,null,{"$f":"IF(D20=D41,\" \",\"Out of Balance\")","v":" "}]
["Batch & Date"]
["DAHC"]
["Batch & Date"]
["DAHC"]
["Batch & Date"]
[]
[null,"Total Credit Cards",null,{"$f":"D24+D26+D28+D30+D32+D34+D36","v":0},null,"Counted by:______________________________","Need Name"]
[null,null,null,null,null,"Date:______________________"]
[null,"CSB Deposit + Credit Cards",null,{"$f":"G21+D39","v":0},null,null," "]
[]
["To be posted by Cashiers in Student Service Center of TFWMISC"]
["Health Care Center A00181975",null,null,null,null,"HCPB (C.)","BC/BS",{"$f":"D10","v":0},"A"]
["DCHC  (D)","MC/VISA/DISC-HCC",{"$f":"CONCATENATE(C25,\"-\",I44)","v":"-A"},{"$f":"D24","v":0},null,"HCPU (C.)","Medicaid/UPHP",0,"B"]
["DCHC  (D)","MC/VISA/DISC-HCC",{"$f":"CONCATENATE(C27,\"-\",I45)","v":"-B"},{"$f":"D26","v":0},null,"HCPM (C.)","Medicare ",0,"C"]
["DCHC  (D)","MC/VISA/DISC-HCC",{"$f":"CONCATENATE(C29,\"-\",I46)","v":"-C"},{"$f":"D28","v":0},null,"HCPC (C.)","Insurance (Commercial)",0,"D"]
["DCHC  (D)","MC/VISA/DISC-HCC",{"$f":"CONCATENATE(C31,\"-\",I47)","v":"-D"},{"$f":"D30","v":0},null,null,"Virtual CC",{"$f":"D14","v":0},"E"]
["DCHC  (D)","MC/VISA/DISC-HCC",{"$f":"CONCATENATE(C33,\"-\",I48)","v":"-E"},{"$f":"D32","v":0},null,"HCPS (C.)","Secondary Insurance",{"$f":"D15","v":0}]
["DAHC  (D)","AMEX-HCC",{"$f":"CONCATENATE(C35,\"-\",I49)","v":"-"},{"$f":"D34","v":0},null,"HCPL (C.)","Local Payor",{"$f":"D16","v":0}]
["DAHC  (D)","AMEX-HCC",{"$f":"CONCATENATE(C37,\"-\",I50)","v":"-"},{"$f":"D36","v":0},null,"HCPY (C.)","Patient Payments",{"$f":"D17","v":0}]
["DBHC  (D)","Deposit to CSB-HCC",null,{"$f":"G21","v":0},null,"HCPZ (C.)","Other Payments",{"$f":"D18","v":0}]
[]
[null,"Total Debits",null,{"$f":"SUM(D45:D53)","v":0},null,null,"Total Credits",{"$f":"SUM(H44:H53)","v":0}]
[]
[null,"Cashier:____________________________________"]
[null,"Date:____________________"]