The following names can be used on all check templates.
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. |
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. |
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.