Bank Reconciliation in Excel Just by 2 Steps
Posted Date : 16-Jul-2020 , 10:00:52 pm | Posted By CASANSAAR
Listen to this Article
0:00
0:00
Please find the excel file attached herewith.
Category : Accounts | Downloads : 43 | Comments : 3 | Hits : 1166
Also Read - Test File
This is testing
Also Read - Fund Flow Statement
PFA
Also Read - Cash Flow Statement
PFA
Also Read - how to prepare balance sheet easy
Very good and easy
Also Read - consolidated notes to accounts
Comments
sanjeev kumar goel
17-Jul-2020 , 09:37:57 amExcel 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.
RITESH BIJLANI
19-Jul-2020 , 04:03:31 amMr.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.
RITESH BIJLANI
19-Jul-2020 , 04:05:01 amMr.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.