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.