As the new accountant of Villain Corn, you were assigned to prepare the bank reconciliation statement for the year-end of 2020. The following are the given: Cash on book records before reconciliation was P 900.000 Cash per bank statements before reconciliation was P 762,000 Money to deposit on December 31 amounting to P 130,000 was sent to the bank late. This was reflected in the books but not on the bank Outstanding checks totaled P41,000 as of December 31. Bank service charges for December of P 110,000. A customer paid directly to the bank without informing the corporation, P 68,000. Villain made a payment using cash from the bank amounting to P 18,000 but it was recorded in the book as 14,000. The bank erroneously charged 3.000 to Villain Corp but actually is should be charged to Enemy Corp. Here's your guide to accomplish this output. Step 1. Locate the beginning Cash balance of the company. Note all information is given in the problem. Your task is to identify and arrange them according to the format presented in the lecture note. Step 2. Next, find the book reconciliation items like Credit Memo and Debit Memo. Step 3. After that, look for the item in the letter above for an ERROR made by the company. Analyze this error if the effect is overstating or understating the cash. If the error is overstating the amount of cash, deduct this erroneous amount. If the error is understating the cash balance, add the amount to correct it. Step 4. This time, it's checking the bank balance. Find the amount representing the cash balance statement in the bank. Step 5. Next look for the Deposit in transit and Outstanding check. If you forgot how to deal with this go back with the lecture notes. Step 6. After that. look for the item in the letter above for an ERROR made by the bank. Analyze this error if the effect is overstating or understating the cash in the bank. If the error is overstating the amount of cash, deduct this erroneous amount. If the error is understating the cash balance, add the amount to correct it.   (please show detailed solution for reference)

College Accounting (Book Only): A Career Approach
13th Edition
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:Scott, Cathy J.
Chapter6: Bank Accounts, Cash Funds, And Internal Controls
Section: Chapter Questions
Problem 1PB
icon
Related questions
Question

As the new accountant of Villain Corn, you were assigned to prepare the bank reconciliation statement for the year-end of 2020. The following are the given:

Cash on book records before reconciliation was P 900.000

Cash per bank statements before reconciliation was P 762,000

Money to deposit on December 31 amounting to P 130,000 was sent to the bank late. This was reflected in the books but not on the bank

Outstanding checks totaled P41,000 as of December 31.

Bank service charges for December of P 110,000.

A customer paid directly to the bank without informing the corporation, P 68,000.

Villain made a payment using cash from the bank amounting to P 18,000 but it was recorded in the book as 14,000.

The bank erroneously charged 3.000 to Villain Corp but actually is should be charged to Enemy Corp.

Here's your guide to accomplish this output.

Step 1. Locate the beginning Cash balance of the company. Note all information is given in the problem. Your task is to identify and arrange them according to the format presented in the lecture note.

Step 2. Next, find the book reconciliation items like Credit Memo and Debit Memo.

Step 3. After that, look for the item in the letter above for an ERROR made by the company. Analyze this error if the effect is overstating or understating the cash. If the error is overstating the amount of cash, deduct this erroneous amount. If the error is understating the cash balance, add the amount to correct it.

Step 4. This time, it's checking the bank balance. Find the amount representing the cash balance statement in the bank.

Step 5. Next look for the Deposit in transit and Outstanding check. If you forgot how to deal with this go back with the lecture notes.

Step 6. After that. look for the item in the letter above for an ERROR made by the bank. Analyze this error if the effect is overstating or understating the cash in the bank. If the error is overstating the amount of cash, deduct this erroneous amount. If the error is understating the cash balance, add the amount to correct it.

 

(please show detailed solution for reference)

As the new accountant of Villain Corp, you were assigned to prepare the bank reconciliation
statement for the year end of 2020. The following are the given:
a. Cash on book records before reconciliation was P 900,000
b. Cash per bank statements before reconciliation was P 762,000
c. Money to deposit on December 31 amounting to P 130,000 was sent to the bank late. This
was reflected in the books but not on the bank
d. Outstanding checks totaled P41,000 as of December 31.
e. Bank service charges for December of P 110,000.
f. A customer paid directly to the bank without informing the corporation, P 68,000.
E. Villain made a payment using cash from the bank amounting to P 18,000 but it was recorded in
the book as 14,000.
h. The bank erroneously charged 3,000 to Villin Corp but actually is should be charged to Enemy
Corp.
Here's your guide to accomplish this output.
Step 1. Locate the beginning Cash balance of the company. Note all information are given in the problem. Your task is to identify and arrange them
according to the format presented in the lecture note.
Step 2. Next find the book reconciliation items like Credit Memo and Debit Memo.
Step 3. After that, look for the item in the letter above for an ERROR made by the company. Analyze this error if the effect is overstating or
understating the cash. If the error is overstating the amount of cash, deduct this erroneous amount If the error is understating the cash balance, add the
amount to correct it.
Step 4. This time, it's checking the bank balance. Find the amount representing the cash balance statement in the bank.
Step 5. Next look for the Deposit in transit and Outstanding check. If you forgot how to deal with this go back with the lecture notes.
Step 6. After that, look for the item in the letter above for an ERROR made by the bank. Analyze this error if the effect is overstating or understating the
cash in bank. If the error is overstating the amount of cash, deduct this erroneous amount. If the error is understating the cash balance, add the amount to
correct it.
Transcribed Image Text:As the new accountant of Villain Corp, you were assigned to prepare the bank reconciliation statement for the year end of 2020. The following are the given: a. Cash on book records before reconciliation was P 900,000 b. Cash per bank statements before reconciliation was P 762,000 c. Money to deposit on December 31 amounting to P 130,000 was sent to the bank late. This was reflected in the books but not on the bank d. Outstanding checks totaled P41,000 as of December 31. e. Bank service charges for December of P 110,000. f. A customer paid directly to the bank without informing the corporation, P 68,000. E. Villain made a payment using cash from the bank amounting to P 18,000 but it was recorded in the book as 14,000. h. The bank erroneously charged 3,000 to Villin Corp but actually is should be charged to Enemy Corp. Here's your guide to accomplish this output. Step 1. Locate the beginning Cash balance of the company. Note all information are given in the problem. Your task is to identify and arrange them according to the format presented in the lecture note. Step 2. Next find the book reconciliation items like Credit Memo and Debit Memo. Step 3. After that, look for the item in the letter above for an ERROR made by the company. Analyze this error if the effect is overstating or understating the cash. If the error is overstating the amount of cash, deduct this erroneous amount If the error is understating the cash balance, add the amount to correct it. Step 4. This time, it's checking the bank balance. Find the amount representing the cash balance statement in the bank. Step 5. Next look for the Deposit in transit and Outstanding check. If you forgot how to deal with this go back with the lecture notes. Step 6. After that, look for the item in the letter above for an ERROR made by the bank. Analyze this error if the effect is overstating or understating the cash in bank. If the error is overstating the amount of cash, deduct this erroneous amount. If the error is understating the cash balance, add the amount to correct it.
Expert Solution
steps

Step by step

Solved in 2 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.
Similar questions
Recommended textbooks for you
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
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Auditing: A Risk Based-Approach (MindTap Course L…
Auditing: A Risk Based-Approach (MindTap Course L…
Accounting
ISBN:
9781337619455
Author:
Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
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