Question

In: Accounting

Bank reconciliation The company’s accounting intern has prepared the end-of-January bank reconciliation from the bank statement,...

Bank reconciliation

The company’s accounting intern has prepared the end-of-January bank reconciliation from the bank statement, and is worried because the Adjusted Balance amounts do not agree. After reviewing the bank reconciliation, scroll down for the next steps in helping the intern.

Murdstone Co.

Bank Reconciliation

January 31, 20Y5

1

Cash balance according to bank statement

$23,557.98

2

Deduct deposit of May 31, not recorded by bank

12,125.25

3

$11,432.73

4

Add outstanding checks:

5

No. 124

$62.00

6

No. 125

86.00

7

No. 129

1,250.00

1,398.00

8

Adjusted balance

$12,830.73

9

10

Cash balance according to Murdstone Co.

$51,567.88

11

Add check returned because of insufficient funds

23,475.40

12

$75,043.28

13

Deduct: Note and interest collected by bank

$15,250.75

14

Bank service charge

400.00

15

Error in recording Check No. 123

9,000.00

24,650.75

16

Adjusted balance

$50,392.53

You assist the intern to check source documents, and find that most of the dollar amounts are correct; however, two dollar amounts are incorrect. After reviewing the following table, scroll down for the next steps in helping the intern.

Item

Correct in Intern’s Reconciliation?

If “No,” Corrected Amount

Cash balance according to bank statement Yes
Deposit of January 31, not recorded by bank Yes
Outstanding check No. 124 Yes
Outstanding check No. 125 No $68.00
Outstanding check No. 129 Yes
Cash balance according to Murdstone Co. Yes
Amount of check returned because of insufficient funds Yes
Amount of note and interest collected by bank Yes
Bank service charge No $40.00
Company error in recording Check No. 123 as $12,435.00 rather than the correct amount of $21,435.00 Yes

After asking the intern to search for other errors by comparing her reconciliation to prior bank reconciliations prepared by the former accountant, you work together to compute the corrected Adjusted Balance. Enter your answer with two decimal places.

Q) What is the Corrected Adjusted Balance amount?

Solutions

Expert Solution

Murdstone Co.
Bank Reconciliation
January 31, 20Y5
1 Cash balance according to bank statement       23,557.98
2 Add deposit of May 31, not recorded by bank       12,125.25
3       35,683.23
4 Deduct outstanding checks:
5 No. 124          62.00
6 No. 125          68.00
7 No. 129     1,250.00          1,380.00
8 Adjusted balance       34,303.23
9
10 Cash balance according to Murdstone Co.       51,567.88
13 Add Note and interest collected by bank       15,250.75
12       66,818.63
11 Deduct: check returned because of insufficient funds 23,475.40
14 Bank service charge          40.00
15 Error in recording Check No. 123     9,000.00       32,515.40
16 Adjusted balance       34,303.23
Q What is the Corrected Adjusted Balance amount         34,303.23

Related Solutions

the following information was taken from a company’s bank reconciliation at the end of the year:...
the following information was taken from a company’s bank reconciliation at the end of the year: Bank balance $ 8,900 Checks outstanding $ 7,700 Note collected by the bank $ 1,300 Service fee $ 25 Deposits outstanding $ 4,100 NSF check $ 300 What is the correct cash balance that should be reported in the company's balance sheet at the end of the year? a.$5,275. b.$9,900. c.$5,300. d.$8,600. 2 At December 31, Gill Co. reported accounts receivable of $292,000 and...
Bank Reconciliation An accounting clerk for Chesner Co. prepared the following bank reconciliation: Chesner Co. Bank...
Bank Reconciliation An accounting clerk for Chesner Co. prepared the following bank reconciliation: Chesner Co. Bank Reconciliation July 31, 20Y4 Cash balance according to company's records $8,260 Adjustments: Outstanding checks $3,960 Error by Chesner Co. in recording Check No. 1056 as $820 instead of $280 540 Note for $13,000 collected by bank, including interest 13,520 Deposit in transit on July 31 (8,410) Bank service charges (30) Total adjustments 9,580 Cash balance according to bank statement $17,840 a. From the data...
An accounting clerk for Chesner Co. prepared the following bank reconciliation:
 An accounting clerk for Chesner Co. prepared the following bank reconciliation: A. From the data in this bank reconciliation, prepare a new bank reconciliation for Chesner Co., using the format shown in the Let's Review section. B. If a balance sheet were prepared for Chesner Co. on July 31, 20Y4, what amount should be reported for cash?
