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
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
  • 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