How to automate cash flow chart for invoices

Hello. I have a tab with invoices.

Column B has total invoice amount
Column C has deposit amount
Column D has deposit date = if there is a deposit date due date, that means the deposit has not been paid (it is owed)
Column F has remaining balance
Column G has remaining balance due date.

How can I get the values associated with the months to sum up on a calendar with a month in each column? I want to take the $s owed so I can see when they come each month. There might be a pivot way to do this as well? Thanks!!