Check Date & Amount Formatting

When printing checks, there are six options to control the formatting of the check date, and the check amounts. As seen in the example below, the options occupy the bottom six lines of the settings window.

The first three options are mainly supplied to satisfy the check specifications imposed by the Canadian Payments Association that came into effect between 2006 and 2008.

Check OCR Date Format

This setting controls the formatting of the date printed on check templates using the cell name OCRCHECKDATE

Under the CPA specifications, the date must be printed as 8 digits, in one of three formats: ddmmyyyy, mmddyyyy, or yyyymmdd.

To set the date format for your checks, press <F3> and choose from the following formats:

DDMMYYYY
D D M M Y Y Y Y
MMDDYYYY
M M D D Y Y Y Y
YYYYMMDD
Y Y Y Y M M D D

Single and double-spaced version of each format are available to accommodate any possible formatting requirements.

Check Asterisk Amount Format

This setting controls the formatting of the amount printed on check templates using the cell name CHECKAMOUNTASTERISK

To set the amount format for your checks, press <F3> and choose from the following formats:

**********1,234.56
*********$1,234.56
$*********1,234.56

Note that the above examples use the currency symbol $. The symbol will be replaced with the symbol specified in the Currency Symbol option below, if different.

Check Text Amount Format

This setting controls the formatting of the amount in words printed on check templates using the cell name TEXTAMOUNT

To set the amount format for your checks, press <F3> and choose from the following formats:

Five Dollars and Six Cents----------
---- Five Dollars and Six Cents ----
--------- Five Dollars and Six Cents
--------- Five and 6/100 -----------
--------------------- Five and 6/100
Five---------------------------6/100
Five and 6/100 ---------------------
----- Five and 6/100 Dollars -------
------------- Five and 6/100 Dollars
Five and 6/100 Dollars -------------
Five Dollars and Six Cents**********
**** Five Dollars and Six Cents ****
********* Five Dollars and Six Cents
********* Five and 6/100 ***********
********************* Five and 6/100
Five***************************6/100
Five and 6/100 *********************
***** Five and 6/100 Dollars *******
************* Five and 6/100 Dollars
Five and 6/100 Dollars *************

Note that the above examples use the currency name dollar and the currency fraction name cent. These will be replaced with the Currency Name and Currency Fraction Name specified in the options below when different.

The remaining three options define the currency symbol and names that are used in formatted amounts.

Currency Symbol

This setting controls the currency symbol used in some of the Asterisk Amount Format choices. Together, these settings control the format of the amount printed using the CHECKAMOUNTASTERISK template cell name.

For Canada and the U.S.A. you would enter $.

Currency Name

This setting controls the currency word used in some of the Check Text Amount Format choices. Together, these settings control the format of the text amount printed using the TEXTAMOUNT template cell name.

For Canada and the U.S.A. you would enter dollar.

Currency Fraction Name

This setting controls the fractional currency word used in some of the Check Text Amount Format choices. Together, these settings control the format of the text amount printed using the TEXTAMOUNT template cell name.

For Canada and the U.S.A. you would enter cent.


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