Download attached free Exshail Pass Book with Bank Reco with cheque Printing (Lite Version for Excel-2007+) for the financial year i.e. F.Y. 2017-2018.
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 template.
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.
New Reports :
1. Bank Deposit Slip : You have to just feed the entry no. in yellow highlighted cell.
2. Summery of all the bank transactions in the sheet named stm.
Any problem you may post in forum. For FY 2018-2019, with more features\improvements if any will be posted ASAP.
Thanks, Exshail Software