Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help Using bank reconciliation to determine cash receipts stolen amount of carh receipts by taking the daily depesis to the bank. The following data
please help Using bank reconciliation to determine cash receipts stolen amount of carh receipts by taking the daily depesis to the bank. The following data have been gathered for OctoberI Nis deposins were in transt on Dctober 31 . Tis information kas been collected in the Microsoft Excel Online fie. Goen the spreadsheet, pertom the regulred analysk, and input your answers is the eventigna belis. X= Open spreadshet 2. Detemnine the ameurt of cash receipts stoien by the sales clerk. Round yout answer to the nearest cotan 5 b. What accounting controls would hile prevected or detected this theft? Using bank reconciliation to detormine cash recelpts stolen Alaska Impressions Co. records all cash receipts on the basis of its cash register tapes. Alaska Impressions discovered during October 20Y3 that one of its sales clerks had stolen an undetermined amount of cash receipts by taking the daily deposits to the bank. The following data have been gathered for October: No deposits were in transit on October 31. Using formulas and cell references, perform the required analysis, and input your answers into the Amount column. Transfer the numeric result for the green entry cell (C15) into the appropriate field in CNOWv2 for aradinn Evaluating internal Contriol of Cath The following procedures were recently installed by Raspberry Creek Company: a. After necessary aborovais have been obtained for the poymens of a voucher, the treasurer signs and maits the check, The treasurer then stamps the voucher ans subporting documentation as pald and retums the voucher and supporting documentation to the accounts payable clerk for filing. b. The aceounts payyabie cierk prepares a voucher for each disbursement, The voucher along with the supporting documentation is formarded bo the treasureris onice for approval. C. Along with petty cash expense receipts for postage, oflice supplies, etc, several postdated emplopee chects are in the petty cash hind, d. Ac the end of the coy, cash register derks are regulred to use their own funds to make io any cash shortages is their regitters. e. At the end of each day, all cash recepts are placed in the bank's night depository. 1. At the end of each day, an accounting derk compares the duplicate copy of the dally cash deposit allp with the depost receipt obtained from che benk. 9. All mail is opened by the mall clerk, who forwards al cash remitanoes to the cashier. The castier prepures a listing of the cash recelpts and formerds a copy of the last mo the accoints receivasie cienk. for recording in the accounts. h. The banic reconcilation is prepared by the cashiec, who works unser the susenision of the treasurer. Mequired: Using bank reconciliation to determine cash receipts stolen Alaska Imppressions Ca, recoeds all cash receipts on the basis of its cash register tapes. Alaska Impressions discovered during October 20 I that one of its sales clerks had stelen an undeterreined anount of cash recelpts by taking the call deposits to the bank. The following dats have been gathicred for October: No deposits were in trancit on October 31 . This information has been collected in the Microsoft Excel Onlne file. Open the spresdaheet, perform the requiced analysis; and input wour andwers is the questions below. Using bank reconcillation to determine cash receipts stolen Alaska Impressions Co. records all cash receipts on the basis of its cash register tapes. Alaska Impressions discovered during October 20Y3 that one of its sales clerks had stolen an undetermined amount of cash receipts by taking the daily deposits to the bank. The following data have been gathered for October: No deposits were in transit on October 31. Using formulas and cell references, perform the required analysis, and input your answers into the Amount column. Transfer the numeric result for the green entry cell (C15) into the appropriate field in CNOWV2 for grading. Using bank reconciliation to determine cash receipts stolen amount of carh receipts by taking the daily depesis to the bank. The following data have been gathered for OctoberI Nis deposins were in transt on Dctober 31 . Tis information kas been collected in the Microsoft Excel Online fie. Goen the spreadsheet, pertom the regulred analysk, and input your answers is the eventigna belis. X= Open spreadshet 2. Detemnine the ameurt of cash receipts stoien by the sales clerk. Round yout answer to the nearest cotan 5 b. What accounting controls would hile prevected or detected this theft? Using bank reconciliation to detormine cash recelpts stolen Alaska Impressions Co. records all cash receipts on the basis of its cash register tapes. Alaska Impressions discovered during October 20Y3 that one of its sales clerks had stolen an undetermined amount of cash receipts by taking the daily deposits to the bank. The following data have been gathered for October: No deposits were in transit on October 31. Using formulas and cell references, perform the required analysis, and input your answers into the Amount column. Transfer the numeric result for the green entry cell (C15) into the appropriate field in CNOWv2 for aradinn Evaluating internal Contriol of Cath The following procedures were recently installed by Raspberry Creek Company: a. After necessary aborovais have been obtained for the poymens of a voucher, the treasurer signs and maits the check, The treasurer then stamps the voucher ans subporting documentation as pald and retums the voucher and supporting documentation to the accounts payable clerk for filing. b. The aceounts payyabie cierk prepares a voucher for each disbursement, The voucher along with the supporting documentation is formarded bo the treasureris onice for approval. C. Along with petty cash expense receipts for postage, oflice supplies, etc, several postdated emplopee chects are in the petty cash hind, d. Ac the end of the coy, cash register derks are regulred to use their own funds to make io any cash shortages is their regitters. e. At the end of each day, all cash recepts are placed in the bank's night depository. 1. At the end of each day, an accounting derk compares the duplicate copy of the dally cash deposit allp with the depost receipt obtained from che benk. 9. All mail is opened by the mall clerk, who forwards al cash remitanoes to the cashier. The castier prepures a listing of the cash recelpts and formerds a copy of the last mo the accoints receivasie cienk. for recording in the accounts. h. The banic reconcilation is prepared by the cashiec, who works unser the susenision of the treasurer. Mequired: Using bank reconciliation to determine cash receipts stolen Alaska Imppressions Ca, recoeds all cash receipts on the basis of its cash register tapes. Alaska Impressions discovered during October 20 I that one of its sales clerks had stelen an undeterreined anount of cash recelpts by taking the call deposits to the bank. The following dats have been gathicred for October: No deposits were in trancit on October 31 . This information has been collected in the Microsoft Excel Onlne file. Open the spresdaheet, perform the requiced analysis; and input wour andwers is the questions below. Using bank reconcillation to determine cash receipts stolen Alaska Impressions Co. records all cash receipts on the basis of its cash register tapes. Alaska Impressions discovered during October 20Y3 that one of its sales clerks had stolen an undetermined amount of cash receipts by taking the daily deposits to the bank. The following data have been gathered for October: No deposits were in transit on October 31. Using formulas and cell references, perform the required analysis, and input your answers into the Amount column. Transfer the numeric result for the green entry cell (C15) into the appropriate field in CNOWV2 for grading
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started