Reconciliation Summary

Report 2 Downloads 112 Views
1 :39 PM

Wayland Athletic Boosters Club

Reconciliation Summary

09/12/15

United Bank Checking , Period Ending 08/31/2015 Aug31 ,1 5 Beginning Balance Cleared Transactions Checks and Payments - 25 items Deposits and Credits - 10 items Total Cleared Transactions

34 ,570.41 -18,133.61 23 ,880.08 5,746.47

Cleared Balance Uncleared Transactions Checks and Payments - 5 items Total Uncleared Transactions

40,316.88 -3 ,933 .83 -3 ,933 .83

Register Balance as of 08/3112015 New Transactions Checks and Payments - 12 items Deposits and Credits - 5 items Total New Transactions Ending Balance

36,383.05 -7 ,638 .19 9,682 .26 2,044 .07 38,427.12

Page 1

1:44 PM

Wayland Athletic Boosters Club

Profit & Loss

09/12/15

January through September 2015

Accrual Basis

Jan - Sep 15 Ordinary Income/Expense Income Advertising with Boosters Boosters Bash Boosters Bash Ticket sales Donations Raffle & Auction Sales

14,875.00 9,500 .00 270 .00 7,905 .00

Total Boosters Bash Concessions Receipts Football Concessions Soccer; boys concessions Soccer; girls concess ions Start up cash/change funds Concessions Receipts - Other

17,675 .00 10,606 .61 962 .15 796 .21 0.00 -60 .30

Total Concessions Receipts Direct Public Support Corporate Contributions Legacies and Bequests Bill Merchant Volleyball Bill Merchant; basketball Bill Merchant; softball Legacies and Bequests - Other Total Legac ies and Bequests Total Direct Public Support Indirect Public Support Investments Interest-Savings, Short-term CD

12,304 .67 200.00 280.00 290.00 420.00 500.00 1,490.00 1,690 .00 67 .12 2.23

Total Investments Other Types of Income Credit Card Sales Miscellaneous Revenue Other Types of Income - Other Total Other Types of Income

Total Income Gross Profit Expense Awards and Grants Banking Fees Credit Cards Fees

2.23 154.70 20.24 18,662 .03 18,836.97 65,450.99 65,450 .99 135.40 43.45

Total Banking Fees Boosters Bash - Expense Boosters Decorations Cash Drawings Promotional Giveaways Boosters Bash - Expense - Other Total Boosters Bash - Expense Business Expenses Business Registrati on Fees Business Expenses - Other Total Business Expenses Coach ing Cl inics/Sem inars Tennis cl inics Coaching Cl inics/Sem inars - Ot her Total Coaching Cl inics/Seminars

43.45 160.98 2,200 .00 232 .90 3,526 .00 6,119.88 761.00 4,402 .96 5,163.96 120.00 300.00 420.00

Page 1

1:44 PM

Wayland Athletic Boosters Club

09/12/15

Profit & Loss January through September 2015

Accrual Basis

Jan - Sep 15 Concessions Supplies Boys Soccer Football Game Pizza Concessions Supplies - Other Total Concessions Supplies Contract Services End Zone Sign Vendor Outside Contract Services Total Contract Services Facilities and Equipment Equip Rental and Maintenance Facilities and Equipment - Other Total Facilities and Equipment Operations Postage, Mailing Service Printing and Copying Total Operations Other Types of Expenses Banner Signs Other Costs Total Other Types of Expenses Specific Sport Boys Basketball Cheer Football Girls Basketball Golf Soccer Softball Volleyball Wrestling Specific Sport - Other Total Specific Sport Total Expense Net Ordinary Income Other Income/Expense Other Income Interest Income Total Other Income Net Other Income Net Income

33.00 400.00 15,811 .92 16,244 .92 1,287 .00 2,425.57 3,712 .57 2,065 .92 2,444 .73 4,510 .65 19.60 142.32 161 .92 750.00 258 .35 1,008 .35 520 .00 10.00 3,663.00 146.00 840 .00 100.00 1,888.70 817.82 8.75 803 .75 8,798 .02 46,319 .12 19,131 .87

