August 2022 PY to CY Comparison Report

AID 1436106 · View on Simbli

Agenda Item

i. Acceptance of the August 2022 Monthly Financial Reports

Summary: Presented by: Ms. Masana Mailliard, Interim Chief Financial Officer, Division of Finance
Request: It is requested that the Board of Education accept the August 2022 Monthly Financial Report.
Contact: Ms. Masana Mailliard, Interim Chief Financial Officer, Division of Finance, 678.676.0446
Status: General Counsel approval not required
                                                 DEKALB COUNTY BOARD OF EDUCATION
                                             GENERAL FUND - PRIOR YEAR COMPARISON CHARTS
                                                          August - 08/31/2022


                                                               Revenues Comparison


                     30,000,000


                     25,000,000


                     20,000,000


                     15,000,000


                     10,000,000


                      5,000,000


                                   0
                                       Local Revenue                  State Revenue                   Other Revenue                  Total Revenue
        FY22 - Prior Fiscal Year         8,379,713                      4,320,329                         5,659                       12,705,701
        FY23 - Current Fiscal Year       23,622,404                     5,752,263                         235,099                     29,609,766

                                                       FY22 - Prior Fiscal Year       FY23 - Current Fiscal Year


Revenue recognition increased comparable to the previous reporting period, primarily driven by increases in local property tax
receipts for the second half of August. Furthermore, State Revenue increased attributable to higher QBE, Quality Basic Education,
funding collections.

                                                            Expenditures Comparison

                     45,000,000
                     40,000,000
                     35,000,000
                     30,000,000
                     25,000,000
                     20,000,000
                     15,000,000
                     10,000,000
                       5,000,000
                                   0
                                       Instruction           Pupil Services           Maintenance and              Other Functions    Total Expenditures
                                                                                         Operation
        FY22 - Prior Fiscal Year       8,975,121               1,607,819                 7,937,436                   11,207,719           29,728,095
        FY23 - Current Fiscal Year     12,409,519              1,863,053                 11,959,707                  16,226,120           42,458,399

                                                       FY22 - Prior Fiscal Year       FY23 - Current Fiscal Year


Amounts attributable to the General Fund increased comparable to the previous reporting period, driven by increases across a wide
variety of services not limited to personnel. Increases in instructional related expenditures occurred in salaries and benefits,
worker's compensation insurance, purchased professional services, supplies, and technology services. Increases for Maintenance
and Operation were identifiable to property risk management services not present in the previous period, as well as increases in
expenditures such as custodial personnel, repairs and maintenance, energy, and utilities.
                             DEKALB COUNTY BOARD OF EDUCATION
                            GENERAL FUND - PRIOR YEAR COMPARISON
                                      August - 08/31/2022

                                             Revenues:


           Description        FY22 - Prior Fiscal Year     FY23 - Current Fiscal Year    Difference


Local Revenue                                  8,379,713                    23,622,404      15,242,691
State Revenue                                  4,320,329                     5,752,263       1,431,934
Other Revenue                                      5,659                       235,099         229,440
Total Revenue                                12,705,701                    29,609,766       16,904,065




                                           Expenditures:


           Description        FY22 - Prior Fiscal Year     FY23 - Current Fiscal Year    Difference


Instruction                                    8,975,121                   12,409,519        3,434,398
Pupil Services                                 1,607,819                    1,863,053          255,234
Maintenance and Operation                      7,937,436                   11,959,707        4,022,272
Other Functions                               11,207,719                   16,226,120        5,018,401
Total Expenditures                           29,728,095                    42,458,399       12,730,304