Answer and Explanation:
The preparation of bank reconciliation is shown below:-
Cash balance according to bank statement $8,000
Add deposits in transit not recorded by bank $500
Total $8,500
Less: outstanding checks $2,200
Adjusted balance $6,300
Cash balance according to depositor's records $3,675
Add: Note collected by bank, including $50 interest $2,850
Error in recording cash sales of $342 as $324 $18
Total $6,543
Less: NSF check from Alice Bell $218
Bank service charges $25
Adjusted balance $6,300