70.2K

Verified Solution

Link Copied!

I need help with my ACCT 101 project. I'm having trouble understanding where I went wrong because my final balance for my T-account in cash is $29,565, which is what was requested from my teacher in the project notes. But my accounts aren't balanced, the left side equals $85,905 and the right side equald $84,505.... i'm have a lot of trouble particularly with the scenario for December 5th (I have every transaction color coded to match where i've recorded besides that one). Please help me with where I went wrong on this assignment.

1 The Equipment was purchased Jan. 1 two years ago It has a useful life of 5 years 2 The prepaid insurance was purchased Oct. 1st It is a 6 month policy. No adjustments have been made. 3 The unearned revenue was prepaid by Roman Ine. on Oct. 1st and covers 6 months of work. No adjustments have been made. Dec. 1st Collected $865 from Franklin from a previous engagement in Oct. Dec. 2nd Paid $1,401 on Gusto's Inc. invoice from a previously recorded transaction with check \#1301. Dec 3rd - Paid December rent of $2,134 with check \#1302. Dec 4th - Completed additional work for Washington, sent invoice \#Y77P for $1,20B due in 1 month. Dec. 5th - Paid employee from work previously expensed in Nov. with payment due Dec. 5th using check #1303. Dec. 8th - Purchased land on a note for $41,299 to be used for future construction of a new office building. Land and Nates payable will have account numbers of 150 and 240 , respectively. Dec. 9th - Paid $1,222 to cover all utilities for the month of Dec using check \#1304. Dec. 10th. Completed $418 worth of work for a repeat customer who pays cash immediately upon completion. Dec. 11th= Collected $790 from Washington from a previous engagement in Nov. Dec. 12th - Our employee earned two weeks of pay amounting to $1,730, to be paid Dec. 23rd. "emplayee took vacation from Dec. 15th-Dec. 31st. No pay will accrue Dec. 15th=1 eah Tyler, the owner, withdrew $3,204 for personal use using check \#1305. Dec. 16th - Completed a large job for Franklin for $11,249. Sent invoice \#Y78P due Jan. 31st Dec. 22nd - Franklin paid $2,682 to pay off some of his balance due. Dec. 23rd Paid our employee for the work expensed Dec. 12th. Dec 24th-Dec. 31st - Owner took off the rest of the year. Adjustments 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 $422 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 I-Acsts the December and adjusting transactions 4. Total each J-Acct and provide the equation total at the top in the highlighted cells. Check Figure - The cash IfAcct.final balance should be $29.564 1 The Equipment was purchased Jan. 1 two years ago It has a useful life of 5 years 2 The prepaid insurance was purchased Oct. 1st It is a 6 month policy. No adjustments have been made. 3 The unearned revenue was prepaid by Roman Ine. on Oct. 1st and covers 6 months of work. No adjustments have been made. Dec. 1st Collected $865 from Franklin from a previous engagement in Oct. Dec. 2nd Paid $1,401 on Gusto's Inc. invoice from a previously recorded transaction with check \#1301. Dec 3rd - Paid December rent of $2,134 with check \#1302. Dec 4th - Completed additional work for Washington, sent invoice \#Y77P for $1,20B due in 1 month. Dec. 5th - Paid employee from work previously expensed in Nov. with payment due Dec. 5th using check #1303. Dec. 8th - Purchased land on a note for $41,299 to be used for future construction of a new office building. Land and Nates payable will have account numbers of 150 and 240 , respectively. Dec. 9th - Paid $1,222 to cover all utilities for the month of Dec using check \#1304. Dec. 10th. Completed $418 worth of work for a repeat customer who pays cash immediately upon completion. Dec. 11th= Collected $790 from Washington from a previous engagement in Nov. Dec. 12th - Our employee earned two weeks of pay amounting to $1,730, to be paid Dec. 23rd. "emplayee took vacation from Dec. 15th-Dec. 31st. No pay will accrue Dec. 15th=1 eah Tyler, the owner, withdrew $3,204 for personal use using check \#1305. Dec. 16th - Completed a large job for Franklin for $11,249. Sent invoice \#Y78P due Jan. 31st Dec. 22nd - Franklin paid $2,682 to pay off some of his balance due. Dec. 23rd Paid our employee for the work expensed Dec. 12th. Dec 24th-Dec. 31st - Owner took off the rest of the year. Adjustments 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 $422 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 I-Acsts the December and adjusting transactions 4. Total each J-Acct and provide the equation total at the top in the highlighted cells. Check Figure - The cash IfAcct.final balance should be $29.564

Answer & Explanation Solved by verified expert

See Answer