What I can DoActivity 3.4 Reconcile Me1. The bank statement for Juan Company shows a balance per bank of P15,907.45 onApril 30,2015.On this date the balance of cash per books is P11,589.45.Additional information is provided below:Deposits in transit: April 30 deposit (received by the bank on viay 1) P2,201.40Outstanding checks: No. 453-P3,000.00No. 457-P1,401.30No. 460-P1,502.70Errors: Juan wrote check no. 443 for P1,226.00 and the bank correctly paid thatamount. However, he recorded the check as P1,262.00.Bank memoranda:Debit- NSF check from Pedro P425.60Debit- Charge for printing company checks P30.00Credit - Collection of note receivable for P1,000 pius interest earned of P50, lessbank collection fee of P15.00.Required: Prepare a bank reconciliation statement using the adjusted method.Hint: Bank Debit Memo are deductions made by the bank to the account of thedepositor Bank Credit Memo are additions made by the bank to the account of theaepositor.2. The company has an unadjusted book balance of P200,000.00. It has a deposit intransit worth P56,000.00 and outstanding check worth P12,000.00. The bankstatement received from the bank shows that the interest income worth P37,000.00was credited and the service charge of P19,000.00 was deducted.Required:1. How much is the adjusted cash balance for the period?2. How much is the unadjusted bank balance?

BRS stands for Bank reconciliation statement which refers to the statement that reports the…

y 3.4 Reconcile Me bank statement for Juan Company shows a balance per bank of P 30,2015. date the balance of cash per books is P11,589.45. al information is provided below: ennsits in transit: Anril 30 deposit (received by the bank on viay 1

y 3.4 Reconcile Me bank statement for Juan Company shows a balance per bank of P 30,2015. date the balance of cash per books is P11,589.45. al information is provided below: ennsits in transit: Anril 30 deposit (received by the bank on viay 1

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter5: Bank Reconciliation (bankrec)

Section: Chapter Questions

Problem 2R

See similar textbooks

Similar questions

Using the following information, prepare a bank reconciliation. Bank balance: $4,587 Book balance: $5,577 Deposits in transit: $1,546 Outstanding checks: $956 Interest income: $56 NSF check: $456
The bank reconciliation shows the following adjustments: Deposits in transit: $852 Notes receivable collected by bank: $1,000; interest: $20 Outstanding checks: $569 Error by bank: $300 Bank charges: $30 Prepare the correcting journal entry.
Using the following information, prepare a bank reconciliation. Bank balance: $3,678 Book balance: $2,547 Deposits in transit: $321 Outstanding checks: $108 and $334 Bank charges: $25 Notes receivable: $1,000; interest: $35
The bank statement for Juan Company shows a balance per bank of P15,907.45 on April 30,2015. On this date the balance of cash per books is P11,589.45. Additional information are provided below: Deposits in transit: April 30 deposit (received by the bank on May 1) P2,201.40 Outstanding checks: No. 453- P3,000.00 No. 460- P1,502.70 No. 457- P1,401.30 Errors: Juan wrote check no. 443 for P1,226.00 and the bank correctly paid that amount. However, he recorded the check as P1,262.00.
Bank reconciliation problem: The bank statement for Juan Company shows a balance per bank of P15,907.45 on April 30,2015. On this date the balance of cash per books is P11,589.45. Additional information are provided below: Deposits in transit: April 30 deposit (received by the bank on May 1) P2,201.40 Outstanding checks: No. 460-P1,502.70 No. 453-P3,000.00 No. 457-P1,401.30 Errors: Juan wrote check no. 443 for P1,226.00 and the bank correctly paid that amount. However, he recorded the check as P1,262.00. Bank memoranda: Debit- NSF check from Pedro P425.60. Debit- Charge for printing company checks P30.00 Credit – Collection of note receivable for P1,000 plus interest eamed of P50, less bank collection fee of P15.00. Required: Prepare a bank reconciliation statement using the adjusted method. Hint: Bank Debit Memo are deductions made by the bank to the account of the depositor Bank Credit Memo are additions made by the bank to the account of the depositor
Bank reconciliation problem: The bank statement for Juan Company shows a balance per bank of $15,907.45 on April 30, 2015. On this date, the balance cash per books is $11,589.45. Additional information: Deposits in transit: April 30 deposit (Received by the bank on May 1) $2,201.40 $3,000.00 $1,401.30 S1,502.70 Outstanding checks: No. 453 No. 457 No. 460 Errors: Juan wrote the check no. 443 for $1,226.00 and the bank correctly paid that amount. However, he recorded the check as $1,262.00. Bank memoranda: Debit – NSF check from Pedro $425.60 Debit – Charge for printing company checks $30.00 Credit – Collection of note receivable for $1,000 plus interest earned $50, less bank collection fee of $15.00. Required: Prepare a bank reconciliation statement using the adjusted method. Hint: Bank Debit Memo are deductions made by the bank to the account of the depositor. Bank Credit Memo are additions made by the bank to the account of the depositor.
Hh1. Prepare the bank reconciliation and corresponding journal entries. ONE SIDE BANK BALANCE AND OTHER SIDE BALANCE PER GENERAL LEDGER(BOOK BALANCE)
Prepare a Bank Reconciliation Statement using: a. Adjusted Balance Method b. Book to Bank Method c. Bank to Book Method
The following information pertains to jeng Company: Balance per bank statement, Dec. 31, 2013, P73,350Cash ledger balance, Dec. 31, 2013, P63,675Proceeds of a customer’s note collected by the bank including P50 interest, P6,525Bank service charges, P45Deposit in transit, P4,158NSF check of customer deposited and returned, P378Outstanding checks, P7,731 Requirement:a. Prepare the bank reconciliation statement.b. Journalize the adjusting entries
At November 30, Mazaya Company has the following bank information: cash balance per book R 04,600; outstanding checks R.O 28o; deposits in transit R.O 550, credit memo for interest R.O10, bank service charge RO.20 What is Mazaya's adjusted cash balance on November 30? Select one: a. RO4.590 b. R.O.4.320 CRO4.870 d. RO.4.870
Solve This ASAP
2. Shown below is the bank reconciliation for ONMYOWN Company for May 2023: Balance per bank, May 31, 2023 Add: Deposit in Transit Total Less: Outstanding Checks Bank Credit Error Cash Balance per book, May 31, 2023 The bank statement for June 2023 contains the following data: Total deposits Total charges, including and NSF check of P 4,000 and a service charge of P200 P 14,000 5,000 P75,000 12,000 87,000 19,000 P 68,000 P 55,000 48,000 All outstanding checks on May 31, 2023, including the bank credit, were cleared in bank in June 2023. There were outstanding checks of P 15,000 and deposit in transit of P19,000 on June 30, 2023 2.1. What is the cash balance per bank on June 30, 2023? 2.2. What is the Adjusted cash balance on June 30, 2023? 2.3. What is the cash balance per book on June 30, 2023?