0

Add "Pay Now" or "Balance after Pending Aid" fields to the Data Slicer

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
  • 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

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.

0 comments

Please sign in to leave a comment.