Monday, July 25, 2016

Cheque printing without special software or Printer with MS Excel

Print your Business or personal bank Cheques
simply using MS Excel.



Cheque Printer new version available to download..




This is a simple workbook,which will very useful for you if you write lot of cheques manually to your suppliers daily for your business. With this method you not need special printer or software only you need is computer with MS Excel and normal printer.



Yes, now you can use your normal printer and your laptop or desktop computer to print 100s of cheques in second.

First you have to enable macros to your MS excel.

I already crate a excel workbook using some macros and VB, you can download it free. and play....

These are the only steps you have to do to set your cheques printing.


  • 1) save attached excel file in your favorites folder.
  • 2) open office excel program and enable macros.


When you open the file , a yellow Message Bar appears in upper under menu bar like this. 

                    A) Click Enable Content button.


Then file will open as a trusted document.If you not enable macros in your excel program file not work properly:

How to do it manually  :  Macro settings are located in the Trust Center.

1. Click the File tab.
2. Click Options.
3. Click Trust Center, and then click Trust Center Settings.
4. In the Trust Center, click Macro Settings.
5. Make the selections that you want.
6. Click OK.



3) now open the save excel file. 



There are three work sheets in workbook .
  1. First worksheet for your cheque detail. (chdetails) You can add 100 of checks detials for print
  2. second cheque printer (cheqprint) You have to set it first time for your cheque paper size
  3. Third sheet for  customers/suppliers list. (payee list)


4) now scan an one of your check leaf from your check book and insert it to 2nd sheet to      format the margins.

According to size of your bank check size ,
drag and drop the  details to the correct place of check picture. These details linked with checks details sheet data. when you change the chcks details this data will change.

See the green color drop lines, it can move to any place to set your check leaf.

After you drag all cheque details to correct place. Remove check scan copy.





Now you can copy & paste first cheque margin to down for any nos of checks you wants.




Now enter your payee list and save. When you need to create checks just go to checks details sheet.










what you give to world 
  • select the payee name form drop down list.
  • enter the amount
  • now cheques ready to print. any way first time just print a photo copy of black cheque and see whether all the margins and places are correct. if not drag till it ok, 


                                                                                   





Thanks
If this is useful for you please share to world...

New Link for download
Direct download with Google Drive

24 comments:

  1. Nice post! Banks and credit Unions used to be the traditional way through which one could reorder personal check. This was the most common way to order checks. Most people no longer go through their banks to order online checks because the check costs are far too expensive. Thanks.

    Reorder Checks

    ReplyDelete
    Replies
    1. Nice post thanks.
      I m using free check printing utility.
      Try - www.xltool.in

      Delete
  2. I can only preview 2 checks. How can I see all the 10? Also what happens if it is more than 10?

    ReplyDelete
    Replies
    1. You can format down - dark color space, to link other checks same as first Two.
      If you want to print more than 10 in one time you need to format details work sheet first.
      Thanks

      Delete
    2. After formatting, the 10 cheques get displayed correctly. But the print takes only the first 2 cheques. I am sure the print module has some issues with the code. Could you have a look?

      Delete
    3. Nice post thanks.
      I m using free check printing utility.
      Try - www.xltool.in

      Delete
  3. Thanks for your response. Can you elaborate how to link? I have a 3rd check that I formatted same as the first 2 I have the values coming up but it does not go into the print preview. When I hit preview I still see two checks.

    ReplyDelete
  4. Now special software is free for personal users. you can check http://freechequeprinting.com . Its easy to use.

    ReplyDelete
  5. Now Special Software is free. You can check it http://freechequeprinting.com try it. its lifetime free

    ReplyDelete
  6. How to change currency to local currency?

    ReplyDelete
  7. dear friends, i tried to set with my cheque leaf for printing. but am helpless to arrange it as properly. could you please help me if i send u one cheque copy?

    ReplyDelete
  8. please mail me this excel format on my mail

    prashantpawar1983@gmail.com

    ReplyDelete
  9. Qualities of online printing companies differ. Some firms offer a definite turnaround date while others add charges for every little thing you request on your orders. You have to understand your needs before you start searching for a printing service, but make sure the needs coordinate with business objectives.
    order bank checks

    ReplyDelete
  10. hi, i read ur post and find interesting, however, the download limit reach the maximum everyday. would it be possible u will add another download link for us.

    Thanks

    ReplyDelete
  11. How Can I Change Money Name under in Word? like "Four Hundred Dollar and no cents" to 'Four Hundred Taka and no paisa"

    ReplyDelete
  12. Nice post thanks.
    I m using free check printing utility.
    Try - www.xltool.in

    ReplyDelete
  13. Great blog! Bank check designs come in an unlimited array of styles prints and patterns. now you are able to add your own custom designs to checks or even make your own photo checks with customized check designs.Thanks.Learn more

    ReplyDelete
  14. Nice post! Having a checkbook that defines the individualism of depositors can be quite difficult to do on their own because of the possibility of infringing on legality issues.
    Reorder Checks

    ReplyDelete
  15. Nice Post! If you’re using your checks for business, don’t worry because there are some people who’ve decided to go for a more formal look by keeping the original design of their checks, except they’ve added a few more helpful information that their clients can use. Learn More

    ReplyDelete
  16. Great info! The traditional way of ordering and reordering checks is through a request at your bank or credit union to issue a batch for you. Though this can be the most known way of how to order checks, most people these days don’t go through their banks anymore.
    Find your bank

    ReplyDelete
  17. Very Nice Post.
    I am using Free WELL Bank Cheque Printing Software.
    Try - http://www.xltool.in

    ReplyDelete
  18. Good Information,All we will need to order our checks is our personal address information and banking information in the proper check format in order to be accepted and considered as legitimate checks.
    Learn More

    ReplyDelete