BMBA 140 Assignment #3iremcelen

.docx

School

University of Victoria *

*We aren’t endorsed by this school

Course

140

Subject

Accounting

Date

Feb 20, 2024

Type

docx

Pages

7

Uploaded by BarristerBoulderPorcupine21

Report
BMBA 140 Financial Accounting – Assignment #3 (55 Marks) First and Last Name: İrem Celen Background: You are the accountant for Plants from Paradise Ltd. (Plants), a garden center located in Victoria, BC. Plants has a December 31 fiscal year end. The controller has given you a list of accounting tasks to complete: Complete the December bank reconciliation and any required journal entries (Task #1) Record the inventory purchased in December, adjust for the year-end inventory count, and answer the questions provided (Task #2) Record the sales made in December and prepare an Aged AR schedule as at December 31 along with any required write-offs, and answer the questions provided (Task #3) Task #1 – Complete the December Bank Reconciliation (17 Marks): Using the template provided, please complete the December bank reconciliation, and prepare any required journal entries. Balance per bank statement, December 31, 2022: $13,297.00 Balance per General Ledger, December 31, 2022: $15,644.50 Note: 1. The bank statement included an NSF charge of $150.00 for a cheque received from a customer. 2. The bank statement included an incorrect charge of $25.00 to the company’s account for preparing their bank reconciliation, a service which was not provided by the bank. 3. Outstanding cheques as at December 31, 2022 were $120.00 4. $1,150 was received into the company’s bank account on December 31, 2022 from a Line of Credit extended by the bank. 5. Cash sales of $12.50 were incorrectly recorded as $1,250 by the company’s bookkeeper. 6. The bank statement included a debit memo for $220.00 for monthly bank fees. 7. Deposits in transit as at December 31, 2022 were $1,985.00
Bank Reconciliation Template: Plants from Paradise Ltd. Bank Reconciliation December 31, 2022 Cash Balance per bank statement 13,297.00 Add: Bank Error 25.00 Deposits in Transit 1,985.00 Less: Outstanding Cheques 120.00 Adjusted Cash Balance 15,187.00 Cash per G/L Balance 15,644.50 Add: Line of Credit Deposit 1,150.00 Less: NSF Change 150.00 Bookkeeper Error 1,237.00 Bank Fees 220.00 Adjusted Cash 15,187.00 Journal Entry Template: Entry # Date Account Name DR / CR Amount 1 Dec 31, 2022 Cash DR 1,150 Line of Credit CR 1,150 2 Dec 31, 2022 A/R DR 150 Cash CR 150 3 Dec 31, 2022 Sales DR 1,237.50 Cash CR 1,237.50 4 Dec 31, 2022 Bank Fee Expense DR 220 Cash CR 220 2
Task #2 – Inventory (15 Marks) 2a) Using the template provided, please record the inventory purchased based on the following two invoices (4 Marks): Invoice # 10678 – Planter’s Potting Mix Invoice # 698-001 – Out of this World Plants Entry # Date Description Account Name DR / CR Amount 1 Dec 23,2021 Invoice # 10678 Inventory DR 1,549.45 A/P CR 1,549.45 2 Dec 28,2021 Invoice # 698-001 Inventory DR 1,191.20 A/P CR 1,191.20 2b) Using the template provided, please record the adjusting journal entry required based on the results of the inventory count (3 Marks): The inventory balance in the General Ledger on December 31, 2022 was $12,580. Based on the inventory count, we have determined that actual inventory on hand is $10,330. Entry # Date Description Account Name DR / CR Amount 1 Dec 31,2022 Inventory Count Adjusting Entry COGS DR 2,250 Inventory CR 2,250 2c) Please provide an answer to the following questions (8 Marks): 1. Please explain why we perform an inventory count: (2 Marks) The first reason is to confirm inventory on hand. It is also needed for adjusting G/L to agree to inventory on hand. 2. What causes inventory on hand to be different than inventory per the GL: (2 Marks) Because of miscounts in receiving or if inventory has been stolen or damaged. 3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help