Reference no: EM131396904
Assignment
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?
Show all work in the Excel spreadsheet and submit with the reconciliation report.
|
Graphs of the exponential functions
: The figures below show the graphs of the exponential functions f(x) and g(x) and h(x) the linear function,. The function f(x) has y-intercept (.75) and goes through the point (1,9/2).
|
|
Significant processing power and storage capacity
: Smartphones have innovative user interfaces and applications; and significant processing power and storage capacity. And most owners would not ever be without their mobiles. Smartphones can be an asset to a business but should they be allowed in an e..
|
|
Write an organizational policy to correct it-related ethics
: Write an organizational policy (or personal policy, if not in the job force) to correct the IT-related ethical issue that you described in Paper B1, where you mapped key organizational or personal issues and identified how these digital ethical is..
|
|
What odds ratio means and what confidence limit implies
: Compute the odds ratio and its 95% confidence limit. Write in words what this odds ratio means and what this confidence limit implies.
|
|
What principles of internal control were violated in case
: 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?
|
|
What are high availability scalability and interoperability
: An information system often must share information, or have interoperability, with other information systems within the enterprise.
|
|
Determining the annual interest
: You deposit $5000 into an account that earns 8% compounded annually. A friend deposits $4250 into an account that earns 7.95% annual interest, compounded continuously. Will your friend's balance ever equal yours? If so, when? If not, enter NEVER
|
|
About their views on increased food prices
: Assume you are planning to interview shoppers in a shopping mall about their views on increased food prices and what the federal government should do about them. In what different ways might you try to motivate shoppers to cooperate in your survey?
|
|
Career progression where they apply for roles
: For those who become managers, they reach a stage in their career progression where they apply for roles which have management responsibilities. Thus, why should a manager know about research and research methods when the job entails managing people,..
|