9342 9342 9342 19,225.29

Page 2

1:21 PM

Wayland Athletic Boosters Club

09/12/15

Deposit Detail August through September 2015 Type Deposit

Num

Date

Name

8/13/2015 Northern Physical T Kathleen Reagan Jack & Erin Sopjes Angela & Michael S .. Lisa & Matt Edney Ronald & Pamela H... Tim & Janice Reed Brett & Juliette Sloan Justin Wilson Heather LaHuis Gianni Marchesotti Eric & Kristy Johnson Cash Hastings City Bank

Account United Bank Chee ...

2,050.00

Boosters Bash Tick ... Boosters Bash Tick ... Boosters Bash Tick ... Boosters Bash Tick .. Boosters Bash Tick .. Boosters Bash Tick .. Boosters Bash Tick .. Boosters Bash Tick .. Boosters Bash Tick .. Boosters Bash Tick .. Boosters Bash Tick .. Boosters Bash Tick ... Boosters Bash Tick .. Donations

-200 .00 -50 .00 -100 .00 -100 .00 -100 .00 -100 .00 -100 .00 -100 .00 -100.00 -50.00 -50.00 -100.00 -800.00 -100.00

TOTAL Deposit

-2 ,050.00 8/17/2015 Todd & Julie Fox John & Barbara Mar ... Richard & Julie Boyle Jennifer & Paul Mor .. . Diane Fugate Jodi & Troy Sevigny Travis & Heather S .. Cinnamon & Scott ... Michael & Amanda . Carrie & Jeremy Ha .. David & Julie Jenison Steve & Theresa D... Carl & Michelle Co ... Cash

United Bank Chee ...

1,420.00

Boosters Bash Tick .. Boosters Bash Tick .. Boosters Bash Tick .. Boosters Bash Tick .. Boosters Bash Tick .. Boosters Bas h Tick .. Boosters Bash Tick .. Boosters Bash Tick Boosters Bash Tick ... Boosters Bash Tick .. Boosters Bash Tick ... Boosters Bash Tick ... Donations Boosters Bash Tick ...

-100.00 -100.00 -100.00 -100.00 -100.00 -100.00 -100.00 -100.00 -100.00 -100.00 -100.00 -100.00 -20 .00 -200 .00

TOTAL Deposit

-1 ,420 .00 8/24/2015

United Bank Chee ... Keith Nickels Nicole Cardosa Jack & Amy Chesley Travis Wilcox Lisa Gray David & Robin Kota .. Mark & Cheri Shep ... Ron & Theresa Hu .. Carl & Michelle Co ... Mike & Leigh Holtz Abe & Sandy Vand .. David & Jodi Modre .. Cash

TOTAL

Amount

Boosters Boosters Boosters Boosters Boosters Boosters Boosters Boosters Boosters Boosters Boosters Boosters Boosters

Bash Tick .. Bash Tick. Bash Tick .. Bash Tick ... Bash Tick ... Bash Tick .. Bash Tick .. Bash Tick .. Bash Tick ... Bash Tick .. Bash Tick .. Bash Tick ... Bash Tick ..

1,700.00 -100.00 -100.00 -100 .00 -100.00 -100.00 -100 .00 -100 .00 -100 .00 -100 .00 -100 .00 -100.00 -100 .00 -500.00 -1,700.00

Page 1

Wayland Athletic Boosters Club

1 :21 PM

Deposit Detail

09/12/15

August through September 2015 Type

Num

Deposit

Payment Payment Payment Payment Payment Payment

Date

Name

8/24/2015

2081 10586 8973 8417 1023 .. 11797

8/24/2015 8/25/2015 8/25/2015 8/25/2015 8/25/2015 8/25/2015

Cash Tom Cutler Cash Joe & Kathy Rybiski Dr. Ron House Amerprise Financial. .. United Collision Ce .. Eclips Studio , Inc Scott Bloom , OD PLC Bay Valley Foods Stehouwer Auto Sal. .

Account United Bank Chee ...

3,811.00

