End$-$of$-$Period Spreadsheet $($Work Sheet$)$

For the Month Ended May $31,20$ Y$5$ Comprehensive Problem $1$

Part $5$: Work Sheet

The following is a comprehensive problem which encompasses all of the elements learned in previous chapters. You can refer to the objectives for each chapter covered as a review of the concepts. Note: You must complete parts $1,2,3,4$ before completing part $5.$

Part $5$: Enter the unadjusted trial balance on an end$-$of$-$period spreadsheet $($work sheet$)$ and complete the spreadsheet using the following adjustment data.

Insurance expired during May is $$275.$

Supplies on hand on May $31$ are $$715.$

Depreciation of office equipment for May is $$330.$

Accrued receptionist salary on May $31$ is $$325.$

Rent expired during May is $$1,600.$

Unearned fees on May $31$ are $$3,210.$

If an amount box does not require an entry, leave it blank.

Kelly Consulting

End$-$of$-$Period Spreadsheet $($Work Sheet$)$

For the Month Ended May $31,20$Y$5$

Unadjusted Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet

Account Title Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit

Cash fill in the blank $1$

fill in the blank $2$

fill in the blank $3$

fill in the blank $4$

fill in the blank $5$

fill in the blank $6$

fill in the blank $7$

fill in the blank $8$

fill in the blank $9$

fill in the blank $10$

Accounts Receivable fill in the blank $11$

fill in the blank $12$

fill in the blank $13$

fill in the blank $14$

fill in the blank $15$

fill in the blank $16$

fill in the blank $17$

fill in the blank $18$

fill in the blank $19$

fill in the blank $20$

Supplies fill in the blank $21$

fill in the blank $22$

fill in the blank $23$

fill in the blank $24$

fill in the blank $25$

fill in the blank $26$

fill in the blank $27$

fill in the blank $28$

fill in the blank $29$

fill in the blank $30$

Prepaid Rent fill in the blank $31$

fill in the blank $32$

fill in the blank $33$

fill in the blank $34$

fill in the blank $35$

fill in the blank $36$

fill in the blank $37$

fill in the blank $38$

fill in the blank $39$

fill in the blank $40$

Prepaid Insurance fill in the blank $41$

fill in the blank $42$

fill in the blank $43$

fill in the blank $44$

fill in the blank $45$

fill in the blank $46$

fill in the blank $47$

fill in the blank $48$

fill in the blank $49$

fill in the blank $50$

Office Equipment fill in the blank $51$

fill in the blank $52$

fill in the blank $53$

fill in the blank $54$

fill in the blank $55$

fill in the blank $56$

fill in the blank $57$

fill in the blank $58$

fill in the blank $59$

fill in the blank $60$

Accum. Depreciation fill in the blank $61$

fill in the blank $62$

fill in the blank $63$

fill in the blank $64$

fill in the blank $65$

fill in the blank $66$

fill in the blank $67$

fill in the blank $68$

fill in the blank $69$

fill in the blank $70$

Accounts Payable fill in the blank $71$

fill in the blank $72$

fill in the blank $73$

fill in the blank $74$

fill in the blank $75$

fill in the blank $76$

fill in the blank $77$

fill in the blank $78$

fill in the blank $79$

fill in the blank $80$

Salaries Payable fill in the blank $81$

fill in the blank $82$

fill in the blank $83$

fill in the blank $84$

fill in the blank $85$

fill in the blank $86$

fill in the blank $87$

fill in the blank $88$

fill in the blank $89$

fill in the blank $90$

Unearned Fees fill in the blank $91$

fill in the blank $92$

fill in the blank $93$

fill in the blank $94$

fill in the blank $95$

fill in the blank $96$

fill in the blank $97$

fill in the blank $98$

fill in the blank $99$

fill in the blank $100$

Kelly Pitney, Capital fill in the blank $101$

fill in the blank $102$

fill in the blank $103$

fill in the blank $104$

fill in the blank $105$

fill in the blank $106$

fill in the blank $107$

fill in the blank $108$

fill in the blank $109$

fill in the blank $110$

Kelly Pitney, Drawing fill in the blank $111$

fill in the blank $112$

fill in the blank $113$

fill in the blank $114$

fill in the blank $115$

fill in the blank $116$

fill in the blank $117$

fill in the blank $118$

fill in the blank $119$

fill in the blank $120$

Fees Earned fill in the blank $121$

fill in the blank $122$

fill in the blank $123$

fill in the blank $124$

fill in the blank $125$

fill in the blank $126$

fill in the blank $127$

fill in the blank $128$

fill in the blank $129$

fill in the blank $130$

Salary Expense fill in the blank $131$

fill in the blank $132$

fill in the blank $133$

fill in the blank $134$

fill in the blank $135$

fill in the blank $136$

fill in the blank $137$

fill in the blank $138$

fill in the blank $139$

fill in the blank $140$

Rent Expense fill in the blank $141$

fill in the blank $142$

fill in the blank $143$

fill in the blank $144$

fill in the blank $145$

fill in the blank $146$

fill in the blank $147$

fill in the blank $148$

fill in the blank $149$

fill in the blank $150$

Supplies Expense fill in the blank $151$

fill in the blank $152$

fill in the blank $153$

fill in the blank $154$

fill in the blank $155$

fill in the blank $156$

fill in the blank $157$

fill in the blank $158$

fill in the blank $159$

fill in the blank $160$

Depreciation Expense fill in the blank $161$

fill in the blank $162$

fill in the blank $163$

fill in the blank $164$

fill in the bla