Question

In: Accounting

The cash account for Stone Systems at July 31, 2016, indicated a balance of $17,750. The...

The cash account for Stone Systems at July 31, 2016, indicated a balance of $17,750. The bank statement indicated a balance of $33,650 on July 31, 2016. Comparing the bank statement and the accompanying canceled checks and memos with the records reveals the following reconciling items:

A. Checks outstanding totaled $17,865.
B. A deposit of $9,150, representing receipts of July 31, had been made too late to appear on the bank statement.
C. The bank had collected $6,095 on a note left for collection. The face of the note was $5,750.
D. A check for $390 returned with the statement had been incorrectly recorded by Stone Systems as $930. 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 $1,810 had been incorrectly charged by the bank as $1,180.
F. Bank service charges for July amounted to $80.
Instructions
1. Prepare a bank reconciliation. Refer to the Amount Descriptions list provided for the exact wording of the answer choices for text entries. “Deduct:” or “Add:” will automatically appear if it is required.
2. Journalize the necessary entries. The accounts have not been closed. Refer to the Chart of Accounts for exact wording of account titles.
3. If a balance sheet were prepared for Stone Systems on July 31, 2016, what amount should be reported as cash?

Chart of Accounts

CHART OF ACCOUNTS
Stone Systems
General Ledger
ASSETS
110 Cash
111 Petty Cash
120 Accounts Receivable
131 Notes Receivable
141 Merchandise Inventory
145 Office Supplies
146 Store Supplies
151 Prepaid Insurance
181 Land
191 Office Equipment
192 Accumulated Depreciation-Office Equipment
193 Store Equipment
194 Accumulated Depreciation-Store Equipment
LIABILITIES
211 Accounts Payable-Holland Co.
221 Notes Payable
222 Interest Payable
231 Salaries Payable
241 Sales Tax Payable
EQUITY
310 Owner, Capital
311 Owner, Drawing
312 Income Summary
REVENUE
410 Sales
610 Interest Revenue
EXPENSES
510 Cost of Merchandise Sold
515 Credit Card Expense
516 Cash Short and Over
520 Salaries Expense
531 Advertising Expense
532 Delivery Expense
533 Insurance Expense
534 Office Supplies Expense
535 Rent Expense
536 Repairs Expense
537 Selling Expenses
538 Store Supplies Expense
561 Depreciation Expense-Office Equipment
562 Depreciation Expense-Store Equipment
590 Miscellaneous Expense
710 Interest Expense

Amount Descriptions

Amount Descriptions
Bank error in charging check as $1,180 instead of $1,810
Bank error in charging check as $1,810 instead of $1,180
Bank service charges
Check for $1,180 returned because of insufficient funds
Deposit of July 31, not recorded by bank
Error in recording check
Error in recording July 31 deposit
Outstanding checks
Proceeds of note collected by bank, not including interest
Proceeds of note collected by bank, including $345 interest

Bank Reconciliation

1. Prepare a bank reconciliation. Refer to the Amount Descriptions list provided for the exact wording of the answer choices for text entries. “Deduct:” or “Add:” will automatically appear if it is required. Whenever there is more than one adjusting item in the bank portion of the reconciliation or the general ledger portion of the bank reconciliation, enter in the order presented in the instructions.

STONE SYSTEMS

Bank Reconciliation

July 31, 2016

1

Cash balance according to bank statement

2

3

4

5

6

Adjusted balance

7

8

Cash balance according to company’s records

9

10

11

12

13

Adjusted balance

Journal

2. Journalize the necessary entries. The accounts have not been closed. Refer to the Chart of Accounts for exact wording of account titles.

PAGE 1

JOURNAL

DATE DESCRIPTION POST. REF. DEBIT CREDIT

1

2

3

4

5

6

Final Question

3. If a balance sheet were prepared for Stone Systems on July 31, 2016, what amount should be reported as cash?

Solutions

Expert Solution

SOLUTION

(A)

Stone Systems

Bank Reconciliation

July 31, 2016

Amount ($) Amount ($)
Cash balance according to bank statement 33,650
Add: Deposit of July 31, not recorded by bank 9,150
42,800
Deduct: Outstanding checks 17,865
Bank error in charging check as $1,180 instead of $1,810 630 18,495
Adjusted balance 24,305
Cash balance according to company's records 17,750
Add: Proceeds of note collected by bank, including $345 interest 6,095
Error in recording check 540 6,635
24,385
Deduct: Bank service charges (80)
Adjusted balance 24,305

(B) Journal Entries-

Date Account titles and Explanation Debit ($) Credit ($)
July 31 Cash 6,635
Notes Receivable 6,095
Accounts Payable - Holland Co. 540
July 31 Miscellaneous Expense 80
Cash 80

(C) If a balance sheet were prepared for Stone Systems on July 31, 2016, $24,305.00 should be reported as cash.


Related Solutions

