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)

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education