5. The accountant for the Goshen Company assembled the following data: June 30 July 31 P 39,745 137,817 12,880 30,112 Cash account balance P 15,822 Bank statement balance 107,082 8,201 27,718 Deposits in transit Outstanding checks Bank service charge Customer's check deposited July 10, retumed by bank on July 16 marked NSF, and redeposited immediateły. no entry made on books for retun or redeposit Collection by bank of company's notes receivable *(Recorded on books in month following charge or collection) 72 60 8,250 80,900 71,815 The bank statements and the company's cash records show these totals: Disbursements in July per bank statement Cash receipts in July per Goshen's books Checks written in July per Goshen's books Receipts in July per bank statement P218,373 236,452 212,529 249,108 Determine the correct balance of the following A June 30 adjusted cash in bank balance B. July 31 adjusted receipts CuN 31 adiusted disbursements

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 4R
icon
Related questions
Question
there were deposits in transit amounting to P20,000 and outstanding checks totaling P42,500. The bank statement for
among its recelpts. Included on the bank debits were cost of checkbooks amounting to P300 and a P10,000 check
The bank statement on November 30, 20X6 showed a balance of P76,500. Among the bank credits in November was
marked "DAIF for P6,000. On December 31, 20X6 the company placed with the bank a customer's promissory note
December showed total receipts of P183,900, disbursements of P101,800 and a balance of P121,400. Bank debit
a customer's note for P25,000 collected for the account of the company which the company recognized in December
PROOF OF CASH PROBLEM
4. In the process of your examination of the financial statements of the Mehsoy Company for the year ended December
31. 20X6, you obtained the following data on its curent account
which was charged by the bank in error against Malu-ov Compeny accOunt, Alao in November, you ascertained er
the month of December showed total credit of P104.000 and total charges of P51,000. The company bo debit
memos for December were: No. 14334 for service chargee PA0O and No 14346 on a customer's returned check
with a face value of P30,000 for collection. The company treated this pote an part of its receipts although the butecka
able to collect on the note only in January, 20X7, A check for Poo wi racorded in the company cash payments books
in December as P9,900.
Based on the above data, you are to provide the answers to the following:
A How much is the undeposited collections as of December 31, 20X6?
B. How much is the outstanding checks as of December 31, 20X6?
C. How much is the adjusted cash balance as of November 30, 20X6?
D. How much is the adjusted bank receipts for December?
E. How much is the adjusted book disbursements for December?
F. How much is the adjusted cash balance as of December 31, 20X6?
5. The accountant for the Goshen Company assembled the following data:
June 30
P 15,822
107,082
8,201
27,718
July 31
P 39,745
137,817
12,880
30,112
Cash account balance
Bank statement balance
Deposits in transit
Outstanding checks
Bank service charge*
Customer's check deposited July 10, returned
by bank on July 16 marked NSF, and redeposited immediately:
no entry made on books for return or redeposit
Collection by bank of company's notes receivable
*(Recorded on books in month following charge or collection)
72
60
8,250
80,900
71,815
The bank statements and the company's cash records show these totals:
Disbursements in July per bank statement
Cash receipts in July per Goshen's books
Checks written in July per Goshen's books
Receipts in July per bank statement
P218,373
236,452
212,529
249,108
Determine the correct balance of the following:
A June 30 adjusted cash in bank balance
B. July 31 adjusted receipts
C. July 31 adjusted disbursements
D. July 31 adjusted cash in bank balance
Transcribed Image Text:there were deposits in transit amounting to P20,000 and outstanding checks totaling P42,500. The bank statement for among its recelpts. Included on the bank debits were cost of checkbooks amounting to P300 and a P10,000 check The bank statement on November 30, 20X6 showed a balance of P76,500. Among the bank credits in November was marked "DAIF for P6,000. On December 31, 20X6 the company placed with the bank a customer's promissory note December showed total receipts of P183,900, disbursements of P101,800 and a balance of P121,400. Bank debit a customer's note for P25,000 collected for the account of the company which the company recognized in December PROOF OF CASH PROBLEM 4. In the process of your examination of the financial statements of the Mehsoy Company for the year ended December 31. 20X6, you obtained the following data on its curent account which was charged by the bank in error against Malu-ov Compeny accOunt, Alao in November, you ascertained er the month of December showed total credit of P104.000 and total charges of P51,000. The company bo debit memos for December were: No. 14334 for service chargee PA0O and No 14346 on a customer's returned check with a face value of P30,000 for collection. The company treated this pote an part of its receipts although the butecka able to collect on the note only in January, 20X7, A check for Poo wi racorded in the company cash payments books in December as P9,900. Based on the above data, you are to provide the answers to the following: A How much is the undeposited collections as of December 31, 20X6? B. How much is the outstanding checks as of December 31, 20X6? C. How much is the adjusted cash balance as of November 30, 20X6? D. How much is the adjusted bank receipts for December? E. How much is the adjusted book disbursements for December? F. How much is the adjusted cash balance as of December 31, 20X6? 5. The accountant for the Goshen Company assembled the following data: June 30 P 15,822 107,082 8,201 27,718 July 31 P 39,745 137,817 12,880 30,112 Cash account balance Bank statement balance Deposits in transit Outstanding checks Bank service charge* Customer's check deposited July 10, returned by bank on July 16 marked NSF, and redeposited immediately: no entry made on books for return or redeposit Collection by bank of company's notes receivable *(Recorded on books in month following charge or collection) 72 60 8,250 80,900 71,815 The bank statements and the company's cash records show these totals: Disbursements in July per bank statement Cash receipts in July per Goshen's books Checks written in July per Goshen's books Receipts in July per bank statement P218,373 236,452 212,529 249,108 Determine the correct balance of the following: A June 30 adjusted cash in bank balance B. July 31 adjusted receipts C. July 31 adjusted disbursements D. July 31 adjusted cash in bank balance
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Bank reconciliation statement
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning