Answered step by step
Verified Expert Solution
Link Copied!

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

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions