Fiscal Requirements

1
Fiscal Requirements August 20th
2

• I am proud of Tennessee's reputation for good
  government, and I want and expect us to be a
  model for other states in how we handle Recovery
  Act money sensibly turning square corners, and
  with every nook and cranny of what we do and what
  we spend well-lighted and visible to the public.
• Governor Phil Bredesen

3
Stimulus 101

• Title I, II, X Projects 264,886,174
• IDEA Projects 236,959,361
• State Stabilization 947,598,000
• USDA 2,275,738
• Bonds (QSCB) 121,738,000
• Please contact the Bond Finance Office in the
  Comptrollers Office for more information on the
  bonds.

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
4
Title I, Title II, Title X Account Numbers

• These projects will use the newly created sub
  funds in eReporting.
• LEAs will have 5 days at the close of the quarter
  to report YTD expenditures for that quarter.
• LEAs are only required to report the ARRA Title
  I, Title II, Title X in eReporting. Not the
  regular federal funds, both will be reported in
  FACTS.
• If you upload all 142 funds the Department will
  only pull the ARRA 142.

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
5
IDEA Account Numbers

• These projects will use the newly created sub
  funds in eReporting.
• LEAs will have 5 days at the close of the quarter
  to report YTD expenditures for that quarter.
• LEAs are only required to report the ARRA IDEA
  Part B and Preschool in eReporting. Not the
  regular federal funds, both will be reported in
  FACTS.
• If you upload all 142 funds the Department will
  only pull the ARRA 142.

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
6
ARRA Sub Funds for 142

• Title I A Formula 10S
• Title I A School Improvement 11S
• Title II D Formula 23S
• Title II D Competitive 21S
• Title X Homeless 70S
• IDEA Part B 90S
• IDEA Preschool 91S
• These projects will continue to use the same
  revenue account numbers. The new sub funds will
  allow these projects to be accounted for
  separately.

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
7
IDEA MOE Reduction

• LEAs will need to track the General Purpose funds
  that were freed up when General Purpose
  expenditures were shifted to IDEA.
• These expenditures will need to be reported by
  the end 4th quarter (July 8th) on the IDEA MOE
  ReductionARRA.

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
8
State Fiscal Stabilization Funds (SFSF)Education
Portion (81.8)

• BEP FY09 18,000,000
• BEP FY10 172,400,000
• BEP FY11 172,214,400
• Higher Education 412,520,600
• Tennessees Total 775,135,000

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
9
State Fiscal Stabilization Funds (SFSF)State
Gov. Portion (18.2)

• FY10 FY11
• Extended Contract 15,000,000 15,000,000
  
• CSH 15,422,500 15,422,500
• Internet Connectivity 2,063,000
  2,063,000
• Professional Dev. 582,000
  582,000
• SSMS 2,700,000 2,700,000
• Family Resource Centers 3,463,200
  3,463,200
• Safe Schools 3,092,800 3,092,800
• Exemplary Educators 2,250,000
  2,250,000
• Other DOE 4,112,800 3,862,800
• Education Total 51,686,300 51,436,300
• Other State Gov. 51,447,200
  17,893,200
• Total State Gov. 103,133,500 69,329,500
• Total FY10 FY11 172,463,000

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
10
SFSF Total

• Education (81.8) 775,135,000
• State Gov. (18.2) 172,463,000
• TNs SFSF Total 947,598,000

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
11
SFSF Account Numbers

• Current/State New/ARRA
• BEP 46511 46512
• Extended Contract 46612 46615
• CSH 46590 46591
• Internet Conn. 46590 46592
• Professional Dev. 46590 46593
• Family Resource 46590 46594
• SSMS 46590 46595
• Safe Schools 46980 46981
• These expenditures will have to be cost centered
  and accounted for separately (or journal entry).

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
12
SFSF BEP Account Numbers

• BEP ARRA Revenue 46512
• BEP ARRA Expense 71100-116-xxx
• Cost center (or journal entry).
• 71100-116 (Regular Instruction Teachers) should
  be sufficient to cover the entire ARRA portion of
  a LEAs BEP.

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
13
SFSF BEP Reporting Requirements

