| Player Name | Program | Origin | Status | Paid | Profile | Housing | Drug-Free | Contract | Gear | Parent | Portal | COA | Accepted |
|---|
Student Information
Financial Details
Auto-calculated from base cost of $72,797
Auto-set to 8 days after Invoice Date
Payment Schedule
First payment starts the month after deposit due date.
Output Options
Generate PDFs
Generates PDFs and logs to Airtable if checked
Ready to send acceptance + COA?
Summary
Quick Tips
- • Post Grad: $15,000 default
- • High School: $20,000 default
- • Deposit typically: $3,000
- • PDFs download automatically
- • Base cost: $72,797 (for scholarship calc)
Payment Manager
Roster tuition shows scheduled and recorded tuition for applied, accepted, and committed students. Needs Review holds unlinked, lead-only tuition, or inactive payment records.
Tuition
Outstanding
—
Collected
—
Past Due
—
Collection Rate
—
App Fees Collected
—
— deposits
Other Payments
—
| Student | Due Date | Amount | Status | Type | Method | Cardholder | Address | Actions |
|---|---|---|---|---|---|---|---|---|
| Loading payments… | ||||||||
| Student Name | Check-In Time | Check-Out Time | Duration | Actions |
|---|---|---|---|---|
| Loading… | ||||
Payment Status Distribution
Country Distribution
Monthly Revenue (Last 6 Months)
| Month | Amount | Payments |
|---|
Email Settings
admin@floridacoastalprep.com
System Info
Broadcast Message
Quick Actions
Scans scheduled payments, marks past-due, sends reminders to parents.
Coming soon — triggers a Netlify rebuild of the marketing site.
Schedule Manager
Announcements
Loading...
I-20 Requests
Loading...
I-20 Status Board
International student visa document tracking
| Student | Program | Country | Info Status | Passport | Missing Fields | Coach | Actions |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
I-20 Letters
Create school acceptance and transfer letters for students. These downloads are admin-only.
Gallery
Loading...
Recruiting Assignments
Drag leads between coaches to assign. SMS notification sent on assign.
Activity Feed
Chronological log of all automated emails, SMS, status changes, and assignments.
Lead Hub
Every lead in the system. Assign a coach and set status inline — changes save instantly.
| Name ⇅ | Source ⇅ | Program ⇅ | Coach ⇅ | Status ⇅ | Last Contact ⇅ | Email ⇅ | Started ⇅ | Actions | |
|---|---|---|---|---|---|---|---|---|---|
| Loading leads... | |||||||||
Click any row to see player phone, parent contact, and more details.
Applied Queue
Applicants Lee owes a COA to, and those awaiting deposit after COA was sent. Auto-reassigned every 10 min when any recruit's Status becomes "Applied."
Portal Tracker
One reconciliation view for parent portal, player portal, gear, documents, I-20 requests, payments, and COA versions.
Lifecycle Health
Flags recruits stuck between lead, application fee, COA, follow-up, and deposit stages so cleanup work is visible.
Source of Truth Audit
Checks that Airtable fields, admin views, player portal, parent portal, gear records, I-20 requests, and signed document records agree.
COA Follow-Up
Everyone whose acceptance + COA packet has been sent, with the 24-hour inbox/spam reminder status and current Airtable status shown.
App Fee Payers
Everyone who paid the $25 application fee in the last 90 days. Cross-references Authorize.net receipts in Outlook against Airtable Students. Flags orphans (paid but no Student record), no-deposit leads (paid but didn't commit), and converted (paid + deposited).
Recruiting Analytics
Funnel performance per coach and overall. All metrics computed from leads (Is_Lead=TRUE).
Teams
Manage the FCP basketball teams. Used by the Scheduling Agent and player/team assignments.