LIVE GST Certification Course by CA Arun Chhajer begins 27th April. Register Now!!

Excel pass book with bank reco for excel-2007+

Exshail (Software) (1576 Points)

24 February 2013

Exshail 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,

Reply
Follow
Share

14 Replies

Exshail (Software) (1576 Points)
Replied 24 February 2013

Screenshot of bank reconcile statement with both format.

1 Like

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.

Attached File : 58368 1159447 axis bank passbook 13 14.zip downloaded: 1322 times

Exshail (Software) (1576 Points)
Replied 11 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 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.

Attached File : 58368 1307799 exshail bank passbook 14 15.zip downloaded: 972 times

Exshail (Software) (1576 Points)
Replied 10 May 2015

Hi Friends, Attached herewith Bank Passbook for F.Y. 2015-16. If you have uncleared cheques in previous year then write opening balance as per Bank Statement & uncleared cheques again on 01/04/2015. Now you can also print cheques. You should be on the cheque transaction row and click on Print Cheque from Ribbon Menu. Sample Data already entered so you can easily and fully explore it.

Attached File : 58368 20150510173535 exshail bank passbook with cheque print 15 16.zip downloaded: 689 times

2 Like

Exshail (Software) (1576 Points)
Replied 07 February 2016

Free Simple Auto Bank Reconcile Statement with Cheque Printing Utility

Friends,

Download attached free Exshail Pass Book with Bank Reco with cheque Printing (Lite Version for Excel-2007+) for the next financial year i.e. F.Y. 2016-2017.

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, click on Cheque Print from ribbon menu. It will print only those cheque on which current selcetion is active on that row from Exshail Bank Passbook Worksheet.

Customization will be charged.

Thanks,

Exshail Software

Attached File : 58368 20160207150730 exshail bank passbook 16 17.zip downloaded: 858 times

Harshith Rai (Accounts Manager) (25 Points)
Replied 12 May 2017

FY 17-18 PLZ

Jayesh Moundekar (Accountant) (7 Points)
Replied 07 February 2018

please sent 17-18 &18-19

Jayesh Moundekar (Accountant) (7 Points)
Replied 07 February 2018

please sent 17-18 &18-19

Exshail (Software) (1576 Points)
Replied 09 February 2018

Originally posted by : Jayesh Moundekar
	please sent 17-18 &18-19

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 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.

Exshail Bank Deposit Slip

2. Summery of all the bank transactions in the sheet named stm.

Exshail Bank Summery

Any problem you may post here. Customization will be charged.

For FY 2018-2019, with more features\improvments if any will be posted ASAP.

Thanks,

Exshail Software

Attached File : 58368 20180209091355 exshail passbook 17 18.zip downloaded: 226 times

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

Attached File : 58368 20180216164313 exshail passbook 17 18 caclub.zip downloaded: 638 times

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

Attached File : 58368 20180304153851 exshail passbook 18 19.zip downloaded: 223 times

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