track where the balance is coming from

[BORUCH]

hi all i have the below table

AM Balance Order Jul.08.24 (Part 3).xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	ITEM #	AM SNACKS	ORIGINAL BALANCE DATE	ORIGINAL BALANCE	ORDER DATE	QTY ORDERED	BALANCE	RECEIVED DATE	INVOICE #	QTY RECEIVED	BALANCE	RECEIVED DATE	INVOICE #	QTY RECEIVED	BALANCE
2	00001	apples	9/6/2023	8	11/2/2023	75	83	11/19/2023	9999	10	73	11/30/2023	123	50	23
3	00002	oranges	9/6/2023	-34	11/2/2023	500	466	11/19/2023	8888	400	66	11/30/2023	456	60	6
Sheet1

Cell Formulas
Range	Formula
G2:G3	G2	=D2+F2
K2:K3,O2:O3	K2	=G2-J2

i would like an excel formula on another sheet for each item to track the balance by date

 

[Alex Blakenburg]

Thanks for the feedback. Glad we were able to help.