The cash account for Brentwood Bike Co. at May 1 indicated a balance of $14,890. During May, the total cash deposited was $75,970 and checks written totaled $70,540. The bank statement indicated a balance of $25,750 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 $11,470. A deposit of $9,340, representing receipts of May 31, had been made too late to appear on the bank statement. The bank had collected for Brentwood Bike Co. $4,940 on a note left for collection. The face of the note was $4,560. A check for $360 returned with the statement had been incorrectly charged by the bank as $630. A check for $970 returned with the statement had been recorded by Brentwood Bike Co. as $790. The check was for the payment of an obligation to Adkins Co. on account. Bank service charges for May amounted to $50. A check for $1,140 from Jennings Co. was returned by the bank because of insufficient funds. Instructions: 1. Prepare a bank reconciliation as of May 31.
Bank Reconciliation and Entries
The cash account for Brentwood Bike Co. at May 1 indicated a balance of $14,890. During May, the total cash deposited was $75,970 and checks written totaled $70,540. The bank statement indicated a balance of $25,750 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 $11,470.
- A deposit of $9,340, representing receipts of May 31, had been made too late to appear on the bank statement.
- The bank had collected for Brentwood Bike Co. $4,940 on a note left for collection. The face of the note was $4,560.
- A check for $360 returned with the statement had been incorrectly charged by the bank as $630.
- A check for $970 returned with the statement had been recorded by Brentwood Bike Co. as $790. The check was for the payment of an obligation to Adkins Co. on account.
- Bank service charges for May amounted to $50.
- A check for $1,140 from Jennings Co. was returned by the bank because of insufficient funds.
Instructions:
1. Prepare a bank reconciliation as of May 31.
Brentwood Bike Co. | ||
Bank Reconciliation | ||
May 31 | ||
Cash balance according to bank statement | $fill in the blank 11a54af71fa5ff7_1 | |
$fill in the blank 11a54af71fa5ff7_3 | ||
fill in the blank 11a54af71fa5ff7_5 | fill in the blank 11a54af71fa5ff7_6 | |
$fill in the blank 11a54af71fa5ff7_7 | ||
fill in the blank 11a54af71fa5ff7_9 | ||
Adjusted balance | $fill in the blank 11a54af71fa5ff7_10 | |
Cash balance according to company's records | $fill in the blank 11a54af71fa5ff7_11 | |
fill in the blank 11a54af71fa5ff7_13 | ||
$fill in the blank 11a54af71fa5ff7_14 | ||
$fill in the blank 11a54af71fa5ff7_16 | ||
fill in the blank 11a54af71fa5ff7_18 | ||
fill in the blank 11a54af71fa5ff7_20 | fill in the blank 11a54af71fa5ff7_21 | |
Adjusted balance | $fill in the blank 11a54af71fa5ff7_22 |
2. Journalize the necessary entries (a.) that increase cash and (b.) that decrease cash. The accounts have not been closed. For a compound transaction, if an amount box does not require an entry, leave it blank.
a. May 31 | fill in the blank d99a3302d04c06f_2 | fill in the blank d99a3302d04c06f_3 | |
fill in the blank d99a3302d04c06f_5 | fill in the blank d99a3302d04c06f_6 | ||
fill in the blank d99a3302d04c06f_8 | fill in the blank d99a3302d04c06f_9 | ||
b. May 31 | fill in the blank d99a3302d04c06f_11 | fill in the blank d99a3302d04c06f_12 | |
fill in the blank d99a3302d04c06f_14 | fill in the blank d99a3302d04c06f_15 | ||
fill in the blank d99a3302d04c06f_17 | fill in the blank d99a3302d04c06f_18 | ||
fill in the blank d99a3302d04c06f_20 | fill in the blank d99a3302d04c06f_21 |
3. If a
$fill in the blank 7f9a6a03c078018_1
Trending now
This is a popular solution!
Step by step
Solved in 2 steps