SQL Server 2019

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

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

Insert Into  your_table Values(3345312,'2022-08-07',100,50,null),
(5435245,'2022-08-06',50,50,null),
(4353451,'2022-08-05',0,100,null),
(5762454,'2022-08-04',20,100,null),
(7634523,'2022-08-03',400,100,null),
(5623456,'2022-08-02',100,20,null),
(4524354,'2022-08-01',0,0,null);
7 rows affected

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


Id
Date
IN
OUT
Balance


3345312
2022-08-07
100
50
250

5435245
2022-08-06
50
50
200

4353451
2022-08-05
0
100
200

5762454
2022-08-04
20
100
300

7634523
2022-08-03
400
100
380

5623456
2022-08-02
100
20
80

4524354
2022-08-01
0
0
0


Update your_table Set [in] = 100 Where [Date] = '2022-08-04';
Select Id, [Date], [IN], [OUT],
       SUM([IN] - [OUT]) Over (Order By [Date]) AS Balance
From your_table
Order By [Date] DESC;


Id
Date
IN
OUT
Balance


3345312
2022-08-07
100
50
330

5435245
2022-08-06
50
50
280

4353451
2022-08-05
0
100
280

5762454
2022-08-04
100
100
380

7634523
2022-08-03
400
100
380

5623456
2022-08-02
100
20
80

4524354
2022-08-01
0
0
0


With CTE AS 
(
    Select Id, Balance,
           SUM([IN] - [OUT]) Over (Order By [Date]) AS bl
    From your_table
) 
Update CTE Set Balance = bl;
Select * From your_table;


Id
Date
IN
OUT
Balance


3345312
2022-08-07
100
50
330

5435245
2022-08-06
50
50
280

4353451
2022-08-05
0
100
280

5762454
2022-08-04
100
100
380

7634523
2022-08-03
400
100
380

5623456
2022-08-02
100
20
80

4524354
2022-08-01
0
0
0

Id	Date	IN	OUT	Balance
3345312	2022-08-07	100	50	250
5435245	2022-08-06	50	50	200
4353451	2022-08-05	0	100	200
5762454	2022-08-04	20	100	300
7634523	2022-08-03	400	100	380
5623456	2022-08-02	100	20	80
4524354	2022-08-01	0	0	0