CORRECTED MONTHLY TREASURER'S REPORT NOVEMBER 2016
I. PROGRAM SUMMARY
PROGRAM ACCOUNT
01: 03: 06: 09: 11: 14: 15: 16: 20: 30: 31: 40: 43: 49: 50: 53: 60: 62: 68: 70: 71: 75: 76: 79: 80: 81: 82: 83: 84: 85: 97: 98: 99:
General Fund Golden Age Club Ballet/Jazz/Tap Soccer Basketball TaeKwonDo (Golden Dragons) Aikido Wrestling Tennis Baseball Youth Softball Football North Bay Rugby North Bay Rugby Youth Pgm Chess Club Basketball Cheerleading Summer Concerts Parks/Special Events 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 Academy Liability Insurance $ Holding Acct Council $ Holding Acct City $ Holding Acct
00:
Unclaimed Deposits TOTALS
Aberdeen Parks & Rec Website:
11/01 BALANCE
INCOME
EXPENSE
11/30 BALANCE
$3,968.54 1,082.87 17,513.66 9,278.83 5,049.69 6,300.16 9,542.63 5,864.17 828.02 2,085.26 1,416.21 10,813.22 1,404.52 -648.62 6.88 1,515.09 299.96 16,034.88 340.00 11,954.39 5,530.63 3,178.51 25.00 -46.97 105.00 0.00 1,643.20 0.00 110.82 900.00 7,785.70 19,686.78 20,000.00
-$42.00 93.50 14,104.70 -813.69 8,295.00 0.00 350.00 0.00 0.00 1,107.50 0.00 0.00 -55.00 12,705.00 0.00 2,150.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 2,405.00 0.00 205.00 410.00 0.00
-$1,106.83 -333.40 -7,823.00 -1,710.00 -341.16 0.00 -102.00 -500.00 0.00 0.00 0.00 -4,857.86 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 -333.40 0.00 0.00 0.00 0.00
$2,819.71 842.97 23,795.36 6,755.14 13,003.53 6,300.16 9,790.63 5,364.17 828.02 3,192.76 1,416.21 5,955.36 1,349.52 12,056.38 6.88 3,665.09 299.96 16,034.88 340.00 11,954.39 5,530.63 3,178.51 25.00 -46.97 105.00 0.00 1,643.20 0.00 2,182.42 900.00 7,990.70 20,096.78 20,000.00
0.00
0.00
0.00
0.00
$163,569.03
40,915.01
-17,107.65
187,376.39
II. DEPOSITS BY PROGRAM DATE
AMOUNT
DESCRIPTION
** Program 01: GENERAL FUND 11123/2016 -$42.00 Check order from bank **Subtotal **Program 03: GOLDEN AGE CLUB 11/4/2016 $29.50 Bounty Share 11/4/2016 $19.00 Dues 11/17/2016 $30.00 Bounty Share 11/17/2016 $15.00 Greeting card sales **Subtotal **Program 06: 1112/2016 11/2/2016 11/2/2016 11/3/2016 11/3/2016 1114/2016 1114/2016 11/8/2016 11/9/2016 1119/2016 11121/2016 11/21/2016 1112112016 ** Subtotal
-$42.00
$93.50
BALLET/JAZZ/TAP $4,333.25 Joe Corbi Pizza Fundraiser $3,350.70 Joe Corbi Pizza Fundraiser $261.00 Joe Corbi Pizza Fundraiser -$64.75 Bad Check (Coleman Benson) -$12.00 Bad Chk Svc Chg (C Benson) -$17.00 Bad Check (Julie M. Bathel) -$12.00 Bad Chk Svc Chgh (J Bathel) $433.50 Joe Corbi Pizza Fundraiser -$410.00 TFR Council$ from BALLET (82*5) -$205.00 TFR Insurance $ from BALLET (82*2.50) $3,800.00 Costumes $1,830.00 Registrations $817.00 Sweatshirts $14,104.70
** Program 09: SOCCER 10/6/2016 -$1,107.50 11128/2016 $293.81 **Subtotal
Correct charge for Check #26426 (Trophies) LifeTouch photo rebate -$813.69
**Program 11: BASKETBALL 11/9/2016 $5,785.00 Registrations 11/17/2016 $895.00 12W Tvl Boys $1,615.00 Registrations 11/21/2016 ** Subtotal **Program 15: AIKIDO 11125/2016 $350.00 ** Subtotal
$8,295.00
Registrations $350.00
**Program 30: BASEBALL 10/6/2016 $1,107.50 Correct charge for Check #26426 (Trophies-Soccer) **Subtotal $1,107.50
II. DEPOSITS BY PROGRAM DATE
AMOUNT
DESCRIPTION
**Program 43: NORTH BAY RUGBY 10/13/2016 -$55.00 Correct charge for Check #26445 (Mens port-a-pot) ** Subtotal -$55.00 **Program 49: 10/13/2016 11110/2016 11112/2016 11116/2016 11/22/2016 **Subtotal
NORTH BAY RUGBY YOUTH PGM $55.00 Mis-charged for Check #26445 (Mens port-a-pot) $2,255.00 Registrations $1,800.00 VOID Check #26400 (stopped payment on lost check) $6,265.00 Registrations $2,330.00 Registrations $12,705.00
**Program 53: BASKETBALL CHEERLEADING 1114/2016 $665.00 Registrations 1114/2016 $355.00 Donation from Football 11/17/2016 $760.00 Registrations 11130/2016 $370.00 Registrations ** Subtotal
$2,150.00
** Program 84: LACROSSE 1114/2016 $1,045.00 Registrations 11/15/2016 $100.00 Bank adjustment to deposit (Registrations) 11115/2016 $780.00 Registrations $480.00 Registrations 11/22/2016 **Subtotal $2,405.00 ** Program 97: LIAB INSUR $HOLDING ACCT 1119/2016 $205.00 TFR Insurance$ from BALLET (82*2.50) $205.00 **Subtotal **Program 98: COUNCIL$ HOLDING ACCT 11/9/2016 $410.00 TFR Council$ from BALLET (82*5) ** Subtotal $410.00 *** Total Deposits
$40,915.01
Ill. CHECKS BY PROGRAM DATE
CHK NR
PAYEE
AMOUNT
DESCRIPTION
DATE CLEARED
**Program 01: GENERAL FUND 11107/2016 11115/2016 11115/2016 11/30/2016 11107/2016 11/21/2016 11129/2016
26472 26487 26488 26501 VISA VISA VISA
Office Centre Gene A. Gall Office Centre Erie Insurance Group Stamps.com Register. com Home Depot
**Subtotal
$420.00 $135.00 $23.85 $202.00 $15.99 $157.00 $152.99
Registration fonns (2000) #50632 Reimb IRS 990 software ($35) & Bookkeeping [Sept-0 Signature stamp Comm1 Fire Policy [Q241 050026] Postal svc (mon) Website domain name renewal (3 yrs) Stringed work lights (2), bulbs, oil, funnels
11/09/2016 11118/2016 11117/2016 12/05/2016 11/07/2016 11121/2016 11129/2016
$1,106.83
**Program 03: GOLDEN AGE CLUB 11115/2016 11115/2016 1112112016
26484 26485 26494
Elizabeth Myers Jacqueline Downing Jeff Teate
**Subtotal
$200.00 Petty cash (donuts, etc) $58.40 Flowers sent to Harriet Seese (10/31/16) $75.00 Entertainment (Magic Show) 11122/16
11117/2016 11/16/2016 11128/2016
$333.40
** Program 06: BALLET/JAZZ/TAP 11109/2016 11/15/2016 1112112016 11130/2016
26483 26486 26496 26499
Sybil Baker Joe Corbi's Fundraising Classic Team Sports Sarah J. Watt
**Subtotal
$70.00 $5,927.00 $806.00 $1,020.00
Refund due to illness & injury Pizza Fundraiser Sweatshirts (35) #36487 Salary (Nov) 34 hrs @$30
11114/2016 11116/2016 11129/2016 12/05/2016
End of year party End of year party End of year party End of year party End of year party End of year party RefU-11 & U-9 RefU-11 & U-9 Reffor U-11 & U-9 APG fees for 2016 ESSL Flight Series
11115/2016 11109/2016 11121/2016 11117/2016 11114/2016
$7,823.00
** Program 09: SOCCER 11107/2016 11108/2016 11108/2016 11108/2016 11/08/2016 11108/2016 11108/2016 11109/2016 11/09/2016 11/2112016
26474 26475 26476 26477 26478 26479 26480 26481 26482 26495
Scott Ryan Michelle Travers Larry Brown Angel Chavez J. J. Steigerwalt Nicole Ryan Jeff Sefa JoAnna Marlow Kevin Ryan Churchville Recreation Council
**Subtotal
$75.00 $75.00 $75.00 $75.00 $50.00 $75.00 $80.00 $80.00 $585.00 $540.00
11/14/2016 11123/2016
$1,710.00
** Program 11: BASKETBALL 1112112016
26498
Stephen Davis
**Subtotal
$341.16 Reimburse basketballs, etc [Olympia, 11/16]
11128/2016
$341.16
** Program 15: AIKIDO 11/30/2016
26500
James 0. Shell
**Subtotal
$102.00 Salary (Sept-Oct) 17 hrs @ $6
$102.00
**Program 16: WRESTLING 11/15/2016
**Subtotal
26489
UCWL
$500.00 UCWL League dues
$500.00
12/05/2016
Ill. CHECKS BY PROGRAM DATE
CHK NR
** Program 40: ll/08/2016 11/15/2016 11/15/2016 11/15/2016 11115/2016 1112112016 11/14/2016 **Subtotal
DESCRIPTION
$115.00 $1,088.00 $1,200.00 $1,200.00 $800.00 $396.36 $58.50
Reimbursement In-house Trophies Banquet (128) Banquet (128) End of year dinner Custodian H. Kenly (15 hrs.) 10/8/16 #17-049 Funeral flowers for Football staff member
DATE CLEARED
Christina Jones Tri-State Trophies Golden Corral! Golden Corral! Sanford A. Fisher Harford Co MD Dee's Flowers & Gifts
12/05/2016 11114/2016
$4,857.86 LACROSSE
11107/2016 26473 **Subtotal
*** Total Checks
AMOUNT
FOOTBALL
26333 26490 26491 26492 26493 26497 VISA
** Program 84:
PAYEE
Chris Allen
$333.40 6x6 Lax goals (4)
$333.40 $17,107.65
11/10/2016
V. TREASURER'S NOTES 1. CORRECTIONS TO OCTOBER REPORT: a. 10/06/2016: Check 26426 for BASEBALL's trophies was originally shown as SOCCER. b. 10/13/2016: Check 26445 for RUGBY MEN's port-a-pot was originally shown as YTH RUGBY. 2. MISCELLANEOUS: a. 11/12/2016: Check 26400 to Potomac Society of Rugby Football Referees for $1800 (Referee fees (18 games @ $100) #H24-H25) was lost and re-issued as Check 26427. A stop order for Check 26400 was setup with our bank but required a 24-48 hour delay before effective. Due to this lapse, I forgot to void the original check so did so on 11/12/2016 (putting the voided $1800 back in YTH RUGBY's account). b. 11115/2016: The bank found an additional check in a LACROSSE deposit which increased it by $100. c. 11/23/2016: Kenny Wilson was running out of checks so ordered more thru our bank. They issued a debit memo charging our account for the $42 cost.
Gene Gall, Treasurer [
[email protected]] Aberdeen Board of Parks & Recreation Website: www .aberdeenpr.com
:~Ytif:~~ti~~~~~~:~~iE;:~tfftt~~0:i~;~);;t:~~~{~!~1~~~~~~~~~i~f~fo1t4~~~t~~J~~ffi;~;~tr;t1Jf~~1i~~¥~~l¥~~~TtH11g%¥ V. FY 2016 COUNCIL$ HOLDING ACCT As Of 11/30/2016 FY 2015
FY 2016
Assessment = $5 per registrant Regs Amount
Regs
Amount
82
139 60 185 36
$565 $505 $615 $0 $0 $315 $0 $695 $300 $925 $180
0 0 0 0
$410 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
98
$490
0
$0
31
$155
0
$0
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:
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
98:
Council Fund $ Holding
113 101 123 63
0 0
0
177
$750 $0 $150 $0 $0 $885
0
1321
$6,605
82
150 30
0 0
$0 $0 $0 $0 $0 $0 $0 $410
.,
:~~~~~~~~i~~~~~~!1§1t~~r~~is~t~~~~~~~~: :-, ~ '~~ ~ ~:~:~~~;~!~~y~·~~;/ ~:~::~~~;:;~-~~: ~ ~-~~ ~~~ ~ :tz~: -~~~{~~ ~~ :-:-;~~: ~~~ ~ -~ ;~:._:~}:;~ ~~> ~ : ~~{~~ ~~ _ ~~~~: ~~~ ~~ - ~~~~ ~ ~,~s~~;~£J:-~~J: VI. FY 2016 LIABILITY INSURANCE$ HOLDING ACCT As Of 11/30/2016
Assessment
=$2.50 per registrant
FY 2015 Regs
FY 2016 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 BalleVJazzJTap 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 & Tourn 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
98
0 0 0
0.00 $205.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$245.00
0
$0.00
31
$77.50
0
$0.00
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 0 0
0
0 0
0 82
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $205.00