The Payment Register allows you to generate a history of all activity that has occurred for a specified bank account for a specified date range. This includes all computer checks, regular manual checks, EFT manual checks, actual cash deposits from DSRs, bank reconciliation adjustments, general journal entries that affect the cash account, and house account deposits. The report will include the vendor code and name for checks and EFT’s.
The options screen appears similar to the following:
The following options are available to customize your report:
Bank Enter the bank code (required).
Check # To report on a specific check, enter a check number.
ACH To report on a specific ACH transaction, select an ACH number.
Batch Code Enter a specific batch code to limit the report to a single batch, or leave blank to include all.
Date Range Specify a range of dates to generate a history of all checks written during that time period.
Initial View Select whether to initially generate the report in detail (Expanded) or summary (Collapsed). You can change this in the report preview screen.
Sort By Specify a sorting criteria for your report — by date, check number, or alphabetically by recipient name.
Transaction types to include Select one or more transaction types to include on the report. At least one must be selected.
Transaction statuses to include Select one or more transaction statuses to include in the report. At least one must be selected. Including different statuses on the report can help when checking the status of a bank account reconciliation. The status of each item displays at the far right of the report as follows:
Open indicates the item has not been selected on a posted bank reconciliation.
Cleared indicates the item has been selected on a posted bank reconciliation.
Marked indicates the item has been selected on an unposted bank reconciliation.
Voided indicates the item has been voided. The void date of voided transactions will appear on the report.
Note: For payroll checks, the employee name and number are stored with the check record and will show up on this report.
The following is a sample Payment Register: