Answered step by step
Verified Expert Solution
Link Copied!

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!

image text in transcribed

Below is the information needed. I'm struggling and would like to cross check my work.

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Fundamentals For Health Care Management

Authors: Steven A. Finkler, David M. Ward, Thad Calabrese

3rd Edition

1284124932, 9781284124934

More Books

Students also viewed these Accounting questions

Question

Id probably just get more upset. Its bett er to just drop it.

Answered: 1 week ago