Need Part $2$ to be completed

December business transactions

Dec. $1$st $$ Collected $$800$ from Franklin from a previous engagement in Oct.

Dec. $2$nd $$ Paid $$1,400$ on Gusto$$s Inc. invoice from a previously recorded transaction with check #$1301.$

Dec $3$rd $$ Paid December rent of $$2,200$ with check #$1302.$

Dec $4$th $$ Completed additional work for Washington, sent invoice #Y$77$P for $$1,500$ due in $1$ month.

Dec. $5$th $$ Paid employee from work previously expensed in Nov. with payment due Dec. $5$th using check #$1303.$

Dec. $8$th $-$ Purchased land on a note for $$23,000$ to be used for future construction of a new office building.

Land and Notes payable will have account numbers of $150$ and $240,$ respectively.

Dec. $9$th $-$ Paid $$1,600$ to cover all utilities for the month of Dec using check #$1304.$

Dec. $10$th $-$ Completed $$500$ worth of work for a repeat customer who pays cash immediately upon completion.

Dec. $11$th $-$ Collected $$800$ from Washington from a previous engagement in Nov.

Dec. $12$th $-$ Our employee earned two weeks of pay amounting to $$1,550,$ to be paid Dec. $23$rd$.$

$*$employee took vacation from Dec. $15$th$-$Dec. $31$st$.$ No pay will accrue$*$

Dec. $15$th $-$ Leah Tyler, the owner, withdrew $$3,100$ for personal use using check #$1305.$

Dec. $16$th $$ Completed a large job for Franklin for $$12,000.$ Sent invoice #Y$78$P due Jan. $31$st$.$

Dec. $22$nd $$ Franklin paid $$2,500$ to pay off some of his balance due.

Dec. $23$rd $$ Paid our employee for the work expensed Dec. $12$th$.$

Dec $24$th$-$Dec. $31$st $$ Owner took off the rest of the year.

Adjustments $($due with Part $1)$

$1.$ The equipment was used for the third year.

$2.$ Prepaid insurance was adjusted for Oct$-$Dec usage.

$3.$ Unearned revenue was updated to show $3$ months of work completed.

$4.$ A final count of supplies showed $$400$ remaining.

Part $1$ instructions

$1.$ Open the Excel attachment named $$Student fill$-$in template$.$

$2.$ Transfer the opening trial balance amounts to the T$-$Accts.

$3.$ Journal and post to the T$-$Accts the December and adjusting transactions.

$4.$ Total each T$-$Acct and provide the equation total at the top in the highlighted cells.

Check Figure $$ The cash T$-$Acct final balance should be $ $29,250$

$*$A detailed video overview can be found within this assignment in IvyLearn.

Part $2$ instructions

$1.$ Using the feedback provided from your instructor in the gradebook comments, update any incorrect items.

$2.$ Prepare the Adjusted trial balance.

$3.$ Prepare the Income Statement, Statement of Retained Earnings, and the Balance Sheet.

$4.$ Prepare the Closing journal entries and Post$-$closing trial balance.