Soccer; boys co nee .. . Donations Boosters Bash Tick ... Boosters Bash Tick ... Boosters Bash Tick Undeposited Funds Undeposited Funds Undeposited Funds Undeposited Funds Undeposited Funds Undeposited Funds

-486.00 -100 .00 -50 .00 -100.00 -100.00 -75.00 -75.00 -1 25 .00 -75 .00 -125 .00 -2 ,500 .00

TOTAL

-3,811 .00

Deposit

8/25/2015 Cash

United Bank Chee ...

200.75

Soccer; boys conce .. .

-200 .75 -200.75

TOTAL

8/25/2015

Deposit

Deposit

United Bank Chee ...

1.00

Soccer; boys conce ...

-1 .00 -1.00

TOTAL Deposit

8/28/2015

Deposit

United Bank Chee ...

6,328.60

Football Concessions

-6,328.60 -6,328.60

TOTAL

8/28/2015

Deposit

Deposit

United Bank Chee .. .

2.00

Football Concessions

-2 .00 -2 .00

TOTAL

8/31/2015

Deposit

Payment

77144

8/31 /2015

Brian Ortega Josh Banner Chemical Bank of .. Cash United Bank of Way ..

United Bank Chee ...

8,355.00

Boosters Bash Tick .. Boosters Bash Tick ... Boosters Bash Tick Raffle & Auction Sa l. .. Undeposited Funds

-50 .00 -50 .00 -100 .00 -7,905.00 -250.00 -8,355.00

TOTAL Deposit

9/3/2015

Electronic Scrip R. ..

United Bank Chee ...

6.60

Indirect Public Supp ..

-6.60 -6.60

TOTAL Deposit

9/4/2015 Cash

TOTAL

Amount

United Bank Chee ...

474.40

Soccer; boys conce ..

-474.40 -474.40

Page 2

Wayland Athletic Boosters Club

1:21 PM

Deposit Detail

09/12/15

August through September 2015 Type

Num

Name

Date 9/4/2015

Deposit

Account United Bank Chee ...

Cash

Football Concessions

9/11/2015

Deposit

Cash

-4 ,435 .06

United Bank Chee .. .

4,241 .20

Football Concessions

-4,241 .20 -4,241.20

TOTAL Deposit

TOTAL

4,435.06

-4,435 .06

TOTAL

Payme nt Payment

Amount

United Bank Chee ...

9/12/2015 2042

9/4/20 15 9/11 /2015

Excel lent Exteriors Reno Agency

Undeposited Funds Undeposited Funds

525.00 -400 .00 -125 .00 -525.00

Page 3

1:39 PM

Wayland Athletic Boosters Club

09/12/15

Check Detail July through September 2015 Type

Num

---

8/24/2015

Check

Name

Date Cash

Item

Account

Paid Amount

-2,200.00

United Bank Chee ... Cash Drawings

TOTAL 8/24/2015

Check

Cash

Cash

Cash

TOTAL 9/4/2015

Cash

TOTAL 9/11/2015

Cash

TOTAL Debit

7/6/2015

Staples

TOTAL Debit

7/7/2015

World Pay

-2,000.00

--

-2,000.00

2,000.00

-2 ,000.00

2,000.00 -0.25

-0.25

0.25

-0.25

0.25 -800.00

-800.00

800.00

-800.00

800.00 -65.19

-65.19

65.19

-65.19

65 .19 -0.03

United Bank Chee ... Credit Cards Fees

TOTAL

1,600.00

United Bank Chee ... Printing and Copying

Check

1,600.00

-1 ,600.00

United Bank Chee .. . Football Concessions

Check

-1,600.00

United Bank Chee .. . Football Concessions

Check

200.00

United Bank Chee ... Football Concessions

Check

200.00

-200.00

-1,600.00

TOTAL 9/3/2015

-200.00

United Bank Chee .. . Football Concessions

Check

2,200 .00 2,200 .00 -200.00

TOTAL 8/27/2015

-2 ,200.00 -2,200.00

United Bank Chee .. . Soccer; boys co nee ..

Check

Original Amount

-0.03

0.03

-0 .03

0.03 Page 1

Wayland Athletic Boosters Club

1:39 PM

Check Detail

