Spreadsheet: 680950d1591276512-if-currency-is-x-and-due-day-is-1-return-day-as-2-excelf-sample
Sheet: Future-Current Month

 | Due | Future
 | Payment Date Fiter | June-20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8-10
 |  | Column Labels
 |  | AED |  | AUD |  | CHF |  | DKK |  | EUR |  | GBP |  | SEK |  | USD |  | MYR |  | [NAME] |  | HKD |  | Total Sum of Amount in doc. curr. | Total Sum of Field2
 | Row Labels | Sum of Amount in doc. curr. | Sum of Field2 | Sum of Amount in doc. curr. | Sum of Field2 | Sum of Amount in doc. curr. | Sum of Field2 | Sum of Amount in doc. curr. | Sum of Field2 | Sum of Amount in doc. curr. | Sum of Field2 | Sum of Amount in doc. curr. | Sum of Field2 | Sum of Amount in doc. curr. | Sum of Field2 | Sum of Amount in doc. curr. | Sum of Field2 | Sum of Amount in doc. curr. | Sum of Field2 | Sum of Amount in doc. curr. | Sum of Field2 | Sum of Amount in doc. curr. | Sum of Field2
 | 2020-06-05 00:00:00 |  | 0 | -4516.87 | 4.51687 |  | 0 |  | 0 | -36449.86 | 36.44986 | -14799.96 | 14.79996 |  | 0 |  | 0 |  | 0 |  | 0 | -96536 | 96.536 | -152302.69 | 152.30269
 | 2020-06-08 00:00:00 |  | 0 |  | 0 |  | 0 |  | 0 | -2040716.719999999 | 2040.716719999999 | -1713.3 | 1.7133 | -319400 | 319.4 | -23015.55 | 23.01555 |  | 0 |  | 0 |  | 0 | -2384845.569999998 | 2384.845569999999
 | 2020-06-09 00:00:00 | -51026.85 | 51.02685 | -11797.5 | 11.7975 |  | 0 |  | 0 | -2400886.85 | 2400.88685 | -4.44 | 0.00444 |  | 0 | -67496 | 67.496 |  | 0 |  | 0 |  | 0 | -2531211.64 | 2531.21164
 | 2020-06-10 00:00:00 |  | 0 | -12446.5 | 12.4465 | -15899.75 | 15.89975 |  | 0 | -1772656.55 | 1772.656549999999 | -55264.62 | 55.26461999999999 |  | 0 | -49736 | 49.736 | -4457.4 | 4.4574 |  | 0 |  | 0 | -1910460.819999999 | 1910.46082
 | 2020-06-11 00:00:00 | -32980.5 | 32.9805 | -11286.44 | 11.28644 |  | 0 |  | 0 | -1075538.93 | 1075.53893 | -18891.06 | 18.89106 |  | 0 | -13005 | 13.005 |  | 0 |  | 0 |  | 0 | -1151701.93 | 1151.70193
 | 2020-06-12 00:00:00 | -36330 | 36.33 | -23721.77 | 23.72177 |  | 0 |  | 0 | -2001137.63 | 2001.13763 | -34352.82 | 34.35282 | -52659.46 | 52.65946 | -46132.5 | 46.1325 |  | 0 | -4170650 | 4170.65 |  | 0 | -6364984.18 | 6364.98418
 | 2020-06-15 00:00:00 | -28620 | 28.62 | -43209.37 | 43.20937 |  | 0 |  | 0 | -932188.3299999998 | 932.1883299999998 | -4889.68 | 4.88968 |  | 0 | -40801.23 | 40.80123 |  | 0 |  | 0 |  | 0 | -1049708.61 | 1049.70861
 | 2020-06-16 00:00:00 | -38325 | 38.325 | -12925 | 12.925 | -38858.16 | 38.85816000000001 |  | 0 | -1262347.16 | 1262.34716 | -24799.8 | 24.7998 | -68400 | 68.4 | -32112 | 32.112 |  | 0 |  | 0 |  | 0 | -1477767.12 | 1477.76712
 | 2020-06-17 00:00:00 | -26266.8 | 26.2668 |  | 0 |  | 0 |  | 0 | -1187292.54 | 1187.29254 | -17521.39 | 17.52139 |  | 0 | -81919.15 | 81.91914999999999 | -50607.9 | 50.6079 |  | 0 |  | 0 | -1363607.78 | 1363.60778
 | 2020-06-18 00:00:00 | -98648.38 | 98.64838 | -17435.66 | 17.43566 |  | 0 |  | 0 | -418421.33 | 418.42133 | -22760 | 22.76 |  | 0 | -18032 | 18.032 |  | 0 |  | 0 |  | 0 | -575297.37 | 575.2973700000001
 | 2020-06-19 00:00:00 |  | 0 | -22484 | 22.484 |  | 0 |  | 0 | -509770.72 | 509.77072 | -47888.87 | 47.88887 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | -580143.59 | 580.1435900000001
 | 2020-06-22 00:00:00 |  | 0 | -19717.55 | 19.71755 | -1606.61 | 1.60661 |  | 0 | -752519.5399999999 | 752.5195399999999 | -10578 | 10.578 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | -784421.7 | 784.4216999999999
 | 2020-06-23 00:00:00 |  | 0 | -7700 | 7.7 |  | 0 |  | 0 | -570419.99 | 570.41999 | -27927.72 | 27.92772 |  | 0 | -4508 | 4.508 |  | 0 |  | 0 |  | 0 | -610555.71 | 610.5557100000001
 | 2020-06-24 00:00:00 |  | 0 | -6325 | 6.325 |  | 0 |  | 0 | -796624.2600000001 | 796.6242600000002 | -5088.84 | 5.08884 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | -808038.1000000001 | 808.0381000000001
 | 2020-06-25 00:00:00 |  | 0 | -4290 | 4.29 |  | 0 |  | 0 | -997184.1499999999 | 997.1841499999999 | -9449.4 | 9.449399999999999 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | -1010923.55 | 1010.92355
 | 2020-06-26 00:00:00 |  | 0 | -20240.93 | 20.24093 | -23952.48 | 23.95248 | -108680 | 108.68 | -4866112.680000001 | 4866.11268 | -60098.82 | 60.09882 | -259200 | 259.2 | -16548 | 16.548 |  | 0 |  | 0 |  | 0 | -5354832.910000001 | 5354.83291
 | 2020-06-29 00:00:00 |  | 0 | -26911.28 | 26.91128 |  | 0 |  | 0 | -1521688.64 | 1521.68864 | -16781.78 | 16.78178 | -819490 | 819.49 | -1803.2 | 1.8032 |  | 0 |  | 0 |  | 0 | -2386674.9 | 2386.674900000001
 | 2020-06-30 00:00:00 |  | 0 |  | 0 | -4200 | 4.2 |  | 0 | -6402902.690000001 | 6402.902690000002 | -26586.84 | 26.58684 | -206721 | 206.721 | -21760 | 21.76 |  | 0 |  | 0 |  | 0 | -6662170.530000001 | 6662.170530000001
 | Grand Total | -312197.53 | 312.19753 | -245007.87 | 245.00787 | -84517 | 84.517 | -108680 | 108.68 | -29544858.57 | 29544.85856999998 | -399397.3400000001 | 399.3973400000001 | -1725870.46 | 1725.87046 | -416868.6299999999 | 416.8686300000001 | -55065.3 | 55.0653 | -4170650 | 4170.65 | -96536 | 96.536 | -37159648.7 | 37159.64870000001