✦Template Printable Ideas Insights

How to Print Checks from Excel: A Step-by-Step Guide

By

Ever found yourself in need of printing checks but detained by the prospect of tediously filling out each one by hand? With Microsoft Excel at your disposal, you can streamline this process and save both time and effort. This detailed guide will walk you through the process step-by-step, enabling you to print checks efficiently and accurately.

Before we delve into the nitty-gritty of printing checks using Excel, let's ensure you have the necessary tools. You'll need a printer capable of printing on check stock, which is thicker than regular paper. Additionally, you'll require check stock compatible with your printer and the number of checks you wish to print.

Preparing Your Excel Workbook

To commence, open a new or existing Excel workbook. For this demonstration, we'll assume you're working with a new file. The first step is to format your cells to accommodate your check information.

an image of a table with numbers and times on it in the form of a calendar
an image of a table with numbers and times on it in the form of a calendar
PAYROLL CHECKS USING EXCEL READY TO PRINT
PAYROLL CHECKS USING EXCEL READY TO PRINT
Print mass Checks automatically V02 with Tutorial Video
Print mass Checks automatically V02 with Tutorial Video

Typically, checks comprise several key components, such as the payee's name, the amount, the date, and your account number. For each of these fields, create a separate column in your Excel sheet. For instance, in cells A1 to E1, you might title your columns 'Payee', 'Amount', 'Date', 'Memo', and 'Account Number'.

Entering Check Data

Once your columns are set up, begin populating the cells with the relevant information. If you're printing multiple checks, you'll want to enter data for each one in a separate row. To maintain accuracy, ensure that each field corresponds with the correct column.

Checks Template Word | Template Business
Checks Template Word | Template Business
The simple way to add check marks in Excel!
The simple way to add check marks in Excel!
Pieter (haasbroekpieter) - Profile | Pinterest
Pieter (haasbroekpieter) - Profile | Pinterest

For example, if your first check is to be made out to 'John Doe' for $500 on January 15, 2022, with the memo 'Salary' and account number '123456789', your first row might look like this:

  • John Doe
  • $500.00
  • 01/15/2022
  • Salary
  • 123456789

Formatting Your Data

Now that your check information is entered, it's time to format your data to ensure it appears correctly on your checks. First, select the cells containing your data and click the 'Merge & Center' button in the 'Home' tab under 'Alignment'. This will ensure your text is centered within each check field.

Next, adjust the font size and style according to your check's design. If your checks feature pre-printed text, you may need to adjust your data's positioning to align with these elements. You can do this by selecting your cell, clicking the 'Merge & Center' button again, and then using the arrow keys to precisely position your text.

Best Check Printing Software
Best Check Printing Software
How to create an excel checkbook register
How to create an excel checkbook register
How to Insert a Check Mark (Tick ✓) Symbol in Excel [Quick Guide]
How to Insert a Check Mark (Tick ✓) Symbol in Excel [Quick Guide]
Cheque Print Without Special Software or Printer With MS Excel (Bank Checks Print)
Cheque Print Without Special Software or Printer With MS Excel (Bank Checks Print)
How to Use Excel Checkboxes | Interactive Checklists & Reports
How to Use Excel Checkboxes | Interactive Checklists & Reports
Printable Check Register Template, Checkbook Register Log, Expense Tracker Sheet, Google Sheets, Excel Template
Printable Check Register Template, Checkbook Register Log, Expense Tracker Sheet, Google Sheets, Excel Template

Settings Up Your Printer for Check Stock

Before printing your checks, you'll need to ensure your printer is configured to use check stock. Most printers require you to load check stock manually, rather than using the automatic feeder. Consult your printer's user manual for specific instructions.

Additionally, you'll need to adjust your printer's paper size settings to accommodate check stock. In most cases, this will be a standard letter size (8.5 x 11 inches), but it's essential to confirm this with your specific check stock supplier.

Printing Your Checks

With your printer configured and your check data formatted, you're ready to print your checks. Select the cells containing your check data and navigate to the 'File' tab. Click 'Print', and in the 'Printer' section, ensure your correct printer is selected.

Checkbook Register Template for Excel
Checkbook Register Template for Excel
Editable Business Checks Template | Printable Business Check PDF | Canva Business Check Template | Blank Office Checks
Editable Business Checks Template | Printable Business Check PDF | Canva Business Check Template | Blank Office Checks
Printable Checkbook Register Template
Printable Checkbook Register Template

In the 'Settings' section, make sure the paper size is set to 'Letter'. Under 'Scaling', select 'Fit to' and ensure the 'Printable area' option is selected. This will ensure your checks print at the correct size. Finally, click 'Print' to commence printing your checks.

Reviewing and Storing Your Checks

Once your checks have been printed, carefully remove them from your printer and review each one to ensure the data printed correctly. If any checks are incorrect, you can void them by writing 'VOID' across them in a manner that obscures the printed data.

Upon reviewing your checks, store them carefully until they're ready for use. Remember to keep them secure to prevent fraudulent activity.

Now that you know how to print checks using Excel, you can streamline your accounting processes and save time and effort. The next time you need to print checks, you'll be able to do so quickly and efficiently. Happy printing!