Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This project will give you an opportunity to apply your knowledge of accounting principles and procedures by handling all the accounting work of Wells Consulting

This project will give you an opportunity to apply your knowledge of accounting principles and procedures by handling all the accounting work of Wells Consulting Services for the month of January 2015.

Assume that you are the chief accountant for Wells Consulting Services. During January, the business will use the same types of records and procedures that you learned about in Chapters 2 6. The chart of accounts for Wells Consulting Services has been expanded to include a few new accounts. Follow all the instructions to complete the accounting records for the month of January 2015.

Well's Consulting Services

Chart of Accounts

ASSETS (100-199)

REVENUE (400-499)

101

Cash

401

Service Fee Income

111

Accounts Receivable

121

Supplies

EXPENSES (500-599)

134

Prepaid Insurance

137

Prepaid Rent

511

Salaries Expense

141

Equipment

514

Utilities Expense

142

Accumulated Depreciation, Equipment

517

Supplies Expense

520

Rent Expense

LIABILITIES (200-299)

523

Depreciation Expense, Equipment

526

Advertising Expense

202

Accounts Payable

529

Maintenance Expense

532

Telephone Expense

OWNER'S EQUITY (300-399)

535

Insurance Expense

301

Carolyn Wells, Capital

302

Carolyn Wells, Drawing

309

Income Summary

Instructions continued:

Set-up a General Ledger Account for each account listed in the Chart of Accounts. Copy in opening balance figures for January 1, 2015 into the proper General Ledger. (Hint: the necessary figures are from the Post-closing Trial Balance prepared on December 31, 2014, which appears below. (Only include an opening balance figure for the accounts listed with a balance, otherwise, there is no opening balance).

Analyze each business transaction, which appear on the next page and then journalize the transactions into the General Journal. Number the General Journal as Page 1 to begin journalizing the January 2015 transactions into the General Journal.

Post the transactions into the General Ledger accounts.(check figures for Cash & A/R are on page 4)

Prepare the Unadjusted Trial Balance Section of the Worksheet (AF-12A & 12B).

Prepare the Adjustments Section of the Worksheet (AF-12A & 12B). Number the General Journal as Page 4 to record the adjustments in the General Journal and post the adjustments to the General Ledger accounts.

Compute and record the adjustment for supplies used during the month. An inventory taken on January 31st showed supplies of $2,000 on hand.

Compute and record the adjustment for expired insurance for the month.

Record the adjustment for expired rent of $4,000 for the month.

Record the monthly depreciation adjustment of $183 on the existing (old) equipment. The depreciation adjustment on the new equipment purchased in January will not begin until February.

Complete the Worksheet. Prepare the Adjusted Trial Balance Section of the Worksheet as well as extend the figures to the Income Statement & Balance Sheet Sections of the Worksheet.

Prepare the Income Statement and the Statement of Owners Equity for the month ending January 31, 2015 and the Balance Sheet as of January 31, 2015. There are no owner investments in January 2015.

Journalize and post Closing Entries. record the closing entries in the General Journal and post the closing entries to the General Ledger accounts.

Prepare a Post-closing Trial Balance. (See the check figure for the Post-Closing Trial

Wells' Consulting Services

Post-closing Trial Balance

December 31, 2014

Account Name/Title

Debit

Credit

CASH

$ 111,350

ACCOUNTS RECEIVABLE

5,000

SUPPLIES

1,000

PREPAID RENT

4,000

EQUIPMENT

11,000

ACCUMULATED DEPRECIATION-EQUIPMENT

$ 183

ACCOUNTS PAYABLE

3,500

CAROLYN WELLS, CAPITAL, 12/31/2014

128,667

Totals:

$ 132,350

$ 132,350

DATE

BUSINESS TRANSACTIONS

January 2

Purchased supplies for $3,000 cash; issued Check No. 1015.

2

Purchased & paid for a one-year insurance policy for $4,800; issued Check No. 1016.

7

Sold & provided services during the first week of January. $15,000 in cash sales and

$1,800 in credit sales.

12

Collected a total of $1,500 in cash from credit customers during the first week

of January.

12

Issued Check No. 1017 for $2,150 to pay for special promotional advertising to

new businesses on the local radio station during the month.

13

Collected a total of $2,250 in cash from credit customers during the second week

of January.

14

Returned supplies that were damaged for a cash refund of $275.

15

Sold & provided services during the second week of January. $18,250 in cash sales and

$2,375 in credit sales.

20

Purchased supplies for $1,800 from White's, Inc.; received Invoice No. 2384 payable

in 30 days.

20

Sold & provided services during the third week of January. $9,050 in cash sales and

$5,850 in credit sales.

20

Collected a total of $1,750 in cash from credit customers during the third week

of January.

21

Issued Check No. 1018 for $4,250 to pay for maintenance work on the office

equipment.

22

Issued Check No. 1019 for $2,750 to pay for special promotional advertising to

new businesses on the local newspaper.

23

Received the monthly telephone bill for $410 and paid it with Check No. 1020.

26

Collected a total of $4,570 in cash from credit customers during the fourth week

of January.

27

Issued Check No. 1021 for $2,000 to a vendor, as payment on account for Invoice

No. 2223.

28

Sent Check No. 1022 for $1,050 in payment of the monthly bill for utilities.

29

Sold & provided services during the fourth week of January. $14,050 in cash sales and

$2,250 in credit sales.

31

Issued Check No.'s 1023 - 1027 for $15,500 to pay the monthly salaries of the

regular employees and three part-time workers.

31

Issued Check No. 1028 for $6,000 for personal use.

31

Issued Check No. 1029 for $1,050 to pay for maintenance services for the month.

31

Purchased new equipment for $10,500 from Contemporary Equipment Company;

issued Check No. 1030 for $5,500 and put the rest on account/credit. The equipment

has a 5 year useful life & no salvage value but depreciation wont begin until February.

31

Sold & provided services on January 31st. $2,850 in cash sales and $1,450 in credit sales.

Mini-Practice Set #1

Wells Consulting Services

Check Figures

The ending balance of the Cash Account in the General Ledger at January 31st, 2015 is $132,435.

The ending balance of the Accounts Receivable Account in the General Ledger at January 31st, 2015 is $8,655.

The ending balance of the Accounts Payable Account in the General Ledger at January 31st, 2015 is $8,300.

On the worksheet, the Adjustments (Section 2) debit & credit column totals are $8,108.

The Post-Closing Trial Balance debit & credit column totals at January 31st, 2015 is $168,990.

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

Question

Date decision to be made (if known)

Answered: 1 week ago