TOTALS Aberdeen Parks & Rec Website

Report 7 Downloads 103 Views
ABERDEEN BOARD OF PARKS & RECREATION MONTHLY TREASURER'S REPORT JULY2014

I. PROGRAM SUMMARY 07/01 PROGRAM ACCOUNT

62: 67: 68: 70: 71: 74: 75: 76: 78: 79: 80: 97: 98: 99:

General Fund Golden Age Club Ballet/Jazz/Tap Gymnastics Soccer W eightlifting 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 & Tourn Field Hockey Liability Insurance Holding Acct Head Tax $ Holding Acct City $ Holding Acct

00:

Unclaimed Deposits

01: 03: 06: 07: 09: 10: ll: 14: 15: 16: 20: 30: 31: 40: 43: 48: 49: 50:

60:

TOTALS

Aberdeen Parks & Rec Website:

07/31

BALANCE

INCOME

EXPENSE

BALANCE

$1,26139 2,067.97 12,506.35 3,981.41 9,565.39 6,698.52 -283.25 6,393.16 9,236.63 4,934.04 275.55 6,530.36 3,993.37 5,486.23 2,035.67 10,526.73 4,483.83 6.88 -3,309.79 18,309.68 2,428.34 615.00 3,914.08 968.01 2.65 3,269.51 25.00 0.01 4,864.03 0.00 3,829.10 10,040.00 0.00

$463.37 111.50 510.00 0.00 240.00 0.00 851.66 0.00 100.00 0.00 880.00 0.00 0.00 5,068.00 0.00 0.00 0.00 0.00 3,550.00 600.00 0.00 0.00 0.00 -711.66 0.00 0.00 0.00 0.00 1,580.00 210.00 0.00 0.00 -7,856.27

-$404.22 -325.00 -693.20 0.00 0.00 -17.29 0.00 0.00 -90.00 0.00 0.00 -525.00 0.00 -4,940.00 -1,500.00 0.00 -608.32 0.00 0.00 0.00 -100.00 -75.00 0.00 0.00 0.00 0.00 0.00 0.00 -5,600.00 0.00 0.00 0.00 0.00

$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.68 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

0.00

0.00

0.00

0.00

$134,655.85

5,596.60

-14,878.03

125,374.42

II. DEPOSITS BY PROGRAM DATE

AMOUNT

DESCRIPTION

** Program 01: GENERAL FUND 07/07/14 $141.00 City$- Adobe PDF software 07/07/14 $14.95 City$- Internet svc (Office PC) 07/07/14 $34.33 City$- Mouse replacement (Treas) 07/07/14 $100.00 City$- Postage refill 07/07/14 $15.99 City$- Postal svc 07/31114 $58.60 HCCSB Pepsi machine revenue 07/31114 $0.55 Interest (Harford Natl) 07/31114 $97.95 Accidental credit card charges reimb (Gall) **Subtotal

$463.37

** Program 03: GOLDEN AGE CLUB 07/16/14 $15.00 Dues 07/02114 $17.50 Bounty Share 07/09/14 $19.50 Bounty Share 07/16/14 $19.50 Bounty Share 07/16114 $40.00 Greeting Card Sales **Subtotal

$111.50

**Program 06: BALLET/JAZZ/TAP 07/23/14 $510.00 Registrations ** Subtotal

** Program 09: SOCCER 07/25/14 $240.00

$510.00

Registrations

**Subtotal

$240.00

** Program 11: BASKETBALL 07/11114 $851.66 TFR un-spent FY13 City$ to BASKETBALL ** Subtotal

**Program 15: AIKIDO 07/18/14 $100.00

$851.66

Registrations

** Subtotal

** Program 20: TENNIS 07/21114 $880.00 **Subtotal

$100.00

Registrations $880.00

II. DEPOSITS BY PROGRAM DATE

AMOUNT

DESCRIPTION

** Program 40: FOOTBALL 07/16/14 $4,000.00 City$- Shoulder pads & cleats 07/28/14 ($150.00) Bad Check (Harold Blume 3rd) 07/28/14 ($12.00) Bad Chk Svc Chg (H. Blume) $250.00 Cleats 07/17/14 07/01114 $340.00 Registration & Cleats 07/24/14 $640.00 Registration & Cleats $5,068.00

**Subtotal

** Program 60: SUMMER CONCERTS 07/01114 $3,550.00 City$- Performers, Attendant, Banner ** Subtotal

$3,550.00

