Would it be possible to create a sheet that gives you details on what transfers to set up in your bank account to automate budgeting?
So I get paid twice a month, and my wife gets paid twice a month into our INCOME account. I then have automated transfers set up to transfer money to my BILLS, LONG TERM BILLS & a couple of other accounts.
Is it possible to make it so that the sheet analyses the incoming & outgoing from the accounts and create a list of transfers needed in order to have the right amount of money in each account?
INCOME: Paid $3800 on the 1st
BILLS: -$2000 of bills between 1st & 15th (second payday)
Recommended Transfer: INCOME TO BILLS $2000 on the 2nd
I have multiple accounts set up for specific tasks: No account fees on each account
INCOME: Any income received
BILLS: All my monthly bills
LT BILLS: Any bill that is paid quarterly or annually etc.
Annual Amount / 26, and then I transfer this over every payday, so that there is money there for those bills
SAVINGS: General Savings account.
So I am just after a way to in a sense automate a lot of the process.