Help with spreadsheet to track membership dues...

Hello,

I have a martial arts school and need to track who has paid, when their monthly fee is due and who is late.

I would like the spreadsheet to automatically show who is late and who is current based on their assigned due date.

I attached what I have so far. Any help would be much appreciated to get me going in the right direction.

Thanks in advance!