** Program 62: PARK/SPECIAL EVENTS 07/03/14 $100.00 Festival Park reservation 07111114 $100.00 Festival Park reservation 07/25114 $100.00 Festival Park reservation $300.00 Festival Park reservations (2) 07/17/14 ** Subtotal

$600.00

** Program 71: SUMMER BASKETBALL ACADEMY 07/09/14 $140.00 Registrations 07/11114 ($851.66) TFR un-spent FY13 City$ to BASKETBALL **Subtotal

($711.66)

**Program 79: WARDLE SOCCER CAMP&TOURN 07/31114 $300.00 6x6 registrations 07/11/14 $1,250.00 Registrations 07/21114 $30.00 Registrations (2@$15) **Subtotal

$1,580.00

** Program 80: FIELD HOCKEY 07/11114 $180.00 Registrations (12@$15) 07/25/14 $30.00 Registrations (2@$15) **Subtotal

$210.00

** Program 99: CITY $HOLDING ACCT 07/01114 ($3,550.00) TFR City$ to CONCERTS- Peformers, etc 07/16/14 ($4,000.00) TFR City$ to FOOTBALL (Shldr Pads&Clts) 07/07/14 ($14.95) TFR City$ to GEN FUND (Internet svc) 07/07/14 ($34.33) TFR City$ to GEN FUND (Mouse) 07/07/14 ($141.00) TFR City$ to GEN FUND (PDF software) 07/07/14 ($100.00) TFR City$ to GEN FUND (Postage refill) 07/07/14 ($15.99) TFR City$ to GEN FUND (Postal svc) ** Subtotal

($7,856.27)

***Total Deposits

$5,596.60

Ill. CHECKS BY PROGRAM DATE

CHK NR

PAYEE

AMOUNT

DESCRIPTION

CLEARED

** Program 01: GENERAL FUND 07/07/20 14VISA 07/07/20 14VISA 07/07/2014VISA 07/07/2014VISA 07/07/20 14VISA 07/07/20 14VISA 07/1 0/2014VISA 07/14/20 14VISA 07/14/20 14VISA 07/17/2014VISA 07/25/20 14VISA -Subtotal

Stamps.com Staples. com Stamps.com, Microsoft Amazon. com Microsoft Microsoft Microsoft Microsoft Microsoft People PC Int Svc

100.00 34.33 15.99 19.99 141.00 1.99 49.99 19.99 4.99 1.00 14.95

