Monday, July 25, 2016

Cheque printing without special software or Printer with Excel

Print your office or personal bank Checks 
simply  using MS Excel for your business.

This is a simple worksheet, will very useful for you if you write lot of checks 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.

You can use your normal printer and your computer to print 100s of checks soon.

First you have to enable macros to your excel work sheet.

This simple a excel work book, You can download it free. and play....

You have to do only few things to set your checks ready to print.

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 mane bar. 
A) Click Enable Content button.

The file will open as a trusted document.

B) If you not enable macros in your excel program file not work properly:

How to do it :  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 .
  1. first one for your cheque detail. (chdetails)
  2. second cheque printer (cheqprint)
  3. Third one your 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 age.

According to size of your bank check, format of leaf will be difference.

Drag the check leaf to the first check margin ...,
and drag and drop the  details to the correct place of check picture.

See the green color drop it can move to any place.
After you drag all cheque details to correct place. Remove check scan copy.
Now you can copy & paste first cheque margin to down for 10 checks.

Now enter your payee list and save. When you need to create checks just go to checks details sheet. 
  • select the payee name form drop down list.
  • enter the amount
  • 10 checks you can print in one time easily.

what you give to world

If this is useful for you pl give a comment...

Direct download with Google Drive