ADULT EDUCATION

1
ADULT EDUCATION FAMILY LITERACYFinancial
ManagementApril 2005
2
TIMELINE
Click on a date to see related tasks for each due
date. Or proceed one-by-one using Next Slide.
_I______________I______________I_____________I____
____________
May 10, 2005
June 13, 2005
May 1, 2005
August 15, 2005
Click here if you want to bypass all the timeline
slides.
Finished with Timeline
3
TIMELINE FISCAL YEAR 2004-05

• May 1, 2005
• FY2004-05 Budget and Expenditure forms will be
  e-mailed to each AEFLA CIVICS provider.
• Format will be in an e-budget Excel file.
• Two Instruction word file documents will be
  included.

4
Your Task

• AEFLA CIVICS grantee
• Review the budget information for accuracy and
  completeness.
• Correct as necessary.
• Return to CDE only if substantial changes are
  made.

5
TIMELINE FISCAL YEAR 2005-2006

• May 10, 2005
• CDE will e-mail FY2005-06 Annual Budget and
  Narrative forms to each AEFLA CIVICS provider.
• Format will be in an e-budget Excel file.
• Two Instruction word file documents will be
  included.

6
Your task

• AEFLA CIVICS grantee
• Prepare the Annual Budget and Narrative Report
  using the FT2005-06 e-budget Excel file.
• Contact Glenn Jeglum with questions at
  303-866-6836

7
TIMELINE FISCAL YEAR 2005-06

• June 13, 2005 Completed 2005-2006 Annual Budget
  and Narrative Report e-budget file due at CDE
• Contact Glenn Jeglum with questions at
  303-866-6836

8
Your task

• AEFLA CIVICS grantee
• E-mail completed 2005-2006 Annual Budget and
  Narrative Report e-budget file to CDE.
• E-mail the file to Glenn Jeglum at
  jeglum_g_at_cde.state.co.us

9
TIMELINEFISCAL YEAR 2004-05

• August 15, 2005
• E-mail the completed FY2004-05 End of Year Annual
  Expenditure Report- e-Budget files to CDE.
• One file for AEFLA and one separate file for
  CIVICS.

More details
10
Your task

• AEFLA CIVICS grantee
• Prepare the End of Year Annual Expenditure Report
  using the FY2004-05
• e-Budget Excel file.
• E-mail the completed file to jeglum_g_at_cde.state.co
  .us

More details
11
Annual End of Year Expenditure Report

• For Awards Subject to Annual Performance
  Factor Calculations- Prepare Detailed
  Expenditure Report.
• For Awards NOT Subject to Annual Performance
  Factor Calculations enter totals only for each
  award.
• Cash or in-kind matching funds enter total
  expenditure for each source of funds. Must be
  at least 40 of total Grant expenditures.

12
Annual End of Year Expenditure Report

• Must be in balance
• Total expenditures for all FY2004-05 awards.
• Total draw down of moneys from CDE.
• Cannot be greater than FY2004-05 Awards.

• If draw down is greater than expenditures,
  return money to CDE.

13
SECURITY ALERT!

• WARNING Prior to opening
• the Excel Budget file, please
• close all other Microsoft Excel
• files you may have open.
• Security must be set to
• Medium.
• Macros must be Enabled.

14

• Tools
• Macro
• Security

Start with a blank Excel worksheet.
15
Set the security level to medium. Click the OK
button.
16

• Download and save the e-budget file.
• Open the e-budget file.
• Enable Macros every time the file is used.

Now you are ready for e-budgets.
17
Introduction to e-Budgets
WHAT WOULD YOU LIKE TO DO?
Work On Budgets
Open another Budget/Narrative Set
Work On End of Year Expenditure Report
18
Work on Budget

• 2-Cover Page
• 3-Match cash or in-kind
• 4-Budget Basic
• 4-Narrative Basic
• Budget Summary

19
Open Another Budget/Narrative Set

• 2-Cover Page
• 3-Match cash or in-kind
• 4-Budget Basic
• 4-Narrative Basic
• 4-Budget-2
• 4-Narrative-2
• Budget Summary
• Used for Expansions or where another Budget page
  is needed.

20
Work on End of Year Expenditure Report

• 2-Cover Page
• 3-Match cash or in-kind
• 4-Budget Summary
• 4-Expenditure Summary
• 4-Expenditure Supplement
• 5-Variance Summary

21
2-Cover Page
Date Update to correspond with submission date
of report. Names and Addresses Verify accuracy.
Correct as necessary.
22
2-Cover Page
Budget subject to Annual Performance Factor
Calculations.
Detailed budget amounts shown
Actual expenditures reported

• On the right side
• Budget page 1 ? 4-Budget Basic
• Budget page 2 ? 4-Budget -2
• Expenditures Reported ? 4-Expenditure
  Summary

23
2-Cover Page
Budget NOT subject to Annual Performance Factor
Calculations
24
3-Match
Cash and In-Kind
25
4-Budget Basic
Budget subject to Annual Performance Factor
Calculations.
26
4-Narrative Basic
27
5-Budget Summary
Budget subject to Annual Performance Factor
Calculations.
28
5-Budget Summary
29
5-Budget Summary
30
5-Expenditure Summary
ANNUAL END OF YEAR EXPENDITURE REPORT
31
5-Expenditure Summary
ANNUAL END OF YEAR EXPENDITURE REPORT
32
5-Expenditure Supplement
COST OF INSTITUTIONALIZED STUDENTS
OR
33
6-Variance Report
INFORMATIONAL ONLY
34
CALL OR E-MAIL WITH QUESTIONS OR PROBLEMS
Jeglum_g_at_cde.state.co.us Glenn Jeglum
303-866-6836
For Microsoft Excel questions contact Doug
Glynn 303-866-6607