General Adjusting and Closing General Income Requirement Worksheet Stmt of OE Bal Sheet Postclosing Analyze Journal Ledger Statement Prepare the trial balance section of the worksheet. Then prepare the Adjustments section using the adjusting transactions. Now complete the worksheet. ELI'S CONSULTING SERVICES Worksheet Month Ended January 31, 20X2 Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet Account Name Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit Cash Accounts receivable Supplies Prepaid insurance Prepaid rent Equipment Accumulated depreciation-Equipment Accounts payable Trayton Eli, Capital Trayton Eli, Drawing Income summary Fees income Salaries expense Utilities expense Supplies expense Insurance expense Rent expense Depreciation expense-Equipment Advertising expense Telephone expense Maintenance expense Sub–totals 이$ 이 $ 이 $ 이 $

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
ATE TRANSACTIONS
Jan. 2 Purchased supplies for $14,000; issued Check 1015.
  2 Purchased a one-year insurance policy for $16,800.
  7 Sold services for $30,000 in cash and $20,000 on credit during the first week of January.
  12 Collected a total of $8,000 on account from credit customers during the first week of January.
  12 Issued Check 1017 for $7,200 to pay for special promotional advertising to new businesses on the local radio station during the month.
  13 Collected a total of $9,000 on account from credit customers during the second week of January.
  14 Returned supplies that were damaged for a cash refund of $1,500.
  15 Sold services for $41,400 in cash and $4,600 on credit during the second week of January.
  20 Purchased supplies for $10,000 from White’s, Inc.; received Invoice 2384 payable in 30 days.
  20 Sold services for $25,000 in cash and $7,000 on credit during the third week of January.
  20 Collected a total of $11,200 on account from credit customers during the third week of January.
  21 Issued Check 1018 for $14,130 to pay for maintenance work on the office equipment.
  22 Issued Check 1019 for $7,200 to pay for special promotional advertising to new businesses in the local newspaper.
  23 Received the monthly telephone bill for $2,050 and paid it with Check 1020.
  26 Collected a total of $3,200 on account from credit customers during the fourth week of January.
  27 Issued Check 1021 for $6,000 to Office Plus as payment on account for Invoice 2223.
  28 Sent Check 1022 for $5,350 in payment of the monthly bill for utilities.
  29 Sold services for $38,000 in cash and $5,500 on credit during the fourth week of January.
  31 Issued Checks 1023–1027 for $65,600 to pay the monthly salaries of the regular employees and three part-time workers.
  31 Issued Check 1028 for $24,000 for personal use.
  31 Issued Check 1029 for $8,300 to pay for maintenance services for the month.
  31 Purchased additional equipment for $30,000 from Contemporary Equipment Company; issued Check 1030 for $20,000 and bought the rest on credit. The equipment has a five-year life and no salvage value.
  31 Sold services for $15,200 in cash and $3,240 on credit on January 31.
    ADJUSTMENTS
  31 Compute and record the adjustment for supplies used during the month. An inventory taken on January 31 showed supplies of $9,400 on hand.
  31 Compute and record the adjustment for expired insurance for the month.
  31 Record the adjustment for one month of expired rent of $4,000.
  31 Record the adjustment for depreciation of $183 on the old equipment for the month. The first adjustment for depreciation for the new equipment will be recorded in February.

Question: Using the information given, I must complete a worksheet below. I've already finished the general journal and I know it's correct. However my adjusting and closing entries, and general ledger some of them may be wrong and debits and credits dont add up. So that's why I'm struggling on the worksheet. If you could mostly help with the worksheet that would be perfect, thank you. I'll attach what I have and the worksheet. The adjustments for supplies, insurance, rent and depreciation in order are: 14,600, 1,400, 4000, and 183 I believe.

 