Chapter 7 lab The cash account for Stone Systems at July 31, 20Y5, indicated a balance...
Chapter 7 lab The cash account for Stone Systems at July 31, 20Y5, indicated a balance of $17,750. The bank statement indicated a balance of $33,650 on July 31, 20Y5. Comparing the bank statement and the accompanying canceled checks and memos with the records reveals the following reconciling items: Checks outstanding totaled $17,865. A deposit of $9,150, representing receipts of July 31, had been made too late to appear on the bank statement. The bank had collected $6,095 on a...
Bank Reconciliation and Entries The cash account for Stone Systems at July 31, 20Y5, indicated a...
Bank Reconciliation and Entries The cash account for Stone Systems at July 31, 20Y5, indicated a balance of $12,695. The bank statement indicated a balance of $16,480 on July 31, 20Y5. Comparing the bank statement and the accompanying canceled checks and memos with the records reveals the following reconciling items: Checks outstanding totaled $5,930. A deposit of $6,180, representing receipts of July 31, had been made too late to appear on the bank statement. The bank had collected $3,210 on...
Bank Reconciliation and Entries The cash account for Stone Systems at July 31, 20Y5, indicated a...
Bank Reconciliation and Entries The cash account for Stone Systems at July 31, 20Y5, indicated a balance of $17,750. The bank statement indicated a balance of $33,650 on July 31, 20Y5. Comparing the bank statement and the accompanying canceled checks and memos with the records reveals the following reconciling items: Checks outstanding totaled $17,865. A deposit of $9,150, representing receipts of July 31, had been made too late to appear on the bank statement. Required: The bank had collected $6,095...
Bank Reconciliation and Entries The cash account for Stone Systems at July 31, 20Y5, indicated a...
Bank Reconciliation and Entries The cash account for Stone Systems at July 31, 20Y5, indicated a balance of $17,750. The bank statement indicated a balance of $33,650 on July 31, 20Y5. Comparing the bank statement and the accompanying canceled checks and memos with the records reveals the following reconciling items: Checks outstanding totaled $17,865. A deposit of $9,150, representing receipts of July 31, had been made too late to appear on the bank statement. The bank had collected $6,095 on...
Bank Reconciliation and Entries The cash account for Stone Systems at July 31, 20Y5, indicated a...
Bank Reconciliation and Entries The cash account for Stone Systems at July 31, 20Y5, indicated a balance of $17,750. The bank statement indicated a balance of $33,650 on July 31, 20Y5. Comparing the bank statement and the accompanying canceled checks and memos with the records reveals the following reconciling items: Checks outstanding totaled $17,865. A deposit of $9,150, representing receipts of July 31, had been made too late to appear on the bank statement. The bank had collected $6,095 on...
The cash account for Leisure Systems at Feb 29 2012, indicated a balance of $4,720. The...
The cash account for Leisure Systems at Feb 29 2012, indicated a balance of $4,720. The bank statement indicated a balance of $18,650 on Feb 29, 2012. Comparing the bank statements and accompanying cancelled checks and memos with records reveals the following reconciling items Checks outstanding totaled $13,960 2. Deposits of $9,350 representing receipts of February 29 had been made too late to appear on the bank statement. 3. The bank had collected $ 8,560 on a note left for...
The cash account for Collegiate Sports Co. on November 1, 2016, indicated a balance of $81,145....
The cash account for Collegiate Sports Co. on November 1, 2016, indicated a balance of $81,145. During November, the total cash deposited was $293,150, and checks written totaled $307,360. The bank statement indicated a balance of $112,675 on November 30, 2016. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: A. Checks outstanding totaled $41,840. B. A deposit of $12,200, representing receipts of November 30, had been made too late...
The cash account for Brentwood Bike Co. at May 1, 2016, indicated a balance of $34,250....
The cash account for Brentwood Bike Co. at May 1, 2016, indicated a balance of $34,250. During May, the total cash deposited was $140,300, and checks written totaled $138,880. The bank statement indicated a balance of $43,525 on May 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: A. Checks outstanding totaled $6,440. B. A deposit of $1,850 representing receipts of May 31, had been made too late to...
The cash account for Capstone Medical Co. at November 30, 2016, indicated a balance of $89,620....
The cash account for Capstone Medical Co. at November 30, 2016, indicated a balance of $89,620. The bank statement indicated a balance of $128,660 on November 30, 2016. Comparing the bank statement and the accompanying canceled checks and memos with the records revealed the following reconciling items: A. Checks outstanding totaled $32,700. B. A deposit of $18,550, representing receipts of November 30, had been made too late to appear on the bank statement. C. The bank collected $26,750 on a...
The cash account for Corey’s Construction Company at August 31, 2020, indicated a book balance of...
The cash account for Corey’s Construction Company at August 31, 2020, indicated a book balance of $19,885. The bank statement received by the company indicated a balance of $39,473.63 as at August 31, 2020. A comparison of the bank statement and the accompanying cancelled cheques and memos with the records revealed the following: A deposit of $6,794.62 was received by the bank on August 31 after the bank statement was prepared. Cheques #251 for $1,200 and #260 for $1,333.25 were...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT