Spreadsheet: 854654d1704453593-offset-values-and-identify-leftover-balance-cells-book2
Sheet: Master

Ref No |  |  | Client Name | Address | Date | Amount |  |  | Cumulative Sum
1 |  |  | ABC | XYZ | 2022-04-14 00:00:00 | 370
1 |  |  | ABC1 | ABC1 | 2022-04-01 00:00:00 | 42121
10 |  |  | ABC | XYZ | 2022-12-07 00:00:00 | -17197
10 |  |  | ABC1 | ABC1 | 2022-04-18 00:00:00 | 41663
11 |  |  | ABC1 | ABC1 | 2022-04-20 00:00:00 | -289351
11 |  |  | ABC | XYZ | 2023-01-10 00:00:00 | 708
12 |  |  | ABC | XYZ | 2023-02-04 00:00:00 | 550
12 |  |  | ABC1 | ABC1 | 2022-04-22 00:00:00 | 39832
13 |  |  | ABC | XYZ | 2023-02-13 00:00:00 | 490
13 |  |  | ABC1 | ABC1 | 2022-04-22 00:00:00 | 34692
14 |  |  | ABC | XYZ | 2023-03-15 00:00:00 | 1003
14 |  |  | ABC1 | ABC1 | 2022-04-26 00:00:00 | 41663
15 |  |  | ABC | XYZ | 2023-03-15 00:00:00 | -1
15 |  |  | ABC1 | ABC1 | 2022-04-29 00:00:00 | 35319
16 |  |  | ABC1 | ABC1 | 2022-04-29 00:00:00 | 41663
17 |  |  | ABC1 | ABC1 | 2022-05-03 00:00:00 | 38447
18 |  |  | ABC1 | ABC1 | 2022-05-07 00:00:00 | 34593
19 |  |  | ABC1 | ABC1 | 2022-05-07 00:00:00 | 23705
2 |  |  | ABC | XYZ | 2022-04-15 00:00:00 | 650
2 |  |  | ABC1 | ABC1 | 2022-04-01 00:00:00 | 1745737
20 |  |  | ABC1 | ABC1 | 2022-05-09 00:00:00 | 21334
21 |  |  | ABC1 | ABC1 | 2022-05-11 00:00:00 | 24585
22 |  |  | ABC1 | ABC1 | 2022-05-13 00:00:00 | 37476
23 |  |  | ABC1 | ABC1 | 2022-05-17 00:00:00 | 35918
24 |  |  | ABC1 | ABC1 | 2022-05-17 00:00:00 | 32352
25 |  |  | ABC1 | ABC1 | 2022-05-18 00:00:00 | 23548
26 |  |  | ABC1 | ABC1 | 2022-05-21 00:00:00 | 34379
27 |  |  | ABC1 | ABC1 | 2022-05-23 00:00:00 | -400000
28 |  |  | ABC1 | ABC1 | 2022-05-23 00:00:00 | 35871
29 |  |  | ABC1 | ABC1 | 2022-05-25 00:00:00 | 37476
3 |  |  | ABC | XYZ | 2022-05-19 00:00:00 | 1357
3 |  |  | ABC1 | ABC1 | 2022-04-01 00:00:00 | 39374
30 |  |  | ABC1 | ABC1 | 2022-05-30 00:00:00 | 38195
31 |  |  | ABC1 | ABC1 | 2022-06-01 00:00:00 | 30810
32 |  |  | ABC1 | ABC1 | 2022-06-05 00:00:00 | 30367
33 |  |  | ABC1 | ABC1 | 2022-06-05 00:00:00 | 36628
34 |  |  | ABC1 | ABC1 | 2022-06-06 00:00:00 | 28888
35 |  |  | ABC1 | ABC1 | 2022-06-08 00:00:00 | 39108
36 |  |  | ABC1 | ABC1 | 2022-06-10 00:00:00 | 33778
37 |  |  | ABC1 | ABC1 | 2022-06-10 00:00:00 | 37476
38 |  |  | ABC1 | ABC1 | 2022-06-11 00:00:00 | 26987
39 |  |  | ABC1 | ABC1 | 2022-06-15 00:00:00 | 35025
4 |  |  | ABC | XYZ | 2022-06-29 00:00:00 | 708
4 |  |  | ABC1 | ABC1 | 2022-04-02 00:00:00 | 34692
40 |  |  | ABC1 | ABC1 | 2022-06-18 00:00:00 | 37623
41 |  |  | ABC1 | ABC1 | 2022-06-21 00:00:00 | 37253
42 |  |  | ABC1 | ABC1 | 2022-06-21 00:00:00 | 38687
43 |  |  | ABC1 | ABC1 | 2022-06-28 00:00:00 | 36209
44 |  |  | ABC1 | ABC1 | 2022-06-28 00:00:00 | 39169
45 |  |  | ABC1 | ABC1 | 2022-06-29 00:00:00 | 27447
46 |  |  | ABC1 | ABC1 | 2022-07-03 00:00:00 | 32380
47 |  |  | ABC1 | ABC1 | 2022-07-06 00:00:00 | 37666
48 |  |  | ABC1 | ABC1 | 2022-07-06 00:00:00 | 19802
49 |  |  | ABC1 | ABC1 | 2022-07-16 00:00:00 | 9487
5 |  |  | ABC | XYZ | 2022-08-18 00:00:00 | 4200
5 |  |  | ABC1 | ABC1 | 2022-04-08 00:00:00 | 41663
50 |  |  | ABC1 | ABC1 | 2022-07-16 00:00:00 | -379739
51 |  |  | ABC1 | ABC1 | 2022-07-22 00:00:00 | 18783
52 |  |  | ABC1 | ABC1 | 2022-07-25 00:00:00 | 34088
53 |  |  | ABC1 | ABC1 | 2022-07-29 00:00:00 | 33559
54 |  |  | ABC1 | ABC1 | 2022-08-01 00:00:00 | 30027
55 |  |  | ABC1 | ABC1 | 2022-08-10 00:00:00 | 18526
56 |  |  | ABC1 | ABC1 | 2022-08-16 00:00:00 | 14573
57 |  |  | ABC1 | ABC1 | 2022-08-21 00:00:00 | 26269
58 |  |  | ABC1 | ABC1 | 2022-08-21 00:00:00 | 11560
59 |  |  | ABC1 | ABC1 | 2022-08-29 00:00:00 | 3705
6 |  |  | ABC | XYZ | 2022-09-15 00:00:00 | 1003
6 |  |  | ABC1 | ABC1 | 2022-04-08 00:00:00 | 38459
60 |  |  | ABC1 | ABC1 | 2022-08-31 00:00:00 | 38515
61 |  |  | ABC1 | ABC1 | 2022-08-31 00:00:00 | 32025
62 |  |  | ABC1 | ABC1 | 2022-10-07 00:00:00 | 34305
63 |  |  | ABC1 | ABC1 | 2022-11-19 00:00:00 | 33382
64 |  |  | ABC1 | ABC1 | 2022-11-20 00:00:00 | 30373
65 |  |  | ABC1 | ABC1 | 2022-11-20 00:00:00 | 31331
66 |  |  | ABC1 | ABC1 | 2022-11-21 00:00:00 | 16842
67 |  |  | ABC1 | ABC1 | 2022-11-25 00:00:00 | 4446
68 |  |  | ABC1 | ABC1 | 2022-11-28 00:00:00 | -300000
69 |  |  | ABC1 | ABC1 | 2022-12-13 00:00:00 | -200000
7 |  |  | ABC | XYZ | 2022-09-27 00:00:00 | 885
7 |  |  | ABC1 | ABC1 | 2022-04-13 00:00:00 | 34692
70 |  |  | ABC1 | ABC1 | 2022-12-20 00:00:00 | -200000
71 |  |  | ABC1 | ABC1 | 2022-12-28 00:00:00 | -200000
72 |  |  | ABC1 | ABC1 | 2022-12-31 00:00:00 | 27048
73 |  |  | ABC1 | ABC1 | 2022-12-31 00:00:00 | -150000
74 |  |  | ABC1 | ABC1 | 2023-01-10 00:00:00 | -200000
75 |  |  | ABC1 | ABC1 | 2023-01-20 00:00:00 | -200000
76 |  |  | ABC1 | ABC1 | 2023-01-21 00:00:00 | -116374
77 |  |  | ABC1 | ABC1 | 2023-01-29 00:00:00 | -200000
78 |  |  | ABC1 | ABC1 | 2023-02-08 00:00:00 | 37828
79 |  |  | ABC1 | ABC1 | 2023-02-10 00:00:00 | -200000
8 |  |  | ABC | XYZ | 2022-11-07 00:00:00 | 7080
8 |  |  | ABC1 | ABC1 | 2022-04-13 00:00:00 | 41206
80 |  |  | ABC1 | ABC1 | 2023-02-11 00:00:00 | 2117
81 |  |  | ABC1 | ABC1 | 2023-02-16 00:00:00 | -27048
81 |  |  | ABC1 | ABC1 | 2023-03-26 00:00:00 | 27048
82 |  |  | ABC1 | ABC1 | 2023-02-20 00:00:00 | -200000
83 |  |  | ABC1 | ABC1 | 2023-02-27 00:00:00 | -200000
84 |  |  | ABC1 | ABC1 | 2023-03-14 00:00:00 | -39945
85 |  |  | ABC1 | ABC1 | 2023-03-15 00:00:00 | -200000
86 |  |  | ABC1 | ABC1 | 2023-03-25 00:00:00 | -96260
9 |  |  | ABC | XYZ | 2022-11-25 00:00:00 | 944
9 |  |  | ABC1 | ABC1 | 2022-04-15 00:00:00 | 33970