XYZ Inc is preparing the October month-end Bank Reconciliation. The balance in the cash ledger on October 31 was $1,900. Some adjustments to this cash ledger balance were recorded on the Bank Reconciliation Report, as follows: • Bank service charge $55 NSF cheque: $375 • Cheque # 40 was correctly written and processed for $3,030 however the XYZ bookkeeper recorded the cheque amount for $3,300. What is the adjusted cash balance for October 31, for the Bank Reconciliation Report? Show your basic math.

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
### Bank Reconciliation Explanation

XYZ Inc is preparing the October month-end Bank Reconciliation. The balance in the cash ledger on October 31 was $1,900. Some adjustments to this cash ledger balance were recorded on the Bank Reconciliation Report, as follows:

- **Bank service charge**: $55
- **NSF cheque**: $375
- **Cheque #40 correction**: This cheque was correctly written and processed for $3,030; however, the XYZ bookkeeper recorded the cheque amount as $3,300.

**Task:**
What is the adjusted cash balance for October 31, for the Bank Reconciliation Report? Show your basic math.

#### Solution:
1. **Initial Cash Ledger Balance**: $1,900

2. **Adjust for Bank Service Charge**: 
   - Subtract $55 (service charge)
   - New balance: $1,900 - $55 = $1,845

3. **Adjust for NSF Cheque**: 
   - Subtract $375 (NSF cheque)
   - New balance: $1,845 - $375 = $1,470

4. **Adjust for Cheque #40 Error**:
   - Difference: $3,300 (recorded) - $3,030 (actual) = $270
   - Add $270 (since $270 was recorded as an extra deduction)
   - New balance: $1,470 + $270 = $1,740

**Adjusted Cash Balance**: $1,740
Transcribed Image Text:### Bank Reconciliation Explanation XYZ Inc is preparing the October month-end Bank Reconciliation. The balance in the cash ledger on October 31 was $1,900. Some adjustments to this cash ledger balance were recorded on the Bank Reconciliation Report, as follows: - **Bank service charge**: $55 - **NSF cheque**: $375 - **Cheque #40 correction**: This cheque was correctly written and processed for $3,030; however, the XYZ bookkeeper recorded the cheque amount as $3,300. **Task:** What is the adjusted cash balance for October 31, for the Bank Reconciliation Report? Show your basic math. #### Solution: 1. **Initial Cash Ledger Balance**: $1,900 2. **Adjust for Bank Service Charge**: - Subtract $55 (service charge) - New balance: $1,900 - $55 = $1,845 3. **Adjust for NSF Cheque**: - Subtract $375 (NSF cheque) - New balance: $1,845 - $375 = $1,470 4. **Adjust for Cheque #40 Error**: - Difference: $3,300 (recorded) - $3,030 (actual) = $270 - Add $270 (since $270 was recorded as an extra deduction) - New balance: $1,470 + $270 = $1,740 **Adjusted Cash Balance**: $1,740
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

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