please explain how to do it:)

Bank recondiliation and entries The cash account for stone Systems at July 31,20rs, indicated a balance of $8,375. The bank statement indicated a balance of $11,050 an Juky 31 . 20rs.Camparingthebank statement and the accompaning canceled thecks and memos with the records reveals the following reconoling liems: a. Checks outstanding totaled $3,980. b. A depocit of $1,140, representing receipts of luly 31 , had been made too late to apoear on the bank statement. c. The bank had collected $2,150 on a note left for collection. The face of the note was $2,040. d. A check for $800 retumed with the statement had been incorrectly recorded by Stone Systems as \$8:80. The check was for the payment of an obilgabon to Holland Ca. for the purchase of office supplies on account. e. A check drawn for $700 had been incorrectly charped by the bank as $70. f. Bank service charges for July arnounted to $25. Required: 1. Prepare a bank reconciliation. T Chest Mr wher. 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, ftecall tisat when you are finished, the adfusted balances in the bank and company sections of the reconcifiation must be equat it not, an item has been overlook ed ar treated in eitor. Hecall that the company's cash account balance is updated for any items in the company section of the bank reconcilation. 2. Joumalize the necessary entries (a.) that increase cash and (b.) that decrease cash, The accounts have noc been dosed. If an amount bov does not iequire an entry, leave if blank. 2. Journalize the necessary entries (a.) that increase cash and (b.) that decrease cash. The accounts have not been dosed. If an amount box does not require an entry, leave it bank. Troibace ronean Ny Wer 2. Keeg in mind that the company needs to journalize any adjusting items in the company section of the bank reconciliation, because these have not been previously recorded by the company. Debit merno itecns liko bank service charges decrease Cash. Ttems that come from credit memos like colections of notes or interest by the bank increase cash. If the company made an etror that overstates or understates cash in the company section, the journal aufustment would decrease Cash or increase Cash. respectively. 3. If a balance sheet were prepared for Stoee Systems on July 31, 20y5, what amount should be reported as cash