Reporting on gift certificate redemption in scheduling

Site URL: http://www.wellroomva.com

I sell gift certificates through the scheduling portion of squarespace.  These certificates are redeemed for various services: customers book appointments for a service through squarespace and use some (or all) of a certificate for the appointment.

I have not found a straight-forward way to report on the redemption of gift certificates, so I understand how much is outstanding, what amounts have been redeemed for the various services I offer, or which certificates have an outstanding balance so I can communicate with the customer to encourage their patronage.

Ultimately I need to be able to migrate the amounts used from the gift certificate liability account to revenues in my accounting software and I don't want to wade through all the transactions to find the redemptions.

Anyone able to provide some guidance? Thanks!