Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Prepare a bank reconciliation from detailed data. The bank portion of the bank reconciliation for Initech at March 31, 2023, is shown below. Initech Bank
Prepare a bank reconciliation from detailed data. The bank portion of the bank reconciliation for Initech at March 31, 2023, is shown below. Initech Bank Reconciliation March 31, 2023 Cash balance per bank $12,367.90 Add: Deposits in transit 1,530.20 13,898.10 Less: Outstanding checks: Check Number Check Amount 2451 $1,260.40 2470 684.20 2471 844.50 2472 426.80 2474 1,050.00 4,265.90 Adjusted cash balance per bank $9,632.20 The adjusted cash balance per bank agreed with the cash balance per books at March 31. The April bank statement showed the following checks and deposits: Bank Statement Checks Deposits Date Number Amount Date Amount 4-2 2471 844.50 4-1 $1,530.20 4-3 2451 1,260.40 4-4 1,211.60 4-4 2472 426.80 4-8 990.10 4-5 2474 1,050.00 4-13 2,575.00 4-6 2475 1,137.70 4-18 1,472.70 4-8 2476 2,330.00 4-21 2,945.00 4-10 2477 600.00 4-25 2,567.30 4-15 2479 1,750.00 4-28 1,650.00 4-18 2480 1,330.00 4-30 1,186.00 4-27 2481 695.40 Total $16,127.90 4-28 2483 575.50 4-30 2486 940.00 Total $12,940.30 The cash records per books for April showed the following: Cash Payments Journal Date Number Amount Date Number Amount 4-1 2475 $1,137.70 4-20 2483 $575.50 4-2 2476 2,330.00 4-22 2484 829.50 4-2 2477 600.00 4-23 2485 974.80 4-4 2478 538.20 4-24 2486 940.00 4-8 2479 1,755.00 4-29 2487 398.00 4-10 2480 1,330.00 4-30 2488 1,303.00 4-15 2481 695.40 Total $14,019.10 4-18 2482 612.00 Cash Receipts Journal Date Amount 4-3 1,211.60 4-7 990.10 4-12 2,575.00 4-17 1,472.70 4-20 2,945.00 4-24 2,675.30 4-27 1,650.00 4-29 1,186.00 4-30 1,428.00 Total 16,133.70 The April bank statement contained two bank memoranda: 1. A credit of $2,400 for the collection of a customer payment via an electronic funds transfer. 2. A debit of $35 for the printing of additional company checks. At April 30, the cash balance per books was $11,746.80 and the cash balance per bank statement was $17,920.50. The bank did not make any errors, but Initech made two errors. Instructions (a) Using Excel, prepare a bank reconciliation (in good form) for Initech as of April 30, 2023
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