1.
BCD Associates | ||
Bank Reconciliation | ||
June 30, xxxx | ||
Balance per bank statement | 3070 | |
Add: Deposits in transit | 2400 | |
5470 | ||
Less: Outstanding checks | ||
Check no. 104 | 500 | |
Check no. 105 | 900 | 1400 |
Adjusted balance $ | 4070 | |
Balance per books | 4185 | |
Add: | ||
EFT collection of note by bank | 1000 | |
Interest credited by bank | 15 | 1015 |
5200 | ||
Less: | ||
Error in recording check no. 101 ($3100 - $3010) | 90 | |
EFT for rent | 330 | |
NSF check | 700 | |
Bank service charges | 10 | 1130 |
Adjusted balance $ | 4070 |
2.
Date | General Journal | Debit | Credit |
June 30, xxxx | Cash | 1000 | |
Notes receivable | 1000 | ||
(To record EFT collection of note by bank) | |||
June 30, xxxx | Cash | 15 | |
Interest revenue | 15 | ||
(To record interest credited by bank) | |||
June 30, xxxx | Utilities expense | 90 | |
Cash | 90 | ||
(To rectify error in recording check no. 101) | |||
June 30, xxxx | Rent expense | 330 | |
Cash | 330 | ||
(To record EFT for rent) | |||
June 30, xxxx | Accounts receivable | 700 | |
Cash | 700 | ||
(To record NSF check) | |||
June 30, xxxx | Miscellaneous expense | 10 | |
Cash | 10 | ||
(To record bank service charges) |
3.
Cash | |||
Jun. 30 bal. | 4185 | ||
Jun. 30 adj. | 1015 | 1130 | Jun. 30 adj. |
Total | 5200 | 1130 | |
Jun. 30 adj. bal. | 4070 |
Note: A combined entry has been shown posted to the cash account for all debit adjustments and credit adjustments.
Check No. The Cash account of BCD Associates at June 30, xxxx: Cash Beg. Bal 400...
fill out excel at the bottom
The June bank statement and the cash T-account for Superior Printing, Inc., is A The June bank statement and the cash T-account for Superior Printing, Inc., is shown below. BANK STATEMENT Deposits Other Checks Date June 1 10,000 440 1,200 500 1,200 250 80 9,800 350 4,600 700 920 NSF 840 Balance 18,500 18,060 16,860 16,360 15,160 24,910 23,990 49,190 48,840 44,240 60,540 59,570 59,000 35,000 17,000 600 Serv. Charge Interest Earned Cash June...
Bentley Company’s June 30 bank statement and June ledger account
for cash are summarized below:BANK STATEMENTChecksDepositsBalanceBalance, June 1$6,500Deposits during June$16,20022,700Checks cleared during June$16,6006,100Bank service charges406,060Balance, June 306,060Cash (A)June 1 Balance6,500 June Checks written19,000June Deposits18,100Required:1. Reconcile the bank account. A comparison of
the checks written with the checks that have cleared the bank shows
outstanding checks of $2,400. A deposit of $1,900 is in transit at
the end of June.2. Prepare the journal entry that should be
made as a result of...
Superior Printing, Inc. has provided you with its bank statement and Cash T-Account for the month of June. The Controller has asked you to prepare the Bank Reconciliation for the month of June. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=B11" was entered, the...
Preparing Bank Reconciliation and Entries and Reporting Cash Bentley Company's June 30 bank statement and June ledger account for cash are summarized below: E6-27 LO6-4 BANK STATEMENT Checks Deposits Balance $16.200 Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 $16,600 40 $ 6,500 22.700 6.100 6,060 6,060 Cash (A) 6,500 June 18,100 Checks written 19,000 June ! Balance June Deposits Required: 1. Reconcile the bank account. A comparison of the checks written...
Required information [The following information applies to the questions displayed below.) Hills Company's June 30 bank statement and the June ledger account for cash are summarized here: BANK STATEMENT Checks Deposits Other $18,500 Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 Balance $ 7,300 25, 800 6, 200 6,169 6, 169 $19, 600 $31 June 1 June Balance Deposits Cash (A) 7, 300 20,000 19,900 Checks written 7, 400 June June 30...
[The following information applies to the questions displayed below.] Hills Company’s June 30 bank statement and the June ledger account for cash are summarized here: BANK STATEMENT Checks Deposits Other Balance Balance, June 1 $ 7,200 Deposits during June $ 18,000 25,200 Checks cleared during June $ 19,100 6,100 Bank service charges $ 30 6,070 Balance, June 30 6,070 Cash (A) June 1 Balance 6,800 June Deposits 19,000 19,400 Checks written June June 30 Balance 6,400 Required: Prepare a bank...
Hills Company's June 30 bank statement and the June ledger account for cash are summarized here: BANK STATEMENT Checks Deposits Other Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 $17,800 $18,990 Balance $ 7,160 24,960 6,060 6,030 6,030 $30 Cash (A) June 1 June Balance Deposits Balance 7,160 18,600 6,560 19,200 Checks written June June 30 3. What is the balance in the Cash account after the reconciliation entries? Cash Balance 4....
Required information [The following information applies to the questions displayed below.) Hills Company's June 30 bank statement and the June ledger account for cash are summarized here: BANK STATEMENT Checks Deposits Other $17, 800 Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 Balance $ 7, 160 24, 960 6,060 6,030 6, 030 $18,900 $30 June 1 June Balance Bala Deposits Cash (A) 7,160 18,600 19,200 Checks written 6,560 June June 30 Balance...
Required information [The following information applies to the questions displayed below.) Hills Company's June 30 bank statement and the June ledger account for cash are summarized here: BANK STATEMENT Checks Deposits $17,200 Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 Other Balance $ 7,040 24, 240 5,940 $30 5,910 5,910 $18,300 June 1 June Balance Deposits Balance Cash (A) 7,040 17,400 18,600 5,840 Checks written June June 30 Required: 1. Prepare a...
Required information [The following information applies to the questions displayed below) Hills Company's June 30 bank statement and the June ledger account for cash are summarized here: BANK STATEMENT Checks Deposits $17,800 Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 $18,900 Other Balance $ 7,160 24,960 6,060 $30 6,038 6,830 June 1 June June 30 Balance Deposits Balance Cash (A) 7,160 18,600 19,200 Checks written 6,560 June Required: 1. Prepare a bank...