Introduction: Cheque Print Without Special Software or Printer With MS Excel (Bank Checks Print)

Picture of Cheque Print Without Special Software or Printer With MS Excel (Bank Checks Print)

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

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 with my blog or google group.
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.

Picture of 1) Save Attached Excel File to Your Computer in Your Favorites Folder.

1) save the Ms Excel file to your computer in your favorites folder. if you download it form my blog..





Step 2: 2)open Excel Program and Enable Macros.

Picture of 2)open Excel Program and Enable Macros.

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.

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:

Step 5: 6)go to First Page. Select Suppliers and Enter Amounts. It Will Update Second Cheque Print Sheet.

Picture of 6)go to First Page. Select Suppliers and Enter Amounts. It Will Update Second Cheque Print Sheet.

6) Open the 1st work sheet. Select suppliers and enter amounts you want to pay.

It will update 2nd cheque print sheet.
you can save the 1st sheet details for your records before enter the next check lists.

Step 6: 7)print Preview and See All Are Correct. First Print Test Page and See All Margins Are Ok. If Not Drag to Correct Place and Save.

Picture of 7)print Preview and See All Are Correct. First Print Test Page and See All Margins Are Ok. If Not Drag to Correct Place and Save.

7) Print preview and see all are correct. First print test page and see all margins are ok. If not drag to correct place and save.
J.M.N Bandara

  • You can free download very useful INVOICE AND PAYROLL SYSTEM I created to give to world free...with my Site





Comments

jaswinder singhB1 (author)2017-09-03

please send the file by email. my email ID jaswinder1975@gmail.com thank you

darkgraven (author)2017-06-27

Kindly email it to me too.. my email is r.puertollano@yahoo.com

Fishtalel (author)2017-04-30

pls email the file to Diwash.pokharel@outlook.com. Thank You

sadyblossom (author)2017-04-03

please email the file to suzanneclarkbennett@gmail.com. I am unable to download. thank yo.

mhmalsuwaidi (author)2017-03-14

please send it

mhmalsuwaidi@hotmail.com

GeorgeV13 (author)2015-11-17

I got cheque printing with the help of excel & word using mail merge...

1. Automatic covertion of amount to words (paisa excluded)

2. Drop down list of parties

if any one need please mail me (no charges) jijanvg@gmail.com

AkberA4 (author)GeorgeV132017-02-15

I NEED HELP HOW CHEQUE PRINT

AkberA4 (author)AkberA42017-02-15

HOW ITS PDF FILE DOWNLAOD

nayia01 (author)GeorgeV132017-02-01

I would love if you could send me that file as well to Nayia01@aim.com

Thanks so much!!!

srikantj1 (author)GeorgeV132017-01-31

Hey pls mail me that file to mail id sriksnites@gmail.com

RaymondW36 (author)GeorgeV132017-01-25

please send a copy to me. many thanks!

1@btltx.com

rebsite (author)GeorgeV132017-01-25

pls kindly send to rebeccang@ctc.org.hk that would be very helpful. thanks!

KIRAN1492 (author)GeorgeV132017-01-19

PLEASE MAIL IT TO ME ON KIRAN.JAIN@LIVE.COM

Saran_dharun (author)GeorgeV132017-01-16

kINDLY SEND TO MY MAILID mithileshyash@gmail.com

VickySoni3 (author)GeorgeV132017-01-05

Hellow George can u plz send me that file on this
Vijay.tilokanee@gmail.com

SunilS94 (author)GeorgeV132016-12-31

Hi George

please send me that file, i need desprately.

my mail id is - sunilhonest1984@gmail.com

niravsukhiyaji (author)GeorgeV132016-12-25

please send me that file

MaryJ102 (author)GeorgeV132016-12-02

can you please send to my email..

grace.prmhomesleisure@gmail.com

Thank you..

ShriniwasG (author)GeorgeV132016-10-03

Hi,

Pleased if you share the same on my email shrineemail@gmail.com

Thanks a lot..

Shriniwas Gorintala

udaykumar309 (author)GeorgeV132016-02-08

Hi George

can you pls send this to me at udaykumar309@gmail.com ?

fazal Qadir (author)GeorgeV132015-12-29

fazal.qadir86@yahoo.com

please send details on above said mail address.

azedrisjamil (author)2017-02-14

please send me that file too on azedrisjamilzesta@gmail.com.

thanks in advance

NituK (author)2017-02-03

Try XLTOOL Bank Cheque Printing Software. Unlimited cheque printing possible with different currencies.
Link - http://www.xltool.in/cheque-print.html
Link - http://www.xltool.in

KIRAN1492 (author)2017-01-19

PLEASE MAIL IT TO ME ON KIRAN.JAIN@LIVE.COM

LanceCox (author)2017-01-10

Intuit developed accounting software named QuickBooks for small business. It has every aspect to make your business look more professional and manage whole economical details. One feature of this software is the ability to print error free checks like https://www.checkomatic.com/business-checks/printed/ . It provides great protections against fraud by defining address and contact information of the vendors.

HadyJ (author)2016-12-11

Thank you! What if I want to print multiple currencies like in the software http://chequeone.com ? Currently it prints only dollars

hiashvin (author)2016-09-06

wher is atached file

MohammedI56 (author)2016-08-16

i can't find excel file could you please send it to mail id: md.imran822@yahoo.com

bingbing2016 (author)2016-08-04

where is the excile file? i cant find it

ManojK158 (author)2016-07-25

Hi, please send cheque printing in excel & word

shakilj (author)2016-06-02

Hi, please send cheque printing in excel & word on my mail.id.sagarscreeners@gmail.com

RamNbnscoe (author)2016-01-04

The best cheque printing software i have ever seen..

It includes Automatic conversion of amount to word and also import values from excel and other dynamic features.

if u want please connect..

www.printacheque.com

ppsheth@gmail.com

amrhashim (author)2015-05-30

thanks ,,,, but i think , it'll be good if you post video explains the steps in details

HadyJ (author)2015-03-09

Thank you! What if I want to print multiple currencies like in the software http://chequeone.com ? Currently it prints only dollars

HadiA2 (author)2015-02-28

Hi,

but i'm knowing how to scan it and drag it well plz can u show me how

HadiA2 (author)2015-02-28

Hi,

but i'm knowing how to scan it and drag it well plz can u show me how

VineetC (author)2014-12-12

is there a way not to print Dollar, Cents while printing the amount in words? We have different currency out here in India

" One Hundred only" would be better than " One hundred dollars and no cents"

AliH12 (author)VineetC2015-02-14

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 :)

johnny.vega.7106 (author)2015-02-09

Can you point out what is a check leaf?

johnny.vega.7106 (author)2015-02-09

What is the "check leaf"?

KrysiaB (author)2014-12-03

Is there any way to use the Company Address - for window envelopes for example?

sudhersonapex (author)2014-11-18

nice

sudhersonapex (author)2014-11-18

nice

chaxstore (author)2014-11-02

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 :)

jibin000 (author)2014-09-17

would please explain how can print in cheque in step vice

virtualsplat (author)2014-06-19

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

rrd1111 (author)2014-03-01

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

nikkyjohnson (author)2013-04-05

For work with excel files try to use .xlsx repair

http://www.xlsxrepairtoolbox.com supports any version of Microsoft Excel application

bkakkattil (author)2013-03-26

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

stevenphilips37 (author)2013-02-11

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

About This Instructable

414,916views

22favorites

License:

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 WYGWORLD:INVOICING BILLING AND INVENTORY CONTROL SYSTEMDesign a form filling database using Microsoft access.Flower Vars from newspaper tube
Add instructable to: