The following information is provided for Elli Dance Company as of June 30, 2012.

  1. Cash Balance per Elli Dance Company's account with First Bank of Baltimore: $8399 
  2. Deposits in transit: $2300
  3. Service charges levied by First Bank of Baltimore: $45 
  4. Cash Balance per Elli Dance Company's records: $9400 
  5. First Bank of Baltimore collected on a promissory note for Elli Dance in the amount of $400 plus $40 of interest. 
  6. Elli Dance Co.'s bookkeeper inadvertently recorded a check from customer, Danielle Johnson for $250. The amount of the check was $100.
  7. First Bank of Baltimore incorrectly processed a check for $27 from Elise Dance Supply Company against Elli Dance Company's account. 
  8. The following checks issued by Elli Dance Company were not yet cashed as of June 30, 2012:
    Ck # 1106 $588
    Ck # 1112 $493

Prepare a bank reconciliation.

Elli Dance Company
Bank Reconciliation
June 30, 2012
DescriptionAmount
Book Balance
Subcategory,Add:
Subcategory,Deduct:
Single line
Adjusted book balanceSingle line
DescriptionAmount
Bank Balance
Subcategory,Add:
Subcategory,Deduct:
Single line
Adjusted bank balanceSingle line