Question

The cash account for Coastal Bike Co. at October 1, 20Y9, indicated a balance of $32,527. During October, the total cash deposited was $139,121, and checks written totaled $135,890. The bank statement indicated a balance of $43,660 on October 31, 20Y9. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items:

a.	Checks outstanding totaled $6,625.
b.	A deposit of $1,888 representing receipts of October 31, had been made too late to appear on the bank statement.
c.	The bank had collected for Coastal Bike Co. $5,250 on a note left for collection. The face of the note was $5,000.
d.	A check for $260 returned with the statement had been incorrectly charged by the bank as $620.
e.	A check for $410 returned with the statement had been recorded by Coastal Bike Co. as $140. The check was for the payment of an obligation to Rack Pro Co. on account.
f.	Bank service charges for October amounted to $37.
g.	A check for $1,418 from Bay View Condos was returned by the bank due to insufficient funds.

	Instructions
1.	Prepare a bank reconciliation as of October 31, 20Y9. Refer to the Amount Descriptions list provided for the exact wording of the answer choices for text entries. "Add:" & "Deduct:" will automatically appear if it is required. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
2.	Journalize the necessary entries. Refer to the Chart of Accounts for exact wording of account titles.
3.	If a balance sheet were prepared for Coastal Bike Co. on October 31, 20Y9, what amount should be reported as cash?

Prepare a bank reconciliation as of October 31, 20Y9. Refer to the Amount Descriptions list provided for the exact wording of the answer choices for text entries. "Add:" & "Deduct:" will automatically appear if it is required. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

Coastal Bike Co.

Bank Reconciliation

October 31, 20Y9

1	Cash balance according to bank statement
2
3
4
5
6
7
8	Cash balance according to company’s records
9
10
11
12
13
14

Journalize the necessary entries. Refer to the Chart of Accounts for exact wording of account titles.

PAGE 1

JOURNAL

ACCOUNTING EQUATION

	DATE	DESCRIPTION	POST. REF.	DEBIT	CREDIT	ASSETS	LIABILITIES	EQUITY
1
2
3
4
5
6
7

If a balance sheet were prepared for Coastal Bike Co. on October 31, 20Y9, what amount should be reported as cash? _______________

Answer 1

If a balance sheet were prepared for Coastal Bike Co. on October 31, 20Y9, amount that should be reported as cash $39283

Coastal Bike Co. Bank Reconciliation October 31, 2049 Cash balance according to bank statement Add:Deposit in transit Bank error (620 - 260 ) 35758 1888 360 43660 Cash balance according to company's records Add:Note Receivable Interest Income 2248 5000 250 5250 41008 45908 Deduction : Outstanding checks 6625 37 1418 Deduction Service Charges NSF 6625 Correction of error ( 410 - 140) 39283 Adjusted Cash Balance 270 1725 Adjusted Cash Balance 39283 Journal Enteries Trans. Particulars 1 Cash Note Receivable Interest Income Debit in $ Credit in 5250 5000 250 2 37 Miscellaneous Expense Accounts Receivable Accounts Payable Cash 1418 270 1725