Question
Case 2 Based on what you learned in the text and using the Sample Company, you are to add the following activities to your company:
Case 2 Based on what you learned in the text and using the Sample Company, you are to add the following activities to your company: 1. Open and review your previously customized report named Trial Balance 1/31/19. Adjusting Entries Chapter 9 2. Record the appropriate adjusting journal entries on 1/31/19 based on the following:
a. An inventory of supplies reveals that only $200 of supplies remain as of 1/31/19.
b. $1,800 of prepaid expenses expired (representing prepaid insurance) in the month of January.
c. A bill for $750 was received and recorded in the next month for legal fees performed in the current month. Create a new liability account as you did earlier in the chapter.
d. Custom painting services recorded on invoice \#1003 for $4,500.00 to Hagen's toys were never performed even though invoiced. Thus, the revenue had not been earned. Create a new liability account as you did earlier in the chapter.
e. Repair services of $6,298 were performed on the last day of the month for a new customer: Kelly's Awesome Copters but not invoiced to the customer or recorded into the accounting records until a few days into the next month. Create a new asset account as you did earlier in the chapter.
f. Depreciation Expense of $1,000 ( $375 and $625 for Furniture and Machinery \& Equipment, respectively) needed to be recorded for the month. Before recording this journal entry edit the "Depreciation" expense account so the new name is "Depreciation Expense." Also, change the account title for Machinery \& Equipment accumulated depreciation from "Depreciation" to "Accumulated Depreciation" like you did in the chapter.
3. Open, print, and export to Excel your previously customized report named Trial Balance 1/31/19, which should reflect your adjusting journal entries.
4. Open, print, and export to Excel your previously customized report named Transaction Detail by Account, which should reflect your adjusting journal entries.
Debit | Credit | |
Checking | 31,860.68 | |
Accounts Rceivable | 1,425.00 | |
Iventory Asset | 5,410.00 | |
Prepaid Epenses | 6,800.00 | |
Supplies Asset | 450.00 | |
Undeposited Funds | 925.00 | |
Furniture:Original Cost | 4,875.00 | |
Machinery & Equipment: Depreciation | 1,000.00 | |
Machinery & Equipment: Original Cost | 10,000.00 | |
Investment | 3,200.00 | |
Accounts Payable | 8,670.00 | |
AMEX | 240.00 | |
Payroll Tax Payable | 2,484.94 | |
Notes Payable | 27,625.00 | |
Common Stock | 25,100.00 | |
Opening balance equity | 0.00 | |
Retained Earnings | 7,585.00 | |
Sales | 5,700.00 | |
Services | 225.00 | |
Cost of Goods Sold | 3,020.00 | |
Advertising | 500.00 | |
Insurance | 400.00 | |
Interest Expense | 300.00 | |
Meals and Entertainment | 240.00 | |
Payroll | 9,224.26 | |
TOTAL | $ 78,629.94 | $ 78,629.94 |
I NEED THE ANSWERS WITH EVERY ADJUSTMENT IN EXEL FORMAT. I NEED TO SEE EVERY ADJUSTMENT IN THE TRAIL BALANCE.
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