The suggested logic will determine if all bank accounts are reconciled or alternatively using the same logic as the monthly unreconciled.

We sum less than the current date (i.e. First of the month) and raise the alert for any Asset accounts that do not balance for the previous month.