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
Add: Add:
Less: Less:
Adjusted bank balance Adjusted company balance
2 Prepare the two journal entries.
Journal
Date Accounts Post. Ref Debit Credit
Dec. 31
Dec. 31
