Galloway Company SOLUTION IN EXCEL

Adjusting Entries and Adjusted Trial Balances

Galloway Company is a small editorial services company owned and operated by Fran Briggs. On July 31, 2012, the end of the current year, Galloway Company's accounting clerk prepared the unadjusted trial balance shown below.

The data needed to determine year-end adjustments are as follows:

1. Unexpired insurance at July 31, $4,800.
2. Supplies on hand at July 31, $600.
3. Depreciation of building for the year, $3,100.
4. Depreciation of equipment for the year, $2,700.
5. Rent unearned at July 31, $1,750.
6. Accrued salaries and wages at July 31, $3,000.
7. Fees earned but unbilled on July 31, $10,750.

Required:

1. Journalize the adjusting entries using the following additional accounts: Salaries and Wages Payable; Rent Revenue; Insurance Expense; Depreciation Expense—Building; Depreciation Expense—Equipment; and Supplies Expense.

2. Determine the balances of the accounts affected by the adjusting entries, and prepare an adjusted trial balance

Click here for solution