The balance in Happ Incorporateds general ledger Cash account was $12,870 at August 31, before reconciliation. The August 31 balance shown in the bank statement was $11,530. Reconciling items included deposits in transit, $1,240; bank service charges, $90; NSF check written by a customer and returned with the bank statement, $490; outstanding checks, $420; and interest credited to the account during September but not recorded on the companys books, $60.

Required:

1. Show the reconciling items in a horizontal model that should be prepared to reflect the reconciling items for Happ Incorporated at August 31.
2. What is the amount of cash to be included in the August 31 balance sheet for the companys bank account?