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.
Step 2: 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.
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.
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.
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.
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.
- You can free download very useful INVOICE AND PAYROLL SYSTEM I created to give to world free...with my Site