Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete the worksheet using the excel file. Add your adjusting journal entries and complete the adjusted trial balance. Do not do the financial statements, closing
Complete the worksheet using the excel file.
Add your adjusting journal entries and complete the adjusted trial balance.
Do not do the financial statements, closing entries, or post-close trial balance.
The information for the adjusting journal entries are at the bottom of the tab- "adjusting entries"
Adjusting Journal Entries Info. | |||
Insurance that expired during December was $275.00 | |||
A physical count of the supplies indicated that $715.00 were on hand. | |||
Depreciation on office equipment for the period was $330.00 | |||
Salaries worked but not yet paid was $325.00 | |||
Monthly rent of $1600.00 was used during December. | |||
Unearned fees on December 31 are $3,210 | |||
TRIAL BALANCE | ADJUSTMENTS | ADJ TRIAL BALANCE | INCOME STATEMENT | BALANCE SHEET | ||||||
ACCOUNT TITLE | DEBIT | CREDIT | DEBIT | CREDIT | DEBIT | CREDIT | DEBIT | CREDIT | DEBIT | CREDIT |
Cash | 44,195 | |||||||||
Accounts Receivable | 8,080 | |||||||||
Supplies | 2,085 | |||||||||
Prepaid Rent | 3,200 | |||||||||
Prepaid Insurance | 1,500 | |||||||||
Office Equipment | 14,500 | |||||||||
Accumulated Depreciation | 330 | |||||||||
Accounts Payable | 895 | |||||||||
Salaries Payable | ||||||||||
Unearned Fees | 7,000 | |||||||||
Kelly Pitney, Capital | 42,300 | |||||||||
Kelly Pitney, Drawing | 10,500 | |||||||||
Fees Earned | 36,210 | |||||||||
Salary Expense | 1,380 | |||||||||
Rent Expense | ||||||||||
Supplies Expense | ||||||||||
Depreciation Expense | ||||||||||
Insurance Expense | ||||||||||
Miscellaneous Expense | 1,295 | |||||||||
86,735 | 86,735 | |||||||||
Net Income |
Step by Step Solution
★★★★★
3.53 Rating (153 Votes )
There are 3 Steps involved in it
Step: 1
ANSWER To complete the worksheet and adjust the trial balance well first record the adjusting journa...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