The City of Castleton's General Fund had the following post-closing trial balance at June 30, 2022, the end of its fiscal year. Debits Credits Cash $ 358,000 Sales Taxes Receivable 15, eee Taxes Receivable-Delinquent 587,000 Allowance for Uncollectible Delinquent Taxes $ 193,280 Interest and Penalties Receivable 26,680 Allowance for Uncollectible Interest and Penalties 11,560 Inventory of Supplies 16,500 Vouchers Payable 152,500 Due to Federal Government 63,490 Deferred Inflows of Resources-Unavailable Revenues 366, eee Fund Balance-Nonspendable-Inventory of Supplies 16,500 Fund Balance-Unassigned 200, 130 $1,ee3, 189 $1,003,180 a Record the effect of the following transactions on the General Fund and governmental activities for the year ended June 30, 2023. b. Record in general journal form entries to close the budgetary and operating statement accounts in the General Fund only c. Prepare a General Fund balance sheet as of June 30, 2023 d. Prepare a General Fund statement of revenues, expenditures, and changes in fund balance for the year ended June 30, 2023. Required A Required B Required Required D Record the effect of the following transactions on the General Fund and governmental activities for the year ended June 30, 2023. Avoid use of functional detalls for expenses and itemization of revenue accounts. So, use of account names "Expenses" and "Revenues will suffice wherever required. (If no entry is required for a transaction/event, select 'No Journal Entry Required in the first account field.) Transaction Fund Governmental Debit General Journal Credit Activities 1. The budget for FY 2023 provided for General Fund estimated revenues totaling 53.220.000, appropriations totaling 53,040,000, and another financing use--interfund transfer out of $136.000 General Fund 2. The city council authorized temporary borrowing of $540,000 in the form of a 120-day tax anticipation note obtained from a local bank General Fund and Governmental Activities 3. The property tax levy for FY 2023 was recorded. Net assessed Valuation of taxable property for the year was $45,000,000, and the tax rate was $5 per $100. It was estimated that 4 percent of the levy would be uncollectible 3 General Fund Govermental Activities 4. Purchase orders and contracts were issued to vendors and others in the amount of $2,100,000 4 General Fund Governmental Activities 5. $2,050,000 of current taxes, $387 270 of delinquent taxes, $20,970 of interest and penalties, and $15,000 of accrued sales taxes were collected. The delinquent taxes and associated interest and penalties were collected more than 60 days after the prior year-end. Record the $2,050,000 of current taxes, $387 270 of delinquent taxes, and $20,970 of interest and penalties collected 5a General Fund 5b Record the delinquent taxes and associated interest and penalties collected more than 60 days after the prior year-end 50 Governmental Activities Record the $2,050,000 of current taxes, $387,270 of delinquent taxes, and $20,970 of interest and penalties collected 5d Record the delinquent taxes and associated interest and penalties collected more than 60 days after the prior year-end. 6. Additional interest and penalties on delinquent taxes were accrued in the amount of $38,840, of which 25 percent was estimated to be uncollectible. 6 General Fund Governmental Activities 7. Because of a change in state law, the city was notified that it will receive $88.000 less in intergovernmental revenues than was budgeted. 7 General Fund Governmental Activities 8. Delinquent taxes of $13,192 were deemed uncollectible and written off. The associated interest and penalties of $992 also were written off General Fund 8 Governmental Activities 9. Total payroll during the year was 5859,490. Of that amount, $65,750 was withheld for employees' FICA tax liability, 5107 710 for employees' federal income tax liability, and 34,800 for state taxes, the balance was paid to employees in cash. 9 General Fund Governmental Activities 10. The employer's FICA tax liability was recorded for $65,750 10 General Fund Governmental Activities 130 130 Governmental Activities Record the receipt of vouchers for the purchase orders and contracts encumbered for 2023 14. Vouchers payable totaling $2,341,680 were paid after deducting a credit for purchases discount of $8.430 (credit Expenditures). 14 General Fund Governmental Activities 15. The tax anticipation note of $540,000 was repaid. Interest totaled $10,400 15 General Fund Governmental Activities 16. A transfer of 5136,000 was made to establish a special revenue fund to account for expenditures related to a federal grant 16 General Fund Governmental Activities 17. All unpaid current year's property taxes became delinquent. The balances of the current taxes receivable and related uncollectibles were transferred to delinquent accounts. The City uses the 60-day rule for all revenues and does not expect to collect any delinquent property taxes or interest and penalties in the first 60 days of the next fiscal year. 17a General Fund Record the reclassification of the unpaid property taxes of current year. 17 Record the reclassification of the related allowance for estimated uncollectible Stoperty taxes of current year, 170 Record the reclassification of the property tax revenue of current year. 170 Governmental Activities Record the reclassification of the unpaid property taxes of current year 17e Record the reclassification of the related allowance for estimated uncollectible property taxes of current year. 171 Record the reclassification of the property tax rovenue of current year. 18. A physical inventory of materials and supplies at June 30, 2023, showed a total of $19.900. Inventory is recorded using the purchases method in the General Fund, the consumption method is used at the government-wide level. (Note: A periodic inventory system is used both in the General Fund and at the government-wide level. When inventory was purchased during the year. Expenditures were debited in the General Fund journal and Inventory of Supplies was debited in the governmental activities journal.) 18 General Fund Governmental Activities Required Required B Required Required D Record in general Journal form entries to close the budgetary and operating statement accounts in the General Fund only. (Ir no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.) Transactions Fund General Journal Debit Credit 1. Record the closure of budgetary statements account General Fund 1 2. Record the closure of operating statements account 2 General Fund Required A Required B Required Required D Prepare a General Fund balance sheet as of June 30, 2023. CITY OF CASTLETON General Fund Balance Sheet As of June 30, 2023 Assets 0 0 $ 0 Cash Sales Taxes Receivable Taxes Receivable-Delinquent Less: Allowance for Uncollectible Taxes-Delinquent Interest and Penalties Receivable Less: Allowance for Uncollectible Interest and Penalties Inventory of Supplies Total Assets Liabilities and Fund Balances Liabilities: Vouchers Payable Deferred Inflows of ResourcesUnavailable Revenues Total Liabilities and Deferred Inflows of Resources Fund Balances: Nonspendable-Inventory of Supplies Unassigned Total Fund Balances Total Liabilities and Fund Balances 0 0 $ 0 Required A Required B Required C Required D Prepare a General Fund statement of revenues, expenditures, and changes i CITY OF CASTLETON General Fund Statement of Revenues, Expenditures, and Changes in Fund Balance For the Year Ended June 30, 2023 Revenues 0 Taxes Interest and Penalties on Taxes Other Sources Total Revenues Expenditures Salaries and Wages Interest on Notes Payable Other Total Expenditures Excess of Revenues over Expenditures Other Financing Uses Change In Fund Balance Increase in Inventory of Supplies Fund Balances, July 1, 2022 Fund Balances, June 30, 2023 $ 0 0 $ 0 The City of Castleton's General Fund had the following post-closing trial balance at June 30, 2022, the end of its fiscal year. Debits Credits Cash $ 358,000 Sales Taxes Receivable 15, eee Taxes Receivable-Delinquent 587,000 Allowance for Uncollectible Delinquent Taxes $ 193,280 Interest and Penalties Receivable 26,680 Allowance for Uncollectible Interest and Penalties 11,560 Inventory of Supplies 16,500 Vouchers Payable 152,500 Due to Federal Government 63,490 Deferred Inflows of Resources-Unavailable Revenues 366, eee Fund Balance-Nonspendable-Inventory of Supplies 16,500 Fund Balance-Unassigned 200, 130 $1,ee3, 189 $1,003,180 a Record the effect of the following transactions on the General Fund and governmental activities for the year ended June 30, 2023. b. Record in general journal form entries to close the budgetary and operating statement accounts in the General Fund only c. Prepare a General Fund balance sheet as of June 30, 2023 d. Prepare a General Fund statement of revenues, expenditures, and changes in fund balance for the year ended June 30, 2023. Required A Required B Required Required D Record the effect of the following transactions on the General Fund and governmental activities for the year ended June 30, 2023. Avoid use of functional detalls for expenses and itemization of revenue accounts. So, use of account names "Expenses" and "Revenues will suffice wherever required. (If no entry is required for a transaction/event, select 'No Journal Entry Required in the first account field.) Transaction Fund Governmental Debit General Journal Credit Activities 1. The budget for FY 2023 provided for General Fund estimated revenues totaling 53.220.000, appropriations totaling 53,040,000, and another financing use--interfund transfer out of $136.000 General Fund 2. The city council authorized temporary borrowing of $540,000 in the form of a 120-day tax anticipation note obtained from a local bank General Fund and Governmental Activities 3. The property tax levy for FY 2023 was recorded. Net assessed Valuation of taxable property for the year was $45,000,000, and the tax rate was $5 per $100. It was estimated that 4 percent of the levy would be uncollectible 3 General Fund Govermental Activities 4. Purchase orders and contracts were issued to vendors and others in the amount of $2,100,000 4 General Fund Governmental Activities 5. $2,050,000 of current taxes, $387 270 of delinquent taxes, $20,970 of interest and penalties, and $15,000 of accrued sales taxes were collected. The delinquent taxes and associated interest and penalties were collected more than 60 days after the prior year-end. Record the $2,050,000 of current taxes, $387 270 of delinquent taxes, and $20,970 of interest and penalties collected 5a General Fund 5b Record the delinquent taxes and associated interest and penalties collected more than 60 days after the prior year-end 50 Governmental Activities Record the $2,050,000 of current taxes, $387,270 of delinquent taxes, and $20,970 of interest and penalties collected 5d Record the delinquent taxes and associated interest and penalties collected more than 60 days after the prior year-end. 6. Additional interest and penalties on delinquent taxes were accrued in the amount of $38,840, of which 25 percent was estimated to be uncollectible. 6 General Fund Governmental Activities 7. Because of a change in state law, the city was notified that it will receive $88.000 less in intergovernmental revenues than was budgeted. 7 General Fund Governmental Activities 8. Delinquent taxes of $13,192 were deemed uncollectible and written off. The associated interest and penalties of $992 also were written off General Fund 8 Governmental Activities 9. Total payroll during the year was 5859,490. Of that amount, $65,750 was withheld for employees' FICA tax liability, 5107 710 for employees' federal income tax liability, and 34,800 for state taxes, the balance was paid to employees in cash. 9 General Fund Governmental Activities 10. The employer's FICA tax liability was recorded for $65,750 10 General Fund Governmental Activities 130 130 Governmental Activities Record the receipt of vouchers for the purchase orders and contracts encumbered for 2023 14. Vouchers payable totaling $2,341,680 were paid after deducting a credit for purchases discount of $8.430 (credit Expenditures). 14 General Fund Governmental Activities 15. The tax anticipation note of $540,000 was repaid. Interest totaled $10,400 15 General Fund Governmental Activities 16. A transfer of 5136,000 was made to establish a special revenue fund to account for expenditures related to a federal grant 16 General Fund Governmental Activities 17. All unpaid current year's property taxes became delinquent. The balances of the current taxes receivable and related uncollectibles were transferred to delinquent accounts. The City uses the 60-day rule for all revenues and does not expect to collect any delinquent property taxes or interest and penalties in the first 60 days of the next fiscal year. 17a General Fund Record the reclassification of the unpaid property taxes of current year. 17 Record the reclassification of the related allowance for estimated uncollectible Stoperty taxes of current year, 170 Record the reclassification of the property tax revenue of current year. 170 Governmental Activities Record the reclassification of the unpaid property taxes of current year 17e Record the reclassification of the related allowance for estimated uncollectible property taxes of current year. 171 Record the reclassification of the property tax rovenue of current year. 18. A physical inventory of materials and supplies at June 30, 2023, showed a total of $19.900. Inventory is recorded using the purchases method in the General Fund, the consumption method is used at the government-wide level. (Note: A periodic inventory system is used both in the General Fund and at the government-wide level. When inventory was purchased during the year. Expenditures were debited in the General Fund journal and Inventory of Supplies was debited in the governmental activities journal.) 18 General Fund Governmental Activities Required Required B Required Required D Record in general Journal form entries to close the budgetary and operating statement accounts in the General Fund only. (Ir no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.) Transactions Fund General Journal Debit Credit 1. Record the closure of budgetary statements account General Fund 1 2. Record the closure of operating statements account 2 General Fund Required A Required B Required Required D Prepare a General Fund balance sheet as of June 30, 2023. CITY OF CASTLETON General Fund Balance Sheet As of June 30, 2023 Assets 0 0 $ 0 Cash Sales Taxes Receivable Taxes Receivable-Delinquent Less: Allowance for Uncollectible Taxes-Delinquent Interest and Penalties Receivable Less: Allowance for Uncollectible Interest and Penalties Inventory of Supplies Total Assets Liabilities and Fund Balances Liabilities: Vouchers Payable Deferred Inflows of ResourcesUnavailable Revenues Total Liabilities and Deferred Inflows of Resources Fund Balances: Nonspendable-Inventory of Supplies Unassigned Total Fund Balances Total Liabilities and Fund Balances 0 0 $ 0 Required A Required B Required C Required D Prepare a General Fund statement of revenues, expenditures, and changes i CITY OF CASTLETON General Fund Statement of Revenues, Expenditures, and Changes in Fund Balance For the Year Ended June 30, 2023 Revenues 0 Taxes Interest and Penalties on Taxes Other Sources Total Revenues Expenditures Salaries and Wages Interest on Notes Payable Other Total Expenditures Excess of Revenues over Expenditures Other Financing Uses Change In Fund Balance Increase in Inventory of Supplies Fund Balances, July 1, 2022 Fund Balances, June 30, 2023 $ 0 0 $ 0