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.

The Bank List report is also available as a Quick Report from the sidebar menu on the Bank Center. The Quick Report provides a means of quickly accessing a list of the checks issued for the day for a particular bank account.

Report Selections

When the report is accessed from a Quick Reports menu, some selections are pre-filled by default. You can change default entries as needed.

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), ACH, OSC or Wire 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.

Exclude Pending Checks

Allows you to exclude pending checks from the Check Register report. See this page for further details.

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 is shown.

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.

CSV 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.
Payee Address	The address of the payee
Created By	The person who created the check
Posted By	The person who posted the check
Status	Current status of the check
Values, pending or posted
GL Type	General ledger type
Check Type
Payee Bank Name	The payee's bank
Payee Bank Account #	The payee's account
Payee Routing #	The payee's bank routing