/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Q28PSA Preparing a bank reconciliation ... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

Preparing a bank reconciliation and journal entries

The August 31 bank statement of Well Healthcare has just arrived from United Bank.

To prepare the bank reconciliation, you gather the following data:

a. The August 31 bank balance is \(4,540.

b. The bank statement includes two charges for NSF checks from customers. One is

for \)380 (#1), and the other is for \(180 (#2).

c. The following Well Healthcare checks are outstanding at August 31:

Check No. Amount

237 \) 80

288 190

291 570

294 600

295 30

296 70

d. Well collects from a few customers by EFT. The August bank statement lists a

\(1,200 EFT deposit for a collection on account.

e. The bank statement includes two special deposits that Well hasn’t recorded yet:

\)800 for dividend revenue, and \(120 for the interest revenue Well earned on its

bank balance during August.

f. The bank statement lists a \)50 subtraction for the bank service charge.

g. On August 31, the Well treasurer deposited \(260, but this deposit does not appear

on the bank statement.

h. The bank statement includes a \)1,050 deduction for a check drawn by Multi-State

Freight Company. Well notified the bank of this bank error.

i. Well’s Cash account shows a balance of $2,800 on August 31.

Requirements

1. Prepare the bank reconciliation for Well Healthcare at August 31, 2018.

2. Journalize any required entries from the bank reconciliation. Include anexplanation for each entry.

Short Answer

Expert verified

The adjusted balance of the bank reconciliation statement is $4,310.

Step by step solution

01

Definition of bank reconciliation statement

The bank reconciliation statement is the statement prepared to remove the errors of bank balance and cash book balance.

02

Bank reconciliation statement

Well Healthcare
Bank Reconciliation Statement
August 31, 2018
Bank Side
Book Side

Particulars

Amount

Particulars

Amount

Balance as per bank

$4,540

Balance as per cash book

$2,800

Add:

Add:

Outstanding Deposits

$260

Dividend Revenue

$800

Bank Error

$1,050

Interest Revenue

$120

EFT Collection

$1,200

Deductions:

Deductions:

Outstanding Checks

$1,540

NSF Cheque

$560

Service Charge

$50

Adjusted Balance on August 31

$4,310

Adjusted Balance on August 31

$4,310

In the bank reconciliation statement, the opening balance as per bank and cashbook is $4,540 and $2,800. You add the outstanding deposit and deduct the outstanding checks to find the adjusted balance on the bank side. You add rent receipts and note collection to the book balance on the book side. After this, you deduct the NSF check, incorrect recording of the check, EFT payment, and service charge. After making these adjustments on both sides, you got the adjusted balance of $4,310.

03

Journal Entries

Date

Particulars

Debit

Credit

August 31

Cash

$800

Dividend Revenue

$800

(To record the dividend revenue)

August 31

Cash

$120

Interest Revenue

$120

(To record the interest revenue)

August 31

Accounts Receivable

$560

Cash

$560

(To record NSF Check)

August 31

Cash

$1,600

Accounts Receivable

$1,600

(To record the receipt of account receivable)

August 31

Bank Charges

$50

Cash

$50

(To record the payment of bank charges)

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91Ó°ÊÓ!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Conduct an Internet search for information on internal control and the Sarbanes-Oxley Act. Write a report of your findings. In your account, discuss some of the advantages and disadvantages of the Sarbanes-Oxley Act. Present it to your class (if required by your instructor).

Preparing a bank reconciliation and journal entries

This problem continues the Crystal Clear Cleaning problem begun in Chapter 2 and

continued through Chapter 6.

In March 2019, Crystal Clear Cleaning opened a new checking account at First

Regional Bank. The bank statement dated March 31, 2019, for Crystal Clear

Cleaning follows:

Beginning Balance, March 1, 2019

Deposits and other credits:

Mar. 2

10

18

20

23 EFT Peg’s Restaurant(1)

(1) Peg’s Restaurant is a customer making a payment on account.

(3) Texas Energy is a utility provider.

(2) Check Art is a company that prints business checks (considered a

bank expense) for Crystal Clear Cleaning.

\(33,000

900

19,000

50,000

350

Checks and other debits:

Mar. 2 EFT to Check Art(2)

Ending balance, March 31, 2019

\) 0

31 Interest Revenue 50

5 Ck#235

9 Ck#237

9 Ck#236

26 Ck#239

10

2,400

1,500

2,900

2,000

28 EFT to Texas Energy(3) 130

29 Ck#240 300

31 Bank service charge 25

103,300

(9,265)

$ 94,035

Crystal Clear Cleaning’s Cash account in the general ledger shows the following

transactions for March:

Cash—First Regional Bank Checking Account

Balance

Deposit

Deposit

Deposit

Deposit

2,400

2,900

1,500

400

2,000

94,870

Mar. 2

10

18

20

31 Deposit

33,000

900

19,000

50,000

1,770

Mar. 2

4

5

10

21

Ck#235

Ck#236

Ck#237

Ck#238

Ck#239

300

300

23

29

Ck#240

Ck#241

Balance

Requirements

1. Prepare the bank reconciliation at March 31, 2019.

2. Journalize any required entries from the bank reconciliation. Post to the CashT-account to verify the balance of the account matches the adjusted book balancefrom the bank reconciliation.

Question: For each of the following items, determine whether the item would be:

a. added to the bank balance

b. subtracted from the bank balance

c. added to the book balance

d. subtracted from the book balance

11. Interest revenue earned

12. NSF check

13. Deposit in transit

14. Service charge

15. Outstanding check

Preparing a bank reconciliation and journal entries

This problem continues the Canyon Canoe Company situation from Chapter 6.

Canyon Canoe Company has decided to open a new checking account at River

Nations Bank during March 2019. Canyon Canoe Company’s March Cash T-account

for the new cash account from its general ledger is as follows:

Cash—River Nations Bank Checking Account

Balance

Deposit

Deposit

Deposit

Deposit

200

4,300

750

1,675

1,500

14,165

Mar. 1

2

13

20

27

Deposit

10,000

2,325

2,750

4,500

31 3,490

Mar. 2

4

9

14

21

Ck#101

Ck#102

Ck#103

Ck#104

Ck#105

175

300

28

30

Ck#106

Ck#107

Balance

Canyon Canoe Company’s bank statement dated March 31, 2019, follows:

Beginning Balance, March 1, 2019

Deposits and other credits:

Mar. 2

14

21

28

29 EFT Sport Shirts(1)

(1) Sport Shirts is a customer making a payment on account.

(2) Bank Checks is a company that prints business checks (considered

a bank expense) for Canyon Canoe Company

\(10,000

2,325

2,750

4,500

500

Checks and other debits:

Mar. 2 EFT to Bank Checks(2)

Ending balance, March 31, 2019

\) 0

31 Interest Revenue 45

3 Ck#101

6 Ck#102

15 Ck#104

16 Ck#103

55

200

4,300

1,675

750

28 EFT to Rivers Energy(3) 270

29 Ck#106 175

31 Bank service charge 70

20,120

(7,495)

$ 12,625

(3) Rivers Energy is a utility provider.

Requirements

1. Prepare the bank reconciliation at March 31, 2019.

2. Journalize any transactions required from the bank reconciliation.

3. Compute the adjusted account balance for the Cash T-account, and denote thebalance as End. Bal. Does the adjusted balance of the Cash T-account match theadjusted book balance on the bank reconciliation?

The Scott Sun & Shade Company had the following financial data at December 31, 2018:

Cash and cash equivalents $ 60,000

Total current liabilities 75,000

What is the cash ratio as of December 31, 2018, for Scott Sun & Shade?

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.