Reconciling the Check Register – RFMS Help Desk

Full Banking User Guide

File>Banking>Reconcile Register

This option allows you to select a checking account and reconcile your records to your bank records. The goal is to bring the reconciliation difference to zero.

How To:

Select Checking Account.
Set up the Bank Statement Parameters.
Mark checks and deposits as cleared according to the bank statement. Bring the reconciliation balance difference to zero. To print a hardcopy of the reconciliation details, click the Print button in the lower right portion of the screen.
Select Done to finish the reconciliation.

Tips:

Checks and Deposits can also be marked and unmarked cleared in a range.
Records may be marked and exit the process without finishing. The system will retain the marked records and you can continue at a later time.

Additional Actions on the Reconcile Dialog

Click the print button to print a report of transactions that have been marked as "R" and those that have not. Use this report to assist in reconciling.

A void-in-process is a check that was written in the month being reconciled but voided in a following month. When a check is voided, the system date is used. Therefore, even though the check is voided as of the month being reconciled, it was considered open. Click the Voids-in-Process button, voids in process button.png ,to print a listing of these.

reconcile dialog voids in process.png

Viewing the Bank Register after Reconcile

The bank register will show those marked but not processed with a "C" instead of a "R". The Reconcile Date will show as the date the records were marked, after the reconciliation is processed the date will change to be the reconciliation date.

Use the Find button, find filter button.png , and choose to list only those records using the reconciliation date.

filter by reconciliation date.png

Bank Statement Parameters Dialog

Field	Explanation
Reconcile Month of	The default date is the month prior to your current system date. Change the date by typing in a new month and year (mm/yy) or click the F8 button to access the on-line calendar.
Ending Balance from Bank Statement	Enter the ending balance that appears on the bank statement. This number is used in the reconciliation process. The system will compare what is in the register to this number.
Bank Reconcile File	Automatic reconciliation of the check register via a bank supplied file is now available. An ofx file is required. Note: Some banks do not support ofx files. Check with your bank.