he 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,402. The company's bank statement shows a balance on November 30 of $30,779. Outstanding checks at November 30 include check #3030 in the amount of $1,825 and check W3556 in the amount of $1,579. . Included with the bank statement was a credit memo in the amount of $890 for an EFT in payment of a customer's account. . The bank deducted $127 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,855 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,690, but was recorded in the accounting records as $2,840. . Included with the bank statement was a debit memorandum in the amount of $85 for bank service charges Required: Prepare a bank reconciliation for Tiemey Company as of November 30. Tierney Company Bank Reconciliation At November 30 Updates to Comp 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 Book Air