Question

4. The bank statement for Allen Co. indicates a balance of $8,000.00 on June 30. After...

4. The bank statement for Allen Co. indicates a balance of $8,000.00 on June 30. After the books for June have been adjusted, the cash account balance had a balance of $3,675.00. Prepare the bank reconciliation on the basis of the following information:

  1. Cash Receipts of $342 had been recorded on the books as $324,

  2. Deposits in transit not record by the bank, $500

  3. Bank service charges, $25

  4. Note collected by the bank and not yet notified to the company,$3,250 including

    interest

  5. NSF check from a customer, $218

  6. Checks outstanding, $1,800

Homework Answers

Answer #1

Solution:

Bank Reconciliation Statement
Allen Company
Bank Book
Balance, June 2020 $ 8000 Balance, June 2020 $ 3675
Add: Add:
Deposit in transit $ 500 Note Collected $ 3250
Error in recording (342-324) $ 18
$ 8500 $ 6943
Less: Less:
Outstanding Cheques $ 1800 Bank Charges $ 25
NSF Cheques from Customer $ 218
Monthly Note Payment
$ 1800 $ 243
Adjusted Bank Balance $ 6700 Adjusted Book Balance $ 6700
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Lazer Company had the following bank reconciliation on June 30: Balance per bank statement, June 30                          
Lazer Company had the following bank reconciliation on June 30: Balance per bank statement, June 30                                                                                     3,000,000 Deposit in transit                                                                                                                                  400,000 Total                                                                                                                                                      3,400,000 Outstanding checks                                                                                                                        (900,000) Balance per book, June 30                                                                                                           2,500,000 The bank statement for the month of July showed the following: Deposits, including P200, 000 note collected for Lazer                                                     9,000,000 Disbursements, including P140, 000 NSF customer check                 and P10,000 service charge                                                                                          7,000,000 All reconciling items on June 30 cleared through the bank in July. The...
Exercise 7-9 Don Wyatt is unable to reconcile the bank balance at January 31. Don’s reconciliation...
Exercise 7-9 Don Wyatt is unable to reconcile the bank balance at January 31. Don’s reconciliation is as follows. Cash balance per bank $3,760.20 Add: NSF check 590.00 Less: Bank service charge 30.00 Adjusted balance per bank $4,320.20 Cash balance per books $4,075.20 Less: Deposits in transit 630.00 Add: Outstanding checks 935.00 Adjusted balance per books $4,380.20 Prepare a correct bank reconciliation. (List items that increase cash balance first. Reconcile cash balance per bank first. Round answers to 2 decimal...
Bentley Company’s June 30 bank statement and June ledger account for cash are summarized below: BANK...
Bentley Company’s June 30 bank statement and June ledger account for cash are summarized below: BANK STATEMENT Checks Deposits Balance Balance, June 1 $ 6,500 Deposits during June $ 16,200 22,700 Checks cleared during June $ 16,600 6,100 Bank service charges 40 6,060 Balance, June 30 6,060 Cash (A) June 1 Balance 6,500   June Checks written 19,000 June Deposits 18,100 Required: 1. Reconcile the bank account. A comparison of the checks written with the checks that have cleared the bank...
Whispering Winds Spa shows a general ledger balance for the Cash account of $4,169.35 on June...
Whispering Winds Spa shows a general ledger balance for the Cash account of $4,169.35 on June 30 and the bank statement as of that date indicates a balance of $4,195.00. When the statement was compared with the cash records, the following facts were determined: 1. There were bank service charges for June of $23.00. 2. A bank memo stated that Bao Dai’s note for $906.00 and interest of $51.00 had been collected on June 29, and the bank had charged...
Jamison Company gathered the following reconciling information in preparing its June bank reconciliation: Cash balance per...
Jamison Company gathered the following reconciling information in preparing its June bank reconciliation: Cash balance per bank, June 30 $11,883 Note receivable collected by bank 7,216 Outstanding checks 5,690 Deposits in transit 4,345 Bank service charge 77 NSF check 1,902 Using the above information, determine the cash balance per books (before adjustments) for Jamison Company. On October 1, Black Company receives a 10% interest-bearing note from Reese Company to settle a $16,200 account receivable. The note is due in six...
Chicago Company has hired you to reconcile its bank statement and cash account. At June 30,...
Chicago Company has hired you to reconcile its bank statement and cash account. At June 30, 2019, the Cash account on the books showed the following: Cash account Date Explanation Debits Credits Balance June 1 Balance $5,600 June 1-30 Deposits $32,000 37,600 June 1-30 Checks $29,700 7,900 June 30 Balance 7,900 The June bank statement, just received, showed the following: June 1, balance $5,600 Deposits made in June 29,000 Interest paid by the bank in June 120 Checks paid in...
The cash records of Mercury Company show the following: 1. The June 30 bank reconciliation indicated...
The cash records of Mercury Company show the following: 1. The June 30 bank reconciliation indicated that deposits in transit totaled $790. During July the general ledger account Cash shows deposits of $9,800, but the bank statement indicates that only $8,240 in deposits were received during the month. 2. The June 30 bank reconciliation also reported outstanding checks of $1,200. During the month of July, Mercury Company books show that $11,570 of checks were issued, yet the bank statement showed...
The cash records of Jasmin Company show the following four situations: 1) The June 30 bank...
The cash records of Jasmin Company show the following four situations: 1) The June 30 bank reconciliation indicated that deposits in transit total $2,110. During July the general ledger account Cash shows deposits of $23,620, but the bank statement indicates that only $23,400 in deposits were received during the month. 2) The June 30 bank reconciliation also reported outstanding checks of $1,250. During the month of July, Jasmin Company books show that $25,800 of checks were issued. The bank statement...
The cash records of Sunland Company show the following. For July: 1. The June 30 bank...
The cash records of Sunland Company show the following. For July: 1. The June 30 bank reconciliation indicated that deposits in transit total $700. During July, the general ledger account Cash shows deposits of $18,870, but the bank statement indicates that only $15,810 in deposits were received during the month. 2. The June 30 bank reconciliation also reported outstanding checks of $910. During the month of July, Sunland Company books show that $17,980 of checks were issued, yet the bank...
Ayayai Spa shows a general ledger balance for the Cash account of $4,181.35 on June 30...
Ayayai Spa shows a general ledger balance for the Cash account of $4,181.35 on June 30 and the bank statement as of that date indicates a balance of $4,135.00. When the statement was compared with the cash records, the following facts were determined: 1. There were bank service charges for June of $29.00. 2. A bank memo stated that Bao Dai’s note for $918.00 and interest of $36.00 had been collected on June 29, and the bank had charged $4.50...