You can create a bank Check printer simply  using MS Excel for your small business.
This method will very useful if you write more checks manually to your suppliers .
If you use this excel format not need to buy special printer or software. you can use your normal printer and your computer to do this.

First you have to enable macros to your excel or use 2003/2007 version.
I have create very simple excel work book, it can download free.
You have to do only below few things to set your checks to print.


Step 1: 1) save attached excel file to your computer in your favorites folder.

1) save the attached excel file to your computer in your favorites folder.

Download this file & Save in your computer from my blog

<p>I got cheque printing with the help of excel &amp; word using mail merge... </p><p>1. Automatic covertion of amount to words (paisa excluded)</p><p>2. Drop down list of parties</p><p>if any one need please mail me (no charges) jijanvg@gmail.com</p>
<p>can you please send to my email..</p><p>grace.prmhomesleisure@gmail.com</p><p>Thank you.. </p>
<p>Hi,</p><p>Pleased if you share the same on my email shrineemail@gmail.com</p><p>Thanks a lot..</p><p>Shriniwas Gorintala</p>
<p>Hi George</p><p>can you pls send this to me at udaykumar309@gmail.com ?</p>
<p>fazal.qadir86@yahoo.com</p><p>please send details on above said mail address.</p>
<p>wher is atached file</p>
i can't find excel file could you please send it to mail id: md.imran822@yahoo.com
<p>where is the excile file? i cant find it</p>
<p>Hi, please send cheque printing in excel &amp; word</p>
<p>Hi, please send cheque printing in excel &amp; word on my mail.id.sagarscreeners@gmail.com</p>
<p>The best cheque printing software i have ever seen..</p><p>It includes Automatic conversion of amount to word and also import values from excel and other dynamic features.</p><p>if u want please connect..</p><p><a href="http://www.printacheque.com" rel="nofollow">www.printacheque.com</a></p><p><a href="http://www.printacheque.com" rel="nofollow">ppsheth@gmail.com</a></p>
<p>thanks ,,,, but i think , it'll be good if you post video explains the steps in details </p>
<p>Thank you! What if I want to print multiple currencies like in the software http://chequeone.com ? Currently it prints only dollars</p>
<p>is there a way not to print Dollar, Cents while printing the amount in words? We have different currency out here in India</p><p> &quot; One Hundred only&quot; would be better than &quot; One hundred dollars and no cents&quot;</p>
<p>i think you need to go to the visual basic window and change some codes in it like dollar comments and anything you wanna make it fit your work :)</p>
Hi VineetC<br>Yes you can remove to print Dollar and cents changing the Macro Code and if you want to add different currency in word you can do it.
<p>Dear Bandara,</p><p>Can you please send me which code I want to change to remove the word Dollar and cent appearing on the print.</p>
<p>Hi,</p><p>but i'm knowing how to scan it and drag it well plz can u show me how</p>
Hi <br>just scan cheque and copy it to excel sheet . then drag the formated text box to correct place.
<p>Hi,</p><p>but i'm knowing how to scan it and drag it well plz can u show me how</p>
People have been moving towards electronic transfers for years, can you provide software that writes you a BACS data file?<br> <br> L
Thanks for your suggestion. I have idea and plan to create database program to create TT &amp; electronic transfer. If you have, can you kindly forward me some electronic transfer forms with difference bank.
<p>dear bandara pls tel how to change dollers to rupees step by step its very importent</p>
Can you point out what is a check leaf?
<p>page of a cheque book</p><p><a href="https://www.google.lk/search?q=check+leaf&biw=1366&bih=643&source=lnms&tbm=isch&sa=X&ei=tbfaVL_WHY6cugThh4LYCQ&ved=0CAYQ_AUoAQ" rel="nofollow">https://www.google.lk/search?q=check+leaf&amp;biw=1366&amp;bih=643&amp;source=lnms&amp;tbm=isch&amp;sa=X&amp;ei=tbfaVL_WHY6cugThh4LYCQ&amp;ved=0CAYQ_AUoAQ</a></p>
What is the &quot;check leaf&quot;?
<p>Is there any way to use the Company Address - for window envelopes for example?</p>
Hi,<br>Do you want to add company address to checks or want to do difference job with excel.
Hello Bandara:<br><br>Yes, I would be interested in adding the company address to the checks such that it would appear in the lower window of a two window envelope.<br><br>Thank you!
<p>nice </p>
<p>nice </p>
<p>Thanks for sharing this resource! I have been using http://checkwritingsoftware.net/ for this purpose and the experience has been fairly good. But I will try this too..glad reading :)</p>
<p>would please explain how can print in cheque in step vice</p>
<p>You can check our easy to use 'cheque printing software 6.6' The best features are it supports any king of printers, bulk printing, unlimited bank accounts, unlimited payee accounts, import/export to excel option. You can have your own customized cheque and it supports CTS 2010 cheque format. Visit : http://www.virtualsplat.com/software-solution/cheque-bill-printing-software.asp</p>
<p>I am not able to download it please tell how to do </p>
For work with excel files try to use&nbsp;.xlsx repair<br> <br> <a href="http://www.xlsxrepairtoolbox.com" rel="nofollow">http://www.xlsxrepairtoolbox.com</a>&nbsp;supports any version of Microsoft Excel application
Thank you very much Mr. Bandara.. I was searching for a long time to get such a method .. You also helped me a lot to make modification on the existing thing .. I appreciate your support .. Thanks a lot
For working with excel files make use of&nbsp;repair xlsx files<br> <br> <a href="http://www.repairxlsx.xlsxrepairtoolbox.com" rel="nofollow">http://www.repairxlsx.xlsxrepairtoolbox.com</a>&nbsp;recovers cells, fonts, colors, borders, content, formulas and other items

About This Instructable




Bio: I'm Sri Lankan and like to learn new things and communicate with others in the world. I'm employing as an Accountant in Maldives ... More »
More by bandara:Free web traffic software with Excel Design a form filling database using Microsoft access. Flower Vase from newspaper tube 
Add instructable to: