Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

# Transaction Account DR CR 1 Government levied $2,000,000 of General Fund Property tax for the fiscal year with an estimated uncollectible amount of $400,000.

#

Transaction

Account

DR

CR

1

Government levied $2,000,000 of General Fund Property tax for the fiscal year with an estimated uncollectible amount of $400,000.

2

The General Fund paid $350,000 on the vouchers payable that were outstanding at the end of FY 2013.

3

The General Fund paid the $13,000 reported as Due to Other Funds at the end of FY 2013. This amount was reported as Internal Payables to Business -type Activities at the government-wide level.

Assume that it is Tax Year 2014. Complete the yellow area for the General Fund only.

Chart of Accounts for General Fund

Cash

Taxes ReceivableCurrent

Estimated Uncollectible Current Taxes

Taxes ReceivableDelinquent

Estimated Uncollectible Delinquent Taxes

Interest and Penalties Receivable on Taxes

Estimated Uncollectible Interest and Penalties

Due from Other Funds

Due from State Government

Inventory of Supplies

Vouchers Payable

Tax Anticipation Notes Payable

Due to Other Funds

Due to Federal Government

Due to State Government

Fund BalanceNonspendableInventory of Supplies

Fund BalanceRestrictedGeneral Government

Fund BalanceRestrictedPublic Safety

Fund BalanceRestrictedPublic Works

Fund BalanceRestrictedHealth and Welfare

Fund BalanceRestrictedCulture and Recreation

Fund BalanceCommittedGeneral Government

Fund BalanceCommittedPublic Safety

Fund BalanceCommittedPublic Works

Fund BalanceCommittedHealth and Welfare

Fund BalanceCommittedCulture and Recreation

Fund BalanceAssignedGeneral Government

Fund BalanceAssignedPublic Safety

Fund BalanceAssignedPublic Works

Fund BalanceAssignedHealth and Welfare

Fund BalanceAssignedCulture and Recreation

Fund BalanceUnassigned

Budgetary Fund Balance

Encumbrances Outstanding

Estimated Revenues

Revenues

Appropriations

Estimated Other Financing UsesInterfund Transfers Out

Expenditures

Other Financing UsesInterfund Transfers Out

Assignment Option #1: Government Transactions

Using the data in the Option 1 Spreadsheet (linked at the bottom of the page), perform the accounting required for each of the following government fund transaction:

Perform the required journal entries

Requirements:

Complete all work on the spreadsheet attached to this assignment; it will be your only deliverable.

Clearly identify the requirements being addressed. Show all calculations within the cells of an Excel spreadsheet. This means that you must use formulas and links so that the thought process can be examined. Make good use of comments to convey your thought process as well. No hard coding of solutions. Submit a single MS Excel file for grading.

Review the grading rubric to understand how you will be graded on this assignment. Reach out to your instructor if you have questions about the assignment.

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

Financial Accounting And Reporting

Authors: Mr Barry Elliott, Jamie Elliott

16th Edition

027377817X, 978-0273778172

More Books

Students also viewed these Accounting questions

Question

Solve this pair of simultaneous equations: xy = 4 y = x 3

Answered: 1 week ago

Question

Define self-esteem and discuss its impact on your life.

Answered: 1 week ago