Suggestions for Reporting On Outstanding Gift Certificates?

Hi all!

I'm looking to add a widget to a dashboard that pulls outstanding/unused gift certificate totals. We'd like to get a better idea of how our COVID cancellations are tracking in terms of how many returns are being made to gift certificates for patrons' future use. However, I can't simply track return transaction types with gift certificate payment methods because our ticket office has been occasionally refunding to gift certificate for immediate use when a patron calls and wants their refund credited toward next season's order. Is it possible to limit this to just unused gift certificates?

Thanks!

Lauren