Prepare the Bank Reconciliation Statement

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
icon
Related questions
Question

Prepare the Bank Reconciliation Statement

Item 7:The company's Cash account at the end of August shows a
balance of Php967.
Item 8 :During the month of August the company wrote checks totaling
more than Php50,000. As of August 31 Php3,021 of the checks written
in August had not yet cleared the bank and Php200 of checks written in
June had not yet cleared the bank.
Item 9 The Php1,450 of cash received by the company on August 31
was recorded on the company's books as of August 31. However, the
Php1,450 of cash receipts was deposited at the bank on the morning of
September 1.
Item 10:On August 29 the company's Cash account shows cash sales of
Php145. The bank statement shows the amount deposited was actually
Php154. The company reviewed the transactions and found that
Php154 was the correct amount.
Transcribed Image Text:Item 7:The company's Cash account at the end of August shows a balance of Php967. Item 8 :During the month of August the company wrote checks totaling more than Php50,000. As of August 31 Php3,021 of the checks written in August had not yet cleared the bank and Php200 of checks written in June had not yet cleared the bank. Item 9 The Php1,450 of cash received by the company on August 31 was recorded on the company's books as of August 31. However, the Php1,450 of cash receipts was deposited at the bank on the morning of September 1. Item 10:On August 29 the company's Cash account shows cash sales of Php145. The bank statement shows the amount deposited was actually Php154. The company reviewed the transactions and found that Php154 was the correct amount.
WEEK 17 - Required: Given the BELOW information, PREPARE BRS.
Item 1 The bank statement for August 2014 shows an ending balance of Php3,490.
Item 2:On August 31 the bank statement shows charges of Php35 for the service
charge for maintaining the checking account.
Item 3 :On August 28 the bank statement shows a return item of Php100 plus a
related bank fee of Php10. The return item is a customer's check that was returned
because of insufficient funds.
Item 4 :The bank statement shows a charge of Php80 for check printing on August
20.
Item 5 The bank statement shows that Php8 was added to the checking account
on August 31 for interest earned by the company during the month of August.
Item 6 :The bank statement shows that a note receivable of Php1,000 was
collected by the bank on August 29 and was deposited into the company's account.
On the same day, the bank withdrew Php40 from the company's account as a fee
for collecting the note receivable.
Transcribed Image Text:WEEK 17 - Required: Given the BELOW information, PREPARE BRS. Item 1 The bank statement for August 2014 shows an ending balance of Php3,490. Item 2:On August 31 the bank statement shows charges of Php35 for the service charge for maintaining the checking account. Item 3 :On August 28 the bank statement shows a return item of Php100 plus a related bank fee of Php10. The return item is a customer's check that was returned because of insufficient funds. Item 4 :The bank statement shows a charge of Php80 for check printing on August 20. Item 5 The bank statement shows that Php8 was added to the checking account on August 31 for interest earned by the company during the month of August. Item 6 :The bank statement shows that a note receivable of Php1,000 was collected by the bank on August 29 and was deposited into the company's account. On the same day, the bank withdrew Php40 from the company's account as a fee for collecting the note receivable.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Financial Statement Analysis
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.
Similar questions
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning