Question
Bank Reconciliation and Entries The cash account for Coastal Bike Co. at October 1, 20Y9, indicated a balance of $13,640. During October, the total cash
Bank Reconciliation and Entries
The cash account for Coastal Bike Co. at October 1, 20Y9, indicated a balance of $13,640. During October, the total cash deposited was $69,320 and checks written totaled $64,360. The bank statement indicated a balance of $23,500 on October 31, 20Y9. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items:
- Checks outstanding totaled $10,470.
- A deposit of $8,530, representing receipts of October 31 had been made too late to appear on the bank statement.
- The bank had collected for Coastal Bike Co. $4,510 on a note left for collection. The face of the note was $4,160.
- A check for $580 returned with the statement had been incorrectly charged by the bank as $850.
- A check for $970 returned with the statement had been recorded by Coastal Bike Co. as $790. The check was for the payment of an obligation to Rack Pro Co. on account.
- Bank service charges for October amounted to $60.
- A check for $1,040 from Bay View Condos was returned by the bank due to insufficient funds.
Instructions:
1. Prepare a bank reconciliation as of October 31, 20Y9.
Coastal Bike Co. | ||
Bank Reconciliation | ||
October 31, 20Y9 | ||
Cash balance according to bank statement | $fill in the blank 6758d8fedfc107c_1 | |
Adjustments: | ||
$fill in the blank 6758d8fedfc107c_3 | ||
fill in the blank 6758d8fedfc107c_5 | ||
fill in the blank 6758d8fedfc107c_7 | ||
Total adjustments | fill in the blank 6758d8fedfc107c_8 | |
Adjusted balance | $fill in the blank 6758d8fedfc107c_9 | |
Cash balance according to company's records | $fill in the blank 6758d8fedfc107c_10 | |
Adjustments: | ||
$fill in the blank 6758d8fedfc107c_12 | ||
fill in the blank 6758d8fedfc107c_14 | ||
fill in the blank 6758d8fedfc107c_16 | ||
fill in the blank 6758d8fedfc107c_18 | ||
Total adjustments | fill in the blank 6758d8fedfc107c_19 | |
Adjusted balance | $fill in the blank 6758d8fedfc107c_20 |
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. 20Y9 Oct. 31 | fill in the blank 6e61f7079fedff0_2 | fill in the blank 6e61f7079fedff0_3 | |
fill in the blank 6e61f7079fedff0_5 | fill in the blank 6e61f7079fedff0_6 | ||
fill in the blank 6e61f7079fedff0_8 | fill in the blank 6e61f7079fedff0_9 | ||
b. Oct. 31 | fill in the blank 6e61f7079fedff0_11 | fill in the blank 6e61f7079fedff0_12 | |
fill in the blank 6e61f7079fedff0_14 | fill in the blank 6e61f7079fedff0_15 | ||
fill in the blank 6e61f7079fedff0_17 | fill in the blank 6e61f7079fedff0_18 | ||
fill in the blank 6e61f7079fedff0_20 | fill in the blank 6e61f7079fedff0_21 |
3. If a balance sheet were prepared for Coastal Bike Co. on October 31, 20Y9, what amount should be reported as cash? $fill in the blank 5808c9fa7f83074_1
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started