Test prep company

Westerly Crossing Test Prep · Test prep company · Raleigh, NC

Viggo Jablonski runs the program at Westerly Crossing Test Prep, a test prep company in Raleigh, and uses this to invoice every family's prep plan, record each payment and see at a glance which plans are still unpaid.

EducationBillingDashboards4 tables · 5 views · 1 form · 2 dimension sets · 1 dashboard · 1 document · 1 notification · 1 stage rule set · 1 agent
Use this template

Billing board

Prep plans
Draft3
Allegra: Private tutoring, 10 sessionsINV-26-228Giulio Marchetti-Nkemelu
Thatcher: AP exam reviewINV-26-229Oriel Paddock-Vance
Jasper: SAT 12-week courseINV-26-230Harleen Sandhu-Castellan
Sent5
Adjoa: SAT 12-week courseINV-26-223Kwabena Osei-Mensah
Ignacio: ACT 8-week courseINV-26-224Leocadia Vasquez-Whitlock
Ren: PSAT weekend bootcampINV-26-225Hisako Tanaka-Burrows
Clementine: AP exam reviewINV-26-226Rutherford Abernethy
Emre: GRE one-on-one, 8 sessionsINV-26-227Selin Demirci-Fox
Part paid5
Mio: SAT 12-week courseINV-26-218Kazuo Nakagawa-Ellery
Tobenna: AP exam reviewINV-26-219Chidinma Okonjo-Hale
Marisela: Private tutoring, 10 sessionsINV-26-220Declan Brannigan-Soto
Joaquin: PSAT weekend bootcampINV-26-221Aldonza Ferreiro
Linus: ACT 8-week courseINV-26-222Sunniva Brekke-Aldous
Overdue7
Thatcher: SAT 12-week courseINV-26-211Oriel Paddock-Vance
Jasper: ACT 8-week courseINV-26-212Harleen Sandhu-Castellan
Lucian: PSAT weekend bootcampINV-26-213Bronislawa Wojcik-Ashby
Bryony: GRE one-on-one, 8 sessionsINV-26-214Evander Quigley-Rhodes
Sipho: Private tutoring, 10 sessionsINV-26-215Thandeka Mbeki-Lorentz
2 more
Paid10
Tobenna: SAT 12-week courseINV-26-201Chidinma Okonjo-Hale
Marisela: ACT 8-week courseINV-26-202Declan Brannigan-Soto
Joaquin: SAT 12-week courseINV-26-203Aldonza Ferreiro
Linus: Private tutoring, 10 sessionsINV-26-204Sunniva Brekke-Aldous
Adjoa: PSAT weekend bootcampINV-26-205Kwabena Osei-Mensah
5 more

Tables

Prep plans

30 sample rows · 14 columns

One student's prep plan from invoice to payment: the course, the fee, the tutor, the due date and what has come in.

Prep planInvoice numberFamilyPlanInstructorBilling statusStarts
Tobenna: SAT 12-week courseINV-26-201Chidinma Okonjo-HaleSAT 12-week courseCalloway Everhart-SinghPaidJul 7, 2026
Marisela: ACT 8-week courseINV-26-202Declan Brannigan-SotoACT 8-week courseAurelio TsvetkovPaidJul 18, 2026
Joaquin: SAT 12-week courseINV-26-203Aldonza FerreiroSAT 12-week courseCalloway Everhart-SinghPaidJul 28, 2026
Linus: Private tutoring, 10 sessionsINV-26-204Sunniva Brekke-AldousPrivate tutoring, 10 sessionsWinnifred Ashgrove-LamPaidAug 5, 2026
Adjoa: PSAT weekend bootcampINV-26-205Kwabena Osei-MensahPSAT weekend bootcampCalloway Everhart-SinghPaidAug 8, 2026
Ignacio: AP exam reviewINV-26-206Leocadia Vasquez-WhitlockAP exam reviewWinnifred Ashgrove-LamPaidAug 17, 2026
Ren: ACT 8-week courseINV-26-207Hisako Tanaka-BurrowsACT 8-week courseAurelio TsvetkovPaidAug 20, 2026
Clementine: SAT 12-week courseINV-26-208Rutherford AbernethySAT 12-week courseCalloway Everhart-SinghPaidAug 28, 2026
Thatcher: SAT 12-week courseINV-26-211Oriel Paddock-VanceSAT 12-week courseCalloway Everhart-SinghOverdueAug 28, 2026
Emre: Private tutoring, 10 sessionsINV-26-209Selin Demirci-FoxPrivate tutoring, 10 sessionsWinnifred Ashgrove-LamPaidAug 31, 2026
Jasper: ACT 8-week courseINV-26-212Harleen Sandhu-CastellanACT 8-week courseAurelio TsvetkovOverdueSep 5, 2026
Allegra: GRE one-on-one, 8 sessionsINV-26-210Giulio Marchetti-NkemeluGRE one-on-one, 8 sessionsTemperance Obuya-ReinholtPaidSep 8, 2026

18 more rows

Families

18 sample rows · 10 columns

The parents who enrol a student, with who to call and which plans are on their account.

