Nested Select Query in SQL Server

Question

Hello everyone, I need assistance again in SQL Server. Please refer to my query and its output below:

 

 

Below also is the actual value of that table:

 

 

As you can see, there is a discrepancy in the previous day balance. Please help me to fix my query. Thank you so much.