Acct 571: Week 6 Project-Comprehensive Accounting Project

Team, you have been called in to help James Miller who has operated a part-time architectural business from his home. His accountant has decided to quit working for him and Miller has decided he needs a more organized approach to keeping his accounting records. (Miller has kept his accounting records in a big file cabinet). Miller has decided to move to a rented office space and is planning to operate the business on a full-time basis. The business will be known as Miller Architects, Inc. Miller also has the following transactions that took place during the month of June 20XX:

June 1. The following assets were received from James Miller in exchange for common stock: Cash, $ 23,400; accounts receivable, $ 4,000; supplies, $1,900 and Office Equipment, $ 15,500. There were no liabilities received.

June 1. Paid six months' rent in advance on a lease rental contract, $ 6,000.

June 2. Paid the premiums on property and casualty insurance policies, $ 2,400. ( The policy is for six months)

June 4. Received cash from the Smith Company as an advance payment for services to be provided and it will be recorded as unearned fees for $ 5,000.

June 5. Purchased a new computer on account from Stone's Computer Nook for $ 3,000. The useful life has been determined to be 5 years.

June 6. Received cash from clients on account for $ 2,200.

June 9. Paid cash to Greenfield Tribune for a newspaper advertisement, $ 150.

June 12. Recorded services provided on account to various clients for the period of June 1 thru 12, for $ 4,900.

June 13. Paid Stone's Computer Nook for part of the liability incurred on June 5, $ 750.

June 14. Paid part-time receptionist for two weeks' salary, $ 900.

June 17. Paid cash for supplies, $ 900.

June 20. Purchased additional office equipment on account from Merrick Office Supply store for $ 2,500.

June 20. Recorded services provided on account to various clients for the period of June 13-20, $ 3,100.

June 24. Received cash from clients for fees earned during the period of June 17 thru 24, $ 5,400.

June 26. Received cash from clients on account from June 12 services, $ 2,000.

June 27. Paid part-time receptionist for two weeks salary, $ 900.

June 29. Paid telephone bill for June, $ 320.

June 29. Paid electricity bill for June, $ 485.

June 30. Recorded cash from clients for fees earned for the period of June 25-30, $ 3,200.

June 30. Recorded services provided on account for the remainder of June, $ 1,700.

June 30. Paid dividends of $ 3,000.

Possible adjustment data for Miller Architects as of June 30, 20XX:

a. Insurance expired during June is $400.

b. Supplies on hand on June 30 is $ 2,250.

c. Monthly depreciation of office equipment is $ 300.

d. Monthly depreciation of computer is $ 50

e. Rent expired during June is $1,000.

f. Accrued receptionist salary on June 30 is $ 150.

g. Unearned fees on June 30 is $ 4,000.

Deliverables for this project:

Your job is to review the transactions and help Miller Architects, Inc. develop a chart of accounts that Miller Architects, Inc. will utilize in the future.

Your next task to record these transactions using Excel. You will need to make general journal and a general ledger for Miller Architects

After the recording the transactions and posting the transactions into the general journal and general ledger that you have created, please complete the following tasks:

unadjusted trial balance.

Prepare the adjusting entries and post to the general ledger.

adjusted trial balance.

Prepare the financial statements for the month of June.

Prepare the closing entries for the month of June and post to the general ledger.

post-closing trial balance for the month of June.