Cheque Printing Template In .xls

Cheque Printing Format in Excel Free Download (.xls file Download) Hi Friends, I have made a cheque printing format in excel. This will help you to make the cheque very quickly. In this format you just need to enter the “Name on Cheque” then Enter the “Amount on Cheque” and what will be the Date of Cheque. Mar 28, 2018 You just need to pick the appropriate templates, fill in your details and you are able to find the ideal cheque template in your hand the moment you take a print out. You will also receive oversized check template free when it has to do with making presentations for charity events. If you operate a business you comprehend the value of Invoicing.

Cheque Printing Template In .xls Business
Cheque Printing Template In .xls Excel

CHECK PRINTING TEMPLATES

CHECK PRINTING TEMPLATES
by Jim Kaness

Printing (filling in the blank spaces on) individual personal (2 3/4' by 6') bank-checks with a personal computer and printer is quite possible, but not common. Fortunately, to facilitate machine reading of the checks, the blank spaces for filling in the recipient and the amounts are all standardized in the United States for checks on any bank. I cannot speak for other countries (NEW: See link above for Canadian personal cheques). If your handwriting is as bad as mine, or if you want to prepare a check that is difficult to alter, this can be quite useful.

Please note that creating and printing a complete check on blank paper is not possible without special magnetic ink and its font for the bottom line containing the bank routing and account numbers. See Bank of America Check Specifications for more on this.

The free-gratis downloadable ODS, XLS, and XLSX files below were made under LibreOffice Calc 4.2.6.3 and are in portrait letter. Margins are set to zero. These files offer a separate Data Entry Section and a separate Page Preview Section of how the check will look when printed. The Page Preview Section is the only part of the file that is printed on your check. These worksheets are now password (123) protected against any accidental changes EXCEPT for contents of the five data entry boxes which you are free to change.

The two Microsoft Excel files below were made under LibreOffice Calc 4.2.6.3 and saved as Microsoft Excel files (XLS and XLSX) and verified using Microsoft Excel running under Windows XP, and with the Microsoft Conversion Module for the newer format (XLSX).

Below are photos of the actual worksheet and one of my checks printed from that (routing and account numbers blurred).

TO USE THIS TEMPLATE:
1. Download and save the file. (See DOWNLOADS below)
2. Open the file and edit each of the five data entry boxes to say what you want it to say.
3. Remove a blank check form from your checkbook.
4. Attach the blank check form in the exact upper left corner of an 8 1/2' by 11' printer paper using about 3/4-inch of double sided tape (or about 2-inches of single sided tape folded over on itself sticky side out) between the center of the check form and the printer paper. Insert that paper into the printer as you would any other page to print on.
5. Print the check as with any other page.

TIP- You might want to print on a blank sheet of paper first to get the hang of this.

NOTE 1: My HP Officejet 1350 and HP Officejet 4500 printers will accept a personal check blank and print it. My new HP Envy 4500 will not. The solution, which will work for nearly any printer, is to attach the blank check form in the exact upper left corner of an 8 1/2' by 11' printer paper using about 3/4-inch of double sided tape (or about 2-inches of single sided tape folded over on itself sticky side out) between the center of the check form and the printer paper. Insert that paper into the printer as you would any other page to print on. It works for me.

NOTE 2: This same approach could be used to fill in the blanks on business checks or any other pre-printed form by sizing the rows and colums of the spreadsheet to fit your form. The business checks available to me have all been so radically different in overall size and in the location of the data that I am unable to offer a single template for them.

NOTE 3: The Page Preview Section is the only part of the file that is printed on your check form. You can change the font to anything you like by separately highlighting each entry and selecting the font, color and style of your choice. But, I suggest you use an easily readable font!

NOTE 4: These templates do not provide for printing your signature on your check form. If you wish, you can write your signature on a blank piece of paper, scan that paper, and crop the scan so you have a small photo of your signature. This photo of your signature can then be inserted (and sized) in the appropriate location in the Preview Section. It works for me.

DOWNLOADS (Free of Charge. For use by Anyone.)

To download the 42 KB (checktemplate.ods) LibreOffice Calc template file for personal (2 3/4' by 6') checks,click on Personal Check Template ODS

To download the 16 KB (checktemplate.xls) Microsoft Excel XLS template file for personal checks.click on Personal Check Template XLS

To download the 6 KB (checktemplate.xlsx) Microsoft Excel XLSX template file for personal checks.click on Personal Check Template XLSX

BACK TO ENGINEERING MENU

Hong Kong Banks:

If your bank is not listed in the printed cheque examples below, please visit here to get support for your bank.

The Hongkong and Shanghai Bank (HSBC) - 香港上海匯豐銀行:

The Hongkong and Shanghai Bank - Pink Cheque (HSBC) - 香港上海匯豐銀行:

The Hongkong and Shanghai Bank - Premier (HSBC) - 香港上海匯豐銀行:

Bank Of China - 中國銀行:

Hang Seng Bank - 恒生銀行:

Hang Seng Bank (Personal) - 恒生銀行:

Hang Seng Bank (Prestige) - 恒生銀行:

Dah Sing Bank - 大新銀行:

Dah Sing Bank (i-Account) - 大新銀行:

Dah Sing Bank (VIP Banking) - 大新銀行:

Standard Chartered Bank - 渣打銀行:

Standard Chartered Bank (Priority Banking) - 渣打銀行:

DBS Bank - 星展銀行:

DBS Bank (Personal) - 星展銀行:

DBS Bank (Treasures) - 星展銀行:

Fubon Bank - 富邦銀行:

Fubon Bank (Personal) - 富邦銀行:

Nanyang Commercial Bank - 南洋商業銀行:

Sumitomo Mitsui Banking Corporation - 三井住友銀行:

Wing Hang Bank - 永亨銀行:

Citibank - 花旗銀行:

Citibank (Personal) - 花旗銀行:

ICBC Bank - 工銀亞洲:

ICBC Bank (Elite Club) - 工銀亞洲:

ICBC Bank (Personal) - 工銀亞洲:

Citic Bank International - 中信銀行國際:

China Citic Bank International - 中信银行(国际):

China Citic Bank International (Citic First) - 中信银行(国际):

BEA Bank (Corporate) - 東亞銀行:

BEA Bank (Personal) - 東亞銀行:

Shanghai Commercial Bank - 上海商業銀行:

Shanghai Commercial Bank (Personal) - 上海商業銀行:

Wing Lung Bank - 永隆銀行:

Wing Lung Bank (Personal) - 永隆銀行:

China Construction Bank (Asia) - 中國建設銀行(亞洲):

China Construction Bank (Asia) (Personal) - 中國建設銀行(亞洲):

OCBC Wing Hang - 華僑永亨銀行:

OCBC Wing Hang (USD) - 華僑永亨銀行:

OCBC Wing Hang (Personal) - 華僑永亨銀行:

Bank of America - 美國銀行:

Chiyu Banking Corporation - 集友銀行: