Exshail (Software) (1576 Points)
24 February 2013Exshail Pass Book with Bank Reco Lite Version for Excel-2007+.
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.
Sample Data already enterered, afterwards you can overwrite it with your actual data.
Thanks,
Exshail
(Software)
(1576 Points)
Replied 24 February 2013
Screenshot of bank reconcile statement with both format.
Exshail
(Software)
(1576 Points)
Replied 05 March 2013
If Excel 2007 is blocking macros due to problems with "encryption" and your antivirus software, and you're not seeing the "Enable this content" radio button, you likely need to download the latest Service Pack for Office 2007.
To install Office Suite Service Pack 2, click on below link:
Office 2007 Service Pack 2
Exshail
(Software)
(1576 Points)
Replied 04 April 2013
Attached herewith Bank Passbook for F.Y. 2013-14.
If you have uncleared cheques in Prevous year then write opening balance as per Bank Statement & uncleared cheques again on 01/04/2013.
.
Exshail
(Software)
(1576 Points)
Replied 11 April 2014
Hi Friends,
Exshail
(Software)
(1576 Points)
Replied 13 April 2014
Hi Friends,
Attached herewith Bank Passbook for F.Y. 2014-15. If you have uncleared cheques in Prevous year then write opening balance as per Bank Statement & uncleared cheques again on 01/04/2014.
Exshail
(Software)
(1576 Points)
Replied 10 May 2015
Exshail
(Software)
(1576 Points)
Replied 07 February 2016
Exshail
(Software)
(1576 Points)
Replied 09 February 2018
Originally posted by : Jayesh Moundekar |
||
|
|
please sent 17-18 &18-19 |
|
Exshail
(Software)
(1576 Points)
Replied 16 February 2018
Exshail Bank Passbook with Auto Bank Reconcile Statement
Download attached free Exshail Pass Book with Bank Reco with cheque\deposit slip Printing (Lite updated 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 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.
New 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.
Any problem you may post here. Customization will be charged.
For FY 2018-2019, with more features\improvements if any will be posted ASAP.
Thanks,
Exshail Software
Exshail
(Software)
(1576 Points)
Replied 04 March 2018
Download attached free Exshail Pass Book with Bank Reco with cheque\deposit slip Printing (Lite updated 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.
Any problem you may post here.
Customization will be charged.
Thanks,
Exshail Software
Debasish Mishra
(AM)
(22 Points)
Replied 13 April 2018
Can I see the Code for the template which has been designed for performing Bank Rec ? Kindly help me to establish my learning curve. Email ID# debasish.mishrafinance @ gmail.com
CAclubindia
