Spreadsheet: 730558d1619767393-combining-revenue-and-expenses-to-construct-a-excel-bank-ledger-bank-account
Sheet: Bank Account

I'm kindly asking for the excel formula to produce the Bank Account
Desired outcome
Date | Description | Reference | Revenue | Expenses | Balance |  |  | Date | Description | Reference | Revenue | Expenses | Balance
2021-03-01 00:00:00 |  |  |  |  | 460 |  |  |  |  |  |  |  | 400
2021-03-01 00:00:00 | ELECTRICTY | 1 |  | 100
2021-03-01 00:00:00 | [NAME] | 14247 | 10000
2021-03-01 00:00:00 | RENTALS | 2 |  | 2000
2021-03-02 00:00:00 | YOUNG | 14248 | 10500
2021-03-02 00:00:00 | Suspense Account | 14249 | 4067.7
2021-03-02 00:00:00 | Suspense Account | 14250 | 30000
2021-03-03 00:00:00 | [NAME] | 14251 | 10360
2021-03-05 00:00:00 | SUNDRY | 3 |  | 30
2021-03-05 00:00:00 | SUNDRY | 4 |  | 15.82
2021-03-05 00:00:00 | Sundry | 5 |  | 790.84
2021-03-09 00:00:00 | [NAME] | 14252 | 10000
2021-03-11 00:00:00 | MARY | 14254 | 6000
2021-03-11 00:00:00 | RATES | 6 |  | 20
2021-03-11 00:00:00 | Suspense Account | 14259 | 29500
2021-03-12 00:00:00 | SUNDRY | 7 |  | 43.11
2021-03-12 00:00:00 | SUNDRY | 8 |  | 86.21
2021-03-12 00:00:00 | Sundry | 9 |  | 4310.68
2021-03-15 00:00:00 | SUNDRY | 10 |  | 30
2021-03-15 00:00:00 | REPAIRS | 11 |  | 30
2021-03-15 00:00:00 | CLEANING | 12 |  | 46.88
2021-03-15 00:00:00 | SUNDRY | 13 |  | 191.36
2021-03-15 00:00:00 | Sundry | 14 |  | 2880
2021-03-15 00:00:00 | Sundry | 15 |  | 2000
2021-03-15 00:00:00 | INTERNET | 16 |  | 4687.76
2021-03-15 00:00:00 | INKOSIPHILE TSHUMA | 14257 | 14500
2021-03-16 00:00:00 | Suspense Account | 14259 | 29500
2021-03-17 00:00:00 | Suspense Account | 14260 | 50150
2021-03-18 00:00:00 | Suspense Account | 14261 | 22600
2021-03-18 00:00:00 | ETHAN UNION | 14262 | 10000
2021-03-19 00:00:00 | SUNDRY | 17 |  | 52.43
2021-03-19 00:00:00 | SUNDRY | 18 |  | 30
2021-03-19 00:00:00 | SUNDRY | 19 |  | 141.76
2021-03-19 00:00:00 | Sundry | 20 |  | 5243.18
2021-03-19 00:00:00 | Sundry | 21 |  | 1845.12
2021-03-19 00:00:00 | Suspense Account | 11399 | 23375
2021-03-20 00:00:00 | Suspense Account | 14264 | 77500
2021-03-22 00:00:00 | Suspense Account | 14263 | 27500
2021-03-23 00:00:00 | Suspense Account | 14265 | 23095.33
2021-03-23 00:00:00 | Suspense Account | 14266 | 5000
2021-03-23 00:00:00 | TILDA | 100 | 15000
2021-03-23 00:00:00 | MERCY | 101 | 101900
2021-03-24 00:00:00 | TEAS | 22 |  | 400
2021-03-24 00:00:00 | SUNDRY | 23 |  | 100
2021-03-24 00:00:00 | Sundry | 24 |  | 20000
2021-03-24 00:00:00 | HARVEY | 102 | 56750
2021-03-25 00:00:00 | SUNDRY | 25 |  | 159.24
2021-03-25 00:00:00 | SUNDRY | 26 |  | 5146.94
2021-03-25 00:00:00 | OMEGA | 103 | 1930
2021-03-25 00:00:00 | BLESSING | 104 | 15000
2021-03-25 00:00:00 | Sundry | 27 |  | 15924
2021-03-25 00:00:00 | Sundry | 28 |  | 37800
2021-03-25 00:00:00 | SUNDRY | 29 |  | 378
2021-03-25 00:00:00 | Net Salaries | 30 |  | 5543
2021-03-25 00:00:00 | SUNDRY | 31 |  | 250
2021-03-25 00:00:00 | Net Salaries | 32 |  | 1500
2021-03-25 00:00:00 | SUNDRY | 33 |  | 250
2021-03-25 00:00:00 | Net Salaries | 34 |  | 3050.05
2021-03-25 00:00:00 | SUNDRY | 35 |  | 250
2021-03-25 00:00:00 | Net Salaries | 36 |  | 2450.9
2021-03-25 00:00:00 | SUNDRY | 37 |  | 250
2021-03-25 00:00:00 | Net Salaries | 38 |  | 9330.4
2021-03-25 00:00:00 | SUNDRY | 39 |  | 250
2021-03-25 00:00:00 | Net Salaries | 40 |  | 2195
2021-03-25 00:00:00 | SUNDRY | 41 |  | 250
2021-03-25 00:00:00 | Net Salaries | 42 |  | 5328.32
2021-03-25 00:00:00 | SUNDRY | 43 |  | 250
2021-03-25 00:00:00 | Net Salaries | 44 |  | 11094.4
2021-03-25 00:00:00 | SUNDRY | 45 |  | 250
2021-03-25 00:00:00 | Net Salaries | 46 |  | 10406.74
2021-03-25 00:00:00 | SUNDRY | 47 |  | 250
2021-03-25 00:00:00 | Net Salaries | 48 |  | 3394.05
2021-03-25 00:00:00 | SUNDRY | 49 |  | 250
2021-03-25 00:00:00 | Net Salaries | 50 |  | 11015.28
2021-03-25 00:00:00 | SUNDRY | 51 |  | 250
2021-03-25 00:00:00 | Net Salaries | 52 |  | 5862.21
2021-03-25 00:00:00 | SUNDRY | 53 |  | 250
2021-03-25 00:00:00 | Net Salaries | 54 |  | 8851.26
2021-03-25 00:00:00 | SUNDRY | 55 |  | 250
2021-03-25 00:00:00 | Net Salaries | 56 |  | 9840.68
2021-03-25 00:00:00 | SUNDRY | 57 |  | 250
2021-03-25 00:00:00 | Net Salaries | 58 |  | 8576.61
2021-03-25 00:00:00 | SUNDRY | 59 |  | 250
2021-03-25 00:00:00 | Net Salaries | 60 |  | 9723.04
2021-03-25 00:00:00 | SUNDRY | 61 |  | 250
2021-03-25 00:00:00 | Net Salaries | 62 |  | 9231.65
2021-03-25 00:00:00 | SUNDRY | 63 |  | 250
2021-03-25 00:00:00 | Net Salaries | 64 |  | 9272.56
2021-03-25 00:00:00 | SUNDRY | 65 |  | 250
2021-03-25 00:00:00 | Net Salaries | 66 |  | 7840.89
2021-03-25 00:00:00 | SUNDRY | 67 |  | 250
2021-03-25 00:00:00 | Net Salaries | 68 |  | 9222.56
2021-03-25 00:00:00 | SUNDRY | 69 |  | 250
2021-03-25 00:00:00 | Net Salaries | 70 |  | 5754.39
2021-03-25 00:00:00 | SUNDRY | 71 |  | 250
2021-03-25 00:00:00 | Net Salaries | 72 |  | 4042.65
2021-03-25 00:00:00 | SUNDRY | 73 |  | 250
2021-03-25 00:00:00 | Net Salaries | 74 |  | 4567.17
2021-03-25 00:00:00 | SUNDRY | 75 |  | 250
2021-03-25 00:00:00 | Net Salaries | 76 |  | 4366.95
2021-03-25 00:00:00 | SUNDRY | 77 |  | 250
2021-03-25 00:00:00 | Net Salaries | 78 |  | 4359
2021-03-25 00:00:00 | SUNDRY | 79 |  | 250
2021-03-25 00:00:00 | Net Salaries | 80 |  | 4888.65
2021-03-25 00:00:00 | SUNDRY | 81 |  | 250
2021-03-25 00:00:00 | Net Salaries | 82 |  | 4549
2021-03-25 00:00:00 | SUNDRY | 83 |  | 250
2021-03-25 00:00:00 | Net Salaries | 84 |  | 6482.99
2021-03-25 00:00:00 | SUNDRY | 85 |  | 250
2021-03-25 00:00:00 | Net Salaries | 86 |  | 4043.16
2021-03-25 00:00:00 | SUNDRY | 87 |  | 250
2021-03-25 00:00:00 | Net Salaries | 88 |  | 8971.64
2021-03-25 00:00:00 | SUNDRY | 89 |  | 250
2021-03-25 00:00:00 | Net Salaries | 90 |  | 7868.45
2021-03-25 00:00:00 | SUNDRY | 91 |  | 250
2021-03-25 00:00:00 | NIGEL | 105 | 43375
2021-03-26 00:00:00 | SUNDRY | 92 |  | 104.77
2021-03-26 00:00:00 | SUNDRY | 93 |  | 209.54
2021-03-26 00:00:00 | Sundry | 94 |  | 10476.75
2021-03-26 00:00:00 | 11252770 |  | 10000
2021-03-26 00:00:00 | HILDA | 107 | 123125
2021-03-27 00:00:00 | JOY | 108 | 6469.69
2021-03-27 00:00:00 | EVER | 109 | 34075
2021-03-29 00:00:00 | SUNDRY | 95 |  | 30
2021-03-29 00:00:00 | SUNDRY | 96 |  | 30
2021-03-29 00:00:00 | SUNDRY | 97 |  | 47.32
2021-03-29 00:00:00 | Sundry | 98 |  | 1440
2021-03-29 00:00:00 | Sundry | 99 |  | 926.1
2021-03-29 00:00:00 | ALEX | 110 | 5000
2021-03-30 00:00:00 | SUNDRY | 100 |  | 1229.54
2021-03-30 00:00:00 | Sundry | 101 |  | 50
2021-03-30 00:00:00 | SUNDRY | 102 |  | 6933.64
2021-03-30 00:00:00 | SUNDRY | 103 |  | 50
2021-03-30 00:00:00 | Sundry | 104 |  | 5353.9
2021-03-30 00:00:00 | SUNDRY | 105 |  | 145.95
2021-03-30 00:00:00 | Sundry | 106 |  | 29189.27
2021-03-30 00:00:00 | SUNDRY | 107 |  | 100
2021-03-30 00:00:00 | Sundry | 108 |  | 20000
2021-03-30 00:00:00 | Suspense Account | 14258 | 5000
2021-03-30 00:00:00 | TEBO | 12 | 83820
2021-03-31 00:00:00 | SUNDRY | 109 |  | 50
2021-03-31 00:00:00 | SUNDRY | 110 |  | 30
2021-03-31 00:00:00 | SUNDRY | 111 |  | 38
2021-03-31 00:00:00 | SUNDRY | 112 |  | 30
2021-03-31 00:00:00 | SUNDRY | 113 |  | 5654.61
2021-03-31 00:00:00 | Sundry | 114 |  | 2000
2021-03-31 00:00:00 | Sundry | 115 |  | 525
2021-03-31 00:00:00 | Sundry | 116 |  | 3800
2021-03-31 00:00:00 | Sundry | 117 |  | 2500
2021-03-31 00:00:00 | Sundry | 118 |  | 18998.97
2021-03-31 00:00:00 | Sundry | 119 |  | 250
2021-03-31 00:00:00 | Pension | 120 |  | 117019.1
2021-03-31 00:00:00 | SUNDRY | 121 |  | 1170.19
2021-03-31 00:00:00 | Sundry | 122 |  | 49371.31
2021-03-31 00:00:00 | Sundry | 123 |  | 493.71
2021-03-31 00:00:00 | Sundry | 124 |  | 1680
2021-03-31 00:00:00 | Sundry | 125 |  | 250
2021-03-31 00:00:00 | Sundry | 126 |  | 2250
2021-03-31 00:00:00 | Sundry | 127 |  | 250
2021-03-31 00:00:00 | Sundry | 128 |  | 16240.13
2021-03-31 00:00:00 | Sundry | 129 |  | 250
2021-03-31 00:00:00 | Sundry | 130 |  | 1680
2021-03-31 00:00:00 | Sundry | 131 |  | 250
2021-03-31 00:00:00 | Sundry | 132 |  | 13340
2021-03-31 00:00:00 | Sundry | 133 |  | 250
2021-03-31 00:00:00 | [NAME] | 134 |  | 29174.87
2021-03-31 00:00:00 | SUNDRY | 135 |  | 291.75
2021-03-31 00:00:00 | NSSA | 136 |  | 7933.64
2021-03-31 00:00:00 | SUNDRY | 137 |  | 250
2021-03-31 00:00:00 | Trade Union | 138 |  | 180
2021-03-31 00:00:00 | SUNDRY | 139 |  | 250
2021-03-31 00:00:00 | NEC | 140 |  | 16217.6
2021-03-31 00:00:00 | SUNDRY | 141 |  | 250
2021-03-31 00:00:00 | Net Salaries | 142 |  | 2500
2021-03-31 00:00:00 | Sundry | 143 |  | 250
2021-03-31 00:00:00 | TILDA | 13 | 3580