General
Journal
Adjusting
and Closing
General
Income
Requirement
Worksheet
Stmt of OE Bal Sheet Postclosing
Analyze
Ledger
Statement
Prepare the trial balance section of the worksheet. Then prepare the Adjustments section using the adjusting transactions. Now complete the worksheet.
ELI'S CONSULTING SERVICES
Worksheet
Month Ended January 31, 20X2
Trial Balance
Adjustments
Adjusted Trial Balance
Income Statement
Balance Sheet
Account Name
Debit
Credit
Debit
Credit
Debit
Credit
Debit
Credit
Debit
Credit
Cash
Accounts receivable
Supplies
Prepaid insurance
Prepaid rent
Equipment
Accumulated depreciation-Equipment
Accounts payable
Trayton Eli, Capital
Trayton Eli, Drawing
Income summary
Fees income
Salaries expense
Utilities expense
Supplies expense
Insurance expense
Rent expense
Depreciation expense-Equipment
Advertising expense
Telephone expense
Maintenance expense
Sub-totals
$
O $
0 $
$
0 $
0 $
0 $
0 $
0 $
Totals
$
O $
0 $
$
Transcribed Image Text:General Journal Adjusting and Closing General Income Requirement Worksheet Stmt of OE Bal Sheet Postclosing Analyze Ledger Statement Prepare the trial balance section of the worksheet. Then prepare the Adjustments section using the adjusting transactions. Now complete the worksheet. ELI'S CONSULTING SERVICES Worksheet Month Ended January 31, 20X2 Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet Account Name Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit Cash Accounts receivable Supplies Prepaid insurance Prepaid rent Equipment Accumulated depreciation-Equipment Accounts payable Trayton Eli, Capital Trayton Eli, Drawing Income summary Fees income Salaries expense Utilities expense Supplies expense Insurance expense Rent expense Depreciation expense-Equipment Advertising expense Telephone expense Maintenance expense Sub-totals $ O $ 0 $ $ 0 $ 0 $ 0 $ 0 $ 0 $ Totals $ O $ 0 $ $
NO
Date
General Journai
Debit
Creait
1
Jan. 02, 20X2
Supplies
14,000
Cash
14,000
2
Jan. 02, 20X2
Prepaid insurance
16,800
Cash
16,800
3
Jan. 07, 20X2
Cash
30,000
Accounts receivable
20,000
Fees income
50,000
4
Jan. 12, 20X2
Cash
8,000
Accounts receivable
8,000
5
Jan. 12, 20X2
Advertising expense
7,200
Cash
7,200
6
Jan. 13, 20X2
Cash
9,000
Accounts receivable
9,000
7
Jan. 14, 20X2
Cash
1,500
Supplies
1,500
8
Jan. 15, 20X2
Cash
41,400
Accounts receivable
4,600
Fees income
46,000
9
Jan. 20, 20X2
Supplies
10,000
Accounts payable
10,000
10
Jan. 20, 20X2
Cash
25,000
Accounts receivable
7,000
Fees income
32,000
11
Jan. 20, 20X2
Cash
11,200
Accounts receivable
11,200
12
lan 21 20X?
Maintenance evnenee
14 130
Transcribed Image Text:NO Date General Journai Debit Creait 1 Jan. 02, 20X2 Supplies 14,000 Cash 14,000 2 Jan. 02, 20X2 Prepaid insurance 16,800 Cash 16,800 3 Jan. 07, 20X2 Cash 30,000 Accounts receivable 20,000 Fees income 50,000 4 Jan. 12, 20X2 Cash 8,000 Accounts receivable 8,000 5 Jan. 12, 20X2 Advertising expense 7,200 Cash 7,200 6 Jan. 13, 20X2 Cash 9,000 Accounts receivable 9,000 7 Jan. 14, 20X2 Cash 1,500 Supplies 1,500 8 Jan. 15, 20X2 Cash 41,400 Accounts receivable 4,600 Fees income 46,000 9 Jan. 20, 20X2 Supplies 10,000 Accounts payable 10,000 10 Jan. 20, 20X2 Cash 25,000 Accounts receivable 7,000 Fees income 32,000 11 Jan. 20, 20X2 Cash 11,200 Accounts receivable 11,200 12 lan 21 20X? Maintenance evnenee 14 130
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Characteristics Of Insurance
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education