Spreadsheet: 751300d1634036918-excel-formula-to-calculate-bank-balance-bank-balance
Sheet: Sheet2

Kindly asking for a excel formula used by the Bank to Calculate running balance. In my ledger in column E, I use this formula: Sum(E5,C6-D6).
However, I have a different balance from the bank despite having equal debits and credits.
LEDGER BANK STATEMENT |  |  |  |  |  |  | BANK STATEMENT
Date | Reference | Debit | Credit | Balance |  |  | Date | Reference | Debit | Credit | Balance
 | Opening Balance |  |  | 165135.46 |  |  |  | Opening Balance |  |  | 165135.46
2021-01-04 00:00:00 | 14179 | 20000 | 0 |  |  |  | 2021-01-04 00:00:00 | 1 | 5890 | 0 | 159245.46
2021-01-04 00:00:00 | 1 | 0 | 5890 |  |  |  | 2021-01-05 00:00:00 | 14179 | 0 | 20000 | 179245.46
2021-01-05 00:00:00 | 2 | 0 | 1400 |  |  |  | 2021-01-05 00:00:00 | 2 | 1400 | 0 | 177845.46
2021-01-05 00:00:00 | 3 | 0 | 1400 |  |  |  | 2021-01-05 00:00:00 | 3 | 1400 | 0 | 176445.46
2021-01-05 00:00:00 | 4 | 0 | 1400 |  |  |  | 2021-01-05 00:00:00 | 4 | 1400 | 0 | 175045.46
2021-01-05 00:00:00 | 5 | 0 | 1400 |  |  |  | 2021-01-05 00:00:00 | 5 | 1400 | 0 | 173645.46
2021-01-05 00:00:00 | 6 | 0 | 1400 |  |  |  | 2021-01-05 00:00:00 | 6 | 1400 | 0 | 172245.46
2021-01-05 00:00:00 | 7 | 0 | 1400 |  |  |  | 2021-01-05 00:00:00 | 7 | 1400 | 0 | 170845.46
2021-01-05 00:00:00 | 8 | 0 | 1400 |  |  |  | 2021-01-05 00:00:00 | 8 | 1400 | 0 | 169445.46
2021-01-05 00:00:00 | 9 | 0 | 1400 |  |  |  | 2021-01-05 00:00:00 | 9 | 1400 | 0 | 168045.46
2021-01-05 00:00:00 | 10 | 0 | 1400 |  |  |  | 2021-01-05 00:00:00 | 10 | 1400 | 0 | 166645.46
2021-01-05 00:00:00 | 11 | 0 | 1400 |  |  |  | 2021-01-05 00:00:00 | 11 | 1400 | 0 | 165245.46
2021-01-05 00:00:00 | 12 | 0 | 1400 |  |  |  | 2021-01-05 00:00:00 | 12 | 1400 | 0 | 163845.46
2021-01-05 00:00:00 | 13 | 0 | 1400 |  |  |  | 2021-01-05 00:00:00 | 13 | 1400 | 0 | 162445.46
2021-01-07 00:00:00 | 14 | 0 | 20000 |  |  |  | 2021-01-07 00:00:00 | 14 | 20000 | 0 | 142445.46
2021-01-09 00:00:00 | 15 | 0 | 1920 |  |  |  | 2021-01-09 00:00:00 | 15 | 1920 | 0 | 140525.46
2021-01-11 00:00:00 | 14230 | 11500 | 0 |  |  |  | 2021-01-11 00:00:00 | 14230 | 0 | 11500 | 152025.46
2021-01-13 00:00:00 | 14231 | 20000 | 0 |  |  |  | 2021-01-13 00:00:00 | 14231 | 0 | 20000 | 172025.46
2021-01-21 00:00:00 | 14232 | 2572 | 0 |  |  |  | 2021-01-21 00:00:00 | 14232 | 0 | 2572 | 174597.46
2021-01-26 00:00:00 | 16 | 0 | 6581 |  |  |  | 2021-01-26 00:00:00 | 16 | 6581 | 0 | 168016.46
2021-01-26 00:00:00 | 17 | 0 | 5793 |  |  |  | 2021-01-26 00:00:00 | 17 | 5793 | 0 | 162223.46
2021-01-26 00:00:00 | 18 | 0 | 4461 |  |  |  | 2021-01-26 00:00:00 | 18 | 4461 | 0 | 157762.46
2021-01-26 00:00:00 | 19 | 0 | 7913 |  |  |  | 2021-01-26 00:00:00 | 19 | 7913 | 0 | 149849.46
2021-01-26 00:00:00 | 20 | 0 | 4953 |  |  |  | 2021-01-26 00:00:00 | 20 | 4953 | 0 | 144896.46
2021-01-26 00:00:00 | 21 | 0 | 4043 |  |  |  | 2021-01-26 00:00:00 | 21 | 4043 | 0 | 140853.46
2021-01-26 00:00:00 | 22 | 0 | 4584 |  |  |  | 2021-01-26 00:00:00 | 22 | 4584 | 0 | 136269.46
2021-01-26 00:00:00 | 23 | 0 | 11043 |  |  |  | 2021-01-26 00:00:00 | 23 | 11043 | 0 | 125226.46
2021-01-26 00:00:00 | 24 | 0 | 3399 |  |  |  | 2021-01-26 00:00:00 | 24 | 3399 | 0 | 121827.46
2021-01-26 00:00:00 | 25 | 0 | 4580 |  |  |  | 2021-01-26 00:00:00 | 25 | 4580 | 0 | 117247.46
2021-01-26 00:00:00 | 26 | 0 | 11134 |  |  |  | 2021-01-26 00:00:00 | 26 | 11134 | 0 | 106113.46
2021-01-26 00:00:00 | 27 | 0 | 4107 |  |  |  | 2021-01-26 00:00:00 | 27 | 4107 | 0 | 102006.46
2021-01-26 00:00:00 | 28 | 0 | 4359 |  |  |  | 2021-01-26 00:00:00 | 28 | 4359 | 0 | 97647.45999999999
2021-01-26 00:00:00 | 29 | 0 | 7929 |  |  |  | 2021-01-26 00:00:00 | 29 | 7929 | 0 | 89718.45999999999
2021-01-26 00:00:00 | 30 | 0 | 10480 |  |  |  | 2021-01-26 00:00:00 | 30 | 10480 | 0 | 79238.45999999999
2021-01-26 00:00:00 | 31 | 0 | 9370 |  |  |  | 2021-01-26 00:00:00 | 31 | 9370 | 0 | 69868.45999999999
2021-01-26 00:00:00 | 32 | 0 | 9222 |  |  |  | 2021-01-26 00:00:00 | 32 | 9222 | 0 | 60646.45999999999
2021-01-26 00:00:00 | 33 | 0 | 5360 |  |  |  | 2021-01-26 00:00:00 | 33 | 5360 | 0 | 55286.45999999999
2021-01-26 00:00:00 | 34 | 0 | 2540 |  |  |  | 2021-01-26 00:00:00 | 34 | 2540 | 0 | 52746.45999999999
2021-01-26 00:00:00 | 35 | 0 | 5883 |  |  |  | 2021-01-26 00:00:00 | 35 | 5883 | 0 | 46863.45999999999
2021-01-26 00:00:00 | 36 | 0 | 8637 |  |  |  | 2021-01-26 00:00:00 | 36 | 8637 | 0 | 38226.45999999999
2021-01-26 00:00:00 | 37 | 0 | 9296 |  |  |  | 2021-01-26 00:00:00 | 37 | 9296 | 0 | 28930.45999999999
2021-01-26 00:00:00 | 38 | 0 | 9272 |  |  |  | 2021-01-26 00:00:00 | 38 | 9272 | 0 | 19658.45999999999
2021-01-26 00:00:00 | 39 | 0 | 2195 |  |  |  | 2021-01-26 00:00:00 | 39 | 2195 | 0 | 17463.45999999999
2021-01-26 00:00:00 | 40 | 0 | 4000 |  |  |  | 2021-01-26 00:00:00 | 40 | 4000 | 0 | 13463.45999999999
2021-01-26 00:00:00 | 41 | 0 | 528.54 |  |  |  | 2021-01-26 00:00:00 | 41 | 528.54 | 0 | 12934.91999999998
2021-01-28 00:00:00 | 14233 | 22572.9 | 0 |  |  |  | 2021-01-28 00:00:00 | 14233 | 0 | 22572.9 | 35435.82
2021-01-28 00:00:00 | 14234 | 5180 | 0 |  |  |  | 2021-01-28 00:00:00 | 14234 | 0 | 5180 | 40615.82
2021-01-29 00:00:00 | 14235 | 6567.7 | 0 |  |  |  | 2021-01-29 00:00:00 | 14235 | 0 | 6567.7 | 47183.52
2021-01-30 00:00:00 | 14236 | 5000 | 0 |  |  |  | 2021-01-30 00:00:00 | 14236 | 0 | 5000 | 52183.52
2021-01-31 00:00:00 | 42 | 0 | 21383.03 |  |  |  | 2021-01-31 00:00:00 | 42 | 21383.03 |  | 52183.52