Explore CuePilot as every user
ExploreCuePilotas
The accountant's console
Fees · live in the laptop
MARCUS BENNETT
CEO
Fees Dashboard
Aug 2025 — Jul 2026 · Last updated 2 hours ago
AY 2025-26
Annual Revenue Plan
AY 2025–26 · 93 enrolled / 114 capacity · 82% utilisation · 2 months left
EXPECTED ANNUAL
$4.1M
at current enrollment (93)
CAPACITY CEILING
$5.0M
if every seat filled (114)
SALVAGE OPPORTUNITY
$152K
21 open seats × 2 months left
Past + currentCollectedOutstandingLost opportunity|FutureExpectedSalvage opportunity|Capacity ceiling
Invoice vs Cash Flow
Quarterly invoices in Aug / Nov / Feb / May · cash flow tracks them, with small late-tail in the next month
INVOICED
$4.1M
10 of 4 billings issued
SETTLED
$3.6M
$19K paid
OUTSTANDING
$737K
$504K overdue
CASH BANKED
$3.6M
across attributions
Invoice barIssued quarterly, by status
Waivedwritten off
Overduepast due window
Duewithin window
Paidpaid, not yet banked
Settledmoney in the bank
Cash flow barBanked this month, by attribution
For upcomingadvance for next 2 months
For prior monthslate catch-up
For this monthon-time portion
AY 2025–26
Cash conversion cycle
11.8days
invoice → money in bank
DSO 9.3d
+2.5d
Family pays → 79% of cycle21% ← Gateway clears
Receivables Aging
$18,110outstanding · 62 students
↓ $1,087 vs last month
$10,985
60.7%
0–30 days
$3,875
21.4%
31–60 days
$910
5.0%
61–90 days
$2,340
12.9%
90+ days
Top Defaulters
| Student | Center | Overdue ↓ | Days | ||
|---|---|---|---|---|---|
NS Noah Sanchez | Atelier Manhattan | $540 | 21d | ||
TL Theo Lewis | Atelier Manhattan | $540 | 21d | ||
LH Liam Hernandez | Atelier Manhattan | $540 | 52d | ||
LR Lucas Reyes | Atelier Manhattan | $540 | 21d | ||
EP Evelyn Perez | Atelier Manhattan | $540 | 172d | ||
MN Mateo Nelson | Atelier SoMa | $480 | 52d | ||
MN Mateo Nelson | Atelier SoMa | $480 | 21d | ||
DG Daniel Goldberg | Atelier SoMa | $480 | 21d |
Showing 8 of 62
Payment Milestones & Cash Flow
Cumulative invoiced vs banked across AY 25-26 · 4 quarterly billings
Target (invoice issued) Actual (banked) Paid Unpaid
| Milestone | Due Date | Expected | Collected | Variance | Status |
|---|---|---|---|---|---|
| Admission | Aug 1, 2025 | $230,100 | $230,100 | $0 | 100% |
| Q1 Tuition | Aug 1, 2025 | $839,100 | $839,100 | $0 | 100% |
| Q2 Tuition | Nov 1, 2025 | $839,100 | $839,100 | $0 | 100% |
| Q3 Tuition | Feb 1, 2026 | $839,100 | $839,100 | $0 | 100% |
| Q4 Tuition | May 1, 2026 | $839,100 | $445,500 | $393,600 | 53% |
Collection Velocity:89.0%
Projected Year End:$3,586,500
Gap to Close:$393,600
Center Performance
YTD totals + this month — click headers to sort
| Year to date | Jul · this month | ||||||
|---|---|---|---|---|---|---|---|
| Center | Students | Billed | Collected | Rate ↓ | Billed | Collected | Overdue |
Atelier SoMa Bay Area Cluster · West Coast · avg $47,356/yr | 12/15 | $568K | $535K | 94% | $115K | $86K(75%) | 0.9% |
Atelier Manhattan Manhattan Cluster · East Coast · avg $53,602/yr | 18/22 | $965K | $886K | 92% | $194K | $121K(62%) | 0.3% |
Atelier Lincoln Park Chicago Cluster · Midwest · avg $38,043/yr | 20/25 | $761K | $685K | 90% | $162K | $89K(55%) | 0.4% |
Atelier Boulder Front Range Cluster · Mountain · avg $36,549/yr | 18/22 | $658K | $587K | 89% | $135K | $68K(50%) | 0.4% |
Atelier Park Slope Brooklyn Cluster · East Coast · avg $44,195/yr | 25/30 | $1.1M | $952K | 86% | $233K | $86K(37%) | 0.4% |
Distributions
Payment Methods
ACHDominant
ACH36%
Credit Card32%
Check13%
Apple Pay12%
Wire6%
Cash2%
Revenue by Category
81%Primary
Tuition82%
Meals7%
Admission6%
Transport5%
Late Fee0%
Activities0%
Charge Type
94%Main type
Recurring94%
One-time6%
On-demand0%
Adjustment0%
Attendance0%
Discounts & Adjustments
Discounts & Waivers
Total Discounts
−$79,000
Discount Rate: 1.91% of gross revenue
SCHOLARSHIPScholarship5 entries
−$25,000EARLYBIRDDISCOUNTEarly Bird Discount32 entries
−$24,000SIBLINGDISCOUNTSibling Discount10 entries
−$15,000STAFFCHILDWAIVERStaff Child Waiver5 entries
−$15,000Gross Revenue$4,135,720
Net of Discounts$4,056,720
Late Fees & Penalties
Total Late Fees Charged
$15,925
$15,505 collected (97.4%) · $420 outstanding
Late Payment Fee297 events
98% collected$12,375
Late Pickup42 events
98% collected$2,100
Returned Payment Fee32 events
88% collected$960
Early Drop-off14 events
100% collected$490
Net Adjustment Impact−$63,495
Net Revenue After Adj.$4,072,225