Customizing Check Printing

Because of differences in font sizes and row and column spacing between different Excel versions, different System versions, and different printers, our check blanks may not print exactly right on your setup. In that case you will need to customize the blanks to get them to fit. You will also need to do this if printing on brands of pre-printed checks that are different from the ones supported by the MacNail accounting software.

NOTE-- In 2000, we replaced MacNail with Goldenseal construction accounting software.We still include these instructions on our website, for die-hard users of our original MacNail Accounting software. Goldenseal is an integrated program that includes general accounting, job costing, payroll and project billing, plus estimating and other features. You'll use the Custom Layouts command in Goldenseal, to change the layout of checks or printed forms.

To adjust row and column positions, follow these steps:
1. Open the Paycheck Blank and/or Check Blank file that you are using.
2. Choose Unprotect Document from the Options menu (if the command says Protect Document, it is already unprotected).
3. Choose Display from the Options menu, and turn on 'Row and Column Headings' if they are not already visible.
4. You can now 'tweak' row heights or column widths to adjust the location of each item. Widening a column width will shift things to the right, while making it more narrow will shift things to the left. Similarly, widening a row height shifts things down, and making it more narrow raises that row and every row beneath it.
5. Once things look good, make a test print on plain paper, and hold it up to the pre-printed forms to make sure each item is positioned correctly. You may need to make several test prints to get things lined up exactly!
6. Once the Blank is printing correctly, choose Protect Document from the Options menu, then choose Save from the File menu.
7. All future checks printed from the modified Blanks will use the new setup.

If you want to make more serious modifications to any of the check-printing files, you can also:
*Cut and paste each name on the check blank so it prints in a different location.
*Make a new cell equal to an existing cell, so the same information is printed in more than one place (for example, when printing on two- or three-part checks).
*Add 'stock' information that will print on every check-- simply type it into a blank cell. For example, to have today's date entered into a cell, enter the formula =NOW() into the cell where you'd like the date to appear. You may need to adjust the number formatting so it appears correctly!