...
The Check Register program is designed to automatically reconcile a district's payroll and deduction company checks. The program can also Re-issue, Print, and Resequence checks. Can Reconciliation of single checks or ranges of checks. A reverse reconciling option (Unreconcile) is also available for checks that are reconciled in error and must be reversed. The Auto-Reconcile option, reconciles the checks on the file returned by the bank or created from sources outside the payroll system (such as EXCEL, ACCESS, LOTUS). The import file must be saved in either a sequential, comma separated value, (CSV) or a TAB delimited format.
Re-issue
When using the Re-issue option, the system will Void the old check at this time. Select the Check to be Re-issued. Click on re-issue
Select the Bank Account from the drop down box. The next available check will be used for the New Check Number. Enter in a Reissue Date or leave blank for today's date.
Print Checks
Select the check(s) to be printed and click on Print Checks
Select the options for printing
...
Checks can be selected or just click on and enter in desired checks to be resequence.
Enter in the date requested
...
The Check Reconcile program handles reconciliation of single checks or ranges of checks. An Unreconciling Un-reconciling option is also available for checks that are reconciled in error and must be reversed.
...
Reconcile
Select Check to Reconcile
Enter In Reconcile Date:
Unreconcile
Select Check to Unreconcile
And click on
Auto-Reconcile
The district must first create an initialization file in Utilities/Automatic Payment Reconciliation option, that will define all the data that is to be extracted and placed on the sequential file to be sent to the bank. This initialization file will also define all data that is returned from the bank to be reconciled by the district.
...
To Download Summary, click on to save report or to not download and exit.
Payment Reconcile Extract
Extract Reconciliation File setup
Specific Date - Date needs to be before the Transaction Date of the check in order for it to be included in the Extract File
Bank Account - This will need to be setup under the Core/Bank Accounts option first.
File Format - The Extract file needs to be created under the Utilities/Automatic Payment Reconciliation Configuration option. (The Import and Extract file can be the same file format).
Payment Transaction Type -
- All
- Payroll Check
- Deduction Check
- Group Deduction
Example of a Payment Reconcile Extract File
Payment Reconciliatin Extraction Report
Report Creation
To create a report from the Grid, please click on the Report documentation link to find the How to Steps: Report