E5-5 Preparing a Bank Reconciliation and Journal Entries and Reporting Cash [LO 5-4]
[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:

E5-5 Part 1
Required:
1. Prepare a bank reconciliation. A comparison of the checks written with the checks that have cleared the bank shows outstanding checks of $300. Some of the checks that cleared in June were written prior to June. No deposits in transit were noted in May, but a deposit is in transit at the end of June.

E5-5 Part 3
3. What is the balance in the Cash account after the reconciliation entries?
E5-5 Part 4
4. In addition to the balance in its bank account, Hills Company also has $100 of petty cash on hand. This amount is recorded in a separate T-account called Petty Cash on Hand. What is the total amount of cash that should be reported on the balance sheet at June 30?
Solution 1:
| Hills company | |||||
| Bank Reconciliation | |||||
| Jun-30 | |||||
| Bank statement | company's books | ||||
| Ending balance per bank | $5,771 | Ending balance per cash account | $5,600 | ||
| Additions: | Additions: | ||||
| Add: Deposits in Transit (17000-16900) | 100 | ||||
| $100 | $0 | ||||
| $5,871 | $5,600 | ||||
| Deductions: | Deductions: | ||||
| Less: Outstanding checks | 300 | Less: Service charge | 29 | ||
| $300 | $29 | ||||
| Upto date cash balance | $5,571 | upto date cash balance | $5,571 | ||
Solution 3:
Cash balance = $5,571
Solution 4:
Total amount of cash = $5571 + $100 = $5,671
E5-5 Preparing a Bank Reconciliation and Journal Entries and Reporting Cash [LO 5-4]
E6-27 (Algo) Preparing Bank Reconciliation and Entries and Reporting Cash L06-4 Bentley Company's June 30 bank statement and June ledger account for cash are summarized below: BANK STATEMENT Checks $15.700 Balance, June 1 Deposits during June Checks cleared during June Bank service charges Balance, June 30 $16,650 Balance $ 7.600 23,300 6,650 6,611 6,611 39 orang June 1 Balance June Deposits pelance Cash(A) 7,600 June Cheeks written 18,100 ana Chucks written 19,50|| Required: 1. Reconcile the bank account. A comparison...
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...
Hills Company’s June 30 bank statementHills Company's June 30 bank statement and the June ledger account for cash are summarized here: Required: 1. Prepare a bank reconciliation. A comparison of the checks written with the checks that have cleared the bank shows outstanding checks of $300. Some of the checks that cleared in June were written prior to June. No depo in transit were noted in May, but a deposit is in transit at the end of June. 2. Prepare any journal entries...
Required information E5-6 Preparing a Bank Reconciliation and Journal Entries and Reporting Cash [LO 5-4] [The following information applies to the questions displayed below.] The September 30 bank statement for Cadieux Company and the September ledger account for cash are summarized here: BANK STATEMENT Checks Deposits Other Balance Balance, September 1 $ 1,980 September 7 NSF check $ 90 1,890 September 11 $ 2,970 4,860 September 12 #101 $ 790 4,070 September 17 #102 1,680 2,390 September 26 #103 2,290...
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 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...
PA5-3 Identifying Outstanding Checks and Deposits in Transit and Preparing a Bank Reconciliation and Journal Entries [LO 5-4, LO 5-5] [The following information applies to the questions displayed below.] The December bank statement and cash T-account for Stewart Company follow: There were no deposits in transit or outstanding checks at November 30. PA5-3 Part 3 3. Prepare a bank reconciliation for December. PA5-3 Part 4 4. Prepare any journal entries that the company should make as a result of the bank reconciliation. (If no entry is required...
E6-28 (Algo) Preparing Bank Reconciliation and Entries and Reporting Cash L06-4 The September 30 bank statement for Bennett Company and the September ledger account for cash are summarized here. BANK STATEMENT Checks Balance, September 1 Deposits recorded during September Checks cleared during September $26,900 NSF checks-Betty Brown Bank service charges Balance, September 30 $26.550 180 Cash (A) Sept. Checks written Sept. 1 Balance Sept. Deposits 7,300 28,850 No outstanding checks and no deposits in transit were carried over from August,...
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...
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....