...
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 program also consists of two options, Auto-Reconcile and Payment Reconcile Extract. 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. The Payment Reconcile Extracts outstanding check information and copies it to a file in a format that can be used by the district's bank.
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
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
Output Format: XML (Export)
PDF (Print)Bank Account: Select desired account
Starting Check Number: Will use the Number(s) that are checked in the selection
File Name: XML (Checks.xml)
...
Once all selections have been made, click on 
or to cancel select 
.
Example of a
...
Payroll Check.XML
...
Example of a
...
Payroll Check.PDF
...
Resequence
Select the checks to be Resequence
...
Enter in the date requested
...
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.
...
(the Field Name titles are not necessary for exporting or importing. File will indicate 'Failed Checks', 'Check Null' unable to determine check number from record', on the Summary report created):
Enter in requested data:
Auto-Reconciliation Summary
...
Payment Reconcile Extract
...
Extract Reconciliation File setup
...