Can't help but give a quick plug here for our Finance Manager software.
Besides its tons of other benefits, it makes creating this report at any time a one-step (press print) process. Plus leaders (anyone with look-in permission) can view current financials at any time from any internet-connected computer.
You've got to sign up for the free trial. And if your treasurer's not using the system already, then you've got to set it up to kick into gear for your transition time.
Our treasurer hands out a treasury report at each meeting. It just notes from the beginning of the school year what we have taken in from each fundraiser and what we have spent on each event or item and what the current balance is.