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.

Short Answer

Expert verified

The adjusted balance of the bank reconciliation statement is $95,105.

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

Crystal Clear Cleaning
Bank Reconciliation Statement
March 31, 2019
Bank Side
Book Side

Particulars

Amount

Particulars

Amount

Balance as per bank

$94,035

Balance as per cash book

$94,870

Add:

Add:

Outstanding Deposits

$1,770

Interest Revenue

$50

EFT Collection

$350

Deductions:

Deductions:

Outstanding Checks

$700

Utility Expense

$130

Bank Expense

$10

Service Charge

$25

Adjusted Balance on October 31

$95,105

Adjusted Balance on October 31

$95,105

In the bank reconciliation statement, the opening balance as per bank and cashbook is $94,035 and $94,870. 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 $95,105.

03

Journal Entries

Date

Particulars

Debit

Credit

March 31

Cash

$50

Interest Revenue

$50

(To record the interest revenue)

March 31

Bank Expense

$10

Cash

$10

(To record NSF Check)

March 31

Cash

$350

Accounts Receivable

$350

(To record the receipt of account receivable)

March 31

Bank Charges

$25

Cash

$25

(To record the payment of bank charges)

March 31

Utilities Expense

$130

Cash

$130

The first and the second entry is passed to interest revenue.

The third entry is passed on record as the bank expense

The fourth entry is given on recording the collection accounts receivable.

The fifth entry is passed on recording the payment of bank charges.

04

Cash T-account

Cash

Opening Balance

$94,870

Utilities Expense

$130

Interest Revenue

$50

Bank expense

$10

Account Receivable

$350

Service Charges

$25

Adjusted Balance of Cash

$95,10

Hence, the adjusted balance of the book side of the bank reconciliation statement is equal to the adjusted balance of the cash t-account.

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 Vaia!

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

Question: Understanding bank account controls

Answer the following questions about the controls in bank accounts:

Requirements

1. Which bank control protects against forgery?

2. Which bank control reports the activity in the customer’s account each period?

3. Which bank control confirms the amount of money put into the bank account?

In 100 words or fewer, explain why there may be a difference between the bank statement ending cash balance and the ending balance in the Cash account. Give at least two examples of adjustments to the bank balance and the book balance.

Classifying bank reconciliation items

The following items could appear on a bank reconciliation:

a. Outstanding checks, \(670.

b. Deposits in transit, \)1,500.

c. NSF check from customer, no. 548, for \(175.

d. Bank collection of note receivable of \)800, and interest of \(80.

e. Interest earned on bank balance, \)20.

f. Service charge, \(10.

g. The business credited Cash for \)200. The correct amount was \(2,000.

h. The bank incorrectly decreased the business’s account by \)350 for a check written

by another business.

Classify each item as (1) an addition to the book balance, (2) a subtraction from the

book balance, (3) an addition to the bank balance, or (4) a subtraction from the bank

balance.

Using Excel for a Bank Reconciliation

Download an Excel template for this problem online in MyAccountingLab or athttp://www.pearsonhighered.com/Horngren.

Lori Anders of Wilderness Associates is getting ready to prepare the October bank reconciliation.

The cash balance on the books of Wilderness Associates on October 31 is \(3,546.

Lori reviews the bank statement, and notes the checking account balance at October 31 is \)2,445. The bank statement also

reveals that the bank collected a note receivable on behalf of Wilderness Associates—the principal was \(1,500 and the interest

was \)15. One customer’s check for \(29 was returned by the bank for insufficient funds. Two additional items on the bank statement

were the monthly EFT for the utilities, \)250, and the bank service fee of \(12. Lori notes that the cash deposit made on

October 31 of \)3,300 does not appear on the statement, and that three checks totaling $975 had not cleared the bank account

when the bank statement was prepared.

Requirements

1. Prepare the bank reconciliation for Wilderness Associates at October 31, 2018. Format appropriate cells with dollar signs and double

underlines. Use Excel formulas to calculate subtotals and totals.

2. Journalize the entries based on the bank reconciliation. For dollar amounts, use cell references on bank reconciliation

Levon Helm was a kind of one-person mortgage broker. He would drive around Tennessee looking for homes that had second mortgages, and if the criteria were favorable, he would offer to buy the second mortgage for “cash on the barrelhead.” Helm bought low and sold high, making sizable profits. Being a small operation, he employed one person, Cindy Patterson, who did all his bookkeeping. Patterson was an old family friend, and he trusted her so implicitly that he never checked up on the ledgers or the bank reconciliations. At some point, Patterson started “borrowing” from the business and concealing her transactions by booking phony expenses. She intended to pay it back someday, but she got used to the extra cash and couldn’t stop. By the time the scam was discovered, she had drained the company of funds that it owed to many of its creditors. The company went bankrupt, Patterson did some jail time, and Helm lost everything

Requirements

  1. What was the key control weakness in this case?
  2. Many small businesses cannot afford to hire enough people for adequate separation of duties. What can they do to compensate for this?
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.

Sign-up for free