Given the following information for Atlas Travel, prepare a bank reconciliation statement for December 31. Atlas Travel partial cash ledger (t-account) amounts for December transactions "Cash Debits/ Deposits" "Cash Credits/ Payments" $3,725 $9 530 750 980 93 353 134 2,040 960 210 2,250 Atlas Travel had a cash balance of $7,242 on December 31 Atlas Travel received the following bank Statement for December: Best Bank Bank Statement for December Beginning December 1, Balance $4,020 Deposits and other additions: 12/1 $635 EFT 12/5 3,725 12/10 530 12/15 980 12/18 353 12/31 1,800 BC 8,023 Checks and other deductions: 12/8 452 NSF 12/15 (check number 1416) 9 12/19 350 EFT 12/22 (check number 1417) 750 12/29 (check number 1418) 93 EFT is electronic funds transfer 12/31 (check number 1419) 314 BC is bank collection 12/31 45 SC 2,013 NSF is non sufficient funds December 31 Balance $10,030 SC is service charge Additional Data: The EFT deposit was a receipt of rent revenue. The EFT deduction was payment of insurance expense. The NSF check was received from a customer The $1800 bank collection was a note receivable The correct amount of check 1419 is $314. Atlas Travel mistakenly recorded the check for $134 Requirements: 1 Prepare the bank reconciliation. Atlas Travel Bank Reconciliation December 31, 20## Best Bank Balance, Dec. 31 Atlas Travel Balance Dec 31
