Because aid does not disburse until 2 weeks after the beginning of a term and months after initial invoicing, I have had to create a complicated tagging system in order to isolate students who should receive payment reminders (i.e. those students who will owe more than $250 AFTER aid is disbursed). Prior to every "Balance Due" email, I need to do the following (copied from my markdown SOP document):
-
Untag students who should no longer be tagged
- Go to the Balances Detail Report
- Load the filter Tagged and > $250
- Review each student
- Select "Untag" from the "Actions" dropdown and remove the "Exclude Payment Plan Email < 250" tag
- Go to the Balances Detail Report
-
Tag students who are not already tagged
- In the Balances Detail Report
- Load the filter No Tag < $250
- Select "Tag" from the "Actions" dropdown and add the "Exclude Payment Plan Email < 250" tag
- In the Balances Detail Report
After this, I can send emails to tagged students from the Data Slicer. It would be much smoother if I could instead pull all students whose Pay Now amount is greater than $250 from within the Data Slicer.
Alternatively, a "Balance after pending aid" field would avoid the risk of confusing results due to payment plan or invoice due dates.
I know it's a long request, so thanks for reading.