report on balance due on a certain date

Our kids make competition fee payments throughout the year, although some pay in full.

I need a report on who just owes their October competition fees. It seems I can only get balance totals