CNA L&P - Checks: Set Check Ceiling (next check number out of sequence)

ConnectNow Accounting generates the next check number by either:

1.  Finding the highest existing check number and adding one.

2.  Or, when a check ceiling is set, finding the highest existing check number below the ceiling and adding one.

This article will explain the following: 

 

.

How do check numbers get out of sequence?

You may have received a new set of checks which are numbered lower than your previous set, OR-

When an Electronic Funds Transfer (EFT) check number is assigned through the Bills screen, sometimes a numeric check number is assigned that is very large. If alpha characters are not included in that check number, the next generated check number will be that very high number plus one.

For example, a check number of 42520171 may be assigned to and EFT transaction which is dated 04/25/2017. Since no alpha characters are used in this check number, when printing checks the next check number generated will be 42520172.

.

How to prevent check numbers from getting out of sequence:

When you assign a check number to an EFT or an ACH Transaction, add alpha characters to the number such as EFT42520171. A check number with alpha characters will not be considered when generating the next check number.

.

How to get your checks back in sequence:

If my next physical check number is 20012, but due to an EFT or ACH entry, I have previously entered a higher number (42520171) with no alpha characters, my next generated check number will be out of sequence. The software will find the highest assigned check number below the ceiling if one exists or below 999999999 if one does not. It will add one to the number it finds. With no ceiling set, the next generated check number in our example will be 42520171 + 1.

To get your checks back in sequence, you must set a check ceiling. A ceiling tells the software to look for the highest check number which is below the ceiling and add one. It also tells the software to not go beyond this ceiling number when generating numbers. The check ceiling must be high enough to allow a few thousand checks to print in sequence, but below the next highest check number. 

In our example, we want the system to generate check 20012 but if we do not set a ceiling, it will generate check number 42520172.  In this case, the ceiling could be set to 42520170 since there were no checks with numbers between 20012 and 42520171. 

 

.

How to set the check number ceiling: If your organization uses Primary/Subsidiary Bank Accounts, click the following link to learn how to Set the Check Ceiling for Primary Subsidiary Bank AccountsGo into Accounts and use Quick Find to bring up the Checking Account. Then, at the bottom of the screen you find a Check Number Ceiling Field. Add the number there and click Submit.

setcheckceiling.PNG

To verify the ceiling you have set will generate the next sequential check number, go into checks and select the account. You will see which number the system will generate the next time you print checks.

veifyceiling.PNG

If this number is not correct, you must lower the ceiling to below this number.

 

.

 

 

How to set the check number ceiling for Primary and Subsidiary Bank Accounts: Go into Setup--> Primary and Subsidiary Bank Accounts--> choose the bank account. In the Check Number Ceiling fill in the number and submit. 

 

To verify the ceiling you have set will generate the next sequential check number, go into checks and select the account. You will see which number the system will generate the next time you print checks.

veifyceiling.PNG

If this number is not correct, you must lower the ceiling to below this number.

 

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.