CC5-1 Part 2 2. Nicole has asked you to prepare a bank reconciliation for NGS. According to her records, NGS's cash balance is $7,800 December 31, but the bank reports a balance of $7,300. a. The bank deducted $450 for an NSF check from a customer deposited on December 22. b. NGS has written checks totaling $5,300 that have not yet cleared the bank. C. The bank added $40 cash to the account for interest earned in December. d. NGS made a $5,170 deposit on December 31, which will be recorded by the bank in January. e. The bank deducted $40 for service charges. f. NGS wrote a check to a supplier on account for $200 but mistakenly recorded it as $20. NICOLE'S GETAWAY SPA Bank Reconciliation At December 31 Company's Books Ending Balance per Cash Account Bank Statement Ending Balance per Bank Statement Additions: Additions: Deductions: Deductions: Up-to-Date Cash Balance Up-to-Date Cash Balance