Postage refill Replacement mouse Postal service (monthly) Xbox (Josh Gall) accidental purchase Adobe Acrobat X Standard software (for the n Xbox (Josh Gall) accidental purchase Xbox (Josh Gall) accidental purchase Xbox (Josh Gall) accidental purchase Xbox (Josh Gall) accidental purchase Xbox (Josh Gall) accidental purchase Internet svc (Office PC)

07/07/2014 07/07/2014 07/07/2014 07/07/2014 07/07/2014 07/07/2014 07/10/2014 07/14/2014 07114/2014 07/17/2014 07/25/2014

404.22

** Program 03: GOLDEN AGE CLUB 07/04/201425509 07/16/201425528 -Subtotal

Harford Choral Society Elizabeth Myers

125.00 Singing performance (07/I5/14) 200.00 Petty cash (donuts, etc)

07/18/2014 07/21/2014

325.00

**Program 06: BALLET/JAZZffAP 07/03/201425507 07/03/201425508 -Subtotal

Harford County, MD Harford County, MD

213.65 Custodian PR #ll (5hrs 04/26, 4hrs 04/05) 479.55 Custodian PR #8 (14hrs 04/10-11, 4hs 03/29)

07/18/2014 07/18/2014

693.20

**Program 10: WEIGHTLIFITNG 07/02/201425506 -Subtotal

Denton Spring Water Co.

17.29 Water (Inv #462356, 07/02/14)

07/09/2014

17.29

** Program 15: AIKIDO 07/23/201425523 -subtotal

James 0. Shell

90.00 Salary (May-Jun) 12 hrs@ $6

07/28/2014

90.00

** Program 30: BASEBALL 07/04/201425510 07/04/201425511 07/04/201425512 -Subtotal

Dylan Brown Devon Grimes Adonai Fernandez

175.00 Umpire (5 gms@ $35) 175.00 Umpire (5 gms@ $35) 175.00 Umpire (5 gms@ $35)

07/08/2014 07/14/2014 07/08/2014

525.00

**Program40: FOOTBALL 07/I6/201425520 07/16/201425521 -Subtotal

All Pro A Team Sports All Pro A Team Sports

3,500.00 Shoulder pads (40 pr@ $87.50) 1,440.00 Cleats (48@$30)

07/21/2014 07/21/2014

4,940.00

** Program 43: NORTH BAY RUGBY 07/09/20142?516 -Subtotal

Potomac Society ofRugby Football Refs

1,500.00 Ref fees (15@$100) Mar-May 2014 1,500.00

07/22/2014

Ul. CHECKS BY PROGRAM DATE

CHK NR

** Program 49: 07/09/201425 514 07/09/201425515 07/16/201425527 -Subtotal

** Program 67: 07/30/201425524 -Subtotal

** Program 68: 07/04/201425513 -Subtotal

** Program 79: 07/16/201425522 -Subtotal

*** Total Checks

PAYEE

AMOUNT

DESCRIPTION

CLEARED

180.00 Referee (12 gms@ $15) 180.00 Referee (12 gms@ $15) 248.32 Food, end-of-season hosting

07/18/2014 07/18/2014 07/28/2014

NORTH BAY RUGBY YOUTH PGM Tristan Townsend Andrew Marinick Ellen L. Hickey

608.32

SWANFEST Craig Lanphear

I 00.00 Retirement dinner

07/31/2014

100.00

JEAN DAVIS MEMORIAL FUND Heather Piper

75.00 Scholarship

07/11/2014 75.00

WARDLE SOCCER CAMP&TOURN Gettysburg Soccer Camps

5,600.00 Camp fee for HS team 5,600.00 14,878.03

07/30/2014

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. b. ACCIDENTAL CHARGES: The Board approved the Treasurer's purchase of Microsoft Office 2013 software suite. The Treasurer used the Board's VISA card but this somehow became the default card for the Treasurer's personal account with Microsoft, resulting in 5 personal charges totaling $97.95 on the Parks & Rec account The Treasurer deposited his personal check to reimburse this amount on 07/31/14. 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 at410-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 (just 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).

G

IV. 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 VII) 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/0 112014.

Gene Gall, Bookkeeper Aberdeen Board of Parks & Recreation Website: wvvw.aberdeenpr.com

7

V. FY 2013 HEAD TAX ASSESSMENTS As Of 06101/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:

179: 80:

General Fund Golden Age Club Ballet/Jazz/Tap 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

11: 14: 15: 16: 20: 30: 31: 40: 43: 48: 49: 50: 60: 62: 67: 68: 70: 71: 74: 75: 76:

77: 78:

0

138 42

$690 $210

82

$410

49 180

$245 $900

152

$760

160

$800

$0

62

$310

0

$0

-$310

-$4,015

~

$0

$0

VI. FY 2013 LIABILITY INSURANCE ASSESSMENTS As Of 06/01/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

01: 03: 06: 07: 09: 10: 11: 14: 15: 16: 20: 30: 31: 40: 43: 48: 49: 50: 60: 62: 67: 68: 70: 74: 75: 76: 77: 78: 79: 80:

General Fund Golden Age Club Ballet/Jazz/Tap 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

71:

0

$0.00

62

$155.00

0

$0.00

-$155.00

-$2,007.50

q

$0.00

$0.00

VII. FY 2014 CITY BUDGET STATUS As Of 07/0112014 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)

$600.00 $156.00 $374.00 $900.00 $200.00 $500.00 $300.00

USED

BALANCE

$175.33 $14.95 $0.00 $0.00 $0.00 $115.99 $0.00

$424.67 $141.05 $374.00 $900.00 $200.00 $384.01 $300.00

Legal Defense Fund

$100.00

$0.00

$100.00

Contingencies

$200.00

$0.00

$200.00

$3,330.00

$306.27

$3,023.73

SUBTOTAL 06: BALLET Master classes for instructors

$400.00

$0.00

$400.00

!Pads 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

$1,000.00

$0.00

$1,000.00

$200.00

$0.00

$200.00

$300.00

$0.00

$300.00

New tennis baHs

$50.00

$0.00

$50.00

USTA Clinics (3@$25) for instructors

$75.00

$0.00

$75.00

$1,500.00

$0.00

$1,500.00

$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

07: GYMNASTICS Uability Insurance

$1,000.00

09: SOCCER Nets, whistles, balls, baH bags, needles,

etc

First aid kits, ice packs, shin guards 11: BASKETBALL Replace old, worn & lost uniforms Balls, whistles, lanyards, scorebooks,

etc

First Aid Supplies 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 liability 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(1 0@$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

10

$7,856.27

$12,143.73