The cash account for Deaver Consulting at October 31, 20Y6, indicated a balance of $15,750. The bank statement indicated a balance of $31,095 on October 31, 20Y6. Comparing the bank statement and the accompanying canceled checks and memos with the records revealed the following reconciling items:

1. Checks outstanding totaled $10,125.
2. A deposit of $4,120, representing receipts from October 31, had been made too late to appear on the bank statement.
3. The bank had collected $10,400 on a note left for collection. The face of the note was $10,000.
4. A check for $1,200 returned with the statement had been incorrectly recorded by Deaver Consulting as $120. The check was for the payment of an obligation to Oxford Office Supplies Co. for the purchase of office supplies on account.
5. A check drawn for $320 had been incorrectly charged by the bank as $230.
6. Bank service charges for October amounted to $70.

Instructions:

1. Prepare a bank reconciliation.

2. Illustrate the effects on the accounts and financial statements of the bank reconciliation. If no account or activity is affected, select "No effect" from the dropdown and leave the corresponding number entry box blank. Enter account decreases and cash outflows as negative amounts.

Increase in Cash:

Decrease in Cash