seriousdamage
Board Regular
- Joined
- Aug 14, 2005
- Messages
- 58
Hello All,
I am trying to organize data from a small balance sheet into various virtual accounts.
I have 4 accounts where I like to split the income, each account has a purpose.
Please see image attached.
The idea is that I have a sheet where I record all transactions for money coming in and out (Column B to E)
Each transaction will only have 2 categories, "IN" and "OUT"
The plan is if I add a transaction with the category "IN" than I like to split the amount for that transaction into the for accounts based on the 4 different % that you can see in columns H,
the more I add this category and the amounts should keep summing up
If I add a category "OUT" than the amount in column E should be subtracted from Account 4 in cell J7
Lastly, the idea is that C2 should always be equal to J2, if it's not then I know I made a mistake somewhere.
Could someone help me?
Thanks so much
Regards
Nic
I am trying to organize data from a small balance sheet into various virtual accounts.
I have 4 accounts where I like to split the income, each account has a purpose.
Please see image attached.
The idea is that I have a sheet where I record all transactions for money coming in and out (Column B to E)
Each transaction will only have 2 categories, "IN" and "OUT"
The plan is if I add a transaction with the category "IN" than I like to split the amount for that transaction into the for accounts based on the 4 different % that you can see in columns H,
the more I add this category and the amounts should keep summing up
If I add a category "OUT" than the amount in column E should be subtracted from Account 4 in cell J7
Lastly, the idea is that C2 should always be equal to J2, if it's not then I know I made a mistake somewhere.
Could someone help me?
Thanks so much
Regards
Nic