Question

Bank Reconciliation A bank reconciliation explains the causes for any differences between a company's cash balance...

Bank Reconciliation

A bank reconciliation explains the causes for any differences between a company's cash balance on its bank statement and its cash balance on the books (that is, in the ledger. )

Allez Company's monthly bank statement shows an account balance of $6127.23. The cash balance in its ledger is $5301.05.

A thorough bank reconciliation investigation yields the following information:

The bank erroneously deducted $346.70 from the company's account when the actual amount of a check written by the company was $326.70.
The company erroneously recorded a check it wrote for $468.19 as $671.41.
The company recently made a $633.64 deposit that has not yet been reflected on the bank statement.
The bank collected a $490.00 note receivable, plus $13.00 in interest, which has not been recorded in the company's records.
Bank service charges of $11.00 have been assessed to the company's account.
There are two checks outstanding (not yet appearing on the bank statement) that were written for $812.61 and $458.87.
A $486.88 check from one of the company's customers, Phil Conners, was returned by the bank because of insufficient funds (NSF) in the customer's account.

Prepare the bank reconciliation for Allez Co. Enter amounts to the nearest cent.

Allez Co.
Bank Reconciliation
January 31, 2014
Cash balance per bank statement $
Add: Deposit not recorded by bank (deposit in transit) $
Add: Bank error in charging check
$
Deduct: Outstanding checks
Adjusted balance $
Cash balance per company records $
Add: Proceeds of note collected by bank, including interest $
Add: Error in recording check
$
Deduct: Check returned for insufficient funds $   
Deduct: Bank service charge
Adjusted balance $   
Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1
Allez Co.
Bank Reconciliation
31-Jan-14
Cash balance per bank statement $6,127.23
Add: Deposit not recorded by bank (deposit in transit) $633.64
Add: Bank error in charging check $20.00
$653.64
Deduct: Outstanding checks ($1,271.48)
Adjusted balance $5,509.39
Cash balance per company records $5,301.05
Add: Proceeds of note collected by bank, including interest $503.00
Add: Error in recording check $203.22
$706.22
Deduct: Check returned for insufficient funds ($486.88)
Deduct: Bank service charge ($11.00)
($497.88)
Adjusted balance $5,509.39
0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers...
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: Cash balance according to the company's records at July 31 $28,850. Cash balance according to the bank statement at July 31, $30,060. Checks outstanding, $5,860. Deposit in transit, not recorded by bank, $4,700. A check for $340 in payment of an account was erroneously recorded in the check register as $430. Bank debit memo for service charges, $40. a. Prepare a...
Bank reconciliation Prepare a bank reconciliation as of October 31 from the following information: a. The...
Bank reconciliation Prepare a bank reconciliation as of October 31 from the following information: a. The October 31 cash balance in the general ledger is $1,688. b. The October 31 balance shown on the bank statement is $746. c. Checks issued but not returned with the bank statement were No. 462 for $26 and No. 483 for $100. d. A deposit made late on October 31 for $900 is included in the general ledger balance but not in the bank...
Bank Reconciliation and Entries The cash account for American Medical Co. at April 30 indicated a...
Bank Reconciliation and Entries The cash account for American Medical Co. at April 30 indicated a balance of $14,395. The bank statement indicated a balance of $16,430 on April 30. Comparing the bank statement and the accompanying canceled checks and memos with the records revealed the following reconciling items: Checks outstanding totaled $5,910. A deposit of $6,160, representing receipts of April 30, had been made too late to appear on the bank statement. The bank collected $3,200 on a $3,040...
The Concept of Bank Reconciliation is to compare the company's book balance (balance shown in the...
The Concept of Bank Reconciliation is to compare the company's book balance (balance shown in the Cash Account) with the Bank Statement balance. Imagine a business carrying $500,000 balance in the books but the bank only shows $300,000. Will the bank pay the business $200,000 difference? Hence, Bank Reconciliation is an Internal Control measure assuring the books is recorded correctly. Do you have a bank account? Think about your own account. Banks generally have a cut-off time of 3PM but...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $12,770....
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $12,770. During May, the total cash deposited was $64,320 and checks written totaled $59,720. The bank statement indicated a balance of $21,800 on May 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $9,710. A deposit of $7,910, representing receipts of May 31, had been made too late to appear on the bank...
The following data were accumulated for use in reconciling the bank account of Mathers Co. for...
The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: Cash balance according to the company's records at July 31 $18,170. Cash balance according to the bank statement at July 31, $19,230. Checks outstanding, $3,690. Deposit in transit, not recorded by bank, $2,960. A check for $590 in payment of an account was erroneously recorded in the check register as $950. Bank debit memo for service charges, $30. a. Prepare a bank reconciliation,...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $13,110. During May, the total cash deposited was $65,030 and checks written totaled $60,380. The bank statement indicated a balance of $22,050 on May 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $9,820. A deposit of $8,000, representing receipts of May 31, had been made too late...
The following information is available to assist you in preparing a bank reconciliation for Racine Rentals...
The following information is available to assist you in preparing a bank reconciliation for Racine Rentals on March 31: The balance on the March 31 bank statement is $6,506.10. Not included on the bank statement is a $423 deposit made by Racine's late on March 31. A comparison between the canceled checks listed on the bank statement and the company records indicated that the following checks are outstanding at March 31: No. 112 $42.92 No. 117 307.00 No. 120 10.58...
An accounting clerk for Chesner Co. prepared the following bank reconciliation: Chesner Co. Bank Reconciliation August...
An accounting clerk for Chesner Co. prepared the following bank reconciliation: Chesner Co. Bank Reconciliation August 31 Cash balance according to company's records $6,340 Add: Outstanding checks $3,040   Error by Chesner Co. in recording Check     No. 1056 as $820 instead of $280 540   Note for $10,000 collected by bank, including interest 10,400 13,980 $20,320 Deduct: Deposit in transit on August 31 $6,450       Bank service charges 50 6,500 Cash balance according to bank statement $13,820 a. From the data in this...
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers...
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: Cash balance according to the company's records at July 31 $17,880. Cash balance according to the bank statement at July 31, $19,100. Checks outstanding, $3,630. Deposit in transit, not recorded by bank, $2,910. A check for $170 in payment of an account was erroneously recorded in the check register as $710. Bank debit memo for service charges, $40. a. Prepare a...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT