Youth sports league

Quillmoor Green Youth League · Youth sports league · Fort Collins, CO

Rocco Jankowski coordinates Quillmoor Green Youth League, a youth soccer league in Fort Collins, and he bills every child's registration from one place, so each invoice, payment and unpaid balance can be traced to its division and month before the next game day.

NonprofitBillingDrill-down5 tables · 6 views · 2 forms · 1 dimension set · 2 drill-downs · 1 digest · 1 document · 1 notification · 1 stage rule set · 1 agent
Use this template

Billing board

Registrations
Registered5
QG-26-1030Clara ZelenkaU12 Ravens
QG-26-1031Isaiah TemboU14 Wolves
QG-26-1032Lucia Montague-ItoU6 Chipmunks
QG-26-1033Soren AshworthU10 Comets
QG-26-1034Yusra MahmoudU8 Foxes
Invoiced9
QG-26-1021Callum Dunmore-ReyesU10 Comets
QG-26-1022Aurelia ValdiviaU8 Foxes
QG-26-1023Hugo Larkspur-MbekiU14 Wolves
QG-26-1024Sabina OkoroU12 Ravens
QG-26-1025Dmitri KovalenkoU8 Foxes
4 more
Part paid6
QG-26-1015Oscar FennimoreU12 Lynx
QG-26-1016Zadie Okonjo-PruittU10 Falcons
QG-26-1017Rhys PenhallowU8 Herons
QG-26-1018Amara Delgado-StroudU12 Ravens
QG-26-1019Felix BergstromU14 Wolves
1 more
Paid14
QG-26-1001Ezra CallowayU8 Foxes
QG-26-1002Imogen TakahashiU10 Badgers
QG-26-1003Mateo QuinteroU12 Lynx
QG-26-1004Roisin DelacourtU10 Falcons
QG-26-1005Kwesi Mensah-BarlowU8 Herons
9 more
Waived2
QG-26-1035Declan Pruett-SalazarU14 Wolves
QG-26-1036Yolanda Ferreira-LundeU12 Ravens

Tables

Registrations

36 sample rows · 16 columns

One line per child per season: what was billed, what has come in and what is still owed.

RegistrationPlayerTeamDivisionUniformTotal feePayments
QG-26-1034Yusra MahmoudU8 FoxesU8$30$135
QG-26-1033Soren AshworthU10 CometsU10$0$125
QG-26-1032Lucia Montague-ItoU6 ChipmunksU6$0$85
QG-26-1031Isaiah TemboU14 WolvesU14$30$185
QG-26-1030Clara ZelenkaU12 RavensU12$0$140
QG-26-1029Rafael Achebe-LundU8 HeronsU8$0$105
QG-26-1028Matilde BrandvoldU10 FalconsU10$30$155
QG-26-1027Emilio SantoroU12 LynxU12$0$140
QG-26-1026Maren Holloway-AbaraU10 BadgersU10$0$125
QG-26-1025Dmitri KovalenkoU8 FoxesU8$30$135
QG-26-1024Sabina OkoroU12 RavensU12$0$140
QG-26-1023Hugo Larkspur-MbekiU14 WolvesU14$0$155

24 more rows

Players

36 sample rows · 10 columns

Every child signed up for the season, with the family's contact details and the notes a coach needs.

