The Iowa Chart of Account Coding, found on the Uniform Financial Accounting page of the Department website, is regularly updated to reflect changes necessary to meet fiscal reporting needs. The most recent update is provided below.
February 2023
Project 1112
|
Property Tax and State Aid Financed Weighted English Learners (EL) and SBRC Modified Supplemental Amount for EL (General Fund only) (Used with program 41X) (Feb23 title change)
|
Source/Project 4368
|
Clean School Bus Rebate Program (EPA) (FAL/CFDA 81.255) (Feb23)
|
Source/Project 4034
|
Coronavirus State and Local Fiscal Recovery Fund (CSLFR) – School Safety Improvement Fund (FAL/CFDA 21.027) (Reinstated for CSLFR ARP Feb23)
|
Source/Project 3419
|
Iowa Skilled Worker and Job Creation Fund (IC 8.75) (Rural Innovation Grant Program) (IAC 261-221) (STEM Best HD and Program Enhancement Awards) (HF871) (HF2564) (DED) (Dec20) (Mar22) (Name change Feb 23)
|
March 2023
Project 3190
|
Categorical Fund Accounts from Other Categorical Funds (Effective FY24 Reporting) (Mar23)
|
Project 3191
|
Teacher Salary Supplement Originating from Professional Development (Projects 3373 or 3376) Funds (IC 257.10) (HF68) (Effective FY24 Reporting) (Mar23)
|
Project 3192
|
Teacher Salary Supplement Originating from Teacher Leadership Supplement (Project 3116) Funds (IC 257.10) (HF68) (Effective FY24 Reporting) (Mar23)
|
Project 3193
|
Teacher Salary Supplement Originating from Gifted and Talented Programs (Project 1118) Funds (IC 257.10) (HF68) (Effective FY24 Reporting) (Mar23)
|
Source 319X
|
Reserved for Categorical Fund Account Projects
|
Object 959
|
Categorical Intrafund Transfers (General Fund Only) (Effective FY24 Reporting) (Mar23)
|
The Department has been asked a variety of account coding questions relating to school meal accounts in the Nutrition Fund. This article is organized into multiple subtopics as provided below.
- Deposits made to a school meal account
- How to determine and record bad debt
- Applying revenue to student meal debts
- Funds donated from private sources
- Funds from a General Fund flexibility account transfer
Deposits made to a school meal account
Deposits made into a school meal account are considered unearned revenues and must be recorded in the Nutrition Fund balance sheet Account 483 - Unearned Revenues. These monies are properly accounted for as a liability (e.g., in the event refunds are requested when a student/adult leaves the district). As students/adults make purchases using funds from their meal account, the purchase becomes a sale with Source 16XX. Districts should record student/adult sales monthly using reports or data from the Point of Sale (POS) system.
Deposit payments made into individual/family food service account
Debit Cash (Fund 61, Account 1XX)
Credit Unearned Revenues (Fund 61, Account 483)
Record student/adult purchases as meal sales monthly using data from POS system
Debit Unearned Revenues (Fund 61, Account 483)
Credit Meal Sale (Fund 61, Source 16XX)
How to determine and record bad debt
At the end of a school year, districts should make an adjusting journal entry to account for accounts receivable (Account 153) in the Nutrition Fund using reports or data from the POS system.
Bad debts are unpaid meal accounts which are no longer collectible or are too costly to be collected. Review the district’s board policy which defines parameters for determining when a liability is uncollectible and should be considered a bad debt. Once a debt is determined to be a bad debt, the district may set up an estimated bad debt account for the amount deemed uncollectible in the Nutrition Fund balance sheet Account 154, allowance for uncollectible accounts receivable. Balance sheet Account 154 is a contra asset account that reduces the amount of the gross accounts receivable amount on the district's balance sheet.
Record estimated bad debt for uncollectible meal account
Debit Bad Debt Expense (Fund 61, Function 3110, Object 899)
Credit Allowance for Uncollectible Accounts Receivable (Fund 61, Account 154)
Applying revenue to student meal debts
1. Funds donated from private sources
Iowa Code subsection 283A.11(6) authorizes districts to deposit moneys received from private sources for purposes of paying student meal debt in the Nutrition Fund.
Deposit donated funds from private sources into the Nutrition Fund
Debit Cash (Fund 61, Account 1XX)
Credit Donation for Negative Nutrition Account (Fund 61, Source 1922)
Pay student meal debt with donated funds from private sources
If the debt is already included in the estimated bad debt (Account 154),
Debit Allowance for Uncollectible Accounts Receivable (Fund 61, Account 154)
Credit Other Accounts Receivable (Fund 61, Account 153)
*Districts may use a district-assigned project code to track the donation.
OR
If the debt has not been included in the estimated bad debt (Account 154),
Debit Bad Debt Expense (Fund 61, Function 3110, Object 899)
Credit Other Accounts Receivable (Fund 61, Account 153)
*Districts may use a district-assigned project code to track the donation.
2. Funds from the General Fund flexibility account
Districts may also deposit funds from the General Fund flexibility account into the unpaid student meals account per Iowa Code subsection 298A.2(2)"c".
Moneys deposited in the flexibility account may be used by the school district during a budget year beginning on or after the calendar years in which the moneys were transferred to the flexibility account for any of the following:
(6) For deposit in the unpaid student meals account to be used for purposes of paying student meal debt accrued by individual students in accordance with section 283A.11, subsection 6.
Transfer funds from the General Fund flexibility account into the Nutrition Fund
Debit Flexibility Account (Fund 10, Function 6261, Project 31XX, Object 910)
Credit Interfund Transfer from General Fund (Fund 61, Project 1922, Source 5210)
Pay student meal debt with funds from the General Fund flexibility account
If the debt is already included in the estimated bad debt (Account 154),
Debit Allowance for Uncollectible Accounts Receivable (Fund 61, Account 154)
Credit Other Accounts Receivable (Fund 61, Account 153)
OR
If the debt has not been included in the estimated bad debt (Account 154),
Debit Bad Debt Expense (Fund 61, Function 3110, Object 899)
Credit Other Accounts Receivable (Fund 61, Account 153)
If you have further questions, please contact Kathy Bowers at kathy.bowers@iowa.gov or 515-210-9674, Jina Brincks at jina.brincks@iowa.gov or 515-313-5942, or Song Luong at song.luong1@iowa.gov or 515-205-0259.
Medicaid account coding is performed differently from the way most other account coding is completed by Area Education Agencies (AEAs) or Local Education Agencies (LEAs). Since the amount of reimbursement an AEA or LEA will receive from Medicaid for an expenditure is not known at the time the expenditure is incurred, a Medicaid expenditure is initially coded to the appropriate program and/or program levels of the students for whom the expenditure was incurred. When an LEA or AEA receives the Medicaid claim reimbursement, only the revenue retained by the LEA/AEA will be recorded as revenue. The state share portion of the reimbursement received that will be paid to Iowa Health and Human Services (HHS) is recorded on the balance sheet as accounts payable rather than as an expenditure.
Medicaid reimbursement received:
Debit Cash (Fund 10, Account 10X)
Credit Intergovernmental Payables (Fund 10, Program 2XX, Project 3321, Account 410) state share amount due to HHS
Credit Medical Assistance Program-Medicaid (Fund 10, Program 2XX, Project 4634, Source 4634) revenue retained by LEA/AEA
Record state portion when paid back to HHS:
Debit Intergovernmental Payables (Fund 10, Program 2XX, Project 3321, Account 410)
Credit Cash (Fund 10, Account 10X)
Reclassify the expenditures originally charged to special education project codes:
Debit new expenditure code using (Fund 10, Program 2XX, Project 4634)
Credit original expenditure code
Record receivable if Medicaid not received by June 30 (estimate if amount is unknown):
Debit Intergovernmental Receivables (Fund 10, Project 4634, Account 141) for retained amount
Debit Intergovernmental Receivables (Fund 10, Project 3321, Account 141) for state portion
Credit Intergovernmental Payables (Fund 10, Project 3321, Account 410) for state portion
Credit Medicaid revenue (Fund 10, Project 4634, Source 4634) if received within 60 days after year end
OR
Credit Deferred Inflow (Fund 10, Project 4634, Account 623) if received more than 60 days after year end
Please see the full journal entry examples in the UFA Journal Entries on the Medicaid Journal Entries tab.
If you have further questions, please contact Kathy Bowers at kathy.bowers@iowa.gov or 515-210-9674, Jina Brincks at jina.brincks@iowa.gov or 515-313-5942, or Song Luong at song.luong1@iowa.gov or 515-205-0259.
|