Problem 9.3A (Algo) Preparing a bank reconciliation statement and journalizing entries to adjust the cash balance. LO 9-5, 9-6 140 On May 2, 20X1, HPF Vacations received its April bank statement from First City Bank and Trust. Enclosed with the bank statement, which appears below, was a debit memorandum for $240 that covered an NSF check issued by Doris Fisher, a credit customer. The firm's checkbook contained the following information about deposits made and checks issued during April. The balance of the Cash account and the checkbook on April 30, 20x1, was $3,013. DATE TRANSACTIONS April 1 Balance $6,399 1 Check 1207 3 Check 1208 430 5 Deposit 480 5 Check 1209 340 10 Check 1210 3,300 17 Check 1211 19 Deposit 230 22 Check 1212 9 23 Deposit 230 26 Check 1213 280 28 Check 1214 17 30 Check 1215 30 Deposit 280 75 15 FIRST CITY BANK AND TRUST 1-877-123-9876 HPF Vacations 1718 Jade Lane San Diego, CA 92111-4998 Account Number: 23-11070-08 Activity Summary: Balance, April i Deposits and credits Withdrawals and debits Balance, April 30 April 1-30, 2019 $ 6,399.00 940.00 (4,820.00) $ 2,519.00 DEPOSITS/CREDITS WITHDRAWALS/DEBITS 480.00 DATE DESCRIPTION 4/1/X1 Opening balance 4/6/X1 Deposit 4/6/X1 Check No. 1207 4/10/X1 Check No. 1208 4/10/X1 Check No. 1209 4/13/X1 Check No. 1210 4/14/X1 Service fee 4/20/X1 Deposit 4/22/X1 Check No. 1211 4/25/X1 Deposit 4/26/X1 Check No. 1212 4/29/X1 Debit for NSF Check 4/29/X1 Check No. 1213 Totals 140.00 430.00 340.00 3,300.00 6.00 BALANCE $6,399.00 6,879.00 6,739.00 6,309.00 5,969.00 2,669.00 2,663.00 2,893.00 2,818.00 3,048.00 3,039.00 2,799.00 2,519.00 230.00 75.00 230.00 9.00 240.00 280.00 4,820.00 940.00 Required: 1. Prepare a bank reconciliation statement for the firm as of April 30, 20X1. 2. Record general journal entries for any items on the bank reconciliation statement that must be journalized. Analyze: What checks remain outstanding after the bank statement has been reconciled? Analyze: What checks remain outstanding after the bank statement has been reconciled? Complete this question by entering your answers in the tabs below. Bank Rec General Journal Analyze Prepare a bank reconciliation statement for the firm as of April 30, 20X1. HPF VACATIONS Bank Reconciliation Statement April 30, 20X1 Balance on bank statement Additions: Deductions: Total deductions Adjusted bank balance Balance in books Deductions: Adjusted book balance Screenshot Journal entry worksheet 1 2 Record the deposit in transit. Note: Enter debits before credits. Date April 30, 20X1 General Journal Debit Credit Record entry Clear entry View general journal Journal entry worksheet 4 Record the returned check. Note: Enter debits before credits. Date April 30, 20X1 General Journal Debit Credit Record entry Clear entry View general journal Journal entry worksheet