Final answer:
To prepare Queen City's bank reconciliation, deduct outstanding checks and add deposit in transit to the company's balance. Deduct collection paid directly to the bank and add any service charges or interest revenue. Compare adjusted balance with the bank balance to reconcile any differences.
Step-by-step explanation:
To prepare Queen City's bank reconciliation at December 31, we need to adjust the Cash account balance reported by the company to match the balance reported by the bank. First, we deduct the outstanding checks totaling $1,200 from the company's balance. Next, we add the deposit in transit of $400 to the company's balance. Now, let's consider the bank statement. We deduct the collection of $580 from Kelly Brooks, as this was paid directly to the bank. We also deduct the $20 service charge and add the $10 interest revenue earned by Queen City. Finally, we compare the adjusted company's balance with the bank balance to reconcile any differences.