Bank Reconciliation and Entries The cash account for Stone Systems at July 31, 20Y5, indicated a balance of $12,670. The bank statement indicated a balance of $16,000 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,760. A deposit of $6,000, representing receipts of July 31, had been made too late to appear on the bank statement. The bank had collected $3,120 on a note left for collection. The face of the note was $2,960. A check for $600 returned with the statement had been incorrectly recorded by Stone Systems as $660. The check was for the payment of an obligation to Holland Co. for the purchase of office supplies on account. A check drawn for $500 had been incorrectly charged by the bank as $50. Bank service charges for July amounted to $60. Required: 1. Prepare a bank reconciliation. Stone Systems Bank Reconciliation July 31, 20Y5 Cash balance according to bank statement $ 16,000 Add: Deposit in transit on July 31 6,000 Deduct: Outstanding checks $ 5,760 Deduct: Bank error in charging check as $50 instead of $500 450 Total deductions 6,210 Adjusted balance $ 15,790 Cash balance according to company's records $ Adjustments: Add: Note collected by bank, including $160 interest $ 3,120 Add: Error in recording check by Stone Systems 60 Total additions 3,180 Deduct: Bank service charges 60 Adjusted balance $ Feedback 1. Set up two sections: one for the company cash account section and the other for the bank balance section. Determine the effect of the data on each section. Recall that when you are finished, the adjusted balances in the bank and company sections of the reconciliation must be equal. If not, an item has been overlooked or treated in error. Recall that the company's cash account balance is updated for any items in the company section of the bank reconciliation.
2. Journalize the necessary entries (a.) that increase cash and (b.) that decrease cash. The accounts have not been closed. If an amount box does not require an entry, leave it blank. 20Y5 July 31 Cash Notes Receivable Interest Revenue Accounts Payable-Holland Co. July 31 Miscellaneous Expense Cash
3. If a balance sheet were prepared for Stone Systems on July 31, 20Y5, what amount should be reported as cash? $
Answer-
Stone Systems | ||||
Bank Reconciliation | ||||
July 31, 20Y5 | ||||
Cash balance according to bank statement | $16,000 | |||
Adjustments: | ||||
Deposit of July 31, not recorded by bank | $6,000 | |||
Bank error in charging check as $50 instead of $500 | -$450 | |||
Outstanding checks | -$5,760 | |||
Total adjustments | -$210 | -$210 | ||
Adjusted balance | $15,790 | |||
Cash balance according to company's records | $12,670 | |||
Adjustments: | ||||
Proceeds of note collected by bank, including $160 interest | $3,120 | |||
Error in recording check by Stone Systems (600-660) | $60 | |||
Bank service charges | -$60 | |||
Total adjustments | $3,120 | $3,120 | ||
Adjusted balance | $15,790 |
2- Journal Entries
Date | Account Title | Debit ($) | Credit ($) |
2015 July 31 | Cash | 3,180 | |
Notes Receivable | 2,960 | ||
Interest Revenue (3,120-2,960) | 160 | ||
Accounts Payable -Holland Co. | 60 | ||
July 31 | Miscellaneous expenses | 60 | |
Cash | 60 |
3-The Cash Balance that shall be reported in Balance Sheet $15,790.
Kindly give thumbs up if u like my answer....Thanks!!!
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,800. The bank statement indicated a balance of $15,970 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,750. A deposit of $5,990, representing receipts of July 31, had been made too late to appear on the bank statement. The bank had collected $3,110 on...
Bank Reconciliation and Entries The cash account for Stone Systems at July 31, 2015, indicated a balance of $9,155. The bank statement indicated a balance of $11,610 on July 31, 20Y5. Comparing the bank statement and the accompanying canceled checks and memos records reveals the following reconciling items: a. Checks outstanding totaled $4,180. b. A deposit of $4,350, representing receipts of July 31, had been made too late to appear on the bank statement. c. The bank had collected $2,260...
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: 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...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $12,830. During May, the total cash deposited was $ 64,640 and checks written totaled $60,020. The bank statement indicated a balance of $21,910 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 $9,760. b. A deposit of $7,950, representing receipts of May 31, had been...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $14,640. During May, the total cash deposited was $73,260 and checks written totaled $68,020. The bank statement indicated a balance of $24,840 on May 31. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $11,060. A deposit of $9,010, representing receipts of May 31, had been made too late...
Only need help with Question 2 Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $14,600. During May, the total cash deposited was $73,740 and checks written totaled $68,470. The bank statement indicated a balance of $25,000 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 $11,130. b. A deposit of $9,070, representing receipts...
Bank Reconciliation and Entries. The cash account for Brentwood Bike Co. at May 1 indicated a balance of $14,640. During May, the total cash deposited was $73,180 and checks written totaled $67,950. The bank statement indicated a balance of $24,810 on May 31. Comparing the bank statement, the canceled checks, ans fhe accompaying memos with the records revealed the following reconciling items: a. Checks outstanding totaled $11,050 2 matches shor De ories & Problems BLANKSH. ALGO eBook Show Me How...
Bank Reconciliation and Entries The cash account for Brentwood Bike Co. at May 1 indicated a balance of $14,370. During May, the total cash deposited was $72,740 and checks written totaled $67,540. The bank statement indicated a balance of $24,660 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 $10,980. b. A deposit of $8,950, representing receipts of May 31, had been made...
The cash account for Deaver Consulting at October 31, 2016, indicated a balance of $9,810. The bank statement indicated a balance of $12,360 on October 31, 2016 Comparing the bank statement and the accompanying canceled checks and memos with the records revealed the following reconciling items: a. Checks outstanding totaled $4,450. b. A deposit of $4,640, representing receipts from October 31, had been made too late to appear on the bank statement. C. The bank had collected $2,410 on a...
Bank Reconciliation On July 31, Arthur Company's Cash in Bank account had a balance of $8,112.62. On that date, the bank statement indicated a balance of $10,170.62 A comparison of returned checks and bank advices revealed the following: 1. Deposits in transit July 31 amounted to $3,316.12. 2. Outstanding checks July 31 totaled $1,251.12. 3. The bank erroneously charged a $215.00 check of Solomon Company against the Arthur bank account. 4. A $15 bank service charge has not yet been...