Have a report that shows realtime balance from current semester after next semester is billed

We have a lot of students on payment plans and they are paying on their account right up until the semester ends. This means that they register and are billed for the following semester while they still have a balance from the current semester. I'd like to request a report that will allow me to see what students' realtime balances are for the current semester even after we've billed them for the next semester. Currently, I can only pull up a report with students' overall balances (for both semesters) or run a report with an as of date before they were billed for the next semester but it won't include payments made beyond that date. Thank you!