Looking for the right formula for my household cash flow sheet

[DavisGuy83]

Hello:

New to the forum, but not to Excel. Ha! I mostly use Excel these days to run what basically is a cash flow sheet/budget to keep tracks of money in and money out. When I make reference to a specific account (credit card or savings account) in the cash flow I want to be able to see it affect the balance in a different column. I'm pasting a workbook below to try and illustrate what I'm talking about, but like if I come up short on bills one week and say I put a cell indicating I am moving $500 from savings, I want to see next to that week's finances what my savings balance is and have that populate all future savings balances with any future change. So if there is $5,000 in the savings account and I move $500 for bills, I want to just input Savings in my description column on my cash flow columns, then "$500" (as a positive number) in my amount column then in the column next it I want to see "Savings" in a 'description' column and then "$4,500" in the amount column next to it. And then I want it to connect it with the next weeks data and the next week and so on so that if I got like a bonus at work and instead of needing to barrow the $500 from savings that one week I change the number to "-$1,500" (Because I would have increased the income on that week by $1,500 and then moving money to savings is a negative budget item on my cash flow instead of a positive one when I'm bringing cash in) and all of the savings balances change to "$6,500" until the next time on the clash flow sheet the word "savings" appears. So the "Savings" column should have $6,500 as the value after it until the next time "savings" appears in the cash flow. So let's say then 2 weeks later in my data I show adding "$2,000" to my savings all future values next to savings should show "$8,500" after the savings column. But then if I go back and change that "$1,500" to "$1,000" then the savings balance 2 weeks later should be showing "$8,000" not "$8,500". Kind of complicated, but any help would be appreciated!

[JohnTopley]

Examplw

For Savings, try

=$E$1+ABS(SUMIFS($C$1:$C13,$B$1:B13,"Savings",$C$1:C13,"<0"))-SUMIFS($C$1:$C13,$B$1:B13,"Savings",$C$1:C13,">0")

where $E$1 is the opening balance of your savings