Answer:
1a. Revised Cash balance $23,710
1b. No. the Bank reconciliation is NOT in balance
2a.$23,630
2b.No. The bank reconciliation will still NOT be in balance
3.The difference of $171,000 will be subtracted from the book balance
Explanation:
1a.Preparation of the Revised Cash Book
Particular Debit Particular Credit
Unadjusted $16,830; EFT of Utility $1,400
Balance $9,900 ; Bil $100
Note Collected 1,100; Service Fee Charged $2,700
Interest on Note Collected 90 ; NSF Checks Dishonored $23,710
Excess of Insurance Expense 27,910; Revised Balance $27,910
Therefore the Revised Cash balance at the end of the period will be $23,710
1b.NO. The Bank reconciliation is NOT in balance because the revised balance is still not matched with the bank balance reason been that the amount of $23,710 is not equal to $19,610
2-a) In a situation where the entry to correct the insurance payment hasn’t been made, the balance of cash book will be :
$23,710 – $80 = $23,630
2-b) No. The bank reconciliation will still NOT be in balance because $23,630 is not equal to $19,610
3. If company incorrectly recording a customer deposit at $190,000 rather than $19,000, this increases the balance of cash book by $171,000. Therefore, the company subtracted the difference of $171,000 from the book balance