Can anyone help me with this problem?

Please prepare a bank reconciliation and journal entries with same format. (Excel format would be great for me!)

The name of transaction is included so please use same accounting terms as they were used in the problem. Thank you!

3. McDermott Company's bank statement for September 30 showed an ending cash balance of $1,462. The company's cash account in its general ledger showed a $1,115 debit balance The following information was also available as of September 30 The bank deducted $165 for an NSF check from a customer deposited on September 15. The September 30 cash receipts, $1,330, were placed in the bank's night depository after banking hours on that date and this amount did not appear on the September 30 bank statement. A $23 debit memorandum for checks printed by the bank was included with the canceled checks. Outstanding checks amounted to S1,265. Included with the bank statement was a credit memo in the amount of $915 for an EFT in payment of a customer's account. Included with the canceled checks was a check for S315, drawn on the account of another company