please prepare a bank reconciliation

Nicole has asked you to prepare a bank reconciliation for NGS. According to her records, NGS's cash balance is $7400 at December 31, but the bank reports a balance of $6, 900. The bank deducted $410 for an NSF check from a customer deposited on December 22. NGS has written checks totaling $4, 900 that have not yet cleared the bank. The bank added $20 cash to the account for interest earned in December NGS made a $4, 720 deposit on December 31, which will be recorded by the bank in January. The bank deducted $20 for service charges NGS wrote a check to a supplier on account for $300 but mistakenly recorded it as $30