ABERDEEN BOARD OF PARKS & RECREATION MONTHLY TREASURER'S REPORT AUGUST2015 1-Sep-15
I. PROGRAM SUMMARY
PROGRAM ACCOUNT
01:
99:
General Fund Golden Age Club Ba1Jet/Jazz/I'ap Gymnastics Soccer W eightlifting Basketba1J Tae Kwon Do (Golden Dragons) Aikido Wrestling Tennis Baseba11 Youth Softba11 Footba11 North Bay Rugby North Bay Rugby Youth Pgm Chess Club Basketba11 Cheerleading Summer Concerts Parks/Specia1 Events Jean Davis Mernoria1 Fund Specia1 Projects Summer Basketba11 Academy Track& Field Team Softba1l Co-op Wardle Soccer Camp & Tourn Field Hockey Roller Hockey Roller Derby (HarfCo Hellions) Plastic Model Club Lacrosse Liability Insurance $ Holding Acct Council $ Holding Acct City $ Holding Acct
00:
Unclaimed Deposits
03:
06: 07:
09: 10: II: 14: 15: 16: 20: 30: 31:
40: 43: 49: 50: 53:
60: 62: 68: 70: 71: 75: 76: 79: 80: 81: 82: 83:
84: 97: 98:
TOTALS
08101 BALANCE
08/31 INCOME
EXPENSE
14,065.68 355.67 8,181.23 6.88 438.59 390.21 16,034.88 340.00 12,856.49 3,240.97 3,269.51 25.00 190.38 105.00 0.00 648.20 0.00 1,075.00 4,648.20 14,395.28 -7,846.56
$266.98 347.75 40.00 0.00 140.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 420.00 1,211.00 0.00 OJKl 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 250.00 0.00 0.00 235.00 0.00 450.00 0.00 0.00 -266.98
-$250.99 -400.00 0.00 0.00 0.00 0.00 0.00 0.00 -90.00 0.00 0.00 0.00 0.00 -5,920.00 0.00 -700.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 0.00 0.00 0.00 -202.50 0.00
$1,912.35 2,570.98 15,771.17 3,772.41 11,511.26 6,773.36 5,216.78 7,082.16 9,347.63 4,801.20 778.02 4,132.41 429.09 9,356.68 355.67 7,481.23 6.88 438.59 390.21 16,034.88 340.00 12,856.49 3,240.97 3,269.51 25.00 440.38 105.00 0.00 883.20 0.00 1,525.00 4,648.20 14,192.78 -8,113.54
0.00
0.00
0.00
0.00
$146,045.69
3,o93.75
-7,563.49
141,575.95
$1,896.36 2,623.23 15,731.17 3,772.41 11,371.26 6,773.36 5,216.78 7,082.16 9,437.63 4,801.20 778.02 4,132.41 9.()9
Aberdeen Parks & R« Website: http:/11nnv.abenleenpr.mmrmdex.htm.l
1
II. DEPOSITS BY PROGRAM DATE
AMOUNI
DESCRIPTION
** Prowam 01: GENERAL FUND 8/5/2015 $15.99 City$- Postal svc (mon) 8/13/2015 $100.00 City$- Postal refill 8/18/2015 $35.00 City$- IRS 990 website software 8/19/2015 $100.00 City$- IRS 990 return preparation fee ** Subtotal $250.99 **Program 03: GOLDEN AGE CLUB 8/12/2015 $15.00 Dues 8/12/2015 $16.00 Bounty Share 8/12/2015 $74.00 Applebee's fundraiser 8/12/2015 $48.00 Banquet tickets 8/12/2015 $3.75 Greeting card sales 8/18/2015 $115.00 Applebees 8/18/2015 $10.00 Donation (Applebees) 8118/2015 $18.00 Bounty Share 8/18/2015 $11.25 Greeting card sales 8/26/2015 $18.75 Bounty Share 8/26/2015 $18.00 Donations **Subtotal $347.75 **Prowam06: BALLETflAZVTAP 8114/2015 $40.00 Registrations **Subtotal
$40.00
**Program 09: SOCCER 8/6/2015 $140.00 Registrations **Subtotal
$140.00
** Program 31: YOUTH SOFTBALL 8/28/2015 $420.00 Mise **Subtotal
$420.00
** Program 40: FOOTBALL 8/12/2015 $50.00 Donations 8112/2015 $516.00 Trunkerfest 8/12/2015 $645.00 Registrations **Subtotal
$1,211.00
**Program 79: WARDLE SOCCER CAMP&TOURN 8/11/2015 $250.00 Registrations **Subtotal $250.00 ** Prowam 82: ROLLER DERBY (HELLIONS) 8/20/2015 $235.00 Mise **Subtotal
$235.00
,...
;c:.
II. DEPOSITS BY PROGRAM DATE
AMOUNT
DESCRIPTION
**Program 84: LACROSSE 8/13/2015 $450.00 Fundraising **Subtotal
$450.00
** Program 99: CITY $HOlDING ACCT 8/5/2015 -$15.99 TFR City$ to GEN FUND {Postal Svcv) 8/13/2015 -$100.00 TFR City$ to GEN FUND (Postal refill) 8/18/2015 -$35.00 TFR City$ to GEN FUND (IRS 990 software) 8/19/2015 -$100.00 TFR City$ to GEN FUND (IRS preparation fee) ** Subtotal -$250.99 *** Total Deposits
$3,093.75
3
Ill. CHECKS BY PROGRAM DATE
CHK NR
PAYEE
**Program 01: GENERAL FUND 08/19/2015 26063 Gene A GaU 08/05/2015 VISA Stamps.com 08/13/2015 VISA Stamps.com 08/18/2015 VISA Urban Institute 990 Online **Subtotal ** Program 03: GOLDEN AGE CLUB 08/09/2015 26055 Jim DeBusk 08/25/2015 26066 Elizabeth Myers **Subtotal ** Program 15: AIKIDO 08/25/2015 26067 James 0 SheU **Subtotal ** Program 40: FOOTBALL 08/18/2015 26058 Sanford Fisher 08/18/2015 26059 Troy Malloy 08/18/2015 26060 UCYFL 08/19/2015 26064 AIJ Pro Team Sports **Subtotal
AMOUNT $100.00 $15.99 $100.00 $35.00
DESCRIPTION IRS 990 return preparation fee Posta1 svc (mon) Postage refill IRS 990 software $250.99
$150.00 Entertainment (08/18/15) $250.00 Petty cash (donuts, etc) $400.00
$90.00 Salary (May) 7 hrs, (Jun) 8 hrs@ $6 $90.00
$1,400.00 $1,800.00 $600.00 $2,120.00
Concession start-up Referee fees Team entry fees Uniforms $5,920.00
**Program 49: NORTH BAY RUGBY YOUTH PGM 08/04/2015 26052 Potomac Society ofRugby Football Refs **Subtotal
$700.00 5 boys+ 2 girls @$100 ea [#2015-58] $700.00
** Program 98: COUNCIL$ HOLDING ACCT 08/18/2015 26062 Tom Anderson 08/25/2015 26065 Protect Youth Sports **Subtotal
$120.00 Change Jocks at .AHS $82.50 Background checks $202.50
***Total Checks
$7,563.49
CLEARED
08/24/2015 08/05/2015 08/13/2015 08/18/2015
08/18/2015 08/31/2015
08/31/2015
08/27/2015 08/28/2015 08/25/2015
08/11/2015
08/31/2015
IV. TREASURER'S NOTES
1. BUILDING CWSURE: a BACKGROUND: The Harford County Community Services building (also known as the old Elementary School) at 34 N. Philadelphia Blvd. has been the Aberdeen Recreation Council's headquarters for 40 years or so. b. FLOODING: On or about February 17, there was a power failure in the building which caused the heat to shut off and, with the frigid weather we've been experiencing, caused multiple pipes to break and extensive flooding to occur. c. ASSESSMENT: Engineers for the county subsequently inspected the building and determined the resulting damage will be too costly to repair. Consequently, they have permanently closed the building. d. INTERIM MEASURES: The building is now closed Don Ewing has a key if you have an urgent need to get something out of the building. We are still working on long-term storage arrangements e. MAIL FORWARDING: Our mail is currently forwarded to the Aberdeen City office at 60 N. Parke Street; Aberdeen, MD 21001. If soliciting donations, please have them sent to your home address. f CHECK REQUESTS: You may mail check requests and invoices to Kenny Wilson, 3 E. Aztec Street, Aberdeen, MD 21001-2003 or email scanned forms to bvilsan246@;,hoL.T.ail.com. g. FOR DEPOSIT ONLY STAMPS: Bank of America wants our account number on the back of each check you deposit We have extra For Deposit Only stamps with this info. Please email Kenny Wilson. 2. DEPOSIT SLIPS:
a Extra deposit slips? See Tim Getz. b. We will provide a For Deposit Only stamp (with our name and account#) to any program that needs one. Contact Kenny Wilson at 410-272-4510 or 'kwilson246@hotmailcom. c. Please list checks by name instead of number. d. All programs share the same accoWit Be sure to legibly print your Program Name below the Aberdeen Board of Parks and Recreation title bar. Please also jot down what the deposit is for (e.g., Registrations, Pizza FWidraiser, Sponsors, etc.); if multiple sources, please provide a breakdown (e.g., $102 Registrations, $200 FWidmiser). e. The deposit slips have 3 copies. The bank keeps the top (white) one and returns a pink and yellow copy to you. I can view most deposit slips online via our bank but maybe one deposit per month is not viewable due to technical problems.
IV. TREASURER'S NOTES (CONT)
3. FY 2014 CITY MONEY STATUS (SECTION VII): AU un-spent allocations were distributed to programs except GENERAL FUND allocations for the Annual Dinner and Postal Services.
4. FY 2015 CITY MONEY REQUESTS (SECTION VIII): Packets were mailed to Program Leaders the first week of Jan 2015. FY 2015 City Money Requests were due to me by 03/01/2015. We did not get an increase from the city. The Board did a "scrub" to trim total requests down to $20,000. The FY 2015 City Money budget is shown at Section VIII of this report These allocations became available to you as o£07/01/2015.
Kenneth W. Wilson, Treasurer Aberdeen Board of Parks & Recreation Website: www.aberdeenpr.com
6 7
V. FY2015 HOLDING ACCT As Of 0813112015
Assessment
=$5 per registrant
FY2014
JUL
AUG
SEP
Regs Amount Regs Amount Regs Amount Regs Amount PROGRAM ACCOUNT
01: 03: 06: 07: 09: 10: 11:
14: 15: 16: 20: 30: 31: 40: 43: 48: 49:
jso: 53: 60: 62: 67: 68: 70:
71: 75: 76: 79: 80: 81: 82: 83: 98:
General Fund Golden Age Club Ballet/Jazz/fap Gymnastics Soccer w eigbtlifting 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 & Tourn Field Hockey Roller Hockey Roller Derby (Harf C-0 Hellions) Plastic Model Club
Council Fund $ HoJding
140
$700
77
$385
93
$465
10
$50
6
$30 $250 $200 $710
50 40 142 80 180
$400 $900
36
$180
84
$420
14
$70
33
165
0
$0
130 14 0 13 5
$650
$70 $0 $65
$25
1147 -$5,735
$0
0
$0
$0
VI. FY 2015 LIABILITY INSURANCE $ HOLDING ACCT As Of 08131/2015
Assessment
=$2.50 per registrant
FY2014
JUL
Regs
Amount
55 140
$123.75 $350.00
77
$192.50
93 10 50 40 142 80 180
$232.50 $25.00 $15.00 $125.00 $100.00 $355.00 $200.00 $450.00
84
$210.00
14
$35.00
33
$82.50 $0.00
130 14 0 13 5
$325.00 $35.00 $0.00 $32.50 $12.50
1166
-$2,901.25
Regs
AUG
Amount
Regs
SEP
Amount Regs
Amount
PROGRAM ACCOUNT
01: 03: 06: 07: 09: 10: 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: 97:
General Fund Golden Age Club BalJet/Jazz/Tap Gymnastics Soccer Weightlifting BasketbalJ TaeKwonDo Aikido Wrestling Tennis BasebalJ Youth SoftbalJ Football North Bay Rugby Martial Arts Unlimited North Bay Rugby Youth Pgm Chess Club BasketbalJ Cheerleading Summer Concerts Parks/Special Events SwanFest Jean Davis Memorial Fund Special Projects Summer BasketbalJ Academy Track & Field Team Softball Co-op Wardle Soccer Camp & Tourn Field Hockey Roller Hockey Roller Derby (HatfCo Hellions) Plastic Model Club Liability Insurance Shares
6
$0.00
$0.00
$0.00
~~.l!!~f~iii;~Jt\~~iil~-f&*\fi~~H~~~w~'?lf~~~~.li~~~V~Iii~li VII. FY 2015 CITY BUDGET STATUS As Of 0813112015
BUDGETED 01: GENERAL FUND Computer/Office Equipment Fire/Treasurer Bond Premium Volunteer Recognition IRS-related expenses Postal svc/Biank forms/Postage refills Bookkeeping expense ( 12 months x $25) Legal Defense Fund Contingencies
USED
BALANCE
$500.00 $300.00 $1,000.00 $200.00 $500.00 $300.00 $100.00 $125.00
$171.56 $0.00 $0.00 $135.00 $131.98 $50.00 $0.00 $0.00
$328.44 $300.00 $1,000.00 $65.00 $368.02 $250.00 $100.00
$3,025.00
$488.54
$2,536.46
$400.00 $300.00
$0.00 $0.00
$400.00 $300.00
$300.00 $200.00 $200.00
$0.00 $0.00 $0.00
$300.00 $200.00 $200.00
$1,300.00 $300.00
$0.00 $0.00
$1,300.00 $300.00
$1,000.00 $400.00 $200.00
$0.00 $0.00 $0.00
$1,000.00 $400.00 $200.00
$50.00
$0.00 $75.00
$50.00
$75.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
31: SOFTBALL Fierld equipment - plates, plugs, pitchers mounds Liability insurance 1st aid ice packs, 1st aid kits
$300.00 $200.00 $100.00
$0.00 $0.00 $0.00
$300.00 $200.00 $100.00
$2,000.00 $2,000.00
$2,000.00 $2,000.00
$0.00
$1,200.00 $300.00
$0.00 $0.00
$1,200.00 $300.00
$300.00
$0.00
$300.00
$3,000.00 $450.00 $100.00
$3,000.00 $450.00 $100.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$300.00 $100.00 $100.00
$8,113.54
$11,886.46
SUBTOTAL 03:
GOLDEN AGE CLUB HP15 Laptop computer with Touch Smart display Epson EX3220 LCD projector
06: BALLET Teacher training lpadsllpods Barre cart 09: SOCCER Nets, whistles, balls, ball bags, needles, First aid kits, ice packs, shin guards
etc
11: BASKETBALL Replace old, worn & lost uniforms Leadership funds to help with custodial fees Replace First Aid kits, ice packs, etc 20: TENNIS New tennis balls USTA Clinics (3@$25) for instructors
40: FOOTBALL Replace womlold shoulder pads, medical supplies, New helmets 49: NORTH BAY YOUTH RUGBY USA Rugby liability insurance for HS boy & girl teams First Aid kit supplies for youth & 2 HS teams 53: BASKETBALL CHEERLEADING Portable all-in-one PA saystem/speaker 60: SUMMER CONCERTS Performer fees (10@$300) Site Coordinator's salary(10@$45) Banner date change 71: BASKETBALL ACADEMY Replace worn uniforms (pants & jerseys) Balls, whistles, scorebooks First aid kits TOTAL
$300.00 $100.00 $100.00
q
$20,000.00
$125.00
$0.00
$0.00