Download attached free Exshail Pass Book with Auto Bank Reco with cheque\Deposit Slip Printing (Lite Version for Excel-2007+) for the financial year i.e. F.Y. 2018-2019.
1. Enter Passbook entry in first sheet with auto balance.
2. Enter Cheque Clearing date in Clg.Date.
3. Click on Bank Reco from Ribbon button to view Bank Reconcile Statement.
4. Press Escape to Close Bank Reco.
5. Save\Close Passbook from Ribbon button. Maintain Bankwise file from this templete.
To print Cheque, just select\activate any cells from the row whic have records to print the cheque then click on Cheque Print from ribbon menu.
Other Reports :
1. Bank Deposit Slip : You have to just feed the entry no. in yellow highlited cell.
2. Summery of all the bank transactions in the sheet named stm. #zip