Spreadsheet: 782801d1654275687-spill-formula-to-sum-up-schedules-by-months-test11
Sheet: USD 05.22

2022-05-01 00:00:00
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 | Jun 2022 | Jul 2022 | Aug 2022 | Sep 2022
 |  |  |  |  |  |  | 0 | 798.3 |  |  |  | 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 | 572.44 | 225.86 | 0 | 0
30998 | 2021-06-24 00:00:00 |  |  |  |  | 0 | 0 | 672.62 |  | 8071.329999999999 | 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 | 672.62 | 0 | 0 | 0
31615 | 2021-06-28 00:00:00 |  |  |  |  | 0 | 0 | 2018.96 |  | 6443.74 | 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 | 537.65 | 537.65 | 537.62 | 406.04
36111 | 2021-09-01 00:00:00 |  |  |  |  | 0 | 0 | 8711.96 |  | 34847.96 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2904 | 2904 | 2904 | 2904 | 2904 | 2904 | 2904 | 2904 | 2904 | 2904 | 2904 | 2903.96 | 0
36485 | 2021-09-13 00:00:00 |  |  |  |  | 0 | 0 | -2018.96 |  | -6443.74 | 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 | -537.65 | -537.65 | -537.62 | -406.04
36487 | 2021-09-13 00:00:00 |  |  |  |  | 0 | 0 | 2047.56 |  | 6534.89 | 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 | 545.25 | 545.25 | 545.25 | 411.81
38012 | 2021-08-31 00:00:00 |  |  |  |  | 0 | 0 | 4752.01 |  | 19008.01 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3168 | 1584 | 1584 | 1584 | 1584 | 1584 | 1584 | 1584 | 1584 | 1584 | 1584.01 | 0
38130 | 2021-10-10 00:00:00 |  |  |  |  | 0 | 0 | 123.34 |  | 370.14 | 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 | 30.85 | 30.85 | 30.85 | 30.79
38831 | 2021-10-05 00:00:00 |  |  |  |  | 0 | 0 | 4056 |  | 12168 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1014 | 1014 | 1014 | 1014 | 1014 | 1014 | 1014 | 1014 | 1014 | 1014 | 1014 | 1014
39180 | 2021-10-15 00:00:00 |  |  |  |  | 0 | 0 | 10456.52 |  | 22854.04 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64
39184 | 2021-11-09 00:00:00 |  |  |  |  | 0 | 0 | -10456.52 |  | -22854.04 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -2077.64 | -2077.64 | -2077.64 | -2077.64 | -2077.64 | -2077.64 | -2077.64 | -2077.64 | -2077.64 | -2077.64 | -2077.64
39815 | 2021-10-30 00:00:00 |  |  |  |  | 0 | 0 | 351 |  | 1170 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 117 | 117 | 117 | 117 | 117 | 117 | 117 | 117 | 117 | 117 | 0
40098 | 2021-10-15 00:00:00 |  |  |  |  | 0 | 0 | 10456.52 |  | 22854.04 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64 | 2077.64
41570 | 2021-11-30 00:00:00 |  |  |  |  | 0 | 0 | 378 |  | 1134 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 126 | 126 | 126 | 126 | 126 | 126 | 126 | 126 | 126 | 0
43829 | 2021-12-30 00:00:00 |  |  |  |  | 0 | 0 | 702 |  | 1872 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 234 | 234 | 234 | 234 | 234 | 234 | 234 | 234 | 0
43831 | 2021-10-01 00:00:00 |  |  |  |  | 0 | 0 | 432 |  | 1584 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 432 | 144 | 144 | 144 | 144 | 144 | 144 | 144 | 144 | 0
45047 | 2021-12-31 00:00:00 |  |  |  |  | 0 | 0 | 3282.4 |  | 4220.28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 468.92 | 468.92 | 468.92 | 468.92 | 468.92 | 468.92 | 468.92 | 468.92 | 468.92
45049 | 2022-01-25 00:00:00 |  |  |  |  | 0 | 0 | 21280 |  | 21280 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2660 | 2660 | 2660 | 2660 | 2660 | 2660 | 2660 | 2660
45357 | 2022-01-30 00:00:00 |  |  |  |  | 0 | 0 | 1161 |  | 2709 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 387 | 387 | 387 | 387 | 387 | 387 | 387 | 0
46039 | 2022-01-25 00:00:00 |  |  |  |  | 0 | 0 | 20965.47 |  | 24956.49 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4933.059999999999 | 2860.49 | 2860.49 | 2860.49 | 2860.49 | 2860.49 | 2860.49 | 2860.49
47164 | 2022-02-13 00:00:00 |  |  |  |  | 0 | 0 | 255.55 |  | 255.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 31.94 | 31.94 | 31.94 | 31.94 | 31.94 | 31.94 | 31.94 | 31.94
47166 | 2022-02-10 00:00:00 |  |  |  |  | 0 | 0 | 641.63 |  | 256.6399999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 32.08 | 32.08 | 32.08 | 32.08 | 32.08 | 32.08 | 32.08 | 32.08
48190 | 2022-01-11 00:00:00 |  |  |  |  | 0 | 0 | 610.91 |  | 1374.51 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 458.16 | 152.72 | 152.72 | 152.72 | 152.72 | 152.72 | 152.75
48675 | 2022-03-21 00:00:00 |  |  |  |  | 0 | 0 | 0 |  | 167584.91 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 83792.46 | 83792.45 | 0 | 0 | 0 | 0
49412 | 2022-03-23 00:00:00 |  |  |  |  | 0 | 0 | 616.9 |  | 370.14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 61.69 | 61.69 | 61.69 | 61.69 | 61.69 | 61.69
49994 | 2022-03-20 00:00:00 |  |  |  |  | 0 | 0 | 771.13 |  | 462.66 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 77.11 | 77.11 | 77.11 | 77.11 | 77.11 | 77.11
49996 | 2022-03-31 00:00:00 |  |  |  |  | 0 | 0 | 0 |  | 25528.14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25528.14 | 0 | 0 | 0 | 0
50509 | 2022-03-27 00:00:00 |  |  |  |  | 0 | 0 | 223968.4 |  | 223968.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 223968.4
50510 | 2022-03-27 00:00:00 |  |  |  |  | 0 | 0 | 223968.4 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
50642 | 2022-03-31 00:00:00 |  |  |  |  | 0 | 0 | 2361.47 |  | 1836.66 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 524.76 | 262.38 | 262.38 | 262.38 | 262.38 | 262.38
50724 | 2022-03-28 00:00:00 |  |  |  |  | 0 | 0 | 1641.21 |  | 2461.81 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 410.3 | 410.3 | 410.3 | 410.3 | 410.3 | 410.31
51602 | 2022-03-18 00:00:00 |  |  |  |  | 0 | 0 | 141666.66 |  | 85000.02 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 28333.34 | 14166.67 | 14166.67 | 14166.67 | 14166.67
51909 | 2022-05-10 00:00:00 |  |  |  |  | 0 | 0 | -208501.32 |  | -208501.32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -208501.32
51910 | 2022-05-10 00:00:00 |  |  |  |  | 0 | 0 | -208501.32 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
51913 | 2022-05-10 00:00:00 |  |  |  |  | 0 | 0 | 208501.32 |  | 208501.32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 208501.32
51914 | 2022-05-10 00:00:00 |  |  |  |  | 0 | 0 | 208501.32 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
51928 | 2022-04-30 00:00:00 |  |  |  |  | 0 | 0 | 24046.26 |  | 24046.26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24046.26 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 1583.81 | 1245.05 | 4274.38 | 8907.150000000001 | 9517.79 | 10075.79 | 10490.71 | 18534.79 | 16920.38 | 101481.26 | 155080.35 | 55639.36 | 30573.9 | 30348.01 | 248686.98