Reconciling Multiple Checks

Use the Check Reconciliation screen to reconcile printed checks to your bank account. In addition, you can use the User Defined Upload Processing screen, after you have uploaded the data from the file your bank has sent you, to reconcile all of the checks in that file.

To reconcile multiple checks:

From the A/P > Check Reconciliation menu, select Check Reconciliation to display the Check Reconciliation screen.

In the Branch field, enter the branch or branches against for which you want to reconcile checks, and press Enter.
From the list of bank accounts that displays, select the bank account from which the check was written and press Enter.
The system displays a list of all the unreconciled checks in the account by check number, with the following information:

Column	Description
Check#	The check number.
PostDate	The date the check was posted.
Payee	The vendor to whom the check was made payable.
Check Amt	The amount of the check.
Rec Date	The reconciliation date, if there is one.

Use the Rec Series hot key to display the Check Reconciliation Series screen.
In the Starting Check # field, enter the number of the starting check for the series of checks you want to reconcile.
In the Ending Check # field, enter the number of the last check in the series of checks you want to reconcile.
In the Reconcile date field, enter the date on which you want to the checks to reconcile, and press Enter.

The system displays the Check Reconciliation screen, and the Rec Date field displays the reconciled date of any checks that have been reconciled.

Press Esc to exit this screen.

To reconcile multiple checks:

From the System > Printers menu, select Your Hold Entries.
Use the Down Arrow key to move the cursor to the line item that contains the information you need to reconcile.
Use the Process hot key to display the User Defined Upload Processing screen.
In the Processing Type field, press F10, and select Spooler Check Reconciliation. Spooler Check Reconciliation now displays in this field.
Use the Begin hot key to display the Spooler Check Reconciliation screen.
In the Input File field, the system populates this field with the name of the bank file that was uploaded to the spooler.
In the Work ID field, do one of the following:

Leave the field blank – Does not save the template after this update.
Enter a name that identified the vendor who sent the file or the price line being updated – Creates a new template.
Press F10 and select an ID – Uses an existing template.

In the Desc field, enter a description of the template for this check reconciliation process.

In the Branch field, enter the branch for which these checks are being reconciled.
In the Bank field, enter the name of the bank from which you received the checks.
In the Check Number field, enter the following information:

Start – Enter the starting position using a character number that begins the section of data.
Lngth – Enter the corresponding length of the field.
Dec # – Enter the number of numerals behind the decimal point.

In the Check Amount field, enter the following information:

Start – Enter the starting position using a character number that begins the section of data.
Lngth – Enter the corresponding length of the field.
Dec # – Enter the number of numerals behind the decimal point.

In the Reconciliation Date field, enter the following information:

Start – Enter the starting position using a character number that begins the section of data.
Lngth – Enter the corresponding length of the field.
Dec # – Enter the number of numerals behind the decimal point.

Use any of the following hot keys, as needed:

Hot Key	Function
Begin	Begins processing the upload file.
Rec Layout	Identifies the Spooler Check Reconciliation format for the file you are importing. For more information, see Defining the File Format for Price Updates.
Delete	Deletes the currently displayed work ID. The system prompts you for confirmation of the deletion.