Question

Roper Electronics received its bank statement for the month of August with an ending balance of $11,740. Roper determined that check #613 for $155 and check #601 for $420 were both outstanding. Also, a $6,900 deposit for August 30 was in transit as of the end of the month. Northern Regional Bank also collected a $5,000 note receivable on August 1 that was issued March 1. Accrued interest is $250. Northern Regional Bank charged a $35 fee for the collection service. The bank statement reveals a bank service charge of $20. A customer check for $68 was returned with the bank statement marked "NSF." The ending balance of the Roper cash account is $12,938.?

Answer 1

Answer

The answer and procedures of the exercise are attached in a microsoft excel document.  

Explanation  

Please consider the data provided by the exercise. If you have any question please write me back. All the exercises are solved in a single sheet with the formulas indications.  

Download xlsx