Pre Pay SKUs, reporting, and cancellations

A couple questions. We recently ran our monthly club processing and accidentally posted two different club runs to one set of members. We’ve gone through and cancelled everything out, but canceling an order does not refund a pre-paid shipment. So the questions:

  • Is there an existing report that I can run that shows me all club members on prepayment as of a certain date? I didn’t see one.
  • Is there any other way to credit back pre pay shipments manually? The only thing I know to do is basically “sell” them a $0 pre pay SKU to make up for the one that was lost.