{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Remittance Calculator","Remittance Audit","Summary Page"],"not_rendered":{"charts":0,"images":3,"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":"Remittance Calculator","index":0,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[2,5,6,5],[19,5,23,5],[48,0,48,2],[49,0,49,2],[50,0,50,2],[42,0,42,2],[43,0,43,2],[44,0,44,2],[45,0,45,2],[46,0,46,2],[32,0,32,2],[33,0,33,2],[34,0,34,2],[35,0,35,2],[47,0,47,2],[36,0,36,2],[37,0,37,2],[38,0,38,2],[39,0,39,2],[40,0,40,2],[41,0,41,2],[27,0,27,2],[28,0,28,2],[29,0,29,2],[30,0,30,2],[31,0,31,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[11,5,16,5],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2]]}
["# of Bills","Bills","Amount"]
[0,0.01,{"$f":"B2*A2","v":0}]
[0,0.05,0,null,null,0,null,"Total Change","Total Change"]
[0,0.1,0,null,null,null,null,{"$f":"SUM(C2:C6)","v":0},0]
[0,0.25,0]
[0,0.5,0,null,null,null,null,"Total Bills"]
[0,1,0,null,null,null,null,{"$f":"SUM(C7:C13)","v":0}]
[0,5,{"$f":"B8*A8","v":0},null,null,"Remittance Amount"]
[0,10,0]
[0,20,0,null,null,{"$f":"TODAY()","v":"2022-07-14"}]
[0,50,0]
[0,100,0,null,null,{"$f":"SUM(C2:C13,A15:C30)","v":0}]
[0,1000,0,null,null,null,null,"Refresh"]
["Enter Checks below"]
[0]
[0]
[0]
[0]
[0]
[0,null,null,null,null,{"$f":"F12-F3","v":0}]
[0]
[0]
[0]
[0]
[0,null,null,null,null,"Difference"]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]

{"sheet":"Remittance Audit","index":1,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,5,1,9]]}
[]
[null,"Total",{"$f":"SUM(C3:C65536)","v":5610.8200000000006},null,null,"INSTRUCTIONS"]
[null," HATLEY, MISTY       ",137.75,null,null,"1. Highlight policy holders on remittance report and paste"]
[null," CHANCE CAROLYN      ",145]
[null," PENNINGTON, JOHNNY  ",75.069999999999993,null,null,"     over into \"Policyholder name\" column in cell a3"]
[null," DEAN, DAVID         ",385.5]
[null," GARRISON, RICHARD   ",194.2,null,null,"2. Highlight payments on remittance report and paste over"]
[null," RILEY, FUGATE       ",244.5,null,null,"    into column B under the \"payment\" column"]
[null," BURGAN, SCOTTY E    ",216.55,null,null,null,"press the money sign to sort the PH "]
[null," RASNIC, THOMAS L    ",23.8,null,null,3,"alphabetically. This will also sort by column"]
[null," EDWARDS, HOWARD     ",240.5,null,null,null,"\"X\" and move any unchecked PH to the "]
[null," HARBER JUANITA      ",230,null,null,null,"bottom."]
[null," HARBER, JUANITA     ",296]
[null," MOON, WILLIAM       ",35.5]
[null," NEELEY, LEONARD     ",240.5,null,null,"4. Place an \"X\" in column C for payments you have "]
[null," REYNOLDS, RALPH     ",904.3,null,null,"    accounted for. Press the money sign at anytime"]
[null," MOORE JODY          ",141.1,null,null,"    to move the \"X\" 'ed policy holders to the top of the list."]
[null," WOODARD, TIMOTHY W  ",493.1]
[null," WOOD, EDNA        ",44.01]
[null," GARRETT, JAMES    ",64.39]
[null," COLE, PHYLLIS     ",51.91,null,1968.59,"checks"]
[null," SMYTH, ROY L      ",232.8,null,1555.99,"cash"]
[null," SCOTT BRIAN       ",93.05]
[null," WILLIAMS DANIEL E ",176.41]
[null," BALES, EVON       ",149.72999999999999]
[null," HARBER, DEBORAH   ",406.63]
[null," ELDRIDGE, ARNOLD   ",224]
[null," CALTON, NANCY      ",164.52]

