The following information is available for the Tierney Company for the month of November . On November 30, after all transactions have been recorded, the balance in the company's Cash account has a balance of $28,202 The company's bank statement shows a balance on November 30 of $30,529. Outstanding checks at November 30 include check #3030 in the amount of $1,775 and check #3556 in the amount of $1,559. Included with the bank statement was a credit memo in the amount of $870 for an EFT in payment of a customer's account. The bank deducted $117 for an NSF check from a customer deposited on November 22. A deposit placed in the bank's night depository on November 30 totaled $1,825 and did not appear on the bank statement. Examination of the checks on the bank statement with the entries in the accounting records reveals that check #3445 for the payment of an account payable was correctly written for $2,650, but was recorded in the accounting records as $2,790. included with the bank statement was a debit memorandum in the amount of $75 for bank service charges. Required: Prepare a bank reconciliation for Tierney Company as of November 30. Tierney Company Bank Reconciliation At November 30 Updates to Company's Books Ending Cash Balance per Books Additions: Updates to Bank Statement Ending Cash Balance per Bank Statement Additions: Deductions: Deductions: Up-to-date ending cash balance Up-to-date ending cash balance