Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

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

Accounting for petty cash transactions

On June 1, Fab Salad Dressings creates a petty cash fund with an imprest balance of

\(300. During June, Al Franklin, the fund custodian, signs the following petty cash tickets:

Petty Cash

Ticket Number Item Amount

101 Office supplies \) 30

102 Cab fare for executive 20

103 Delivery of package across town 50

104 Business dinner 40

105 Merchandise inventory 90

On June 30, before replenishment, the fund contains these tickets plus cash of \(90.

The accounts affected by petty cash payments are Office Supplies, Travel Expense,

Delivery Expense, Entertainment Expense, and Merchandise Inventory.

Requirements

1. Explain the characteristics and the internal control features of an imprest fund.

2. On June 30, how much cash should the petty cash fund hold before it isreplenished?

3. Journalize all required entries to create the fund and replenish it. Includeexplanations.

4. Make the July 1 entry to increase the fund balance to \)375. Include an explanationand briefly describe what the custodian does.

Match the accounting terminology to the definitions.

1. Sarbanes-Oxley Act

2. Internal control

3. Encryption

4. Separation of duties

5. Internal auditors

a. Organizational plan and all the related measures adopted by an entity to safeguard assets,

encourage employees to follow company policies, promote operational efficiency, and ensure

accurate and reliable accounting records.

b. Employees of the business who ensure that the company’s employees are following company

policies and meeting legal requirements and that operations are running efficiently.

c. Rearranging plain-text messages by a mathematical process—the primary method of

achieving security in e-commerce.

d. Requires companies to review internal control and take responsibility for the accuracy and

completeness of their financial reports.

e. Dividing responsibilities between two or more people.

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?

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?

The following petty cash transactions of Green Golf Equipment occurred in May:

May 1 Established a petty cash fund with a \(200 balance.

31 The petty cash fund has \)18 in cash and \(180 in petty cash tickets that were issued to pay for Office Supplies(\)81), Delivery Expense (\(36), Postage Expense (\)54), and Miscellaneous Expense ($9).

The petty cash custodianreplenished the fund and recorded the expenses.

Prepare the journal entries.

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