• LEAs will use the SFSF BEP report in eReporting.
• LEAs will report 71100-116 expenditures after the
  second quarter of FY10 FY11 to cover the amount
  in the LEA SFSF application (BEP). This is a
  change from previous webinar.
• LEAs will have 5 days at the close of the quarter
  to report expenditures for that quarter.
• Local Finance will then flow out that amount of
  funds in 46512 in the February BEP payment.

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
14
SFSF Extended Contract Account Numbers

• SFSF Ext. Cont. Revenue 46615
• SFSF Ext. Cont. Expense
• 7xxxx-127 (Extended Contract)
• 7xxxx-201 (Social Security)
• 7xxxx-204 (Retirement)
• 7xxxx-212 (Medicare)
• Cost center (or journal entry).

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
15
SFSF Extended Contract Reporting Requirements

• LEAs will use the SFSF Extended Contract report
  in eReporting.
• LEAs will report in appropriate categories and
  object codes each quarter of FY10 FY11.
• LEAs will have 5 days at the close of the quarter
  to report expenditures for that quarter.
• Local Finance will then flow out that amount of
  funds in 46615.

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
16
SSMS Accounting Reporting

• SSMS ARRA Revenue 46595
• LEAs will need to account for the expenditure
  separately. It should be easy since its one
  payment.
• All eligible LEAs received an invoice from
  Century.
• The Department also received a copy of all the
  invoices from Century and will process the
  payment by 8/21/09.

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
17
Internet Accounting Reporting

• Internet ARRA Revenue 46592
• Cost center (or journal entry)
• All ENA LEAs received an invoice from ENA.
• The Department is receiving a copy of all the
  invoices from ENA and will process the payments
  as invoices come in.(annually, semi-annually,
  quarterly, monthly)
• The Department is billed for the ATT LEAs.
• Three LEAs use a different vendor and will need
  to send in invoices for reimbursement.

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
18
CSH Accounting Reporting

• CSH ARRA Revenue 46591
• Cost center (or journal entry)
• This grant will continue to operate on a
  reimbursement basis as it has in the past.
• Reimbursement request will be sent to the Office
  of Coordinated School Health.

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
19
Safe Schools Accounting
Reporting

• Safe Schools ARRA Revenue 46981
• Cost center (or journal entry)
• This grant will continue to operate on a
  reimbursement basis as it has in the past.
• Reimbursement request will be sent to the Office
  of School Safety and Learning Support.

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
20
Family Resource Centers Accounting Reporting

• Family Resource ARRA Revenue 46594
• Cost center (or journal entry)
• This grant will continue to operate on a
  reimbursement basis as it has in the past.
• Reimbursement request will be sent to the Office
  of Early Learning.

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
21
USDA Accounting Reporting

• USDA Food Service Equipment
• Revenue 47115
• Expenditure 73100-710-xxx
• cost center (or journal entry)

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
22
Quarter Dates and Deadlines

• Expenditures will be the only thing reported in
  the quarterly reports, revenue is not required to
  be reported..
• Report YTD expenditures each quarter.

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
23
2009 2010 Quarter Dates and Deadlines

• Quarter 1 (July Sept) October 7th
• Quarter 2 (Oct Dec) January 8th
• Quarter 3 (Jan March) April 8th
• Quarter 4 (April June) July 8th

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
24
2010 2011 Quarter Dates and Deadlines

• If necessary
• Quarter 1 (July Sept) October 7th
• Quarter 2 (Oct Dec) January 7th
• Quarter 3 (Jan March) April 7th
• Quarter 4 (April June) July 8th

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
25
2011 2012 Quarter Dates and Deadlines

• If necessary
• Quarter 1 (July Sept) October 7th
• Quarter 2 (Oct Dec) January 6th

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
26
eReporting

• After each quarterly reporting cycle, the Office
  of Local Finance will capture the YTD
  expenditures in a database and then zero out all
  amounts in eReporting.
• These amounts will be removed from eReporting
  when a LEA begins completing Annual Financial
  Report.

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
27
Jobs Created and Retained

• Surveys will be coming from Title I, Title II,
  Title X, IDEA Part B, Preschool, Extended
  Contract to collect this data.

American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans
28
Questions???
American Recovery and Reinvestment Act of
2009 Speed economic recovery ? Create and save
jobs ? Provide needed services to Tennesseans