SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Create Table  your_table(Pid int, Id INT, Date [DATE], [IN] INT, [OUT] INT, Balance  Int);

Insert Into  your_table Values
(1,3345312,'2022-08-07',100,50,null),
(1,5435245,'2022-08-06',50,50,null),
(1,4353451,'2022-08-05',0,100,null),
(1,5762454,'2022-08-04',20,100,null),
(1,7634523,'2022-08-03',400,100,null),
(1,5623456,'2022-08-02',100,20,null),
(1,4524354,'2022-08-01',0,0,null),
  
(2,1234567,'2022-08-07',20,10,null),
(2,1234568,'2022-08-06',5,5,null),
(2,1234569,'2022-08-05',0,30,null),
(2,1234570,'2022-08-04',10,20,null),
(2,1234571,'2022-08-03',200,50,null),
(2,1234572,'2022-08-02',50,20,null),
(2,1234573,'2022-08-01',0,0,null);
14 rows affected

Select Pid, Id, [Date], [IN], [OUT],
       SUM([IN] - [OUT]) Over (Partition By Pid Order By [Date]) AS Balance
From your_table
Order By Pid, [Date] DESC;


Pid
Id
Date
IN
OUT
Balance


1
3345312
2022-08-07
100
50
250

1
5435245
2022-08-06
50
50
200

1
4353451
2022-08-05
0
100
200

1
5762454
2022-08-04
20
100
300

1
7634523
2022-08-03
400
100
380

1
5623456
2022-08-02
100
20
80

1
4524354
2022-08-01
0
0
0

2
1234567
2022-08-07
20
10
150

2
1234568
2022-08-06
5
5
140

2
1234569
2022-08-05
0
30
140

2
1234570
2022-08-04
10
20
170

2
1234571
2022-08-03
200
50
180

2
1234572
2022-08-02
50
20
30

2
1234573
2022-08-01
0
0
0


Update your_table Set [in] = 100 Where [Date] = '2022-08-04' And Pid = 1;

With CTE AS 
(
    Select Pid, Id, Balance, Date, [IN] ,[OUT],
           SUM([IN] - [OUT]) Over (Partition By Pid Order By [Date]) AS bl
    From your_table
) 
Update CTE Set Balance = bl Where [Date] >= '2022-08-04' And Pid = 1;-- Remove this condition to update all rows
Select * From your_table order by pid, date desc;


Pid
Id
Date
IN
OUT
Balance


1
3345312
2022-08-07
100
50
330

1
5435245
2022-08-06
50
50
280

1
4353451
2022-08-05
0
100
280

1
5762454
2022-08-04
100
100
380

1
7634523
2022-08-03
400
100
null

1
5623456
2022-08-02
100
20
null

1
4524354
2022-08-01
0
0
null

2
1234567
2022-08-07
20
10
null

2
1234568
2022-08-06
5
5
null

2
1234569
2022-08-05
0
30
null

2
1234570
2022-08-04
10
20
null

2
1234571
2022-08-03
200
50
null

2
1234572
2022-08-02
50
20
null

2
1234573
2022-08-01
0
0
null

Pid	Id	Date	IN	OUT	Balance
1	3345312	2022-08-07	100	50	250
1	5435245	2022-08-06	50	50	200
1	4353451	2022-08-05	0	100	200
1	5762454	2022-08-04	20	100	300
1	7634523	2022-08-03	400	100	380
1	5623456	2022-08-02	100	20	80
1	4524354	2022-08-01	0	0	0
2	1234567	2022-08-07	20	10	150
2	1234568	2022-08-06	5	5	140
2	1234569	2022-08-05	0	30	140
2	1234570	2022-08-04	10	20	170
2	1234571	2022-08-03	200	50	180
2	1234572	2022-08-02	50	20	30
2	1234573	2022-08-01	0	0	0