p5-4

for part b), please do the tabular analysis like the pic above with the accounts in b

S348. 5. Checks outstanding on July 31 totalel 6. On July 31, the bank statement showed an N the company from W. Krueger, a customer, on account. Instructions (a) Prepare the bank reconciliation as of July 31. (b) Prepare a tabular analysis for the necessary adjustments at July 31. Use the following sh bal. S7,024.00 column headings: Cash, Accounts Receivable, Accounts Payable, Revenues, and Expenses. Include margin explanations for the revenues and expenses. nts from The ba 1. A 2. A P5-4 The bank portion of the bank reconciliation for Bogalusa Company at October 31, 2017, is as follows IOCAL, USA C OMPA NY Bank Reconcilation October 31, 2017 Cash balance per bank Add: Deposits in transit $12,367.90 1.530 20 13,898.10 Less: Outstanding checks Check Number 2451 Check Amount $1,260.40 684.20 844.50 426.80 2471 2472 2474 1,050.00 426590 9,632,20 Adjusted cash balance per bank e ticThe adjusted cash balance per bank agreed with the cash balance per books at October 31 The November bank statement showed the following checks and deposits. Bank Statement ook Checks Deposits Date Number Amount Amount 1,530.20 2470 S 684.20 844.50 1,050,00 11-1 11-4 ay Z 2474 2475 2476 2477 2479 990.10 2,575.00 1,472.70 2,945.00 2,567.30 1,650.00 1,186.00 575.50 Tota $16,127.90 1,640.70 1113 2,830,00 11-18 600.00 11-21 1,750.00 11-25 1,330.00 1-28 695.40 1-30 1-10 11-15 gave 11-27 2481 11-30 2483 11-29 2486 Total 30 im 940.00 $12,940.30 bou The cash records per books for November showed the following. ison Cash Receipts Record Cash Payments Record Date Number Amount Date Number Amount Date Amount 2475 $1,640.70 11-20 2483 575.501-3 1,211.60 1-2 2476 2,830.00 11-22 2484 829.50 11-7 990.10 he or 974.80 12 2,575.00 940.00 1117 1472.70 398.00 20 2,954.00 800,00 24 2,567.30 11-2 2477 600.00 11-23 2485 538.20 11-24 2486 114 2478 1-8 2479 1,705.00 11-29 2487 1110 2480 1,330.00 11 11-15 2481 -30 248s 11-27 1,650.00 11-29 1,186.00 1,304.00 Total $15,910.70 695.40 Total 612.00 $14,469.10 1-18 2482 latement contained two bank memoranda redit of $2,242 for the collection for Bogalusa Company of an electronic funds transfer it lor the printing of additional company checks $85 200 5 Fraud, Internal Control, and Cash At November 30, the cash balance per books was $11,073.80 and the cash balance pe bank statement was $17,712.50. The bank did not make any errors, but Bogalusa Com pany made two errors. Instructions (a) Adjusted cash bal. $13,176.80 (a) Using the steps in the reconciliation procedure described on pages 173-174, preparea bank reconciliation at November 30, 2017. (b) Prepare a tabular analysis for the adjustments based on the reconciliation. Use the fol lowing column headings: Cash, Accounts Receivable, Accounts Payable, Revenues, and Expenses. Include margin explanations for the changes in revenues and expenses. (Note The correction of any errors pertaining to recording checks should be made to Accounts Payable. The correction of any errors relating to recording cash receipt should be made to Accounts Receivable.) Ins Prepare a bank reconciliation P5-5 Timmins Company of Emporia, Kansas, spreads herbicides and applies liquid fer and adjustments tilizer for local farmers. On May 31, 2017, the company's Cash account showed a balance of $6,738.90. (LO 3), AP The bank statement from Emporia State Bank on that date showed the following balance P5 M: EMPORIA STATE BANK Stockholders Equity Assets Liabilities Retained Earnings Accounts Note Common Retained Receivabile Supplies EquipPayable Payable Stock Earnings Revenues Expenses Dividends Explan Sheet2