Question

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:

  1. The balance on the March 31 bank statement is $6,506.10.
  2. Not included on the bank statement is a $423 deposit made by Racine's late on March 31.
  3. 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
    No. 122 87.01
  4. The bank acts as a collection agency for checks returned for insufficient funds. The March bank statement indicates that one such check in the amount of $45.00 was collected and deposited and a collection fee of $15.61 was charged.
  5. Interest earned on the checking account and added to Racine's account during March was $4.30. Miscellaneous bank service charges amounted to $22.
  6. A comparison between the deposits listed on the bank statement and the company's books revealed that a customer's check in the amount of $1,250 appears on the bank statement in March but was never added to the customer's account on the company's books.
  7. The comparison of checks cleared per the bank statement with those per the books revealed that the wrong amount was charged to the company's account for a check. The amount of the check was $990. The proof machine encoded the check in the amount of $909, the amount charged against the company's account.

Required:

Enter all amounts rounded to the nearest cent.

1. Determine the balance on the books before any adjustments as well as the corrected balance to be reported on the balance sheet.

Racine Rentals
Bank Reconciliation
March 31
Balance per bank statement, March 31 $
Add: Deposit in transit
Deduct:
Outstanding checks:
No. 112 $
No. 117
No. 120
No. 122 $
Bank error
Adjusted balance, March 31 $
Balance per books, March 31 $
Add: Customer check collected $
Add: Interest earned on account
Add: Customer check not recorded
Deduct: Collection fee $
Deduct: Bank service charges
Adjusted balance, March 31 $

Homework Answers

Answer #1
Racine Rentals
Bank Reconciliation
March 31
Balance per bank statement, March 31 $ 6,506.10
Add: Deposit in transit 423.00
Deduct:
Outstanding checks:
No. 112 $ 42.92
No. 117 307.00
No. 120 10.58
No. 122 87.01 $ 447.51
Bank error 81 528.51
Adjusted balance, March 31 $ 6,400.59
Balance per books, March 31 $ 5,138.9
Add: Customer check collected $  45.00
Add: Interest earned on account 4.30
Add: Customer check not recorded 1,250.00
Deduct: Collection fee $ 15.61
Deduct: Bank service charges 22.00
Adjusted balance, March 31 $ 6,400.59

Amount to be shown in the Balance Sheet: $ 6,400.59

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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...
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...
Use the following information to prepare a bank reconciliation for Magee Company at August 31, 2016:...
Use the following information to prepare a bank reconciliation for Magee Company at August 31, 2016: (1) Cash account balance, $18,273.40. (2) Bank statement balance, August 31, $16,315.00. (3) Deposits in transit, $2,800.00. (4) Outstanding checks, August 31, $1,850.80. (5) Service charge on bank statement not recorded in books, $44.00. (6) Bank error—another company's check charged on Magee Company's bank statement, $245.20. (7) Check for repairs expense, $1,680.00, incorrectly recorded in books as $960.00. (a) Prepare the bank reconciliation. (b)...
Bank Reconciliation Use the following information to prepare a bank reconciliation for Young Company at June...
Bank Reconciliation Use the following information to prepare a bank reconciliation for Young Company at June 30: 1 Balance per Cash account, June 30. $14,111.60 2 Balance per bank statement, June 30. 14,600.50 3 Deposits not reflected on bank statement. 1,450 4 Outstanding checks, June 30. 2,520.90 5 Service charge on bank statement not recorded in books. 22.0 6 Error by bank-Yertel Company check charged on Young Company's bank statement. 1,100 7 Check for advertising expense 500 incorrectly recorded in...
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...
Problem 6-4A Preparing a bank reconciliation and recording adjustments LO P3 [The following information applies to...
Problem 6-4A Preparing a bank reconciliation and recording adjustments LO P3 [The following information applies to the questions displayed below.] The following information is available to reconcile Branch Company’s book balance of cash with its bank statement cash balance as of July 31, 2017.    On July 31, the company’s Cash account has a $25,754 debit balance, but its July bank statement shows a $27,438 cash balance. Check No. 3031 for $1,260 and Check No. 3040 for $622 were outstanding...
Bank Reconciliation An accounting clerk for Chesner Co. prepared the following bank reconciliation: Chesner Co. Bank...
Bank Reconciliation An accounting clerk for Chesner Co. prepared the following bank reconciliation: Chesner Co. Bank Reconciliation July 31, 20Y4 Cash balance according to company's records $6,170 Adjustments:    Outstanding checks $2,960    Error by Chesner Co. in recording Check      No. 1056 as $710 instead of $170 540    Note for $9,700 collected by bank, including interest 10,090    Deposit in transit on July 31 (6,280)    Bank service charges (30)       Total adjustments 7,280 Cash balance according to bank statement $13,450 a. From the data...
Bank Reconciliation An accounting clerk for Chesner Co. prepared the following bank reconciliation: Chesner Co. Bank...
Bank Reconciliation An accounting clerk for Chesner Co. prepared the following bank reconciliation: Chesner Co. Bank Reconciliation July 31, 20Y4 Cash balance according to company's records $7,620 Adjustments:    Outstanding checks $3,660    Error by Chesner Co. in recording Check      No. 1056 as $830 instead of $380 450    Note for $12,000 collected by bank, including interest 12,480    Deposit in transit on July 31 (7,760)    Bank service charges (30)       Total adjustments 8,800 Cash balance according to bank statement $16,420 a. From the data...
Prepare Bank reconciliation report and journalize the necessary adjustments as of March 31st, 2017 for Company...
Prepare Bank reconciliation report and journalize the necessary adjustments as of March 31st, 2017 for Company “R”; its bank statement for March shows the following data:                                 Balance 3/1                              $15,650                            Balance 3/31                                $17,580 Debit memorandum:                                                         Credit memorandum:          NSF check                           $275                                    Collection of note receivable    $605 The cash balance per books at March 31st is $16,319. Other relevant data are given below: The NSF check was from a customer, The note collected by the bank was a $600, 3 month,...
The accountant of BWS Company has compiled the following information for preparing a bank reconciliation for...
The accountant of BWS Company has compiled the following information for preparing a bank reconciliation for the company as of September 31, 2019: - A deposit of $9,366 on September 31 does not appear in the bank statement. - As of September 31, cash per the bank statement is $41,631. - Among the paid checks accompanied in the bank statement is the Check No: 113 for $1,512 which is paid by the bank erroneously although this check is not written...