Question

1 Approved Answer

Posted on Sep 05, 2024

Somebody help me do a Statement of Revenues, Expenditures, and Changes in Fund Balances please Ref Year Account Description Est. Revenues Dr(Cr) Revenues Cr(Dr) Balance

Somebody help me do a Statement of Revenues, Expenditures, and Changes in Fund Balances please

image text in transcribed

Ref Year Account Description Est. Revenues Dr(Cr) Revenues Cr(Dr) Balance Dr(Cr) Estimated Revenues-Taxes-Real Property 102 2020 Budget authorization 6.792,000 6,792,000 103 2020 Accrued revenue 6,792,000 0 112 2020 Previous deferral 371,860 (371,860) 109 2020 Accrued revenue (308,000) (63,860) 111 2020 Closing Entry (6,792,000) (6,855,860) 111 2020 Closing Entry (6,792,000) ( (63,860) 111 2020 Closing Entry 308.000 (371,860) 111 2020 Closing Entry (371,860) 0 Estimated Revenues-Taxes-Sales 102 2020 Budget authorization 775,000 775,000 103 2020 Received in cash 748,000 27,000 111 2020 Closing Entry (775,000) (748,000) 111 2020 Closing Entry (748,000) 0 Estimated Revenues-Interest and Penalties on Taxes 102 2020 Budget authorization 49,000 49,000 110 2020 Budget amendment (10,000) 39,000 111 2020 Closing Entry (49.000) (10,000 111 2020 Closing Entry 10,000 0 Estimated Revenues-Licenses and Permits 102 2020 Budget authorization 485,000 485,000 103 2020 Received in cash 479.000 6,000 111 2020 Closing Entry (485,000) (479,000) 111 2020 Closing Entry (479,000) 0 102 2020 Estimated Revenues-Fines and Forfeits Budget authorization Received in cash 515,000 515,000 103 2020 519,000 (4,000) 111 2020 Closing Entry (515,000) (519,000) 111 2020 Closing Entry (519,000) 0 Estimated Revenues-Intergovernmental Revenue Budget authorization 102 2020 535,000 535,000 Ref Year Account Description Est. Revenues Dr(Cr) Revenues Cr(Dr) Balance Dr(Cr) 103 2020 Previous deferral 30,000 505,000 103 2020 Received in cash 515,000 (10,000) 111 2020 Closing Entry (535,000) (545,000) 111 2020 Closing Entry (30,000) (515,000) 111 2020 Closing Entry (515,000) 0 Estimated Revenues-Charges for Services 102 2020 Budget authorization 350,000 350,000 103 2020 Received in cash 361,000 (11,000) 111 2020 Closing Entry (350,000) (361,000) 111 2020 Closing Entry (361,000) 0 Estimated Revenues-Miscellaneous Revenues 102 2020 Budget authorization 220,000 220,000 103 2020 Received in cash 226,500 (6,500) 111 2020 Closing Entry (220,000) (226,500) 111 2020 Closing Entry (226,500) 0 Ref Account Description Enc. Increase Enc. Decrease Enc. Balance Exp. DriCr) Exp. Balance Approp. Cr(Dr) Balance Cr(Dr) Appropriations-General Government 102 Budget authorization 103 Purchase orders 195,000 1,905,000 1,905,000 1,510,000 395,000 395.000 104 Payroll 1,500,376 1,500,376 9,624 394,060 940 403,684 105 Purchase orders 105 Goods received 110 Budget amendment 395,940 1,896,316 7.744 (5,000) 2,744 111 Closing Entry (1,910,000) (1,907,256) 111 Closing Entry (1,500,376) 395,940 (406,880) 111 Closing Entry (395,940) 0 (10.940) Appropriations Public Safety 102 3,675,000 3,675,000 Budget authorization Purchase orders 103 1,095,000 1,095,000 2,580,000 104 Payroll 2,531,644 2,531,844 2,531,644 48,356 105 1,088,600 6,400 1,136,956 1.086.650 3,618,294 50,306 Purchase orders 105 Goods received 108 Utilities and other Closing Entry 50,000 3,668,294 306 111 (3,665,000) (3,664,694) 111 Closing Entry (2,531,644) 1,136,650 (1,133,050) 111 Closing Entry (1,086,650) 50.000 (46,400) 111 Closing Entry (50,000) 0 3,600 Appropriations Public Works 102 Budget authorization 1,775,000 1,775,000 103 Purchase orders 985,750 985,750 789,250 104 Payroll 790,481 790,481 (1.231) 967,620 18,130 966,389 105 Purchase orders 105 Goods received 962,300 1,752,781 4,089 111 Closing Entry (1,775,000) (1,770,911) 111 Closing Entry (790,481) 962,300 (980,430) 111 Closing Entry (962,300) 0 (18,130) Appropriations-Health and Welfare 102 Budget authorization 1.065.000 1065.000 1,065,000 Account Description Ref Enc. Increase Enc. Decrease Enc. Balance Exp. Dricr) Exp. Balance Approp. Cr(Dr) Balance Cr(Dr) 103 Purchase orders 665,725 665,725 399,275 104 Payroll 401,673 401,673 (2,398) 663,600 2.125 661,202 105 Purchase orders Goods received 105 661,200 1,062,873 2 111 Closing Entry (1,065,000) (1,064,998) 111 Closing Entry (401,673) 661,200 (663,325) 111 Closing Entry (661,200) 0 (2,125) Appropriations-Culture and Recreation 102 Budget authorization 1,080,000 1.080.000 103 Purchase orders 625,125 625,125 454,875 104 Payroll 448.864 448,864 6,011 105 Purchase orders 617,000 617,000 8,125 623,011 105 Goods received 613.750 1,062,614 9,261 111 Closing Entry (1,080,000) (1,070,739) 111 Closing Entry (448,864) 613,750 (621,875) 111 Closing Entry (613,750) 0 (8,125) Appropriations-Miscellaneous 105,000 105,000 103 98,000 98.000 7,000 102 Budget authorization Purchase orders Purchase orders 105 Goods received 107 Utilities and other 105 98,000 0 105,000 98,000 98.000 7,000 10.000 108,000 (3.000) 111 Closing Entry (105,000) (108,000) 111 Closing Entry (98,000) 10,000 (10,000) 111 Closing Entry (10,000) 0 0 Ref Year Account Description Est. Revenues Dr(Cr) Revenues Cr(Dr) Balance Dr(Cr) Estimated Revenues-Taxes-Real Property 102 2020 Budget authorization 6.792,000 6,792,000 103 2020 Accrued revenue 6,792,000 0 112 2020 Previous deferral 371,860 (371,860) 109 2020 Accrued revenue (308,000) (63,860) 111 2020 Closing Entry (6,792,000) (6,855,860) 111 2020 Closing Entry (6,792,000) ( (63,860) 111 2020 Closing Entry 308.000 (371,860) 111 2020 Closing Entry (371,860) 0 Estimated Revenues-Taxes-Sales 102 2020 Budget authorization 775,000 775,000 103 2020 Received in cash 748,000 27,000 111 2020 Closing Entry (775,000) (748,000) 111 2020 Closing Entry (748,000) 0 Estimated Revenues-Interest and Penalties on Taxes 102 2020 Budget authorization 49,000 49,000 110 2020 Budget amendment (10,000) 39,000 111 2020 Closing Entry (49.000) (10,000 111 2020 Closing Entry 10,000 0 Estimated Revenues-Licenses and Permits 102 2020 Budget authorization 485,000 485,000 103 2020 Received in cash 479.000 6,000 111 2020 Closing Entry (485,000) (479,000) 111 2020 Closing Entry (479,000) 0 102 2020 Estimated Revenues-Fines and Forfeits Budget authorization Received in cash 515,000 515,000 103 2020 519,000 (4,000) 111 2020 Closing Entry (515,000) (519,000) 111 2020 Closing Entry (519,000) 0 Estimated Revenues-Intergovernmental Revenue Budget authorization 102 2020 535,000 535,000 Ref Year Account Description Est. Revenues Dr(Cr) Revenues Cr(Dr) Balance Dr(Cr) 103 2020 Previous deferral 30,000 505,000 103 2020 Received in cash 515,000 (10,000) 111 2020 Closing Entry (535,000) (545,000) 111 2020 Closing Entry (30,000) (515,000) 111 2020 Closing Entry (515,000) 0 Estimated Revenues-Charges for Services 102 2020 Budget authorization 350,000 350,000 103 2020 Received in cash 361,000 (11,000) 111 2020 Closing Entry (350,000) (361,000) 111 2020 Closing Entry (361,000) 0 Estimated Revenues-Miscellaneous Revenues 102 2020 Budget authorization 220,000 220,000 103 2020 Received in cash 226,500 (6,500) 111 2020 Closing Entry (220,000) (226,500) 111 2020 Closing Entry (226,500) 0 Ref Account Description Enc. Increase Enc. Decrease Enc. Balance Exp. DriCr) Exp. Balance Approp. Cr(Dr) Balance Cr(Dr) Appropriations-General Government 102 Budget authorization 103 Purchase orders 195,000 1,905,000 1,905,000 1,510,000 395,000 395.000 104 Payroll 1,500,376 1,500,376 9,624 394,060 940 403,684 105 Purchase orders 105 Goods received 110 Budget amendment 395,940 1,896,316 7.744 (5,000) 2,744 111 Closing Entry (1,910,000) (1,907,256) 111 Closing Entry (1,500,376) 395,940 (406,880) 111 Closing Entry (395,940) 0 (10.940) Appropriations Public Safety 102 3,675,000 3,675,000 Budget authorization Purchase orders 103 1,095,000 1,095,000 2,580,000 104 Payroll 2,531,644 2,531,844 2,531,644 48,356 105 1,088,600 6,400 1,136,956 1.086.650 3,618,294 50,306 Purchase orders 105 Goods received 108 Utilities and other Closing Entry 50,000 3,668,294 306 111 (3,665,000) (3,664,694) 111 Closing Entry (2,531,644) 1,136,650 (1,133,050) 111 Closing Entry (1,086,650) 50.000 (46,400) 111 Closing Entry (50,000) 0 3,600 Appropriations Public Works 102 Budget authorization 1,775,000 1,775,000 103 Purchase orders 985,750 985,750 789,250 104 Payroll 790,481 790,481 (1.231) 967,620 18,130 966,389 105 Purchase orders 105 Goods received 962,300 1,752,781 4,089 111 Closing Entry (1,775,000) (1,770,911) 111 Closing Entry (790,481) 962,300 (980,430) 111 Closing Entry (962,300) 0 (18,130) Appropriations-Health and Welfare 102 Budget authorization 1.065.000 1065.000 1,065,000 Account Description Ref Enc. Increase Enc. Decrease Enc. Balance Exp. Dricr) Exp. Balance Approp. Cr(Dr) Balance Cr(Dr) 103 Purchase orders 665,725 665,725 399,275 104 Payroll 401,673 401,673 (2,398) 663,600 2.125 661,202 105 Purchase orders Goods received 105 661,200 1,062,873 2 111 Closing Entry (1,065,000) (1,064,998) 111 Closing Entry (401,673) 661,200 (663,325) 111 Closing Entry (661,200) 0 (2,125) Appropriations-Culture and Recreation 102 Budget authorization 1,080,000 1.080.000 103 Purchase orders 625,125 625,125 454,875 104 Payroll 448.864 448,864 6,011 105 Purchase orders 617,000 617,000 8,125 623,011 105 Goods received 613.750 1,062,614 9,261 111 Closing Entry (1,080,000) (1,070,739) 111 Closing Entry (448,864) 613,750 (621,875) 111 Closing Entry (613,750) 0 (8,125) Appropriations-Miscellaneous 105,000 105,000 103 98,000 98.000 7,000 102 Budget authorization Purchase orders Purchase orders 105 Goods received 107 Utilities and other 105 98,000 0 105,000 98,000 98.000 7,000 10.000 108,000 (3.000) 111 Closing Entry (105,000) (108,000) 111 Closing Entry (98,000) 10,000 (10,000) 111 Closing Entry (10,000) 0 0