Help with formulas that will populate a "quick view" of household bills and payments.

I am needing help with setting up formulas for this bill sheet. I have "Monthly Charges" which don't change, and they populate to the main "housing" table. I also have the payment table set up, and that information populates to the main "housing" table also.-- I guess what I am needing is a way to show a "running balance owed" that does not include amounts for upcoming months, just the current month with a balance owed that includes any past due Months. Also is there a way that the payments table information could populate in the main housing table based on the date information that is inputed for the payment.

OMG! Thank you very much, my eyes were crossing trying to figure it out, but that works great!!