The cash account for Stone Systems at July 31, 20Y5, indicated a balance of $12,700. The bank statement indicated a balance of $15,810 on July 31, 20Y5. Comparing the bank statement and the accompanying canceled checks and memos with the records reveals the following reconciling items: a. Checks outstanding totaled $5,690. b. A deposit of $5,930, representing receipts of July 31, had been made too late to appear on the bank statement. c. The bank had collected $3,080 on a note left for collection. The face of the note was $2,920. d. A check for $500 returned with the statement had been incorrectly recorded by Stone Systems as $550. The check was for the payment of an obligation to Holland Co. for the purchase of office supplies on account. e. A check drawn for $300 had been incorrectly charged by the bank as $30. f. Bank service charges for July amounted to $50. Required: 1. Prepare a bank reconciliation. Stone Systems Bank Reconciliation July 31, 20Y5 Cash balance according to bank statement Add: Deposit in transit on July 31 Deduct: Qutstanding checks

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 and Journal Entries

#### 1. Adjusted Balance Calculation

- **Adjusted Balance** (Bank):
  - Input field (blank)

- **Adjusted Balance** (Company's records):
  - Input field (blank)

#### Cash Balance According to Company's Records

  - Input field (blank)

#### Adjustments

- Adjustments section is designed to allow input for necessary adjustments both for positive and negative:
  - Addition input field
  - Total additions input field (calculated total)
  - Adjusted balance input field

#### 2. Journalize Entries

Provide journal entries to:

- Increase cash
  - Input date: 20Y5 July 31 with dropdown selection for transaction type (Credit/Debit) followed by amount
  
- Decrease cash
  - Input date: 20Y5 July 31 with dropdown selection for transaction type (Credit/Debit) followed by amount

#### Journal Entry Section

20Y5 July 31:

- Dropdown selection for account
- Input field for transaction amount

July 31:

- Dropdown selection for account
- Input field for transaction amount

#### 3. Balance Sheet Preparation

- Question: "If a balance sheet were prepared for Stone Systems on July 31, 20Y5, what amount should be reported as cash?"
  - Answer: $15,780
Transcribed Image Text:### Bank Reconciliation and Journal Entries #### 1. Adjusted Balance Calculation - **Adjusted Balance** (Bank): - Input field (blank) - **Adjusted Balance** (Company's records): - Input field (blank) #### Cash Balance According to Company's Records - Input field (blank) #### Adjustments - Adjustments section is designed to allow input for necessary adjustments both for positive and negative: - Addition input field - Total additions input field (calculated total) - Adjusted balance input field #### 2. Journalize Entries Provide journal entries to: - Increase cash - Input date: 20Y5 July 31 with dropdown selection for transaction type (Credit/Debit) followed by amount - Decrease cash - Input date: 20Y5 July 31 with dropdown selection for transaction type (Credit/Debit) followed by amount #### Journal Entry Section 20Y5 July 31: - Dropdown selection for account - Input field for transaction amount July 31: - Dropdown selection for account - Input field for transaction amount #### 3. Balance Sheet Preparation - Question: "If a balance sheet were prepared for Stone Systems on July 31, 20Y5, what amount should be reported as cash?" - Answer: $15,780
### Bank Reconciliation and Entries

The cash account for Stone Systems at July 31, 20Y5, indicated a balance of $12,700. The bank statement indicated a balance of $15,810 on July 31, 20Y5. Comparing the bank statement and the accompanying canceled checks and memos with the records reveals the following reconciling items:

a. Checks outstanding totaled $5,690.
b. A deposit of $5,930, representing receipts of July 31, had been made too late to appear on the bank statement.
c. The bank had collected $3,080 on a note left for collection. The face of the note was $2,920.
d. A check for $500 returned with the statement had been incorrectly recorded by Stone Systems as $550. The check was for the payment of an obligation to Holland Co. for the purchase of office supplies on account.
e. A check drawn for $300 had been incorrectly charged by the bank as $30.
f. Bank service charges for July amounted to $50.

#### Required:
1. Prepare a bank reconciliation.

### Stone Systems
**Bank Reconciliation**  
**July 31, 20Y5**

| **Items**                                                        | **Amount**  |
|------------------------------------------------------------------|-------------|
| **Cash balance according to bank statement**                     | $15,810     |
| **Add: Deposit in transit on July 31**                           | $5,930      |
|                                                                   |             |
| **Deduct: Outstanding checks**                                    | $5,690      |
| **Deduct: Error in recording check by Stone Systems**             | $50 (550-500)|
| **Bank service charges**                                          | $50         |
|                                                                   | **Total deductions** | $5,790     |
| **Adjusted balance**                                              | $15,950     |
| **Cash balance according to company's records**                   | $12,700     |

#### Explanation of Graphs/Diagrams:
The diagram presented is a table structure for the bank reconciliation process:

1. **Cash balance according to bank statement:** The starting point is the cash balance shown by the bank statement, which is $15,810.
   
2. **Add: Deposit in transit on July 31:** Deposits made too late to appear on the bank statement are added. In this case, a deposit of $5,930 was made.

3. **Ded
Transcribed Image Text:### Bank Reconciliation and Entries The cash account for Stone Systems at July 31, 20Y5, indicated a balance of $12,700. The bank statement indicated a balance of $15,810 on July 31, 20Y5. Comparing the bank statement and the accompanying canceled checks and memos with the records reveals the following reconciling items: a. Checks outstanding totaled $5,690. b. A deposit of $5,930, representing receipts of July 31, had been made too late to appear on the bank statement. c. The bank had collected $3,080 on a note left for collection. The face of the note was $2,920. d. A check for $500 returned with the statement had been incorrectly recorded by Stone Systems as $550. The check was for the payment of an obligation to Holland Co. for the purchase of office supplies on account. e. A check drawn for $300 had been incorrectly charged by the bank as $30. f. Bank service charges for July amounted to $50. #### Required: 1. Prepare a bank reconciliation. ### Stone Systems **Bank Reconciliation** **July 31, 20Y5** | **Items** | **Amount** | |------------------------------------------------------------------|-------------| | **Cash balance according to bank statement** | $15,810 | | **Add: Deposit in transit on July 31** | $5,930 | | | | | **Deduct: Outstanding checks** | $5,690 | | **Deduct: Error in recording check by Stone Systems** | $50 (550-500)| | **Bank service charges** | $50 | | | **Total deductions** | $5,790 | | **Adjusted balance** | $15,950 | | **Cash balance according to company's records** | $12,700 | #### Explanation of Graphs/Diagrams: The diagram presented is a table structure for the bank reconciliation process: 1. **Cash balance according to bank statement:** The starting point is the cash balance shown by the bank statement, which is $15,810. 2. **Add: Deposit in transit on July 31:** Deposits made too late to appear on the bank statement are added. In this case, a deposit of $5,930 was made. 3. **Ded
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

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
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