Spreadsheet: 746583d1630869465-excel-formula-for-monthly-bank-statement-cum-bank
Sheet: Monthly Bank Statement

Kindly asking for a formula to produce a bank statement based on the month on cell B3 (Drop down list), using information on cumulative bank statement sheet
 | February
Date | Description | Reference | Debit | Credit | Balance |  |  | January
 |  |  |  |  | 30872.49 |  |  | February
2021-02-01 00:00:00 | SBPOS Commission | 1 | 2000 | 0 | 28872.49 |  |  | March
2021-02-02 00:00:00 | ZIPIT 477116 WBZ-[PHONE] | 14237 | 0 | 7000 | 35872.49 |  |  | April
2021-02-02 00:00:00 | 10719506 | 14238 | 0 | 9250 | 45122.49 |  |  | May
2021-02-03 00:00:00 | TABONGA PENYAI GR 2 KUDU | 14239 | 0 | 10000 | 55122.49 |  |  | June
2021-02-04 00:00:00 | USSD/ [NAME] | 14240 | 0 | 10000 | 65122.49 |  |  | July
2021-02-05 00:00:00 | pricingOnlineTranParticulars.scr | 2 | 250 | 0 | 64872.49 |  |  | August
2021-02-05 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 3 | 8851 | 0 | 56021.49 |  |  | September
2021-02-05 00:00:00 | pricingOnlineTranParticulars.scr | 4 | 250 | 0 | 55771.49 |  |  | October
2021-02-05 00:00:00 | EOL/RTGS BEAUTY GAVHURE SALARY | 5 | 6581 | 0 | 49190.49 |  |  | November
2021-02-05 00:00:00 | POS PURCHASE        POWER SHOP BULAWAYO PL BULAWA | 6 | 7104.5 | 0 | 42085.99 |  |  | December
2021-02-05 00:00:00 | IMTT | 7 | 450.73 | 0 | 41635.26
2021-02-05 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: Tran ID-S381291 | 8 | 71.05 | 0 | 41564.21
2021-02-08 00:00:00 | POS PURCHASE        ECONET ZITF STAND      BULAWA | 9 | 12491.64 | 0 | 29072.57
2021-02-08 00:00:00 | RTND RTGS CHARGES | 10 | 100 | 0 | 28972.57
2021-02-08 00:00:00 | IMTT | 11 | 249.83 | 0 | 28722.74
2021-02-08 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 12 | 124.92 | 0 | 28597.82
2021-02-09 00:00:00 | [NAME] [NAME] | 14241 | 0 | 6567.7 | 35165.52
2021-02-10 00:00:00 | 10796651 | 14242 | 0 | 27500 | 117665.52
2021-02-10 00:00:00 | 10796651 | 14242 | 0 | 27500 | 117665.52
2021-02-10 00:00:00 | 10796651 | 14242 | 0 | 27500 | 117665.52
2021-02-16 00:00:00 | pricingOnlineTranParticulars.scr | 13 | 250 | 0 | 117415.52
2021-02-16 00:00:00 | EOL/RTGS E LEARNING BUNDLE | 14 | 1400 | 0 | 116015.52
2021-02-16 00:00:00 | pricingOnlineTranParticulars.scr | 15 | 250 | 0 | 115765.52
2021-02-16 00:00:00 | EOL/RTGS E LEARNING BUNDLE | 16 | 1400 | 0 | 114365.52
2021-02-16 00:00:00 | pricingOnlineTranParticulars.scr | 17 | 250 | 0 | 114115.52
2021-02-16 00:00:00 | EOL/RTGS E LEARNING BUNDLE | 18 | 1400 | 0 | 112715.52
2021-02-16 00:00:00 | pricingOnlineTranParticulars.scr | 19 | 250 | 0 | 112465.52
2021-02-16 00:00:00 | EOL/RTGS E LEARNING BUNDLE | 20 | 1400 | 0 | 111065.52
2021-02-16 00:00:00 | pricingOnlineTranParticulars.scr | 21 | 250 | 0 | 110815.52
2021-02-16 00:00:00 | EOL/RTGS E LEARNING BUNDLE | 22 | 1400 | 0 | 109415.52
2021-02-16 00:00:00 | pricingOnlineTranParticulars.scr | 23 | 250 | 0 | 109165.52
2021-02-16 00:00:00 | EOL/RTGS E LEARNING BUNDLE | 24 | 1400 | 0 | 107765.52
2021-02-16 00:00:00 | pricingOnlineTranParticulars.scr | 25 | 250 | 0 | 107515.52
2021-02-16 00:00:00 | EOL/RTGS E LEARNING BUNDLE | 26 | 1400 | 0 | 106115.52
2021-02-16 00:00:00 | pricingOnlineTranParticulars.scr | 27 | 250 | 0 | 105865.52
2021-02-16 00:00:00 | pricingOnlineTranParticulars.scr | 28 | 250 | 0 | 105615.52
2021-02-16 00:00:00 | EOL/RTGS E LEARNING BUNDLE | 29 | 1400 | 0 | 104215.52
2021-02-16 00:00:00 | EOL/RTGS E LEARNING BUNDLE | 30 | 1400 | 0 | 102815.52
2021-02-16 00:00:00 | pricingOnlineTranParticulars.scr | 31 | 250 | 0 | 102565.52
2021-02-16 00:00:00 | EOL/RTGS E LEARNING BUNDLE | 32 | 1400 | 0 | 101165.52
2021-02-16 00:00:00 | pricingOnlineTranParticulars.scr | 33 | 250 | 0 | 100915.52
2021-02-16 00:00:00 | EOL/RTGS E LEARNING BUNDLE | 34 | 1400 | 0 | 99515.52
2021-02-16 00:00:00 | pricingOnlineTranParticulars.scr | 35 | 250 | 0 | 99265.52
2021-02-16 00:00:00 | EOL/RTGS E LEARNING BUNDLE | 36 | 1400 | 0 | 97865.52
2021-02-16 00:00:00 | pricingOnlineTranParticulars.scr | 37 | 250 | 0 | 97615.52
2021-02-16 00:00:00 | EOL/RTGS E LEARNING BUNDLE | 38 | 1400 | 0 | 96215.52
2021-02-16 00:00:00 | pricingOnlineTranParticulars.scr | 39 | 250 | 0 | 95965.52
2021-02-16 00:00:00 | EOL/RTGS E LEARNING BUNDLE | 40 | 274 | 0 | 95691.52
2021-02-16 00:00:00 | pricingOnlineTranParticulars.scr | 41 | 250 | 0 | 95441.52
2021-02-16 00:00:00 | EOL/RTGS E LEARNING BUNDLE | 42 | 274 | 0 | 95167.52
2021-02-16 00:00:00 | IMTT | 43 | 364 | 0 | 94803.52
2021-02-17 00:00:00 | USSD/FEES [NAME] | 14244 | 0 | 27500 | 122303.52
2021-02-18 00:00:00 | POS PURCHASE        ELECTROSALES FIFE ST   BULAWA | 44 | 1619.55 | 0 | 120683.97
2021-02-18 00:00:00 | IMTT | 45 | 32.39 | 0 | 120651.58
2021-02-18 00:00:00 | FEE - ZIMSWITCH POS PURCHASE: [NAME] | 46 | 30 | 0 | 120621.58
2021-02-19 00:00:00 | ZIPIT 606827 645FBTC210500513 | 14245 | 0 | 7500 | 128121.58
2021-02-24 00:00:00 | 000002188 RIVERSIDE STIMULATIO | Swipe | 0 | 36750 | 164871.58
2021-02-24 00:00:00 | 10921184 | 14246 | 0 | 12000 | 176871.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 47 | 250 | 0 | 176621.58
2021-02-26 00:00:00 | EOL/RTGS VEHICLE USAGE NOV TO FEB | 48 | 4000 | 0 | 172621.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 49 | 250 | 0 | 172371.58
2021-02-26 00:00:00 | EOL/RTGS MATHE | 50 | 2195 | 0 | 170176.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 51 | 250 | 0 | 169926.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 52 | 2043 | 0 | 167883.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 53 | 250 | 0 | 167633.58
2021-02-26 00:00:00 | EOL/RTGS BEAUTY GAVHURE | 54 | 4081 | 0 | 163552.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 55 | 250 | 0 | 163302.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 56 | 5035 | 0 | 158267.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 57 | 250 | 0 | 158017.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 58 | 5851 | 0 | 152166.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 59 | 250 | 0 | 151916.58
2021-02-26 00:00:00 | EOL/RTGS SALARY JULY | 60 | 1500 | 0 | 150416.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 61 | 250 | 0 | 150166.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 62 | 5172 | 0 | 144994.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 63 | 250 | 0 | 144744.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 64 | 5096 | 0 | 139648.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 65 | 250 | 0 | 139398.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 66 | 5637 | 0 | 133761.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 67 | 250 | 0 | 133511.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 68 | 5360 | 0 | 128151.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 69 | 250 | 0 | 127901.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 70 | 5883 | 0 | 122018.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 71 | 250 | 0 | 121768.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 72 | 5370 | 0 | 116398.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 73 | 250 | 0 | 116148.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 74 | 5000 | 0 | 111148.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 75 | 250 | 0 | 110898.58
2021-02-26 00:00:00 | EOL/RTGS BUSI JUN SALARY | 76 | 5134 | 0 | 105764.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 77 | 250 | 0 | 105514.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 78 | 10460 | 0 | 95054.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 79 | 250 | 0 | 94804.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 80 | 4858 | 0 | 89946.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 81 | 250 | 0 | 89696.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 82 | 1607 | 0 | 88089.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 83 | 250 | 0 | 87839.58
2021-02-26 00:00:00 | EOL/RTGS BLESSING TAGAR JUN SALARY | 84 | 4816 | 0 | 83023.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 85 | 250 | 0 | 82773.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 86 | 4681 | 0 | 78092.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 87 | 250 | 0 | 77842.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 88 | 5134 | 0 | 72708.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 89 | 250 | 0 | 72458.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 90 | 899 | 0 | 71559.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 91 | 250 | 0 | 71309.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 92 | 4560 | 0 | 66749.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 93 | 250 | 0 | 66499.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 94 | 1543 | 0 | 64956.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 95 | 250 | 0 | 64706.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 96 | 1818 | 0 | 62888.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 97 | 250 | 0 | 62638.58
2021-02-26 00:00:00 | EOL/RTGS JULIET RWAFA SALARY | 98 | 2453 | 0 | 60185.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 99 | 250 | 0 | 59935.58
2021-02-26 00:00:00 | EOL/RTGS February SALARY | 100 | 3286 | 0 | 56649.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 101 | 250 | 0 | 56399.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 102 | 4422 | 0 | 51977.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 103 | 250 | 0 | 51727.58
2021-02-26 00:00:00 | EOL/RTGS RIVERSIDE SALARY | 104 | 1668 | 0 | 50059.58
2021-02-26 00:00:00 | pricingOnlineTranParticulars.scr | 105 | 250 | 0 | 49809.58
2021-02-26 00:00:00 | EOL/RTGS FEBRUARY | 106 | 4826 | 0 | 44983.58
2021-02-26 00:00:00 | IMTT | 107 | 2487.76 | 0 | 42495.82
2021-02-28 00:00:00 | MONTHLY MANAGEMENT FEE | 108 | 2500 | 0 | 39995.82
2021-02-28 00:00:00 | DEBIT CARD MNGMNT FEE | 109 | 50 | 0 | 39945.82