Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Management A Strategic Emphasis

Authors: Edward Blocher, David E. Stout, Gary Cokins, Kung Chen

4th Edition

0073128155, 978-0073128153

More Books

Students also viewed these Accounting questions