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 Gibbs French. in Ethiopia
Jan 24,2025

Real Tutor Solution

Tutor-Verified Answer

Answer

**Bank Reconciliation for June 2015:** 1. **Bank Statement Balance:** Br. 9,143.11 2. **Add: Deposit in Transit** (Br. 1,852.21) 3. **Subtract: Outstanding Checks** (Br. 5,265.27) 4. **Add: Bank Collection for Note** (Br. 1,030.00) 5. **Add: Error in Check Charged** (Br. 18.00) 6. **Subtract: Error in Check Recorded** (Br. 210.00) 7. **Subtract: Bank Service Charges** (Br. 18.20) **Adjusted Bank Balance:** Br. 6,548.85 **Journal Entries:** 1. **Bank Service Charges:** - Debit: Bank Service Charges Expense Br. 18.20 - Credit: Cash Br. 18.20 2. **Error in Check Charged:** - Debit: Cash Br. 18.00 - Credit: Accounts Payable Br. 18.00 3. **Error in Check Recorded:** - Debit: Accounts Payable Br. 210.00 - Credit: Cash Br. 210.00 4. **Bank Collection for Note:** - Debit: Cash Br. 1,030.00 - Credit: Notes Receivable Br. 1,030.00

Solution

To solve the problem, we will follow these steps: ### Task 2.1: Prepare Bank Reconciliation for June 2015 1. **Start with the Bank Statement Balance:** - Bank Statement Balance as of June 30, 2015: \( \text{Br. } 9143.11 \) 2. **Adjust for Deposits in Transit:** - Add: Deposit in Transit: \( \text{Br. } 1852.21 \) 3. **Adjust for Outstanding Checks:** - Subtract: Outstanding Checks: \( \text{Br. } 5265.27 \) 4. **Adjust for Bank Collections:** - Add: Bank Collection for Note: \( \text{Br. } 1030.00 \) 5. **Adjust for Errors in Checks:** - Add: Error in Check Charged (overcharged by bank): \( \text{Br. } 157 - 139 = \text{Br. } 18 \) - Subtract: Error in Check Recorded (under-recorded by company): \( \text{Br. } 240 - 30 = \text{Br. } 210 \) 6. **Adjust for Bank Service Charges:** - Subtract: Bank Service Charges: \( \text{Br. } 18.20 \) Now, let's calculate the adjusted bank balance step by step. ### Calculation Steps: 1. **Initial Bank Balance:** \[ \text{Bank Balance} = 9143.11 \] 2. **Add Deposit in Transit:** \[ \text{Adjusted Balance} = 9143.11 + 1852.21 = 10995.32 \] 3. **Subtract Outstanding Checks:** \[ \text{Adjusted Balance} = 10995.32 - 5265.27 = 5729.05 \] 4. **Add Bank Collection for Note:** \[ \text{Adjusted Balance} = 5729.05 + 1030.00 = 6759.05 \] 5. **Add Error in Check Charged:** \[ \text{Adjusted Balance} = 6759.05 + 18 = 6777.05 \] 6. **Subtract Error in Check Recorded:** \[ \text{Adjusted Balance} = 6777.05 - 210 = 6567.05 \] 7. **Subtract Bank Service Charges:** \[ \text{Adjusted Balance} = 6567.05 - 18.20 = 6548.85 \] ### Final Adjusted Bank Balance: \[ \text{Final Adjusted Bank Balance} = 6548.85 \] ### Task 2.2: Record the Necessary Journal Entries Now, we will record the necessary journal entries based on the reconciling items: 1. **Record Bank Service Charges:** - Debit: Bank Service Charges Expense \( \text{Br. } 18.20 \) - Credit: Cash \( \text{Br. } 18.20 \) 2. **Record Error in Check Charged:** - Debit: Cash \( \text{Br. } 18.00 \) (to correct the overcharge) - Credit: Accounts Payable \( \text{Br. } 18.00 \) 3. **Record Error in Check Recorded:** - Debit: Accounts Payable \( \text{Br. } 210.00 \) (to correct the under-recording) - Credit: Cash \( \text{Br. } 210.00 \) 4. **Record Bank Collection for Note:** - Debit: Cash \( \text{Br. } 1030.00 \) - Credit: Notes Receivable \( \text{Br. } 1030.00 \) ### Summary of Journal Entries: 1. **Bank Service Charges:** \[ \text{Debit: Bank Service Charges Expense} \quad \text{Br. } 18.20 \] \[ \text{Credit: Cash} \quad \text{Br. } 18.20 \] 2. **Error in Check Charged:** \[ \text{Debit: Cash} \quad \text{Br. } 18.00 \] \[ \text{Credit: Accounts Payable} \quad \text{Br. } 18.00 \] 3. **Error in Check Recorded:** \[ \text{Debit: Accounts Payable} \quad \text{Br. } 210.00 \] \[ \text{Credit: Cash} \quad \text{Br. } 210.00 \] 4. **Bank Collection for Note:** \[ \text{Debit: Cash} \quad \text{Br. } 1030.00 \] \[ \text{Credit: Notes Receivable} \quad \text{Br. } 1030.00 \] This completes the bank reconciliation and the necessary journal entries for ABC Company for June 2015.

Reviewed and approved by the UpStudy tutoring team

error msg
Explain
Simplify this solution

Mind Expander

Alright, let's dive into the world of bank reconciliations and journal entries! To prepare a bank reconciliation, we first need to establish the adjusted balances using the provided information. Let’s break this down. 1. **Bank Statement Balance**: Beginning balance at bank: Br. 9143.11 Add: Deposit in transit: Br. 1852.21 Add: Note collected by the bank: Br. 1030 Less: Outstanding checks: Br. 5265.27 Adjusted bank balance: Br. 9143.11 + Br. 1852.21 + Br. 1030 - Br. 5265.27 = Br. 6660.05 2. **Book Balance**: Beginning balance: Br. 3943.50 Add: Cash receipts for June: Br. 28971.60 Less: Total checks paid: Br. 28388.85 Adjusted book balance: Br. 3943.50 + Br. 28971.60 - Br. 28388.85 = Br. 6726.25 Next, compare these adjusted balances to find any discrepancies. After correcting the errors noted, such as the incorrectly recorded check amounts, we would tally up the correct amounts: **Reconciliation Summary**: - **Adjusted Bank Balance**: Br. 6660.05 - **Adjusted Book Balance**: Br. 6726.25 **Journal Entries**: Now, let's tackle the necessary journal entries: 1. **Interest Collected by the Bank**: Debit Cash: Br. 1030 Credit Interest Income: Br. 1030 2. **Bank Error on Returned Check (additional charge)**: Debit Cash: Br. 18 (to correct) Credit Accounts Payable: Br. 18 3. **Company Error in Recording Check**: Debit Accounts Payable: Br. 210 (to correct) Credit Cash: Br. 210 4. **Bank Service Charges**: Debit Bank Charges: Br. 18.20 Credit Cash: Br. 18.20 With the above entries and reconciliations, ABC Company can sleep easy knowing their cash records and bank statement align! And remember, reconciling is key to keeping financial records squeaky clean. Cheers to balancing those books!

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