Using the following information, prepare a bank reconciliation for Tequila Mockingbird Mexican bar and grill for August 31, 2014:

(a) The bank statement balance is $4,690

(b) The cash account balance is $5,080.

(c) Outstanding checks amounted to $715.

(d) Deposits in transit are $1,020.

(e) The bank service charge is $40.

(f) A check for $72 for supplies was recorded as $27 in the ledger.