09/12/15

July through September 2015 Type Check

Num

--Debit

Date 8/24/2015

Name Bigsigns.com

Item

Account

End Zone Sign Ven ...

Debit

9/9/2015

US Post Office

Postage , Mailing Se ..

Check

EFT

7/1/2015

Staples

TOTAL EFT

9/4/2015

WorldPay

TOTAL 3818

7/1/2015

Wayland Union Sc ...

TOTAL 3819

7/23/2015

Music Unlimited

Outside Contract S ...

Bill TOTAL

3820

7/23/2015 7/23/2015

Wayland Floral & ...

-19.60

19.60

-19.60

19.60 -65.19

-65.19

65.19

-65.19

65 .19 -14.95

-14.95

14.95

-14.95

14.95 -2,858.82

-915 .00 165.00 -226.00 -515.00 -840.00 -527.82

915 .00 -165 .00 226.00 515.00 840.00 527.82

-2,858.82

2,858.82

United Bank Chee ...

TOTAL Bill Pmt -Check

-19.60

United Bank Chee .. . Specific Sport Specific Sport Business Registrati ... Business Registrati .. Golf Volleyball

Check

1,287 .00

United Bank Chee ... Credit Cards Fees

Check

1,287 .00

-1 ,287.00

United Bank Chee .. . Printing and Copying

Check

-1,287.00

United Bank Chee ...

TOTAL

-600.00 -600.00

600.00

-600 .00

600.00

United Bank Chee ... Outside Contract S ..

Original Amount -1,287.00

United Bank Chee .. .

TOTAL Check

Paid Amount

-110.50 -110.50

110.50

-110.50

110.50

Page 2

1:39 PM

Wayland Athletic Boosters Club

09/12/15

Check Detail July through September 2015 Type Check

Num

--3821

Date 7/23/2015

Name Wayland Union Hi.. .

Item

Account United Bank Chee .. . Boys Basketball Volleyball Softball

TOTAL Check

3822

8/17/2015

Wayland Football

TOTAL 3823

8/17/2015

Wayland Union Hi. ..

TOTAL Check

3824

8/17/2015

Next Level Perfor...

Outside Contract S .. .

3825

8/17/2015

Amber Whitman M ...

Outside Contract S .. .

3826

8/17/2015

Wayland Union Sc ...

Football

3827

8/18/2015

Uccellos Ristorante

-100.00 -100.00

100.00

-1 00.00

100.00 -322.00

-322.00

322 .00

-322 .00

322 .00 -800.00

-800 .00

800.00

-800.00

800.00 -1 43.04

-143.04

143.04

-143.04

143.04 -3,563.00

-3,563 .00

3,563 .00

-3,563.00

3,563 .00

United Bank Chee .. . Football Game Pizza

TOTAL

990.00

United Bank Chee ...

TOTAL Check

-990.00

United Bank Chee ...

TOTAL Check

290.00 290.00 410.00

United Bank Chee ...

TOTAL Check

-290.00 -290.00 -410.00

United Bank Chee ... Softball

Original Amount -990.00

United Bank Chee .. . Football

Check

Paid Amount

-21 0.00 -210.00

210.00

-210.00

210.00

Page 3

1:39 PM

Wayland Athletic Boosters Club

09112/15

Check Detail July through September 2015 Type Check

Num 3828

Date 8118/2015

Name Uccellos Ristorante

Item

Account

Football Game Pizza

3829

811912015

Penny Salisbury

Concessions Suppli ..

Check

3830

8121/2015

Shelly Whitley

Concessions Suppli ..

3831

812412015

Custom Engraving ...

Banner Signs

3832

8/2412015

Klosterman Distrib .. .

TOTAL 3833

8/2412015

Shelly Whitley

TOTAL 3834

8124/2015

Klosterman Distrib ...

TOTAL 3835

812412015

Uccellos Ristorante

-50.00 -50.00

50.00

-50.00

50.00 -625.00

-625.00

625.00

-625.00

625 .00 -3,426.70

-3,426.70

3,426.70

-3,426.70

3,426.70 -60.30

-60 .30

60.30

-60.30

