Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help filling out the following balance sheet. I'm having a hard time figuring out what goes where. Thank you! Below is the information
I need help filling out the following balance sheet. I'm having a hard time figuring out what goes where. Thank you!
Below is the information needed. I'm struggling and would like to cross check my work.
Any help would be reall appreciated! Thank you!
\begin{tabular}{|c|c|c|c|c|c|} \hline & & Allowance for Uncollectible Interest and Penalties & & & \\ \hline 2022 & 101 & 2-B & & 1,203 & (1,203) \\ \hline \multirow[t]{2}{*}{2023} & 111 & 4A9 & & 1,536 & (2,739) \\ \hline & & Due from State Government & & & \\ \hline 2022 & 101 & 2B & 165,000 & & 165,000 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|r|} \hline & & Expenditures & & \\ \hline 2023 & 110 & 4A5 & 3,187,748 & \\ \hline 2023 & 108 & 4A6 & 799,582 & 3,187,748 \\ \hline 2023 & 113 & Closing Entry & & 3,987,330 \\ \hline & & & & \\ \hline & & Other Financing Uses-Interfund Transfers Out & & \\ \hline 2023 & 109 & 4A10 & 1,250 & \\ \hline \end{tabular} General Ledger City of Smithville 1 - General Fund \begin{tabular}{|c|c|c|c|c|c|} \hline Year & Ref & Account Description & Debits & Credits & \begin{tabular}{c} Balance \\ Dr(Cr) \end{tabular} \\ \hline & & Cash & & & \\ \hline 2022 & 101 & 2B & 342,223 & & 342,223 \\ \hline 2023 & 105 & 4A3 & 4,305,169 & & 4,647,392 \\ \hline 2023 & 110 & 4A5 & & 2,040,087 & 2,607,305 \\ \hline 2023 & 109 & 4A7 & & 2,018,452 & 588,853 \\ \hline 2023 & 109 & 4A10 & & 1,250 & 587,603 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Year & Ref & Account Description & Debits & Credits & \begin{tabular}{c} Balance \\ Dr(Cr) \end{tabular} \\ \hline & & Budgetary Fund Balance & & & \\ \hline 2023 & 102 & 3A & 1,767 & & 1,767 \\ \hline \multirow[t]{2}{*}{2023} & 112 & Closing Entry & & 1,767 & 0 \\ \hline & & Encumbrances Outstanding & & & \\ \hline 2023 & 104 & 4A2 & & 833,271 & (833,271) \\ \hline \multirow[t]{2}{*}{2023} & 107 & 4A6 & 800,061 & & (33,210) \\ \hline & & Estimated Revenues & & & \\ \hline 2023 & 102 & 3A & 4,020,633 & & 4,020,633 \\ \hline 2023 & 112 & Closing Entry & & 4,020,633 & 0 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Year & Ref & Account Description & Debits & Credits & \begin{tabular}{c} Balance \\ Dr(Cr) \end{tabular} \\ \hline \multirow[t]{2}{*}{2023} & 105 & 4A3 & & 165,000 & 0 \\ \hline & & Vouchers Payable & & & \\ \hline 2022 & 101 & 2B & & 272,187 & (272,187) \\ \hline 2023 & 108 & 4A6 & & 799,582 & (1,071,769) \\ \hline \multirow[t]{2}{*}{2023} & 109 & 4A7 & 872,228 & & (199,541) \\ \hline & & Due to Federal Government & & & \\ \hline 2022 & 101 & 2-B & & 135,720 & (135,720) \\ \hline 2023 & 110 & 4A5 & & 908,508 & (1,044,228) \\ \hline 2023 & 109 & 4A7 & 907,952 & & (136,276) \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline & & Allowance for Uncollectible Current Taxes & & & \\ \hline 2023 & 103 & 4A1 & & 18,787 & (18,787) \\ \hline 2023 & 103 & 4A8 & 18,787 & & 0 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline & & Revenues & & & \\ \hline 2023 & 103 & 4A1 & & 1,859,913 & (1,859,913) \\ \hline 2023 & 105 & 4A3 & & 2,121,803 & (3,981,716) \\ \hline 2023 & 106 & 4A4 & & 95,881 & (4,077,597) \\ \hline 2023 & 103 & 4A8 & 70,450 & & (4,007,147) \\ \hline 2023 & 111 & 4A9 & & 4,805 & (4,011,952) \\ \hline \multirow[t]{2}{*}{2023} & 113 & Closing Entry & 4,011,952 & & 0 \\ \hline & & Appropriations & & & \\ \hline 2023 & 102 & 3A & & 4,021,150 & (4,021,150) \\ \hline \multirow[t]{2}{*}{2023} & 112 & Closing Entry & 4,021,150 & & 0 \\ \hline & & Estimated Other Financing Uses-Interfund Transfers Out & & & \\ \hline 2023 & 102 & 3A & & 1,250 & (1,250) \\ \hline 2023 & 112 & Closing Entry & 1,250 & & 0 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline & & Taxes Receivable-Delinquent & & & \\ \hline 2022 & 101 & 2B & 391,756 & & 391,756 \\ \hline 2023 & 105 & 4A3 & & 387,201 & 4,555 \\ \hline \multirow[t]{2}{*}{2023} & 103 & 4A8 & 281,805 & & 286,360 \\ \hline & & Allowance for Uncollectible Delinquent Taxes & & & \\ \hline 2022 & 101 & 2B & & 4,752 & (4,752) \\ \hline \multirow[t]{2}{*}{2023} & 103 & 4A8 & & 18,787 & (23,539) \\ \hline & & Interest and Penalties Receivable on Taxes & & & \\ \hline 2022 & 101 & 2B & 37,718 & & 37,718 \\ \hline 2023 & 105 & 4A3 & & 34,270 & 3,448 \\ \hline 2023 & 111 & 4A9 & 8,454 & & 11,902 \\ \hline \end{tabular} \begin{tabular}{|r|r|l|r|r|r|} \hline & & Taxes Receivable-Current & & \\ \hline 2023 & 103 & 4A1 & 1,878,700 & 1,878,700 \\ \hline 2023 & 105 & 4A3 & & 1,596,895 & 281,805 \\ \hline 2023 & 103 & 4A8 & & 281,805 & 0 \\ \hline & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Year & Ref & Account Description & Debits & Credits & \begin{tabular}{c} Balance \\ Dr(Cr) \end{tabular} \\ \hline \multirow[t]{2}{*}{2023} & 112 & Closing Entry & & 1,250 & 0 \\ \hline & & Encumbrances & & & \\ \hline 2023 & 104 & 4A2 & 833,271 & & 833,271 \\ \hline 2023 & 107 & 4A6 & & 800,061 & 33,210 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline & & Due to State Government & & & \\ \hline 2022 & 101 & 2B & & 32,600 & (32,600) \\ \hline 2023 & 110 & 4A5 & & 239,153 & (271,753) \\ \hline \multirow[t]{2}{*}{2023} & 109 & 4A7 & 238,272 & & (33,481) \\ \hline & & Deferred Inflows of Resources & & & \\ \hline 2022 & 101 & 2B & & 97,704 & (97,704) \\ \hline 2023 & 106 & 4A4 & 95,881 & & (1,823) \\ \hline 2023 & 103 & 4A8 & & 70,450 & (72,273) \\ \hline \multirow[t]{2}{*}{2023} & 111 & 4A9 & & 2,113 & (74,386) \\ \hline & & Fund Balance-Restricted-Public Safety & & & \\ \hline 2022 & 101 & 2B & & 114,000 & (114,000) \\ \hline 2023 & 114 & Closing Entry & 60,000 & & (54,000) \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline & & Fund Balance-Assigned-Culture and Recreation & & & \\ \hline 2022 & 101 & 2B & & 56,800 & (56,800) \\ \hline \multirow[t]{2}{*}{2023} & 114 & Closing Entry & 56,800 & & 0 \\ \hline & & Fund Balance-Unassigned & & & \\ \hline 2022 & 101 & 2B & & 221,731 & (221,731) \\ \hline 2023 & 112 & Closing Entry & 1,250 & & (220,481) \\ \hline 2023 & 113 & Closing Entry & & 24,622 & (245,103) \\ \hline 2023 & 114 & Closing Entry & & 116,800 & (361,903) \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline & & Allowance for Uncollectible Interest and Penalties & & & \\ \hline 2022 & 101 & 2-B & & 1,203 & (1,203) \\ \hline \multirow[t]{2}{*}{2023} & 111 & 4A9 & & 1,536 & (2,739) \\ \hline & & Due from State Government & & & \\ \hline 2022 & 101 & 2B & 165,000 & & 165,000 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|r|} \hline & & Expenditures & & \\ \hline 2023 & 110 & 4A5 & 3,187,748 & \\ \hline 2023 & 108 & 4A6 & 799,582 & 3,187,748 \\ \hline 2023 & 113 & Closing Entry & & 3,987,330 \\ \hline & & & & \\ \hline & & Other Financing Uses-Interfund Transfers Out & & \\ \hline 2023 & 109 & 4A10 & 1,250 & \\ \hline \end{tabular} General Ledger City of Smithville 1 - General Fund \begin{tabular}{|c|c|c|c|c|c|} \hline Year & Ref & Account Description & Debits & Credits & \begin{tabular}{c} Balance \\ Dr(Cr) \end{tabular} \\ \hline & & Cash & & & \\ \hline 2022 & 101 & 2B & 342,223 & & 342,223 \\ \hline 2023 & 105 & 4A3 & 4,305,169 & & 4,647,392 \\ \hline 2023 & 110 & 4A5 & & 2,040,087 & 2,607,305 \\ \hline 2023 & 109 & 4A7 & & 2,018,452 & 588,853 \\ \hline 2023 & 109 & 4A10 & & 1,250 & 587,603 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Year & Ref & Account Description & Debits & Credits & \begin{tabular}{c} Balance \\ Dr(Cr) \end{tabular} \\ \hline & & Budgetary Fund Balance & & & \\ \hline 2023 & 102 & 3A & 1,767 & & 1,767 \\ \hline \multirow[t]{2}{*}{2023} & 112 & Closing Entry & & 1,767 & 0 \\ \hline & & Encumbrances Outstanding & & & \\ \hline 2023 & 104 & 4A2 & & 833,271 & (833,271) \\ \hline \multirow[t]{2}{*}{2023} & 107 & 4A6 & 800,061 & & (33,210) \\ \hline & & Estimated Revenues & & & \\ \hline 2023 & 102 & 3A & 4,020,633 & & 4,020,633 \\ \hline 2023 & 112 & Closing Entry & & 4,020,633 & 0 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Year & Ref & Account Description & Debits & Credits & \begin{tabular}{c} Balance \\ Dr(Cr) \end{tabular} \\ \hline \multirow[t]{2}{*}{2023} & 105 & 4A3 & & 165,000 & 0 \\ \hline & & Vouchers Payable & & & \\ \hline 2022 & 101 & 2B & & 272,187 & (272,187) \\ \hline 2023 & 108 & 4A6 & & 799,582 & (1,071,769) \\ \hline \multirow[t]{2}{*}{2023} & 109 & 4A7 & 872,228 & & (199,541) \\ \hline & & Due to Federal Government & & & \\ \hline 2022 & 101 & 2-B & & 135,720 & (135,720) \\ \hline 2023 & 110 & 4A5 & & 908,508 & (1,044,228) \\ \hline 2023 & 109 & 4A7 & 907,952 & & (136,276) \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline & & Allowance for Uncollectible Current Taxes & & & \\ \hline 2023 & 103 & 4A1 & & 18,787 & (18,787) \\ \hline 2023 & 103 & 4A8 & 18,787 & & 0 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline & & Revenues & & & \\ \hline 2023 & 103 & 4A1 & & 1,859,913 & (1,859,913) \\ \hline 2023 & 105 & 4A3 & & 2,121,803 & (3,981,716) \\ \hline 2023 & 106 & 4A4 & & 95,881 & (4,077,597) \\ \hline 2023 & 103 & 4A8 & 70,450 & & (4,007,147) \\ \hline 2023 & 111 & 4A9 & & 4,805 & (4,011,952) \\ \hline \multirow[t]{2}{*}{2023} & 113 & Closing Entry & 4,011,952 & & 0 \\ \hline & & Appropriations & & & \\ \hline 2023 & 102 & 3A & & 4,021,150 & (4,021,150) \\ \hline \multirow[t]{2}{*}{2023} & 112 & Closing Entry & 4,021,150 & & 0 \\ \hline & & Estimated Other Financing Uses-Interfund Transfers Out & & & \\ \hline 2023 & 102 & 3A & & 1,250 & (1,250) \\ \hline 2023 & 112 & Closing Entry & 1,250 & & 0 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline & & Taxes Receivable-Delinquent & & & \\ \hline 2022 & 101 & 2B & 391,756 & & 391,756 \\ \hline 2023 & 105 & 4A3 & & 387,201 & 4,555 \\ \hline \multirow[t]{2}{*}{2023} & 103 & 4A8 & 281,805 & & 286,360 \\ \hline & & Allowance for Uncollectible Delinquent Taxes & & & \\ \hline 2022 & 101 & 2B & & 4,752 & (4,752) \\ \hline \multirow[t]{2}{*}{2023} & 103 & 4A8 & & 18,787 & (23,539) \\ \hline & & Interest and Penalties Receivable on Taxes & & & \\ \hline 2022 & 101 & 2B & 37,718 & & 37,718 \\ \hline 2023 & 105 & 4A3 & & 34,270 & 3,448 \\ \hline 2023 & 111 & 4A9 & 8,454 & & 11,902 \\ \hline \end{tabular} \begin{tabular}{|r|r|l|r|r|r|} \hline & & Taxes Receivable-Current & & \\ \hline 2023 & 103 & 4A1 & 1,878,700 & 1,878,700 \\ \hline 2023 & 105 & 4A3 & & 1,596,895 & 281,805 \\ \hline 2023 & 103 & 4A8 & & 281,805 & 0 \\ \hline & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Year & Ref & Account Description & Debits & Credits & \begin{tabular}{c} Balance \\ Dr(Cr) \end{tabular} \\ \hline \multirow[t]{2}{*}{2023} & 112 & Closing Entry & & 1,250 & 0 \\ \hline & & Encumbrances & & & \\ \hline 2023 & 104 & 4A2 & 833,271 & & 833,271 \\ \hline 2023 & 107 & 4A6 & & 800,061 & 33,210 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline & & Due to State Government & & & \\ \hline 2022 & 101 & 2B & & 32,600 & (32,600) \\ \hline 2023 & 110 & 4A5 & & 239,153 & (271,753) \\ \hline \multirow[t]{2}{*}{2023} & 109 & 4A7 & 238,272 & & (33,481) \\ \hline & & Deferred Inflows of Resources & & & \\ \hline 2022 & 101 & 2B & & 97,704 & (97,704) \\ \hline 2023 & 106 & 4A4 & 95,881 & & (1,823) \\ \hline 2023 & 103 & 4A8 & & 70,450 & (72,273) \\ \hline \multirow[t]{2}{*}{2023} & 111 & 4A9 & & 2,113 & (74,386) \\ \hline & & Fund Balance-Restricted-Public Safety & & & \\ \hline 2022 & 101 & 2B & & 114,000 & (114,000) \\ \hline 2023 & 114 & Closing Entry & 60,000 & & (54,000) \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline & & Fund Balance-Assigned-Culture and Recreation & & & \\ \hline 2022 & 101 & 2B & & 56,800 & (56,800) \\ \hline \multirow[t]{2}{*}{2023} & 114 & Closing Entry & 56,800 & & 0 \\ \hline & & Fund Balance-Unassigned & & & \\ \hline 2022 & 101 & 2B & & 221,731 & (221,731) \\ \hline 2023 & 112 & Closing Entry & 1,250 & & (220,481) \\ \hline 2023 & 113 & Closing Entry & & 24,622 & (245,103) \\ \hline 2023 & 114 & Closing Entry & & 116,800 & (361,903) \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started