Splitting a bank account

Hi. I have a savings account that i want to keep track of using Excel. Instead of doing multiple savings accounts I want to have just one savings account but use Excel to split it into 3-4 categories.

I am wondering is someone knows how to do this. Lets say i have $4000 in my savings account. I want to enter the amount in excel and split that into categories like Car fund, House Fund, and General Savings. I would like it to split it like 10% to Car Fund, 10% to House Fund, and 80% to General Savings.

I would also like to be able to input deposits and have it automatically split it up into the different categories. I would also like to be able to deposit into each separate category without it splitting between all of them.

I dont know enough about Excel to make this on my own but if it is possible to create it would be a great way for me to manage my savings account without having to open multiple savings accounts. Thank you.

Originally Posted by DonkeyOte

Perhaps something along the lines of the attached ?

DonkeyOte that is exactly what i was looking for. Thank you. Is there any way to also have the total of the entire account shown as well?


And thank you to everyone else for putting thought and time into my question. Id love to see some other ideas you guys have.