The following data were accumulated for use in reconciling the bank account of Kaycee Sisters Inc. for August 20Y9:

A) Cash balance according to the company's records at August 31, $28,700.

B) Cash balance according to the bank statement at August 31, $30,180.

C) Checks outstanding, $5,830.

D) Deposit in transit, not recorded by bank, $4,680.

E) A check for $590 in payment of an account was erroneously recorded by Kaycee Sisters Inc. as $950.

F) Bank debit memo for service charges, $30.

Prepare a bank reconciliation, using the format shown in Exhibit 12.

Cash balance according to bank statement	_________________
Add bank service charge OR add desposit in transit, not recorded by bank OR add outstanding checks OR deduct bank service charges OR deduct deposit in transit, not recorded by bank
(total)
Add bank service charge OR add outstanding checks OR deduct bank service charge OR deducted deposit in transit, not recorded by bank OR deduct outstanding checks
Adjusted balance (grand total?)
Cash balance according to Kaycee Sisters Inc.
Add deposit in transit, not recorded by bank OR add error in reading check as $950 by company instead of $590 OR add outstanding checks OR deduct deposit in transit, not record by bank OR deduct error in reading check as $950 by company instead of $590
(total)
add bank service charge OR add deposit in transit, not recorded by bank OR add outstanding checks OR deduct bank service charges OR deduct outstanding checks
Adjusted balance

Prepare a bank reconciliation, using the format shown in Ex Kaycee Sisters Inc. Bank Reconciliation August 31, 20Y9 Cash balance according to bank statement $ Adjusted balance Cash balance according to Kaycee Sisters Inc. $ Adjusted balance