HomeMy WebLinkAbout2019-01-23 - Agenda Packet - Community & Arts Foundation tQ RAKCRO CUCAMONGA
COMMUNITY
ARTS FOUNDATION
AGENDA
COMMUNITY & ARTS
FOUNDATION
WEDNESDAY, JANUARY 23, 2019
EXECUTIVERNANCE COMMITTEE MEETING
LOCATION:
Serrano Conference Room
City of Rancho Cucamonga
10500 Civic Center Drive
Rancho Cucamonga, CA 91703
MEMBERS:
CHAIR Tina Chen, Esq.
VICE CHAIR Mark Rivera
TREASURER/SECRETARY Jim Harrington
FORMER CHAIR Paula Pachon
Mission Statement
♦ Enriching lives through support of the arts at the Victoria Gardens Cultural Center and
supporting efforts that benefit the community.
If you need special assistance or accommodations to participate in this meeting,please contact the
Community Services at(909)477-2760. Notification of 48 hours prior to the meeting will enable the
City to make reasonable arrangements to ensure accessibility. Listening devices are available for
the hearing impaired.
RANCHO CUCAMONGA
-` COMMUNITY
�RTSFOUNDATION
JANUARY 23, 2019
COMMUNITY & ARTS FOUNDATION EXECUTIVE/FINANCE COMMITTEE
A. 4:30 P.M. -CALL TO ORDER
Al. Roll Call: Tina Chen
Mark Rivera
Jim Harrington
Paula Pachon
B. COMMUNICATIONS FROM THE PUBLIC
This is the time and place for the general public to address the Committee. State law prohibits the
Committee from addressing any issue not previously included on the Agenda. The Committee may
receive testimony and set the matter for a subsequent meeting. Comments are to be limited to five
minutes per individual.
C. CONSENT CALENDAR
The following Consent Calendar items are expected to be routine and non-controversial. They
will be acted upon by the Community and Arts Foundation Executive/Finance Committee at one
time without discussion. Any item may be removed by a Member or member of the audience for
discussion.
Cl. Request for approval of the minutes of the Community &Arts Foundation Executive/Finance
Committee meeting held on October 24, 2018. 1
C2. Treasurer Report for November and December 2018. 4
D. ITEMS FOR DISCUSSION
The following items are not public hearing items, although the Chair may open the meeting for
public input:
D1. Executive Director's Report.
D2. Discussion Regarding Financial Reporting Guidelines for Non Profits and Update on Status of Form
1023.
D3. Discussion of Paychex Processing.
D4, Ongoing Discussion of RCCAAF Reorganization Plan.
D5. Update on Fundraising Committees.
• Golf Tournament (Completed)
Page 1 of 2
RANCHO CUCAMONGA
COMMUNITY
A RTS FOUNDATION
JANUARY 23, 2019
COMMUNITY & ARTS FOUNDATION EXECUTIVE/FINANCE COMMITTEE
• Fritz Coleman— Benefit Performance
• Monte Carlo Night
• Cinco de Bunco
• Quakes Night(Completed)
D6. Community Services Director's Report(Verbal)
E. IDENTIFICATION OF ITEMS FOR THE NEXT MEETING
This is the time for the Executive Committee to identify the items they wish to discuss at the
next meeting. These items will not be discussed at this meeting, only identified for the next
meeting.
F. ADJOURNMENT
I, Valerie Smith, Administrative Secretary of the City of Rancho Cucamonga, or my designee,
hereby certify that a true, accurate copy of the foregoing agenda was posted on Thursday,
January 17, 2019, seventy-two (72) hours prior to the meeting per Government Code 54954.2 at
10500 Civic Center Drive.
/s/ Valerie Smith
Valerie Smith
Executive Assistant
City of Rancho Cucamonga
Page 2 of 2
RANCHO CUCAMONGA
COMMUNITY
OVARTS FOUNDATION
OCTOBER 24, 2018
COMMUNITY & ARTS FOUNDATION EXECUTIVE/FINANCE COMMITTEE
MEETING MINUTES
A. CALL TO ORDER
Al. A meeting of the Rancho Cucamonga Community & Arts Foundation Executive/Finance
Committee was held on Wednesday, October 24, 2018 at the Rancho Cucamonga Civic
Center, located at 10500 Civic Center Dr., Rancho Cucamonga, California. The meeting
was called to order at 4:45 p.m. by Chair Chen.
A2. Present were Committee Members: Tina Chen, Jim Harrington, Mark Rivera and Paula
Pachon.
Also present were: Jennifer Hunt Gracia, Community Services Director; Susan Sluka-Kelly,
Executive Director; Catherine Allen, Account Technician; Christen Mitchell, Management
Analyst II, and Valerie Smith, Executive Assistant.
B. COMMUNICATIONS FROM THE PUBLIC
131. None.
C. CONSENT CALENDAR
C1. Request for approval of the minutes of the Community &Arts Foundation Executive Finance
Committee meeting held on August 22, 2018 and the special meeting on September 26, 2018.
C2. Receive and file Treasurer Report.
MOTION: Moved by Vice Chair Rivera, seconded by Secretary/Treasurer Harrington to
receive and file the Consent Calendar. Motion carried: 4-0.
D. ITEMS FOR DISCUSSION
D1. Financial Update.
Analyst Mitchell provided a summary of the financials for the Foundation. She presented an
issue on back-up for the $2,397.50 that was found in Quick Books. The conclusion based on
the check request signed in 2013 is that the City owes the Foundation money. She also
presented the funds that the Foundation had received for the Animal Center from WoofTrax.
Lastly, she updated on the taxes as LSL had emailed the 990 Questionnaire to staff. The first
deadline is November 151. Discussion ensued regarding whether the Full Board needs to
review it or if the Executive Finance Committee's review is sufficient. Executive Director
Sluka-Kelly will email it to Member Brown to provide her recommendation and to the
Executive Finance Committee members. Discussion commenced on the Foundation's use of
Page 1 of 3
RANCHO CUCAMONGA
COMMUNITY
&4RTSFOUNDATION
OCTOBER 24, 2018
COMMUNITY & ARTS FOUNDATION EXECUTIVE/FINANCE COMMITTEE
MEETING MINUTES
cash vs. accrual in the financials. Mark provided an explanation on the cash vs. accrual. No
further discussion was held.
MOTION: Moved by Chair Chen and seconded by Vice Chair Rivera to reimburse the Animal
Center the funds received from WoofTrax and request that the City reimburse $2,397 to the
Foundation. Motion carried: 4-0.
D2. Consideration to Allow Healthy RC to Apply for Kaiser Permanente Sponsorship Funds for
the City's Annual Teen Forum Event.
Joanna Marrufo, Management Aide in the City Manager's office, provided a brief presentation
on the impact of Healthy RC and the benefits of the Teen Forum Event for the community.
She explained that Healthy RC would be applying with the Foundation's non-profit status and
would then provide a report of how the money was used. Chair Chen expressed concern
about the guidelines of the application and getting invoices. Discussion ensued over the need
for procedures for requests such as that presented by Healthy RC. No further discussion was
held.
MOTION: Vice Chair Rivera moved to approve the submittal of the application by Healthy RC
once Executive Director Sluka-Kelly reviews and approves it based on the conversation
during the meeting. Second by Secretary/Treasurer Harrington. Motion carried: 4-0.
D3. Update of Foundation Insurance Policy.
Secretary/Treasurer Harrington presented an update on the Foundation's insurance policy.
He shared that he provided the insurer the Foundation's information so that there would be
coverage for the golf tournament. He recommended that Altru be canceled now that the
Foundation has a new insurance. No further discussion was held.
D4. Ongoing Discussion of RCCAAF Reorganization Plan.
Executive Director Sluka-Kelly went over the list of the financial process that she created for
the Foundation member's review. The Committee determined that the attorney should review
the financial process. They also discussed the purpose of meeting with the Library Foundation
to collaborate on the transition period. No further discussion was held.
D5. Update on Fundraising Committees.
Vice-Chair Rivera provided an update on the golf tournament. The committee members
shared that it was an enjoyable and successful event.
Vice-Chair Rivera left at 6:07 p.m.
Page 2 of 3
RANCHO CUCAMONGA
COMMUNITY
8A RTS FOUNDATION
OCTOBER 24, 2018
COMMUNITY & ARTS FOUNDATION EXECUTIVE/FINANCE COMMITTEE
MEETING MINUTES
E. IDENTIFICATION OF ITEMS FOR THE NEXT MEETING
Update on discussion with attorney on financial process and by-laws.
F. ADJOURNMENT
The Community & Arts Foundation Executive/Finance Committee meeting was adjourned at 6:33 p.m.
Respectfully submitted,
/s/Valerie Smith
Valerie Smith
Executive Assistant
City of Rancho Cucamonga
Page 3 of 3
RANCHO CUCAMONGA
COMMUNITY
&4RTSFOUNDATION
STAFF REPORT
DATE: January 23, 2019
TO: Rancho Cucamonga Community &Arts Foundation
FROM: Jennifer Hunt Gracia, Community Services Director
INITIATED BY: Catherine Allen, Account Technician
Elisa Garcia, Management Aide
SUBJECT: Treasurer Report
RECOMMENDATION:
Staff is seeking approval to issue a $1,000.00 reimbursement check to the Animal Care
Foundation, for the PetSmart Charities donation that was electronically deposited into the
Foundation's PAL account. Staff also recommends the Foundation receive and file this
informational report.
BACKGROUND:
Updated treasurer reports are provided to Full and Executive Board members at bimonthly
meetings.
P&L Detail —Operating Budget:
• 11/01/2018 — Staff submitted a check payment to HUB International in the amount of
$1,895.00 for the Foundation's new liability insurance policy. The pro-rated cancellation
of the old policy through Altru resulted in a reimbursement of the unused premium in the
amount of$414.00, which was received on 11/21/2018.
• 11/01 and 11/02/2018—The Foundation PAL account was charged, and then reimbursed
for a $141.91 Merchant Services fee for the credit card machine. The final cost to the
Foundation for November 2018 was $0.00.
• 11/09, 11/13 and 12/17/2018— Payroll and taxes for Susan Sluka-Kelly were debited via
Paychex from the Foundation's PAL account.
• 11/14 and 11/19/2018—UnionBanc investment interest was earned in the total amount of
$6,679.45
• 11/20/2018—A replacement check in the amount of$4,000.00 was made for the budgeted
2018 AAIE Art Show. (NOTE: The original check, which was mailed out on 0 9/2 712 01 8,
had gotten lost in the mail. Staff put a stop-payment on the lost check and issued the new
one on 11/20/2018.)
• 12/03 and 12/04/2018—The Foundation PAL account was charged, and then reimbursed
for a $46.16 Merchant Services fee for the credit card machine. The final cost to the
Foundation for December 2018 was $0.00.
• 12/11/2018 —A $1,000.00 PAL Spotlight donation payment was received from L. Dennis
Michael. He had originally pledged $5,000 back in October 2007. To date, he has paid a
Page 1 of 3
total of$4,000.00 towards this pledge. He requested an invoice and will pay the remaining
$1,000.00 in February 2019.
• 12/28/2018—Investment interest was earned in the amount of$4,375.00.
P&L Detail—Grants:
• 09/26/2018—Invoiced Lewis Real Estate Corporation for their$23,500.00 corporate grant
sponsorship. The check was received and deposited on 11/15/2018. The funds for this
grant are designated as follows:
o Donor Development and Retention (Restricted Funds) = $2,500.00
o Guest Artist Sponsorship (Restricted Funds) = $10,000.00
o PAL Campaign /Spotlight Donor= $7,500.00
0 2018 Golf Tournament= $2,000.00
0 2019 Monte Carlo Casino Night = $1,500.00
• 10/23/2018 — Invoiced Bank of America Foundation for their $10,000.00 grant
sponsorship. The check was received and deposited on 11/15/2018.
• 11/15/2018 — A restricted Mainstreet donation was received from Doug Morris in the
amount of$250.00.
• 11/15/2018 — A $500.00 cash donation for the Playpartner program was received from
Jaymee Vasquez.
• 12/10/2018—A$500.00 donation was received from the Caplin Foundation, restricted to
Mainstreet and Lewis Family Playhouse.
• 12/10/2018—A$50.00 Love of Wine donation was received from Debra Mack-Rankins.
• 12/10/2018 — A $10,000 grant was received from B of A Bank, for sponsorship of
"Hunchback" and "Emperor's Nightingale."
• 12/19/2018—A$10,000.00 Love of Wine donation was received from Doug Morris.
• 12/21/2018—A$10,000.00 Love of Wine donation was received from Lane Matsuno.
P&L Fundraising Events:
• 11/21/2018 —The final Silent Auction payment was received in the amount of$65.00 for
the 2018 Monte Carlo Night. Total income for this event is $9,112.40.
• 12/31/2018 — The total balance earned from the 2018 Golf Tournament is $43,767.26.
(This includes the $2,000.00 sponsorship, which was designated from the Lewis grant.)
There are no outstanding donation invoices; all donation payments have been received.
Balance Sheet
• PAL account balance = $169,908.03
• LAIF account balance = $295,976.22
• As of 12/31/2018, the equity account balances are as follows:
o Temporarily Restricted Net Assets (includes all restricted grants, as well as
donations that are restricted to MainStreet) = $123,169.19
o Permanently Restricted Net Assets (consists of the Endowment fund, which is
invested through Union Bank) = $2,350,586.75
Page 2 of 3
o Unrestricted Net Assets (consists of all unrestricted earnings of the Foundation) _
$238,937.83
• Other Liabilities — A $1,000.00 donation from PetSmart Charities was electronically
deposited into the Foundation's PAL account on 12/24/2018. This amount will need to be
reimbursed to the Animal Care Foundation.
PAL Checking Account:
• 06/20/2018—The $237.04 bus reimbursement check that was sent to the Pacific Avenue
Academy of Music finally cleared on 11/14/2018.
• 11/20/2018—A replacement check in the amount of$4,000.00 was issued to AAIE; staff
voided the original check, dated 09/27/2018, which was lost in transit.
• 11/21/2018—A reimbursement check in the amount of$2,397.50 was received from the
City for the overpayment made by the Foundation back in 2013 for Movies in Town Center.
LAIF Account:
• November 2018—No interest was earned on the LAW account.
• December 2018—No interest was earned on the LAIF account.
FISCAL IMPACT:
• Total FY 2018/2019 Operating Budget Income for November 2018= $6,758.53
• Total FY 2018/2019 Operating Budget Expenses for November 2018= $15,263.34
• Total FY 2018/2019 Operating Budget Income for December 2018 = $5,375.00
• Total FY 2018/2019 Operating Budget Expenses for December 2018 = $2,045.35
EXHIBITS:
Exhibit A-Foundation financial reports for November and December 2018 and operating budgets
for Fiscal Year 2018/2019.
Page 3 of 3
Foundation Financial Reports
FY 2018/2019
Foundation Operating Budget
Budget Summary and
Statement of Activity
November 1 — 30, 2018
December 1 — 31, 2018
Rancho Cucamonga Community&Arts Foundation
Operating Budget-18/19 Budget
Description 18/19 18119 lulyl-31 Augl-31 Septl-30 001-31 Nov1-30 Decl-31 18/19 YTD
Approved Actuak Actuals
Fundrai$ing/Invesbrant$ $ 70,025 $ 34,195 $ 4,765 $ 1,014 $ 204 $ 8,644.$ 14.1% $ 5,375 $ 34,195
PAL C4mp41gn4p tight Donors $ 10,500 $ 1,000 $ 1,000 $ 1,000
R.Lewis:PAL Cchrwign/SpoV(ght Donors $ 7,500 $ 7,500 $ 7,500 S 7,500
RCQvakes Stoke Outs $ 6,000 $ 7,045 IYourCause $ 7.045 $ 7,045
VG edcks/Pbgoes $ L400 $ 950 $ as0 1 1 $ 850
Ineeatmentlncome S 36,625 $ 14,429 $ 3,375 NeMakfur Qoo0,Your $ 6679 $ 4,375 $ 14,429
Intemrinc4melAIF $ 5,000 $ 2,989 $ 1,390 6ux•Amazan Smile 17S99 $ 2,989
Mhc Donotioru lAmoion Smlk,Your Cowie) $ 3,000 $ 382 $ 164 $ 204 S 14 $ 382
ActivitiesB Events $100,550 $ 71,725 $ - $ 34300 $ 24,500 $ 21,360 $ 3,565 $ - $ 71,725
Quotes Night $ 1,600 $ 1,650 $ 650 $ 1,0g0 $ 1,650
Go1/Touhnwnct $ 65,000 $ 68,510 $ 31,650 $ 13,500 $ 21,360 S 2,000 $ 68,510
Fritz Coleman Performance $ 11,650 $ - race Paemert rcWat forsllmtauNon kern $
Monte Carib Night $ 15,000 $ 1,565 br 2018 MonkG NIgN-$65; $ 1,565 $ 1,565
Gnco de Bunco $ 2,300 $ Lewis dmatbn dea)gmted/or Monte Cato $
Mhc./New Fundmiser $ 5,000 N,ht=$1,500
Total Revenue $170,575 $105,920 $ 4,765 $ 33,314 11$ 14,704 $ 30,004 $ 17,759 $ 5,375 $105,920
Rancho Cucamonga Community&Arts Foundation
Operating Budget-18/19 Budget
Expenditures
/19 YTD
Description 18/19 18/19 Julyl-31 Augl-31 Septl-30 Octl-31 Novl-30 Decl-31 18
Approved Actuals Actuals
tuals
Administration $ 49,100 $ 15,773 $ 20 $ 2,646 $ 4374 $ 4,498 $ 4,299 $ 2,045 $ 15,773
Personnel $ 35,000 $ 13,787 $ 2,626 $ 2,037 $ 4,3194$ 21760'$ 2,045 $ 13,787
Business Cards/OJjim Supplies $ 1,000 $ 179 179, $ 179
FinandoICompho-ce $ 30,000 $ 40 $ 20 $ 20 516s srt'31 $ 40
w vne pope
Insurance $ 2,300 $ 1.481 Pema.wrex• m.s1 $ 1,I81 $ 1,481
TmvefS Meetings $ 1,000 $ 287 $ 228 $ S9 $ 287
MiscxW,x,ous $ 1,OOD $ 109 $ 109 X $ 109
Marketing&Community Outreach $ 3,700 $ - $ - $ - $ - $
201712018 Foundation Report $ 1,200 $ Pak$1,895 to HUB Intl; $
Foundation Brochure $ RttNM M14 refund hum $ _
Nbu
Webslte Nosfing/Malntenance $ 1,500 $ $
Miscellaneous Marketing Eia $ 1,000 $ $
Board Development&Training $ 1,0D0 $ $ $
Donor Development&Retention $ 2,200 $ 19 S 10 $ - $ - $ 10 S - $ $ 19
Donareecognition Event $ 1,400 $ $
DonolAwards $ 600 $ $
DonorPbaues/Bnd. $ 200 $ 19 $ 10 $ 10 $ 19
Fundrdtsing Activities&Events $ 36,000 $ 24,743 $ - $ - $ 04 $ 24,209 $ - $ - $ 24,743
Golf Tournament(2018) $ 25,000 $ 24,743 $ 534 $ 24,209 $ 24,743
Monte Cado Night(2018) $ 5,000 $ $
Frkz Cokman Pkdormance $ 3,001) $
other $ 5,000 $ $
Foundation Sponsored City Programs $ 54,000 $ 6,964 $ - S - $ - $ - $ 6964 $ - $ 6,964
tew Family Playhouse $ 3,500 $ $
RCCommunity Th tWMTG $ 15,000 $ $
Wand Musk Sedts(3Shaws) $ 8,000 $ $
8uss1ngjor U,derserved5tudents See Grant Budget $
Foundation Fortuity Wknds/F/ex Pack MSFC $ 20,000 $ 6,964 $ 61964 $ 6,964
Malostreer Theatre Company $ 7,500 $ $
Community Programs $ 23,500 $ 4,00D $ - $ - $ - $ - $ 4,001) S - $ 4,000
NSPer/ormlrg Arts Pmgmm Support $ 3,000 $ $
Student Schabrship Pmgmm $ 5,000 $ $
New Program Grant $ 10,000 $
SrptemberArt Association Art Show $ 4,000 $ 4,000 $ 4,000 $ 4,000
Discretionary Giving $ 1,500
Total Expenditures $169 $ 51 30 2 28716 15 e2005 5
Budgeted Net Total $ 1,075 $ 54,421
Accrual Basis Rancho Cucamonga Community&Arts Foundation
Statement of Activity - Operating Budget
Fiscal Year 2018 - 2019
November 2018
Type Date Num Name Memo Class Amount
Ordinary IncomelExpense
Income
40000-MISC INCOME
40030•Amazon Smile
Sales Amazon Smile donation activity for FUNDRAISING ACTIVITIES:General
Receipt 11/06/2018 01241-333 Amazon Smile period:07/01/2018-09/30/2018 Fundraising 14.08
Total 40030-Amazon Smile 14.08
Total 40000-MISC INCOME 14.08
42000-INTEREST INCOME
42010-Investment Interest Income
Deposit 11/14/2018 UnionBanc Investment Investment interest income ADMINISTRATIVE/GENERAL 2,520.55
Services
Deposit 11/19/2018 UnionBanc Investment Investment interest income ADMINISTRATIVE/GENERAL 4,158.90
Services
Total 42010-Investment Interest Income 6,679.45
Total 42000•INTEREST INCOME 6,679.45
45000•PROGRAM/EVENT INCOME
45080-Event Silent Auction
Sales 2018 Monte Carlo Casino Night-Silent FUNDRAISING ACTIVITIES:Monte
Receipt 11/21/2018 01241-342 Nazir,Donna auction item(Gold Canyon Gift Basket) Carlo Casino Night:2018 65.00
Total 45080-Event Silent Auction 65.00
Total 45000-PROGRAM/EVENT INCOME 65.00
Total Income 6,758.53
Gross Profit 6,758.53
Expense
66000-PROGRAM EXPENSES
66200-Giving Activities I Sponsorship
Accrual Basis Rancho Cucamonga Community&Arts Foundation
Statement of Activity - Operating Budget
Fiscal Year 2018 - 2019
November 2018
Type Date Num Name Memo Class Amount
66204-Art Shows
Check 11/20/2018 11536 Associated Artists of the 2018 AAIE Art Show reimbursement to PROGRAM ACTIVITIES:Unrestricted 4,000.00
Inland Empire VGCC/Foundation support Program Income:Art Show
Total 66204-Art Shows 4,000.00
66207-Foundation Sponsored Tkts LFP
City of Rancho Reimbursement to City-Subsidized PROGRAM ACTIVITIES:Unrestricted
Check 11/06/2018 11533 Cucamonga-V opening weekend and family flex pack Program Income:VGCC/Playhouse 6,964.00
tickets for"School House Rock Live" Sponsorships
Total 66207•Foundation Sponsored Tkts LFP 6,964.00
Total 66200•Giving Activities/Sponsorship 10,964.00
Total 66000-PROGRAM EXPENSES 10.964.00
60000•ADMINISTRATIVE EXPENSES
60030•Bank Charges
60032-Merchant Service Fee
Deposit 11/01/2018 UnionBank-PAL Reimbursement of Merchant Services ADMINISTRATIVE/GENERAL -141.91
Account fee(credit card terminal)
Check 11/02/2018 Electronic UnionBank Monthly Merchant Services fee(credit ADMINISTRATIVE/GENERAL 141.91
cans terminal)
Total 60032-Merchant Service Fee 0.00
Total 60030-Bank Charges 0.00
60008-Liability Insurance
Check 11/01/2018 11531 HUB International Liability Insurance-Acct# ADMINISTRATIVE/GENERAL 1.895.00
Insurance N13P1557372-Policy#NBP1557372
Reimbursement for Liability Insurance
Deposit 11/21/2018 1026 Altru policy through Altru,which was ADMINISTRATIVE/GENERAL -414.00
canceled before the policy end date
Total 60008-Liability Insurance 1,481.00
Accrual Basis Rancho Cucamonga Community&Arts Foundation
Statement of Activity - Operating Budget
Fiscal Year 2018 - 2019
November 2018
Type Date Num Name Memo Class Amount
60040-Personnel
60041 -Payroll Taxes
Check 11/09/2018 Electronic State/Federal Tax Payroll taxes for Susan Sluka-Kelly- ADMINISTRATIVE/GENERAL 779.01
Agency Paychex TPS taxes
Check 11/13/2018 Electronic State/Federal Tax Payroll taxes for Susan Sluka-Kelly- ADMINISTRATIVE/GENERAL 11.00
Agency Paychex EIB Invoice CCD
Check 11/13/2018 Electronic State/Federal Tax Payroll taxes for Susan Sluka-Kelly- ADMINISTRATIVE/GENERAL 58.00
Agency Paychex EIB Invoice CCD
Check 11/13/2018 Electronic State/Federal Tax Payroll taxes for Susan Sluka-Kelly- ADMINISTRATIVE/GENERAL 99.15
Agency Paychex EIB Invoice CCD
Total 60041 -Payroll Taxes 947.16
60042-Payroll
Check 11/09/2018 Electronic Susan Sluka-Kelly Payroll for Susan Sluka-Kelly-Paychex ADMINISTRATIVE/GENERAL 1,812.53
Inc.Payroll CCD
Total 60042-Payroll 1,812.53
Total 60040-Personnel 2.759.69
60005-Board Meetings I Hospitality
Credit Card 11/28/2018 Ralphs/Food 4 Less Dinner for November 28th Board ADMINISTRATIVE/GENERAL 58.65
Charge Foundation Meeting
Total 60005-Board Meetings/Hospitality 58.65
Total 60000-ADMINISTRATIVE EXPENSES 4,299.34
Total Expense 15,263.34
Net Ordinary Income A504.81
Net Income -8,504.81
Accrual Basis Rancho Cucamonga Community&Arts Foundation
Statement of Activity - Operating Budget
Fiscal Year 2018 - 2019
December 2018
Type Date Num Name Memo Class Amount
Ordinary Income/Expense
Income
42000•INTEREST INCOME
42010-Investment Interest Income
Deposit 12/28/2018 UnlonBanc Investment Investment interest eamed ADMINISTRATIVE!GENERAL 4,375.00
Services
Total 42010•Investment Interest Income 4,375.00
Total 42000- INTEREST INCOME 4,375.00
43000-INDIVIDUAL CONTRIBUTIONS
43010-Spotlight Donor
43013-General Donation
Sales 12/11/2018 01241-346 Michael,L.Dennis Payment of PAL Spotlight Donation FUNDRAISING ACTIVITIES:General 1,000.00
Receipt pledge Fundraising
Total 43013•General Donation 1,000.00
Total 43010-Spotlight Donor 1,000.00
Total 43000- INDIVIDUAL CONTRIBUTIONS 1,000.00
Total Income 5,375.00
Gross Profit 5,375.00
Expense
60000-ADMINISTRATIVE EXPENSES
60030-Bank Charges
60032-Merchant Service Fee
Check 12/03/2018 Electronic UnionBank Monthly Merchant Services fee(credit ADMINISTRATIVE/GENERAL 46.16
card terminal)
Deposit 12/04/2018 UnionBank-PAL Reimbursement of Merchant Services ADMINISTRATIVE/GENERAL -46.16
Account fee(credit card terminal)
Total 60032.Merchant Service Fee 0.00
Total 60030•Bank Charges 0.00
60040•Personnel
Accrual Basis Rancho Cucamonga Community&Arts Foundation
Statement of Activity - Operating Budget
Fiscal Year 2018 - 2019
December 2018
Type Date Num Name Memo Class Amount
60041 •Payroll Taxes
Check 12/17/2018 Electronic State/Federal Tax Paychex TPS Payroll Taxes for Susan ADMINISTRATIVE/GENERAL 459.38
Agency Sluka-Kelly
Total 60041 -Payroll Taxes 459.38
60042-Payroll
Check 12/17/2018 Electronic Susan Sluka-Kelly Paychex Inc.Payroll for Susan Sluka- ADMINISTRATIVE/GENERAL 1,585.97
Kelly
Total 60042-Payroll 1,585.97
Total 60040-Personnel 2,045.35
Total 60000-ADMINISTRATIVE EXPENSES 2.045.35
Total Expense 2.045.35
Net Ordinary Income 3.329.65
Net Income 3,329.65
Foundation Financial Reports
FY 2018/2019
Grants Operating Budget
Budget Summary and
Statement of Activity
November 1 — 30, 2018
December 1 — 31, 2018
Rancho Cucamonga Community&Arts Foundation
Operating Budget Restricted Funds-18/19 Budget
Byah� 18119 yrD
Description 18119 Of July 1-31 W31.31 Sept 1-30 Oal-31 Nov 1-30 Dec 1-31 Aauals
Proposed 18/19 Actual, 0630.18
Support $ - $ 5 - 5 JS,oBJ $ 24M $ aof 5 73AN
Bank of"whoo Grant(Bank) $ 10,00) $ 11,314 $ 1,314 _ 5 IO,aoo $ 1Q000
Bank otAvi Spansw notacatlon) $ IV."',$ 13,019 $ 3,019 $ 10,MM $ 10,000
Kai Cares AM S S."!5 $
MacYS Output Grant S 5,000 $ - Ratdc@d wiparet dma8on flan $
Ralph kewls Hpp:panty Deselapnmt/Rrtmtlm S 2,500 $ UDD Dap Monk-$ O $ 2500 $ 2,500
Dana w for pNypaMa Program Dan S
Ralph care Hap:suronglaritudems $ 61000 $ 6,000 $ 6,000 layni Vasauel-$500
Ralph cork Hap:Guest Attar Sponsonhlp S I4,000 $ 14,000 $ 4,000 $ IDM $ 10,000
USBanmrp Faundoeioe S 25,000 $ 26,898 $ 1,898 S 25,000 $ 25p00
EdBan huparaXanal $ $MT $ $
MalnSDrm Hapwm Support $ 56,298 $ 34,998 $ 250 S 20,550 $, 21,300
ToblB Ye $ 82,500 $ 130,029 $ 51,229 $ - $ - $ $ BAN $ 23,250 $ 30b50 $ 78300
ReLtotal LFP drlm8on from call.Foundation=$500
Late M Wine dawtlon from Doug 110 k-$10,000
tare M Wine ap a0en firm lane Mutsum-$10,000
tnre M Wine aawtbn flan nature Ma -Flanldns-S50
July 1-31 Aug 1.31 Sept 1-30 Oct 1-31 Nov 1-M Dea 1-31 19119 yin
18/19 mianm Fcluals
supported GlvinB 5 121,80 S - S n 5 - $ -Is 6.M S i,1e0 5 8.10
Bonk r/AmMm Gmnr(BankJ $ 21,314 $
9onkaf"arica Spaua(Foundation) $ 5,302 $ 61118 $ t1w $ 7,218
KohPe(Me,AM $ $
MrryB garrtt Gant $ $
Ralph carve prop:Dawn Devdepmmt/Netmthon $ 2,500 $
Ralph care,Hop:B.V.,fa StWents $ 5,989 $ 61 $ 61
Ralph tewls Hap:Gutlt Author Spcaoa 1p $ 14.000 5
OS Ban,Orp Fawdathon $ 26.016 $ 22 $ 725 S 80 $ 882
Etl0on lmm�mlonpl $ - $
Mains.Haaam Support $ 56.298 5
Tot,l Egyeaditorm $ 121,969 is - $ 97 is - $ - $ 6,903 $ 1,180 1$ 81160
Accrual Basis Rancho Cucamonga Community&Arts Foundation
Statement of Activity - Operating Budget / Grants
Fiscal Year 2018 - 2019
November 2018
Type Date Num Grantor Memo Class Amount
Ordinary Income/Expense
Income
43000-INDIVIDUAL CONTRIBUTIONS
43010-Spotlight Donor
43012-MainStreet Donation
Sales 11/15/2018 01241-337 Moms,Doug&Dee Restricted Mainstreet donation PROGRAM ACTIVITIES:Restricted 250.00
Receipt Program Income:MainStreet
Total 43012-MainStreet Donation 250.00
Total 43010•Spotlight Donor 250.00
43020-MainStreet Donation
Sales PROGRAM ACTIVITIES:Restricted
Receipt 11/15/2018 01241-336 Vasquez,Jaymee Cash donation for Playpartner program Program Income:ACTIV TIES:eet 500.00
Total 43020•MainStreet Donation 500.00
Total 43000-INDIVIDUAL CONTRIBUTIONS 750.00
Total Income 750.00
Gross Profit 750.00
Expense
67000-GRANT DISBURSEMENTS
67001-Sponsored Transportation
Lewis Grant-Bus reimbursement for FUNDRAISING
Check 11/06/2018 11532 Lewis Real Estate Corp. Rancho HS to attend"School House ACTIVITIES:Restricted Grants:Lewis 60.96
Rock Live"(PO#FT101918)
Total 67001 -Sponsored Transportation 60.96
67003•Tickets for Underserved
US Bank Grant-Reimbursement to FUNDRAISING
Check 11/06/2018 11534 US Bank City-Tickets for underserved for ACTIVITIES:Restricted Grants:US 725.00
"School House Rock Live" Bank Foundation
B of A Foundation sponsored FUNDRAISING
Check 11/15/2018 11535 Bank of America underserved tickets for"School House ACTIVITIES:Restricted Grants:B of A 3,019.30
Rock Live" Foundation
Accrual Basis ,
Rancho Cucamonga Community&Arts Foundation
Statement of Activity- Operating Budget 1 Grants
Fiscal Year 2018 - 2019
November 2018
Type Date Num Grantor Memo Class Amount
Bank of America:B of A B of A Foundation sponsored FUNDRAISING
Check 11/15/2018 11535 Foundation Restr Grant- underserved tickets for"School House ACTIVITIES:Restricted Grants:B of A 3,098.20
FY18119 Rock Live" Foundation
Total 67003-Tickets for Undeserved 6,842.50
Total 67000-GRANT DISBURSEMENTS 6,903.46
Total Expense 6,903.46
Net Ordinary Income -6,153.46
Net Income -6,153.46
Accrual Basis Rancho Cucamonga Community&Arts Foundation
Statement of Activity - Operating Budget I Grants
Fiscal Year 2018 - 2019
December 2018
Type Date Num Name Memo Class Amount
Ordinary Income/Expense
Income
41000-FOUNDATION GRANT INCOME
Caplin Foundation Restricted Grant-
Sales Caplin Foundation:FY18-19 FUNDRAISING
Receipt 12/10/2018 01241-344 Restricted Grant-Mainstreet Funds to be used for the Lewis Family ACTIVITIES:Restricted Grants 500.00
Playhouse,including Mainstreet
Total 41000-FOUNDATION GRANT INCOME 500.00
43000•INDIVIDUAL CONTRIBUTIONS
43010-Spotlight Donor
43011-Love of Wine Donation
Sales PROGRAM
Receipt 12/10/2018 01241-343 Mack-Rankins,Debra Love of Wine/Mainstreet donation ACTIVITIES:Restricted 60.00
Program lncome:MainStreet
Sales Restricted income-Mainstreet(For the PROGRAM
Receipt 12/19/2018 01241-349T Moms,Doug&Dee Love of Wine) ACTIVITIES:Restricted 10,000.00
Program Income:MainStreet
Sales Restricted income-Mainstreet(For the PROGRAM
Receipt 12/21/2018 01241-350T Matsuno,Lane&Leslie Love of Wine) ACTIVITIES:Restricted 10,000.00
Program Income:MainStreet
Total 43011 -Love of Wine Donation 20,050.00
Total 43010-Spotlight Donor 20,050.00
Total 43000- INDIVIDUAL CONTRIBUTIONS 20,050.00
46000-CORPORATE GRANT INCOME
Sales Bank of America:B of A Bank B of A Bank restricted grant-For FUNDRAISING
12/10/2018 01241-345 sponsorship of"Hunchback"and ACTIVITIES:Restricted 10,000.00
Receipt Restr Grant-FY18-19 "Emperor's Nightingale" Grants:B of A Bank
Total 46000-CORPORATE GRANT INCOME 10,000.00
Total Income 30,550.00
Gross Profit 30,550.00
Expense
67000-GRANT DISBURSEMENTS
Accrual Basis Rancho Cucamonga Community&Arts Foundation
Statement of Activity- Operating Budget / Grants
Fiscal Year 2018 - 2019
December 2018
Type Date Num Name Memo Class Amount
67003-Tickets for Underserved
Bank of America:B of A BofA Foundation-Sponsored FUNDRAISING
Check 12/03/2018 11537 Foundation Restr Grant- underserved tickets for Jane Lynch's"A ACTIVITIES:Restricted 1,100.00
FY18/19 Swingin'Little Christmas Time" Grants:B of A Foundation
US Bank-Sponsored underserved FUNDRAISING
Check 12/03/2018 11538 US Bank tickets for Jane Lynch's"A Swingin'Little ACTIVITIES:Restricted 80.00
Christmas Time" Grants:US Bank Foundation
Total 67003•Tickets for Underserved 1,180.00
Total 67000•GRANT DISBURSEMENTS 1,180.00
Total Expense 1.180.00
Net Ordinary Income 29,370.00
Net Income 29,370.00
Foundation Financial Reports
FY 2018/2019
Fundraising Events
All Transactions for Events Held During Fiscal Year
Accrual Basis Rancho Cucamonga Community&Arts Foundation
Statement of Activity - Fundraising Events
Fiscal Year 2018 - 2019
All Transactions During Fiscal Year through December 31,2018
Fritz Coleman Monte Carlo
Quakes Night Golf Tourney Performance Night Cinco de Bunco
Sept 1,2018 Oct 22,2018 March 23,2019 April 27,2019 May 4,2019 TOTAL
Ordinary Income/Expense
Income
45000•PROGRAM!EVENT INCOME 1,650.00 68,510.00 1,500.00 71,660.00
Total Income 1,650.00 68,510.00 1,500.00 71,660.00
Gross Profit 1,650.00 68.510.00 1,500.00 71,660.00
Expense
65000•FUNDRAISING EXPENSES 0.00 24,742.74 0.00 24,742.74
Total Expense 0.00 24,742.74 0.00 24,742.74
Net Ordinary Income 1,650.00 43.767.26 1,500.00 46,917.26
Net Income 1,650.00 43,767.26 11500.00 46,917.26
Foundation Financial Reports
FY 2018/2019
Foundation Balance Sheet
Standard Report
As of November 30, 2018
and
As of December 31, 2018
Accrual Basis Rancho Cucamonga Community&Arts Foundation
Balance Sheet
Fiscal Year 2018 - 2019
As of November 30,2018
Nov 30,2018
ASSETS
Current Assets
Checking/Savings
10010-PAL Checking Account 154,267.03
10020-LAW Account 295,976.22
Total Checking/Savings 450,243.25
Accounts Receivable
12000-Accounts Receivable 4,500.00
Total Accounts Receivable 4,500.00
Other Current Assets
13000-Investments-UnlonBanc
13150-United States Treas Nts Note 899.718.75
13010-American Express BK FSB CD 250,000.00
13020-Capital One Bank USA NA CD 250,000.00
13030-American Express Centrn 250.000.00
13040-Fed Nad Mtg Assn-3135GOK93 700,868.00
Total 13000-Investments-UnionBanc 2,350,586.75
Total Other Current Assets 2,350,586.75
Total Current Assets 2,805,330.00
TOTAL ASSETS 2,805,330.00
LIABILITIES&EQUITY
Liabilities
Current Liabilities
Credit Cards
22000-US Bank Credit Cards
22020-US Bank Credit Card- 5445 58.65
Total 22000-US Bank Credit Cards 58.65
Total Credit Cards 58.65
Total Current Liabilities 58.65
Total Liabilities 58.65
Equity
30000.Temp Restricted Net Assets 93,799.19
31000•Permanent Restricted Net Assets 2.350.586.75
32000•Unrestricted Net Assets 268,307.83
Net Income 92,577.58
Total Equity 2,805,271.35
TOTAL LIABILITIES&EQUITY 2,805,330.00
Accrual Basis Rancho Cucamonga Community&Arts Foundation
Permanently Restricted Net Assets
Endowment Fund
Balance as of November 30,2018
Type Date Memo Amount
13000-Investments-UnlonBanc
13150-United States Treasury Note
Securities Purchase-
Transfer 07/31/2018 United States 899,718.75
Treasury Note
Total 13150-United States Treas Nis Note 899,718.75
13010-American Express BK FSB CD
Transfer 05/17/2017 Funds Transfer 250,000.00
Total 13010-American Express BK FSB CD 250,000.00
13020-Capital One Bank USA NA CD
Transfer 05/17/2017 Funds Transfer 250,000.00
Total 13020-Capital One Bank USA NA CD 250,000.00
13030•American Express Centm
Transfer 05/14/2015 Investment funds 250,000.00
transfer
Total 13030-American Express Centm 250,000.00
13040-Fed Natl Mtg Assn-3135GOK93
Transfer 06/28/2016 Investment Funds 700,868.00
transfer
Total 13040-Fed Nail Mtg Assn-3135GOK93 700,868.00
Total 13000-Investments-UnionBanc 2,350,586.75
TOTAL 2,350,586.75
Accrual Basis Rancho Cucamonga Community&Arts Foundation
Temporarily Restricted Net Assets
Balance as of November 30,2018
Nov 30,2018
Ordinary Income/Expense
Income
41000-FOUNDATION GRANT INCOME 357,000.00
43000-INDIVIDUAL CONTRIBUTIONS
43010-Spotlight Donor
43011-Love of Wine Donation 36,496.00
43012-MainStreet Donation 4,752.00
Total 43010-Spotlight Donor 41,248.00
43020-MainStreet Donation 500.00
Total 43000-INDIVIDUAL CONTRIBUTIONS 41,748.00
46000•CORPORATE GRANT INCOME 540,750.00
Total Income 939,498.00
Gross Profit 939,498.00
Expense
67000-GRANT DISBURSEMENTS
67013-Associate Tickets 1,186.00
67012-Supporting Sponsor 10,500.00
67011-Presenting Sponsor 99,500.00
67010-Sponsored Season Support 80,000.00
67009-LFP Sponsorship 40,000.00
67001 •Sponsored Transportation 172,560.96
67002•Specialty Series 66,435.00
67003-Tickets for Underserved 41,548.65
67004•Sponsored Tickets 165,556.20
67005-MainStreet Support 98,709.50
67006•Sponsorships 65,002.50
Total 67000-GRANT DISBURSEMENTS 840,998.81
66000-PROGRAM EXPENSES
66300•Spotlight Donor Disbursements
66301•Love of Wine Disbursements 5,000.00
66302-MainStreet Disbursements 1,000.00
Total 66300•Spotlight Donor Disbursements 6,000.00
Total 66000-PROGRAM EXPENSES 6,000.00
65000-FUNDRAISING EXPENSES
65010-Event Consultant Fee -500.00
65040•Event Entertainment -500.00
65100•Live Auction Prizes -300.00
Total 65000•FUNDRAISING EXPENSES -1,300.00
Total Expense 845,698.81
Net Ordinary Income 93,799.19
Net Income 93,799.19
Accrual Basis Rancho Cucamonga Community&Arts Foundation
Balance Sheet
Fiscal Year 2018 - 2019
As of December 31,2018
Dec 31,2018
ASSETS
Current Assets
Checking/Savings
10010•PAL Checking Account 169,908.03
10020-LAW Account 295,976.22
Total Checking/Savings 465,884.25
Other Current Assets
13000-Investments-UnionBanc
13150•United States Treas Nts Note 899,718.75
13010-American Express BK FSB CD 250,000.00
13020•Capital One Bank USA NA CD 250,000.00
13030•American Express Centrn 250,000.00
13040-Fed Nad Mtg Assn-3135GOK93 700,868.00
Total 13000-Investments-UnionBanc 2,350,586.75
16000-Undeposited Funds 22,500.00
Total Other Current Assets 2,373,086.75
Total Current Assets 2,838,971.00
TOTAL ASSETS 2,838,971.00
LIABILITIES&EQUITY
Liabilities
Long Term Liabilities
25000.Other Liabilities 1.000.00
Total Long Term Liabilities 1,000.00
Total Liabilities 1,000.00
Equity
30000-Temp Restricted Net Assets 123,169.19
31000•Permanent Restricted Net Assets 2,350,588.75
32000•Unrestricted Net Assets 238,937.83
Net Income 125,277.23
Total Equity 2,837,971.00
TOTAL LIABILITIES&EQUITY 2,838,971.00
Accrual Basis Rancho Cucamonga Community&Arts Foundation
Permanently Restricted Net Assets
Endowment Fund
Balance as of December 31,2018
Type Date Memo Amount
13000-Investments-UnlonBanc
13150•United States Treasury Note
Securities Purchase-
Transfer 07/31/2018 United States 899,718.75
Treasury Note
Total 13150-United States Treas Nis Note 899,718.75
13010-American Express BK FSB CD
Transfer 05/17/2017 Funds Transfer 250,000.00
Total 13010-American Express BK FSB CD 250,000.00
13020-Capital One Bank USA NA CD
Transfer 05/17/2017 Funds Transfer 250,000.00
Total 13020•Capital One Bank USA NA CD 250.000.00
13030•American Express Centrn
Transfer 05/14/2015 Investment funds 250,000.00
transfer
Total 13030-American Express Centm 250,000.00
13040-Fed Nat]Mtg Assn-3135GOK93
Transfer 06/28/2016 Investment Funds 700,868 00
transfer
Total 13040-Fed Nail Mtg Assn-3135GOK93 700,868.00
Total 13000-Investments-UnionBanc 2,350,586.75
TOTAL 2,350,586.75
Accrual Basis Rancho Cucamonga Community&Arts Foundation
Temporarily Restricted Net Assets
Balance as of December 31,2018
Dec 31,2018
Ordinary Income/Expense
Income
41000-FOUNDATION GRANT INCOME 357,500.00
43000-INDIVIDUAL CONTRIBUTIONS
43010-Spotlight Donor
43011-Love of Wine Donation 56,546.00
43012-MainStreet Donation 4,752.00
Total 43010-Spotlight Donor 61.298.00
43020•MainStreet Donation 500.00
Total 43000-INDIVIDUAL CONTRIBUTIONS 61,798.00
46000•CORPORATE GRANT INCOME 550,750.00
Total Income 970,048.00
Gross Profit 970,048.00
Expense
67000-GRANT DISBURSEMENTS
67013-Associate Tickets 1,186.00
67012-Supporting Sponsor 10,500.00
67011•Presenting Sponsor 99,500.00
67010-Sponsored Season Support 80,000.00
67009-LFP Sponsorship 40,000.00
67001 -Sponsored Transportation 172,560.96
67002-Specialty Series 66,435.00
67003•Tickets for Underserved 42,728.65
67004-Sponsored Tickets 165,556.20
67005-MainStreet Support 98,709.50
67006-Sponsorships 65,002.50
Total 67000-GRANT DISBURSEMENTS 842,178.81
66000-PROGRAM EXPENSES
66300-Spotlight Donor Disbursements
66301•Love of Wine Disbursements 5,000.00
66302-MainStreet Disbursements 1,000.00
Total 66300-Spotlight Donor Disbursements 6,000.00
Total 66000•PROGRAM EXPENSES 6,000.00
65000-FUNDRAISING EXPENSES
65010•Event Consultant Fee -500.00
65040•Event Entertainment -500.00
65100•Live Auction Prizes -300.00
Total 65000-FUNDRAISING EXPENSES -1,300.00
Total Expense 846,878.81
Net Ordinary Income 123,169.19
Net Income 123,169.19
Foundation Financial Reports
FY 2018/2019
Foundation Financials
Summary Report
As of December 31, 2018
Rancho Cucamonga Community & Arts Foundation
Financial Summary
As of: As of: As of: As of: As of:
December 31, 2018 June 30, 2018 June 30, 2017 June 30, 2016 June 30, 2015
LAIF Balance $ 295,976.22 $ 292,986.86 $ 437,831.40 $ 1..333,765.45 $ 432,390.90
Investments Total 2,350,586.75 2,350,868.00 2,350,868.00 1,450,868.00 2,348,425.00
Checking Balance 169,908.03 66,052.40 271,037.44 206,062.67 141,973.30
Affiliate's Balance -11000.00 0.00 -357,580.15 -305,312.95 -267,034.84
Total 1 $ 2,815,471.00 1 $ 2,709,907.26 1 $ 2,702,156.69 $ 2,685,383.17 $ 2,655,754.36
Foundation Financial Reports
FY 2018/2019
PAL Checking Account
Reconciliation Summary and Detail
November 1 — 30, 2018
December 1 — 31, 2018
Rancho Cucamonga Community&Arts Foundation
Reconciliation Summary- PAL Checking Account
Fiscal Year 2018 - 2019
Period Ending November 30,2018
Nov 30,2018
Beginning Balance 144,178.56
Cleared Transactions
Checks and Payments-15 Items -38,516.99
Deposits and Credits-19 items 52,749.07
Total Cleared Transactions 14,232.08
Cleared Balance 158,410.64
Uncleared Transactions
Checks and Payments-4 items -4,143.61
Total Uncleared Transactions -4,143.61
Register Balance as of 11/30/2018 154,267.03
New Transactions
Checks and Payments-2 items -1,180.00
Total New Transactions -1,180.00
Ending Balance 153,087.03
Rancho Cucamonga Community&Arts Foundation
Reconciliation Detail - PAL Checking Account
Fiscal Year 2018 - 2019
Period Ending November 30,2018
Type Date Num Name Memo Clr Amount Balance
Beginning Balance 144,178.56
Cleared Transactions
Checks and Payments-15 items
Check 06/20/2018 11512 Pacific Avenue Academy of Music LFP Bus Reimbursement-Frederick(Trip ID#2202) 4 -237.04 -237.04
Check 10/25/2018 11528 Rancho Cucamonga Animal Care Reimbursement for WoofTrax donation 4 -4.00 -337.25
Foundation
Check 10/31/2018 11530 Red Hill Country Club 2018 Golf Tournament-Acct#9124-Balance due 4 -19,576.64 -19,913.89
for 2018 Golf Tournament
Check 11/01/2018 11531 HUB International Insurance Liability Insurance-Acct#NBP1557372-Policy# 4 -1,895.00 -21,808.89
NBP1557372
Check 11/02/2018 Electronic UnionBank Merchant Services fee-Credit card terminal d -141.91 -21,950.80
Reimbursement to City-Subsidized opening
Check 11/06/2018 11533 City of Rancho Cucamonga-V weekend and family flex pack tickets for"School 4 -6,964.00 -28,914.80
Hous...
Check 11/06/2018 11534 City of Rancho Cucamonga-V US Bank Grant-Reimbursement to City-Tickets for 4 -725 00 -29,639.80
underserved for"School House Rock Live"(In...
Check 11/09/2018 Electronic Susan Sluka-Kelly CCD PayroII for Susan Sluka-Kelly-Paychex Inc.Payroll 4 -1,812.53 -31,452.33
Check 11/09/2018 Electronic State/Federal Tax Agency Payroll taxes for Susan Sluka-Kelly-Paychex TPS J -779.01 -32,231.34
taxes
Check 11/13/2018 Electronic State/Federal Tax Agency Payroll taxes for Susan Sluka-Kelly-Paychex EIB J -168.15 -32,399.49
Invoice CCD
Check 11/15/2018 11535 City of Rancho Cucamonga-V B of A Foundation sponsored underserved tickets for 4 -6,117.50 -38,516.99
"School House Rock Live"
Total Checks and Payments -38,516.99 -38,516.99
Deposits and Credits-19 items
Check 09/27/2018 11517 Associated Artists of the Inland VOID:2018 AAIE Art Show reimbursement to VGCC/ 0.00 81.21
Empire Foundation support
Deposit 10/30/2018 2018 Golf Tournament 500.00 596.21
Deposit 10/31/2018 2018 Golf Tournament 1,455.00 2,051.21
Deposit 11/01/2018 Reimbursement of Merchant Services fee- ,j 141.91 2,193.12
Credit card terminal
Deposit 11/01/2018 2018 Golf Tournament 2,500.00 4,693.12
Rancho Cucamonga Community&Ads Foundation
Reconciliation Detail - PAL Checking Account
Fiscal Year 2018 - 2019
Period Ending November 30,2018
Type Date Num Name Memo CIr Amount Balance
Deposit 11/07/2018 2018 Golf Tournament 4 1,000.00 5,693.12
Deposit 11/14/2018 Investment Interest Income 4 2,520.55 8,213.67
Deposit 11/15/2018 Mainstreet/Play Partner Program 4 500.00 8,713.67
Deposit 11/15/2018 BofA Foundation-Restricted Grant 4 10,000.00 18,713.67
Deposit 11/15/2018 (Doug Moms-Mainstreet),(2018 Golf Tournament), 4 24,750.00 43,463.67
(Lewis Restricted Grant)
Deposit 11/19/2018 2018 Golf Tournament 4 2,250.00 45,713.67
Deposit 11/19/2018 Investment Interest Income 4 4,158.90 49,872.57
Deposit 11/21/2018 2018 Monte Carlo Casino Night 4 65.00 49,937.57
Deposit 11/21/2018 Reimbursement for Liability Insurance policy through 4 414.00 50,351.57
Altru,which was canceled before the policy...
Deposit 11/21/2018 Reimbursement from City to Foundation for
2,397.50 52,749.07
overpayment for Movies in Town Center
Total Deposits and Credits 52,749.07 52,749.07
Total Cleared Transactions 14,232.08 14,232.08
Cleared Balance 14,232.08 158,410.64
Uncleared Transactions
Checks and Payments-4 items
Check 10/16/2018 11523 City of Rancho Cucamonga-V Reimbursement for theatre seat plate for,Jim and -9.70 -9.70
Penny Haygood
Check 10/29/2018 11529 City of Rancho Cucamonga-V 2018 Golf Tournament-Reimbursement to City for -72.95 -82.65
beverages for 2018 Golf Tournament
Lewis Grant-Bus reimbursement for Rancho HS to -60.96 -143.61
Check 11/06/2018 11532 SB County Superintendent of Schools attend"School House Rock Live"(PO#FT101918)
Check 11/20/2018 11536 Associated Artists of the Inland 2018 AAIE Art Show reimbursement to VGCC/ -4.000.00 -4,143.61
Empire Foundation support
Total Checks and Payments -4,143.61 -4,143.61
Total Uncleared Transactions -4,143.61 -4,143.61
Register Balance as of 11/30/2018 10,088.47 154,267.03
New Transactions
Rancho Cucamonga Community&Arts Foundation
Reconciliation Detail - PAL Checking Account
Fiscal Year 2018 - 2019
Period Ending November 30,2018
Type Date Num Name Memo Clr Amount Balance
Checks and Payments-;!Items
Check 12/03/2018 11537 City of Rancho Cucamonga-V BofA Foundation-Sponsored underserved tickets for -1,100.00 -1,100.00
Jane Lynch's"A Swingin'Little Christmas Time"
Check 12/03/2018 11538 City of Rancho Cucamonga-V US Bank-Sponsored underserved tickets for Jane -80.00 -1,180.00
Lynch's"A Swingin'Little Christmas Time"
Total Checks and Payments -1,180.00 -1,180.00
Total New Transactions -1.180.00 -1,180.00
Ending Balance 8,908.47 153,087.03
Rancho Cucamonga Community&Arts Foundation
Reconciliation Summary- PAL Checking Account
Fiscal Year 2018 - 2019
Period Ending December 31,2018
Dec 31,2018
Beginning Balance 158,410.64
Cleared Transactions
Checks and Payments-9 items -7,412.81
Deposits and Credits-6 items 18,971.16
Total Cleared Transactions 11,558.35
Cleared Balance 169,968.99
Uncleared Transactions
Checks and Payments-1 item -60.96
Total Uncleared Transactions -60.96
Register Balance as of 12131/2018 169,908.03
New Transactions
Deposits and Credits-2 items 22,500.00
Total New Transactions 22,500.00
Ending Balance 192,408.03
Rancho Cucamonga Community&Arts Foundation
Reconciliation Detail - PAL Checking Account
Fiscal Year 2018 - 2019
Period Ending December 31,2018
Type Date Num Name Memo Cir Amount Balance
Beginning Balance 158,410.64
Cleared Transactions
Checks and Payments-9 items
Check 10/16/2018 11523 City of Rancho Cucamonga Reimbursement for theatre seat plate for Jim and 4 -9.70 -9.70
Penny Haygood
Check 10/29/2018 11529 City of Rancho Cucamonga 2018 Golf Tournament-Reimbursement to City 4 -72.95 -82.65
for beverages for 2018 Golf Tournament
Check 11/20/2018 11536 Associated Artists of the Inland Empire 2018 AAIE Art Show reimbursement to VGCC/ -4,000.00 -4,082.65
Foundation support
BofA Foundation-Sponsored underserved
Check 12/03/2018 11537 City of Rancho Cucamonga tickets for Jane Lynch's"A Swingin'Little ,1 -1,100.00 -5,182.65
Christmas Time"
Check 12/03/2018 11538 City of Rancho Cucamonga US Bank-Sponsored underserved tickets for -80.00 -5,262.65
Jane Lynch's"A Swingin'Little Christmas Time"
Check 12/03/2018 Electronic Union Bank Monthly Merchant Services fee(credit card 4 -46.16 -5,308.81
terminal)
Check 12/17/2018 Electronic Susan Sluka-Kelly Paychex Inc.Payroll for Susan Sluka-Kelly 4 -1,585.97 -6,894.78
Check 12/17/2018 Electronic State/Federal Tax Agency Paychex TPS Payroll Taxes for Susan Sluka- 4 -459.38 -7,354.16
Kelly
Check 12/31/2018 Electronic U.S.Bank Credit Card Auto-payment on credit card account 4 -58.65 -7,412.81
Total Checks and Payments -7, -7,412.81
Deposits and Credits-6 items
Deposit 12/04/2018 Union Bank Reimbursement of Merchant Services fee(credit 4 46.16 46.16
card terminal)
(Love of Wine),(2018 Golf Tourney),(Caplin
Debra Mack-Rankins=$50 Foundation Restricted Grant-Funds to be used
Deposit 12/10/2018 Soren McAdams=$1,000 for the Lewis Family Playhouse,including 4 11.550.00 11,596.16
Caplin Foundation=$500 Mainstreet),(B of A Bank restricted grant-For
B of A Bank Grant=$10.000 sponsorship of"Hunchback"and"Emperor's
Nightingale")
Deposit 12/11/2018 Dennis Michael PAL Spotlight Donation 4 1,000.00 12,596.16
Deposit 12/13/2018 Tony Mize 2018 Golf Tournament 4 1.000.00 13,596.16
Rancho Cucamonga Community&Arts Foundation
Reconciliation Detail - PAL Checking Account
Fiscal Year 2018 - 2019
Period Ending December 31,2018
Type Date Num Name Memo Cir Amount Balance
Deposit 12/24/2018 Petsmart Charities Animal Care Foundation 4 1,000.00 14,596.16
Deposit 12/28/2018 UnionBanc Investment Sedvices Investment Interest earned 4,375.00 18,971.16
Total Deposits and Credits 18,971.16 18,971.16
Total Cleared Transactions 11,558.35 11,568.35
Cleared Balance 11,558.35 169,968.99
Uncleared Transactions
Checks and Payments-1 item
Lewis Grant-Bus reimbursement for Rancho HS
Check 11/06/2018 11532 SB County Superintendent of Schools to attend"School House Rock Live"(PO# -60.96 -60.96
FT101918)
Total Checks and Payments -60.96
Total Uncleared Transactions -60.96
Register Balance as of 12/31/2018 11,497.39 169,908.03
New Transactions
Deposits and Credits-2 items
Deposit 01/02/2019 Diversified Pacific Development Group 2018 Golf Tournament 2,500.00 2,500.00
Deposit 01/03/2019 Doug Morris=$10,000 Mainstreet-Love of Wine 20,000.00 22,500.00
Lane Matsune=$10.000
Total Deposits and Credits 22,500.00 22,500.00
Total New Transactions 22,500.00 22,500.00
Ending Balance 33,997.39 192,408.03
Foundation Financial Reports
FY 2018/2019
LAIF Account
Reconciliation Summary and Detail
November 1 — 30, 2018
December 1 — 31, 2018
Rancho Cucamonga Community&Arts Foundation
Reconciliation Summary- LAW Account
Fiscal Year 2018 - 2019
Period Ending December 4,2018
Dec 4,2018
Beginning Balance 295,976.22
Cleared Balance 295,976.22
Register Balance as of 1=4►2018 295,976.22
Ending Balance 295,976.22
Rancho Cucamonga Community&Arts Foundation
Reconciliation Detail - LAW Account
Fiscal Year 2018 - 2019
Period Ending December 4,2018
Type Date Name Memo Amount Balance
Beginning Balance 295,976.22
Cleared Balance 295,976.22
Register Balance as of 12/04/2018 295,976.22
Ending Balance 295,976.22
Rancho Cucamonga Community&Arts Foundation
Reconciliation Summary - LAW Account
Fiscal Year 2018 - 2019
Period Ending January 7,2019
Jan 7,2019
Beginning Balance 295,976.22
Cleared Balance 295,976.22
Register Balance as of OIIO 2019 295,976.22
Ending Balance 295,976.22
Rancho Cucamonga Community&Arts Foundation
Reconciliation Detail - LAW Account
Fiscal Year 2018 - 2019
Period Ending January 7,2019
Type Date Memo Amount Balance
Beginning Balance 295,976.22
Cleared Balance 295,976.22
Register Balance as of 01/07/2019 295,976.22
Ending Balance 295,976.22