Question
upstudy study bank question image url

The bank statement for ABC Company as of June 30,2015 indicated balance br. 9143.11. The accounting records of the Company indicate the following data: Cash balance as of June 1,201.5. \( \qquad \) Br. 3943.50 Total cash reciept for June. \( \qquad \) 28971.60 Total amount of check paid. \( \qquad \) 28388.85 Comparision of the bank statement and the accompanying canceled checks and memorandums with the records revealed the following reconciling items: 1. Cheeks outstanding, br. 5265.27 2. A deposit in transit was br: 1852.21 3. The bank had collected for the company br, 1030 on an interset-bearing note left for collection. The face of the nofe was br, 1000. 4. A cheque written for br. 139 returred with the statement had been ineorrectly charged by bonk as br. 157 , 5. A check for br. 30 had been recurded erroneously recorded as br. 240 by company, The cheek was for the payment of account payable. 6. Bank service charges for June amounted to br. 18.20 Required: Task 2.1 Prepare bank reconcilation for the month of June 2015. Task 2.2 Record the necessary journal entries.

Ask by Campbell Bernard. in Ethiopia
Jan 24,2025

Real Tutor Solution

Tutor-Verified Answer

Answer

**Bank Reconciliation for June 2015** **Adjusted Bank Balance:** - Bank Statement Balance: Br. 9,143.11 - Add: Deposit in Transit: Br. 1,852.21 - Less: Outstanding Checks: Br. 5,265.27 - Add: Collection of Note: Br. 1,030.00 - **Total:** Br. 5,730.05 **Adjusted Cash Book Balance:** - Book Balance: Br. 4,526.25 - Add: Collection of Note: Br. 1,030.00 - Add: Correction of Recording Error: Br. 210.00 - Less: Overcharge on Returned Check: Br. 18.00 - Less: Bank Service Charges: Br. 18.20 - **Total:** Br. 5,730.05 **Journal Entries:** 1. **Collection of Note:** - Dr. Cash: Br. 1,030.00 - Cr. Notes Receivable: Br. 1,000.00 - Cr. Interest Income: Br. 30.00 2. **Correction of Overcharge:** - Dr. Accounts Payable: Br. 18.00 - Cr. Cash: Br. 18.00 3. **Correction of Recording Error:** - Dr. Cash: Br. 210.00 - Cr. Accounts Payable: Br. 210.00 4. **Bank Service Charges:** - Dr. Bank Service Charges Expense: Br. 18.20 - Cr. Cash: Br. 18.20

Solution

### **Task 2.1: Prepare Bank Reconciliation for June 2015** **ABC Company** **Bank Reconciliation as of June 30, 2015** --- **1. Adjusted Bank Balance** | **Description** | **Amount (Br.)** | |-----------------------------|------------------| | **Balance as per Bank Statement** | 9,143.11 | | **Add:** Deposit in Transit | 1,852.21 | | **Less:** Outstanding Checks | (5,265.27) | | **Add:** Collection of Note (Item 3)| 1,030.00 | | **Adjusted Bank Balance** | **5,730.05** | --- **2. Adjusted Cash Book Balance** | **Description** | **Amount (Br.)** | |---------------------------------------------|------------------| | **Balance as per Books** | 4,526.25 | | **Add:** Collection of Note (Item 3) | 1,030.00 | | **Add:** Correction of Recording Error (Item 5)| 210.00 | | **Less:** Overcharge on Returned Check (Item 4)| (18.00) | | **Less:** Bank Service Charges (Item 6) | (18.20) | | **Adjusted Cash Book Balance** | **5,730.05** | --- **_Both Adjusted Balances Match at Br. 5,730.05_** --- ### **Task 2.2: Record the Necessary Journal Entries** Based on the reconciling items identified, the following journal entries are required: --- **1. Collection of Interest-Bearing Note by Bank (Item 3)** *The bank collected Br. 1,030 on behalf of the company, which includes Br. 1,000 for the note and Br. 30 for interest.* ```plaintext Dr. Cash 1,030.00 Cr. Notes Receivable 1,000.00 Cr. Interest Income 30.00 ``` --- **2. Correction of Overcharge on Returned Check (Item 4)** *The bank incorrectly charged Br. 157 instead of Br. 139 for a returned check, resulting in an overcharge of Br. 18.* ```plaintext Dr. Accounts Payable 18.00 Cr. Cash 18.00 ``` --- **3. Correction of Recording Error for Check Payment (Item 5)** *The company erroneously recorded a check of Br. 30 as Br. 240, overstating the cash payment by Br. 210.* ```plaintext Dr. Cash 210.00 Cr. Accounts Payable 210.00 ``` --- **4. Recording of Bank Service Charges (Item 6)** *Bank service charges for June amounted to Br. 18.20.* ```plaintext Dr. Bank Service Charges Expense 18.20 Cr. Cash 18.20 ``` --- ### **Summary of Journal Entries** | **Date** | **Account Title** | **Debit (Br.)** | **Credit (Br.)** | |---------------|-------------------------------------|------------------|-------------------| | June 30, 2015 | Cash | 1,030.00 | | | | Notes Receivable | | 1,000.00 | | | Interest Income | | 30.00 | | June 30, 2015 | Accounts Payable | 18.00 | | | | Cash | | 18.00 | | June 30, 2015 | Cash | 210.00 | | | | Accounts Payable | | 210.00 | | June 30, 2015 | Bank Service Charges Expense | 18.20 | | | | Cash | | 18.20 | --- These journal entries ensure that the company's accounting records accurately reflect all transactions and adjustments identified during the bank reconciliation process for June 2015.

