Spreadsheet: 854686d1704465925-offset-values-and-identify-leftover-balance-cells-book2
Sheet: Master

Ref No |  |  | Client Name | Address | Date | Amount |  |  | Cumulative Sum
1 |  |  | ABC1 | ABC1 | 2022-04-01 00:00:00 | 42121
2 |  |  | ABC1 | ABC1 | 2022-04-01 00:00:00 | 1745737
3 |  |  | ABC1 | ABC1 | 2022-04-01 00:00:00 | 39374
4 |  |  | ABC1 | ABC1 | 2022-04-02 00:00:00 | 34692
5 |  |  | ABC1 | ABC1 | 2022-04-08 00:00:00 | 41663
6 |  |  | ABC1 | ABC1 | 2022-04-08 00:00:00 | 38459
7 |  |  | ABC1 | ABC1 | 2022-04-13 00:00:00 | 34692
8 |  |  | ABC1 | ABC1 | 2022-04-13 00:00:00 | 41206
1 |  |  | ABC | XYZ | 2022-04-14 00:00:00 | 370
2 |  |  | ABC | XYZ | 2022-04-15 00:00:00 | 650
9 |  |  | ABC1 | ABC1 | 2022-04-15 00:00:00 | 33970
10 |  |  | ABC1 | ABC1 | 2022-04-18 00:00:00 | 41663
11 |  |  | ABC1 | ABC1 | 2022-04-20 00:00:00 | -289351
12 |  |  | ABC1 | ABC1 | 2022-04-22 00:00:00 | 39832
13 |  |  | ABC1 | ABC1 | 2022-04-22 00:00:00 | 34692
14 |  |  | ABC1 | ABC1 | 2022-04-26 00:00:00 | 41663
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
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
3 |  |  | ABC | XYZ | 2022-05-19 00:00:00 | 1357
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
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
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
4 |  |  | ABC | XYZ | 2022-06-29 00:00:00 | 708
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
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
5 |  |  | ABC | XYZ | 2022-08-18 00:00:00 | 4200
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
60 |  |  | ABC1 | ABC1 | 2022-08-31 00:00:00 | 38515
61 |  |  | ABC1 | ABC1 | 2022-08-31 00:00:00 | 32025
6 |  |  | ABC | XYZ | 2022-09-15 00:00:00 | 1003
7 |  |  | ABC | XYZ | 2022-09-27 00:00:00 | 885
62 |  |  | ABC1 | ABC1 | 2022-10-07 00:00:00 | 34305
8 |  |  | ABC | XYZ | 2022-11-07 00:00:00 | 7080
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
9 |  |  | ABC | XYZ | 2022-11-25 00:00:00 | 944
68 |  |  | ABC1 | ABC1 | 2022-11-28 00:00:00 | -300000
10 |  |  | ABC | XYZ | 2022-12-07 00:00:00 | -17197
69 |  |  | ABC1 | ABC1 | 2022-12-13 00:00:00 | -200000
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
11 |  |  | ABC | XYZ | 2023-01-10 00:00:00 | 708
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
12 |  |  | ABC | XYZ | 2023-02-04 00:00:00 | 550
78 |  |  | ABC1 | ABC1 | 2023-02-08 00:00:00 | 37828
79 |  |  | ABC1 | ABC1 | 2023-02-10 00:00:00 | -200000
80 |  |  | ABC1 | ABC1 | 2023-02-11 00:00:00 | 2117
13 |  |  | ABC | XYZ | 2023-02-13 00:00:00 | 490
81 |  |  | ABC1 | ABC1 | 2023-02-16 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
14 |  |  | ABC | XYZ | 2023-03-15 00:00:00 | 1003
15 |  |  | ABC | XYZ | 2023-03-15 00:00:00 | -1
85 |  |  | ABC1 | ABC1 | 2023-03-15 00:00:00 | -200000
86 |  |  | ABC1 | ABC1 | 2023-03-25 00:00:00 | -96260
81 |  |  | ABC1 | ABC1 | 2023-03-26 00:00:00 | 27048