Spreadsheet: 782791d1654272591-spill-formula-to-sum-up-schedules-by-months-test11
Sheet: USD 05.22

2022-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun 2022 | Jul 2022 | Aug 2022 | Sep 2022
Schedule # | Invoice Date |  |  | [NAME] | Destination Account | Transac.# | Amount total | Remaining Amount | Total amortized |  | Jan 2021 | Feb 2021 | Mar 2021 | Apr 2021 | May 2021 | Jun 2021 | Jul 2021 | Aug 2021 | Sep 2021 | Oct 2021 | Nov 2021 | Dec 2021 | Jan 2022 | Feb 2022 | Mar 2022 | Apr 2022 | May 2022
30998 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 911.2 | 572.44 | 572.44 | 572.44 | 572.44 | 572.44 | 572.44 | 572.44 | 572.44 | 572.44 | 572.44 | 0 | 0 | 0 | 0
31615 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 672.61 | 672.61 | 672.61 | 672.61 | 672.61 | 672.61 | 672.61 | 672.61 | 672.61 | 672.61 | 672.61 | 0 | 0 | 0 | 0
36111 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 123.58 | 537.65 | 537.65 | 537.65 | 537.65 | 537.65 | 537.65 | 537.65 | 537.65 | 0 | 0 | 0 | 0
36485 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2904 | 2904 | 2904 | 2904 | 2904 | 2904 | 2904 | 2904 | 2904 | 0 | 0 | 0 | 0
36487 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -123.58 | -537.65 | -537.65 | -537.65 | -537.65 | -537.65 | -537.65 | -537.65 | -537.65 | 0 | 0 | 0 | 0
38012 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 125.33 | 545.25 | 545.25 | 545.25 | 545.25 | 545.25 | 545.25 | 545.25 | 545.25 | 0 | 0 | 0 | 0
38130 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3168 | 1584 | 1584 | 1584 | 1584 | 1584 | 1584 | 1584 | 0 | 0 | 0 | 0
38831 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30.85 | 30.85 | 30.85 | 30.85 | 30.85 | 30.85 | 30.85 | 30.85 | 0 | 0 | 0 | 0
39180 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1014 | 1014 | 1014 | 1014 | 1014 | 1014 | 1014 | 1014 | 0 | 0 | 0 | 0
39184 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 0 | 0 | 0 | 0
39815 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -2077.64 | -2077.64 | -2077.64 | -2077.64 | -2077.64 | -2077.64 | -2077.64 | 0 | 0 | 0 | 0
40098 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 117 | 117 | 117 | 117 | 117 | 117 | 117 | 0 | 0 | 0 | 0
41570 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 0 | 0 | 0 | 0
43829 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 126 | 126 | 126 | 126 | 126 | 126 | 0 | 0 | 0 | 0
43831 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 234 | 234 | 234 | 234 | 234 | 0 | 0 | 0 | 0
45047 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 432 | 144 | 144 | 144 | 144 | 144 | 0 | 0 | 0 | 0
45049 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 468.92 | 468.92 | 468.92 | 468.92 | 468.92 | 0 | 0 | 0 | 0
45357 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2660 | 2660 | 2660 | 2660 | 0 | 0 | 0 | 0
46039 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 387 | 387 | 387 | 387 | 0 | 0 | 0 | 0
47164 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4933.059999999999 | 2860.49 | 2860.49 | 2860.49 | 0 | 0 | 0 | 0
47166 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 31.94 | 31.94 | 31.94 | 31.94 | 0 | 0 | 0 | 0
48190 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 32.08 | 32.08 | 32.08 | 32.08 | 0 | 0 | 0 | 0
48675 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 458.16 | 152.72 | 152.72 | 0 | 0 | 0 | 0
49412 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 83792.46 | 83792.45 | 0 | 0 | 0 | 0
49994 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 61.69 | 61.69 | 0 | 0 | 0 | 0
49996 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 77.11 | 77.11 | 0 | 0 | 0 | 0
50509 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25528.14 | 0 | 0 | 0 | 0
50510 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
50642 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
50724 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 524.76 | 262.38 | 0 | 0 | 0 | 0
51602 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 410.3 | 410.3 | 0 | 0 | 0 | 0
51909 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 28333.34 | 0 | 0 | 0 | 0
51910 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
51913 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
51914 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
51928 |  |  |  |  |  |  |  |  |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0