Instructables

Cheque printing without special software or Printer with Excel (check print)

Picture of Cheque printing without special software or Printer with Excel (check print)
14TODAY.png
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.

 
 
Remove these adsRemove these ads by Signing Up

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

Picture of 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





Step 2: 2)open excel program and enable macros.

Picture of 2)open excel program and enable macros.
67TODAY.png
2)open office excel program and enable macros.

A) if you  already have enable macros in you computer. The following yellow massage will appear.
the Message Bar appears.
When you open a file that has macros, the yellow Message Bar appears with a shield icon and the Enable Content button.
On the Message Bar, click Enable Content.
The file opens and is a trusted document.

B)if you not enable macros: do like this.
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.

The following image is the Macro Settings area of the Trust Center.


Step 3: 3) now open the save excel file.

Picture of 3) now open the save excel file.
3) now open the save excel file.

Three are three work sheets .
1st sheet for your check detail (Name,Amount.
2nd check printer.
3rd sheet for  your customer/supplier list.

Step 4: 4) now you have to scan one of your cheque leaf from your cheque book as a picture and insert it to second sheet.

Picture of 4) now you have to scan one of your cheque leaf from your cheque book as a picture and insert it to second sheet.
75TODAY.png
71TODAY.png
According to your bank check Size and format leaf will be difference.
Drag the check leaf to the first check margin and drag and drop the check details to the correct place of check picture.
After you drag all cheqe details to correct place. Remove check scan copy.
Now you can copy & paste first cheqe margin to down for 10 check

ex: see the pic. of cheque leaf:
jibin0001 month ago

would please explain how can print in cheque in step vice

virtualsplat4 months ago

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

rrd11117 months ago

I am not able to download it please tell how to do

For work with excel files try to use .xlsx repair

http://www.xlsxrepairtoolbox.com supports any version of Microsoft Excel application
bkakkattil1 year ago
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
lemonie1 year ago
People have been moving towards electronic transfers for years, can you provide software that writes you a BACS data file?

L
bandara (author)  lemonie1 year ago
Thanks for your suggestion. I have idea and plan to create database program to create TT & electronic transfer. If you have, can you kindly forward me some electronic transfer forms with difference bank.
For working with excel files make use of repair xlsx files

http://www.repairxlsx.xlsxrepairtoolbox.com recovers cells, fonts, colors, borders, content, formulas and other items