Question

In: Accounting

Preparing a bank reconciliation

Question 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.

Expert Solution

Step 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.

Step 2: 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:

Deposit in transit $100 Bank Collection $510

$3,440 Interest Revenue $20

$3,070

Less: Less:

Outstanding Checks $400 Service Charge $30

Adjusted bank balance, December 31, 2018 $3,040 Adjusted cash balance December 31, 2018 $3,040

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

Sahil Dangi answered 2 years ago

Items on a Bank Reconciliation Assume that a company is preparing a bank reconciliation for the...

Items on a Bank Reconciliation Assume that a company is preparing a bank reconciliation for the month of June. It reconciles the bank balance and the book balance to the correct balance. For each of the following items, indicate whether the item is an addition to the bank balance, an addition to the book balance, a deduction from the bank balance, a deduction from the book balance, or would not appear on the June reconciliation. Also, choose Yes or No...

Bank Reconciliation The following information is available to assist you in preparing a bank reconciliation for...

Bank Reconciliation The following information is available to assist you in preparing a bank reconciliation for Calico Corners on May 31: The balance on the May 31 bank statement is $8,432.11. Not included on the bank statement is a $1,250 deposit made by Calico Corners late on May 31. A comparison between the canceled checks returned with the bank statement and the company records indicated that the following checks are outstanding at May 31: No. 123 $23.40 No. 127 145.00...

what is a bank reconciliation? what are the steps in preparing a bank reconciliation? what purpose...

what is a bank reconciliation? what are the steps in preparing a bank reconciliation? what purpose does it serve?

Preparing a bank Reconciliation Statement: •The July 31 bank statement for Parkview Company indicated a cash...

Preparing a bank Reconciliation Statement: •The July 31 bank statement for Parkview Company indicated a cash balance of $5,000.17. •The cash ledger account on that date shows a balance of $4,262.83. •Four outstanding checks totaled $717.75. •A $410.90 deposit made after banking hours on July 31 does not appear in the bank statement. •On July 30, the bank returned J.B. Ball’s NSF check for $50.25, received as payment of an account receivable. •The bank statement showed $24.74 interest earned on...

Briefly explain the importance of preparing Bank Reconciliation Statement and analyze the adjustments and the treatment...

Briefly explain the importance of preparing Bank Reconciliation Statement and analyze the adjustments and the treatment of the adjustments that needs to be considered under bank statement and cash book statement. You can access online resources to get the required information while maintaining APA referencing guidance [ 5 marks] [ minimum 500 words].

James Thomas is responsible for preparing bank reconciliation statements for Ajax Inc. Ajax has many bank...

James Thomas is responsible for preparing bank reconciliation statements for Ajax Inc. Ajax has many bank accounts, including separate accounts for each major branch, accounts for payments of salaries and dividends, and accounts kept in foreign currency for overseas divisions. James maintains records including bank statements and weekly bank reconciliations for each account. In addition, there are files containing correspondence with banks about disputed transactions, dishonored checks from Ajax's customers, and other bank-initiated transactions such as fees and interest. a....

While preparing the bank reconciliation, an accountant with Elliter noticed that an error had been made...

While preparing the bank reconciliation, an accountant with Elliter noticed that an error had been made in recording a deposit received by the company. The receipt had been recorded by the company as $729 yet the correct amount of the deposit on the bank statement was $279. Which of the following reconciling adjustments is necessary? 1. Deduct $450 from the bank statement balance 2. Add $450 to the bank statement balance 3. Add $450 to the company's records 4. Deduct...

Preparing Bank reconciliation & any journal entries; The following information is for Neopolitan Ltd in July...

Preparing Bank reconciliation & any journal entries; The following information is for Neopolitan Ltd in July 1.Cash balance per bank, July 31, $10,670 2. Cash balance per general ledger cash account, July 31, $8,953 3. Bank Service Charge, $40 4. Deposits in Transit, $1,968 5. Electronic receipts from customers in payment of their accounts, $1,276, not previously recorded by the company 6. Outstanding cheques, $2,359 7. Cheque #373 was correctly written in the amount of $890 but was incorrectly recorded...

Nose Mask Ltd (Nose Mask) is preparing his bank reconciliation at 31st May 2019. His bank...

Nose Mask Ltd (Nose Mask) is preparing his bank reconciliation at 31st May 2019. His bank statement balance failed to agree with the cash book balance. His bank statement shows a balance of GH₵684 cash at the bank. After investigation the following were revealed; a. The following cheques have not yet been presented at the bank. These are: Cheque No. GH₵ 956784........1,875 956892........978 958452.........1,407 958541.........366 958668..........261 Total Amount = 4,887 b. Cheque number 958602 was incorrectly recorded in Nose Mask's...

1. Kreiger Corporation developed the following reconciling information in preparing its July bank reconciliation: Bank balance...

1. Kreiger Corporation developed the following reconciling information in preparing its July bank reconciliation: Bank balance before reconciliation $23,000 Note receivable collected by bank 7,500 Outstanding checks 15,000 Deposits in transit 8,000 Bank service charge 100 NSF check 1,800 Determine the cash balance per books (before adjustments) for Kreiger. 2. Kendall Corporation had a 1/1/19 balance in the Allowance for Doubtful Accounts of $18,000. During 2019, it wrote off $11,500 of accounts and collected...