FQM-Lists app: Fees/Fines

https://folio-org.atlassian.net/browse/UXPROD-4850

Lists app/FQM > Fees/Fines use cases

1. At the end of each semester, we need to get a list of all students who own more than $20 in fines to block them in Banner. I need to be able to limit the search by date (last semester only), by user type (students only) and by feeFineType (Late fee manual charge, Overdue and Manual fines). Also I need to be able to group the fines by user as some patrons could have more than one fine each less than $20.

Fields to display: User.first_name, user.last_name, user.user_name, user.barcode, user.external_id, account.metadata.createDate, account.amount, account.balance, account.status, account.feeFineType, account.paymentStatus, account.feeFineOwner

Queryable fields: feeFineType, remaining, metadata.createdDate, user.patronGroup.name, paymentStatus

2. As someone that manages exports to the bursar system i need to see all fee/fines that were sent to a specific transfer account for a given time period.

Fields to display: User.first_name, user.last_name, user.user_name, user.barcode, user.external_id, account.metadata.createDate, account.amount, account.balance, account.status, account.feeFineType, account.paymentStatus, account.feeFineOwner, account.barcode, account.title, account.callNumber, account.location

Queryable fields: paymentStatus, metadata.createdDate, feeFineActions.typeAction, feeFineActions.paymentMethod

Join:

• feeFineActions.accountId to accounts.id

Please add use cases below this point.

Queryable fields, and Fields to display and Joins can be ignored. Please just provide a brief example of what you would like to query.

3. Closer to the end of every semester I run a list of all items that are still not returned from the previous semester. So in April 2026, my Loans query will look like:

   (item_status == "Aged to lost") AND (loan_status == "Open") AND (loan_due_date >= "2025-08-19") AND (loan_due_date <= "2025-12-16")

   I get the list of not returned items but I don’t know what it means fiscally. We use actual costs, so it would be useful if there was a way to tally the actual costs of those Aged to Lost items.
   
   

4. At the end of each semester, we look over the list of graduating students and check if any have outstanding fees in one of our departments. A quick way to create and compile that list would be helpful.

   1. A query that allows for user lists to search by Fees/Fines would be very helpful, as the app currently cannot do that to my knowledge.

5. I would like to find out how much in overdue, replacement, manual fines/fees was paid last semester at each of our campuses. And how much was waived.
   
   

6. I would like to create a list of all users whose total fees are less than 10 euros and who are at least 8 weeks old. Ideally, I could also limit this list to users who are not blocked.
   Then I will block the users manually. This way, long-term non-payers can be blocked.

7. We would like to create a list of non-student users who have any fees/fines. We would like to filter by fee/fine type and time-range and have customer user fields to narrow the list to our own campus users.

8. We would like to create a list of users who have fines (greater than or equal to a certain amount) who are associated with a particular campus. We are a consortium that shares a single FOLIO tenant. We identify a user’s campus by using a multi-select custom user field in the user record.

9. We need to be able to run a list of students who have items that are outstanding:

10. I need a list of all patrons that have unpaid fines or fees of any kind, so we can follow up with them. For the list export, it would be helpful to have:

    1. user first and last name

    2. user email

    3. user phone number

    4. user primary address

    5. user barcode

    6. fee amount

    7. fee reason

    8. date fee was created

    9. item title, author, barcode, UUID/HRID, due date and status

11. Being able to target that list more would also be helpful

    1. List of all patrons who have aged-to-lost fines incurred during the last fiscal year, how much the fines are for, and the items they’re associated with.

    2. List all patrons with aged-to-lost fines incurred over the past month.

12. I use the Lists app extensively for billing purposes. I manually add student holds to Banner both regularly throughout the semester and extensively at the end of the semester. Although I've worked out a method using loan due dates in a range and item's status as aged to lost, this method is imperfect and likely doesn't capture all fee/fines/manual charges. 

    Also, it would be extremely helpful for billing purposes to be able to look back at older fines, as well as to find fines by amount. For example, I could find all the students who have been billed for laptops (a specific amount different from other fees). 

13. I transfer outstanding fines to Banner once a week. Because our Financial Operations requires documentation of the fines, I have to transfer them manually. It would be nice to be able to run a list of all open fines. I mostly just need the total amount owed and the Patron’s Barcode.

14. It would be helpful for us to have the following two functions:

    1. A list of our users who have any fines at any given time

    2. A list of our users who have paid on fines within a certain time frame (within the last two years)

15. Last night, one of our circulation staff encountered a blocked patron account while checking out a charger. The patron had a large overdue fee from his previous charger loan. We overrode the block, but I immediately wanted to go look at all patrons with fees/fines, so I could see which ones could be waived and which need to be billed. There is currently no way to run a list of all fees/fines owed or a list of all blocked patrons. If there is list functionality for fees/fines, our use case would be to export a table of the amount owed, patron name (and other identifiers), patron status, patron blocks, items/loans associated with the fee/fine, item status (like available or lost), and check out/in date.

16. On the first and third Monday of every month, I run a check over who has any fines of $.01 in order to delete fines or determine whether they need to be put on our fines interface and a notice placed on their FOLIO account

17. “We would use the data to look up patron information. After reviewing the account, we would then decide whether to forgive the offense or escalate to our business office. This is also our best opportunity to see if the item is missing and if we can recover it.

    Most of our fines involve overdue laptops which are in high demand so ensuring we can get those into the next set of hands is a high priority.”

    Also, would it be possible to add a list for items “sent to billing” so they won’t show up on future reports? And then if an item is returned it populates a new list so that items returned after marked as lost so we can credit the student back their replacement fee?

18. We would like being able to create a list of patrons with

    1. open fee/fines that sit on their account longer than x days/months/years

    2. closed fee/fines that sit on their account longer than x days/months/years

19. We would like to create a list of patrons with fees/fines ocurring connected to open loans

20. Reminder fees: We would like to create a list of patrons with reminder fees on a certain sequence of the reminder fees scheme.
    For example a list of all users with reminder fees on sequence 2

21. We would like to create a list of patrons with a certain amount of open fees/fines on their account who are already blocked.