Versions Compared

Key

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

...

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 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. 

Image RemovedImage Added

Re-issue

When using the Re-issue option, the system will Void the old check at this timeoriginal check and allow a new payment to be processed.  Since the payment is for the same dollar amount it should not cause any issues with crossing calendar and/or fiscal years.  Select the Check to be Re-issued.  Click on re-issueImage Removed.

If a check is reissued in error, the following steps can be taken to unvoid the original check and void the reissued check.

  • Go to Payments>Payroll>Payroll Payments and void the Payment Number.
  • After the Payment Number has a Void status of true, select this Payment Number again and select Un-viod.
  • A pop-up box should appear.  Check the checkbox of the number that needs to be unvoided and select Un-void.

(Checks that are reconciled, cannot be Re-issued. Unreconcile first, then Re-issue) 

Image Added

(Checks that are Voided, cannot be Re-issued)

Image Added


Image Added


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.

Image RemovedImage Added


Image RemovedImage Added



Print Checks

Select the check(s) to be printed and click on Print Checks (Checks Image Removedthat are Reconciled, must be Unreconciled to be reprinted)

Image Added


Select the options for printing.

Image RemovedImage Added

Output Format: XML (Export) The 'XML' option of 'Output Format' is used when printing with outside printing software which will use the Bank Account information entered under Core<Bank Accounts

                           PDF (Print)

...

Form:  Only is an option for PDF format

Memo:  Add a message to print on the check.

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

Example of a Payroll Check.XML

Image RemovedImage Added

Example of a Payroll Check.PDF

Image RemovedImage Added

Resequence

Select the checks to be Resequenced

Checks can be selected or just click on  and enter in desired checks to be resequence. 

Image RemovedImage Added


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

Image RemovedImage Added


Enter In Reconcile Date:

Image RemovedImage Added

Image RemovedImage Added

Image RemovedImage Added



Unreconcile

Select Check to Unreconcile

Image RemovedImage Added


And click on 

Image RemovedImage Added

Auto-Reconcile

Image RemovedImage Added


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.

image2017-3-28_14-7-0.pngImage Removed

Payment Reconcile Extract

Image Removed

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

Image Removed

Example of a Payment Reconcile Extract File

Image Removed

Payment Reconciliatin Extraction Report

Image Removed

Image Added

Image Added


Report Creation

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

Image RemovedImage Added