Check Templates

The following names can be used on all check templates.

Name and Address fields:

Check Template Address Names
PAYEE
Payee name.
ENAME
Employee name, as used on payroll checks through Payroll.
ADDRESS
Payee's address.
Individual address fields from an Accounts Receivable or Payable can also be used. i.e. the phone number of a customer or vendor.

See Name and Address Information Cell Names for more.

Header Names:

Check Template Cell Names
CHECKAMOUNTASTERISK
Check amount, padded on the left with asterisks. For example: ****1,234.56.

See the manual section Check Date & Amount Formatting for more information on the use of this cell name.
CHECKAMOUNT
Check amount.
TEXTAMOUNT
Check amount in words. The word text is padded on the left and right with hyphens (-) as required to fill the cell entirely.

See the manual section Check Date & Amount Formatting for more information on the use of this cell name.
CHECKNUMBER
Check reference number.
CHECKDATE
Date of the check. (The format of the date is controlled by cell format of the Excel template.)
OCRCHECKDATE
Date of the check formatted for optical character recognition. e.g.: DDMMYYYY, MMDDYYYY, etc.

See the manual section Check Date & Amount Formatting for more information on the use of this cell name.
OCRDATEGUIDE
Guide for the date of the check formatted for optical character recognition. e.g.: DDMMYYYY, MMDDYYYY, etc.

The guide needs to be present on the template and just above the OCRCHECKDATE field.
A COURIER font should be used and both fields set to the same font size and horizontal alignment.
BANKNAME
Account name of the bank the check is drawn on.
BANKDESCRIPTION
Account description of the bank the check is drawn on.
BANKID
(Canada Only) ID of the bank the check is drawn on.
BANKTRANSIT
(Canada Only) Bank's transit (branch) the check is drawn on.
BANKACCOUNT
(Canada Only) Bank account the check is drawn on.
EBANKID
Employee's bank ID the check is payable to.
EBANKTRANSIT
Employee's bank transit (branch) the check is payable to.
EBANKACCOUNT
Employee's bank account the check is payable to.
MICR
The MICR encoding at the bottom edge for use on blank paper check stock. It is a combination of the CheckNumber, BankTransit, BankId and BankAccount. You must use font E-13B to print this field,

See the manual section Printing MICR Checks for more information on the use of this cell name.

Item Names:

Check Template Item Cell Names
ITEM_ACCOUNT
Name of the cross-account for the transaction detail item.
ITEM_DESCRIPTION
Description of the cross-account for the transaction detail item.
ITEM_QUANTITY
Quantity of the transaction detail item.
ITEM_RATE
Rate of the transaction detail item.
ITEM_AMOUNT
Amount of the transaction detail item.
ITEM_BALANCE
Running balance of the check stub.
ITEM_YTD
Year-to-date total of amounts posted to the cross-account (for employee paychecks.)

NOTE: Names are not case-sensitive.


Copyright (c) 2003-2022 Q.W.Page Associates Inc., All Rights Reserved.