Your assistant prepared the following bank reconciliation statement. It appears that the statement is unacceptable and...
Your assistant prepared the following bank reconciliation statement. It appears that the statement is unacceptable and the task of preparing a proper reconciliation falls upon you. Brandon Company Bank Reconciliation May 31, 2017   Balance per books May 31 $9,585   Add:      Electronic Fund Transfer $1,111      Deposit in transit 2,506 3,617 $13,202   Deduct:      Bank charges $27      NSF cheque, Rhonda Teal 534      Outstanding cheques 1,851      Error in cheque #78: correctly issued and processed       by the bank for $796, but incorrectly recorded       in the...
Bank reconciliation statement questions under intermediate Accounting
Bank reconciliation statement questions under intermediate Accounting
Bank Reconciliation The following bank reconciliation was prepared as of June 30, 20Y7: Poway Co. Bank...
Bank Reconciliation The following bank reconciliation was prepared as of June 30, 20Y7: Poway Co. Bank Reconciliation For the Month Ended June 30, 20Y7 Cash balance according to bank statement $16,185 Adjustments: Outstanding Check No.1067 $575 Outstanding Check No.1106 470 Outstanding Check No.1110 1,050 Outstanding Check No.1113 910 Deposit of June 30 not recorded by bank (6,600) Total adjustments (3,595) Adjusted balance $12,590 Cash balance according to company’s records $8,985 Adjustments: Proceeds of note collected by bank: Face value $6,000...
Question 4 [27] The following bank reconciliation statement was prepared by the bookkeeper of Veggie Stores...
Question 4 [27] The following bank reconciliation statement was prepared by the bookkeeper of Veggie Stores for January 2020. The financial year of the business ends in January each year. Bank overdraft as per bank statement R35 000 Outstanding deposit on 10 January 2020 R12 900 28 January 2020 R10 000 Outstanding deposit: Cheque received from B Brother dated 24 February 2020 R1 800 Outstanding cheques: No. 1642 (dated 20 July 2019) R7 000 No. 9172 (dated 25 January 2020)...
Question 4 [27] The following bank reconciliation statement was prepared by the bookkeeper of Veggie Stores...
Question 4 [27] The following bank reconciliation statement was prepared by the bookkeeper of Veggie Stores for January 2020. The financial year of the business ends in January each year. Bank overdraft as per bank statement R35 000 Outstanding deposit on 10 January 2020 R12 900 28 January 2020 R10 000 Outstanding deposit: Cheque received from B Brother dated 24 February 2020 R1 800 Outstanding cheques: No. 1642 (dated 20 July 2019) R7 000 No. 9172 (dated 25 January 2020)...
Question What is bank reconciliation? What is the objectives of the bank reconciliation statement?
Question What is bank reconciliation? What is the objectives of the bank reconciliation statement?
Bank Reconciliation In-Class Team Case. You received the client prepared bank reconciliation presented below and are...
Bank Reconciliation In-Class Team Case. You received the client prepared bank reconciliation presented below and are auditing Simply Soups Inc’s cash; control risk over cash is assessed at the maximum level. For each item select the one or more procedures she could perform to gather evidence in support of it. Note that since many of the procedures are redundant with one another, they would not all necessarily be included in one particular audit program. For purposes of this problem you...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT