Please solve and answer

The following information is available for the Tiemey Company for the month of November On November 30, afler all transactions have been recorded, the balance in the cornpany's Cash account has a balance of $28,802 . The company's bank statement shows a balance on November 30 of $31,279 . Outstanding checks at November 30 include check #3030 in the amount of $1,925 and check #3556 in the amount of $1,619 Included with the bank statement was a credit memo in the amount of $930 for an EFT in payment of a customer's account. The bank deducted $147 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,915 and did not appear on he 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,770, but was recorded in the accounting records as $2,940 Included with the bank statement was a debit memcrandum in the amount of $105 for bank service charges. Required: Prepare a bank reconciliation for Tierney Company as of Navember 30 Company Bank Reconciliation At November 30 Updates to Bank Statement Updates to Company's Books Ending Cash Balance per Bank Statement Ending Cash Balance per Books Additions: Additions: Deductions: Deductions Up-to-date ending cash balance Up-to-date ending cash balance