I need help to journalize in exel format please asap !! The cash account for Sto

Question

I need help to journalize in exel format please asap !!

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.

Explanation / Answer

Jul-31 Cash 6095      Notes receivable 5750       Interest revenue 345 Jul-31 Cash 540       Accounts Payable – Holland Co 540 Jul-31 Miscellaneous Expense 80        Cash 80

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.