Similar to UXPROD-2023, but this is an aggregate instead of line items.
For every owning library, patron type, and fine type, calculate: total $ assessed, total $ paid, total $ forgiven, remaining balance. Filter by date range, include date range as column in table.
What is the correct date to use for the filter? The date the fee account was created? The date of last activity on this account? Maybe use date_created from feesfines_account by default.
How to calculate remaining balance? One option is "remaining" from accounts, but is that really the latest balance or just the result of one transaction? Is it overwritten each time (correctly)? Another option is to tally up payments and waives (and refunds??) and use that to calculate remaining?