Question

In: Accounting

When the bank reconciliation has differing amounts of the company cash account and the bank statement...

When the bank reconciliation has differing amounts of the company cash account and the bank statement what must you do

Solutions

Expert Solution

Bank Reconciliation statement used to track difference between cash account as per books and bank statement.

We required to adjusted cash balance by recording transaction of non-sufficient check, service charge, interest revenue on bank account.

Objective of bank Reconciliation statement is to detect any error in books of account or adjusted the timing difference for deposit in transit and outstanding check.

Let’s check example of bank reconciliation statement.

Company name

Bank Reconciliation Statement

May 31, 2017

Balance as per bank statement

4550

Add: Deposit in transit

3550

Deduct: outstanding checks

Check 101

500

Check 103

1610

Check 104

870

-2980

Adjusted cash balance

5120

Balance as per books of account

3190

Add:

Interest earned

50

Notes receivable collected by bank

2500

2550

Deduct:

Collection charges

25

NSF Check

550

Service charges

45

-620

Adjusted cash balance

5120

Company required to record following entry from above bank Reconciliation statement.

Company name

Journal entries

Date

Account title & explanation

Debit

Credit

May 31, 2017

Cash

2500

Notes receivable

2500

(To Notes receivable collected by bank.)

May 31, 2017

Cash

50

Interest revenue

50

(To record interest revenue.)

May 31, 2017

Collection charges

25

Cash

25

(To record Collection charges.)

May 31, 2017

Service charges

45

Cash

45

(To record Service charges.)

May 31, 2017

Account receivable

550

Cash

550

(To record non-sufficient funds check.)


Related Solutions

The cash account shows a balance of IDR 450 million before reconciliation. The bank statement has...
The cash account shows a balance of IDR 450 million before reconciliation. The bank statement has not taken into account the IDR 23 million deposit made on the last day of the month concerned. The bank statement shows direct billing by the bank to customer A for IDR 9,400,000 and a check from customer B for IDR 3,200,000 returned as it is NSF. Checks from customer C for IDR 4,500,000 are recorded in the book worth IDR 5,400,000 and customer...
Bank Reconciliation Statement. The cash account for Corey’s Construction Company at August 31, 2020, indicated a...
Bank Reconciliation Statement. The cash account for Corey’s Construction Company at August 31, 2020, indicated a book balance of $19,885. The bank statement received by the company indicated a balance of $39,473.63 as at August 31, 2020. A comparison of the bank statement and the accompanying cancelled cheques and memos with the records revealed the following: A deposit of $6,794.62 was received by the bank on August 31 after the bank statement was prepared. Cheques #251 for $1,200 and #260...
The cash account shows a balance of $85,000 before reconciliation. The bank statement does not
The cash account shows a balance of $85,000 before reconciliation. The bank statement does not include a deposit of $5,000 made on the last day of the month. The bank statement shows a collection by the bank of $2,400 and a customer’s check for $680 was returned because it was NSF. A customer’s check for $900 was recorded on the books as $1,080, and a check written for $138 was recorded as $183. The correct balance in the cash account...
Preparing a bank Reconciliation Statement: •The July 31 bank statement for Parkview Company indicated a cash...
Preparing a bank Reconciliation Statement: •The July 31 bank statement for Parkview Company indicated a cash balance of $5,000.17. •The cash ledger account on that date shows a balance of $4,262.83. •Four outstanding checks totaled $717.75. •A $410.90 deposit made after banking hours on July 31 does not appear in the bank statement. •On July 30, the bank returned J.B. Ball’s NSF check for $50.25, received as payment of an account receivable. •The bank statement showed $24.74 interest earned on...
7. The cash account shows a balance of $62,000 before reconciliation. The bank statement does not...
7. The cash account shows a balance of $62,000 before reconciliation. The bank statement does not include a deposit of $4,800 made on the last day of the month. The bank statement shows a collection by the bank of $1,500 and a customer's check for $635 was returned because it was NSF. A customer’s check for $580 was recorded on the books as $850, and a check written for $252 was recorded as $525. What is the correct balance in...
when performing a reconciliation between the bank statement and the cash book, which TWO of the...
when performing a reconciliation between the bank statement and the cash book, which TWO of the following would require an entry in the cash book? a. Deposits credited after date b. Direct debit on bank statement only c. Bank charges d. Bank error
A bank reconciliation is a. A formal financial statement that list all of the bank account...
A bank reconciliation is a. A formal financial statement that list all of the bank account balances of an enterprise. b. A merger of two banks that previously were competitors. c. A statement sent by the bank to depositor on a monthly basis. d. A schedule that accounts for the differences between an enterprise’s cash balance as shown on its bank statement and the cash balance shown in its general ledger.
Preparation of bank reconciliation The April 30, 2016, bank statement for Comet Company showed a cash...
Preparation of bank reconciliation The April 30, 2016, bank statement for Comet Company showed a cash balance of $7,582. The cash account in the company's general ledger (G/L), according to the company's records on April 30, had a balance of $4,643. The following additional data were revealed during the reconciliation process: 1.A deposit of $652 that had been made by the company on March 31 was processed by the bank in April, and a deposit of $1,531 made on April...
The bookkeeper at Hopkins Company has not reconciled the bank statement with the cash account, saying...
The bookkeeper at Hopkins Company has not reconciled the bank statement with the cash account, saying instead, “I don’t have time.” You have been asked to prepare a reconciliation and review the procedures with the bookkeeper. The April 30, 2018, bank statement and the April ledger accounts for cash showed the following (summarized): Bank Statement Cheques Deposits Balance   Balance, April 1, 2018 $ 34,000   Deposits during April $ 37,600 71,600   Notes collected for company      (including $85 interest) 1,330 72,930   Cheques...
The bookkeeper at Hopkins Company has not reconciled the bank statement with the cash account, saying...
The bookkeeper at Hopkins Company has not reconciled the bank statement with the cash account, saying instead, “I don’t have time.” You have been asked to prepare a reconciliation and review the procedures with the bookkeeper. The April 30, 2018, bank statement and the April ledger accounts for cash showed the following (summarized): Bank Statement Cheques Deposits Balance   Balance, April 1, 2018 $ 34,000   Deposits during April $ 37,600 71,600   Notes collected for company      (including $85 interest) 1,330 72,930   Cheques...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT