Health Care Consultants Trial Balance Excel Spreadsheet

Please complete the following questions below using google sheets.

Please note: Make sure you use only ONE Google Sheet/Microsoft Excel file. Then, rename each sheet as following:

• Sheet 1 = Q8
• Sheet 2 = Q15

Q8.

Please Note:

• You’re making four (4) adjusting entries in General Journal.
  • There is NO need to make General Ledger for Adjusting Entries. You will do this in next question.
• You’re making an annual (1-year) adjustment and not monthly.
• There is NO need for closing entries for this question.

Q15. – Only (a)-(d)

Please Note:

• First open the General Ledger (not T-accounts) accounts for all of the temporary accounts (e.g., revenue, expenses, drawings, and income summary) using the balances given in the Trial Balances.
• Then, journalize the closing entries must be done in General Journal.
• Then, post the journal entries to the General Ledger.
• At last, generate a Post-Closing Trial Balance from the total balances you generate from the step above.
• No need to do Statement of Owner’s Equity (e-f).