{"sheet":"Summary Page","index":2,"n_rows":368,"n_cols":9,"rows_kept":368,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Date","Account #2 (Deposit)","EFT",null,"Totals","Account #2 (Deposit)","EFT ","Account Balance"]
[null,"Original Balance",2000,null,null,"January",{"$f":"SUM(C3:C34)","v":52665.380000000005},{"$f":"SUM(D3:D34)","v":50665.380000000005},{"$f":"G3-H3","v":2000}]
[null,"2005-01-01",null,null,null,"February",{"$f":"SUM(C35:C62)+C3","v":10004.34},{"$f":"SUM(D35:D62)","v":8004.34},{"$f":"G4-H4","v":2000}]
[null,"2005-01-02",null,null,null,"March",{"$f":"SUM(C63:C93)+C3","v":2000},{"$f":"SUM(D63:D93)","v":0},{"$f":"G5-H5","v":2000}]
[null,"2005-01-03",null,null,null,"April",{"$f":"SUM(C94:C123)+C3","v":2000},{"$f":"SUM(D94:D123)","v":0},2000]
[null,"2005-01-04",null,null,null,"May",{"$f":"SUM(C124:C154)+C3","v":2000},{"$f":"SUM(D124:D154)","v":0},2000]
[null,"2005-01-05",null,null,null,"June",{"$f":"SUM(C155:C184)+C3","v":2000},{"$f":"SUM(D155:D184)","v":0},2000]
[null,"2005-01-06",10477.57,10477.57,null,"July",{"$f":"SUM(C185:C215)+C3","v":2000},{"$f":"SUM(D185:D215)","v":0},2000]
[null,"2005-01-07",3908.73,3908.73,null,"August",{"$f":"SUM(C216:C246)+C3","v":2000},{"$f":"SUM(D216:D246)","v":0},2000]
[null,"2005-01-08",null,null,null,"September",{"$f":"SUM(C247:C276)+C3","v":2000},{"$f":"SUM(D247:D276)","v":0},2000]
[null,"2005-01-09",null,null,null,"October",{"$f":"SUM(C277:C307)+C3","v":2000},{"$f":"SUM(D277:D307)","v":0},2000]
[null,"2005-01-10",null,null,null,"November",{"$f":"SUM(C308:C337)+C3","v":2000},{"$f":"SUM(D308:D337)","v":0},2000]
[null,"2005-01-11",4780.67,4780.67,null,"December",{"$f":"SUM(C338:C368)+C3","v":2000},{"$f":"SUM(D338:D368)","v":0},2000]
[null,"2005-01-12"]
[null,"2005-01-13"]
[null,"2005-01-14",9536.25,9536.25]
[null,"2005-01-15"]
[null,"2005-01-16"]
[null,"2005-01-17"]
[null,"2005-01-18"]
[null,"2005-01-19",5889.76,5889.76]
[null,"2005-01-20"]
[null,"2005-01-21"]
[null,"2005-01-22"]
[null,"2005-01-23"]
[null,"2005-01-24",6735.69,6735.69]
[null,"2005-01-25"]
[null,"2005-01-26"]
[null,"2005-01-27"]
[null,"2005-01-28",9336.7099999999991,9336.7099999999991]
[null,"2005-01-29"]
[null,"2005-01-30"]
[null,"2005-01-31"]
[null,"2005-02-01",8004.34,8004.34]
[null,"2005-02-02"]
[null,"2005-02-03"]
[null,"2005-02-04"]
[null,"2005-02-05"]
[null,"2005-02-06"]
[null,"2005-02-07"]
[null,"2005-02-08"]
[null,"2005-02-09"]
[null,"2005-02-10"]
[null,"2005-02-11"]
[null,"2005-02-12"]
[null,"2005-02-13"]
[null,"2005-02-14"]
[null,"2005-02-15"]
[null,"2005-02-16"]
[null,"2005-02-17"]
[null,"2005-02-18"]
[null,"2005-02-19"]
[null,"2005-02-20"]
[null,"2005-02-21"]
[null,"2005-02-22"]
[null,"2005-02-23"]
[null,"2005-02-24"]
[null,"2005-02-25"]
[null,"2005-02-26"]
[null,"2005-02-27"]
[null,"2005-02-28"]
[null,"2005-03-01"]
[null,"2005-03-02"]
[null,"2005-03-03"]
[null,"2005-03-04"]
[null,"2005-03-05"]
[null,"2005-03-06"]
[null,"2005-03-07"]
[null,"2005-03-08"]
[null,"2005-03-09"]
[null,"2005-03-10"]
[null,"2005-03-11"]
[null,"2005-03-12"]
[null,"2005-03-13"]
[null,"2005-03-14"]
[null,"2005-03-15"]
[null,"2005-03-16"]
[null,"2005-03-17"]
[null,"2005-03-18"]
[null,"2005-03-19"]
[null,"2005-03-20"]
[null,"2005-03-21"]
[null,"2005-03-22"]
[null,"2005-03-23"]
[null,"2005-03-24"]
[null,"2005-03-25"]
[null,"2005-03-26"]
[null,"2005-03-27"]
[null,"2005-03-28"]
[null,"2005-03-29"]
[null,"2005-03-30"]
[null,"2005-03-31"]
[null,"2005-04-01"]
[null,"2005-04-02"]
[null,"2005-04-03"]
[null,"2005-04-04"]
[null,"2005-04-05"]
[null,"2005-04-06"]
[null,"2005-04-07"]
[null,"2005-04-08"]
[null,"2005-04-09"]
[null,"2005-04-10"]
[null,"2005-04-11"]
[null,"2005-04-12"]
[null,"2005-04-13"]
[null,"2005-04-14"]
[null,"2005-04-15"]
[null,"2005-04-16"]
[null,"2005-04-17"]
[null,"2005-04-18"]
[null,"2005-04-19"]
[null,"2005-04-20"]
[null,"2005-04-21"]
[null,"2005-04-22"]
[null,"2005-04-23"]
[null,"2005-04-24"]
[null,"2005-04-25"]
[null,"2005-04-26"]
[null,"2005-04-27"]
[null,"2005-04-28"]
[null,"2005-04-29"]
[null,"2005-04-30"]
[null,"2005-05-01"]
[null,"2005-05-02"]
[null,"2005-05-03"]
[null,"2005-05-04"]
[null,"2005-05-05"]
[null,"2005-05-06"]
[null,"2005-05-07"]
[null,"2005-05-08"]
[null,"2005-05-09"]
[null,"2005-05-10"]
[null,"2005-05-11"]
[null,"2005-05-12"]
[null,"2005-05-13"]
[null,"2005-05-14"]
[null,"2005-05-15"]
[null,"2005-05-16"]
[null,"2005-05-17"]
[null,"2005-05-18"]
[null,"2005-05-19"]
[null,"2005-05-20"]
[null,"2005-05-21"]
[null,"2005-05-22"]
[null,"2005-05-23"]
[null,"2005-05-24"]
[null,"2005-05-25"]
[null,"2005-05-26"]
[null,"2005-05-27"]
[null,"2005-05-28"]
[null,"2005-05-29"]
[null,"2005-05-30"]
[null,"2005-05-31"]
[null,"2005-06-01"]
[null,"2005-06-02"]
[null,"2005-06-03"]
[null,"2005-06-04"]
[null,"2005-06-05"]
[null,"2005-06-06"]
[null,"2005-06-07"]
[null,"2005-06-08"]
[null,"2005-06-09"]
[null,"2005-06-10"]
[null,"2005-06-11"]
[null,"2005-06-12"]
[null,"2005-06-13"]
[null,"2005-06-14"]
[null,"2005-06-15"]
[null,"2005-06-16"]
[null,"2005-06-17"]
[null,"2005-06-18"]
[null,"2005-06-19"]
[null,"2005-06-20"]
[null,"2005-06-21"]
[null,"2005-06-22"]
[null,"2005-06-23"]
[null,"2005-06-24"]
[null,"2005-06-25"]
[null,"2005-06-26"]
[null,"2005-06-27"]
[null,"2005-06-28"]
[null,"2005-06-29"]
[null,"2005-06-30"]
[null,"2005-07-01"]
[null,"2005-07-02"]
[null,"2005-07-03"]
[null,"2005-07-04"]
[null,"2005-07-05"]
[null,"2005-07-06"]
[null,"2005-07-07"]
[null,"2005-07-08"]
[null,"2005-07-09"]
[null,"2005-07-10"]
[null,"2005-07-11"]
[null,"2005-07-12"]
[null,"2005-07-13"]
[null,"2005-07-14"]
[null,"2005-07-15"]
[null,"2005-07-16"]
[null,"2005-07-17"]
[null,"2005-07-18"]
[null,"2005-07-19"]
[null,"2005-07-20"]
[null,"2005-07-21"]
[null,"2005-07-22"]
[null,"2005-07-23"]
[null,"2005-07-24"]
[null,"2005-07-25"]
[null,"2005-07-26"]
[null,"2005-07-27"]
[null,"2005-07-28"]
[null,"2005-07-29"]
[null,"2005-07-30"]
[null,"2005-07-31"]
[null,"2005-08-01"]
[null,"2005-08-02"]
[null,"2005-08-03"]
[null,"2005-08-04"]
[null,"2005-08-05"]
[null,"2005-08-06"]
[null,"2005-08-07"]
[null,"2005-08-08"]
[null,"2005-08-09"]
[null,"2005-08-10"]
[null,"2005-08-11"]
[null,"2005-08-12"]
[null,"2005-08-13"]
[null,"2005-08-14"]
[null,"2005-08-15"]
[null,"2005-08-16"]
[null,"2005-08-17"]
[null,"2005-08-18"]
[null,"2005-08-19"]
[null,"2005-08-20"]
[null,"2005-08-21"]
[null,"2005-08-22"]
[null,"2005-08-23"]
[null,"2005-08-24"]
[null,"2005-08-25"]
[null,"2005-08-26"]
[null,"2005-08-27"]
[null,"2005-08-28"]
[null,"2005-08-29"]
[null,"2005-08-30"]
[null,"2005-08-31"]
[null,"2005-09-01"]
[null,"2005-09-02"]
[null,"2005-09-03"]
[null,"2005-09-04"]
[null,"2005-09-05"]
[null,"2005-09-06"]
[null,"2005-09-07"]
[null,"2005-09-08"]
[null,"2005-09-09"]
[null,"2005-09-10"]
[null,"2005-09-11"]
[null,"2005-09-12"]
[null,"2005-09-13"]
[null,"2005-09-14"]
[null,"2005-09-15"]
[null,"2005-09-16"]
[null,"2005-09-17"]
[null,"2005-09-18"]
[null,"2005-09-19"]
[null,"2005-09-20"]
[null,"2005-09-21"]
[null,"2005-09-22"]
[null,"2005-09-23"]
[null,"2005-09-24"]
[null,"2005-09-25"]
[null,"2005-09-26"]
[null,"2005-09-27"]
[null,"2005-09-28"]
[null,"2005-09-29"]
[null,"2005-09-30"]
[null,"2005-10-01"]
[null,"2005-10-02"]
[null,"2005-10-03"]
[null,"2005-10-04"]
[null,"2005-10-05"]
[null,"2005-10-06"]
[null,"2005-10-07"]
[null,"2005-10-08"]
[null,"2005-10-09"]
[null,"2005-10-10"]
[null,"2005-10-11"]
[null,"2005-10-12"]
[null,"2005-10-13"]
[null,"2005-10-14"]
[null,"2005-10-15"]
[null,"2005-10-16"]
[null,"2005-10-17"]
[null,"2005-10-18"]
[null,"2005-10-19"]
[null,"2005-10-20"]
[null,"2005-10-21"]
[null,"2005-10-22"]
[null,"2005-10-23"]
[null,"2005-10-24"]
[null,"2005-10-25"]
[null,"2005-10-26"]
[null,"2005-10-27"]
[null,"2005-10-28"]
[null,"2005-10-29"]
[null,"2005-10-30"]
[null,"2005-10-31"]
[null,"2005-11-01"]
[null,"2005-11-02"]
[null,"2005-11-03"]
[null,"2005-11-04"]
[null,"2005-11-05"]
[null,"2005-11-06"]
[null,"2005-11-07"]
[null,"2005-11-08"]
[null,"2005-11-09"]
[null,"2005-11-10"]
[null,"2005-11-11"]
[null,"2005-11-12"]
[null,"2005-11-13"]
[null,"2005-11-14"]
[null,"2005-11-15"]
[null,"2005-11-16"]
[null,"2005-11-17"]
[null,"2005-11-18"]
[null,"2005-11-19"]
[null,"2005-11-20"]
[null,"2005-11-21"]
[null,"2005-11-22"]
[null,"2005-11-23"]
[null,"2005-11-24"]
[null,"2005-11-25"]
[null,"2005-11-26"]
[null,"2005-11-27"]
[null,"2005-11-28"]
[null,"2005-11-29"]
[null,"2005-11-30"]
[null,"2005-12-01"]
[null,"2005-12-02"]
[null,"2005-12-03"]
[null,"2005-12-04"]
[null,"2005-12-05"]
[null,"2005-12-06"]
[null,"2005-12-07"]
[null,"2005-12-08"]
[null,"2005-12-09"]
[null,"2005-12-10"]
[null,"2005-12-11"]
[null,"2005-12-12"]
[null,"2005-12-13"]
[null,"2005-12-14"]
[null,"2005-12-15"]
[null,"2005-12-16"]
[null,"2005-12-17"]
[null,"2005-12-18"]
[null,"2005-12-19"]
[null,"2005-12-20"]
[null,"2005-12-21"]
[null,"2005-12-22"]
[null,"2005-12-23"]
[null,"2005-12-24"]
[null,"2005-12-25"]
[null,"2005-12-26"]
[null,"2005-12-27"]
[null,"2005-12-28"]
[null,"2005-12-29"]
[null,"2005-12-30"]
[null,"2005-12-31"]