CHECK PRINTING TEMPLATES 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. 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 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. Does Microsoft Office have a template to write business checks? If not, could you please recommend some free software to simply print business checks? I already have printed business checks so I don't need to actually create the check with account numbers, etc. I just want the software to allow me to input. Feb 25, 2013 Does Microsoft Office have a template to write business checks? If not, could you please recommend some free software to simply print business checks? 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 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. Remove a blank check form from your checkbook. 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. 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 To download the 16 KB (checktemplate.xls) Microsoft Excel XLS template file for personal checks. Click on To download the 6 KB (checktemplate.xlsx) Microsoft Excel XLSX template file for personal checks. Click on Copyright © by Jim Kaness. Also - do a web search for something like 'blank check templates for Excel' - you'll get some hits. A template for Word: Now - if you do acquire pre-printed forms to use, then what you'll need to do is scan a few of those and start setting up the printout from Excel to properly enter the information onto those forms. That'll be a bit by trial-and-error in setting up row heights, column widths and font size. That's the reason for using scanned copies - so you don't use up all of the real thing getting your layout right. One thing you're probably going to want is a 'numbers-to-words' routine, and there are lots of those around - here's just one: I am free because I know that I alone am morally responsible for everything I do. You might check with your banking institution to see if they don't have pre-printed forms with a template to use with either Excel or Word to do this. Otherwise you have to simply spend the time to create a layout on a worksheet that looks like a check you'd like to use - the tough part is the account/routing information at the lower left (usually) portion of the check. You'll probably need to scan that in from a check then cut out that section, saving it as a graphic and pasting it into your form. Additional problem there is that on my personal checks, the check number is also shown in that special font to the right of the routing/account information - and that needs to match up for the machine readers that will examine your check later. I'm not sure if any of the fonts available in Windows/Word/Excel match the one used for that section of the check. Now, if you were doing this in Access it would be easier - you could actually use a modified scan of a check as the background for a 'report' and overlay it with data fields to represent check number, date, payee, the numeric and word amount entries along with an annotation about the check. But you're still presented with the problem dealing with the routing/account/matching check number section. I am free because I know that I alone am morally responsible for everything I do.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |