This Historic Invoice Report will provide a fairly detailed breakdown of the debtor and creditor control accounts at a particular point in time. It will include all invoices, balance of prepayments, journals and opening balances.
We may be able to achieve this in a slightly different way. One approach would be to include a separate box under the itemised section to list out any unspent prepayments, e.g. dates and amounts.