Reviewed and approved by the UpStudy tutoring team

error msg
Explain
Simplify this solution

Mind Expander

Sure, let's dive into the bank reconciliation for ABC Company for June 2015 and then the journal entries! ### Task 2.1: Bank Reconciliation for June 2015 **Bank Balance as per Statement** Balance per Bank as of June 30, 2015: Br. 9,143.11 **Add: Deposits in Transit** - Deposits in transit: Br. 1,852.21 **Less: Outstanding Checks** - Outstanding checks: Br. 5,265.27 **Adjusted Bank Balance:** \( 9,143.11 + 1,852.21 - 5,265.27 = Br. 5,730.05 \) **Book Balance as per Cash Records** Cash balance as of June 1, 2015: Br. 3,943.50 Add: Total Cash Receipts for June: Br. 28,971.60 Less: Total Amount of Checks Paid: Br. 28,388.85 **Book Balance before adjustments:** \( 3,943.50 + 28,971.60 - 28,388.85 = Br. 4,526.25 \) **Adjustments to Book Balance:** 1. Add: Note collected by bank: Br. 1,030 2. Less: Cheque incorrectly charged by bank: Br. 18 (Br. 157 - Br. 139) 3. Less: Cheque incorrectly recorded: Br. 210 (Br. 240 - Br. 30) 4. Less: Bank service charges: Br. 18.20 Adjusted Book Balance Calculation: \( 4,526.25 + 1,030 - 18 - 210 - 18.20 = Br. 5,309.05 \) Both Adjusted Bank and Book Balances should be equal through proper adjustments. **Final Adjusted Balance:** - **Bank:** Br. 5,730.05 - **Book:** Br. 5,309.05 ### Task 2.2: Journal Entries 1. **Journal Entry to record interest collected on Note:** ``` Debit: Cash Br. 1,030 Credit: Notes Receivable (or Interest Revenue) Br. 1,030 ``` 2. **Journal Entry to correct the cheque wrongly charged:** ``` Debit: Accounts Payable Br. 18 Credit: Cash Br. 18 ``` 3. **Journal Entry to correct the cheque recorded erroneously:** ``` Debit: Accounts Payable Br. 210 Credit: Cash Br. 210 ``` 4. **Journal Entry for bank service charges:** ``` Debit: Bank Service Charges (or Miscellaneous Expenses) Br. 18.20 Credit: Cash Br. 18.20 ``` And there you have it! ABC Company’s bank reconciliation and necessary journal entries for June 2015 are laid out and balanced.

Related Questions

Latest Other Questions

Try Premium now!
Try Premium and ask Thoth AI unlimited math questions now!
Maybe later Go Premium
Study can be a real struggle
Why not UpStudy it?
Select your plan below
Premium

You can enjoy

Start now
  • Step-by-step explanations
  • 24/7 expert live tutors
  • Unlimited number of questions
  • No interruptions
  • Full access to Answer and Solution
  • Full Access to PDF Chat, UpStudy Chat, Browsing Chat
Basic

Totally free but limited

  • Limited Solution
Welcome to UpStudy!
Please sign in to continue the Thoth AI Chat journey
Continue with Email
Or continue with
By clicking “Sign in”, you agree to our Terms of Use & Privacy Policy