Prepare the bank reconciliation and prepare the journal entries need to reconcile cash.

The cash account for ABC at December 31 indicated a balance of $23,702. The bank statement indicated a balance of $20,994 on December 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items.

a. Checks outstanding totaled $5,659

b. A deposit of $7,652, representing receipts of December 31, had been made too late to spear on the bank statement

c. A direct deposit of $57 was made to the companys bank account for a refund of excess fees that the bank had previously withdrew.

d. A check for $253 returned with the statement had been incorrectly charged by the bank as $325

e. A check for $412 returned with the statement had been recorded by XYZ as $142. The check was for the payment of an obligation to EFG Co on account.

f. Bank service charges for June amounted to $5

g. A check for $375 from a customer was returned by the bank due to insufficient funds