All templates

Automated Tuition Payment Reminders

Every Monday, WebRun opens Blackbaud Tuition Management, finds family accounts past due, captures the balance and how late each is, logs them to a sheet, and drafts a polite reminder per family in Gmail, left unsent for your business office to review and send.

Runs on WebRun · Strict Lockdown policy
Every Monday at 9:00 AM WebRunorchestrates each step
1 Blackbaud find past-due accounts
2 Google Sheets log balances owed
3 Gmail draft polite reminders
In short

How do I send tuition payment reminders to families automatically?

Every Monday, WebRun opens Blackbaud Tuition Management, finds family accounts with a past-due balance, and captures the amount and days overdue. It logs them to a Google Sheet ranked by urgency and drafts a polite reminder per family in Gmail, left unsent for your business office to review and send.

  • Past-due families are nudged weekly, not just at term end
  • Every reminder is drafted and waits for the office to approve
  • Paid families drop off the list automatically each run

Built for school administrators · business office staff · private school bursars · finance coordinators

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens www.blackbaud.com/solutions/financial-management/tuition-management in a real browser with your saved login - no setup, no API keys.

  2. 1
    Blackbaud - find past-due accounts
    blackbaud.com
    WebRun in Blackbaud: find past-due accounts
    WebRun reads past-due tuition balances in Blackbaud Tuition Management.
    • Open Blackbaud Tuition Management and go to the accounts receivable view
    • Find family accounts with a past-due balance and read the amount and due date
    • Capture how many days each account is overdue and the contact on file

    Done when Every past-due family account is listed with its balance and days overdue.

  3. 2
    Google Sheets - log balances owed
    google.com
    WebRun in Google Sheets: log balances owed
    WebRun records each past-due balance in a ranked sheet.
    • Log each family with the balance owed, days overdue, and contact
    • Sort so the oldest and largest balances sit at the top
    • Skip any family already reminded this cycle to avoid double nudges

    Done when The sheet ranks every past-due family by how late and how large the balance is.

  4. 3
    Gmail - draft polite reminders
    gmail.com
    WebRun in Gmail: draft polite reminders
    WebRun drafts a tuition reminder per family and leaves it unsent.
    • Draft a polite, on-brand reminder for each family with the balance and how to pay
    • Keep the tone warm and offer a link to the family payment portal
    • Leave every reminder unsent in Drafts for the business office to review and send. Never email a family on its own

    Done when A tuition reminder sits in Gmail Drafts for each past-due family, none sent.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.blackbaud.com/solutions/financial-management/tuition-management
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
Past-due list · Gmail drafts
OutputWhat each run produces - A ranked list of past-due families with the balance and days overdue, plus a reminder drafted in Gmail for each.
Text
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it email families about money on its own?

No. WebRun drafts every tuition reminder and leaves it unsent in Gmail Drafts. Your business office reviews each one, adjusts the tone or amount if needed, and sends only what it approves. No payment reminder goes out automatically.

How does it know who is past due?

It reads the accounts receivable view in Blackbaud Tuition Management, capturing each family's balance, due date, and days overdue. Anyone whose payment has posted is not flagged, since it reads the live balance each run.

Will a family that already paid get a reminder?

No. WebRun reads the live balance in Blackbaud each Monday, so a family whose payment has cleared no longer shows as past due and is left out of the draft list.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.