The bank reconciliation prepared by Winfield Construction on June $30,2023,$ appeared as follows:

Winfield Construction

Bank Reconciliation

June $30,2023$

Bank statement balance $ $8,700$ Book balance $ $9,260$

Add:

Deposit of June $30$ in transit $1,300$

$ $10,000$

Deduct:

Outstanding cheque #$14740$

Adjusted bank balance $ $9,260$ Adjusted book balance $ $9,260$

The Cash account in the General Ledger appeared as follows on July $31$:

Cash Acct. No$.101$

Date Explanation PR Debit Credit Balance

$2023$

June $30$ Balance $9,260$

July $31$ CR$34,67213,932$

$31$ CD$62,90911,023$

A list of deposits made and cheques written during July, taken from the Cash Receipts Journal and Cash Disbursements Journal, is shown below:

Deposits Made

July $8$ $ $1,190$

$111,550$

$241,339$

$31593$

Total July Cash Receipts $ $4,672$

Cheques Written

No$.52$ $ $1,663$

$53894$

$54352$

Total July Cash Disbursements $ $2,909$

The following bank statement is available for July:

Bank Statement

To: Winfield Construction July $31,2023$

Bank of Montreal

Cheques$/$Charges Deposits$/$Credits Balance

$8,700$

NSF $07/0243107/021,3009,569$

#$5207/081,66307/081,1909,096$

#$9607/1139107/111,55010,255$

$07/241,33911,594$

#$5407/3135207/3111,242$

NSF $=$ Not Sufficient Funds SC $=$ Service Charge PMT $=$ Principal Payment INT $=$ Interest

In reviewing cheques returned by the bank, the bookkeeper noted that cheque #$96$ written by Winburn Construction in the amount of $$391$ was charged against Winfield$$s account in error by the bank. The NSF cheque was regarding a customer account, Jim Anderson.

Required:

$1.$ Prepare a bank reconciliation at July $31.$