PlayerParent or guardianGuardian emailGuardian phoneDate of birthShirt sizeRegistrations
Amara Delgado-StroudTobias Delgadotobias.delgado@bluestemfieldinbox.org(970) 555-0167Feb 12, 2015Youth LQG-26-1018
Anselmo PardoCamila Pardocamila.pardo@foxgloveridgemail.net(970) 555-0156Jul 16, 2012Youth SQG-26-1007
Aurelia ValdiviaRodrigo Valdiviarodrigo.valdivia@foxgloveridgemail.net(970) 555-0171Oct 13, 2019Youth MQG-26-1022
Bram VoskuijlenAnnelies Voskuijlenannelies.voskuijlen@tamaracklanepost.com(970) 555-0160Mar 17, 2012Youth SQG-26-1011
Callum Dunmore-ReyesShauna Dunmoreshauna.dunmore@bluestemfieldinbox.org(970) 555-0170May 6, 2016Youth LQG-26-1021
Clara ZelenkaPavel Zelenkapavel.zelenka@bluestemfieldinbox.org(970) 555-0179Feb 15, 2015Youth LQG-26-1030
Cormac Teague-NakamuraBrenna Teaguebrenna.teague@bluestemfieldinbox.org(970) 555-0158May 3, 2016Youth LQG-26-1009
Declan Pruett-SalazarMairead Pruettmairead.pruett@tamaracklanepost.com(970) 555-0184Mar 23, 2012Youth SQG-26-1035
Dmitri KovalenkoLarysa Kovalenkolarysa.kovalenko@foxgloveridgemail.net(970) 555-0174Jan 7, 2018Youth SQG-26-1025
Emilio SantoroValentina Santorovalentina.santoro@bluestemfieldinbox.org(970) 555-0176Nov 21, 2014Youth LQG-26-1027
Ezra CallowayHollis Callowayhollis.calloway@foxgloveridgemail.net(970) 555-0150Jan 1, 2018Youth SQG-26-1001
Felix BergstromLovisa Bergstromlovisa.bergstrom@foxgloveridgemail.net(970) 555-0168Jul 19, 2012Youth SQG-26-1019

24 more rows

Teams

12 sample rows · 4 columns

The teams in each division, who coaches them, where they play and the season fee.

TeamVolunteer coachHome fieldSeason fee
U6 SparrowsLinus Abernethy-ColeHobbleton Fields, pitch 1$85
U6 ChipmunksVerena MarchettiHobbleton Fields, pitch 1$85
U8 FoxesTomasz WickstromHobbleton Fields, pitch 2$105
U8 HeronsAaliyah Brandt-OseiHobbleton Fields, pitch 2$105
U8 OttersSilas FarradayCedar Bend Park$105
U10 FalconsMarisela DuquesneCedar Bend Park$125
U10 BadgersEvander Rutherford-KimCedar Bend Park$125
U10 CometsOttoline Vasquez-LundHobbleton Fields, pitch 3$125
U12 LynxLeopold OstrowskiHobbleton Fields, pitch 3$140
U12 RavensIngrid FallowfieldCedar Bend Park$140
U14 WolvesCyrus AldernayRiverside Complex$155
U14 HawksPhilomena Tran-WeberRiverside Complex$155

Payments

25 sample rows · 5 columns

Every check, card payment and cash payment received against a registration.

PaymentRegistrationMethodReceivedAmount
PM-26-525QG-26-1020CheckAug 21, 2026$47
PM-26-524QG-26-1019OnlineAug 17, 2026$92
PM-26-523QG-26-1018CheckAug 16, 2026$80
PM-26-522QG-26-1017OnlineAug 10, 2026$57
PM-26-518QG-26-1013OnlineAug 9, 2026$68
PM-26-521QG-26-1016CheckAug 8, 2026$77
PM-26-519QG-26-1014CheckAug 5, 2026$125
PM-26-520QG-26-1015OnlineAug 5, 2026$80
PM-26-514QG-26-1010CashJul 29, 2026$68
PM-26-516QG-26-1012CashJul 27, 2026$140
PM-26-517QG-26-1013CardJul 26, 2026$67
PM-26-515QG-26-1011CardJul 23, 2026$155

13 more rows

Also included

  • Invoices by month and divisionDrill-down
  • Division by billing stageDrill-down
  • Billing boardStage rules
  • Friday unpaid invoicesDigest
  • Invoice coming dueNotificationGives the treasurer a heads-up ahead of each due date, so the reminder call goes out before the invoice slips.
  • Past-due noteDocumentThe short email to a family whose invoice has passed its due date.