Renee S,

There are a few different register reports, so without knowing which one you are running, here is some general information that may help you -

1) If you are going to Cash Management, Reports, Registers, Register - that report sorts first by date, then by check number.  This means it is entirely possible the checks won't be in numerical order, depending on the date the date associated with them.

2) If you are going to Cash Management, Reports, Registers, Check Register - that report sorts by check number, then by date.  This means the checks would also be in numerical order.

3) If you are going to Cash Management, Reports, Registers, Check Register by Date - that reports sorts by date first, then by check - again meaning that the checks may not be in numerical order depending on the date.

(knowledgebase article 36189)

These are not sort orders that can be changed without modifying the report design itself.  However, there may be an underlying issue that is causing the out of balance.  Calling in to Support for assistance with troubleshooting may be a better option than assuming that it is the order of the checks that is the problem.

Angie Gwalchmai

Senior Customer Support Analyst, Sage Construction and Real Estate

Sage North America