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

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!