Spreadsheet: 849386d1699894802-vlookup-with-if-or-cash-receipts-test
Sheet: Projection

DEP_TRANS DT | CHECK_ACH NO | CHECK_CR AMT | LOC | SYS | PYMNT | 2024
 |  |  |  |  |  | DEC 15 | FEB 01 | AMORT
2023-04-03 00:00:00 | 22459 | 502 | 30591 | ERS | ARC
2023-04-03 00:00:00 | 11971 | 185 | 30858 | ERS | ARC
2023-04-03 00:00:00 | 27629 | 503.4 | 40532 | ERS | ARC
2023-04-04 00:00:00 | 17732 | 117000 | 10034 | ERS | AVBE
2023-04-04 00:00:00 | 17733 | 143000 | 10034 | ERS | AVBE
2023-04-04 00:00:00 | 9841 | 156 | 30128 | ERS | PYI
2023-04-04 00:00:00 | 4392 | 95 | 30363 | ERS | PYI
2023-04-04 00:00:00 | 8834 | 13849 | 30702 | ERS | PYI
2023-04-04 00:00:00 | 11246 | 9000 | 30702 | ERS | PYI
2023-04-04 00:00:00 | 21933 | 50756 | 51100 | ERS | PYI
2023-04-04 00:00:00 | 8786 | 46 | 51332 | ERS | PYI
2023-04-05 00:00:00 | 214914 | 527 | 75554 | ERS | PYI
2023-04-06 00:00:00 | 0956823336TC | 1449380 | 50992 | ERS | 0
2023-04-07 00:00:00 | 4731 | 430645 | 40262 | PFRS | PYI
2023-04-07 00:00:00 | 4734 | 115322 | 40262 | ERS | PYI
2023-04-10 00:00:00 | 3057700100JO | 33.6 | 74764 | ERS | 0
2023-04-10 00:00:00 | 3060800100JO | 24.96 | 74764 | ERS | 0
2023-04-10 00:00:00 | 3065500100JO | 45123.77 | 74764 | ERS | 0
2023-04-10 00:00:00 | 3065500100JO | 1707.14 | 74764 | ERS | 0
2023-04-10 00:00:00 | 3065500100JO | 16172.29 | 74764 | ERS | 0
2023-04-11 00:00:00 | 4076 | 1068 | 30065 | ERS | PYI
2023-04-17 00:00:00 | 0131840107FF | 1213251.47 | 10001 | ERS | 0
2023-04-17 00:00:00 | 1941 | 56 | 30747 | ERS | PYI
2023-04-17 00:00:00 | 1150 | 9162 | 50900 | ERS | PYI
2023-04-18 00:00:00 | 28365 | 1090.14 | 30696 | ERS | PYI
2023-04-18 00:00:00 | 32887 | 50000 | 75556 | ERS | PYI
2023-04-19 00:00:00 | 1089605784TC | 4770 | 10009 | ERS | 0
2023-05-01 00:00:00 | 1185767232TC | 99999999.99 | Judiciary | 0 | 0
2023-05-01 00:00:00 | 1185767234TC | 99999999.99 | Judiciary | 0 | 0
2023-05-01 00:00:00 | 1185767236TC | 4202302.02 | Judiciary | 0 | 0
2023-05-05 00:00:00 | 3755000116JO | 42812.87 | 74764 | ERS | 0
2023-05-08 00:00:00 | 1258965409TC | 1449380 | 50992 | ERS | 0
2023-05-16 00:00:00 | 14455 | 360.88 | 30758 | ERS | PYI
2023-05-17 00:00:00 | 0183640137FF | 92282 | 40097 | PFRS | 0
2023-05-17 00:00:00 | 1368409952TC | 2000 | 50851 | ERS | 0
2023-05-18 00:00:00 | 32957 | 50000 | 75556 | ERS | PYI
2023-05-19 00:00:00 | 11809 | 174 | 40307 | ERS | AVBE
2023-05-22 00:00:00 | 6785 | 9009 | 51523 | ERS | AVBE
2023-05-23 00:00:00 | 64276 | 3467 | 73900 | ERS | AVBE
2023-05-25 00:00:00 | 0746780144FF | 2119954 | 20013 | PFRS | 0
2023-05-25 00:00:00 | 4411900144JO | 712000 | 30057 | PFRS | 0
2023-05-26 00:00:00 | 0390130146FF | 74000 | 10015 | ERS | 0
2023-05-26 00:00:00 | 0390130146FF | 521000 | 10015 | ERS | 0
2023-05-31 00:00:00 | 94306 | 1785 | 40339 | PFRS | AVBP
2023-06-02 00:00:00 | 5321000151JO | 42667.82 | 74764 | ERS | 0
2023-06-06 00:00:00 | 1561170243TC | 1449380 | 50992 | ERS | 0
2023-06-07 00:00:00 | 98867 | 253967.85 | 20054 | PFRS | APP
2023-06-07 00:00:00 | 98868 | 207799.4 | 20054 | PFRS | APP
2023-06-07 00:00:00 | 98869 | 361950.47 | 20054 | PFRS | APP
2023-06-07 00:00:00 | 98870 | 273819.43 | 20054 | PFRS | APP
2023-06-08 00:00:00 | 38444 | 555 | 40384 | ERS | AVBE
2023-06-09 00:00:00 | 1097 | 1133.8 | 40521 | ERS | AVBE
2023-06-09 00:00:00 | 1130 | 2267.6 | 40521 | ERS | AVBE
2023-06-09 00:00:00 | 1360 | 7936.6 | 40521 | ERS | AVBE
2023-06-15 00:00:00 | 1657529306TC | 2000 | 50851 | ERS | 0
2023-06-15 00:00:00 | 1657529308TC | 2136576.06 | SurvivorBenefits | 0 | 0
2023-06-16 00:00:00 | 32998 | 50000 | 75556 | ERS | PYI
2023-06-20 00:00:00 | 58555 | 68760 | 40195 | ERS | PYI
2023-06-20 00:00:00 | 58555 | 45373 | 40195 | PFRS | PYI
2023-06-21 00:00:00 | 13875 | 13304 | 40354 | ERS | AVBE
2023-06-23 00:00:00 | 0171370174FF | 69400 | 20043 | PFRS | 0
2023-07-05 00:00:00 | 1355 | 123746 | 50823 | ERS | ARC
2023-07-05 00:00:00 | 1356 | 101580 | 50823 | PFRS | ARC
2023-07-06 00:00:00 | 1850720187EZ | 10957 | 20002 | PFRS | 0
2023-07-06 00:00:00 | 1860140634TC | 1449380 | 50992 | ERS | 0
2023-07-07 00:00:00 | 0343630188FF | 377800 | 72513 | ERS | 0
2023-07-07 00:00:00 | 8237600187JO | 60590.66 | 74764 | ERS | 0
2023-07-11 00:00:00 | 2550 | 25 | 51498 | PFRS | AVBP
2023-07-12 00:00:00 | 33110 | 50000 | 75556 | ERS | PYI
2023-07-14 00:00:00 | 1946385362TC | 2000 | 50851 | ERS | 0
2023-07-18 00:00:00 | 58954 | 1518 | 40195 | ERS | PYI
2023-07-18 00:00:00 | 58954 | 639 | 40195 | PFRS | PYI
2023-07-20 00:00:00 | 1419 | 308231 | 40349 | PFRS | AVBP
2023-08-03 00:00:00 | 2784600214JO | 29803.82 | 74764 | ERS | 0
2023-08-07 00:00:00 | 0318990219FF | 1045101 | 20013 | PFRS | 0
2023-08-08 00:00:00 | 2191736213TC | 44500 | 10003 | ERS | 0
2023-08-09 00:00:00 | 2207767310TC | 1449380 | 50992 | ERS | 0
2023-08-15 00:00:00 | 4414 | 61.63 | 40192 | ERS | AVBE
2023-08-15 00:00:00 | 6731 | 308.12 | 40192 | ERS | AVBE
2023-08-15 00:00:00 | 2269285124TC | 2000 | 50851 | ERS | 0
2023-08-15 00:00:00 | 33248 | 50000 | 75556 | ERS | PYI
2023-08-18 00:00:00 | 0480000230FF | 72055.67 | 20013 | PFRS | 0
2023-08-22 00:00:00 | 4417 | 20.54 | 40192 | ERS | AVBE
2023-08-22 00:00:00 | 6736 | 102.71 | 40192 | ERS | AVBE
2023-08-22 00:00:00 | 5164 | 2651 | 40526 | ERS | AVBE
2023-08-24 00:00:00 | 0089190236FF | 15747.38 | 51151 | ERS | 0
2023-08-31 00:00:00 | 7027900229JO | 28957.28 | 74764 | ERS | 0
2023-09-06 00:00:00 | 2488426911TC | 1449380 | 50992 | ERS | ARC
2023-09-06 00:00:00 | 33280 | 50000 | 75556 | ERS | PYI
2023-09-08 00:00:00 | 5308900250JO | 1 | 10026 | ERS | ARC
2023-09-11 00:00:00 | 33591 | 6628 | 51085 | ERS | ARC
2023-09-15 00:00:00 | 2579763860TC | 2000 | 50851 | ERS | ARC
2023-09-18 00:00:00 | 5586 | 15704 | 30865 | ERS | ARC
2023-09-18 00:00:00 | 6579 | 15000 | 30865 | ERS | ARC
2023-09-21 00:00:00 | 22160 | 67041 | 30648 | ERS | ARC
2023-09-25 00:00:00 | 34415 | 505516 | 72707 | ERS | ARC
2023-09-26 00:00:00 | 88966 | 1546945 | 73314 | ERS | ARC
2023-10-02 00:00:00 | 2371 | 11108 | 51075 | ERS | ARC
2023-10-06 00:00:00 | 4178700279JO | 56772.21 | 74764 | ERS | ESB
2023-10-10 00:00:00 | 2796480802TC | 1449380 | 50992 | ERS | ARC
2023-10-12 00:00:00 | 3538 | 14000 | 40343 | ERS | ARC
2023-10-12 00:00:00 | 19036 | 79318 | 40343 | ERS | ARC
2023-10-12 00:00:00 | 19036 | 105553 | 40343 | PFRS | ARC
2023-10-13 00:00:00 | 2857443248TC | 2000 | 50851 | ERS | PYI
2023-10-17 00:00:00 | 33419 | 50000 | 75556 | ERS | PYI
2023-10-19 00:00:00 | 1484 | 1000 | 30600 | ERS | ARC
2023-10-19 00:00:00 | 2529 | 28246 | 30600 | ERS | ARC
2023-10-19 00:00:00 | 4109 | 16000 | 30600 | ERS | ARC
2023-10-20 00:00:00 | 60446 | 5013.66 | 30416 | ERS | ARC
2023-10-20 00:00:00 | 70261 | 5013.68 | 30416 | ERS | ARC
2023-10-20 00:00:00 | 70266 | 5013.67 | 30416 | ERS | ARC
2023-10-24 00:00:00 | 2041 | 12594 | 30770 | ERS | ARC
2023-10-24 00:00:00 | 35345 | 346247 | 73809 | ERS | ARC
2023-10-27 00:00:00 | 1111 | 50097 | 30577 | ERS | ARC
2023-10-30 00:00:00 | 3006571039TC | 1122750 | 50945 | ERS | ARC
2023-11-03 00:00:00 | 3068464033TC | 1500 | 10009 | ERS | AVB
2023-11-03 00:00:00 | 0482571307FF | 4471 | 40097 | PFRS | AVB
2023-11-03 00:00:00 | 7495 | 38294 | 50740 | ERS | ARC
2023-11-03 00:00:00 | 6446500298JO | 43990.98 | 74764 | ERS | ESB
2023-11-06 00:00:00 | 3075607728TC | 1449380 | 50992 | ERS | ARC
2023-11-06 00:00:00 | 47980 | 166292 | 73612 | ERS | ARC
2023-11-08 00:00:00 | 10198 | 14134 | 30073 | PFRS | ARC
2023-11-08 00:00:00 | 3231 | 184783 | 30073 | ERS | ARC
2023-11-09 00:00:00 | 0800311313FF | 66238 | 30568 | ERS | ARC
2023-11-09 00:00:00 | 0798821313FF | 2630 | 30568 | PFRS | ARC
2023-11-09 00:00:00 | 10754 | 251 | 51102 | ERS | AVBE
2023-11-10 00:00:00 | 3137950501TC | 3600 | 10003 | ERS | AVB
2023-11-10 00:00:00 | 119694 | 1076665 | 70016 | ERS | ARC
2023-11-10 00:00:00 | 147680 | 429410 | 75414 | ERS | ARC