4.

At the end of July, the following adjustment data were assembled. Analyze and use these data to complete requirements (5) and (6).

	Insurance expired during July is $375.
	Supplies on hand on July 31 are $1,525.
	Depreciation of office equipment for July is $750.
	Accrued receptionist salary on July 31 is $175.
	Rent expired during July is $2,400.
	Unearned fees on July 31 are $2,750.

5.

(Optional) On your own paper or spreadsheet, enter the unadjusted trial balance on an end-of-period work sheet and complete the spreadsheet. Find a blank end-of-period work sheet in the Excel spreadsheet you previously downloaded.

6.

A.	Journalize the adjusting entries on page 3 of the journal. Adjusting entries are recorded on July 31.
B.	Use the attached spreadsheet in the Ledger panel to post the adjusting entries to the ledger of four-column accounts, inserting balances is the accounts affected. Add the appropriate posting reference to the adjusting entries in the journal

7.

Prepare an adjusted trial balance.

3. Prepare an unadjusted trial balance.

Diamond Consulting

UNADJUSTED TRIAL BALANCE

July 31, 2016

	ACCOUNT TITLE	DEBIT	CREDIT
1	Cash
2	Accounts Receivable
3	Supplies
4	Prepaid Rent
5	Prepaid Insurance
6	Office Equipment
7	Accumulated Depreciation
8	Accounts Payable
9	Salaries Payable
10	Unearned Fees
11	Steffy Lopez, Capital
12	Steffy Lopez, Drawing
13	Fees Earned
14	Salary Expense
15	Rent Expense
16	Supplies Expense
17	Depreciation Expense
18	Insurance Expense
19	Miscellaneous Expense
20	Totals

7. Prepare an adjusted trial balance.

Diamond Consulting

ADJUSTED TRIAL BALANCE

July 31, 2016

	ACCOUNT TITLE	DEBIT	CREDIT
1	Cash
2	Accounts Receivable
3	Supplies
4	Prepaid Rent
5	Prepaid Insurance
6	Office Equipment
7	Accumulated Depreciation
8	Accounts Payable
9	Salaries Payable
10	Unearned Fees
11	Steffy Lopez, Capital
12	Steffy Lopez, Drawing
13	Fees Earned
14	Salary Expense
15	Rent Expense
16	Supplies Expense
17	Depreciation Expense
18	Insurance Expense
19	Miscellaneous Expense
20	Totals