Prepare a 1050 word bank reconciliation report

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.

You can leave a response, or trackback from your own site.

CLICK ORDER NOW TO GET A CUSTOMIZED PAPER ON THIS TOPIC JUST FOR YOU!! 0%PLAGIARISM 100% ORIGINAL PAPER

14 Responses to “Prepare a 1050 word bank reconciliation report”

  1. 410443 617374When I initially commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several e-mails with the same comment. Is there any way you can remove people from that service? Bless you! 645280

  2. 859493 822016Hey there, I feel your weblog may possibly be having browser compatibility issues. When I look at your site in Safari, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, superb weblog! 546205

  3. 147346 492159View the following tips less than and find to know how to observe this situation whilst you project your home business today. Earn money from home 38111

  4. 272128 255124I admire your function , regards for all the useful blog posts. 268662

  5. 947478 250792Soon after study a number of the websites with your site now, and that i genuinely appreciate your method of blogging. I bookmarked it to my bookmark site list and are checking back soon. Pls have a look at my internet page likewise and let me know in case you agree. 231825

  6. judi online says:

    365128 684928Hi. Cool post. Theres an problem with your site in firefox, and you may want to check this The browser could be the market chief and a good section of folks will pass more than your great writing because of this dilemma. 700389

  7. 575418 859499There a few interesting points more than time here but I dont know if I see them all center to heart. There exists some validity but Let me take hold opinion until I appear into it further. Very excellent post , thanks and now we want far more! Included with FeedBurner at exactly the same time 405971

  8. 189766 632999In todays news reporting clever journalists function their own slant into a story. Bloggers use it promote their works and a lot of just use it for fun or to stay in touch with pals far away. 57735

  9. diamond art says:

    200063 981191I located your weblog internet website on google and check several of your early posts. Continue to maintain up the superb operate. I just further up your RSS feed to my MSN News Reader. Searching for forward to studying extra from you in a even though! 745327

  10. 201535 458014Rattling excellent information can be discovered on web blog . 93951

  11. 458016 520962I discovered your weblog on yahoo and can bookmark it currently. carry on the nice function. 546248

  12. 692645 252839Aw, this became an incredibly good post. In thought I would like to devote writing such as this moreover – taking time and actual effort to make a extremely good article but exactly what do I say I procrastinate alot and by no means locate a strategy to get something completed. 186717

  13. 853175 580564Hello there! I could have sworn Ive been to this weblog before but after reading through some with the post I realized it is new to me. Anyhow, Im certainly pleased I discovered it and Ill be book-marking and checking back frequently! 377218

  14. 834402 175160Top rated lad speeches and toasts, as well toasts. may possibly extremely properly be supplied taken into consideration generating at the party consequently required to be slightly a lot more cheeky, humorous with instructive on top of this. finest man speeches funny 667143

Leave a Reply

Powered by WordPress | Designed by: buy backlinks | Thanks to webdesign berlin, House Plans and voucher codes