Highlight and Calculate overdue balances, including part paid

I need to highlight and calculate overdue payments from invoices. This is a small charity that issues invoices for things like a wedding party where they pay an initial deposit but the balance may not be due for some months when the wedding is due. currently I have columns for, invoice date, due date, amounts paid and balance remaining. Any suggestions, as I have not been able to work out a formula. Thanks