Parent or guardianStudentGradePhoneEmailAccountWith us since
Aldonza FerreiroJoaquin Ferreiro12th grade(919) 555-0153aldonza.ferreiro@pinelandmail-net.comActiveMay 17, 2025
Bronislawa Wojcik-AshbyLucian Wojcik-Ashby9th grade(919) 555-0163bronislawa.wojcik@pinelandmail-net.comActiveDec 4, 2023
Chidinma Okonjo-HaleTobenna Okonjo-Hale11th grade(919) 555-0151chidinma.okonjo@pinelandmail-net.comActiveAug 31, 2025
Declan Brannigan-SotoMarisela Brannigan-Soto10th grade(919) 555-0152declan.brannigan@harbourpostal-box.comActiveJul 9, 2025
Evander Quigley-RhodesBryony Quigley-Rhodes12th grade(919) 555-0164evander.quigley@harbourpostal-box.comActiveOct 12, 2023
Giulio Marchetti-NkemeluAllegra Marchetti-Nkemelu12th grade(919) 555-0160giulio.marchetti@harbourpostal-box.comActiveMay 11, 2024
Harleen Sandhu-CastellanJasper Sandhu-Castellan11th grade(919) 555-0162harleen.sandhu@harbourpostal-box.comActiveJan 26, 2024
Hisako Tanaka-BurrowsRen Tanaka-Burrows9th grade(919) 555-0157hisako.tanaka@pinelandmail-net.comActiveOct 17, 2024
Kazuo Nakagawa-ElleryMio Nakagawa-ElleryCollege (graduate prep)(919) 555-0168kazuo.nakagawa@harbourpostal-box.comActiveMar 14, 2023
Kwabena Osei-MensahAdjoa Osei-Mensah10th grade(919) 555-0155kwabena.osei@pinelandmail-net.comActiveJan 31, 2025
Leocadia Vasquez-WhitlockIgnacio Vasquez-Whitlock12th grade(919) 555-0156leocadia.vasquez@harbourpostal-box.comActiveDec 9, 2024
Oriel Paddock-VanceThatcher Paddock-Vance10th grade(919) 555-0161oriel.paddock@pinelandmail-net.comActiveMar 19, 2024

6 more rows

Payments

21 sample rows · 6 columns

Each payment that comes in against a prep plan, and how it was paid.

PaymentReceipt numberPrep planReceivedAmountPaid by
Linus act 8-week course: depositPM-4121Linus: ACT 8-week courseSep 27, 2026$575ACH
Joaquin psat weekend bootcamp: depositPM-4120Joaquin: PSAT weekend bootcampSep 25, 2026$210Card
Marisela private tutoring: depositPM-4119Marisela: Private tutoring, 10 sessionsSep 20, 2026$625Check
Allegra gre one-on-one: balancePM-4114Allegra: GRE one-on-one, 8 sessionsSep 17, 2026$680Card
Tobenna ap exam review: depositPM-4118Tobenna: AP exam reviewSep 17, 2026$345Card
Fenwick ap exam review: depositPM-4116Fenwick: AP exam reviewSep 10, 2026$200Card
Mio sat 12-week course: depositPM-4117Mio: SAT 12-week courseSep 9, 2026$740Card
Ren act 8-week course: balancePM-4110Ren: ACT 8-week courseSep 5, 2026$575Card
Bryony gre one-on-one: depositPM-4115Bryony: GRE one-on-one, 8 sessionsSep 5, 2026$300Cash
Allegra gre one-on-one: depositPM-4113Allegra: GRE one-on-one, 8 sessionsSep 1, 2026$680Card
Emre private tutoring: payment in fullPM-4112Emre: Private tutoring, 10 sessionsAug 28, 2026$1,250Card
Linus private tutoring: balancePM-4106Linus: Private tutoring, 10 sessionsAug 26, 2026$625Card

9 more rows

Forms and booking

Record a payment

Form
Record a paymentThe form the front office fills in when money arrives for a prep plan.
What is the payment for? *
Which prep plan is it against? *
How much was paid? *
How did they pay?CardCheckACHCash
What day did it arrive?
Record the payment

Dashboards

Billing at a glance

Prep plans
Fees by billing status
  • Paid$11,710
  • Overdue$7,710
  • Part paid$4,990
  • Sent$5,100
  • Draft$3,420
Fees by plan
  • SAT 12-week course$10,360
  • ACT 8-week course$5,750
  • Private tutoring, 10 sessions$6,250
  • PSAT weekend bootcamp$1,680
  • AP exam review$3,450
  • GRE one-on-one, 8 sessions$5,440
Invoices sent each week
  • Jun 28, 20261
  • Jul 5, 20261
  • Jul 19, 20261
  • Jul 26, 20261
  • Aug 2, 20262
  • Aug 9, 20261
  • Aug 16, 20262
  • Aug 23, 20262
Collected by payment method0

Also included

  • Billing boardStage rules
  • Payment due soonNotificationTells the front office when a family's invoice is three days from its due date.
  • Payment reminderDocumentThe polite note that goes to a family whose invoice is past due.