60.30 -890.12

-890 .12

890.12

-890 .12

890 .12

United Bank Chee ... Boys Soccer

TOTAL

29.90

United Bank Chee ... Concessions Suppli. ..

Check

29.90

-29.90

United Bank Chee ... Concess ions Recei ..

Check

-29.90

United Bank Chee ... Concessions Suppli. .

Check

-29.90

United Bank Chee .. .

TOTAL Check

100.00 100.00

United Bank Chee ...

TOTAL Check

-100.00 -100.00

United Bank Chee .. .

TOTAL

Original Amount -100.00

United Bank Chee ...

TOTAL Check

Paid Amount

-33.00 -33 .00

33.00

-33 .00

33.00 Page4

Wayland Athletic Boosters Club

1 :39 PM

Check Detail

09/12/15

July through September 2015 Type Check

Num

--3836

Date 8/24/2015

Name Custom Engraving ...

Item

Account United Bank Chee ... Prom otional Giveaw ...

TOTAL Check

3837

8/25/2015

Wayland Union Sc ...

Softball

3838

8/27/2015

Shelly Wh itley

Boosters Bash - Ex .. .

Check

3839

8/29/2015

Harding's

Boosters Bash - Ex ...

3840

8/29/2015

Cash

TOTAL 3841

8/29/201 5

Orchard Hills

TOTAL 3842

8/31/2015

Kloste rman Distrib ...

TOTAL 3843

8/31/2015

Shelly Whitley

886.70 886.70 -48.23

-48.23

48.23

-48.23

48.23 -53.77

-53 .77

53.77

-53.77

53.77 -200.00

-200.00

200.00

-200.00

200.00 -3,224.00

-3,224.00

3,224 .00

-3,224 .00

3,224.00 -561 .74

-561 .74

56 1.74

-561 .74

56 1.74

United Bank Chee ... Conces sions Suppli..

TOTAL

-886.70 -886 .70

United Bank Chee .. . Concessions Su ppli ..

Check

-886.70

United Bank Chee... Boosters Bas h - Ex .. .

Check

232 .90

United Bank Chee .. . Boosters Bas h - Ex ..

Check

232. 90

-232 .90

United Bank Chee ...

TOTAL Check

-232 .90

United Bank Chee ...

TOTAL

Original Amount -232.90

United Bank Chee ...

TOTAL Check

Paid Amount

-49.90 -49 .90

49.90

-49 .90

49.90 Page 5

1:39 PM

Wayland Athletic Boosters Club

09/12/15

Check Detail July through September 2015 Type Check

Num

--3844

Date 9/1/2015

Name Uccellos Ristorante

Item

Account United Bank Chee ... Concessions Suppli ..

TOTAL Check

3845

9/1/2015

Varsity News Netw ...

Outside Contract S ...

3846

9/2/2015

Mike & Jill Salisbury

Boosters Decorations

Check

3847

9/3/2015

Custom Engraving ...

Banner Signs

3849

9/3/2015

Shelly Whitley

Equip Rental and M ...

3850

9/4/2015

Klosterman Distrib ...

TOTAL 3851

9/10/2015

Uccellos Ristorante

TOTAL 3852

9/13/2015

Klosterman Distrib ...

500.00

-500.00

500.00 -160.98

-160.98

160.98

-160.98

160.98 -125.00

-125.00

125.00

-125.00

125.00 -7.00

-7. 00

7.00

-7.00

7.00 -3,260.95

-3,260 .95

3,260.95

-3,260.95

3,260.95 -90.00

-90 .00

90.00

-90.00

90.00

United Bank Chee .. . Concessions Suppli ..

TOTAL

-500.00

United Bank Chee ... Football Game Pizza

Check

-500.00

United Bank Chee ... Concessions Suppli ...

Check

138.00

United Bank Chee ...

TOTAL Check

138.00

-138.00

United Bank Chee ...

TOTAL Check

-138.00

United Bank Chee ...

TOTAL

Original Amount -138.00

United Bank Chee ...

TOTAL Check

Paid Amount

-536.41 -536.41

536.41

-536.41

536.41 Page 6