{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["% VA To Total Income","Instructions","PDF Transfer Instructions","Example % No Fund Transfer","Example % Fund Transfer"],"not_rendered":{"charts":0,"images":5,"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":"% VA To Total Income","index":0,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,4,0,5],[2,0,2,6],[0,1,0,2],[1,1,1,2],[25,0,34,3]]}
["Beneficiary","File Number",null,"Fiduciary","Misuse Period Date",null,"Misuse Amount Calculator"]
[]
[]
["Income VA","Payment Type","From - Day 01   (i.e. 01/01/2018)","To - Up To Day 31     (i.e., 01/31/2018)","Monthly or Lump Sum Benefit","Amount","Comments VA Income"]
[null,"Beginning Balance",null,null,null,{"$f":"E5","v":0}]
[null,null,null,null,{"$f":"IF(B6 = \"Monthly Payment\", \"Enter MONTHLY Sum\", IF(B6=\"Prorated Payment\", \"Enter MONTHLY Sum\", IF(B6=\"Single Payment\", \"Enter LUMP Sum\", IF(B6=\"Retro\", \"Enter LUMP Sum\", \"\"))))","v":""},{"$f":"IF(ISNUMBER(E6),IF(B6=\"Prorated Payment\",IF(AND((DAY(C6)=30),(DAY(D6)=31)),(DAYS360(C6,D6)+1)*(E6/30),IF(DAY(C6)<>31,IF(MONTH(D6)<>2,IF(DAY(D6)=31,DAYS360(C6,D6)*(E6/30),(DAYS360(C6,D6)+1)*(E6/30)),IF(DAY(D6)<28,(DAYS360(C6,D6)+1)*(E6/30),(DAYS360(C6,D6)+31-DAY(D6))*(E6/30))),IF(MONTH(D6)<>2,IF(DAY(D6)=31,DAYS360(C6,D6)*(E6/30),DAYS360(C6,D6)*(E6/30)),IF(DAY(D6)<28,DAYS360(C6,D6)*(E6/30),(DAYS360(C6,D6)+30-DAY(D6))*(E6/30))))),IF(B6=\"Retro\",E6,IF(B6=\"Single Payment\",E6, IF(B6=\"Monthly Payment\",IF(AND((DAY(C6)=30),(DAY(D6)=31)),(DAYS360(C6,D6)+1)*(E6/30),IF(DAY(C6)<>31,IF(MONTH(D6)<>2,IF(DAY(D6)=31,DAYS360(C6,D6)*(E6/30),(DAYS360(C6,D6)+1)*(E6/30)),IF(DAY(D6)<28,(DAYS360(C6,D6)+1)*(E6/30),(DAYS360(C6,D6)+31-DAY(D6))*(E6/30))),IF(MONTH(D6)<>2,IF(DAY(D6)=31,DAYS360(C6,D6)*(E6/30),DAYS360(C6,D6)*(E6/30)),IF(DAY(D6)<28,DAYS360(C6,D6)*(E6/30),(DAYS360(C6,D6)+30-DAY(D6))*(E6/30))))), \"\")))), \"\")","v":""}]
[null,null,null,null,{"$f":"IF(B7 = \"Monthly Payment\", \"Enter MONTHLY Sum\", IF(B7=\"Prorated Payment\", \"Enter MONTHLY Sum\", IF(B7=\"Single Payment\", \"Enter LUMP Sum\", IF(B7=\"Retro\", \"Enter LUMP Sum\", \"\"))))","v":""},{"$f":"IF(ISNUMBER(E7),IF(B7=\"Prorated Payment\",IF(AND((DAY(C7)=30),(DAY(D7)=31)),(DAYS360(C7,D7)+1)*(E7/30),IF(DAY(C7)<>31,IF(MONTH(D7)<>2,IF(DAY(D7)=31,DAYS360(C7,D7)*(E7/30),(DAYS360(C7,D7)+1)*(E7/30)),IF(DAY(D7)<28,(DAYS360(C7,D7)+1)*(E7/30),(DAYS360(C7,D7)+31-DAY(D7))*(E7/30))),IF(MONTH(D7)<>2,IF(DAY(D7)=31,DAYS360(C7,D7)*(E7/30),DAYS360(C7,D7)*(E7/30)),IF(DAY(D7)<28,DAYS360(C7,D7)*(E7/30),(DAYS360(C7,D7)+30-DAY(D7))*(E7/30))))),IF(B7=\"Retro\",E7,IF(B7=\"Single Payment\",E7, IF(B7=\"Monthly Payment\",IF(AND((DAY(C7)=30),(DAY(D7)=31)),(DAYS360(C7,D7)+1)*(E7/30),IF(DAY(C7)<>31,IF(MONTH(D7)<>2,IF(DAY(D7)=31,DAYS360(C7,D7)*(E7/30),(DAYS360(C7,D7)+1)*(E7/30)),IF(DAY(D7)<28,(DAYS360(C7,D7)+1)*(E7/30),(DAYS360(C7,D7)+31-DAY(D7))*(E7/30))),IF(MONTH(D7)<>2,IF(DAY(D7)=31,DAYS360(C7,D7)*(E7/30),DAYS360(C7,D7)*(E7/30)),IF(DAY(D7)<28,DAYS360(C7,D7)*(E7/30),(DAYS360(C7,D7)+30-DAY(D7))*(E7/30))))), \"\")))), \"\")","v":""}]
[null,null,null,null,"",""]
[null,null,null,null,{"$f":"IF(B9 = \"Monthly Payment\", \"Enter MONTHLY Sum\", IF(B9=\"Prorated Payment\", \"Enter MONTHLY Sum\", IF(B9=\"Single Payment\", \"Enter LUMP Sum\", IF(B9=\"Retro\", \"Enter LUMP Sum\", \"\"))))","v":""},{"$f":"IF(ISNUMBER(E9),IF(B9=\"Prorated Payment\",IF(AND((DAY(C9)=30),(DAY(D9)=31)),(DAYS360(C9,D9)+1)*(E9/30),IF(DAY(C9)<>31,IF(MONTH(D9)<>2,IF(DAY(D9)=31,DAYS360(C9,D9)*(E9/30),(DAYS360(C9,D9)+1)*(E9/30)),IF(DAY(D9)<28,(DAYS360(C9,D9)+1)*(E9/30),(DAYS360(C9,D9)+31-DAY(D9))*(E9/30))),IF(MONTH(D9)<>2,IF(DAY(D9)=31,DAYS360(C9,D9)*(E9/30),DAYS360(C9,D9)*(E9/30)),IF(DAY(D9)<28,DAYS360(C9,D9)*(E9/30),(DAYS360(C9,D9)+30-DAY(D9))*(E9/30))))),IF(B9=\"Retro\",E9,IF(B9=\"Single Payment\",E9, IF(B9=\"Monthly Payment\",IF(AND((DAY(C9)=30),(DAY(D9)=31)),(DAYS360(C9,D9)+1)*(E9/30),IF(DAY(C9)<>31,IF(MONTH(D9)<>2,IF(DAY(D9)=31,DAYS360(C9,D9)*(E9/30),(DAYS360(C9,D9)+1)*(E9/30)),IF(DAY(D9)<28,(DAYS360(C9,D9)+1)*(E9/30),(DAYS360(C9,D9)+31-DAY(D9))*(E9/30))),IF(MONTH(D9)<>2,IF(DAY(D9)=31,DAYS360(C9,D9)*(E9/30),DAYS360(C9,D9)*(E9/30)),IF(DAY(D9)<28,DAYS360(C9,D9)*(E9/30),(DAYS360(C9,D9)+30-DAY(D9))*(E9/30))))), \"\")))), \"\")","v":""}]
[null,null,null,null,"Total Income VA",{"$f":"SUM(F5:F9)","v":0}]
["Income Other","Payment Type","From - Day 01   (i.e. 01/01/2018)","To - Up To Day 31     (i.e., 01/31/2018)","Monthly or Lump Sum Benefit","Amount","Comments Other Income"]
[null,"Beginning Balance",null,null,null,{"$f":"E12","v":0}]
[null,null,null,null,{"$f":"IF(B13 = \"Monthly Payment\", \"Enter MONTHLY Sum\", IF(B13=\"Prorated Payment\", \"Enter MONTHLY Sum\", IF(B13=\"Single Payment\", \"Enter LUMP Sum\", IF(B13=\"Retro\", \"Enter LUMP Sum\", \"\"))))","v":""},{"$f":"IF(ISNUMBER(E13),IF(B13=\"Prorated Payment\", IF(AND((DAY(C13)=30),(DAY(D13)=31)),(DAYS360(C13,D13)+1)*(E13/30),IF(DAY(C13)<>31,IF(MONTH(D13)<>2,IF(DAY(D13)=31,DAYS360(C13,D13)*(E13/30),(DAYS360(C13,D13)+1)*(E13/30)),IF(DAY(D13)<28,(DAYS360(C13,D13)+1)*(E13/30),(DAYS360(C13,D13)+31-DAY(D13))*(E13/30))),IF(MONTH(D13)<>2,IF(DAY(D13)=31,DAYS360(C13,D13)*(E13/30),DAYS360(C13,D13)*(E13/30)),IF(DAY(D13)<28,DAYS360(C13,D13)*(E13/30),(DAYS360(C13,D13)+30-DAY(D13))*(E13/30))))), IF(B13=\"Retro\", E13, IF(B13=\"Single Payment\", E13, IF(B13=\"Monthly Payment\", IF(AND((DAY(C13)=30),(DAY(D13)=31)),(DAYS360(C13,D13)+1)*(E13/30),IF(DAY(C13)<>31,IF(MONTH(D13)<>2,IF(DAY(D13)=31,DAYS360(C13,D13)*(E13/30),(DAYS360(C13,D13)+1)*(E13/30)),IF(DAY(D13)<28,(DAYS360(C13,D13)+1)*(E13/30),(DAYS360(C13,D13)+31-DAY(D13))*(E13/30))),IF(MONTH(D13)<>2,IF(DAY(D13)=31,DAYS360(C13,D13)*(E13/30),DAYS360(C13,D13)*(E13/30)),IF(DAY(D13)<28,DAYS360(C13,D13)*(E13/30),(DAYS360(C13,D13)+30-DAY(D13))*(E13/30))))),\"\")))), \"\")","v":""}]
[null,null,null,null,"",{"$f":"IF(ISNUMBER(E14),IF(B14=\"Prorated Payment\", IF(AND((DAY(C14)=30),(DAY(D14)=31)),(DAYS360(C14,D14)+1)*(E14/30),IF(DAY(C14)<>31,IF(MONTH(D14)<>2,IF(DAY(D14)=31,DAYS360(C14,D14)*(E14/30),(DAYS360(C14,D14)+1)*(E14/30)),IF(DAY(D14)<28,(DAYS360(C14,D14)+1)*(E14/30),(DAYS360(C14,D14)+31-DAY(D14))*(E14/30))),IF(MONTH(D14)<>2,IF(DAY(D14)=31,DAYS360(C14,D14)*(E14/30),DAYS360(C14,D14)*(E14/30)),IF(DAY(D14)<28,DAYS360(C14,D14)*(E14/30),(DAYS360(C14,D14)+30-DAY(D14))*(E14/30))))), IF(B14=\"Retro\", E14, IF(B14=\"Single Payment\", E14, IF(B14=\"Monthly Payment\", IF(AND((DAY(C14)=30),(DAY(D14)=31)),(DAYS360(C14,D14)+1)*(E14/30),IF(DAY(C14)<>31,IF(MONTH(D14)<>2,IF(DAY(D14)=31,DAYS360(C14,D14)*(E14/30),(DAYS360(C14,D14)+1)*(E14/30)),IF(DAY(D14)<28,(DAYS360(C14,D14)+1)*(E14/30),(DAYS360(C14,D14)+31-DAY(D14))*(E14/30))),IF(MONTH(D14)<>2,IF(DAY(D14)=31,DAYS360(C14,D14)*(E14/30),DAYS360(C14,D14)*(E14/30)),IF(DAY(D14)<28,DAYS360(C14,D14)*(E14/30),(DAYS360(C14,D14)+30-DAY(D14))*(E14/30))))),\"\")))), \"\")","v":""}]
[null,null,null,null,"",""]
[null,null,null,null,{"$f":"IF(B16 = \"Monthly Payment\", \"Enter MONTHLY Sum\", IF(B16=\"Prorated Payment\", \"Enter MONTHLY Sum\", IF(B16=\"Single Payment\", \"Enter LUMP Sum\", IF(B16=\"Retro\", \"Enter LUMP Sum\", \"\"))))","v":""},{"$f":"IF(ISNUMBER(E16),IF(B16=\"Prorated Payment\", IF(AND((DAY(C16)=30),(DAY(D16)=31)),(DAYS360(C16,D16)+1)*(E16/30),IF(DAY(C16)<>31,IF(MONTH(D16)<>2,IF(DAY(D16)=31,DAYS360(C16,D16)*(E16/30),(DAYS360(C16,D16)+1)*(E16/30)),IF(DAY(D16)<28,(DAYS360(C16,D16)+1)*(E16/30),(DAYS360(C16,D16)+31-DAY(D16))*(E16/30))),IF(MONTH(D16)<>2,IF(DAY(D16)=31,DAYS360(C16,D16)*(E16/30),DAYS360(C16,D16)*(E16/30)),IF(DAY(D16)<28,DAYS360(C16,D16)*(E16/30),(DAYS360(C16,D16)+30-DAY(D16))*(E16/30))))), IF(B16=\"Retro\", E16, IF(B16=\"Single Payment\", E16, IF(B16=\"Monthly Payment\", IF(AND((DAY(C16)=30),(DAY(D16)=31)),(DAYS360(C16,D16)+1)*(E16/30),IF(DAY(C16)<>31,IF(MONTH(D16)<>2,IF(DAY(D16)=31,DAYS360(C16,D16)*(E16/30),(DAYS360(C16,D16)+1)*(E16/30)),IF(DAY(D16)<28,(DAYS360(C16,D16)+1)*(E16/30),(DAYS360(C16,D16)+31-DAY(D16))*(E16/30))),IF(MONTH(D16)<>2,IF(DAY(D16)=31,DAYS360(C16,D16)*(E16/30),DAYS360(C16,D16)*(E16/30)),IF(DAY(D16)<28,DAYS360(C16,D16)*(E16/30),(DAYS360(C16,D16)+30-DAY(D16))*(E16/30))))),\"\")))), \"\")","v":""}]
[null,null,null,null,"       Total Income Other",{"$f":"SUM(F12:F16)","v":0}]
[null,null,null,null,"Total VA + Other",{"$f":"F10+F17","v":0}]
[null,null,null,null,"% VA Income to Total Income",{"$f":"F10/F18","v":{"$error":"#DIV/0!"}}]
["Expenses Paid","Expense Type","From - Day 01   (i.e. 01/01/2018)","To - Up To Day 31     (i.e., 01/31/2018)","Expense Amount","Amount","Comments Expenses"]
[null,null,null,null,{"$f":"IF(B21=\"Monthly Expense\",\"Enter MONTHLY Sum\",IF(B21=\"Prorated Expense\",\"Enter MONTHLY Sum\",IF(B21=\"Single Expense\",\"Enter LUMP Sum\",\"\")))","v":""},{"$f":"IF(ISNUMBER(E21),IF(B21=\"Prorated Expense\",IF(AND((DAY(C21)=30),(DAY(D21)=31)),(DAYS360(C21,D21)+1)*(E21/30),IF(DAY(C21)<>31,IF(MONTH(D21)<>2,IF(DAY(D21)=31,DAYS360(C21,D21)*(E21/30),(DAYS360(C21,D21)+1)*(E21/30)),IF(DAY(D21)<28,(DAYS360(C21,D21)+1)*(E21/30),(DAYS360(C21,D21)+31-DAY(D21))*(E21/30))),IF(MONTH(D21)<>2,IF(DAY(D21)=31,DAYS360(C21,D21)*(E21/30),DAYS360(C21,D21)*(E21/30)),IF(DAY(D21)<28,DAYS360(C21,D21)*(E21/30),(DAYS360(C21,D21)+30-DAY(D21))*(E21/30))))),IF(B21=\"Single Expense\",E21,IF(B21=\"Monthly Expense\",IF(AND((DAY(C21)=30),(DAY(D21)=31)),(DAYS360(C21,D21)+1)*(E21/30),IF(DAY(C21)<>31,IF(MONTH(D21)<>2,IF(DAY(D21)=31,DAYS360(C21,D21)*(E21/30),(DAYS360(C21,D21)+1)*(E21/30)),IF(DAY(D21)<28,(DAYS360(C21,D21)+1)*(E21/30),(DAYS360(C21,D21)+31-DAY(D21))*(E21/30))),IF(MONTH(D21)<>2,IF(DAY(D21)=31,DAYS360(C21,D21)*(E21/30),DAYS360(C21,D21)*(E21/30)),IF(DAY(D21)<28,DAYS360(C21,D21)*(E21/30),(DAYS360(C21,D21)+30-DAY(D21))*(E21/30))))),\"\"))),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(B22=\"Monthly Expense\",\"Enter MONTHLY Sum\",IF(B22=\"Prorated Expense\",\"Enter MONTHLY Sum\",IF(B22=\"Single Expense\",\"Enter LUMP Sum\",\"\")))","v":""},{"$f":"IF(ISNUMBER(E22),IF(B22=\"Prorated Expense\",IF(AND((DAY(C22)=30),(DAY(D22)=31)),(DAYS360(C22,D22)+1)*(E22/30),IF(DAY(C22)<>31,IF(MONTH(D22)<>2,IF(DAY(D22)=31,DAYS360(C22,D22)*(E22/30),(DAYS360(C22,D22)+1)*(E22/30)),IF(DAY(D22)<28,(DAYS360(C22,D22)+1)*(E22/30),(DAYS360(C22,D22)+31-DAY(D22))*(E22/30))),IF(MONTH(D22)<>2,IF(DAY(D22)=31,DAYS360(C22,D22)*(E22/30),DAYS360(C22,D22)*(E22/30)),IF(DAY(D22)<28,DAYS360(C22,D22)*(E22/30),(DAYS360(C22,D22)+30-DAY(D22))*(E22/30))))),IF(B22=\"Single Expense\",E22,IF(B22=\"Monthly Expense\",IF(AND((DAY(C22)=30),(DAY(D22)=31)),(DAYS360(C22,D22)+1)*(E22/30),IF(DAY(C22)<>31,IF(MONTH(D22)<>2,IF(DAY(D22)=31,DAYS360(C22,D22)*(E22/30),(DAYS360(C22,D22)+1)*(E22/30)),IF(DAY(D22)<28,(DAYS360(C22,D22)+1)*(E22/30),(DAYS360(C22,D22)+31-DAY(D22))*(E22/30))),IF(MONTH(D22)<>2,IF(DAY(D22)=31,DAYS360(C22,D22)*(E22/30),DAYS360(C22,D22)*(E22/30)),IF(DAY(D22)<28,DAYS360(C22,D22)*(E22/30),(DAYS360(C22,D22)+30-DAY(D22))*(E22/30))))),\"\"))),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(B23=\"Monthly Expense\",\"Enter MONTHLY Sum\",IF(B23=\"Prorated Expense\",\"Enter MONTHLY Sum\",IF(B23=\"Single Expense\",\"Enter LUMP Sum\",\"\")))","v":""},{"$f":"IF(ISNUMBER(E23),IF(B23=\"Prorated Expense\",IF(AND((DAY(C23)=30),(DAY(D23)=31)),(DAYS360(C23,D23)+1)*(E23/30),IF(DAY(C23)<>31,IF(MONTH(D23)<>2,IF(DAY(D23)=31,DAYS360(C23,D23)*(E23/30),(DAYS360(C23,D23)+1)*(E23/30)),IF(DAY(D23)<28,(DAYS360(C23,D23)+1)*(E23/30),(DAYS360(C23,D23)+31-DAY(D23))*(E23/30))),IF(MONTH(D23)<>2,IF(DAY(D23)=31,DAYS360(C23,D23)*(E23/30),DAYS360(C23,D23)*(E23/30)),IF(DAY(D23)<28,DAYS360(C23,D23)*(E23/30),(DAYS360(C23,D23)+30-DAY(D23))*(E23/30))))),IF(B23=\"Single Expense\",E23,IF(B23=\"Monthly Expense\",IF(AND((DAY(C23)=30),(DAY(D23)=31)),(DAYS360(C23,D23)+1)*(E23/30),IF(DAY(C23)<>31,IF(MONTH(D23)<>2,IF(DAY(D23)=31,DAYS360(C23,D23)*(E23/30),(DAYS360(C23,D23)+1)*(E23/30)),IF(DAY(D23)<28,(DAYS360(C23,D23)+1)*(E23/30),(DAYS360(C23,D23)+31-DAY(D23))*(E23/30))),IF(MONTH(D23)<>2,IF(DAY(D23)=31,DAYS360(C23,D23)*(E23/30),DAYS360(C23,D23)*(E23/30)),IF(DAY(D23)<28,DAYS360(C23,D23)*(E23/30),(DAYS360(C23,D23)+30-DAY(D23))*(E23/30))))),\"\"))),\"\")","v":""}]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
["Placeholder",null,null,null,"Total\nExpenses:",{"$f":"SUM(F21:F25)","v":0}]
[null,null,null,null,"Total Remaining FUM",{"$f":"F18-F26","v":0}]
[null,null,null,null,"VA Applied to Expenses",{"$f":"F19*F26","v":{"$error":"#DIV/0!"}},{"$f":"F26-F28","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Remaining VA FUM",{"$f":"F10-F28","v":{"$error":"#DIV/0!"}},{"$f":"F27-F29","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Total Funds Accounted For or Transferred",null,"Enter Total Funds Accounted For At End Of Accounting Period or Transferred."]
[null,null,null,null,"% VA Accounted or Transferred",{"$f":"F30*F19","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"% Other Accounted or Transferred",{"$f":"F30-F31","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"VA Misuse Amount",{"$f":"IF(AND(F31>=F29),0,F29-F31)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Other Misuse Amount",{"$f":"IF(AND(F32>=G29),0,((F27-F30)-F33))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Total Misuse Amount",{"$f":"F33+F34","v":{"$error":"#DIV/0!"}}]

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

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

{"sheet":"Example % No Fund Transfer","index":3,"n_rows":71,"n_cols":7,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,4,0,5],[1,1,1,2],[2,0,2,6],[61,0,70,3]]}
["Beneficiary","File Number",null,"Fiduciary","Misuse Period Date",null,"Misuse Amount Calculator"]
["Jane/John Doe","xxx-xx-xxxx",null,"Misuse, Fiduciary","2014-10-01","2017-02-28"]
["Amount calculations use a \"Pro-Rated\"date formula based on \"From - To\" dates. All \"From - To\" dates must be entered with a \"From\" date as \"MM-01-YR\" and \"To\" dates as \"MM-(28, 30, 31)-YR\", representing the actual calendar days of that month.  Enter lump sum payments (Retro/Transfers) using the entire number of days of that particular month and the amount paid.  Ensure calculations include the ending balance of the last verified VA FUM.  Copy and paste additional rows as necessary.  Use the comment cells for informational purposes relating to each individual row. See FPG, 5. for further asistance."]
["Income VA","Payment Type","From - Day 01   (i.e. 01/01/2018)","To - Up To Day 31     (i.e., 01/31/2018)","Monthly or Lump Sum Benefit","Amount","Comments VA Income"]
[null,"Beginning Balance","2014-10-01","2014-10-31",32000,{"$f":"E5","v":32000},"Beginning VA Estate Balance - Fid appointed 10-23-2014"]
[null,"Retro","2014-10-01","2014-10-01",2976,{"$f":"IF(ISNUMBER(E6),IF(B6=\"Prorated Payment\",IF(AND((DAY(C6)=30),(DAY(D6)=31)),(DAYS360(C6,D6)+1)*(E6/30),IF(DAY(C6)<>31,IF(MONTH(D6)<>2,IF(DAY(D6)=31,DAYS360(C6,D6)*(E6/30),(DAYS360(C6,D6)+1)*(E6/30)),IF(DAY(D6)<28,(DAYS360(C6,D6)+1)*(E6/30),(DAYS360(C6,D6)+31-DAY(D6))*(E6/30))),IF(MONTH(D6)<>2,IF(DAY(D6)=31,DAYS360(C6,D6)*(E6/30),DAYS360(C6,D6)*(E6/30)),IF(DAY(D6)<28,DAYS360(C6,D6)*(E6/30),(DAYS360(C6,D6)+30-DAY(D6))*(E6/30))))),IF(B6=\"Retro\",E6,IF(B6=\"Single Payment\",E6, IF(B6=\"Monthly Payment\",IF(AND((DAY(C6)=30),(DAY(D6)=31)),(DAYS360(C6,D6)+1)*(E6/30),IF(DAY(C6)<>31,IF(MONTH(D6)<>2,IF(DAY(D6)=31,DAYS360(C6,D6)*(E6/30),(DAYS360(C6,D6)+1)*(E6/30)),IF(DAY(D6)<28,(DAYS360(C6,D6)+1)*(E6/30),(DAYS360(C6,D6)+31-DAY(D6))*(E6/30))),IF(MONTH(D6)<>2,IF(DAY(D6)=31,DAYS360(C6,D6)*(E6/30),DAYS360(C6,D6)*(E6/30)),IF(DAY(D6)<28,DAYS360(C6,D6)*(E6/30),(DAYS360(C6,D6)+30-DAY(D6))*(E6/30))))), \"\")))), \"\")","v":2976}]
[null,"Single Payment","2016-01-01","2016-01-01",3052,{"$f":"IF(ISNUMBER(E7),IF(B7=\"Prorated Payment\",IF(AND((DAY(C7)=30),(DAY(D7)=31)),(DAYS360(C7,D7)+1)*(E7/30),IF(DAY(C7)<>31,IF(MONTH(D7)<>2,IF(DAY(D7)=31,DAYS360(C7,D7)*(E7/30),(DAYS360(C7,D7)+1)*(E7/30)),IF(DAY(D7)<28,(DAYS360(C7,D7)+1)*(E7/30),(DAYS360(C7,D7)+31-DAY(D7))*(E7/30))),IF(MONTH(D7)<>2,IF(DAY(D7)=31,DAYS360(C7,D7)*(E7/30),DAYS360(C7,D7)*(E7/30)),IF(DAY(D7)<28,DAYS360(C7,D7)*(E7/30),(DAYS360(C7,D7)+30-DAY(D7))*(E7/30))))),IF(B7=\"Retro\",E7,IF(B7=\"Single Payment\",E7, IF(B7=\"Monthly Payment\",IF(AND((DAY(C7)=30),(DAY(D7)=31)),(DAYS360(C7,D7)+1)*(E7/30),IF(DAY(C7)<>31,IF(MONTH(D7)<>2,IF(DAY(D7)=31,DAYS360(C7,D7)*(E7/30),(DAYS360(C7,D7)+1)*(E7/30)),IF(DAY(D7)<28,(DAYS360(C7,D7)+1)*(E7/30),(DAYS360(C7,D7)+31-DAY(D7))*(E7/30))),IF(MONTH(D7)<>2,IF(DAY(D7)=31,DAYS360(C7,D7)*(E7/30),DAYS360(C7,D7)*(E7/30)),IF(DAY(D7)<28,DAYS360(C7,D7)*(E7/30),(DAYS360(C7,D7)+30-DAY(D7))*(E7/30))))), \"\")))), \"\")","v":3052}]
[null,"Monthly Payment","2017-01-01","2017-02-28",3105,6210]
[null,"Prorated Payment","2016-01-01","2016-02-15",5000,{"$f":"IF(ISNUMBER(E9),IF(B9=\"Prorated Payment\",IF(AND((DAY(C9)=30),(DAY(D9)=31)),(DAYS360(C9,D9)+1)*(E9/30),IF(DAY(C9)<>31,IF(MONTH(D9)<>2,IF(DAY(D9)=31,DAYS360(C9,D9)*(E9/30),(DAYS360(C9,D9)+1)*(E9/30)),IF(DAY(D9)<28,(DAYS360(C9,D9)+1)*(E9/30),(DAYS360(C9,D9)+31-DAY(D9))*(E9/30))),IF(MONTH(D9)<>2,IF(DAY(D9)=31,DAYS360(C9,D9)*(E9/30),DAYS360(C9,D9)*(E9/30)),IF(DAY(D9)<28,DAYS360(C9,D9)*(E9/30),(DAYS360(C9,D9)+30-DAY(D9))*(E9/30))))),IF(B9=\"Retro\",E9,IF(B9=\"Single Payment\",E9, IF(B9=\"Monthly Payment\",IF(AND((DAY(C9)=30),(DAY(D9)=31)),(DAYS360(C9,D9)+1)*(E9/30),IF(DAY(C9)<>31,IF(MONTH(D9)<>2,IF(DAY(D9)=31,DAYS360(C9,D9)*(E9/30),(DAYS360(C9,D9)+1)*(E9/30)),IF(DAY(D9)<28,(DAYS360(C9,D9)+1)*(E9/30),(DAYS360(C9,D9)+31-DAY(D9))*(E9/30))),IF(MONTH(D9)<>2,IF(DAY(D9)=31,DAYS360(C9,D9)*(E9/30),DAYS360(C9,D9)*(E9/30)),IF(DAY(D9)<28,DAYS360(C9,D9)*(E9/30),(DAYS360(C9,D9)+30-DAY(D9))*(E9/30))))), \"\")))), \"\")","v":7500}]
[null,null,null,null,{"$f":"IF(B10 = \"Monthly Payment\", \"Enter MONTHLY Sum\", IF(B10=\"Prorated Payment\", \"Enter MONTHLY Sum\", IF(B10=\"Single Payment\", \"Enter LUMP Sum\", IF(B10=\"Retro\", \"Enter LUMP Sum\", \"\"))))","v":""},""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,{"$f":"IF(B20 = \"Monthly Payment\", \"Enter MONTHLY Sum\", IF(B20=\"Prorated Payment\", \"Enter MONTHLY Sum\", IF(B20=\"Single Payment\", \"Enter LUMP Sum\", IF(B20=\"Retro\", \"Enter LUMP Sum\", \"\"))))","v":""},""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"Total Income VA",{"$f":"SUM(F5:F23)","v":51738}]
["Income Other",null,"From - Day 01   (i.e. 01/01/2018)","To - Up To Day 31     (i.e., 01/31/2018)","Monthly or Lump Sum Benefit","Amount","Comments Other Income"]
[null,"Beginning Balance","2014-10-01","2014-10-31",11000,{"$f":"E26","v":11000},"Beginning Other Funds"]
[null,"Single Payment","2015-11-01","2015-11-01",1023,{"$f":"IF(ISNUMBER(E27),IF(B27=\"Prorated Payment\", IF(AND((DAY(C27)=30),(DAY(D27)=31)),(DAYS360(C27,D27)+1)*(E27/30),IF(DAY(C27)<>31,IF(MONTH(D27)<>2,IF(DAY(D27)=31,DAYS360(C27,D27)*(E27/30),(DAYS360(C27,D27)+1)*(E27/30)),IF(DAY(D27)<28,(DAYS360(C27,D27)+1)*(E27/30),(DAYS360(C27,D27)+31-DAY(D27))*(E27/30))),IF(MONTH(D27)<>2,IF(DAY(D27)=31,DAYS360(C27,D27)*(E27/30),DAYS360(C27,D27)*(E27/30)),IF(DAY(D27)<28,DAYS360(C27,D27)*(E27/30),(DAYS360(C27,D27)+30-DAY(D27))*(E27/30))))), IF(B27=\"Retro\", E27, IF(B27=\"Single Payment\", E27, IF(B27=\"Monthly Payment\", IF(AND((DAY(C27)=30),(DAY(D27)=31)),(DAYS360(C27,D27)+1)*(E27/30),IF(DAY(C27)<>31,IF(MONTH(D27)<>2,IF(DAY(D27)=31,DAYS360(C27,D27)*(E27/30),(DAYS360(C27,D27)+1)*(E27/30)),IF(DAY(D27)<28,(DAYS360(C27,D27)+1)*(E27/30),(DAYS360(C27,D27)+31-DAY(D27))*(E27/30))),IF(MONTH(D27)<>2,IF(DAY(D27)=31,DAYS360(C27,D27)*(E27/30),DAYS360(C27,D27)*(E27/30)),IF(DAY(D27)<28,DAYS360(C27,D27)*(E27/30),(DAYS360(C27,D27)+30-DAY(D27))*(E27/30))))),\"\")))), \"\")","v":1023}]
[null,"Monthly Payment","2016-01-01","2016-12-31",1076,{"$f":"IF(ISNUMBER(E28),IF(B28=\"Prorated Payment\", IF(AND((DAY(C28)=30),(DAY(D28)=31)),(DAYS360(C28,D28)+1)*(E28/30),IF(DAY(C28)<>31,IF(MONTH(D28)<>2,IF(DAY(D28)=31,DAYS360(C28,D28)*(E28/30),(DAYS360(C28,D28)+1)*(E28/30)),IF(DAY(D28)<28,(DAYS360(C28,D28)+1)*(E28/30),(DAYS360(C28,D28)+31-DAY(D28))*(E28/30))),IF(MONTH(D28)<>2,IF(DAY(D28)=31,DAYS360(C28,D28)*(E28/30),DAYS360(C28,D28)*(E28/30)),IF(DAY(D28)<28,DAYS360(C28,D28)*(E28/30),(DAYS360(C28,D28)+30-DAY(D28))*(E28/30))))), IF(B28=\"Retro\", E28, IF(B28=\"Single Payment\", E28, IF(B28=\"Monthly Payment\", IF(AND((DAY(C28)=30),(DAY(D28)=31)),(DAYS360(C28,D28)+1)*(E28/30),IF(DAY(C28)<>31,IF(MONTH(D28)<>2,IF(DAY(D28)=31,DAYS360(C28,D28)*(E28/30),(DAYS360(C28,D28)+1)*(E28/30)),IF(DAY(D28)<28,(DAYS360(C28,D28)+1)*(E28/30),(DAYS360(C28,D28)+31-DAY(D28))*(E28/30))),IF(MONTH(D28)<>2,IF(DAY(D28)=31,DAYS360(C28,D28)*(E28/30),DAYS360(C28,D28)*(E28/30)),IF(DAY(D28)<28,DAYS360(C28,D28)*(E28/30),(DAYS360(C28,D28)+30-DAY(D28))*(E28/30))))),\"\")))), \"\")","v":12912}]
[null,"Prorated Payment","2017-01-01","2017-02-15",1092,1638]
[null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(B31 = \"Monthly Payment\", \"Enter MONTHLY Sum\", IF(B31=\"Prorated Payment\", \"Enter MONTHLY Sum\", IF(B31=\"Single Payment\", \"Enter LUMP Sum\", IF(B31=\"Retro\", \"Enter LUMP Sum\", \"\"))))","v":""},""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"       Total Income Other",{"$f":"SUM(F26:F46)","v":26573}]
[null,null,null,null,"Total VA + Other",{"$f":"F24+F47","v":78311}]
[null,null,null,null,"% VA Income to Total Income",{"$f":"F24/F48","v":0.660673468605943}]
["Expenses Paid",null,"From - Day 01   (i.e. 01/01/2018)","To - Up To Day 31     (i.e., 01/31/2018)","Expense Amount","Amount","Comments Expenses"]
[null,"Single Expense","2014-10-28","2014-10-28",2500,{"$f":"IF(ISNUMBER(E51),IF(B51=\"Prorated Expense\",IF(AND((DAY(C51)=30),(DAY(D51)=31)),(DAYS360(C51,D51)+1)*(E51/30),IF(DAY(C51)<>31,IF(MONTH(D51)<>2,IF(DAY(D51)=31,DAYS360(C51,D51)*(E51/30),(DAYS360(C51,D51)+1)*(E51/30)),IF(DAY(D51)<28,(DAYS360(C51,D51)+1)*(E51/30),(DAYS360(C51,D51)+31-DAY(D51))*(E51/30))),IF(MONTH(D51)<>2,IF(DAY(D51)=31,DAYS360(C51,D51)*(E51/30),DAYS360(C51,D51)*(E51/30)),IF(DAY(D51)<28,DAYS360(C51,D51)*(E51/30),(DAYS360(C51,D51)+30-DAY(D51))*(E51/30))))),IF(B51=\"Single Expense\",E51,IF(B51=\"Monthly Expense\",IF(AND((DAY(C51)=30),(DAY(D51)=31)),(DAYS360(C51,D51)+1)*(E51/30),IF(DAY(C51)<>31,IF(MONTH(D51)<>2,IF(DAY(D51)=31,DAYS360(C51,D51)*(E51/30),(DAYS360(C51,D51)+1)*(E51/30)),IF(DAY(D51)<28,(DAYS360(C51,D51)+1)*(E51/30),(DAYS360(C51,D51)+31-DAY(D51))*(E51/30))),IF(MONTH(D51)<>2,IF(DAY(D51)=31,DAYS360(C51,D51)*(E51/30),DAYS360(C51,D51)*(E51/30)),IF(DAY(D51)<28,DAYS360(C51,D51)*(E51/30),(DAYS360(C51,D51)+30-DAY(D51))*(E51/30))))),\"\"))),\"\")","v":2500}]
[null,"Monthly Expense","2014-11-01","2015-10-31",2350,{"$f":"IF(ISNUMBER(E52),IF(B52=\"Prorated Expense\",IF(AND((DAY(C52)=30),(DAY(D52)=31)),(DAYS360(C52,D52)+1)*(E52/30),IF(DAY(C52)<>31,IF(MONTH(D52)<>2,IF(DAY(D52)=31,DAYS360(C52,D52)*(E52/30),(DAYS360(C52,D52)+1)*(E52/30)),IF(DAY(D52)<28,(DAYS360(C52,D52)+1)*(E52/30),(DAYS360(C52,D52)+31-DAY(D52))*(E52/30))),IF(MONTH(D52)<>2,IF(DAY(D52)=31,DAYS360(C52,D52)*(E52/30),DAYS360(C52,D52)*(E52/30)),IF(DAY(D52)<28,DAYS360(C52,D52)*(E52/30),(DAYS360(C52,D52)+30-DAY(D52))*(E52/30))))),IF(B52=\"Single Expense\",E52,IF(B52=\"Monthly Expense\",IF(AND((DAY(C52)=30),(DAY(D52)=31)),(DAYS360(C52,D52)+1)*(E52/30),IF(DAY(C52)<>31,IF(MONTH(D52)<>2,IF(DAY(D52)=31,DAYS360(C52,D52)*(E52/30),(DAYS360(C52,D52)+1)*(E52/30)),IF(DAY(D52)<28,(DAYS360(C52,D52)+1)*(E52/30),(DAYS360(C52,D52)+31-DAY(D52))*(E52/30))),IF(MONTH(D52)<>2,IF(DAY(D52)=31,DAYS360(C52,D52)*(E52/30),DAYS360(C52,D52)*(E52/30)),IF(DAY(D52)<28,DAYS360(C52,D52)*(E52/30),(DAYS360(C52,D52)+30-DAY(D52))*(E52/30))))),\"\"))),\"\")","v":28200},"Authorized allowances"]
[null,"Prorated Expense","2015-11-01","2017-02-28",2420,38720,"Revised authorized or allowed expenses from fidben"]
[null,null,null,null,{"$f":"IF(B54=\"Monthly Expense\",\"Enter MONTHLY Sum\",IF(B54=\"Prorated Expense\",\"Enter MONTHLY Sum\",IF(B54=\"Single Expense\",\"Enter LUMP Sum\",\"\")))","v":""},""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
["Placeholder",null,null,null,"",""]
[null,null,null,null,"Total\nExpenses:",{"$f":"SUM(F51:F61)","v":69420}]
[null,null,null,null,"Total Remaining FUM",{"$f":"F48-F62","v":8891}]
[null,null,null,null,"VA Applied to Expenses",{"$f":"F49*F62","v":45863.952190624565},{"$f":"F62-F64","v":23556.047809375435}]
[null,null,null,null,"Remaining VA FUM",{"$f":"F24-F64","v":5874.0478093754355},{"$f":"F63-F65","v":3016.9521906245645}]
[null,null,null,null,"Total Funds Accounted For or Transferred",null,"Enter Total Funds Accounted For At End Of Accounting Period or Transferred."]
[null,null,null,null,"% VA Accounted or Transferred",{"$f":"F66*F49","v":0}]
[null,null,null,null,"% Other Accounted or Transferred",{"$f":"F66-F67","v":0}]
[null,null,null,null,"VA Misuse Amount",{"$f":"IF(AND(F67>=F65),0,F65-F67)","v":5874.0478093754355}]
[null,null,null,null,"Other Misuse Amount",{"$f":"IF(AND(F68>=G65),0,((F63-F66)-F69))","v":3016.9521906245645}]
[null,null,null,null,"Total Misuse Amount",{"$f":"F69+F70","v":8891}]

{"sheet":"Example % Fund Transfer","index":4,"n_rows":71,"n_cols":7,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,4,0,5],[1,1,1,2],[2,0,2,6],[61,0,70,3]]}
["Beneficiary","File Number",null,"Fiduciary","Misuse Period Date",null,"Misuse Amount Calculator"]
["Jane/John Doe","xxx-xx-xxxx",null,"Misuse, Fiduciary","2014-10-01","2017-02-28"]
["Amount calculations use a \"Pro-Rated\"date formula based on \"From - To\" dates. All \"From - To\" dates must be entered with a \"From\" date as \"MM-01-YR\" and \"To\" dates as \"MM-(28, 30, 31)-YR\", representing the actual calendar days of that month.  Enter lump sum payments (Retro/Transfers) using the entire number of days of that particular month and the amount paid.  Ensure calculations include the ending balance of the last verified VA FUM.  Copy and paste additional rows as necessary.  Use the comment cells for informational purposes relating to each individual row. See FPG, 5. for further asistance."]
["Income VA","Payment Type","From - Day 01   (i.e. 01/01/2018)","To - Up To Day 31     (i.e., 01/31/2018)","Monthly or Lump Sum Benefit","Amount","Comments VA Income"]
[null,"Beginning Balance","2014-10-01","2014-10-31",32000,{"$f":"E5","v":32000},"Beginning VA Estate Balance - Fid appointed 10-23-2014"]
[null,"Retro","2014-10-01","2014-10-01",2976,{"$f":"IF(ISNUMBER(E6),IF(B6=\"Prorated Payment\",IF(AND((DAY(C6)=30),(DAY(D6)=31)),(DAYS360(C6,D6)+1)*(E6/30),IF(DAY(C6)<>31,IF(MONTH(D6)<>2,IF(DAY(D6)=31,DAYS360(C6,D6)*(E6/30),(DAYS360(C6,D6)+1)*(E6/30)),IF(DAY(D6)<28,(DAYS360(C6,D6)+1)*(E6/30),(DAYS360(C6,D6)+31-DAY(D6))*(E6/30))),IF(MONTH(D6)<>2,IF(DAY(D6)=31,DAYS360(C6,D6)*(E6/30),DAYS360(C6,D6)*(E6/30)),IF(DAY(D6)<28,DAYS360(C6,D6)*(E6/30),(DAYS360(C6,D6)+30-DAY(D6))*(E6/30))))),IF(B6=\"Retro\",E6,IF(B6=\"Single Payment\",E6, IF(B6=\"Monthly Payment\",IF(AND((DAY(C6)=30),(DAY(D6)=31)),(DAYS360(C6,D6)+1)*(E6/30),IF(DAY(C6)<>31,IF(MONTH(D6)<>2,IF(DAY(D6)=31,DAYS360(C6,D6)*(E6/30),(DAYS360(C6,D6)+1)*(E6/30)),IF(DAY(D6)<28,(DAYS360(C6,D6)+1)*(E6/30),(DAYS360(C6,D6)+31-DAY(D6))*(E6/30))),IF(MONTH(D6)<>2,IF(DAY(D6)=31,DAYS360(C6,D6)*(E6/30),DAYS360(C6,D6)*(E6/30)),IF(DAY(D6)<28,DAYS360(C6,D6)*(E6/30),(DAYS360(C6,D6)+30-DAY(D6))*(E6/30))))), \"\")))), \"\")","v":2976}]
[null,"Single Payment","2016-01-01","2016-01-01",3052,{"$f":"IF(ISNUMBER(E7),IF(B7=\"Prorated Payment\",IF(AND((DAY(C7)=30),(DAY(D7)=31)),(DAYS360(C7,D7)+1)*(E7/30),IF(DAY(C7)<>31,IF(MONTH(D7)<>2,IF(DAY(D7)=31,DAYS360(C7,D7)*(E7/30),(DAYS360(C7,D7)+1)*(E7/30)),IF(DAY(D7)<28,(DAYS360(C7,D7)+1)*(E7/30),(DAYS360(C7,D7)+31-DAY(D7))*(E7/30))),IF(MONTH(D7)<>2,IF(DAY(D7)=31,DAYS360(C7,D7)*(E7/30),DAYS360(C7,D7)*(E7/30)),IF(DAY(D7)<28,DAYS360(C7,D7)*(E7/30),(DAYS360(C7,D7)+30-DAY(D7))*(E7/30))))),IF(B7=\"Retro\",E7,IF(B7=\"Single Payment\",E7, IF(B7=\"Monthly Payment\",IF(AND((DAY(C7)=30),(DAY(D7)=31)),(DAYS360(C7,D7)+1)*(E7/30),IF(DAY(C7)<>31,IF(MONTH(D7)<>2,IF(DAY(D7)=31,DAYS360(C7,D7)*(E7/30),(DAYS360(C7,D7)+1)*(E7/30)),IF(DAY(D7)<28,(DAYS360(C7,D7)+1)*(E7/30),(DAYS360(C7,D7)+31-DAY(D7))*(E7/30))),IF(MONTH(D7)<>2,IF(DAY(D7)=31,DAYS360(C7,D7)*(E7/30),DAYS360(C7,D7)*(E7/30)),IF(DAY(D7)<28,DAYS360(C7,D7)*(E7/30),(DAYS360(C7,D7)+30-DAY(D7))*(E7/30))))), \"\")))), \"\")","v":3052}]
[null,"Monthly Payment","2017-01-01","2017-02-28",3105,6210]
[null,"Prorated Payment","2016-01-01","2016-02-15",5000,7500]
[null,null,null,null,{"$f":"IF(B10 = \"Monthly Payment\", \"Enter MONTHLY Sum\", IF(B10=\"Prorated Payment\", \"Enter MONTHLY Sum\", IF(B10=\"Single Payment\", \"Enter LUMP Sum\", IF(B10=\"Retro\", \"Enter LUMP Sum\", \"\"))))","v":""},""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"Total Income VA",{"$f":"SUM(F5:F23)","v":51738}]
["Income Other",null,"From - Day 01   (i.e. 01/01/2018)","To - Up To Day 31     (i.e., 01/31/2018)","Monthly or Lump Sum Benefit","Amount","Comments Other Income"]
[null,"Beginning Balance","2014-10-01","2014-10-31",11000,{"$f":"E26","v":11000},"Beginning Other Funds"]
[null,"Single Payment","2015-11-01","2015-11-01",1023,{"$f":"IF(ISNUMBER(E27),IF(B27=\"Prorated Payment\", IF(AND((DAY(C27)=30),(DAY(D27)=31)),(DAYS360(C27,D27)+1)*(E27/30),IF(DAY(C27)<>31,IF(MONTH(D27)<>2,IF(DAY(D27)=31,DAYS360(C27,D27)*(E27/30),(DAYS360(C27,D27)+1)*(E27/30)),IF(DAY(D27)<28,(DAYS360(C27,D27)+1)*(E27/30),(DAYS360(C27,D27)+31-DAY(D27))*(E27/30))),IF(MONTH(D27)<>2,IF(DAY(D27)=31,DAYS360(C27,D27)*(E27/30),DAYS360(C27,D27)*(E27/30)),IF(DAY(D27)<28,DAYS360(C27,D27)*(E27/30),(DAYS360(C27,D27)+30-DAY(D27))*(E27/30))))), IF(B27=\"Retro\", E27, IF(B27=\"Single Payment\", E27, IF(B27=\"Monthly Payment\", IF(AND((DAY(C27)=30),(DAY(D27)=31)),(DAYS360(C27,D27)+1)*(E27/30),IF(DAY(C27)<>31,IF(MONTH(D27)<>2,IF(DAY(D27)=31,DAYS360(C27,D27)*(E27/30),(DAYS360(C27,D27)+1)*(E27/30)),IF(DAY(D27)<28,(DAYS360(C27,D27)+1)*(E27/30),(DAYS360(C27,D27)+31-DAY(D27))*(E27/30))),IF(MONTH(D27)<>2,IF(DAY(D27)=31,DAYS360(C27,D27)*(E27/30),DAYS360(C27,D27)*(E27/30)),IF(DAY(D27)<28,DAYS360(C27,D27)*(E27/30),(DAYS360(C27,D27)+30-DAY(D27))*(E27/30))))),\"\")))), \"\")","v":1023}]
[null,"Monthly Payment","2016-01-01","2016-12-31",1076,{"$f":"IF(ISNUMBER(E28),IF(B28=\"Prorated Payment\", IF(AND((DAY(C28)=30),(DAY(D28)=31)),(DAYS360(C28,D28)+1)*(E28/30),IF(DAY(C28)<>31,IF(MONTH(D28)<>2,IF(DAY(D28)=31,DAYS360(C28,D28)*(E28/30),(DAYS360(C28,D28)+1)*(E28/30)),IF(DAY(D28)<28,(DAYS360(C28,D28)+1)*(E28/30),(DAYS360(C28,D28)+31-DAY(D28))*(E28/30))),IF(MONTH(D28)<>2,IF(DAY(D28)=31,DAYS360(C28,D28)*(E28/30),DAYS360(C28,D28)*(E28/30)),IF(DAY(D28)<28,DAYS360(C28,D28)*(E28/30),(DAYS360(C28,D28)+30-DAY(D28))*(E28/30))))), IF(B28=\"Retro\", E28, IF(B28=\"Single Payment\", E28, IF(B28=\"Monthly Payment\", IF(AND((DAY(C28)=30),(DAY(D28)=31)),(DAYS360(C28,D28)+1)*(E28/30),IF(DAY(C28)<>31,IF(MONTH(D28)<>2,IF(DAY(D28)=31,DAYS360(C28,D28)*(E28/30),(DAYS360(C28,D28)+1)*(E28/30)),IF(DAY(D28)<28,(DAYS360(C28,D28)+1)*(E28/30),(DAYS360(C28,D28)+31-DAY(D28))*(E28/30))),IF(MONTH(D28)<>2,IF(DAY(D28)=31,DAYS360(C28,D28)*(E28/30),DAYS360(C28,D28)*(E28/30)),IF(DAY(D28)<28,DAYS360(C28,D28)*(E28/30),(DAYS360(C28,D28)+30-DAY(D28))*(E28/30))))),\"\")))), \"\")","v":12912}]
[null,"Prorated Payment","2017-01-01","2017-02-15",1092,1638]
[null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(B31 = \"Monthly Payment\", \"Enter MONTHLY Sum\", IF(B31=\"Prorated Payment\", \"Enter MONTHLY Sum\", IF(B31=\"Single Payment\", \"Enter LUMP Sum\", IF(B31=\"Retro\", \"Enter LUMP Sum\", \"\"))))","v":""},""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,{"$f":"IF(B35 = \"Monthly Payment\", \"Enter MONTHLY Sum\", IF(B35=\"Prorated Payment\", \"Enter MONTHLY Sum\", IF(B35=\"Single Payment\", \"Enter LUMP Sum\", IF(B35=\"Retro\", \"Enter LUMP Sum\", \"\"))))","v":""},""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"       Total Income Other",{"$f":"SUM(F26:F46)","v":26573}]
[null,null,null,null,"Total VA + Other",{"$f":"F24+F47","v":78311}]
[null,null,null,null,"% VA Income to Total Income",{"$f":"F24/F48","v":0.660673468605943}]
["Expenses Paid",null,"From - Day 01   (i.e. 01/01/2018)","To - Up To Day 31     (i.e., 01/31/2018)","Expense Amount","Amount","Comments Expenses"]
[null,"Single Expense","2014-10-28","2014-10-28",2500,{"$f":"IF(ISNUMBER(E51),IF(B51=\"Prorated Expense\",IF(AND((DAY(C51)=30),(DAY(D51)=31)),(DAYS360(C51,D51)+1)*(E51/30),IF(DAY(C51)<>31,IF(MONTH(D51)<>2,IF(DAY(D51)=31,DAYS360(C51,D51)*(E51/30),(DAYS360(C51,D51)+1)*(E51/30)),IF(DAY(D51)<28,(DAYS360(C51,D51)+1)*(E51/30),(DAYS360(C51,D51)+31-DAY(D51))*(E51/30))),IF(MONTH(D51)<>2,IF(DAY(D51)=31,DAYS360(C51,D51)*(E51/30),DAYS360(C51,D51)*(E51/30)),IF(DAY(D51)<28,DAYS360(C51,D51)*(E51/30),(DAYS360(C51,D51)+30-DAY(D51))*(E51/30))))),IF(B51=\"Single Expense\",E51,IF(B51=\"Monthly Expense\",IF(AND((DAY(C51)=30),(DAY(D51)=31)),(DAYS360(C51,D51)+1)*(E51/30),IF(DAY(C51)<>31,IF(MONTH(D51)<>2,IF(DAY(D51)=31,DAYS360(C51,D51)*(E51/30),(DAYS360(C51,D51)+1)*(E51/30)),IF(DAY(D51)<28,(DAYS360(C51,D51)+1)*(E51/30),(DAYS360(C51,D51)+31-DAY(D51))*(E51/30))),IF(MONTH(D51)<>2,IF(DAY(D51)=31,DAYS360(C51,D51)*(E51/30),DAYS360(C51,D51)*(E51/30)),IF(DAY(D51)<28,DAYS360(C51,D51)*(E51/30),(DAYS360(C51,D51)+30-DAY(D51))*(E51/30))))),\"\"))),\"\")","v":2500}]
[null,"Monthly Expense","2014-11-01","2015-10-31",2350,{"$f":"IF(ISNUMBER(E52),IF(B52=\"Prorated Expense\",IF(AND((DAY(C52)=30),(DAY(D52)=31)),(DAYS360(C52,D52)+1)*(E52/30),IF(DAY(C52)<>31,IF(MONTH(D52)<>2,IF(DAY(D52)=31,DAYS360(C52,D52)*(E52/30),(DAYS360(C52,D52)+1)*(E52/30)),IF(DAY(D52)<28,(DAYS360(C52,D52)+1)*(E52/30),(DAYS360(C52,D52)+31-DAY(D52))*(E52/30))),IF(MONTH(D52)<>2,IF(DAY(D52)=31,DAYS360(C52,D52)*(E52/30),DAYS360(C52,D52)*(E52/30)),IF(DAY(D52)<28,DAYS360(C52,D52)*(E52/30),(DAYS360(C52,D52)+30-DAY(D52))*(E52/30))))),IF(B52=\"Single Expense\",E52,IF(B52=\"Monthly Expense\",IF(AND((DAY(C52)=30),(DAY(D52)=31)),(DAYS360(C52,D52)+1)*(E52/30),IF(DAY(C52)<>31,IF(MONTH(D52)<>2,IF(DAY(D52)=31,DAYS360(C52,D52)*(E52/30),(DAYS360(C52,D52)+1)*(E52/30)),IF(DAY(D52)<28,(DAYS360(C52,D52)+1)*(E52/30),(DAYS360(C52,D52)+31-DAY(D52))*(E52/30))),IF(MONTH(D52)<>2,IF(DAY(D52)=31,DAYS360(C52,D52)*(E52/30),DAYS360(C52,D52)*(E52/30)),IF(DAY(D52)<28,DAYS360(C52,D52)*(E52/30),(DAYS360(C52,D52)+30-DAY(D52))*(E52/30))))),\"\"))),\"\")","v":28200},"Authorized allowances"]
[null,"Prorated Expense","2015-11-01","2017-02-28",2420,38720,"Revised authorized or allowed expenses from fidben"]
[null,null,null,null,{"$f":"IF(B54=\"Monthly Expense\",\"Enter MONTHLY Sum\",IF(B54=\"Prorated Expense\",\"Enter MONTHLY Sum\",IF(B54=\"Single Expense\",\"Enter LUMP Sum\",\"\")))","v":""},""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
["Placeholder",null,null,null,"",""]
[null,null,null,null,"Total\nExpenses:",{"$f":"SUM(F51:F61)","v":69420}]
[null,null,null,null,"Total Remaining FUM",{"$f":"F48-F62","v":8891}]
[null,null,null,null,"VA Applied to Expenses",{"$f":"F49*F62","v":45863.952190624565},{"$f":"F62-F64","v":23556.047809375435}]
[null,null,null,null,"Remaining VA FUM",{"$f":"F24-F64","v":5874.0478093754355},{"$f":"F63-F65","v":3016.9521906245645}]
[null,null,null,null,"Total Funds Accounted For or Transferred",10000,"Enter Total Funds Accounted For At End Of Accounting Period or Transferred."]
[null,null,null,null,"% VA Accounted or Transferred",{"$f":"F66*F49","v":6606.7346860594298}]
[null,null,null,null,"% Other Accounted or Transferred",{"$f":"F66-F67","v":3393.2653139405702}]
[null,null,null,null,"VA Misuse Amount",{"$f":"IF(AND(F67>=F65),0,F65-F67)","v":0}]
[null,null,null,null,"Other Misuse Amount",{"$f":"IF(AND(F68>=G65),0,((F63-F66)-F69))","v":0}]
[null,null,null,null,"Total Misuse Amount",{"$f":"F69+F70","v":0}]