Running the Check Register Report

Run a Check Register Report to create a list of all the checks you have printed during a certain time period. The report lists checks either by vendor or check number. Keep in mind that this report can be used in multiple ways. You can run the report:

Following every check run.
Along with a general ledger report, for a specific bank account. The total of the checks written for the month should match the total disbursements for the month for that bank account.
For a particular date, branch, and bank account.

For a description of the report, see What the Report Shows at the end of the topic.

To run a Check Register Report:

From the A/P > Reports menu, select Check Register to display the Check Register screen.
In the Br/Tr/All field, enter the branch, territory, or All to include in the report.
In the Start Date field, the enter the first date of the period to include in the report.
In the End Date field, enter the last date of the period to include in the report. The default is the same date as the start date.
In the Bank Account field, select list bank accounts to include in the report.
In the Include Voided Check (Y/N) field, indicate whether to include voided checks. The default is Y.

In the Sort by Vendor or Check # field, press F10 and select one of the following to determine how to sort the checks on the report:

Vendor – Sorts by vendor names, and includes vendor subtotals.
Check – Sorts by check number in descending order.

In the Manual/Computer/Both field, press F10 and select one of the following to indicate which check types to include on the report:

Manual – Includes checks generated manually.
Computer – Includes checks generated by the computer.
Both – Includes both manually and computer generated checks. This is the default.

In the Detail/Summary field, press F10 and select one of the following to determine the level of detail to include on the report:

Detail – Displays all the information on a check, including check number, date, amount, branch, vendor name, invoice date, gross amount, deductions, and discounts. This is the default.

Note: When dealing with transactions entered in a different currency, there may be minor discrepancies in the detail report caused by different exchange rates. The total gross discount and check amounts will always match the general ledger postings, but the individual numbers listed in the report may not exactly add up to the total amounts.

Summary – Displays select information on a check, including check number, date, amount, branch, and vendor name.

Use the Slct key to display the Additional Selection Input screen, where you can enter additional criteria, for example, to select orders associated with a particular batch number.
Set options, if needed, and generate the report.

What the Report Shows

The Check Register Report shows the following information:

Column	Description
Branches	The branch number associated with the payable.
Bank Account	The name of the bank account for which the check was written.
Check #	The number of the check.
Br#	The branch number associated with the payable.
Vendor Name	The name of the vendor to which the payable is due. If the payable is for a customer refund, or a one-time payment that uses a generic vendor, the vendor name and OVERRIDE displays in this field.
Chk Date	The date each check was written.
Check Amt	The amount of each check written.
Invoice #	The invoice number connected with the payable.
Inv Date	The date the invoice was processed.
Gross Amt	The total amount of the invoice before any deductions or discounts were applied.
Deductions	The amount, if any, of deductions applied to the invoice.
Disc Amt	The amount of the discount, if any, applied to the invoice.