Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Unadjusted Trial Balance Rose Temple, Piano teacher December 3 1 , 2 0 2 3 Debit Credit Cash $ 1 0 , 7 7 6
Unadjusted Trial Balance
Rose Temple, Piano teacher
December
Debit Credit
Cash $
Accounts Recievable
Inventory
Office supplies
Digital piano
Owner's Drawings
Advertising expense
Repairs expense
Accounts payable $
Unearned revenue
Sales revenue
Owner's equity
Prepaid rent
Computer Equipment
Acc. Depreciatiopn computer
Interest payable
Bank loan payable
Lesson revenue
COGS
Accounting expense
Bank charges expense
Interest expense
Rent expense
$ $
PART
Note to students: Ensure that you make all your corrections to your Part work
before starting Part You will be using the same Excel worksheets for Part
as you used for Part That is you will just continue with the same general
journal and same general ledger.
On January you receive the following email from your supervisor:
Hi Student Name
Based on discussions I had with Rose, the following information is available
to you. Please record the adjusting journal entries using this information.
December : As at December the following students had received
lessons that they have not yet paid for:
Student Amount owing
Mr Johnson $
MrSaunders
Ms McVey
Rose has indicated the she had office supplies costing $ on hand
at December base on her count of the supplies.
Make the adjusting entry for prepaid rent.
The depreciation expense on property, plant, and equipment has
been correctly calculated by your supervisor at the following amounts
Computer equipment $
Pianos
All of the unearned lesson revenue has been earned by December
Accrue $ for bookkeepingaccounting fees for December.
Accrue interest expense on the bank loan for December. The
calculation is:
Dec loan balance X
NOTE: Dec. loan balance is AFTER the December loan payment
Once you have journalized the above adjusting entries, you must prepare the
December bank reconciliation. You will need the files that are
attached to this email attachments are below
Sincerely,
Professor Name
Attachment #
The completed November bank reconciliation
Rose Temple Piano Teacher
Bank Reconciliation
November
Balance per bank statement...................... $
Less: Outstanding cheques:
Repairs Exp. # $
Advertising Exp #
Balance per general ledger Cash acct..... $
Attachment #
The Bank Statement for December,
CIBC
Statement of Current Account for Rose Temple Piano Teacher
For Month of December
Date Item Debit Credit Balance
Nov Balance
Dec Auto
Dec Dep
Dec Ch
Dec Dep
Dec Ch
Dec WD
Dec Ch
Dec SC
Part instructions continued:
Next, record the last adjusting entry, resulting from your bank reconciliation.
Finally, post your adjusting entries to the general ledger and prepare
the adjusted trial balance at December
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started