BMBA 140 Assignment #3iremcelen
.docx
keyboard_arrow_up
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
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
Related Questions
7
arrow_forward
lemic Calendar My MCBS Library English (en) -
ndamentals of Financial Accounting
Summer Session 12021/ACT 140/D2 / Final Examination/ AC
In a bank reconciliation statement, explain.
A. Non-sufficient-funds (NSF) check
B. What is a deposit in transit?
A BI -
mcbs.proctoring.online is sharing your screen.
Stop
11
arrow_forward
BUSINESS STUDIES DEPARTMENT
INTERMEDIATE ACCOUNTNG1 (TUTORIAL #1)
1. XYZ Co. set up a petty cash fund for payments of small amounts. The
following transactions involving the petty cash fund occurred in May
(the last month of the company's fiscal year).
May 1 Prepared a company check for $250 to establish the petty cash fund.
May 15 Prepared a company check to replenish the fund for the following
expenditures made since May1:
a. Paid $78 for janitorial services.
b. Paid $63.68 for miscellaneous expenses.
c. Paid postage expenses of $43.50.
d. Paid $57.15 to a local newspaper for an advertisement.
e. Counted $11.15 remaining in the petty cash box.
May 16 Prepared a company check for $200 to increase the fund to $450.
May 31 The petty cashier reports that $293.39 cash remains in the fund. A
company check is drawn to replenish the fund for the following expenditures
made since May 15:
a. Paid postage expenses of $48.36.
b. Reimbursed the office manager for business mileage, $38.50.
c. Paid…
arrow_forward
Haytechcc.blackboard.co
gement,.
H https://outlook.offi..
FES Protection Plan
System 7- North C.
work Exercises
Saved
After returning from a three-day business trip, the accountant for Southeast Sales, Johanna Estrada, checked bank activity in the
company's checking account online. The activity for the last three days follows.
Business Checking
Account #123456-987
Date
Туpe
Description
Online Transfer to CM XX0XX
Deposit ID number 8888
Check #1554 (view)
Online payment
Check #1553 (view)
Check #1551 (view)
Edwards UK AP payment
ATM withdrawal
Additions Payments
Balance
09/24/20X1
09/24/20X1 Deposit
09/23/20X1
Loan payment
$5,100.00 $17,275.06
$22,375.06
$5,100.00 $19,945.46
52.05 $25,845.46
$ 400.00 $25,097.51
$1,910.00 $25,497.51
$27,407.51
$ 400.00 $16,907.51
$ 2,429.60
Check
Bill payment
09/23/20X1
09/22/20X1
09/22/20X1
Check
Check
ACH credit
ATM
$10,500.00
09/22/20x1
09/22/20X1
After matching these transactions to the company's Cash account in the general ledger, Johanna noted the…
arrow_forward
Brief Exercise 7-04
Presented below is information related to Sunland Company for its first month of operations.
Credit Sales
Cash Collections
Jan. 7
Austin Co.
$11,600
Jan. 17
Austin Co.
$7,500
15
Diaz Co.
7,200
24
Diaz Co.
4,500
23
Noble Co.
10,000
29
Noble Co.
10,000
Identify the balances that appear in the accounts receivable subsidiary ledger and the accounts receivable balance that appears in the general ledger at the end of January.
Subsidary Ledger
General Ledger
Austin Co.
Diaz Co.
Noble Co.
Balance of Accounts Receivable
$
$
$
$
arrow_forward
weat
subject-Accounting
arrow_forward
Comprehensive Problem 3
Part 2:
The following is a comprehensive problem which encompasses all of the elements learned in previous chapters. Yo
refer to the objectives for each chapter covered as a review of the concepts.
Note: You must complete part 1 before completing part 2.
Based on the following data, prepare a bank reconciliation for December of the current year:
a. Balance according to the bank statement at December 31, $283,000.
b. Balance according to the ledger at December 31, $245,410.
c. Checks outstanding at December 31, $68,540.
d. Deposit in transit, not recorded by bank, $29,500.
e. Bank debit memo for service charges, $750.
f. A check for $12,700 in payment of an invoice was incorrectly recorded in the accounts as $12,000.
Kornett Company
Bank Reconciliation
December 31, 20Y8
Adjusted balance
Deduct:
Adjusted balance
arrow_forward
Subject:- accounting
arrow_forward
Instructions
The following data were gathered to use in reconciling the bank account of Reddan Company:
Balance per bank
$18,250
Balance per company records
9,780
Bank service charges
30
Deposit in transit
3,650
Note collected by bank with $120 interest
5,050
Outstanding checks
7,100
Instructions
a. What is the adjusted balance on the bank reconciliation?
b. Journalize any necessary entries for Reddan Company based on the bank reconciliation. Refer to the Chart of Accounts for exact wording of
account titles.
181 Land
532 Delivery Expense
CHART OF ACCOUNTS
191 Office Equipment
533 Insurance Expense
Reddan Company
192 Accumulated Depreciation-Office Equipment
534 Office Supplies Expense
General Ledger
193 Store Equipment
535 Rent Expense
194 Accumulated Depreciation-Store Equipment
536 Repairs Expense
ASSETS
REVENUE
537 Selling Expenses
110 Cash
410 Sales
LIABILITIES
538 Store Supplies Expense
111 Petty Cash
610 Interest Revenue
210 Accounts Payable
561 Depreciation Expense-Office…
arrow_forward
Comprehensive Problem 3
Part 2:
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 part 1 before completing part 2.
Based on the following data, prepare a bank reconciliation for December of the current year:
a. Balance according to the bank statement at December 31, $283,000.
b. Balance according to the ledger at December 31, $245,410.
c. Checks outstanding at December 31, $68,540.
d. Deposit in transit, not recorded by bank, $29,500.
e. Bank debit memo for service charges, $750.
f. A check for $12,700 in payment of an invoice was incorrectly recorded in the accounts as $12,000.
Kornett Company
Bank Reconciliation
December 31, 20Y5
24
Adjusted balance
24
Total deductions
Adjusted balance
arrow_forward
Awnser in graph format please please provide the 4 graphs
arrow_forward
PROBLEM 1: You obtained the following information on the current account of BUGOY CORP. During your
examination of its financial statements for the year ended December 31, 2021.
The bank statement on November 30, 2021 showed a balance of P918,000. Among the bank credits in November
was customer's note for P300,000 collected for the account of the company which the company recognized in
December among its receipts. Included in the bank debits were cost of checkbooks amounting to P3,600 and a
P120,000 check which was charged by the bank in error against Bugoy's account. Also in November you
ascertained that there were deposits in transit amounting to P240,000 and outstanding checks totaling P510,000.
The bank statement for the month of December showed total credits of P1,248,000 and total charges of P612,000.
The Company's books for December showed total debits of P2,206,800, total credits of P1,221,600 and a balance
of P1,456,800. Bank debit memos for December were: No. 121 for service…
arrow_forward
hrd.3
arrow_forward
Annotatior
The following data were taken from Tyrone Tardieff's
check register for the month of April. Tyrone's bank
reconciliation for March showed one outstanding
check, Check No. 78 for $57.00 (written on March 23),
and one deposit in transit, Deposit No. 10499 for
$96.00 (made on March 30).
Date
Item
Checks
Deposits
Balance
2015
April
1
Beginning Balance
$175.00
1
Deposit No. 10500
$451.61
626.61
1
Check No. 79.
$ 15.00
61661
4.
Check No. 80.
261.32
35559
27
Deposit No. 10501
247.28
602.87
29
Check No. 81.
214.35
38952
The following is from Tyrone's bank statement for
April:
arrow_forward
[The following information applies to the questions displayed below.]
On January 1, 2021, the general ledger of TNT Fireworks includes the following account balances:
Accounts
Debit
Credit
$ 59,000
25,600
Cash
Accounts Receivable
Allowance for Uncollectible Accounts
$ 2,500
Inventory
Notes Receivable (5%, due in 2 years)
36,600
15,600
Land
158,000
Accounts Payable
15,100
Common Stock
223,000
Retained Earnings
54,200
Totals
$294,800
$294,800
During January 2021, the following transactions occur:
January 1 Purchase equipment for $19,800. The company estimates a residual value of $1,800 and a six-year service life.
January 4 Pay cash on accounts payable, $9,800.
January 8 Purchase additional inventory on account, $85,900.
January 15 Receive cash on accounts receivable, $22,300.
January 19 Pay cash for salaries, $30,100.
January 28 Pay cash for January utilities, $16,800.
January 30 Sales for January total $223,000. All of these sales are on account. The cost of the units sold is $116,500.…
arrow_forward
B3
arrow_forward
Question Content Area Using the following information: The bank statement balance is $5,065. The cash account balance is $5,459. Outstanding checks amounted to $866. Deposits in transit are $1,191. The bank service charge is $60. A check for $34 for supplies was recorded as $25 in the ledger. Prepare a bank reconciliation for Candace Co. for May 31. Candace Co. Bank Reconciliation May 31 Cash balance according to bank statement $fill in the blank 1 Adjustments: $- Select - - Select - Total adjustments fill in the blank 6 Adjusted balance $fill in the blank 7 Cash balance according to company's records $fill in the blank 8 Adjustments: $- Select - - Select - Total adjustments fill in the blank 13 Adjusted balance $fill in the blank 14
arrow_forward
Hello tutor please help with calculation
arrow_forward
Revenue and Cash Receipts Journals
Transactions related to revenue and cash receipts completed by Sycamore Inc. during the month of March 20Y8 are as follows:
Mar. 2.
Issued Invoice No. 512 to Santorini Co., $725.
Mar. 4.
Received cash from CMI Inc., on account, for $180.
Mar. 8.
Issued Invoice No. 513 to Gabriel Co., $255.
Mar. 12.
Issued Invoice No. 514 to Yarnell Inc., $640.
Mar. 19.
Received cash from Yarnell Inc., on account, $485.
Mar. 20.
Issued Invoice No. 515 to Electronic Central Inc., $140.
Mar. 28.
Received cash from Marshall Inc. for services provided, $100.
Mar. 29.
Received cash from Santorini Co. for Invoice No. 512 of March 2.
Mar. 31.
Received cash from McCleary Co. for services provided, $60.
Prepare a single-column revenue journal and a cash receipts journal to record these transactions. Enter the transactions in chronological order.
REVENUE JOURNAL
PAGE 8
DATE
Invoice No.
Account Debited
Post. Ref.
Accounts Rec. Dr.Fees Earned Cr.…
arrow_forward
Complete the attached excel sheet using the data
arrow_forward
History
Bookmarks Window
AOL Mail (...
eBook
Q
U
Help
Mail - Fait...
Portal hos..
b. What is the amount recorded for the day's sales?
How should the difference be recorded?
of
v2.cengagenow.com
Chapter 5...
Check My Work 10 more Check My Work uses remaining.
should be recorded as
Recording Cash Sales; Cash Over/Short
The actual cash received from the day's cash sales was $14,346, and the amount indicated by the cash register total was $14,300.
a. What is the amount deposited in the bank for the day's sales?
d. If a cashier is consistently over or short, what action should be taken?
C Cengage...
MacBook Pro
8
JC
4+1
W Activity I...
My Drive..
<₁
Save and Exit Sub
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781305084087
Author:Cathy J. Scott
Publisher:Cengage Learning
Related Questions
- 7arrow_forwardlemic Calendar My MCBS Library English (en) - ndamentals of Financial Accounting Summer Session 12021/ACT 140/D2 / Final Examination/ AC In a bank reconciliation statement, explain. A. Non-sufficient-funds (NSF) check B. What is a deposit in transit? A BI - mcbs.proctoring.online is sharing your screen. Stop 11arrow_forwardBUSINESS STUDIES DEPARTMENT INTERMEDIATE ACCOUNTNG1 (TUTORIAL #1) 1. XYZ Co. set up a petty cash fund for payments of small amounts. The following transactions involving the petty cash fund occurred in May (the last month of the company's fiscal year). May 1 Prepared a company check for $250 to establish the petty cash fund. May 15 Prepared a company check to replenish the fund for the following expenditures made since May1: a. Paid $78 for janitorial services. b. Paid $63.68 for miscellaneous expenses. c. Paid postage expenses of $43.50. d. Paid $57.15 to a local newspaper for an advertisement. e. Counted $11.15 remaining in the petty cash box. May 16 Prepared a company check for $200 to increase the fund to $450. May 31 The petty cashier reports that $293.39 cash remains in the fund. A company check is drawn to replenish the fund for the following expenditures made since May 15: a. Paid postage expenses of $48.36. b. Reimbursed the office manager for business mileage, $38.50. c. Paid…arrow_forward
- Haytechcc.blackboard.co gement,. H https://outlook.offi.. FES Protection Plan System 7- North C. work Exercises Saved After returning from a three-day business trip, the accountant for Southeast Sales, Johanna Estrada, checked bank activity in the company's checking account online. The activity for the last three days follows. Business Checking Account #123456-987 Date Туpe Description Online Transfer to CM XX0XX Deposit ID number 8888 Check #1554 (view) Online payment Check #1553 (view) Check #1551 (view) Edwards UK AP payment ATM withdrawal Additions Payments Balance 09/24/20X1 09/24/20X1 Deposit 09/23/20X1 Loan payment $5,100.00 $17,275.06 $22,375.06 $5,100.00 $19,945.46 52.05 $25,845.46 $ 400.00 $25,097.51 $1,910.00 $25,497.51 $27,407.51 $ 400.00 $16,907.51 $ 2,429.60 Check Bill payment 09/23/20X1 09/22/20X1 09/22/20X1 Check Check ACH credit ATM $10,500.00 09/22/20x1 09/22/20X1 After matching these transactions to the company's Cash account in the general ledger, Johanna noted the…arrow_forwardBrief Exercise 7-04 Presented below is information related to Sunland Company for its first month of operations. Credit Sales Cash Collections Jan. 7 Austin Co. $11,600 Jan. 17 Austin Co. $7,500 15 Diaz Co. 7,200 24 Diaz Co. 4,500 23 Noble Co. 10,000 29 Noble Co. 10,000 Identify the balances that appear in the accounts receivable subsidiary ledger and the accounts receivable balance that appears in the general ledger at the end of January. Subsidary Ledger General Ledger Austin Co. Diaz Co. Noble Co. Balance of Accounts Receivable $ $ $ $arrow_forwardweat subject-Accountingarrow_forward
- Comprehensive Problem 3 Part 2: The following is a comprehensive problem which encompasses all of the elements learned in previous chapters. Yo refer to the objectives for each chapter covered as a review of the concepts. Note: You must complete part 1 before completing part 2. Based on the following data, prepare a bank reconciliation for December of the current year: a. Balance according to the bank statement at December 31, $283,000. b. Balance according to the ledger at December 31, $245,410. c. Checks outstanding at December 31, $68,540. d. Deposit in transit, not recorded by bank, $29,500. e. Bank debit memo for service charges, $750. f. A check for $12,700 in payment of an invoice was incorrectly recorded in the accounts as $12,000. Kornett Company Bank Reconciliation December 31, 20Y8 Adjusted balance Deduct: Adjusted balancearrow_forwardSubject:- accountingarrow_forwardInstructions The following data were gathered to use in reconciling the bank account of Reddan Company: Balance per bank $18,250 Balance per company records 9,780 Bank service charges 30 Deposit in transit 3,650 Note collected by bank with $120 interest 5,050 Outstanding checks 7,100 Instructions a. What is the adjusted balance on the bank reconciliation? b. Journalize any necessary entries for Reddan Company based on the bank reconciliation. Refer to the Chart of Accounts for exact wording of account titles. 181 Land 532 Delivery Expense CHART OF ACCOUNTS 191 Office Equipment 533 Insurance Expense Reddan Company 192 Accumulated Depreciation-Office Equipment 534 Office Supplies Expense General Ledger 193 Store Equipment 535 Rent Expense 194 Accumulated Depreciation-Store Equipment 536 Repairs Expense ASSETS REVENUE 537 Selling Expenses 110 Cash 410 Sales LIABILITIES 538 Store Supplies Expense 111 Petty Cash 610 Interest Revenue 210 Accounts Payable 561 Depreciation Expense-Office…arrow_forward
- Comprehensive Problem 3 Part 2: 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 part 1 before completing part 2. Based on the following data, prepare a bank reconciliation for December of the current year: a. Balance according to the bank statement at December 31, $283,000. b. Balance according to the ledger at December 31, $245,410. c. Checks outstanding at December 31, $68,540. d. Deposit in transit, not recorded by bank, $29,500. e. Bank debit memo for service charges, $750. f. A check for $12,700 in payment of an invoice was incorrectly recorded in the accounts as $12,000. Kornett Company Bank Reconciliation December 31, 20Y5 24 Adjusted balance 24 Total deductions Adjusted balancearrow_forwardAwnser in graph format please please provide the 4 graphsarrow_forwardPROBLEM 1: You obtained the following information on the current account of BUGOY CORP. During your examination of its financial statements for the year ended December 31, 2021. The bank statement on November 30, 2021 showed a balance of P918,000. Among the bank credits in November was customer's note for P300,000 collected for the account of the company which the company recognized in December among its receipts. Included in the bank debits were cost of checkbooks amounting to P3,600 and a P120,000 check which was charged by the bank in error against Bugoy's account. Also in November you ascertained that there were deposits in transit amounting to P240,000 and outstanding checks totaling P510,000. The bank statement for the month of December showed total credits of P1,248,000 and total charges of P612,000. The Company's books for December showed total debits of P2,206,800, total credits of P1,221,600 and a balance of P1,456,800. Bank debit memos for December were: No. 121 for service…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningCollege Accounting (Book Only): A Career ApproachAccountingISBN:9781305084087Author:Cathy J. ScottPublisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781305084087
Author:Cathy J. Scott
Publisher:Cengage Learning