Preparing a bank reconciliation

The Cash account of Guard Dog Security Systems reported a balance of \(2,540 at December 31, 2018. There were outstanding checks totaling \)400 and a December 31 deposit in transit of \(100. The bank statement, which came from Park Cities Bank, listed the December 31 balance of \)3,340. Included in the bank balance was a collection of \(510 on account from Brendan Ballou, a Guard Dog customer who pays the bank directly. The bank statement also shows a \)30 service charge and $20 of interest revenue that Guard Dog earned on its bank balance. Prepare Guard Dog’s bank reconciliation for December 31.

Short Answer

Expert verified

The ending balance of the bank reconciliation statement is $3,040.

Step by step solution

01

Step-by-Step SolutionStep 1: Definition of the bank reconciliation statement

A bank reconciliation statement is a statement that is prepared to remove the difference in the balance of cash balance and bank balance.

02

Bank reconciliation statement

In the bank reconciliation statement, there are two sides one is the bank, and the second is the book side. On the bankside, the opening balance of the bank account is entered. After this, the amount of deposit transit is added to the bank balance, and the number of outstanding checks is deducted.

The second side of the bank reconciliation statement is started with the opening balance of the company’s book. After this, the amount of bank collection and interest revenue is added to the balance, and the amount of service charge is deducted from the book side balance.

Guard Dog Security Systems
Bank Reconciliation Statement
December 31, 2018
Bank
Book

Balance, December 31, 2018

$3,340

Balance, December 31, 2018

$2,540

Add:

Add:

  1. Deposit in transit

$100

  1. Bank Collection

$510

$3,440

  1. Interest Revenue

$20

$3,070

Less:

Less:

  1. Outstanding Checks

$400

  1. Service Charge

$30

Adjusted bank balance, December 31, 2018

$3,040

Adjusted cash balance December 31, 2018

$3,040

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

Study anywhere. Anytime. Across all devices.

Sign-up for free