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

What is a 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

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.

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

Controlling petty cash Just Hangin’ Night Club maintains an imprest petty cash fund of \(150, which is under the control of Sandra Morgan. At March 31, the fund holds \)14 cash and petty cash tickets for office supplies, \(128, and delivery expense, \)15.

Requirements

1. Explain how an imprest petty cash system works.

2. Journalize the establishment of the petty cash fund on March 1 and the replenishing of the fund on March 31.

3. Prepare a T-account for Petty Cash and post to the account. What is the balance of the Petty Cash account at all times?

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