Source: http://www.docstoc.com/docs/70934012/Federal-Work-Study-Match-Funds---Excel
Timestamp: 2014-04-18 04:29:53
Document Index: 568829566

Matched Legal Cases: ['art 1', 'art 2', 'art 3', 'art 1', 'art 1', 'art 1', 'art 2', 'art 1', 'art 1', 'art 1', 'art 2', 'art 1', 'art 1', 'art 1', 'art 2', 'art 2', 'art 2', 'art 3', 'art 3']

Federal Work Study Match Funds - Excel
FY 2009-10 CalWORKs Year-End Expenditure Report
revised 07-27-2010
Instructions for completing the FY 2009-10 CalWORKs Year-End Expenditure Report
Due August 31, 2010
This workbook contains 10 worksheets in the following order:
2 Part 1: Summary
3 Section I: Program Funds
4 Section II: Child Care Funds
5 Section III: Work Study Funds
6 Section IV: TANF Funds
7 Section V: ARRA Funds
8 Section VI: Supplemental TANF Work Study and Job Development/Placement Funds
9 Part 2: Match
10 Part 3: Post Employment Services
- To access a worksheet click on each tab at the bottom of this workbook.
- The workbook is programmed to fill in data and to do the calculations. Use the keyboard tab key to move around in the worksheet. Only the lavender colored cells allow data
- In &quot;Part 1: Summary&quot; the &quot;Budgeted Amount&quot; column will fill in once you have completed the remaining worksheets. When you have completed filling out each of the 9
worksheets, review &quot;Part 1: Summary&quot; for accuracy.
- Print entire workbook. To print entire workbook: Go to File, Print, Entire Workbook. You should have a total of 9 worksheets.
- Then, obtain the appropriate signatures and mail the entire FY 2009-10 CalWORKs Year-End Expenditure Report by August 31, 2010 (postmarked, do not fax) to:
Rochelle Rios, CalWORKs
CCC Chancellor&#39;s Office
If you would like assistance in completing this form, please call Cristina Mora at (916) 445-1643.
California Community Colleges                                                                                 District:
CalWORKs Program                                                                                              College:
Year-End Expenditure Report
Part 1: SUMMARY of                   2009-2010 CalWORKs Program Expenditures
This report must be completed at the college level. If your district has only one college, enter the amount of funding your district received. If there is more than one college in your district, you will need to work
with your district office to determine your college&#39;s funding level. Enter the date your Allocation Adjustment was approved (approval date may be found on the letter emailed to the CalWORKs Coordinator.)
NOTE: Report whole dollars only; do not include cents in any of the figures.
(b) Allocation   (c) Allocation    (d) Allocation   (e) Allocation           (f)
(a)                                                                                                        (g)             (h)
Allocation Type                                                               Adjustment       Adjustment        Adjustment       Adjustment           Revised
Initial Allocation                                                                                          Expended Amount     Balance*
Request 1        Request 2         Request 3        Request 4          Allocation
Enter the date of your Allocation Adjustment approval(s) 10/13/2009
I       College CalWORKs State (Prop 98)     Program Funds                        (match required)                                                                                                     $                - $            - $              -
II       College CalWORKs State (Prop 98)     Child Care Funds                     (no match requirement)                                                                                               $                - $            - $              -
III College CalWORKs State (Prop 98)           Work Study Funds                     (match required)                                                                                                     $                - $            - $              -
IV College CalWORKs Federal                    TANF Funds                           (no match requirement)                                                                                               $                - $            - $              -
V College CalWORKs Federal                    ARRA Funds                           (no match requirement)                                                                                               $                - $            - $              -
Supplemental TANF Work Study &amp; Job
$                - $            - $              -
VI College CalWORKs Federal                    Development/Placement Funds          (no match requirement)
Totals $            - $        - $         - $           - $            - $            - $           - $                                                   -
If column (h) Balance has a positive amount, your district/college is declaring unused funds and these funds will be made available for reallocation to other districts/colleges. If column (h) Balance has a
negative amount, you have overspent your allocation. If funds become available during the review of all the year-end expenditure reports, you may receive an allocation adjustment to cover these over
expenditures. If no funds are available for reallocation, then your district/college is responsible for the over expenditures.
Part 2: MATCH Requirement
District/College              Program Funds Match                                                                                                                                               $                   -
District/College              Work Study Funds Match                                                                                                                                            $                   -
Total Match Provided $                   -
Total Match Required $                   -
We hereby certify the foregoing to be accurate, that all expenditures comply with State and Federal program requirements, and understand that the above information may result in an adjustment to the 2009-2010 CalWORKs funding
College&#39;s CalWORKs Coordinator (Typed name and signature)                                                     Email Address                                            Phone Number                             Ext.        Date
College&#39;s CalWORKs Supervising Administrator (Typed name and signature)                                       Email Address                                            Phone Number                             Ext.        Date
District&#39;s CalWORKs Contact (Typed name and signature)                                                        Email Address                                            Phone Number                             Ext.        Date
District Business Office Officer (Typed name and signature)                                                   Email Address                                            Phone Number                             Ext.        Date
aa9f1d6c-d1a8-47c6-9062-b9cc86c9b859.xls                                                                      Part 1 SUMMARY                                                                                                                      Page 2 of 10
California Community Colleges                                                                                                                      Section I: CalWORKs State Program Funds
CalWORKs Program                                                                                                                             District:            0
Year-End Expenditure Report                                                                                                                  College:             0
Enter the expenditures for the funds distributed to your college from Part 1: Summary, Section I: CalWORKs State Program Funds.
Job Development/                               Curriculum
Code of                                                                                                                 Coordination                                 Instruction       Total
Placement                                 Development
Exp.                                            Classification
1000    Academic Salaries: Position Title(s)                                       % of time
2000    Classified and Other Nonacademic Salaries: Position Title(s)               % of time
3000    Employee Benefits
4000    Supplies &amp; Materials
5000    Other Operating
6000    Capital Outlay
7000    Other Outgo
Subtotal                      -                   -                    -                     -
Total Section I: CalWORKs State Program Funds           -
aa9f1d6c-d1a8-47c6-9062-b9cc86c9b859.xls                                                                                   Sec. I Program                                                           Page 3 of 10
California Community Colleges                                                                                                         Section II: CalWORKs State Child Care Funds
CalWORKs Program                                                                                                         District: 0
Year-End Expenditure Report                                                                                              College: 0
Enter your college’s expenditures for the funds distributed to your college from Part 1: Summary, Section II: CalWORKs State Child Care Funds.
Off-Campus Child       Tracking Costs
Code of                                                                                                     Campus Child Care                                                         Total
Care              (15% of Exp.)
1000     Academic Salaries: Position Title(s)                                                  % of time
2000     Classified and Other Nonacademic Salaries: Position Title(s)                          % of time
3000     Employee Benefits
4000     Supplies &amp; Materials
5000     Other Operating
6000     Capital Outlay
7000     Other Outgo
Subtotal                       -                       -                    -
calculated                                                                                                                    Total Section II: CalWORKs State Child Care Funds                -
(15% of Exp.)       Please note that CalWORKs Child Care Tracking costs are only for the purposes of tracking and administering the CalWORKs Child Care Component and cannot exceed 15% of the
total (Campus Child Care Expenditures + Off-Campus Child Care expenditures).
aa9f1d6c-d1a8-47c6-9062-b9cc86c9b859.xls                                                                Sec. II Child Care                                                                             Page 4 of 10
California Community Colleges                                                                                             Section III: CalWORKs State Work Study Funds
CalWORKs Program                                                                                       District: 0
Year-End Expenditure Report                                                                            College: 0
All work study funds budgeted must have a dollar for dollar match. At least 25% must be from the employer match and entered below; the remaining match may come from other
sources and should be entered in the spreadsheet labeled Part 2: Match. Enter the budget for the funds distributed to your college from Part 1: Summary, Section III: CalWORKs State
Work Study Funds and the employer match.
Object                                                                                         This amount is the
CalWORKs State           Employer
Code of                                                                                            calculated                                                         Total
Work-Study Funds       Work-Study Match
Exp.                                       Classification                                       minimum 25%
2000     Classified and Other Nonacademic Salaries: Position Title(s)                          employer match.
Totals Section III: CalWORKs State Work Study Funds                        -                      -                      -                  -
aa9f1d6c-d1a8-47c6-9062-b9cc86c9b859.xls                                                            Sec. III Work Study                                                                    Page 5 of 10
California Community Colleges                                                                                                                                                                         Section IV: CalWORKs Federal TANF Funds
CalWORKs Program                                                                                                                                                                  District: 0
Year-End Expenditure Report                                                                                                                                                       College: 0
Enter your college’s expenditure for the funds distributed to your college from Part 1: Summary, Section IV: CalWORKs Federal TANF Funds. Do not enter any expenditures from Sec. VI Supplemental TANF Work Study and Job Development/Placement funds.
Job Development/                         Curriculum                                                                  Other Direct Student
Code of                                                                                                           Coordination                            Child Care         Work Study           Instruction                               Total
Placement                           Development                                                                        Support
Exp.                                         Classification
1000     Academic Salaries: Position Title(s)                                    % of time
2000    Classified and Other Nonacademic Salaries: Position Title(s)            % of time
Subtotal                  -                   -                  -                  -                   -                     -                    -
Total Section IV: CalWORKs Federal TANF Funds                   -
aa9f1d6c-d1a8-47c6-9062-b9cc86c9b859.xls                                                                                Sec. IV TANF                                                                                                              Page 6 of 10
California Community Colleges                                                                                                                                                                          Section V: CalWORKs Federal ARRA Funds
CalWORKs Program                                                                                                                                                                   District: 0
Year-End Expenditure Report                                                                                                                                                        College: 0
Enter your college’s expenditures for the funds distributed to your college from Part 1: Summary, Section V: CalWORKs Federal ARRA Funds.
Job Development/                           Curriculum                                                             Other Direct Student
Code of                                                                                                                Coordination                         Child Care       Work Study          Instruction                             Total
Placement                             Development                                                                   Support
1000     Academic Salaries: Position Title(s)                                     % of time
2000     Classified and Other Nonacademic Salaries: Position Title(s)             % of time
Subtotal                      -                  -                 -                -                 -                    -                    -
Total Section V: CalWORKs Federal ARRA Funds               -
aa9f1d6c-d1a8-47c6-9062-b9cc86c9b859.xls                                                                                           Sec. V ARRA                                                                                                          Page 7 of 10
California Community Colleges                      Section VI: Supplemental TANF Work Study and Job Development/Placement Funds
CalWORKs Program                                                      District:                0
Year-End Expenditure Report                                           College:                 0
Object Code                                                                                                          Job Development/
of Exp.                              Classification                                               Work Study           Placement
1000        Academic Salaries: Position Title(s)                             % of time
2000        Classified and Other Nonacademic Salaries: Position Title(s)     % of time
3000        Employee Benefits
4000        Supplies &amp; Materials
5000        Other Operating
6000        Capital Outlay
7000        Other Outgo
Total Section VI: Supplemental TANF Work Study and Job Development/Placement Funds                        -                      -
C:\Docstoc\Working\pdf\aa9f1d6c-d1a8-47c6-9062-b9cc86c9b859.xls
Sec. VI Spl WS JDP                                    Page 8 of 10
California Community Colleges                                                                                                                                                                                                                                                      Part 2: Match Funds
CalWORKs Program                                                                                                                                                                 District: 0
Year-End Expenditure Report                                                                                                                                                      College: 0
Enter the expenditures that were used to meet the dollar for dollar match requirement. In addition, if your college spent more than its required match, enter those amounts here. Give the
accounting code (refer to Appendix A, Chart of Accounts, REVENUE TITLES of the Budget and Accounting Manual) and revenue source for all the district funds declared, that were used at
your college to meet the dollar for dollar match requirement. Check appropriate program component box. Please give a description of how these funds provide direct services to CalWORKs
Other Direct Student Support
District/College                                                                                                                                                 Narrative required: Revenue Source Description and how these funds
Revenue Group                         Revenue Source
Match Amount                                                                                                                                                                 provide direct services to CalWORKs Students
Federal Revenue 8100
State Revenue 8600
Local Revenue 8800
Other Sources 8900
Total Part 2: Match Funds                      -
aa9f1d6c-d1a8-47c6-9062-b9cc86c9b859.xls                                                                     Part 2 MATCH                                                                                                                                                                        Page 9 of 10
California Community Colleges                                                                        Part 3: Post Employment Services
CalWORKs Program                                                                            District: 0
Year-End Expenditure Report                                                                 College: 0
Please complete this section only if your college had excess CalWORKs funds and were able to provide services to Post-Employment Students
during the 2009-2010 Fiscal Year. These expenditures should have been included in the prior worksheets. You must also submit the
Certification Form for Post-Employment Services 2009-2010.
Program Component                    Amount Expended
Total                       -
aa9f1d6c-d1a8-47c6-9062-b9cc86c9b859.xls                          Part 3 Pst Emp Srvcs                                                      Page 10 of 10
Federal Work-Study, Financial Aid, Federal Work Study, Work Study, Federal Work-Study Program, financial aid office, financial need, FWS Program, work-study award, FWS award
Federal Work Study Match Funds document sample
Federal Work Study Match Funds
Federal Work Study Match
Federal Work Study % Match
It's a MATCH - It's a MATCH_