Preparing a bank reconciliation and journal entries

The December cash records of Davidson Insurance follow:


Davidson’s Cash account shows a balance of \(17,450 at December 31. On December

31, Davidson Insurance received the following bank statement:

Additional data for the bank reconciliation follow:

a. The EFT credit was a receipt of rent. The EFT debit was an insurance payment.

b. The NSF check was received from a customer.

c. The \)1,400 bank collection was for a note receivable.

d. The correct amount of check no. 1419, for rent expense, is \(1,930. Davidson’s

controller mistakenly recorded the check for \)1,390.

Requirements

1. Prepare the bank reconciliation of Davidson Insurance at December 31, 2018.

2. Journalize any required entries from the bank reconciliation.

Short Answer

Expert verified

The adjusted balance of the bank reconciliation statement is $18,025.

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

Davidson Insurance
Bank Reconciliation Statement
December 31
Bank Side
Book Side

Particulars

Amount

Particulars

Amount

Balance as per bank

$18,955

Balance as per cash book

$17,450

Add:

Add:

Outstanding Deposits

$1,860

Rent Receipts

$350

Note Collection

$1,400

Deductions:

Deductions:

Outstanding Checks

$2,790

NSF Cheque

$400

Incorrect recording of check

$540

EFT Payment

$225

Service Charge

$10

Adjusted Balance on December 31

$18,025

Adjusted Balance on December 31

$18,025

In the bank reconciliation statement, the opening balance as per bank and cashbook is $18,955 and $17,450. 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 $18,025.

03

Journal Entries

Date

Particulars

Debit

Credit

December 31

Cash

$350

Rent Revenue

$350

(To record the rent revenue)

December 31

Cash

$1,400

Notes Receivable

$1,400

(To record the receipt on notes receivable)

December 31

Accounts Receivable

$400

Cash

$400

(To record NSF Check)

December 31

Rent Expense

$540

Cash

$540

(To record the payment of the rent)

December 31

Accounts Payable

$225

Cash

$225

(To record the payment of accounts payable)

December 31

Misc. Expense

$25

Cash

$25

(To record the payment of misc. expense)

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

Preparing a bank reconciliation and journal entries

The May cash records of Donald Insurance follow:

Cash Receipts Cash Payments

Date Cash Debit Check No. Cash Credit

May 4 \( 4,230 1416 \) 890

9 520 1417 120

14 530 1418 630

17 1,950 1419 1,090

31 1,840 1420 1,420

1421 900

1422 670

Donald’s Cash account shows a balance of \(17,750 at May 31. On May 31, Donald

Insurance received the following bank statement:

Deposits and other Credits:

May 10

May 1

May 5

May 15

May 18

May 22

Checks and other Debits:

8

11 (check no. 1416)

19

22 (check no. 1417)

29 (check no. 1418)

31 (check no. 1419)

May

May

May

May

May

May

May 31

Ending Balance

Beginning Balance

EFT \) 450

NSF

EFT

BC

\( 18,730

1,700

890

1,100

120

520

4,230

530

1,950

\) 14,400

9,380

375

630

1,900

35 (5,050)

Bank Statement for May

SC

Explanations: BC–bank collection; EFT–electronic funds transfer;

NSF–nonsufficient funds checks; SC–service charge

Additional data for the bank reconciliation follow:

a. The EFT credit was a receipt of rent. The EFT debit was an insurance

payment.

b. The NSF check was received from a customer.

c. The \(1,700 bank collection was for a note receivable.

d. The correct amount of check 1419, for rent expense, is \)1,900. Donald’s controller

mistakenly recorded the check for $1,090.

Requirements

1. Prepare the bank reconciliation of Donald Insurance at May 31, 2018.

2. Journalize any required entries from the bank reconciliation

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.

List internal control procedures related to e-commerce.

When are the only times the Petty Cash account is used in a journal entry?

Identifying internal controls. Consider each situation separately. Identify the missing internal control procedure from these characteristics:

• Assignment of responsibilities

• Separation of duties

• Audits

• Electronic devices

• Other controls (specify)

a. While reviewing the records of Quality Pharmacy, you find that the same Team member orders merchandise and approves invoices for payment.

b. Business is slow at Amazing Amusement Park on Tuesday, Wednesday, and Thursday nights. To reduce expenses, the business decides not to use a ticket taker on those nights. The ticket seller (cashier) is told to keep the tickets as a record of the number sold.

c. The same trusted team member has served as a cashier for 12 years.

d. When business is brisk, Fast Mart deposits cash in the bank several times during the day. The manager at one store wants to reduce the time employees spend delivering cash to the bank, so he starts a new policy. Cash will build up over weekends, and the total will be deposited on Monday.

e. Grocery stores such as Convenience Market and Natural Foods purchase most merchandise from a few suppliers. At another grocery store, the manager decides to reduce paperwork. He eliminates the requirement that the receiving department prepare a receiving report listing the goods actually received from

the supplier.

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