Mr.Sanjeev,
Sheet is correct, formulas and steps are also correct only there are mistakes in word typing and I had clearly mentioned prepare your sheet, As this sheet will help you in preparing your sheet.
Mr.Sanjeev,
Sheet is correct, formulas and steps are also correct only there are mistakes in word typing and I had clearly mentioned prepare your sheet, As this sheet will help you in preparing your sheet.
Excel Sheet is wrong. Both uncleared cheque deposited and withdrawals are added in bank Balance as per Books while the total reconciled balance is after deducting Uncleared Cheque Deposits. More over in excel sheet on dated 07/01/2020 Cheque depsoit for Rs.104700/- and on dated 31/01/2020 Cheque Deposit for Rs.75000/-are shown in withdrawal while as per narration these are deposited not withdrawn.
