Reference no: EM132630878
Problem for Bank Reconciliation
The Cash account of The New Normal Corporation for the fiscal year ending July 31, 2019 has the following information.
General Ledger Bank Statement
Beginning Balance ------------------------ P 140,330 P 172,590
Deposits ------------------------------------- 751,680
Cash Receipts Journal------------------- 763,680
Checks Cleared in the Bank ------------ (708,450)
Cash Disbursements Journal ---------- (654,330)
July Bank service Charge -------------- (2,610)
Note Paid by the Bank ------------------ (183,000)
NSF Check --------------------------------- (9,330)
Ending Balance -------------------------- P 249,680 P 20,880
a. Bank Reconciliation in June included the following Information: Bank Statement Balance, P 172,590; Deposit in Transit, P 18,000; Outstanding Checks, P 52,260; and balance per general ledger, P 140,330.
b. Checks Clearing in the bank in July included the following:
Checks Outstanding by the end of June P 50,760
Checks recorded in July Cash Disbursements book 614,010
Check unrecorded and drawn by the company as payment of liability 31,800
A check drawn by New Rural Corporation 11,880
c. Deposits included P 18,000 from June and P 733,680 from July.
d. The bank charged New Normal Corp.'s account for NSF totaling P 9,330. The check was turned over to a collecting agency.
e. A note of P 174,000, plus interest, was paid directly by bank under an agreement signed four months ago. The note was recorded in the books of New Normal at P 174,000.
REQUIRED:
Problem 1. Compute the total Outstanding Checks as of July 31..
Problem 2. Compute the total Deposit in transit as of July 31.
Problem 3. Compute the correct Cash in Bank balance as of July 31.
Problem 4. Compute the Cash in Bank Shortage, if any, as of June 30.