Check Reconciliation Tutorial

Check Reconciliation Program

Overview: This program is used to balance the check register to your bank. You can make adjustments to the checkbook or to the bank and remove (delete) checks that have been cleared.

Follow these directions:

1. From the Master Menu, select 3 - Reports Menu, 2 - Month End Reports, and 7 - Check Reconciliation.
   
   
   
   
2. Select the Register Number you want to balance. Press the Tab key.
   
   
   
   
3. Review the Parameters.
   
   

   Check Register:	Normally Register 0
   Print Detail:	Print Detail Lines
   Statement Ending Date: *	Enter Date MM/DD/YYYY
   Statement Ending Balance: *	Enter Ending Statement Balance
   G/L Account Number:	Enter your G/L Cash in Bank Account #
   G/L Checking Balance: *	Enter balance of your G/L Cash account
   Next Item Number:	Maintained by system
   Date Default Option:	Default Adjustment to Statement Date Or Default Adjustment to Effective Date
   * Very Important Fields

Print List of Outstanding Checks

1. From the Check Reconciliation screen, select Reports and click Print Check Reconciliation.
   
   
   
   
2. Click OK on the print confirmation message box.
   
   
   
   Note: You can also spool the report. When the spooled report is completed, you will be prompted on whether you want to automatically review the spooled file. Click Yes to view the file. This will be true of any report completed in this program.
   
   

Print Tagged Item Report

1. From the the Check Reconciliation screen, select Reports and click Print Tagged Items Report.
   
   
   
   
2. Click OK on the print confirmation message box.
   
   

Display Bank Reconciliation Summary

1. From the Check Reconciliation screen, select Reports and Display Reconciliation.
   
   
   
   The Check Reconciliation Balance Screen will display.
   
   
   
   
2. Click Print Screen to print a hard copy of the results if you want.
   
   
3. Click Continue to return to the Check Reconciliation screen.
   
   

Reconcile Check Register

1. From the Check Reconciliation Screen, click the Reconcile command button.
   
   
   
   
   
   Note: Your task is to tag each check that has been cashed and appear on your Bank Statement.
   
   
   
   
2. Search Options:
   
   Select Check # - If you select this option, you need to key in the check number and click the Check Mark button. This will take you to the check with that check number. If this is the correct check, you will need to click inside the box. This will insert a Check Mark in the box and will remove the check from the Displayed Reconciliation Screen and the Check Reconciliation Report.
   
   Select Amount - If you select this option, you need to key in the check amount and click on the Check Mark button. This will take you to the first check with that dollar amount. If this is the correct check, you will need to click inside the box. This will insert a Check Mark in the box and will remove the check from the Displayed Reconciliation Screen and the Check Reconciliation Report.
   
   
   
   
3. Once you have finished tagging all the returned checks, click Display Reconciliation.
   
   
   
   
   
   The Outstanding Checks Total should be a total of all the checks that have not cleared thru the statement ending date.
   
   
4. Click Continue to return to the Check Reconciliation Detail screen.
   
   
5. Click Exit to return to the Check Reconciliation Screen.

Tag All and Untag All

On the Check Reconciliation Detail form, you can select the checks all at once by clicking Tag All. To clear all the checks, click UnTag All.



Navigating Checks

On the Check Reconciliation Detail form, you will see a complete listing of your checks for that register. If there are more than 5,000 checks, the viewer will show the first 5,000. To view additional checks, use the navigation buttons under the viewer. You will be able to view 5,000 checks at a time except for the last view if there are under 5,000 checks left.



When you are at the end of the check listing, you will receive a message box stating "No More Check Records" are available.

Enter Deposit, Additions, Deletions, and Adjustments

You can make corrections to your check register by entering deposits, additions, deletions, and adjustments. Follow these directions to complete this task.

1. From the Master Menu, select 3 - Reports Menu, 2 - Month End Reports, and 7 - Check Reconciliation.
   
   
2. Select the Register Number you are trying to balance.
   
   
   
   
3. Click the Adjust Register button the main form.
   
   
   
   Note: The Adjust Register and the Reconcile buttons are disabled if All Registers is set on the Check Register field.
   
   
   
   
4. Click the down arrow for the choices.
   
   
   
   

   Description of Each Option Deposit/Addition (Stmt) - This option is used to adjust the right side (Statement Balance) of the screen. See the screen image above. Example: You need to add a check that the Credit Union has written, but it is not on the Bank Statement. This entry will add to the Total Additions field and the Adjusted Total field on the Statement Balance side. On the Check Reconciliation Report and the Check Viewer, the item number will start with the letter "D". Addition (Books) - This option is used to adjust the left side (Book Balance) of the screen. See the screen image above. Example: You need to add an amount to the Book Balance such as a bank fee/charge that appears on the Bank Statement, but has not been entered into the General Ledger. This entry will add to the Total Additions field and the Adjusted Total field on the Book Balance side. On the Check Reconciliation report and the Check Viewer, the item number will start with the letter "A". Deduction (Books) - This option is used to adjust the left side (Book Balance) of the screen. See the screen image above. Example: You need to subtract an amount from the Book Balance such as the bank reversing a charge or a bank refund that has not been entered in the General Ledger. This entry will add to the Total Deductions field and subtract from the Adjusted Total field on the Book Balance side. On the Check Reconciliation report and the Check Viewer, the item number will start with the letter "B". Adjustment (Stmt) - This option is used to adjust the right side (Statement Balance) of the screen. See the screen image above. Example: You need to subtract an amount from the Bank Statement that should not be there. This entry will add to the Outstanding Checks field and subtract from the Adjusted Total field on the Statement Balance side. On the Check Reconciliation report and the Check Viewer, the item number will start with the letter "C".

5. Enter the Effective Date of the adjustment.
   
   
   
   
6. Enter the Description for the adjustment.
   
   
7. Enter the Amount of the adjustment.
   
   
8. Click OK. This will accept your adjustment and reset the screen for the next adjustment.
   
   
9. When you have finished making entries, click Exit on the menu above. The Cancel button will exit the form as well. This will return you to the Check Reconciliation main screen.

Display/Print Check Reconciliation

You can either print or display the reconciliation as shown below.

To view the Check Reconciliation

From the Check Reconciliation screen, you can click Reconcile and then Display Reconciliation on the Check Reconciliation Detail screen. You can also select Display Reconciliation from the Reports menu.







If the Adjusted Total on the Book Balance side is equal to the Adjusted Total on the Statement Balance side, you are done reconciling.

Click Print Screen for a hard copy that shows you have balanced.

Click Continue to return to the Check Reconciliation Detail Screen.

You will now have to Delete Tagged Items so the checks that were cleared this month will not be included when you are trying to balance the checkbook next month.

Delete Tagged Items

Follow these directions to delete the tagged checks.

1. Click the Delete Tagged button.
   
   
   
   Note: Checks after the Statement Date displayed in the confirmation message box will not be deleted even if they are tagged.
   
   
2. Click Yes on the Delete Confirmation message box.
   
   
   
   
3. View the details on the Delete Tagged Item Summary form and click OK.
   
   

You have now completed the Check Reconciliation tutorial.