Month-to-Date Member Control Analysis

Screen ID: 

Screen Title: 

Panel Number:

Report Name:

LCNTR-01

Processing Control Report

593

LCNTR

images\593g_shg.gif

Click here to magnify

 

Access this screen by selecting Tool 543: MTD Member Control Analysis.

The Processing Control Report is a helpful tool used for research when problems arise in balancing your credit union's General Ledger activity. In a nutshell, it is used to verify that daily activity matches beginning-of-day G/L account balances for member and accrual G/Ls. It can show, for example, situations where something was incorrectly posted between end-of-day for one day and beginning-of-day for the next.

Following is an illustration of the totals displayed on this report:

images\741rpt_shg.gif

A - This represents a calculated total of all member account balances (for accounts that are tied to this member G/L) as of beginning-of-day.

B - These columns show actual debits and credits posted and interfaced to the General Ledger during that day, separated by origin code (Teller Processing, ATM Processing, etc.).

C - This total is calculated by taking the beginning-of-day total from A above and adding/subtracting all debits and credits B.

D - For the next day, this again represents a calculated total of all member account balances as of beginning-of-day. If this total does not match C for the previous day, something may have been posted after end-of-day was completed, but the activity never interfaced with the General Ledger.

To run the report, start by entering the month and year for which data should be shown (usually the current month and year). To analyze just a single G/L account, enter the account number here as well (this is recommended to keep the report size manageable).

Although the report can be printed for a single day, the nature of the calculations on the report require multiple days so that you can see a comparison of the beginning-of-day and end-of-day totals from one day to the next. Therefore it is usually recommended that the Process date field be left blank.

The Origin Code descriptions come from the CNTRL file.

Report Sample

images\741rprt-full_shg.gif