Download template from this google docs link.
By J.Archer (Own work) [CC BY 3.0], via Wikimedia Commons |
Reminders
Please enable macros when prompted.
Create custom paper size for your printer 8" x 3" or 8"x5" and name it "check"
Entering data
Enter data in 2nd sheet - check info.
Enter "date" and "amount numbers" only. Excel will convert amount in numbers to words automatically.
Enter payee name in 1st sheet if you'd like to select it in a dropdown option in second sheet
Printing
Print 3rd sheet - "checkprint"
Select page range of of checks you want to print check1 is page 1 etc.
Select paper "check"
Insert check right side first in printer
Editing
3rd sheet protected to avoid accidental moving of textboxes
To edit, right click checkprint sheet then unprotect.
You'll probably need to edit checkprint sheet since banks have different check layouts.
To edit output of "amount words" column in checkdetail sheet press Alt+F11 then edit code.
References:
Cheque printing without special software or Printer with Excel
MS Excel: Convert currency into words
Is there anyway to get three checks to print onto the same page?
ReplyDeleteIs there anyway to get three checks to print onto the same page?
ReplyDelete