ID	Transaction ID	Date	Balance
1	22	10-10-2018	99
1	23	11-10-2018	0
1	24	02-11-2018	198
1	25	13-12-2018	50
2	3	08-11-2018	99
2	4	15-11-2018	0
3	66	29-10-2018	500
3	67	31-10-2018	100
3	68	11-11-2018	200
3	69	01-12-2018	150
3	70	04-12-2018	250
3	71	07-12-2018	50
4	13	26-11-2018	500
4	14	28-11-2018	300
4	15	29-11-2018	400

----------------

Result	
	
Balance for Oct-18	
ID	Balance
1	0
2	0
3	100
4	0
	
Balance for Nov-18	
ID	Balance
1	198
2	0
3	200
4	400
	
Balance for Dec-18	
ID	Balance
1	50
2	0
3	50
4	0