Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Help me with this and provide explanation. the topic is about bank reconcillation The books of Enhypen Inc. disclosed a cash balance of P45,700 on

Help me with this and provide explanation. the topic is about bank reconcillation

The books of Enhypen Inc. disclosed a cash balance of P45,700 on June 30. The bank statement as of June 30 showed a balance of P50,300. Additional information that might be useful in reconciling the two balances follows:

  • Check payable to creditors for P3,000 was erroneously recorded on the books as P4,500.
  • Outstanding checks totaled P9,800 including a certain check of P2,000 payable to supplier recorded on June 25 but not yet mailed as of June 30.
  • There were bank service charges for June of P200 not yet recorded on the books.
  • Enhypen's account had been charged on June 26 for a customer's NSF check for P1,200. No entry has been made for the return of NSF check.
  • Undeposited collections as of June 30 for P13,400 including post-dated check of P1,300 from customer recorded on June 29.
  • A bank memo stated that a customer's note for P7,500 had been collected on June 27 but not yet recorded on the books.

1. How much is the correct cash in bank balance as of June 30?

2. Charm Cleaning prepares a bank reconciliation at the end of every month. At the end of July, the balance in the general ledger checking account was P2,750 and the bank balance on the bank statement was P2,980. Outstanding checks totaled P680 and deposits in trans were P400. The bank statement revealed that a check written for P120 was incorrectly recorded by Charm as a P220 disbursement. The bank statement listed service charges and NSF check charges totaling P150. The corrected cash balance is:

The information that follows is available from the general ledger and the bank statement of Dollar Company:

  • Cash in bank, October 31, P939,000
  • Deposit in transit, October 31, P35,000; outstanding checks, October 31, P68,000
  • Credit memo, October P60,000; Debit memo, October P20,000.
  • Included in the October bank receipts was a deposit of Bucks Company for P25,000, erroneously recorded by the bank to Ducks Company's account.
  • Included in the October bank disbursements was check issued by Quacks Company for P10,000, erroneously recorded by the bank in Bucks Company's account.
  • Included in the book receipts was a deposit for P45,000 which was recorded as P54,000. No correction was made yet by Dollar Company.
  • Included in the book disbursements was a check issued by Dollar Company for P42,000 was recorded as P24,000.

3. The correct cash balance as of October 31, 2019 is?

4. West Company's bank statement for the month of December included the following information: Ending balance 2,800,000 Bank service charge for December 12,000 Interest paid by the bank to West for December10,000 In comparing the bank statement to its own cash records, West Company found the following: Deposits made but not yet recorded by the bank 350,000 Checks written and mailed but not yet recorded by bank 650,000 In addition, West Company discovered that it had drawn and erroneously recorded a check for P46,000 that should have been recorded for P64,000. What is the cash balance per ledger on December 31?

5. Jay Company's checkbook balance at December 31, 2021 was P123,450. In addition, Jay held the following items in its safe on that date: Check payable to Jay, deposited December 15 and included in December 31 checkbook balance, but returned by the bank on December 31 stamped "NSF". The check was redeposited on January 2, 2022 and cleared on January 9, 2022 -12,500 Check payable to Jay dated January 2, 2022 in payment of a sale made in December 2021, not included in December 31 checkbook balance-15,000 Check draw on Jay's account, payable to a vendor, dated and recorded in Jay's books on December 31, but not mailed until January 10, 2022-8,275 What is the amount of cash in Jay's December 31, 2021 statement of financial position?

6. Hero Corp has the following information relating to cash at December 31, 2011: Bank statement balance 2,500,000 Checkbook balance 2,600,000 Deposits in transit 700,000 Outstanding checks 200,000 Hero's December 31, 2011 Balance Sheet should report cash as:

7. Information pertaining to 89 Company appears below: Balance per bank statement July 31-1,240,000 Balance per ledger, July 31-750,000 Deposit on July 30 not recorded by bank-280,000 Debit memo - service charges-10,000 Credit memo - collection of note by bank for 89 Company-300,000 Outstanding checks-? An analysis of the canceled checks returned with the bank statement reveals the following:

  • Check for purchase of supplies was drawn for P60,000 but was recorded as P90,000.
  • The manager wrote a check for traveling expenses of P100,000 while out of town. The check was not recorded.

What is the outstanding checks on July 31?

Use the following information for the next two (2) questions: The books of Coach Company disclosed a cash balance P691,720 on June 30. The bank statement as of June 30 showed a balance of P556,800. Additional information that might be useful in reconciling the two balances follows:

  1. Check No. 128 for P13,000 was erroneously recorded in the check register as P30,000.
  2. A customer's note dated March 31 was discounted on April 12. The note was dishonored on June 29 (maturity date). The bank charged Coach's account for P142,650, which includes a protest fee of P420.
  3. The deposit of June 24 was recorded on the books as P28,950 but it was actually a deposit of P29,850.
  4. Outstanding checks totaled P98,850 as of June 30.
  5. There were bank service charges for June of P2,100 not yet recorded on the books.
  6. Coach's account had been charged on June 26 for a customer's NSF check for P12,960.
  7. Coach properly deposited P6,000 on June 30 that was not recorded by the bank.
  8. Receipt of June 30 for P134,250 were recorded by the bank on July 2.
  9. A bank memo stated that a customer's note for P45,000 and interest of P1,650 had been collected on June 27 and the bank charged a P360 collection fee.

8. How much is the correct cash balance at June 30?

9. How much is the net adjustment to the cash account?

10. Silver Company provided the following information for the month of October: Cash in bank, per bank statement, October 31-5,600,000 Bank service charge for October-24,000 Interest paid by the bank to Silver Company for October-20,000 Deposits made but not yet recorded by the bank-700,000 Checks written and mailed but not yet recorded by the bank-1,300,000 Erroneously recorded a check payment for P92,000 that should have been recorded as P128,000-36,000 What is the cash balance per ledger on October 31?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting for Non-Accounting Students

Authors: John R. Dyson

8th Edition

273722972, 978-0273722977

More Books

Students also viewed these Accounting questions

Question

Where in the hiring process are you?

Answered: 1 week ago