Excel assignment.
Instructions . 0 You are the owner of Good Dog Veterinary Clinic. Be sure to enter your name with the Capital and Drawing accounts wherever appropriate. Journalize the transactions for the month of May 2020, beginning on page GJ 1. Be sure and list the Debit Account(s) first; Credit Account(s) next. Be sure and write a brief explanation for each transaction and skip a line between entries. Post the journal entries to the general ledger accounts. Be sure and use the Post Reference #s for each posting. Prepare the Trial Balance section of the worksheet. Prepare the Adjustments section of the worksheet using the following information: Compute and record the adjustment for supplies used during the month. An inventory showed supplies on hand of $153. Record the adjustment for depreciation of Office Equipment of $93 for the month. Record the adjustment for depreciation of Office Furniture of $38 for the month. Complete the remaining columns of the worksheet. o After you have completed the worksheet you will need to schedule a mandatory progress appointment with me. Starting Nov 19th I will have a signup sheet available for you to make an appointment. Appointments will be for 30 minutes from Nov 19 to Nov 24. The appointment does not need to last the whole 30 minutes. This is time for me to check on how you are doing and time for you to ask questions and solve problems with your project. Using the worksheet, prepare an Income Statement for the month. Fill-in the correct date. Using the worksheet, prepare a Statement of Owner's Equity. Fill-in the correct date. Using the worksheet, prepare a Balance Sheet using the report form. Fill-in the date. Journalize and post the Adjusting Entries in the appropriate tab. About half the students o Journalize and post the Closing Entries in the appropriate tab. About half the students forget to post these Closing Entries and it is easy points. Vet Clinic Prepare a Post-Closing Trial Balance in the appropriate tab. You will lose access to the shared Google Sheet Project Workbook Veterinary Clinic at the due date time. GOOD DOG VETERINARY CLINIC CHART OF ACCOUNTS Assets Revenue 111 Cash 411 Professional Fees 112 Accounts Receivable 412 Boarding Fees 113 115 Supplies Office Equipment Accum. Depr., Office Equip. Expenses 116 511 Salary Expense 117 Office Furniture 512 Rent Expense 118 Accum. Depr., Office Furrn. 513 Utilities Expense Liabilities 211 Accounts Payable 514 Miscellaneous Expense 515 Supplies Expense 516 Depr. Exp., Office Equip. 518 Depr. Exp., Office Furn. 519 Telephone Expense Owner's Equity 311 Your Name, Capital 312 Your Name, Drawing 330 Income Summary Instructions . 0 You are the owner of Good Dog Veterinary Clinic. Be sure to enter your name with the Capital and Drawing accounts wherever appropriate. Journalize the transactions for the month of May 2020, beginning on page GJ 1. Be sure and list the Debit Account(s) first; Credit Account(s) next. Be sure and write a brief explanation for each transaction and skip a line between entries. Post the journal entries to the general ledger accounts. Be sure and use the Post Reference #s for each posting. Prepare the Trial Balance section of the worksheet. Prepare the Adjustments section of the worksheet using the following information: Compute and record the adjustment for supplies used during the month. An inventory showed supplies on hand of $153. Record the adjustment for depreciation of Office Equipment of $93 for the month. Record the adjustment for depreciation of Office Furniture of $38 for the month. Complete the remaining columns of the worksheet. o After you have completed the worksheet you will need to schedule a mandatory progress appointment with me. Starting Nov 19th I will have a signup sheet available for you to make an appointment. Appointments will be for 30 minutes from Nov 19 to Nov 24. The appointment does not need to last the whole 30 minutes. This is time for me to check on how you are doing and time for you to ask questions and solve problems with your project. Using the worksheet, prepare an Income Statement for the month. Fill-in the correct date. Using the worksheet, prepare a Statement of Owner's Equity. Fill-in the correct date. Using the worksheet, prepare a Balance Sheet using the report form. Fill-in the date. Journalize and post the Adjusting Entries in the appropriate tab. About half the students o Journalize and post the Closing Entries in the appropriate tab. About half the students forget to post these Closing Entries and it is easy points. Vet Clinic Prepare a Post-Closing Trial Balance in the appropriate tab. You will lose access to the shared Google Sheet Project Workbook Veterinary Clinic at the due date time. GOOD DOG VETERINARY CLINIC CHART OF ACCOUNTS Assets Revenue 111 Cash 411 Professional Fees 112 Accounts Receivable 412 Boarding Fees 113 115 Supplies Office Equipment Accum. Depr., Office Equip. Expenses 116 511 Salary Expense 117 Office Furniture 512 Rent Expense 118 Accum. Depr., Office Furrn. 513 Utilities Expense Liabilities 211 Accounts Payable 514 Miscellaneous Expense 515 Supplies Expense 516 Depr. Exp., Office Equip. 518 Depr. Exp., Office Furn. 519 Telephone Expense Owner's Equity 311 Your Name, Capital 312 Your Name, Drawing 330 Income Summary
