ABERDEEN BOARD OF PARKS & RECREATION CORRECTED MONTHLY TREASURER'S REPORT
5-Mar-17
I. PROGRAM SUMMARY
PROGRAM ACCOUNT
01: General Fund 03: Golden Age Club 06: Ballet/Jazz/Tap 09: Soccer 11: Basketball 14: TaeKwonDo (Golden Dragons) 15: Aikido 16: Wrestling 20: Tennis 30: Baseball 31: Youth Softball 40: Football 43: North Bay Rugby 49: North Bay Rugby Youth Pgm 50: Chess Club 53: Basketball Cheerleading 60: Summer Concerts 62: Parks/Special Events 68: Jean Davis Memorial Fund 70: Special Projects 71: Summer Basketball Academy 75: Track & Field Team 76: Softball Co-op 79: Wardle Soccer Camp & Toum 80: Field Hockey 81: Roller Hockey 82: Roller Derby (Harf Co Hellions) 83: Plastic Model Club 84: Lacrosse 85: Fastpitch Academy 97: Liability Insurance $ Holding Acct 98: Council $ Holding Acct 99: City $ Holding Acct 00:
Unclaimed Deposits TOTALS
02/01 BALANCE
INCOME
EXPENSE
02/28 BALANCE
$1,833.69 1,694.58 17,703.11 6,074.64 21,560.53 4,892.16 9,643.63 3,079.91 828.02 4,842.76 1,641.21 3,809.59 1,349.52 11,152.40 6.88 666.57 299.96 16,034.88 340.00 11,564.47 5,530.63 3,178.51 25.00 113.03 105.00 0.00 763.20 0.00 3,665.33 900.00 9,068.20 22,338.93 20,000.00
$3,975.00 1,286.00 1,493.85 1,600.00 3,105.00 0.00 0.00 9,830.93 0.00 4,950.00 1,723.00 4,000.00 0.00 1,700.00 0.00 1,112.00 0.00 0.00 0.00 0.00 500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,618.00 0.00 0.00 0.00 -20,000.00
-$321.84 -276.20 -2,074.70 0.00 -6,623.00 0.00 0.00 -2,549.61 0.00 0.00 0.00 0.00 0.00 -4,244.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -500.00 0.00 0.00 0.00 0.00
$5,486.85 2,704.38 17,122.26 7,674.64 18,042.53 4,892.16 9,643.63 10,361.23 828.02 9,792.76 3,364.21 7,809.59 1,349.52 8,607.90 6.88 1,778.57 299.96 16,034.88 340.00 11,564.47 6,030.63 3,178.51 25.00 113.03 105.00 0.00 763.20 0.00 5,783.33 900.00 9,068.20 22,338.93 0.00
0.00
0.00
0.00
0.00
$184,706.34
17,893.78
-16,589.85
186,010.27
Aberdeen Parks & Rec Website: http://www.aberdeenpr.cornlindex.html
II. DEPOSITS BY PROGRAM DATE
AMOUNT
DESCRIPTION
**Program 01: GENERAL FUND City$- Treas bond, insure, IRS, equip, etc 2115/2017 $3,975.00 **Subtotal $3,975.00 **Program 03: GOLDEN AGE CLUB 2115/2017 $1,000.00 City$- Club book, activity supplies 2/8/2017 $75.00 Dues 2/15/2017 $105.00 Dues $60.00 Dues 2/24/2017 2/8/2017 $13.50 Bounty Share 2/15/2017 $19.00 Bounty Share $13.50 Bounty Share 2/24/2017 **Subtotal $1,286.00 **Program 06: BALLET/JAZZ/TAP 2/15/2017 $1,000.00 City$- Teacher tng, player/speakers 2/13/2017 $103.85 Fundraiser $390.00 Costumes 2/13/2017 ** Subtotal $1,493.85 ** Program 09: SOCCER 2/15/2017 $1,600.00 **Subtotal
City $ - Equip, 1st aid supplies $1,600.00
** Program 11: BASKETBALL City$- Equip, uniforms, 1st aid supplies 2/15/2017 $1,600.00 $5.00 Registrations 2/13/2017 2/2112017 $700.00 League fees (J Towne) 2/1/2017 $800.00 Void Check #26516 **Subtotal $3,105.00 **Program 16: WRESTLING 2/6/2017 $4,855.00 Tournament revenue (02/04 & 02/05) 2/8/2017 $4,922.93 Age/Weight Qualifier 2/21/2017 $53.00 Refund from HP Home Store (via Visa) ** Subtotal $9,830.93 **Program 30: BASEBALL City$- Catchers gear, baseballs, equip, etc 2/15/2017 $1,800.00 2/6/2017 $700.00 Registrations (14@ $50) 2/7/2017 $525.00 Registrations $1,275.00 Registrations 2/21/2017 2/24/2017 $650.00 Registrations ** Subtotal $4,950.00
II. DEPOSITS BY PROGRAM DATE
AMOUNT
DESCRIPTION
** Program 31: YOUTH SOFTBALL City$- Liab Insure, 1st aid supplies 2115/2017 $1,125.00 2/27/2017 $675.00 Registrations 2/28/2017 ($65.00) Bad Check (Jacqueline Johnson) 2/28/2017 ($12.00) Bad Chk Svc Chg (J. Johnson) $1,723.00 **Subtotal **Program 40: FOOTBALL City$- Shoulder Pads, Med supplies, etc 2/15/2017 $4,000.00 ** Subtotal $4,000.00 ** Program 49: NORTH BAY RUGBY YOUTH PGM City$ USA Rugby liab, 1st aid supplies 2/15/2017 $1,700.00 $1,700.00 **Subtotal **Program 53: BASKETBALL CHEERLEADING $400.00 2/15/2017 City$- Portable PA system/speaker 2/112017 $712.00 Krispy Kreme donut fundraiser ** Subtotal $1,112.00 ** Program 71: SUMMER BASKETBALL ACADEMY City$- 1st Aid kits $500.00 2/15/2017 **Subtotal $500.00 ** Program 84: LACROSSE 2115/2017 $1,300.00 City$- Equipment $103.00 Registrations 2/8/2017 2/16/2017 $520.00 Registrations $495.00 Registrations 2/23/2017 2/8/2017 $200.00 Donation (Harford Natl Bank) ** Subtotal $2,618.00 ** Program 99: CITY $HOLDING ACCT 2/15/2017 ~$3,975.00) TFR City$ to GEN FUND (Treas bond, equi, etc) ~$1,000.00) TFR City$ to GOLDEN AGE (Club book, acty supp) 2115/2017 ~$1,000.00) TFR City$ to BALLET (teacher tng, player/spkrs) 2115/2017 2115/2017 ~$1,600.00) TFR City$ to SOCCER 2/15/2017 ~$1,600.00) TFR City$ to BASKETBALL 2/15/2017 ~$1,800.00) TFR City$ to BASEBALL (catchers gear, equip, etc ~$1,125.00) TFR City$ to SOFTBALL (Liab Ins, 1st Aid, etc) 2115/2017 2/15/2017 ~$4,000.00) TFR City$ to FOOTBALL (shoulder pads, 1st aid) 2115/2017 ~$1,700.00) TFR City$ to YTH RUGBY (USA Rugby, 1st aid) 2/15/2017 ($400.00) TFR City$ to BASKETBALL CHEER (PA sys) 2/15/2017 ($500.00) TFR City$ to BASKETBALL ACADEMY (1st aid) 2115/2017 ~$1,300.00) TFR City$ to LACROSSE (equipment) ** Subtotal ($20,000.00) *** Total Deposits
$17,893.78
Ill. CHECKS BY PROGRAM DATE
CHK NR
PAYEE
AMOUNI
DATE CLEARED
**Program 01: GENERAL FUND 02/02/2017
26548
Gene A. Gall
100.00
Bookkeeping- (Nov-Dec) 2 months@ $50
02/09/2017
02/16/2017
26561
Gene A. Gall
100.00
02/0112017
VISA
Ha11PriceSoft
79.00
Bookkeeping- (Jan-Feb) 2 months@ $50 IRS 1099 software (to file 1099-MISC salaries of c
02/22/2017 02/0112017
02/06/2017
VISA
Stamps. com
15.99
Postal svc (mon)
02/06/2017
02/06/2017
VISA
HallPriceSoft
26.85
Scannable IRS 1099 forms (for Ballet contract inst 321.84
02/06/2017
59.50
**Subtotal
**Program 03: GOLDEN AGE CLUB 02/07/2017
26551
Maxel Denson
02115/2017 02/22/2017
26556 26562
Ruth Elliiot Ruth Elliiott
Reimbursement for Anniversity Party
02/08/2017
82.85 133.85
Stamps ($49) Flowers ($33.85) Reimbursement for ink pens and flowers 276.20
02/17/2017 02/24/2017
870.00 390.00
Salary (Jan) 29 hrs @ $30
02/03/2017 02/06/2017 02/09/2017
**Subtotal
** Program 06: BALLET/JAZZ/TAP 02/02/2017 02/02/2017
26543 26544
Sarah J. Watt Kate1ynn Mae Selchert
02/02/2017
26545 26546
Tai YanaGee Lynette Brown
26549
Morgan Johns
02/07/2017 02/08/2017
26550 26553
Isadora Fink Harford Co MD
02/27/2017
26566 26567
Harford Co MD Harford Co MD
02/02/2017 02/07/2017
02/28/2017
60.00
Salary (Jan) 26 hrs@ $15 Salary (Jan) 6 hrs@ $10
36.00 90.00
Salary (Jan) 3 hrs@ $12
02/22/2017
Salary (Jan) 9 hrs @$10
02/13/2017
108.00 121.78
Salary (Jan) 9 hrs @$12 Custodian- Evetta Richardson 5hrs (0 1/7/17)
02/14/2017
173.06 225.86
Custodian- (02/12/17) 7 hrs Custodian- (01121/17) 5 hrs- (01128/17) 5 hrs 2,074.70
**Subtotal
**Program 11: BASKETBALL 02/07/2017
247.95
Custodian- E. Sheehan 9.5 hrs (01/7/17)
02/23/2017
Referee fees (01128117-02/04/17)
02/13/2017
Custodian- Eve Sheehan (01121-01128/17) 18.5 hrs Travel team payment 12U Referee fees (02/11-02/18/1 7)
02/28/2017 02/2112017 02/27/2017
26552 26555
Harford Co MD Danny R. Pierce
2,370.00
26558
Harford Co MD
482.84
02/22/2017
26560 26563
Duane Rabb Danny R. Pierce
105.00 2,370.00
02/27/2017
26564
Harford Co MD
450.23
Custodian- (02/04-02111117) 19.5 hrs
Harford Co MD
596.98
Custodian - (02/04-02/05117) 24.5 hrs 6,623.00
02/08/2017 02115/2017 02116/2017
02/27/2017
**Subtotal
26565
Ill. CHECKS BY PROGRAM DATE
CHK NR
PAYEE
DATE CLEARED
AMOUNT
**Program 16: WRESTLING 02/15/2017
26557
Harford Co MD
02/08/2017
VISA
TC logiQ, Inc
02/13/2017
VISA
USA Wrestling Assn
02/09/2017
VISA
Target (Aberdeen)
02/16/2017
VISA
HP Home Store
02/15/2017
VISA
57.45 391.50
02/15/2017
VISA
MyLockerNet LLC (Detroit MI) Customink LLC (Fairfax VA)
Jacket (Mattheus Carroll)
02/15/2017
Shirts in lieu of trophies
02115/2017
02/16/2017
VISA
Launch Trampoline (Newark DE)
249.50
Year-end party @ Launch, DE
02/16/2017
02/14/2017 02/14/2017
VISA
Hilton Garden Inn (BWI Linthicu Hilton Garden Inn (BWI Linthicu
116.39
Rooms for coaches at State tournament (worked late
02/14/2017
VISA
116.39
Rooms for coaches at State tournament (worked late
02/14/2017
02/14/2017
VISA
Hilton Garden Inn (BWI Linthicu
116.39
Rooms for coaches at State tournament (worked late 2,549.61
02/14/2017
500.00
2 teams @ Ruggerfest Tournament
Custodian- Rodney Harris (01128/17) 13 hrs
02/28/2017
Background check (additional coach)
02/08/2017
95.00
USA Wrestling card, 2 yrs (Don Ewing)
02/13/2017
63.59
Digital voice recorder for meetings
02/09/2017
Large format printer (HP DesignJet Tl20) for State
02116/2017
321.41 15.00
1,006.99
**Subtotal
** Program 49: NORTH BAY RUGBY YOUTH PGM 02/15/2017
26559
1,134.00
Club & Individual Player Participation (CIPP) regi
02/06/2017
02/06/2017 02/07/2017
VISA
USA Rugby USA Rugby
02/07/2017
VISA
Penn Legacy/Hempfield Rugby
850.50 800.00
Club & Individual Player Participation (CIPP) regi
02/14/2017
Frostbite tournament (2 teams $400)
02/14/2017
VISA VISA
Penn Legacy/Hempfield Rugby Steamroller Rugby Supply Co.
800.00 160.00
Frostbite tournament (2 teams $400) Rugby balls (10@ $16) 4,244.50
02114/2017 02114/2017
500.00
Referee fees
02/15/2017
02114/2017 02114/2017
VISA
WWRFC
**Subtotal
**Program 84: LACROSSE 02/02/2017
26547
**Subtotal ***Total Checks
Matthew Schwartz
500.00
16,589.85
IV. TREASURER'S NOTES Last year the Aberdeen Board of Directors received requests in excess of $50k for grant money from the city of Aberdeen but only received $20k. After reviewing justifications and prioritizing requests, the Board approved allocating the $20k as follows: 01 GENERAL FUND
$3,975.00
03 GOLDEN AGE CLUB
$1,000.00
06 BALLET
$1,000.00
09 SOCCER
$1,600.00
11 BASKETBALL
$1,600.00
30 BASEBALL
$1,800.00
31 SOFTBALL
$1,125.00
40 FOOTBALL
$4,000.00
49 NORTH BAY YOUTH RUGBY
$1,700.00
53 BASKETBALL CHEERLEADING
$400.00
71 BASKETBALL ACADEMY
$500.00
84 LACROSSE
$1,300.00
$20,000.00
See Section VII for a break-down by line item. These funds were distributed to programs in Feb 2017.
Gene Gall, Treasurer [
[email protected]] Aberdeen Board of Parks & Recreation Website: www .aberdeenpr.com
~~ff!%;~~~~£{t~~~~~t14~~~~~~?;'1~~~~,/~~~~~:~~;p /C~ j~- ~~~~~{~~;~~~;~~~~:~;. J~~: ~~J~~,~- --y~ :;~ ~~ ~ ~ ·-- ~~-~i~%~~;,~~;:~z~id~-j~·'i;~~;~;~~~"-,;_~~~~~}~;--:
v.
FY 2016 COUNCIL$
HOLDING ACCT
As Of 02/28/2017 FY 2015
FY 2016
Assessment =$5 per registrant Regs Amount
Regs
Amount
82 95 122
139 60 185 36
$565 $505 $615 $0 $0 $315 $0 $695 $300 $925 $180
0 0 189 0
$410 $475 $610 $0 $100 $0 $0 $0 $0 $945 $0
98
$490
0
$0
31
$155
29
$145
15
$0 $75
0
$0 $0
PROGRAM ACCOUNT
01: 03: 06: 09: 11: 14: 15: 16: 20: 30: 31: 40: 43: 48: 49: ISO:
53: 60: 62: 67: 68: 70: 71: 75: 76: 79: 80: 81: 82: 83: 84: 85: 98:
General Fund Golden Age Club Ballet/Jazz/Tap Soccer Basketball TaeKwonDo Aikido Wrestling Tennis Baseball Youth Softball Football North Bay Rugby Martial Arts Unlimited North Bay Rugby Youth Pgm Chess Club Basketball Cheerleading Summer Concerts Parks/Special Events SwanFest Jean Davis Memorial Fund Special Projects Summer Basketball Academy Track & Field Team Softball Co-op Wardle Soccer Camp & Toum Field Hockey Roller Hockey Roller Derby (HarfCo Hellions) Plastic Model Club
Lacrosse Fastpitch Academ Council Fund $ Holding
113 101 123 63
20 0
0
177
$750 $0 $150 $0 $0 $885
1321
$6,605
537
150 30
?
0 0
$0 $0 $0 $0 $0 $0 $0 $2,685
~~~~~t~~i~-i{~(~~t~;~~~?i"~f~i~~~,~:~ t~~ -~ ,~~~: -~;~o:~~~~~~:_?;~~i~~-:~::;:=~~~~~.-;;~;~~~--~~~~~~~;:_;~~~-~1~:-~-: :=·,~t;~;~,~: --:-~~-~ ---:t~I~~~~~i~~~{~~t~~~~;~~~~~i:-~~:;~; ~~
VI. FY 2016 LIABILITY
INSURANCEt~HOLDING ACCT
As Of 02/28/2017 FY 2015
FY 2016
Assessment = $2.50 per registrant Regs
Amount
Regs
Amount
PROGRAM ACCOUNT
01: 03: 06: 09: 11: 14: 15: 16: 20: 30: 31: 40: 43: 48: 49: 50: 53: 60: 62: 67: 68: 70: 71: 75: 76: 79: 80: 81: 82: 83:
General Fund Golden Age Club Ballet/Jazz/Tap Soccer Basketball TaeKwonDo Aikido Wrestling Tennis Baseball Youth Softball Football North Bay Rugby Martial Arts Unlimited North Bay Rugby Youth Pgm Chess Club Basketball Cheerleading Summer Concerts Parks/Special Events Swanfest Jean Davis Memorial Fund Special Projects Summer Basketball Academy Track & Field Team Softball Co-op Wardle Soccer Camp & Toum Field Hockey Roller Hockey Roller Derby (HarfCo Hellions) Plastic Model Club
84: 85:
Lacrosse Fastpitch Academy
97:
Liability Insurance Shares
139 60 185
$0.00 $282.50 $252.50 $307.50 $0.00 $0.00 $157.50 $0.00 $347.50 $150.00 $462.50
0 0 189
0.00 $205.00 $237.50 $305.00 $0.00 $50.00 $0.00 $0.00 $0.00 $0.00 $472.50
98
$245.00
0
$0.00
31
$77.50
29
$72.50
15
$0.00 $37.50
0
$0.00 $0.00
113 101 123
63
150 30
177 1285
$375.00 $0.00 $75.00 $0.00 $0.00 $442.50 $0.00 $3,212.50
82 95 122 20 0
$0.00 $0.00 $0.00 0 $0.00 $0.00 $0.00 0 $0.00 537 $1,342.50 0
-;: ~~::- ~-; =~2- ~~J?~~;~~f~~~!~~~~~51f~~~~~ ~~~-- ~'"
BUDGETED
USED
$600.00 $300.00 $1,000.00 $300.00 $500.00 $600.00 $100.00 $575.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$600.00 $300.00 $1,000.00 $300.00 $500.00 $600.00 $100.00 $575.00
$3,975.00
$0.00
$3,975.00
$500.00 $500.00
$0.00 $0.00
$500.00 $500.00
$400.00 $400.00 $200.00
$0.00 $0.00 $0.00
$400.00 $400.00 $200.00
09: SOCCER Nets, whistles, balls, ball bags, needles, etc First aid kits, ice packs, shin guards, mouth pieces
$1,300.00 $300.00
$0.00 $0.00
$1,300.00 $300.00
11: BASKETBALL Equipment Basketballs, Whistles, scorebooks, etc Replace old, worn & lost uniforms Replace First Aid kits, ice packs, etc
$250.00 $1,100.00 $250.00
$0.00 $0.00 $0.00
$250.00 $1,100.00 $250.00
30: BASEBALL Catchers gear, baseballs, equip bags, ump equip First Aid kits, ice packs, etc
$1,500.00 $300.00
$0.00 $0.00
$1,500.00 $300.00
$500.00 $625.00
$0.00 $0.00
$500.00 $625.00
40: FOOTBALL Replace worn/old shoulder pads and equipment Medical Supplies
$2,000.00 $2,000.00
$0.00 $0.00
$2,000.00 $2,000.00
49: NORTH BAY YOUTH RUGBY USA Rugby liability insurance for HS boy & girl teams First Aid kit supplies for youth & 2 HS teams
$1,500.00 $200.00
$0.00 $0.00
$1,500.00 $200.00
$400.00
$0.00
$400.00
01: GENERAL FUND Computer/Office Equipment FirefTreasurer Bond Premium Volunteer Recognition IRS-related expenses IRS 990, 1099, prep) Postal svc/Biank forms/Postage refills Bookkeeping expense (12 months x $50) Legal Defense Fund Contingencies SUBTOTAL 03
GOLDEN AGE CLUB Supplies for Activities at meetings Club book
06: BALLET Teacher training Player/Speakers Barre cart
31: SOFTBALL Liability insurance 1st aid ice packs, 1st aid kits
53: BASKETBALL CHEERLEADING Portable ali-in-one Wireless PA saystem/speaker
BALANCE
71: BASKETBALL ACADEMY First aid kits
$500.00
$0.00
$500.00
84: LACROSSE First Aid kits 10 Team 40 Sets of Girls Eye Mask 100 Mouth Pieces Goalie Saftey Equipment
$400.00 $400.00 $100.00 $400.00
$0.00 $0.00 $0.00 $0.00
$400.00 $400.00 $100.00 $400.00
$0.00
$20,000.00
TOTAL
$20,000.00
f