How to Create an Excel Template for Preprinted Checks

Printing financial details onto physical check stock requires precise spatial alignment to ensure the date, payee, and monetary amounts fall exactly on the preprinted lines. If you rely on physical checkbooks for payroll or vendor payments, automating this process reduces manual errors and saves time. Understanding the process of creating an Excel Template for Preprinted Checks allows you to build a reusable digital layout that correctly matches your physical paper format. The workflow involves determining the exact physical coordinates of your check fields, replicating those dimensions within a spreadsheet environment, and conducting test prints to help ensure consistent alignment.

Workspace Preparation to Create an Excel Template for Preprinted Checks

Before launching your spreadsheet software, you must gather physical measurements of your check stock. The foundation of working to create an Excel template for preprinted checks is establishing an accurate mathematical map of the paper. Grab a standard ruler, a blank preprinted check, and a pencil. You need to measure the exact distance from the top-left edge of the paper to the starting point of every fillable field.

Measure the horizontal and vertical distances for the following required elements:

• Date Line: Measure from the top edge down to the line, and from the right edge inward.
• Payee Line: Measure the drop from the top edge to the "Pay to the Order of" line.
• Numerical Amount Box: Locate the exact vertical and horizontal starting point for the numerical value.
• Written Amount Line: Measure the distance to the line where the text version of the currency sits.
• Memo and Signature Lines: Note the bottom-left and bottom-right coordinates.

Write these measurements down in inches or centimeters. Identify whether you are working with standard personal checks, voucher checks, or three-to-a-page business checks, as this determines your overall page size and margin settings in the next steps.

Create an Excel Template for Preprinted Checks

The most visually intuitive method for creating an Excel Template for Preprinted Checks is using a scanned image of your blank check as a temporary guide. This allows you to position text boxes visually without relying entirely on abstract ruler measurements.

Follow these precise steps to align your fields using a background image:

1. Place a single blank preprinted check into your scanner and save the image as a high-resolution JPEG or PNG file. Ensure the scan is completely straight and scaled to 100% of the original size.
2. Open a blank spreadsheet workbook. Navigate to the Page Layout tab on the top ribbon.
3. Click the Background button (or Print Titles > Background) and select your scanned check image from your local drive. The check will tile across the spreadsheet background.
4. Go to the Insert tab, click Text Box, and draw a box directly over the Date field on the background image. Repeat this process, drawing separate text boxes over the Payee, Amount, Written Amount, and Memo fields.
5. Remove the borders and fill colors from these text boxes. Right-click each box, select Format Shape, set the Fill to No Fill, and the Line to No Line.
6. Link these text boxes to a data entry area. Click the edge of the Date text box, click into the formula bar at the top of the screen, type =A1, and press Enter. Now, whatever you type in cell A1 will appear in the correctly positioned text box. Link the remaining boxes to A2, A3, etc.
7. Load standard plain white paper into your printer. Print a test page of your active sheet.
8. Take the printed white paper, place it directly on top of your physical preprinted check, and hold both sheets up to a bright window or light source. Verify that the printed text falls exactly on the preprinted lines. Move the text boxes in the spreadsheet slightly if adjustments are needed.
9. Crucial final step: Once alignment is perfect, navigate back to the Page Layout tab and click Delete Background. You must remove the image so the spreadsheet only prints the text onto your real check stock.

Alternative Ways to Create an Excel Template for Preprinted Checks

If you prefer a structured grid over floating text boxes, you can manipulate row heights and column widths. while working on creating an Excel Template for Preprinted Checks, many users favor this method for bulk-printing three-to-a-page business checks, as it keeps data locked into rigid cells.

1. Open a new spreadsheet and navigate to the View tab. Click Page Layout. This view changes the column and row headers to display real-world measurements (inches or centimeters) on a digital ruler.
2. Select the entire sheet by clicking the triangle in the top-left corner intersecting the rows and columns.
3. Click and drag the column dividers to match the horizontal measurements you took with your physical ruler. For example, make Column A exactly 1.5 inches wide to push the Payee text to the right.
4. Adjust the row heights to match the vertical drops. Drag the bottom edge of Row 1 down to match the distance from the top of the paper to the Date line.
5. Type sample text (e.g., "John Doe", "150.00") into the intersecting cells. Use the alignment tools on the Home tab to set the text to Bottom Align and Left Align so the text rests naturally on the physical lines.
6. Print a test on plain white paper, verify the alignment against a real check using a light source, and fine-tune the column widths and row heights until perfect.

Use WPS Office for Local Files Related to Creating an Excel Template for Preprinted Checks

while working on creating an Excel Template for Preprinted Checks solves the alignment challenge, distributing that template to employees can cause issues if someone accidentally drags a column and ruins the formatting. WPS Office offers an excellent workflow to secure your layout. Because Windows and Microsoft handle standard print spooling, WPS cannot override your physical printer's hardware margins, but WPS Spreadsheet excels at finalizing and locking page layouts.

Once you have perfected your row and column alignment in WPS Spreadsheet, you can leverage the WPS PDF tool to create an unalterable fillable form. Save your correctly spaced spreadsheet as a PDF using the built-in Export to PDF feature found in the Menu tab. Open this newly created PDF in WPS PDF, navigate to the Form tab, and insert Text Fields directly over your aligned data zones. By saving this interactive PDF, you provide your team with a foolproof check-printing template. They can simply type the payee and amounts into the PDF form fields and print directly to the check stock, ensuring the underlying spatial coordinates are completely locked and immune to accidental spreadsheet edits.

Use Word, Excel, and PPT for FREE

Free Download

FAQs

Why is the printed text misaligned even though the template looks correct on screen?

Printer feed mechanisms often pull thick check stock at slightly different angles or starting points compared to standard paper. Ensure your printer's physical paper guides are snug against the edges of the check stock. If the text is uniformly shifted down or to the right, do not rebuild your entire spreadsheet grid. Instead, go to the Page Layout tab, open Page Setup, and adjust the Top and Left margins by a fraction of an inch to compensate for your specific printer's hardware pull.

Can I automatically convert numerical amounts to written text in my template?

Spreadsheet software does not feature a native, out-of-the-box function to convert a number like "150.00" into "One Hundred Fifty and 00/100". To achieve this, you must rely on custom scripting. You can implement a Visual Basic for Applications (VBA) macro commonly known as the "SpellNumber" function. Once the VBA code is added to your workbook's developer module, you can type a formula like =SpellNumber(B2) into the written amount cell to automate the text generation.

How do I handle formatting for three-to-a-page business checks?

For multi-check pages, you must configure your spreadsheet to a standard Letter size (8.5 x 11 inches) rather than custom check dimensions. Complete the exact alignment for the top check using either the background image or cell dimension method. Once the top check is perfect, copy the entire block of formatting and paste it further down the sheet. Measure the distance between the perforations on your physical stock to ensure the vertical spacing between the first, second, and third check zones correctly matches the physical page.

What is the most reliable font size and style for check printing?

Banks use Optical Character Recognition (OCR) technology to scan and process physical checks automatically. To ensure your checks clear without manual bank intervention, use standard, highly legible sans-serif fonts such as Arial, Calibri, or Tahoma. Avoid cursive, handwriting, or overly bold decorative fonts. Set your font size between 10 and 12 points. For the numerical amount box, ensuring the font is clear and well-spaced is critical for automated banking scanners.