DO IT ABC Co. is preparing its November 30, 2020 bank reconciliation. The following information was determined. a. The cash balance per books is P500,000 while cash balance per bank statement is P530,000. b. The bank collected P640,000 from a customer, representing P600,000 principal of note receivable and P40,000 interest. c. NSF check of P150,000 returned by the bank to ABC. ABC Co. not yet recorded the return of the check. d. Collections amounting to P310,000 were deposited by month end but were not yet reflected on the bank statement. e. Checks issued totaling P60,000 are not yet presented to the bank for payment. f. A book error caused the debits to be overstated by P120,000. g. The bank error caused the debits to be overstated by P90,000.

Financial Accounting
14th Edition
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Carl Warren, Jim Reeve, Jonathan Duchac
Chapter8: Sarbanes-oxley, Internal Control, And Cash
Section: Chapter Questions
Problem 18E
icon
Related questions
Question
DO IT
ABC Co. is preparing its November 30, 2020 bank reconciliation. The following
information was determined.
a. The cash balance per books is P500,000 while cash balance per bank statement
is P530,000.
b. The bank collected P640,000 from a customer, representing P600,000 principal of
note receivable and P40,000 interest.
c. NSF check of P150,000 returned by the bank to ABC. ABC Co. not yet recorded
the return of the check.
d. Collections amounting to P310,000 were deposited by month end but were not yet
reflected on the bank statement.
e. Checks issued totaling P60,000 are not yet presented to the bank for payment.
f.
A book error caused the debits to be overstated by P120,000.
g. The bank error caused the debits to be overstated by P90,000.
Requirements.
1. Prepare bank reconciliation.
Bank Reconciliation Statement
Balance per books, end
Add: Credit memos
Less: Debit memos (NSF)
Add/Less: Book errors
Bal. per bank statement, end
Add: Deposits in transit (DIT)
Less: Outstanding checks (OC)
Add/Less: Bank errors
Adjusted balance
Adjusted balance
2. List down the nature of error its effect on ending balance of cash and the corrections made.
Nature of Error
Effect on ending balance
Correction
(Book or Bank)
of cash
(Amount credited/ debited)
e.g. Cr. P10,000
(Overstated or Understated)
1.
2.
Transcribed Image Text:DO IT ABC Co. is preparing its November 30, 2020 bank reconciliation. The following information was determined. a. The cash balance per books is P500,000 while cash balance per bank statement is P530,000. b. The bank collected P640,000 from a customer, representing P600,000 principal of note receivable and P40,000 interest. c. NSF check of P150,000 returned by the bank to ABC. ABC Co. not yet recorded the return of the check. d. Collections amounting to P310,000 were deposited by month end but were not yet reflected on the bank statement. e. Checks issued totaling P60,000 are not yet presented to the bank for payment. f. A book error caused the debits to be overstated by P120,000. g. The bank error caused the debits to be overstated by P90,000. Requirements. 1. Prepare bank reconciliation. Bank Reconciliation Statement Balance per books, end Add: Credit memos Less: Debit memos (NSF) Add/Less: Book errors Bal. per bank statement, end Add: Deposits in transit (DIT) Less: Outstanding checks (OC) Add/Less: Bank errors Adjusted balance Adjusted balance 2. List down the nature of error its effect on ending balance of cash and the corrections made. Nature of Error Effect on ending balance Correction (Book or Bank) of cash (Amount credited/ debited) e.g. Cr. P10,000 (Overstated or Understated) 1. 2.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Interim financial reporting
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
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
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
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
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
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning