Weekly Planned Vs. Actual Cash Flow

Hello Everyone,

Based on the annexed format is it possible to prepare the Weekly Planned, Actual Cash Flow & Variance with the four different bank accounts we have and we also want to track the cash flow on weekly basis with all the different bank. Here i have prepared the format but if i will continue with the same for one week i will have to create 4 different week then the total of the week and for a month i will have to create 20 columns, which will make the report very lengthy. So guys do you have any idea or formula to make it shorten and sweet by look wise.


Thanks & Regards,


Neilesh