This feature, or some fields and options described, might not be available depending on your settings, security rights, or platform package.

Related Topics Link IconR

Report: Check Register

The Check Register is a detailed list of checks and EFTs issued for a particular bank. Checks are listed in check number order, followed by EFT transactions. Use the register for a listing of cash outflows by the day, week or month.

A check or EFT transaction appears on this report if one or both of its related Check Date or Void Date falls within the Transaction Date Range specified in the report request.

Report Image

ClosedAccessing the Check Register Report

This report is accessible from any center or form with a Toolbox menu. Selecting Toolbox > Reports takes you to the Reports - All list, where you can make your selection.

Click Check Register. This opens the Report - Check Register selection form. Make your selections, pull down the File menu and select to:

ClosedReport Selections

Report Selections

What is this?

Bank

Defaults to (All) or choose a particular bank from the list. The list contains the bank name and general ledger account number.

The list displays only banks for which you have appropriate security.

Check Date Range

Options

What is this?

Current Date

Default option. Use this option for a listing of checks posted on a daily basis.

Select Dates

Use this option to type in (or select from the date picker) a specific beginning date and end date for the check listing.

Check Numbers

Option

What is this?

All Check Numbers

Includes all check numbers for the selected dates.

Select Check Number Range

Use this option to view a particular check number range, within the date range selected. Enter the desired From and To check number range.

Include EFT disbursements

Defaults as checked so that any Electronic Funds Transfer (EFT) transactions are also included in the report. Uncheck to exclude such items from the report.

Description

Defaults as Check Register but can be changed.

Print Cover Page

Allows you to include a cover page listing the selected options included in the report. This option defaults as unchecked.

ClosedReport Fields

Report Fields

Description

Check#

The check number assigned to the check through check printing (automated checks) or manually assigned (manual checks). The check number field is replaced by EFT for electronic funds transfer transactions.

If the check has not been printed yet, the check number is unassigned.

Journal #

An identifying number assigned by the system when the transaction is posted.

The same as the Reference # shown on the bank register.

GL Date

General ledger date.

Payee Name

Name of the person or company to whom the check is payable.

For/Reason for Void

Pulls from the description field on the check data entry. If the check is voided, the reason for the void displays.

Amount

Amount of the check.

Totals

A check or EFT transaction appears on this report if one or both of its related Check Date or Void Date falls within the Transaction Date Range specified in the report request.

Consequently, if the Check Date is included in the Check Date Range but the Void Date is not, both the check and void transactions are included in the report detail.

The check amount is reported in the Check Total for Report Range, and the void amount is reported in the Check Total for Items Outside Report Range.

Totals

What is this?

Check Total for Report Range

All transactions included in the report detail where the check or void dates fall within the Check Date Range.

Check Total for Items Outside Report Range

All transactions included in the report detail where the check or void dates do not fall within the Check Date Range.

Total for All Items Reported

Total of all report detail.

ClosedCSV Columns

CSV Columns

Description

Bank

Name of the bank.

Bank GL

The general ledger account number of the bank.

Check #

The check number assigned to the check through check printing (automated checks) or manually assigned (manual checks). The check number field is replaced by EFT for electronic funds transfer transactions.

If the check has not been printed yet, the check number is unassigned.

Journal #

An identifying number assigned by the system when the transaction is posted.

The same as the Reference # shown on the bank register.

Date

The check date.

Amount

Amount of the check.

Payee Name

Name of the payee.

For

Description for the purpose of the check.

Void Journal #

Reference number assigned if the check is voided.

Void Date

Date the check was voided.

Reason for Void

Reason the check was voided.