Spreadsheet: 773837d1648062151-excel-formula-to-produce-monthly-bank-statement-bank
Sheet: Monthly Bank Ledger

I'm kindly asking for excel formula which can produce a monthly bank statement using data on bank statement worksheet as shown in the desired outcome.
Please not that on cell D4 there is a drop down list to choose the month.
 | BANK STATEMENT
 |  | Month | March | Drop down list
 | LEDGER
 | Date | Name | Reference | Debit | Credit | Balance |  |  |  |  | January
 | Balance B/d |  | bk |  |  | 39945.81999999999 |  |  |  |  | February
 | 2021-03-01 00:00:00 | ETHAN MUNGOZI | 14247 | 10000 | 0 | 49945.81999999999 |  |  |  |  | March
 | 2021-03-01 00:00:00 | 0 | 1a | 30000 | 0 | 79945.81999999998 |  |  |  |  | April
 | 2021-03-01 00:00:00 | 0 | 1 | 0 | 100 | 79845.81999999998 |  |  |  |  | May
 | 2021-03-01 00:00:00 | 0 | 2 | 0 | 2000 | 77845.81999999998 |  |  |  |  | June
 | 2021-03-02 00:00:00 | Suspense Account | 14248 | 4067.7 | 0 | 81913.51999999997 |  |  |  |  | July
 | 2021-03-02 00:00:00 | Suspense Account | 14249 | 10500 | 0 | 92413.51999999997 |  |  |  |  | August
 | 2021-03-03 00:00:00 | Suspense Account | 14250 | 10360 | 0 | 102773.52 |  |  |  |  | September
 | 2021-03-05 00:00:00 | 0 | 3 | 0 | 30 | 102743.52 |  |  |  |  | October
 | 2021-03-05 00:00:00 | 0 | 4 | 0 | 15.82 | 102727.7 |  |  |  |  | November
 | 2021-03-05 00:00:00 | 0 | 5 | 0 | 790.84 | 101936.86 |  |  |  |  | December
 | 2021-03-09 00:00:00 | [NAME] | 14251 | 10000 | 0 | 111936.86
 | 2021-03-10 00:00:00 | 0 | 2a | 29500 | 0 | 141436.86
 | 2021-03-11 00:00:00 | 0 | 3a | 6000 | 0 | 147436.86
 | 2021-03-11 00:00:00 | 0 | 6 | 0 | 20 | 147416.86
 | 2021-03-12 00:00:00 | 0 | 7 | 0 | 43.11 | 147373.75
 | 2021-03-12 00:00:00 | 0 | 8 | 0 | 86.21 | 147287.54
 | 2021-03-12 00:00:00 | 0 | 9 | 0 | 4310.68 | 142976.86
 | 2021-03-15 00:00:00 | 0 | 14252 | 14500 | 0 | 157476.86
 | 2021-03-15 00:00:00 | 0 | 14256 | 22600 | 0 | 180076.86
 | 2021-03-15 00:00:00 | 0 | 10 | 0 | 30 | 180046.86
 | 2021-03-15 00:00:00 | 0 | 11 | 0 | 30 | 180016.86
 | 2021-03-15 00:00:00 | 0 | 12 | 0 | 46.88 | 179969.98
 | 2021-03-15 00:00:00 | 0 | 13 | 0 | 191.36 | 179778.62
 | 2021-03-15 00:00:00 | 0 | 14 | 0 | 2880 | 176898.62
 | 2021-03-15 00:00:00 | 0 | 15 | 0 | 2000 | 174898.62
 | 2021-03-15 00:00:00 | 0 | 16 | 0 | 4687.76 | 170210.86
 | 2021-03-17 00:00:00 | 0 | 14254 | 50150 | 0 | 220360.86
 | 2021-03-19 00:00:00 | INKOSIPHILE TSHUMA | 14257 | 23375 | 0 | 243735.86
 | 2021-03-19 00:00:00 | 0 | 4a | 29500 | 0 | 273235.86
 | 2021-03-19 00:00:00 | 0 | 17 | 0 | 52.43 | 273183.43
 | 2021-03-19 00:00:00 | 0 | 18 | 0 | 30 | 273153.43
 | 2021-03-19 00:00:00 | 0 | 19 | 0 | 141.76 | 273011.67
 | 2021-03-19 00:00:00 | 0 | 20 | 0 | 5243.18 | 267768.49
 | 2021-03-19 00:00:00 | 0 | 21 | 0 | 1845.12 | 265923.37
 | 2021-03-22 00:00:00 | 0 | 5a | 10000 | 0 | 275923.37
 | 2021-03-22 00:00:00 | Suspense Account | 14258 | 27500 | 0 | 303423.37
 | 2021-03-23 00:00:00 | Suspense Account | 14259 | 15000 | 0 | 318423.37
 | 2021-03-23 00:00:00 | Suspense Account | 14260 | 5000 | 0 | 323423.37
 | 2021-03-23 00:00:00 | Suspense Account | 14261 | 23095.33 | 0 | 346518.7
 | 2021-03-24 00:00:00 | 0 | 6a | 77500 | 0 | 424018.7
 | 2021-03-24 00:00:00 | 0 | 22 | 0 | 400 | 423618.7
 | 2021-03-24 00:00:00 | 0 | 23 | 0 | 100 | 423518.7
 | 2021-03-24 00:00:00 | 0 | 24 | 0 | 20000 | 403518.7
 | 2021-03-25 00:00:00 | ETHAN MUNGOZI | 14262 | 15000 | 0 | 418518.7
 | 2021-03-25 00:00:00 | 0 | 7a | 101900 | 0 | 520418.7
 | 2021-03-25 00:00:00 | 0 | 25 | 0 | 159.24 | 520259.46
 | 2021-03-25 00:00:00 | 0 | 26 | 0 | 5146.94 | 515112.52
 | 2021-03-25 00:00:00 | 0 | 27 | 0 | 15924 | 499188.52
 | 2021-03-25 00:00:00 | 0 | 28 | 0 | 37800 | 461388.52
 | 2021-03-25 00:00:00 | 0 | 29 | 0 | 378 | 461010.52
 | 2021-03-25 00:00:00 | Net Salaries | 30 | 0 | 5543 | 455467.52
 | 2021-03-25 00:00:00 | 0 | 31 | 0 | 250 | 455217.52
 | 2021-03-25 00:00:00 | Net Salaries | 32 | 0 | 1500 | 453717.52
 | 2021-03-25 00:00:00 | 0 | 33 | 0 | 250 | 453467.52
 | 2021-03-25 00:00:00 | Net Salaries | 34 | 0 | 3050.05 | 450417.47
 | 2021-03-25 00:00:00 | 0 | 35 | 0 | 250 | 450167.47
 | 2021-03-25 00:00:00 | Net Salaries | 36 | 0 | 2450.9 | 447716.57
 | 2021-03-25 00:00:00 | 0 | 37 | 0 | 250 | 447466.57
 | 2021-03-25 00:00:00 | Net Salaries | 38 | 0 | 9330.4 | 438136.17
 | 2021-03-25 00:00:00 | 0 | 39 | 0 | 250 | 437886.17
 | 2021-03-25 00:00:00 | Net Salaries | 40 | 0 | 2195 | 435691.17
 | 2021-03-25 00:00:00 | 0 | 41 | 0 | 250 | 435441.17
 | 2021-03-25 00:00:00 | Net Salaries | 42 | 0 | 5328.32 | 430112.85
 | 2021-03-25 00:00:00 | 0 | 43 | 0 | 250 | 429862.85
 | 2021-03-25 00:00:00 | Net Salaries | 44 | 0 | 11094.4 | 418768.45
 | 2021-03-25 00:00:00 | 0 | 45 | 0 | 250 | 418518.45
 | 2021-03-25 00:00:00 | Net Salaries | 46 | 0 | 10406.74 | 408111.71
 | 2021-03-25 00:00:00 | 0 | 47 | 0 | 250 | 407861.71
 | 2021-03-25 00:00:00 | Net Salaries | 48 | 0 | 3394.05 | 404467.66
 | 2021-03-25 00:00:00 | 0 | 49 | 0 | 250 | 404217.66
 | 2021-03-25 00:00:00 | Net Salaries | 50 | 0 | 11015.28 | 393202.3799999999
 | 2021-03-25 00:00:00 | 0 | 51 | 0 | 250 | 392952.3799999999
 | 2021-03-25 00:00:00 | Net Salaries | 52 | 0 | 5862.21 | 387090.1699999999
 | 2021-03-25 00:00:00 | 0 | 53 | 0 | 250 | 386840.1699999999
 | 2021-03-25 00:00:00 | Net Salaries | 54 | 0 | 8851.26 | 377988.9099999999
 | 2021-03-25 00:00:00 | 0 | 55 | 0 | 250 | 377738.9099999999
 | 2021-03-25 00:00:00 | Net Salaries | 56 | 0 | 9840.68 | 367898.2299999999
 | 2021-03-25 00:00:00 | 0 | 57 | 0 | 250 | 367648.2299999999
 | 2021-03-25 00:00:00 | Net Salaries | 58 | 0 | 8576.61 | 359071.6199999999
 | 2021-03-25 00:00:00 | 0 | 59 | 0 | 250 | 358821.6199999999
 | 2021-03-25 00:00:00 | Net Salaries | 60 | 0 | 9723.04 | 349098.58
 | 2021-03-25 00:00:00 | 0 | 61 | 0 | 250 | 348848.58
 | 2021-03-25 00:00:00 | Net Salaries | 62 | 0 | 9231.65 | 339616.9299999999
 | 2021-03-25 00:00:00 | 0 | 63 | 0 | 250 | 339366.9299999999
 | 2021-03-25 00:00:00 | Net Salaries | 64 | 0 | 9272.56 | 330094.3699999999
 | 2021-03-25 00:00:00 | 0 | 65 | 0 | 250 | 329844.3699999999
 | 2021-03-25 00:00:00 | Net Salaries | 66 | 0 | 7840.89 | 322003.4799999999
 | 2021-03-25 00:00:00 | 0 | 67 | 0 | 250 | 321753.4799999999
 | 2021-03-25 00:00:00 | Net Salaries | 68 | 0 | 9222.56 | 312530.9199999999
 | 2021-03-25 00:00:00 | 0 | 69 | 0 | 250 | 312280.9199999999
 | 2021-03-25 00:00:00 | Net Salaries | 70 | 0 | 5754.39 | 306526.5299999999
 | 2021-03-25 00:00:00 | 0 | 71 | 0 | 250 | 306276.5299999999
 | 2021-03-25 00:00:00 | Net Salaries | 72 | 0 | 4042.65 | 302233.8799999999
 | 2021-03-25 00:00:00 | 0 | 73 | 0 | 250 | 301983.8799999999
 | 2021-03-25 00:00:00 | Net Salaries | 74 | 0 | 4567.17 | 297416.7099999999
 | 2021-03-25 00:00:00 | 0 | 75 | 0 | 250 | 297166.7099999999
 | 2021-03-25 00:00:00 | Net Salaries | 76 | 0 | 4366.95 | 292799.7599999999
 | 2021-03-25 00:00:00 | 0 | 77 | 0 | 250 | 292549.7599999999
 | 2021-03-25 00:00:00 | Net Salaries | 78 | 0 | 4359 | 288190.7599999999
 | 2021-03-25 00:00:00 | 0 | 79 | 0 | 250 | 287940.7599999999
 | 2021-03-25 00:00:00 | Net Salaries | 80 | 0 | 4888.65 | 283052.1099999999
 | 2021-03-25 00:00:00 | 0 | 81 | 0 | 250 | 282802.1099999999
 | 2021-03-25 00:00:00 | Net Salaries | 82 | 0 | 4549 | 278253.1099999999
 | 2021-03-25 00:00:00 | 0 | 83 | 0 | 250 | 278003.1099999999
 | 2021-03-25 00:00:00 | Net Salaries | 84 | 0 | 6482.99 | 271520.1199999999
 | 2021-03-25 00:00:00 | 0 | 85 | 0 | 250 | 271270.1199999999
 | 2021-03-25 00:00:00 | Net Salaries | 86 | 0 | 4043.16 | 267226.9599999999
 | 2021-03-25 00:00:00 | 0 | 87 | 0 | 250 | 266976.9599999999
 | 2021-03-25 00:00:00 | Net Salaries | 88 | 0 | 8971.64 | 258005.3199999999
 | 2021-03-25 00:00:00 | 0 | 89 | 0 | 250 | 257755.3199999999
 | 2021-03-25 00:00:00 | Net Salaries | 90 | 0 | 7868.45 | 249886.8699999999
 | 2021-03-25 00:00:00 | 0 | 91 | 0 | 250 | 249636.8699999999
 | 2021-03-26 00:00:00 | Suspense Account | 11399 | 1930 | 0 | 251566.8699999999
 | 2021-03-26 00:00:00 | Suspense Account | 14264 | 6469.69 | 0 | 258036.5599999999
 | 2021-03-26 00:00:00 | 0 | 8a | 56750 | 0 | 314786.5599999999
 | 2021-03-26 00:00:00 | 0 | 92 | 0 | 104.77 | 314681.7899999999
 | 2021-03-26 00:00:00 | 0 | 93 | 0 | 209.54 | 314472.2499999999
 | 2021-03-26 00:00:00 | 0 | 94 | 0 | 10476.75 | 303995.4999999999
 | 2021-03-27 00:00:00 | 0 | 9a | 43375 | 0 | 347370.4999999999
 | 2021-03-29 00:00:00 | Suspense Account | 14263 | 10000 | 0 | 357370.4999999999
 | 2021-03-29 00:00:00 | 0 | 12a | 83820 | 0 | 441190.4999999999
 | 2021-03-29 00:00:00 | 0 | 95 | 0 | 30 | 441160.4999999999
 | 2021-03-29 00:00:00 | 0 | 96 | 0 | 30 | 441130.4999999999
 | 2021-03-29 00:00:00 | 0 | 97 | 0 | 47.32 | 441083.1799999999
 | 2021-03-29 00:00:00 | 0 | 98 | 0 | 1440 | 439643.1799999999
 | 2021-03-29 00:00:00 | 0 | 99 | 0 | 926.1 | 438717.0799999999
 | 2021-03-30 00:00:00 | Suspense Account | 14265 | 5000 | 0 | 443717.0799999999
 | 2021-03-30 00:00:00 | Suspense Account | 14266 | 5000 | 0 | 448717.0799999999
 | 2021-03-30 00:00:00 | 0 | 10a | 123125 | 0 | 571842.0799999998
 | 2021-03-30 00:00:00 | 0 | 13a | 3580 | 0 | 575422.0799999998
 | 2021-03-30 00:00:00 | 0 | 100 | 0 | 1229.54 | 574192.5399999998
 | 2021-03-30 00:00:00 | 0 | 101 | 0 | 50 | 574142.5399999998
 | 2021-03-30 00:00:00 | 0 | 102 | 0 | 6933.64 | 567208.8999999998
 | 2021-03-30 00:00:00 | 0 | 103 | 0 | 50 | 567158.8999999998
 | 2021-03-30 00:00:00 | 0 | 104 | 0 | 5353.9 | 561804.9999999998
 | 2021-03-30 00:00:00 | 0 | 105 | 0 | 145.95 | 561659.0499999998
 | 2021-03-30 00:00:00 | 0 | 106 | 0 | 29189.27 | 532469.7799999998
 | 2021-03-30 00:00:00 | 0 | 107 | 0 | 100 | 532369.7799999998
 | 2021-03-30 00:00:00 | 0 | 108 | 0 | 20000 | 512369.7799999998
 | 2021-03-31 00:00:00 | 0 | 11a | 34075 | 0 | 546444.7799999998
 | 2021-03-31 00:00:00 | 0 | 109 | 0 | 50 | 546394.7799999998
 | 2021-03-31 00:00:00 | 0 | 110 | 0 | 30 | 546364.7799999998
 | 2021-03-31 00:00:00 | 0 | 111 | 0 | 38 | 546326.7799999998
 | 2021-03-31 00:00:00 | 0 | 112 | 0 | 30 | 546296.7799999998
 | 2021-03-31 00:00:00 | 0 | 113 | 0 | 5654.61 | 540642.1699999998
 | 2021-03-31 00:00:00 | 0 | 114 | 0 | 2000 | 538642.1699999998
 | 2021-03-31 00:00:00 | 0 | 115 | 0 | 525 | 538117.1699999998
 | 2021-03-31 00:00:00 | 0 | 116 | 0 | 3800 | 534317.1699999998
 | 2021-03-31 00:00:00 | 0 | 117 | 0 | 2500 | 531817.1699999998
 | 2021-03-31 00:00:00 | 0 | 118 | 0 | 18998.97 | 512818.1999999998
 | 2021-03-31 00:00:00 | 0 | 119 | 0 | 250 | 512568.1999999998
 | 2021-03-31 00:00:00 | Pension | 120 | 0 | 117019.1 | 395549.0999999999
 | 2021-03-31 00:00:00 | 0 | 121 | 0 | 1170.19 | 394378.9099999999
 | 2021-03-31 00:00:00 | 0 | 122 | 0 | 49371.31 | 345007.5999999999
 | 2021-03-31 00:00:00 | 0 | 123 | 0 | 493.71 | 344513.8899999998
 | 2021-03-31 00:00:00 | 0 | 124 | 0 | 1680 | 342833.8899999998
 | 2021-03-31 00:00:00 | 0 | 125 | 0 | 250 | 342583.8899999998
 | 2021-03-31 00:00:00 | 0 | 126 | 0 | 2250 | 340333.8899999998
 | 2021-03-31 00:00:00 | 0 | 127 | 0 | 250 | 340083.8899999998
 | 2021-03-31 00:00:00 | 0 | 128 | 0 | 16240.13 | 323843.7599999998
 | 2021-03-31 00:00:00 | 0 | 129 | 0 | 250 | 323593.7599999998
 | 2021-03-31 00:00:00 | 0 | 130 | 0 | 1680 | 321913.7599999998
 | 2021-03-31 00:00:00 | 0 | 131 | 0 | 250 | 321663.7599999998
 | 2021-03-31 00:00:00 | 0 | 132 | 0 | 13340 | 308323.7599999998
 | 2021-03-31 00:00:00 | 0 | 133 | 0 | 250 | 308073.7599999998
 | 2021-03-31 00:00:00 | [NAME] | 134 | 0 | 29174.87 | 278898.8899999998
 | 2021-03-31 00:00:00 | 0 | 135 | 0 | 291.75 | 278607.1399999998
 | 2021-03-31 00:00:00 | NSSA | 136 | 0 | 7933.64 | 270673.4999999998
 | 2021-03-31 00:00:00 | 0 | 137 | 0 | 250 | 270423.4999999998
 | 2021-03-31 00:00:00 | Trade Union | 138 | 0 | 180 | 270243.4999999998
 | 2021-03-31 00:00:00 | 0 | 139 | 0 | 250 | 269993.4999999998
 | 2021-03-31 00:00:00 | NEC | 140 | 0 | 16217.6 | 253775.8999999998
 | 2021-03-31 00:00:00 | 0 | 141 | 0 | 250 | 253525.8999999998
 | 2021-03-31 00:00:00 | Net Salaries | 142 | 0 | 2500 | 251025.8999999998
 | 2021-03-31 00:00:00 | 0 | 143 | 0 | 250 | 250775.8999999998