Revised: 09/01/2017

Check Books Master

 Go to Maintain>>Check Books

The check book master is used to set up a check book for each bank account.  Check numbers used are tracked in this view and different check formats may be setup for each checkbook if needed.  Each check book should be given a unique code.

See Also:  

Note:  The same check book master is shown in the Payroll, Financial, Rep Payee and some Housing modules.  Any changes made in one of those programs to a checkbook within the same Company Fund/ID, will be in the other modules.

Quick Link

Header

Check Book ID

NEW CHECK BOOK ID: Enter a unique check book identifier. Although the field will accept up to 15 characters in length, the check book ID should be no more than 4 characters in length.  The ID may be numerical, alphabetical, or a combination of both.

EXAMPLES:

P1 for Primary checkbook

CKBK for Checkbook

SAV for the savings account

SONE for the savings account of company one

For an existing check book select the check book ID you want to view or edit.

NOTE:  

The check book ID is a key value and may not be altered after it has been saved.

Description

Enter a description for the account. The description may be up to 30 characters in length. This is the description users will see, so be as descriptive as possible.  Descriptions may be edited.

General

Route

Enter the bank's routing account number.  This is a required field if blank check forms are used and Horizon software is printing bank routing information on the checks.  If the checks are preprinted with this information, this field may be left blank.

NOTE:  Not all check formats support printing of the bank routing number.

Type

The Type should usually be set to Standard Checking.  If you feel you need a different selection from the menu, please contact your Horizon Support Representative.

Account Number

Enter the account number (assigned by the bank). This is a required field if blank check forms are used and Horizon software is printing bank routing information on the checks.  If you are using checks that already have the bank code preprinted, this field may be left blank.

NOTE:  Not all check formats support printing the account number on the checks.

Last Check # 1

Enter the last check number used in the checking account. The system will assign the next number in sequence when check processing is run. The system will automatically update this information when check processing is complete and posting is done.

NOTE:

Last Electronic

After you have entered a beginning electronic number (last number used), the system will update this field.  This field maybe edited if the electronic numbers get out of sequence.

Description 1 & 2

Description 1 & 2  is an area for additional comments about the account to help identify it for the user.  It will only be seen if looked at through the Check Book Master. You may enter up to 30 characters in these fields.

Check Format

This field is used to setup different formats for each checkbook.  The main AP check format is found under Settings; Accounts Payable Settings, on the Check Processing tab.  The main payroll check format is found in Payroll Settings in the Payroll module.  All checkbooks will use the same main check format for AP unless a unique one is entered in this field.  Please leave this field blank unless you have been instructed by Horizon personnel to assign a check format in this field.

Note:  The Horizon Help Desk should be contacted before changing a check format.

Print Order

A print order may be assigned by selecting one of the following:

Printing order may also be assigned in Settings.  If you are unsure of where to assign the print order for your purpose, please call the Horizon help desk.

Use Check Overflow Sheet

Place a checkmark in this field if a check overflow sheet is to be used.  Please contact the Horizon Help desk for more information as this may not work with all check formats.

Disable Autoclear

When checked, auto clear for AP ACH payments will be disabled.  AP ACH payments will need to be cleared manually.

General Ledger Information

G/L Number

Enter or select the general ledger cash account number for this checkbook.   This is needed if Receipt Processing will be used.  You may leave this field blank if not using Receipt Entry.   Enter the Cash GL Account number that this check book is linked to.  The general ledger account number should also be linked in this check book in GL Account Master.

Description

The Description of the selected general ledger account number will be displayed.

Segment

If you have a Master Segment selected in General Ledger Settings , enter the control segment value that this check book is in.  Revenue Entry will only allow GL accounts in this control segment to be used.

UnClaimed G/L

Enter or select an account number to serve as the Liability account when Process Unclaimed Property is run.  This field may be left blank if you do not process unclaimed property.

Lock Information

Current User

If the selected check book is locked because the check book is in use, the user's name and the module that has initiated the lock will be displayed.

For example:

Checkbooks may be unlocked by running the Reset Checkbook Lock program which is found under the Quick Link menu.  Please be careful when resetting a locked checkbook as information could be lost. Be sure to contact the user who is shown as the Current User before unlocking the check book to make sure they do not have checks that have not posted.

Check Layout Information

Company Information

Line 1 through 5

Adjustments

Vertical and Horizontal

Enter in a number to adjust the company information on your blank check format.  If you are using pre printed check formats, leave these fields blank.

Justification

Select either Centered or Left Justified.

 

Bank Information

Line 1 through 4

Stub Layout Information

Stub Descriptions

First Stub Description

Second Stub Description

Vertical Stub Adjustments

Enter an adjustment number for the first and second stub.  If you are unsure of the number to enter in these fields, please contact the Horizon help desk.

Signature/Logo Information

Logo Information

Logo Path/File

To print your company logo on your checks, input the system path and name of the file in this field.  This is not a required field and may be left blank when using preprinted checks.

Note:  This information will only be used if the check format supports it.

