Below my Query is taking if some IDs are missing... 🙂

SELECT Accounts.ID, CONVERT(varchar(50),TransactionDate,101) AS TransactionDate, Balance,

( SELECT Sum( Balance )

FROM ( SELECT Top 5 A.Balance

FROM Accounts A

WHERE A.ID <= Accounts.ID

ORDER BY ID DESC

) AS A

) AS RunningTotal

FROM Accounts