Ansel Corporation Cash Journal: \begin{tabular}{lll} June 29 & Deposit & $2,450 \\ June 30 & Check #325 & -895 \\ June 30 & Deposit & +2,300 \\ June 30 & Check #326 & -962 \\ & Check $327 & -526 \\ Cash balance: & & $17,704 \end{tabular} At June 30 , deposits in transit were: $4,750 Outstanding checks totaled: $2,383 Required: 1. Prepare the bank reconciliation at June 30 2. Prepare the adjusting entries at June 30 , assuming the NSF checks was from a customer on account and there was no interest accrued on the Note. Balance Per Bank: \$ Balance per Books: $ Add: Add: Less: Less: Errors: +1 Errors: + - Adj. Cash balance per bank $ Adj. Cash balance per books: $ 2. Alyse's Flower Shop 1. The general ledger shows a balance of 535,000 on January 31 . 2. The hank statement shows a balance of $32,466 on Jatanary 31 . 3. The bank statement shows that $148 of interest was earned during the month of January. 4. The depesit of $5,000 on Jamury 31 th was not feflected en the bank statement. 5. The bank statement showed a debit memo of $150 for the retum of a NSF ebeck. 6. Outstanding checks total $2,500. 7. While examining the cleared checks, the treasurer noticed that check il456 correctly cleared for $435. When originally recorded, the check was posted for $453. The eheck was a payment on account to a vendor. 8. The bank statement showod a $0 foe for safety deposit rent. Balance Per Bank: \$ Add: Less: Errors: +% Adj. Cash balance per bank $ Balance pet Books: 5 Add: Less: Errors +% Adj. Cash balance per books: $ The cash balance per books at May 31 is $14,364. The data: a. The NSF check was from our customer H. Hanks b. Outstanding checks at May 31$2,450 c. Deposits in transit at May 31$1,750 d. The bookkeeper is new to accounting and they made an error when recording a deposit. Correct Deposit amount: $2,612 Error in posting: $2,621 Balance Per Bank: \$ Balance per Books: $ Add: Add: Less: Less: Errors: +/- Errors: +l- Adj. Cash balance per bank $ Adj. Cash balance per books: $ 3 4. Cash balance per the general ledger Cash account at the end of the month of October is $10,296, There are two deposits in transit: Deposit on 10/30/23: $4,145 Deposit on 10/31/23: \$2,095 There are three outstanding checks: Check #356 \$125 Check $358 \$1,102 Check \#359 \$862 One of your customer's payment on account for $268 was returned for insufficient funds. The bank collected a payment of $618 from a sale made on account earlier in the month. The monthly bank service charge is $35 Check $44 correctly cleared the bank for $365; however, the bookkeeper accidentally recorded the check amount as $356. Instruction: Reconcile the bank account as of October 31 solving for the Balance per Bank as of 10/31/2023. You do not need to record the journal entries. Balance per Bank: \$ Add: Balance per Books: $ Add: Subtract: Subtract: Bank Errors +/- Bookkeeper Errors +/ - Adjusted cash balance:\$ Adjusted cash balance $ 4
