Harrison Company maintains a checking account at the First National City Bank. The bank provides a bank statement along with can
celed checks on the last day of each month. The July 2016 bank statement included the following information:
Balance, July 1, 2016 $ 57,053
Deposits 180,600
Checks processed (193,710 )
Service charges (30 )
NSF checks (1,750 )
Monthly loan payment deducted directly by bank from account
(includes $970 in interest) (3,870 )
Balance, July 31, 2016 $
38,293
The company’s general ledger account had a balance of $40,293 at the end of July. Deposits outstanding totaled $7,400 and all checks written by the company were processed by the bank except for those totaling $8,530. In addition, a $3,100 July deposit from a credit customer was recorded as a $310 debit to cash and credit to accounts receivable, and a check correctly recorded by the company as a $30 disbursement was incorrectly processed by the bank as a $300 disbursement.
Required:
1.Prepare a bank reconciliation for the month of July
2.Prepare the necessary journal entries at the end of July to adjust the general ledger cash account. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field).
Balance, July 1, 2016 $ 57,053
Deposits 180,600
Checks processed (193,710 )
Service charges (30 )
NSF checks (1,750 )
Monthly loan payment deducted directly by bank from account
(includes $970 in interest) (3,870 )
Balance, July 31, 2016 $
38,293
The company’s general ledger account had a balance of $40,293 at the end of July. Deposits outstanding totaled $7,400 and all checks written by the company were processed by the bank except for those totaling $8,530. In addition, a $3,100 July deposit from a credit customer was recorded as a $310 debit to cash and credit to accounts receivable, and a check correctly recorded by the company as a $30 disbursement was incorrectly processed by the bank as a $300 disbursement.
Required:
1.Prepare a bank reconciliation for the month of July
2.Prepare the necessary journal entries at the end of July to adjust the general ledger cash account. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field).
1 answer:
Answer:
Harrison company
Step 1.
Preparation of adjusted Cash Book
Balance as at July 31, 2016 = $40,293
Add: bal. of Deposit by credit customer = ($3,100 - $310) = $2,790
Deduct: Bank Service charge = -$30
Deduct: NSF checks = -$1,750
Deduct: loan repayment plus interest = -$3,870
Adjusted Balance =$37,433
Step 2. Bank reconciliation statement
As at 31st July 2016
Balance as per Bank Statement = $38,293
Deduct: uncleared Cheques = -$8,530
Add: Deposits outstanding = $7,400
Add: over disbursement by bank due for recovery = $270
Adjusted Bank Statement = $37,433
Compared to Adjusted Cash Book = $37,433
Difference = $0.
Step 3.
Journal entries required
Debit Cash Account with $2,790
Credit Account Receivables with $2,790
(Under recorded Customer deposit on sales)
Debit NSF expense = $1,750
Debit Loan Account with $2,900
Debit interest on Loan Account with $970
Debit Bank Charges expense a account with $30
Credit Cash Account with $5,650
(Direct debits to bank account on sundry transactions)
Explanation:
A bank reconciliation statement is presented to reconcile a 3rd party (Bank) statement of our Account and the Account maintained by the business in house.
The objective of the Bank reconciliation statement includes:
1. Identify the missing entries in either records
2. Flag the corrections the Bank needs to do to bring our balance to a correct state
3. Pass Journals to capture entries we have missed out or captured incorrectly
4. Identify unassigned entries for investigation
You might be interested in