Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Panel

Table of Contents


Report Creation

To create a report from the Grid, please click on the Report documentation link to find the How to Steps: Report

...

The Check Register program is designed to automatically reconcile a district's payroll and deduction company checks.  The program can also Re-issuePrint, 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.

Print Checks

Select the check(s) to be printed and click on Print Checks

...

Once all selections have been made, click on  or to cancel select .

Example of a Deduction Check.XML

Image Modified

Example of a Deduction Check.PDF

Resequence

Select the checks to be Resequence

Image Modified

Enter in the date requested

...

Once all data has been entered, select  ,  or  to Exit.

Check Reconcile/Unreconcile/Auto-Reconcile/Payment Reconcile Extract

The Check Reconcile program handles reconciliation of single checks or ranges of checks. An Unreconciling option is also available for checks that are reconciled in error and must be reversed.

...

Note: Electronic transfer checks are automatically set to reconciled status when created. An error will occur if these check types are entered in either the reconcile or reverse reconcile modes of the program.

Reconcile

Image Modified

Unreconcile

Image Modified

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 Import Fields can be saved using the 'Saved Formats' option.  Once saved, clicked on , select file type and click on .

 Sample Automatic Payment Reconciliation setup


Example of CSV file


  (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:

Image Modified

Auto-Reconciliation Summary 

To Download Summary, click on  to save report or  to not download and exit.

image2017-3-28_14-7-0.png

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

...

  • All
  • Payroll Check
  • Deduction Check
  • Group Deduction


Example of a Payment Reconcile Extract File

Payment Reconciliatin Extraction Report

...