ABERDEEN BOARD OF PARKS & RECREATION MONTHLY TREASURER'S REPORT
2-Sep-14
I. PROGRAM SUMMARY 08/01
PROGRAM ACCOUNT 01: 03: 06: 07: 09: 10: II: 14: 15: 16: 20: 30: 31: 40: 43: 48: 49: 50: 60: 62: 67: 68: 70: 71: 74: 75: 76: 78: 79: 80: 97: 98: 99:
General Fund Golden Age Club Ballet/Jazz!fap Gymnastics Soccer Weightlifting Basketball TaeKwonDo Aikido Wrestling Tennis Baseball Youth Softball Football North Bay Rugby Martial Arts Unlimited North Bay Rugby Youth Pgm Chess Club Summer Concerts Parks/Special Events SwanFest Jean Davis Memorial Fund Special Projects Summer Basketball Academy AHS Summer Football Camp Track & Field Team Softball Co-op Zimmerman Lacrosse Camp Wardle Soccer Camp & Toum Field Hockey Liability Insurance Holding Acct Head Tax $ Holding Acct City $ Holding Acct
00:
Unclaimed Deposits
TOTALS
Aberdeen Parks & Rec: Website:
08/31
BALANCE
INCOME
EXPENSE
BALANCE
$1,320.54 1,854.47 12,323.15 3,981.41 9,805.39 6,681.23 568.41 6,393.16 9,246.63 4,934.04 1,155.55 6,005.36 3,993.37 5,614.23 535.67 10,526.73 3,875.51 6.88 240.21 18,909.69 2,328.34 540.00 3,914.08 256.35 2.65 3,269.51 25.00 0.01 844.03 210.00 3,829.10 10,040.00 -7,856.27
$205.02 147.00 760.00 0.00 240.00 0.00 0.00 0.00 0.00 0.00 330.00 998.56 0.00 7,088.00 0.00 0.00 0.00 0.00 0.00 200.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 -898.43
-$153.87 0.00 0.00 0.00 0.00 -24.44 -197.90 0.00 0.00 -600.00 -1,260.00 -744.56 -90.00 -2,449.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -200.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
$1,371.69 2,001.47 13,083.15 3,981.41 10,045.39 6,656.79 370.51 6,393.16 9,246.63 4,334.04 225.55 6,259.36 3,903.37 10,253.23 535.67 10,526.73 3,875.51 6.88 240.21 19,109.69 2,328.34 340.00 3,914.08 256.35 2.65 3,269.51 25.00 0.01 844.03 210.00 3,829.10 10,040.00 -8,754.70
0.00
0.00
0.00
0.00
$125,374.43
9,070.15
-5,719.77
128,724.81
II. DEPOSITS BY PROGRAM DATE
AMOUNT
DESCRIPTION
**Program 01: GENERAL FUND 8/5/2014 $15.99 City$- Postal svc (mon) 8/11/2014 $122.93 City$- Printer cartridges (6 color, 2 black) 8/25/2014 $14.95 City$- Internet svc (monthly) 8/29/2014 $50.60 HCCSB Pepsi machine revenue $0.55 Interest (Harford Natl) 8/31/2014 **Subtotal $205.02 **Program 03: GOLDEN AGE CLUB 3/16/1902 $15.00 Dues 8/4/2014 $30.00 Dues 8/4/2014 $31.00 Bounty Share 8/6/2014 $18.50 Bounty Share 8/29/2014 $52.50 Bounty Share **Subtotal
$147.00
**Program 06: BALLET/JAZZ/TAP $195.00 Registrations (3@$65) 8/7/2014 8/27/2014 $565.00 Registrations **Subtotal
$760.00
**Program 09: SOCCER 8/27/2014 $240.00 Registrations **Subtotal
$240.00
**Program 20: TENNIS 8/13/2014 $300.00 Registrations (10@$30) 8/13/2014 $30.00 Registration (1@$30) **Subtotal
$330.00
** Program 30: BASEBALL 8/12/2014 $744.56 City$- Equipment 8/27/2014 $254.00 Sponsors (2) **Subtotal
$998.56
II. DEPOSITS BY PROGRAM DATE
AMOUNT
DESCRIPTION
** Program 40: FOOTBALL
8/8/2014 8/8/2014 8/18/2014 8/18/2014 8/19/2014 8/20/2014 8/20/2014 8/22/2014 8/22/2014 8/29/2014 8/29/2014 8/29/2014
$50.00 $680.00 $1,584.00 $350.00 $342.00 $1,582.00 $1,011.00 -$33.00 -$12.00 $654.00 $630.00 $250.00
**Subtotal
Donation Registrations T-Shirt Sales Registrations T-Shirt Sales Fundraiser Fundraiser Bad Check (George Singer) Bad Chk Svc Chg (G. Singer) T-Shirt Sales Registrations Trip donation $7,088.00
** Program 62: PARK/SPECIAL EVENTS
8/14/2014 8/29/2014 ** Subtotal
$100.00 Festival Park reservation (St Joan of Arc) $100.00 Festival Pk res (Br of God Christ Fellowship) $200.00
** Program 99: CITY $ HOLDING ACCT
8/5/2014 8/11/2014 8/12/2014 8/25/2014 ** Subtotal *** Total Deposits
-$15.99 -$122.93 -$744.56 -$14.95
TFR City$ to GEN FUND (Postal svc) TFR City$ to GEN FUND (Printer cartridges) TFR City$ to BASEBALL (Equipment) TFR City$ to GEN FUND (Internet svc) -$898.43 $9,070.15
3
Ill. CHECKS BY PROGRAM DATE
CHK NR
PAYEE
AMOUNT
DESCRIPTION
CLEARED
** Program 01: GENERAL FUND 08/05/2014 VISA 08/11/2014 VISA 08/25/2014 VISA **Subtotal
Stamps.com Staples.com People PC Internet Svc
$15.99 Postal service (monthly) $122.93 Printer ink cartridges (6 color, 2 black) $14.95 Internet svc (Office PC) monthly
08/05/2014 08/11/2014 08/25/2014
$153.87
**Program 10: WEIGIITLIFTING 08/06/2014 25525 **Subtotal
Denton Spring Water Co.
$24.44 Water (#463864, 08/06/14)
08112/2014
$24.44
**Program 11: BASKETBALL 08/06/2014 25526 **Subtotal
Harford County MD
$197.90 Custodian (Henderson Tournament- 06/30/14) 08/18/2014
$197.90
** Program 16: WRESTLING 08/2112014 25533 **Subtotal
Bethel Apostolic Church
$600.00 Donation for gym usage for practices
$600.00
** Program 20: TENNIS 08/13/2014 25519 Ely Jaffe 08/13/2014 25529 Micha Jaffe **Subtotal
$630.00 Salary (42 hrs@ $15) $630.00 Salary (47 hrs@ $10)
08/22/2014
$1,260.00
** Program 30: BASEBALL 08/12/2014 VISA **Subtotal
BSN Sport Supply Group
$744.56 Equipment
08/12/2014
$744.56
** Program 31: YOUTH SOFTBALL 08/21/2014 25531 **Subtotal
Trophy World LLC
$90.00 Trophies (9@$10) #24059
08/25/2014
$90.00
** Program 40: FOOTBALL 08/20/2014 25530 08/21/2014 25532 **Subtotal
Upper Chesapeake Youth Football League Qual Mar LLC
$440.00 League fees (8 teams@ $55) $2,009.00 Hoodies & t-shirts for parents
08/29/2014 08/27/2014
$2,449.00
** Program 68: JEAN DAVIS MEMORIAL FUND 08/13/2014 25518 **Subtotal
*** Total Checks
Carrie Varela
$200.00 Scholarships
08/20/2014
$200.00 $5,719.77
IV. BOOKKEEPER'S NOTES
1. TREASURER NOTES: a LIABILITY INSURANCE: The Board of Education (BOE) now requires recreation councils to Show proof of a large liability insurance policy as a condition of using BOE property/facilities. Hostetter Insurance Agency of Aberdeen brokered this policy for us and obtained the lowest premium of any other recreation council in Harford County; they also generously donated $1,000 toward this premium.
2. DEPOSIT SLIPS:
a Extra deposit slips are kept in the office on the shelf below the mailboxes. b. We will provide a For Deposit Only stamp (with our name and account#) to any program that needs one. If you lose it, a replacement costs $20.35. Contact Kenny Wilson at 410-272-4510. c. Please list checks by name instead of number. d. All programs share the same account 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 Fundraiser, Sponsors, etc.); if multiple sources, please provide a breakdown (e.g., $102 Registrations, $200 Fundraiser). e. The deposit slips have 3 copies. The bank keeps the top (white) one and returns a pink and yellow copy to you. Please forward the pink copy to me so I can keep our records up to date. You may leave it in the Deposit Slip docket in the office mailbox Gust above the Check Request docket); you may also mail it to me at the office address (Aberdeen Parks & Rec, 34 N. Philadelphia Blvd., Aberdeen, MD 21001-2511). If you fail to do so, your account may be understated. I can view most deposit slips online via our bank but maybe one deposit per month is not viewable due to technical problems.
3. CHECK REQUESTS:
a Blank check requests are kept in the office on the shelf beneath the mailboxes. Requests under $200 may be approved by your Board liaison; requests over $200 must be approved by the Board (at a monthly meeting or via a phone poll conducted by your liaison) befOre Parks & Rec funds are obligated. Exceptions: monthly salaries and recurring expenses, then case-by-case basis. b. Please leave the completed request in the Check Request docket of the mailboxes in the office. Alternatively, you may mail them (using the address in 2e above).
W. TREASURER'S NOTES (CONT)
4. FY 2014 CITY MONEY REQUESTS: Packets were mailed to Program Leaders the first week of Jan 2014. FY 2014 City Money Requests were due to me by 03/01/2014. The Board has done an unofficial "scrub" (Section Vll) to trim total requests down to $20,000 (the same amount we received this year) but are still awaiting word from the Aberdeen Commissioners on how much we will get. These allocations are for the fiscal year starting 07/01/2014.
Gene Gall, Bookkeeper Aberdeen Board ofParks & Recreation Website: \vww.aberdeenpr.com
V. FY 2013 HEAD TAX ASSESSMENTS As Of 08/31/2014 MAY
JUN
JUL
AUG
Assessment = $5 per registrant 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: 50: 60: 62: 67: 68: 70: 71: 74: 75: 76: 77: 78: j79: 80:
General Fund Golden Age Club Ballet/Jazzffap Gymnastics Soccer Weightlifting Basketball TaeKwonDo Aikido Wrestling Tennis Baseball Youth Softball Football North Bay Rugby Martial Arts Unlimited North Bay Rugby Youth Pgm Chess Club Summer Concerts Parks/Special Events SwanFest Jean Davis Memorial Fund Special Projects Summer Basketball Academy AHS Summer Football Camp Track & Field Team Softball Co-op Harford County Lacrosse Zimmerman Lacrosse Camp Wardel Soccer Camp & Tourn Field Hockey
98:
Head Tax $ Holding
0
138
$690
42
$210
82
$410
49
$245
180
$900
152
$760
160
$800
$0
62
$310
0
$0
-$310
7
-$4,015
$0
$0
VI. FY 2013 LIABILITY INSURANCE ASSESSMENTS As Of 08/31/2014
IMAY
JUN
JUL
AUG
Assessment= $2.50 per registrant Regs
Amount
Regs
Amount
138 42
$345.00 $105.00
82
$205.00
49 180
$122.50 $450.00
152
$380.00
160
$400.00
Regs
Amount Regs
Amount
PROGRAM ACCOUNT
78: 79: 80:
General Fund Golden Age Club Ballet/JazzJTap Gymnastics Soccer Weightlifting Basketball TaeKwonDo Aikido Wrestling Tennis Baseball Youth Softball Football North Bay Rugby Martial Arts Unlimited North Bay Rugby Youth Pgm Chess Club Summer Concerts Parks/Special Events SwanFest Jean Davis Memorial Fund Special Projects Summer Basketball Academy AHS Summer Football Camp Track & Field Team Softball Co-op Harford County Lacrosse Zimmerman Lacrosse Camp Wardel Soccer Camp & Tourn Field Hockey
97:
Liab Insurance $ Holding
01: 03: 06: 07: 09: 10: 11: 14: 15: 16: 20: 30: 31: 40: 43: 48: 49: 50: 60: 62: 67: 68: 70: 71: 74: 75: 76:
77:
0
$0.00
62
$155.00
0
$0.00
-$155.00
-$2,007.50
$0.00
$0.00
VI. FY 2014 CITY BUDGET STATUS As Of 0813112014
USED
BALANCE
$600.00 $156.00 $374.00 $900.00 $200.00 $500.00 $300.00
$298.26 $29.90 $0.00 $0.00 $0.00 $131.98 $0.00
$301.74 $126.10 $374.00 $900.00 $200.00 $368.02 $300.00
Legal Defense Fund
$100.00
$0.00
$100.00
Contingencies
$200.00
$0.00
$200.00
$3,330.00
$460.14
$2,869.86
BUDGETED 01: GENERAL FUND Computer/Office Equipment Internet- Office PC Fire/Treasurer Bond Premium Volunteer Recognition IRS-related expenses Postal svc/Biank forms/Postage refills Bookkeeping expense (12 months x $25}
SUBTOTAL 06: BALLET Master classes for instructors
$400.00
$0.00
$400.00
IPads for instructors that don't have one
$200.00
$0.00
$200.00
$0.00
$1,000.00
$1,300.00
$0.00
$1,300.00
$300.00
$0.00
$300.00
07: GYMNASTICS
UabHity Insurance
$1,000.00
09: SOCCER Nets, whistles, baHs, ball bags, needles,
etc
First aid kits, ice packs, shin guards 11: BASKETBALL Replace old,
worn & lost uniforms
$1,000.00
$0.00
$1,000.00
Balls, whistles, lanyards, scorebooks, etc
$200.00
$0.00
$200.00
First Aid Supplies
$300.00
$0.00
$300.00
New tennis balls
$50.00
$0.00
$50.00
USTA crmics (3@$25) for instructors
$75.00
$0.00
$75.00
$1,500.00
$744.56
$755.44
$300.00
$0.00
$300.00
$745.00
$0.00
$745.00
$4,000.00
$4,000.00
$0.00
$1,200.00
$0.00
$1,200.00
$300.00
$0.00
$300.00
20: TENNIS
30: BASEBALL Catchers gear, baseballs, equip bags, ump equip First Aid kits, ice packs, etc 31: SOFTBALL Equipment 40: FOOTBALL Recertification of 200 helmets 49: NORTH BAY YOUTH RUGBY USA Rugby 6ability insurance (80 @ $30) First Aid kits (2) 60: SUMMER CONCERTS Performer fees (10@$300)
$3,000.00
$3,000.00
$0.00
Site Coordinator's salary(10@$45)
$450.00
$450.00
$0.00
Banner date change
$100.00
$100.00
$0.00
$0.00
$250.00
71: BASKETBALLACADEMY Equipment TOTAL
$250.00 $20,000.00
$8,754.70
$11,245.30