I run a private bussiness where have various ways of getting income and I have costs.
I created an excel sheet to show how my profit would be. But then I stumble into some stuff:
I have 2 accounts, a checking account and a savings account. What I do is have all my profit (or loss) go to my checking account, then if my checking´s account is over 200 I transfer 80% to my savings account. I also have a 0,5% margin on my savings account.
My problems come when I have losses. I want excel to automaticly from my accounts in the following order: 1st checking account, 2nd savings account, 3rd credit card (which will show as a deficit on the next month)
I try doing it with IF´s but I get lost as the formula gets to big and its more easy to make errors. Is there a simpler way to do this?
Thank you for the help in advance.
Bookmarks