Your comment.

Cheque writer

This cheque writing software is a Microsoft Excel file.
(If you find this useful, please donate using Paypal by clicking the button below. You dont have to be a member of PayPal to make donation).

Sample 1 :

How to operate :
Write the amount in cell A1.(The font colour of cell A1 is set to white so that it won't print).
Data Validation is used in cell B4 to enable us to select a payee.
The Date elements in cells H2 to M2 are extracted using formula. Have a look at the formula.
There is a formula in cell C5 to get the word. Have a look at the formula.
There is a formula in cell G5 to get the number from cell A1. Have a look at the formula.
To download this sample, click here.


Sample 2 :

In this sample, a button is used to insert the current date into cells H2:M2.



To download this sample, click here.


Sample 3 :

In this sample, a button is used to insert the amount into cells G5, instead of writing into cell A1.



To download this sample, click here.


Sample 4 :

In this sample, the payee name in cell B4 is surrounded by 2 asterisks at both end.



To download this sample, click here.


Sample 5 :

In this sample, the wording in cell C5 is surrounded by 2 asterisks at both end.



To download this sample, click here.


Sample 6 :

In this sample, the amount in cell G5 is surrounded by 3 asterisks at both end.



To download this sample, click here.


Sample 7 :

In this sample, the payee name (in cell B4), the wording (in cell C5) and the amount (in cell G5) are surrounded by 2 asterisks at left-end and many asterisks at right-end.



To download this sample, click here.


Sample 8 :

In this sample, we put RM and Cents in the wording.



To download this sample, click here.


Sample 9 :

In this sample, we add the word ONLY to the wording.



To download this sample, click here.


Sample 10 :

In this sample, we combine a few items :
   Full asterisks
   RM, Cents and ONLY



To download this sample, click here.


Sample 11

No RM, has asterisk, has the word ONLY : May be follow new Bank Negara requirement.



Click here


Sample 12 - for Qatar :

Some visitors from Qatar request for QRs instead of RM.



To download this sample, click here.


Sample 13 :

In this sample, we use a DropDown Control to select a payee. The DropDown coontrol will not get printed.


To download this sample, click here.


Test first :

1. Make a photocopy of one cheque.
2. Cut it to accord to actual size.
3. Try printing on it.
4. See the result.
5. If you are not satisfied, change relevant settings such as margins etc.
6. After you satisfy, only then you can be sure to print on the actual (real) cheque.

List of Payees :

In the sample, you put the payee name in cell B4. In the sample, the cell B4 contains a formula :

=INDEX(PayeesList,F1)

"PayeesList" is the name for a dynamic range of cells which contains the list of payees in sheet Payees.

The range refers to this formula :

=OFFSET(Payees!$A$2,0,0,COUNTA(Payees!$A:$A),1)

(To give a range a name, use menu Insert .. Name .. Define).

You can write directly the payee name into the cell.

Printing :

You print using the ordinary printer. The combo box where you select the payee name will not get printed.

I have cheque from more than one bank :

If you have another cheque, with different width and height of its columns, you can copy this sheet into a new sheet using menu 'Edit | Move or Copy Sheet'. You can rename the new sheet. Then, set the width and height of relevant columns in the new cheque in the new sheet.

Changing sheet name :

You can change a sheet's name, may be to reflect the name of the cheque's bank. However, never change the sheet with name "Payees". It should be permanent.

Setting margin, height and width manually :

You can set the margin, height and width manually using menu File , Page Setup.

Problem ?

If you encounter any problem, do not hesitate to get in touch with me, immediately via E-mail : ibh1@live.com or Tel : 012-3243154.

Donation

If you find this item is useful, you can make donation to me by topping-up my handphone no. DIGI 017-3268109 (Yes, this is a DIGI number, NOT Maxis number). Or You can pay via PayPal by clicking on the Paypal button on top of this page. Any amount is appeciated.

System :

This program is tested fine on Excel XP.

Interested in the code ?

If you are interested to get the code, you can request from me. I need a payment of RM50 or equivalent USD amount. You can pay by using the Paypal 'Donate' button above or top up my Maxis 012-3243154. After paying, let me know by email to ibh1@live.com. I will email you the code within one week.

Modification :

You can modify the system as you wish on your own, or you can contact me to make modification for you.

Contacting the author :

E-mail : ibh1@live.com
Tel : 012-3243154