Check Register

Use this option to generate a listing of either selected accounts payable checks or all the checks in your database. Following is the information provided for each check in the Check Register:

For the standard procedure for generating Accounts Payable reports, refer to Accounts Payable Reports.

Menu Path

From the Fund Accounting menu, select Reports. In the Accounts Payable Reports menu, select Check Register.

Selection Criteria

If the Print Checks by Bank Account option is selected in the Fund Accounting profile, the Bank Account field appears as part of the selection criteria. In this case, the output in PDF and Excel is as follows: 

Report Output in PDF

If the report is run by using the By Bank Account sort option, then the output is as follows:

• Cash Account is displayed as the first column in the report for PDF format.

• The report title is Check Register - By Bank Account if it is run by using the By Bank Account sort option.

• The report is grouped by Bank Account and the Default Cash Account Number is provided with the Bank Account grouping.

• Cash Account is added as a field to display in the report under the Account Number.

  • The Cash Account Number is displayed as just the Cash Account if Full Account Format is not selected or Use Fund Only is selected in the Fund Accounting profile. The Fund field is displayed after the Cash Account. The title in this case is Cash Account.

  • The Cash Account Number is displayed in the full account GL format if Full Account Format is selected and Use Fund Only is not selected in the Fund Accounting profile.

  • The records are sorted by Cash Account number under the Bank Account grouping.

• Totals: Totals are displayed for Check, Cash Account, and Bank Accounts.

Report Output in Excel

If the report is run by using the By Bank Account sort option, then the output is as follows:

• Bank Account is displayed as the first column in the report instead of Fund. The header is Bank Code.

• Default Cash Account Number is displayed next to the Bank Code column. The Default Cash Account Number is taken from bank maintenance screen based on the Check Bank Account provided on the transaction.

• Cash Account is added as a field to display in the report after the Account/Account Number.

  • The Cash Account Number is displayed as just the Cash Account if Full Account Format is not selected or Use Fund Only is selected in the Fund Accounting profile. The Fund field is displayed after the Cash Account. The title in this case is Cash Account.

  • The Cash Account Number is displayed in the full account GL format if Full Account Format is selected and Use Fund Only is not selected in the Fund Accounting profile.

  • The records are sorted by Cash Account number under the Bank Account grouping.

• Totals: Totals are displayed for Check, Cash Account, and Bank Accounts.

Manual and Voided Checks

Besides regular checks, the report includes transactions involving manual and voided checks. However, it does not list voided checks that resulted from errors during print runs. For a report that includes this type of voided check, refer to Check Register with System Voids Report.

Sort Options

The Accounts Payable Check Register page provides the following sort options:

Both reports use the same format, except the report sorted by fund also provides the expenditure account number for each check.