Reference no: EM131418951
Purpose of Assignment
Reconciling bank accounts is a good way to help maintain internal controls over cash. With time lags and posting errors it is easy for cash transactions to be omitted, recorded in a different accounting period, or reflect incorrect amounts. This assignment with give you practical experience in reconciling the cash balance as noted on the company books to the bank's records.
Assignment Steps -
Resources: Financial Accounting: Tools for Business Decision Making
Scenario: Daisey Company is a very profitable small business. It has not, however given much consideration to internal control. For example, in an attempt to keep clerical and office expenses to a minimum, the company has combined the jobs of cashier and book-keeper. As a result, Bret Turrin handles all cash receipts, keeps the accounting records, and prepares the monthly bank reconciliations.
The balance per the bank statement on October 31, 2017, was $18,380. Outstanding checks were No. 62 for $140.75, No. 183 for $180, No. 284 for $253.25, No. 862 for $190.71, No. 863 for $226.80, and No. 864 for $165.28. Included with the statement was a credit memorandum of $185 indicating the collection of a note receivable for Daisey Company by the bank on October 25.
This memorandum has not been recorded by Daisey.
The company's ledger showed one Cash account with a balance of $21,877.72. The balance included undepositied cash on hand. Because of the lack of internal controls, Bret took for personal use all of the undeposited receipts in excess of $3,795.51. He then prepared the following bank reconciliation in an effort to conceal his theft of cash:
|
Cash balance per books, October 31
|
|
$21,877.72
|
|
Add: Outstanding checks
|
|
|
|
No. 862
|
$190.71
|
|
|
No. 863
|
226.80
|
|
|
No. 864
|
165.28
|
482.79
|
|
|
|
22,360.51
|
|
Less: Undeposited receipts
|
|
3,795.51
|
|
Unadjusted balance per bank, October 31
|
|
18,565.00
|
|
Less: Bank credit memorandum
|
|
185.00
|
|
Cash balance per bank statement, October 31
|
|
$18,380.00
|
Prepare a 1,050-word bank reconciliation report (hint: deduct the amount of the theft from the adjusted balance per books) including the following:
- Indicate the three ways that Bret attempted to conceal the theft and the dollar amount involved in each method.
- What principles of internal control were violated in this case?
USE APA format. Show all work in the Excel spreadsheet and submit with the reconciliation report.
Attachment:- Assignment File.rar
|
Organization external and internal strategies
: Describe the field of organizational development (OD) and its relationship to training activities, including the value of cross training between the two. Identify possible HRD strategic alternatives and situations in which they might be appropriate..
|
|
What does the accompanying scatterplot suggest
: What does the accompanying scatterplot suggest about the shape of the distribution for hours studied per week? What does it suggest about the shape of the distribution for monthly cell phone bill?
|
|
Image while dealing with talent surplus
: How can an organization maintain its image while dealing with talent surplus? If layoffs are necessary, what would you recommend managers do to ensure that survivors remain committed and productive?
|
|
Career development of employees
: In 200-250 words, what is HR's role in impacting the career development of employees? What should be the role of training? How can training programs be evaluated on their effectiveness?
|
|
Prepare a bank reconciliation report
: Prepare a 1,050-word bank reconciliation report (hint: deduct the amount of the theft from the adjusted balance per books) including the following: What principles of internal control were violated in this case
|
|
Implementing a streamlined information assurance program
: It could be in the field of securing a wireless network, implementing a streamlined information assurance program, generic security design for a business, personal information privacy protection, etc.
|
|
List the numbers and take the mean
: Put the six pieces of paper in a bowl or hat, and then pull six out, one at a time, replacing each one and mixing them up before pulling the next. List the numbers and take the mean.
|
|
Organizational culture positively or negatively
: 1) Discuss several area in which HR can effect organizational culture positively or negatively. 2) Give some example of ethical issues that you have experienced in jobs and explain how HR did or did not help resolve them.
|
|
Write a probability and a statistics question
: Write a probability and a statistics question associated with the given information.- It has been reported that 62% of all people use a social media.
|