Question

to Prepare Keeper Ltd’s bank reconciliation, you gather the following data: The 30 September bank statement...

to Prepare Keeper Ltd’s bank reconciliation, you gather the following data:

  1. The 30 September bank statement balance is $5,120 CR.
  2. The bank statement included a dishonoured cheque from a customer of $180.
  3. The following cheques are outstanding at 30 September:

Cheque no.

Amount ($)

918

3,450

922

270

iv.          The following amounts were included on the bank statement:

•    a $3,200 EFT deposit from an account customer

•    $350 for interest revenue that Keeper hadn’t recorded

•    a $40 bank service charge.

v. On 30 September 2020, Keeper deposited $1,500 in the bank’s night safe, but this deposit doesn’t appear on the bank statement.

vi. The bank statement includes a $200 payment belonging to Seeker Ltd, an unrelated company. This is a bank error

vii. The general ledger Cash account had a balance of $230 CR on 30 September 2020.

Required:

(a)            Prepare a Bank Reconciliation Statement at 30 September. (4  marks)

(b)       Show workings summarising the adjustments required to give the correct balance in the Cash at Bank general ledger account at 30 September. (4  marks)

Homework Answers

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
1.Prepare bank reconciliation statement and adjusting entries.Shoe City Pty Ltd’s bank reconciliation clerk is unable to...
1.Prepare bank reconciliation statement and adjusting entries.Shoe City Pty Ltd’s bank reconciliation clerk is unable to reconcile the bank balance at 31 January. The balance of the cash at bank account, before any entries for transactions initiated by the bank, was $4770.20 in the company records. The clerk’s attempt at the bank reconciliation statement is as follows: Cash balance as per bank statement $4 392.20 Cr Add: Dishonoured cheque $516.00 Less: Bank charges $30.00 Less: Outstanding deposits $708 Add: Unpresented...
McDermott Company's bank statement for September 30 showed an ending cash balance of $1,476. The company's...
McDermott Company's bank statement for September 30 showed an ending cash balance of $1,476. The company's Cash account in its general ledger showed a $1,130 debit balance. The following information was also available as of September 30. The bank deducted $170 for an NSF check from a customer deposited on September 15. The September 30 cash receipts, $1,340, were placed in the bank's night depository after banking hours on that date and this amount did not appear on the September...
McDermott Company's bank statement for September 30 showed an ending cash balance of $1,462. The company's...
McDermott Company's bank statement for September 30 showed an ending cash balance of $1,462. The company's Cash account in its general ledger showed a $1,115 debit balance. The following information was also available as of September 30. • The bank deducted $165 for an NSF check from a customer deposited on September 15. • The September 30 cash receipts, $1,330, were placed in the bank's night depository after banking hours on that date and this amount did not appear on...
Bank Reconciliation 16. Information about the cash position for Wellington Ltd for the month of June...
Bank Reconciliation 16. Information about the cash position for Wellington Ltd for the month of June 2018 is presented below:  The general ledger Cash at Bank had a balance of $12,600 (Dr) on 30 June 2018.  The June bank statement reported a bank balance of $11,422 (Cr) on 30 June.  Outstanding cheques at the end of June were: No. 777, $120; No. 888, $146; and No. 999, $224.  Cheque receipts of $2,400 for June were placed...
The balance in Happ, Inc.’s general ledger Cash account was $13,200 at September 30, before reconciliation....
The balance in Happ, Inc.’s general ledger Cash account was $13,200 at September 30, before reconciliation. The September 30 balance shown in the bank statement was $11,830. Reconciling items included deposits in transit, $1,270; bank service charges, $105; NSF check written by a customer and returned with the bank statement, $520; outstanding checks, $450; and interest credited to the account during September but not recorded on the company’s books, $75. Required: Prepare a bank reconciliation as of September 30 for...
The September 30 bank statement for Cadieux Company and the September ledger account for cash are...
The September 30 bank statement for Cadieux Company and the September ledger account for cash are summarized here: BANK STATEMENT Checks Deposits Other Balance   Balance, September 1 $ 2,060   September 7 NSF check $ 100 1,960   September 11 $ 3,090 5,050   September 12 #101 $ 830 4,220   September 17 #102 1,760 2,460   September 26 #103 2,330 130   September 29 EFT deposit 165 295   September 30 Service charge   20 275 Cash (A)   Sep 1      Balance 2,060     Sep 10 3,090   830             ...
Bank reconciliation Prepare a bank reconciliation as of October 31 from the following information: a. The...
Bank reconciliation Prepare a bank reconciliation as of October 31 from the following information: a. The October 31 cash balance in the general ledger is $1,688. b. The October 31 balance shown on the bank statement is $746. c. Checks issued but not returned with the bank statement were No. 462 for $26 and No. 483 for $100. d. A deposit made late on October 31 for $900 is included in the general ledger balance but not in the bank...
Prepare a bank reconciliation for Party USA based on the following information and then prepare journal...
Prepare a bank reconciliation for Party USA based on the following information and then prepare journal entries to adjust the general ledger cash balance. Party USA           Bank Reconciliation Dec. 31, 2019 Bank Side Book side Bank Balance Dec 31     General Ledger Balance Dec. 31 Add: Add: Less: Less: Adjusted Bank Balance Adjusted Book Balance Bank Balance 10,450 General ledger cash balance 10,563 Total Deposits in December 64,300 total Checks written in December 12,767 Outstanding Checks as of...
hi, ion was available for the September 30, 2017, reconciliation: From the September 30, 2017, bank...
hi, ion was available for the September 30, 2017, reconciliation: From the September 30, 2017, bank statement   BALANCE OF PREVIOUS STATEMENT ON AUG. 31/17 10,440.00   6 DEPOSITS AND OTHER CREDITS TOTALLING 19,446.00   9 CHEQUES AND OTHER DEBITS TOTALLING 24,130.00   CURRENT BALANCE AS OF SEPT. 30/17 5,756.00 Chequing Account Transactions Date Amount Transaction Description Date Amount Transaction Description   Sept. 05     5,420.00        + Deposit Sept. 25     3,316.00         + Deposit 12     2,315.00        + Deposit 30     39.00...
DROP OUT STORES BANK RECONCILIATION STATEMENT AT 30 APRIL 2007 Cr. Balance per bank statement R1324...
DROP OUT STORES BANK RECONCILIATION STATEMENT AT 30 APRIL 2007 Cr. Balance per bank statement R1324 Add: outstanding deposit R180 = R1 504 Less: outstanding Cheques: No. 361- R 84/ Chq366-R265/ Chq367-R80/ Chq368 - R50/ Chq370- R35 Dr. balance per cash book Balances at 31 May 2007: bank statement (favourable) R324. Cash book (dr. )R384 Items on May bank statement, but not in May cash book: 1. Deposit: R180 2. Telegraphic transfer on 20 May by debtor, W. Pay, to...