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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started