For example:

H:\HorizonSoftware\somecompanylogo.bmp

Position Fields

Use the Left, Right, Top and Bottom position fields to move the logo into the correct position.  The numerical information may be entered in or the counter arrows may be used to increase/decrease the numbers.  

Signature Information

Signature Path/File

To print signature(s) on your checks, input the system path and name of the file in this field.  This is not a required field and may be left blank if signatures are not to be printed on the checks.

Note:  This feature is only used if the check format supports it.

For example:

H:\HorizonSoftware\somesignature.bmp

Signature Position Fields

Use the Left, Right, Top and Bottom position fields to move the signature(s) into the correct position.  The numerical information may be entered in or the counter arrows may be used to increase/decrease the numbers.

NOTE:  Not all check formats support the check signature format.

For Example:

Left Position:  1350

Right Position:  2050

Top Position:  550

Bottom Position:  800

Require Password

Place a checkmark in this field to require a password prior to printing a signature on checks.  A checkmark is automatically entered in this field if the Add/Change Password button is activated and password information is setup.

If a password is not entered during check processing, the checks will print without a signature.

Signature Limit

Enter a dollar amount or leave blank if not applicable.

The system will not print a signature on a check when the check amount is greater than the amount entered here.

Add/Change Password

Click on this button to bring up the following view to enter in password information.  If password information is entered and ok is pressed, a check mark will be entered in the Require Password checkbox if it is not already in there.

 

 
When entering password information for the first time, leave the old password blank. Thereafter, the old password must be entered.
 
Removing Password

To remove the checkmark properly you must remove the password information first; otherwise, when you try to save the file without a checkmark in the Require Password box, you will see the following message:

Format Adjustments

Use the adjustment amounts to move the placement of objects on the check.  Adjustments entered here do not effect the placement or formatting of the paystub, only the check face.

MICR Adjustments

If the MICR bank numbers (routing and account) needs adjusting you may enter numbers in to adjust it vertically or horizontally.

Date Adjustments

Entera number to adjust vertical, horizontal or both to adjust the placement of the date on the check.

Words Adjustments

Enter a number to adjust vertical, horizontal or both to adjust the position of words printed on the check.

Amount Adjustments

Enter in vertical or horizontal adjustments or both to adjust the dollar amounts on the check.

Pay to the Order Adjustments

Memo Adjustments

Name Adjustments

Enter in vertical or horizontal adjustments or both.

Positive Pay

If you will not be generating a Positive Pay file, this page may be left blank.  If you will be creating and sending a positive pay file to a bank, please call the Horizon Help Desk for assistance.  

General Setup

Setup

Pospay Format

Select one of the following formats:

Pospay Path

Enter a path to where the file will be saved.  

File Transfer Setup

FTP Address

Enter the FTP address where the file is to be sent.

User Name

Enter the User Name for the transfer.

Password

Enter the Password for the transfer.

Signing and Encrypting

Key Information

Signing Key(s)

Enter Signing Key information.

Encrypting Key(s)

Enter Encryption information.

 

 

Reset Checkbook Lock

Go to Maintain>>Check Books>>Quick Link>>Reset Checkbook Lock

This program may be used to unlock a checkbook that has been locked while processing checks and should only be used as a last resort.  

Check books are locked to prevent complications that arise when checks/ACH information is removed before it can be canceled or posted.  The user who is in the process of creating, printing and posting checks should be allowed to complete the process to avoid those complications.

Unlocked Checkbooks

If the selected Check Book ID is currently unlocked the following information box will be displayed:

 

Locked Checkbook

If the selected checkbook is locked when this program is activated the following will be displayed:

Click Yes to unlock the checkbook.  This step should only be taken in extreme circumstances.  The better solution is to have the user go into the Check Processing Wizard where they can cancel or post their check information which will unlock the checkbook for other users.

Click No to close the program without unlocking the checkbook.

 

Duplicate

After selecting a check book, the Duplicate function will be available for use.  Pressing the Duplicate icon will open the Checkbook - Save as...function.

Checkbook ID

Enter a new unique Checkbook ID for the duplicate check book.

Description

The description of the original check book will be displayed.  The description may be used or edited for the new check book.

OK

Press the OK button to create the duplicate checkbook.

Cancel

Press the Cancel button to close and stop the duplication process.

 

 

Blank Check Printing

Go to Maintain>>Check Books>>Quick Link>>Print Blank Checks

This program is used to print one or more blank checks for a selected check book.  

Currently this feature only works with certain check formats.  

Header

Check Book ID

Enter or select a Check Book from which to print the check(s) or use the Name field to select the check book..

Name

The Name of the selected check book will be displayed or the Name of the check book may be used to select the check book.

Options

Starting Check #

The starting check number from the tracking file for the selected check book will be displayed.  The check number may be changed if needed.

Number of Checks

Enter the number of checks to print.

Check Date

Enter or select a date to print on the checks.

Print Checks

Click the Print Checks button to print the checks out on the printer selected for check processing.