Gannt Chart With Dynamic Income/Expenses Per Task
I am a contractor and I have all of my draw payments tied to tasks (ex. beginning of drywall) and all my subcontractor payments also tied to tasks (ex. beginning of framing). I'm trying to use my project Gannt to also track my cash flow. I've done this in Excel; however, it was VERY complicated and kept breaking. My thoughts:
-Build my project schedule in a Gannt chart
-Input all of my income and expenses and tie them dynamically to the corresponding task (I had to do this in a separate table above or below the Gannt which mad it more difficult)
-At the bottom, have a calculation showing me the total cash balance for that week, based on (income that week) - (expenses that week) + (the cash balance the previous week).
Here's the part I can't figure out. How do I associate the transaction with the task dates? Ex. if drywall is late by three weeks, I move the schedule forward three weeks and the income from that ALSO moves forward three weeks.