7-4 HELP

The cash account for Coastal Bike Co. at October 1, 20Y9, indicated a balance of $30,356. During October, the total cash deposited was $141,640, and checks written totaled $137,652. The bank statement indicated a balance of $43,000 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,515.
b.	A deposit of $1,779 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,775 on a note left for collection. The face of the note was $5,500.
d.	A check for $470 returned with the statement had been incorrectly charged by the bank as $740.
e.	A check for $310 returned with the statement had been recorded by Coastal Bike Co. as $130. The check was for the payment of an obligation to Rack Pro Co. on account.
f.	Bank service charges for October amounted to $29.
g.	A check for $1,376 from Bay View Condos was returned by the bank due to insufficient funds.

	Required:
1.	Prepare a bank reconciliation as of October 31, 20Y9.
2.	Journalize the necessary entries.
3.	If a balance sheet were prepared for Coastal Bike Co. on October 31, 20Y9, what amount should be reported as cash?

PR 7-4A Algo eBook Show Me How Bank reconciliation and entries Instructions Chart of Accounts Labels and Amount Descriptions ! Bank Reconciliation ! General Journal ! Final Question \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{4}{|c|}{ Bank Reconciliation } & \multirow{3}{*}{ Shaded cells have feedback. X} \\ \hline & \multicolumn{3}{|l|}{ October 31,20Y9} & \\ \hline 1 & Cash balance according to bank statement & & $43,000.00 & \\ \hline 2 & Add: Deposit in transit on October 31 & $1,779.00 & & \\ \hline 3 & Add: Error in recording check & 270.00v & & \\ \hline 4 & Outstanding checks & & 45,049.00 & \\ \hline 5 & Deduct: Adjusted balance & & 6,515.00 & \\ \hline 6 & Cash balance according to company record & & $38,534.00v & \\ \hline 7 & & & & \\ \hline 8 & Cash balance according to company's records & & $34,344.00 & \\ \hline 9 & Add: Note collected by bank, including \$275 interest & & 5,775.00 & \\ \hline 10 & Deduct: Check returned because of insufficient funds & $1,376.00 & & \\ \hline 11 & Deduct: Bank service charges & 29.00 & & \\ \hline 12 & Deduct: Error in recording check & 180.00 & & \\ \hline 13 & Adjusted balance & & 1,585.00 & \\ \hline 14 & & & $38,534.00 & \\ \hline \end{tabular}