Hello, I am looking for someone to form a color coded newt organized excel for my student organization which I am in. I am the treasurer and an trying to build a spread sheet to keep track of our budget and balance. All I am looking for is an excel which have 7 columns. The 7 columns are splint i to kind of 2 portions. 4 columns which pertain to a date entry, expense or income (each separate columns) and balance in the 4th column.
For this section I do not want to have to manually input the date every time. I want to input either my income or expense and have it auto populate the current date and then express this +\- difference in the balance column.
The second part in more of a monthly statement. I want the excel to be able to go through and read when a new month has came and input the month which had past, the end month balance, as well as a value + or - of how the balance had changed from the previous month.
I will not be inputing values daily or even monthly sometimes so i need the excel to be able to read the date it is even if the last entry was months ago. I also would like the monthly statement to populate balances for months which had no income or expense.
Attached is a rough draft of what I am looking for in the excel