(1)
CASHBOOK RECONCILIATION

The Cashbook Reconciliation package is an additional MC OFFICE Software Accounting package to meet the needs of lenders. This specific package is for balancing the cashbook to the various custodial accounts. The Cashbook Reconciliation program automates the balancing of the cashbook.

All deposits added and checks disbursed from the various custodial accounts from the following MC OFFICE Software packages will funnel through the Cashbook Reconciliation programs:

Mortgage Banker Loan Servicing Construction Pool Disbursement

- - - -

Custodial Account Custodial Accounts Custodial Account if used Custodial Account if used

The path to the Cashbook Reconciliation package is selection 07. ACCOUNTING from the Main Menu.

MC OFFICE Main Menu

There are three selections for the Reconcile Cashbook package listed under RECONCILE CASHBOOK. The three options are selections 05. MAINTAIN CHECKING ACCOUNT, 06. RE-ISSUE CHECKS, and 07. RECONCILIATION.

Accounting Main Menu (07)

This selection will be used to add information to the Cashbook data to be processed through the MC OFFICE Software package. Transactions such as credit card withdrawals, miscellaneous credits to the account, deduction of service charges, automatic withdrawal made by Fannie Mae, Freddie Mac and others, miscellaneous charges, and adding checks that were not disbursed through one of the MC OFFICE Software packages.

This selection will be used to initialize the Cashbook Reconciliation. Checks that have not cleared the account and remain outstanding have to be entered at the time the program is set up. Thereafter, this feature will be used only to record those entries not processed though the normal functions of the MC OFFICE Software.

On occasion it will be necessary to re-issue checks. A check could have been lost, destroyed, payable to the wrong person, or even for the wrong amount and voided.

This program permits the operator to re-issue a check, void the previously written check, and add this new check to the list of outstanding checks, not yet paid by the financial institution handling the account.

The re-issuance of a check does not change the balance in the cashbook account. The program will not permit a check to be written for an amount more or less than the amount of the previous check that is being replaced.

On a monthly basis it is necessary to balance the cashbook accounts. This selection is to reconcile the account to the deposits made, checks written and paid, and those checks not yet paid. There is an auditing feature offered by reconciling the cashbook accounts to assure no checks have been stolen, checks written out of sequence, or the payee has altered the check, and no kiting.

It is necessary to make entries not processed through one of the MC OFFICE Software packages through the Maintenance selection prior to commencing the reconciliation.

A list of checks unpaid is maintained by the program. The ending balance for the month is automatically carried forward as the beginning cashbook balance for the next month.

SET UP TO USE

To use the Cashbook Reconciliation package requires initial setup of the package of the accounts, at which financial institution they are held and the data from each MC OFFICE Software package that will pass to each of the accounts.

When the Cashbook Reconciliation programs is loaded and the financial institution accounts are set up, the data commences to pass to the Cashbook Reconciliation programs. However, this may not be a cut-off date for the checking account.

There are four steps to set up the package.

		Determine at which financial institution will the various cashbook custodial accounts be held. The financial institution will need to be assigned a code number.
		What is the assigned account number at the financial institution for the account to be used by the MC OFFICE Software package.
		Set up the financial institution, code number, name, and address. Then add the account numbers and which MC OFFICE Software package will use the account. Enter the type of account and the statement cutoff date.
		Within each MC OFFICE Software package linking to the Cashbook Reconciliation program, the transactions passing to the account must be indicated as to which financial institution and account the transaction will be posted.

These accounts are set up selecting 07. ACCOUNTING on the Main Menu. From the ACCOUNTING menu, select 10. BANK CODES & ACCOUNTS and complete the above steps.

This selection is to set up the financial institutions and accounts to be used by the MC OFFICE Software packages. The screen displays all financial institutions that have been set up.

Bank Codes & Accounts Screen Display (07.10)

When adding additional financial institutions, assign the financial institution code, enter the financial institution name, address, city, state, ZIP Code, and the additional information to define the individual accounts.

CODE

Enter the code number you have assigned for that financial institution. The field size is three numeric (XXX). Enter a code number between 1 and 998. The number 999 is not available.

BANK

Enter the name of the financial institution. The term Bank is used to mean any type of financial institution that offers checking accounts (credit unions, mutual banks, savings banks, savings and loans, etc.).

ADDRESS

Enter the address of the financial institution.

CITY

Enter the city of the financial institution.

ST

The state the financial institution is located.

ZIP

The ZIP Code of the financial institution.

FUNCTION KEY USAGE

<SCF3>HELP

Basic instruction on how to use the function keys shown on the screen.

<F2>FORWARD

Scrolls forward to the next screen.

<F3>BACKWARD

Scrolls backward to the previous screen.

<F7>ADD

To add another financial institution.

<A>SEARCH ACCOUNT

This feature is when the account is known but not the financial institution. The program will search and display those financial institutions that have the account number selected.

<SF8>DELETE ACCOUNT

Deletes an account. An account can only be deleted providing no funds are in the account.

<ESC>RETURN

Return to the previous screen.

This screen explains the use of the various function keys.

Bank Codes & Accounts Screen Display (07.10.<SCF3>)

To add a financial institution, use this selection. When the screen is displayed, enter the assigned code selected for this financial institution and complete entry of the data requested. All the accounts could be at the same financial institution.

Bank Maintenance Screen Display (07.10.<F7>)

BANK CODE

Enter the assigned financial institution. This is the link from the various MC OFFICE Software packages to the accounts.

NAME

Enter the name of the financial institution.

ADDRESS

There are two lines for the address of the financial institution where the accounts are held.

CITY, STATE, ZIP

Enter this information.

TRANSIT ROUTING

Enter the assigned Federal Reserve Clearing Account Number. This information is not used by the program. However, it is available if and when it might be used in the future.

The program has been designed for a possible 32 separate accounts from the MC OFFICE Software packages that could be at a financial institution.

PKG

Bank Maintenance Partial Screen Display (07.10.<F7>.<PKG>)

PKG is an abbreviation for package. This is the MC OFFICE Software package where the data for deposits and checks will be coming from.

Fields 09 through 32, enter the MC OFFICE Software package for the account. Select one of the following:

<MB> <LS> <PD> <CA> <AP>

for for for for for

Mortgage Banker Loan Servicing Pool Disbursement Construction Accounts Payable (under development)

CTL

Bank Maintenance Partial Screen Display (07.10.<F7>.<PKG>.<CTL>)

CTL is the abbreviation for control, the control number this account will correspond to in the MC OFFICE Software. Then enter the actual Account Number within the control. The CTL is a three-digit field. You do not need to zero fill the field. If the control is 1, enter just the 1. After leaving the screen, the program will zero fill the field automatically to be 001.

Then enter the financial institution assigned Account Number where the data from the control will be passed. The ACCT is 16 digits and will accept alpha and numeric characters.

MORTGAGE BANKER

For Mortgage Banker there would be one for the package. There is only one custodial account for the Funds Accounting program (01.16) used by all branches.

LOAN SERVICING

In Loan Servicing this would be the various control numbers. Each control could have a P&I and T&I type custodial account.

The one escrow check-writing account is identified in the LS Master Control Field 51 Cash/Disbursements Out. This clearing account must be set up here first. Contra Bank Account-Clearing Account (07.09.01). The escrow clearing account will have no control portion entered in the setup.

POOL DISBURSEMENT

In the Pool Disbursement package, the Bank Code and custodial P&I and T&I accounts are identified in Fields 04 and 05 of the Pool Master. The issuer code would be the control number.

CONSTRUCTION

For Construction, this would be one for the package. There is one custodial account for disbursements. The Bank Codes are identified within the package (02.11.05) and ACCOUNTING (07.10).

Bank Maintenance Partial Screen Display (07.10.<F7>.<PKG>.<CTL>.<TYPE>)

TYPE

What type of account this will be. Select:

<PI> <TI> <CU> <GN> <OT>

PRINCIPAL & INTEREST account TAX & INSURANCE account CUSTODIAL account GENERAL account OTHER account

ST DAY

ST DAY (Statement Day) means the day of the month the checking account statement is cut off. Enter the day for each of the various accounts.

Bank Maintenance Partial Screen Display (07.10.<F7>.<PKG>.<CTL>.<TYPE>.<STDAY>)

Within each MC OFFICE Software package that links to the Cashbook Reconciliation program, the transactions that will pass to the account must be indicated as to which financial institution and account the transaction will be posted. These accounts are set up from the path: 07. ACCOUNTING on the Main Menu, then on the Accounting menu selection 10. BANK CODES & ACCOUNTS. Determine the date you want to begin using the package. If possible, wait until the cut-off date for the checking account statement before starting. When the General Ledger account is set up and linked to the various MC OFFICE Software packages, the data will commence transferring over. Set up the Bank Codes and Accounts (07.10). The General Ledger Interface (07.09.01) for the custodial accounts cannot be set up until after the Bank Codes are set up. Review the General Ledger Interface accounts to assure all custodial accounts are set up with the correct Bank Code.

(1.4.3)
Contra Accounts

Contra means off-setting. If this account is debited, automatically credit this account number. When funds are moved from a T&I Custodial account to a Clearing Account, the debit is to the T&I Account and the contra is the Clearing Account. The program moves the funds on paper. However, the actual transfer of funds from the T&I account to the Custodial Account must be done physically.

(2)
HOW TO USE CASHBOOK RECONCILIATION

Selection 05 is used for the manual entry of checks, deposits, and various other transactions.

Maintain Checking Account Screen Display (07.05)

The screen displays for all of these transactions are the same. Refer to the TRAN TYPE column for indication of transaction type.

<D>DEPOSIT

To record a deposit to a specific account. A screen will open and display the tran type (deposit), you then enter the date of transaction, amount, and a brief description.

The advance of corporate funds for negative escrow balances will be entered here for the escrow T&I accounts for various investors.

The balance will also be displayed.

<B>BANKCARD WITHDRAWAL

To record a bankcard withdrawal to a specific account. A screen will open and display the tran type (bankcard), you then enter the date of transaction, amount, and a brief description.

<N>MISC CREDIT

To record a miscellaneous credit to a specific account.

<S>SERVICE CHARGE

To record a service charge assessed to a specific account.

<C>CHECK

To record a check written against this account. This is manual entry of a check not disbursed through MC OFFICE Software.

<A>AUTOMATIC WITHDRAWAL

To record an automatic transfer withdrawal from the account specified.

<M>MISC CHARGE

To record a miscellaneous charge to the account specified.

<O>CHECK OUT

To see an entry for check out option for funds disbursed without a check number.

<SF8>DELETE

After you manually delete any transaction entered, the program will display DEL on the line next to the entry.

<F8>VIEW ACCOUNT

To view the account selected.

This option is available through menu options 05. MAINTAIN CHECKING ACCOUNT, 06. RE-ISSUE CHECKS, and when you print the Check Register and the Bank Account History.

View Account Screen Display (07.05.<F8>)

TYPE

Indicates deposit, bankcard withdrawals, miscellaneous credit, service charge, check, automatic withdrawal, or miscellaneous charge.

If the type has a C before it, it has been canceled and re-issued. An R means it is a re-issued check, and a V means the check has been voided.

CHECK NO.

Shows the number of the check.

DATE

The date of the transaction.

CREDIT/DEBIT

The amount of the transaction and whether it was a credit or debit.

NAME OR DESC

The payee the check was written to or the description of the transaction.

<F2>FORWARD

Scroll forward to view additional information.

<F3>BACKWARD

Scroll backward to view previous screens.

Deleted entries will not show on the View Account.

(2.2)
06. Re-Issue Checks

Re-Issue Checks Screen Display (07.06)

The procedure to cancel and re-issue a check is as follows:

Enter the check number to be canceled and the program will ask for a new check number. Enter the new check number, date, amount, etc. To void a check, enter the check number and press <V> to void.

Enter the check numbers used when aligning the checks for printing.

When the various packages process checks, the question is asked if the checks printed correctly. If reprinting is indicated, the program will automatically enter the check numbers to be voided. No need to enter them manually in this option.

<F8>VIEW ACCOUNT

To view the account selected.

All checks that are disbursed from MC OFFICE Software will funnel through Cashbook Reconciliation. This adds automation to balancing the cashbook. MC OFFICE Software that will use Cashbook Reconciliation programs are the following:

• Mortgage Banker
• Loan Servicing
• Pool Disbursement
• Construction
• Accounts Payable

Reconciliation Main Menu (07.07)

STEPS TO USING THE
Cashbook Reconciliation Program

		When the checking account statement is received, enter the Cashbook Reconciliation program (07.07.01). Enter the statement period the checking account statement is covering and the balance from the checking account statement.
		Enter the balance from your checkbook, as of the date of the checking account statement. This will be the balance on the trial balance for that custodial account of the same date as the statement. This is done the first time only.
		Check your deposits with the checking account statement to make sure each deposit has been properly credited. If the deposits are correct, close the deposits, <SF7>.
		Review the checks processed by the bank or credit union. Mark the checks that have been paid. Since most checks issued will be paid, update all by pressing <SF7>. Next, remove the X-Paid for the checks that have not cleared the account.
		Return to the Cashbook Reconciliation screen. If the custodial account balance equals the checking account statement, print the statement. If the account does not balance, determine why. Make any adjustments for automatic transfers where no check was written, any credit card deductions, fees, or errors on checks.
		Print the Monthly Reconciliation and retain for auditors. File the checks and deposits.
		Now the account is balanced, close the checking account. The ending balance is transferred automatically as the beginning balance for the next checking account statement period. The date is updated for the next checking account statement date.

Checking accounts should be balanced every period. If no checks are written from the account, there could still be deposits and transfers by staff or wire.

In starting the Cashbook Reconciliation program, there may be problems balancing. If so, make the adjustments to bring the account in balance. There are several lines to explain any reason.

An example would be fees charged, wire transfer of funds, error in deposit or check, etc.

Once the account is in balance, it should be routine to balance each checking account period.

(2.3.1)
01. Monthly Reconciliation

Monthly Reconciliation Screen Display (07.07.01)

DEPOSITS TO ACCOUNT

To the beginning cashbook balance the program will add all deposits to this account accumulated from the Transaction History and Monthly GL Interface Summary for this account.

CHECKS & WITHDRAWALS FROM ACCOUNT

The program will subtract the amount of funds withdrawn from the account as indicated on the Transaction History and Monthly GL Interface Summary for this account.

DEPOSITS NOT CLEARED ACCOUNT

Enter the deposits that have been made but are not reflected on the statement.

CHECKS NOT PAID/CLEARED ACCOUNT

A listing of all outstanding checks is displayed from prior periods and all checks issued for this period using the check register. Subtract checks not paid by bank or that have not cleared the account.

ADJUSTMENTS

Enter any adjustments needed to balance this account. Adjustments will still need to be entered into the account through MAINTAIN CHECKING ACCOUNT (07.05). If it is an adjustment to deposit, enter the amount of difference of the unmatched amount.

CASHBOOK TO BANK BALANCE DIFFERENCE

Computed difference between the bank balance entered and the checks that have not cleared.

<SF8>BEGINNING CASHBOOK BALANCE

The program stores the ending balance from the prior period. After the statement has been closed, this becomes the beginning cashbook balance for the next period.

This amount can be modified with a password when pressing <SF8>. Passwords are user defined and set up in Security.

When first beginning, you would enter the ending balance from your last/previous bank statement.

<F4>PRINT

BR010.00 MONTHLY RECONCILIATION is explained in detail in 10. MONTHLY RECONCILIATION.

<F8>STATEMENT DATE

Select the statement date. Enter the statement ending date. The beginning statement date will be one day after the statement date of the previous month.

<F7>BANK BALANCE

Enter the ending bank account balance shown on the statement.

<SF6>DEPOSITS

To review deposits made during this period and mark the deposits which have cleared the bank.

Use the Monthly Interface Summary Report to mark the deposits for this account.

<SF7>CHECKS

Displays all outstanding checks (not paid by bank and cleared account) for all prior periods and all checks written, re-issued, voided, or canceled for the current statement period.

<SF2>CLOSE STATEMENT

When this account has been balanced, use this option to close out the statement until the next statement is received. A password is required to close the monthly cycle.

If you did not just previously select <F4>PRINT, the <SF2> will force the program to include a printed copy.

The Cashbook Reconciliation program will be active from the time Bank Codes (07.10) are set up identifying the accounts for the various MC OFFICE Software.

Deposits Detail Screen Display (07.07.01.<SF6>)

DATE

Date of the deposit to the account.

AMOUNT

Amount of the deposit to this account.

CLEAR

Enter to indicate deposit has cleared (posted on statement) the account.

<SF4>SHOW SUMMARY

This selection will display an additional line per day for the total deposits made each day. The <SF4>SHOW SUMMARY option will toggle to OMIT SUMMARY. The operator can select to either show or omit the summary line.

<F6>REPEAT

Repeat all fields in the CLEAR column will display the following options to mark the entry:

Deposits Detail Partial Screen Display (07.07.01.<SF6>.<F6>)

If the deposit showing is incorrect according to your records, indicate the difference by pressing <U>UNMATCHED AMOUNT and entering the correct amount. Do not use <U>UNMATCHED AMOUNT if the deposit showing is correct.

<SF7>UPDATE ALL

Use the <SF7> first to update all amounts, then <F6> to enter throughout the list. Press the space bar to remove the X-CL from the CLEAR column for the deposits that did not clear.

For the various Loan Servicing P&I control’s accounts this will be the daily total amount deposited to the 2 INTEREST DUE and 4 PRINCIPAL RECEIVABLE defined in the General Ledger Interface. It would be the total for the day’s activity of escrow funds received in the 5 ESCROW PAYABLE if this is the T&I control custodial account.

Deposits Detail (Show Summary) Screen Display (07.07.01.<SF6>.<SF4>)

<SF4>OMIT SUMMARY

This selection displays the deposits made but omits the summary total line for the day’s activity. The <SF4>OMIT SUMMARY option will toggle to SHOW SUMMARY. The operator can select to either show or omit the summary line.

Checks Summary Screen Display (07.07.01.<SF7>)

CHECK

Displays the check number or CHK OUT no check was written by the program.

For the various LS control's bank accounts, this will be the total amount disbursed for the day. The report will indicate CHK OUT. Only the check-writing Contra LS Account will indicate the actual check number.

DATE

Date the check was written.

AMOUNT

Amount of the check.

CLEAR

Flag when checks have been paid from the account and shown on statement. Once the checks have shown cleared for the statement, the next statement period will not display the previously cleared checks. To show any previously cleared checks, the operator can enter a beginning date when pressing <SF8> for auditing.

<F6>REPEAT

Repeat all fields from the beginning of the CLEAR column. The program will skip over void, re-issued, or canceled checks.

Checks Summary Partial Screen Display (07.07.01.<SF7>.<F6>)

<SF7>UPDATE ALL

Enter an X - PD on all checks.

Use the <SF7> first to update all amounts, then <F6> to enter throughout the list. Press the space bar to remove the X-CL from the CLEAR column for the deposits that did not clear.

(2.3.2)
02. Account Exceptions

This selection displays accounts that have not been balanced. If any accounts are displayed, this would indicate the account has not been reconciled for the month. All accounts must be balanced every month.

Account Exceptions Screen Display (07.07.02)

<F2>FORWARD

Displays the next screen of account exceptions.

<F3>BACKWARD

Displays the previous screen of account exceptions.

Use this to verify the activity for the month is completed.

These are the various reports available in the Cashbook Reconciliation program. Each of the reports will be explained in detail on the following pages.

Report of Accounts Main Menu (07.07.03)

This selection provides a listing of all accounts not balanced. It lists by bank code and then by account number.

This report is 80 columns wide. The following items are included in the report:

BANK

Bank Code representing the institution where the checking account is.

ACCOUNT NUMBER

Checking account number.

AMOUNT OUT OF BALANCE

Dollar amount account is out of balance.

-STATEMENT DATES-
PREVIOUS CURRENT

Month-Day-Year for previous and current statement dates.

Accounts Not Balanced Sample Report (07.07.03.01.<P>)

This selection provides a listing of missing, voided, and re-issued checks. It lists by bank, account number, and date range.

Missing Checks-Void-Re-Issued Print Screen (07.07.03.02)

<B>BANK RANGE FROM: THRU:

Indicate the Bank Code range.

<F2>ALL BANKS

Will include All Bank Codes.

<A>ACCOUNT RANGE FROM: THRU:

Indicate the checking account range.

<F2>ALL ACCOUNTS

Will include all accounts.

<D>DATE RANGE FROM: MM-DD-YY THRU: MM-DD-YY

Indicate the date range.

SELECTION

Displays the selection the operator has made.

This report is 132 columns wide. The following items are included in the report:

BANK

The Bank Code representing the institution.

ACCOUNT

The custodial checking account number.

CHECK NO.

Lists the checks by number that are missing, void, and re-issued.

Missing Checks-Void-Re-Issued Sample Report (07.07.03.02.<P>)

This selection provides a listing of checks that have not been paid or that have not cleared. It lists by bank, account number, and date range.

Checks Not Paid/Cleared Print Screen (07.07.03.03)

<B>BANK RANGE FROM: THRU:

Indicate the Bank Code range.

<F2>ALL BANKS

Will include all Bank Codes.

<A>ACCOUNT RANGE FROM: THRU:

Indicate the checking account range.

<F2>ALL ACCOUNTS

Will include all accounts.

<D>DATE RANGE FROM: MM-DD-YY THRU: MM-DD-YY

Indicate the date range.

SELECTION

Displays the selection the operator has made.

This report is 132 columns wide. The following items are included in the report:

BANK

The Bank Code representing the institution.

ACCOUNT

The custodial checking account number.

CHECK NO.

The number on the check.

DATE

The date the check cleared.

AMOUNT

The amount of the check. This column will be totaled.

NAME

Indicates to whom check is written.

DESCRIPTION

Brief description.

Checks Not Paid/Cleared Sample Report (07.07.03.03.<P>)

This selection provides a listing of all checks that have been paid in a specified date range. It lists by bank, account number, and date range.

Checks Paid (Date Range) Print Screen (07.07.03.04)

<B>BANK RANGE FROM:     THRU:

Indicate the Bank Code range.

<F2>ALL BANKS

Will include all Bank Codes.

<A>ACCOUNT RANGE FROM:     THRU:

Indicate the checking account range.

<F2>ALL ACCOUNTS

Will include all accounts.

<D>DATE RANGE FROM: MM-DD-YY THRU: MM-DD-YY

Indicate the date range.

SELECTION

Displays the selection the operator has made.

This report is 132 columns wide. The following items are included in the report:

BANK

The Bank Code representing the institution.

ACCOUNT

The custodial checking account number.

CHECK NO.

The number on the check.

DATE

The date the check cleared.

AMOUNT

The amount of the check. This column will be totaled.

NAME

Indicates to whom check is written.

DESCRIPTION

Brief description.

Check Paid (Date Range) Sample Report (07.07.03.04.<P>)

The voided and canceled checks will be omitted from the Checks Not Paid/Cleared list but will be included on the Checks Paid list.

This selection provides a listing of all deposits made to an account in a specified date range. It lists by bank, account number, and date range. The report indicates the date, amount of deposit, whether cleared, and a comment field.

Deposit List (Date Range) Print Screen (07.07.03.05)

<B>BANK RANGE FROM: THRU:

Indicate the Bank Code range.

<F2>ALL BANKS

Will include all Bank Codes.

<A>ACCOUNT RANGE FROM: THRU:

Indicate the checking account range.

<F2>ALL ACCOUNTS

Will include all accounts.

<D>DATE RANGE FROM: MM-DD-YY THRU: MM-DD-YY

Indicate the date range.

SELECTION

Displays the selection the operator has made.

This report is 132 columns wide. The following items are included in the report:

BANK

The Bank Code representing the institution.

ACCOUNT

The custodial checking account number.

DATE

The date the check cleared.

AMOUNT

The amount of the check. This column will be totaled.

CLR

Indicates the check cleared.

COMMENT

Brief comment line.

Deposit List (Date Range) Sample Report (07.07.03.05.<P>)

This selection provides a listing of unmatched items, e.g., items that cleared the checking account for an amount different than the amount issued.

Unmatched Items Print Screen (07.07.03.06)

<B>BANK RANGE FROM: THRU:

Indicate the Bank Code range.

<F2>ALL BANKS

Will include all Bank Codes.

<A>ACCOUNT RANGE FROM: THRU:

Indicate the checking account range.

<F2>ALL ACCOUNTS

Will include all accounts.

<D>DATE RANGE FROM: MM-DD-YY THRU: MM-DD-YY

Indicate the date range.

SELECTION

Displays the selection the operator has made.

This report is 132 columns wide. The following items are included in the report:

BANK

The Bank Code representing the institution.

ACCOUNT

The custodial checking account number.

CHECK NO.

The number on the check.

DATE

The date the check cleared.

AMOUNT WRITTEN

Amount written on the check register.

AMOUNT PAID

Amount the check cleared at.

NAME

Indicates to whom check is written.

DESCRIPTION

Brief description.

Unmatched Items Sample Report (07.07.03.06.<P>)

This selection is to print a check register. It will print by date range. It lists by bank, account number, and date range. This selection also allows one to view an account.

Check Register Print Screen (07.07.03.07)

<V>VIEW ACCOUNT

View the custodial account.

<A>BANK: ACCOUNT:

Indicate the Bank Code and custodial account.

<N>NEXT ACCOUNT

Displays the next account in the package.

<D>DATE RANGE FROM: MM-DD-YY THRU: MM-DD-YY

Indicate the date range.

This report is 132 columns wide. The following items are included in the report:

BANK CODE

The Bank Code representing the institution.

ACCT NO

The custodial checking account number.

CHECK NO

The number on the check.

DATE

The date the check cleared.

CHECK AMT

The amount of the check.

CLEARED

Indicates if cleared.

PAYEE

To whom the check is written.

DESCRIPTION

Brief description. The description will indicate the LS disbursement code and type, e.g., LS 51-MIP, LS EB Escrow Refund, etc.

Check Register Sample Report (07.07.03.07.<P>)

This selection provides a listing of all bank accounts.

List of Bank Accounts Print Screen (07.07.03.08)

<B>BANK RANGE FROM: THRU:

Indicates the Bank Code or range of Bank Codes.

<F2>ALL BANKS

Press <F2>ALL BANKS to list by banks instead of range.

SELECTION

Displays the selection the operator has made.

This report is 132 columns wide. The following items are included in the report:

BANK

The Bank Code for the institution.

BANK NAME

Name of the institution.

TRANSIT

Transit Routing number used by institution.

PROG

<MB> <LS> <PD> <CA> <AP>

Mortgage Banker Loan Servicing Pool Disbursement Construction Accounts Payable

CTL

Indicates the Branch or Control used by the package.

ACCOUNT

Custodial account number.

TYPE

Indicates the two-letter code for the type as follows:

<PI> <TI> <CU> <GN> <OT>

Principal and Interest account Tax and Insurance account Custodial account General account Other

ST

Day of the month for the statement cycle.

List of Bank Accounts Sample Report (07.07.03.08.<P>)

The Trial Balance lists by bank range or all banks. It indicates the bank, bank name, account number, and amount. The report subtotals by bank with a grand total for all banks.

Trial Balance Print Screen (07.07.03.09)

<B>BANK RANGE FROM: THRU:

Range of Bank Codes.

<F2>ALL BANKS

Will include all Bank Codes.

SELECTION

Displays the selection made by operator.

This report is 80 columns wide. The following items are included in the report:

BANK

The Bank Code representing the institution.

BANK NAME

Name of the institution.

ACCOUNT

Custodial account number.

AMOUNT

Balance in the account listed.

Trial Balance Sample Report (07.07.03.09.<P>)

This selection provides a printed copy of the Monthly Reconciliation by bank, account number, and statement date.

This also prints transactions not cleared by bank, account number, and statement date. The transactions not cleared include the transaction type, check number, date, amount, name, and a description.

Monthly Reconciliation Print Screen (07.07.03.10)

<B>BANK RANGE FROM: THRU:

Indicate the Bank Code range.

<F2>ALL BANKS

Will include all Bank Codes.

<A>ACCOUNT RANGE FROM: THRU:

Indicate the checking account range.

<F2>ALL ACCOUNTS

Will include all accounts.

<D>DATE RANGE FROM: MM-DD-YY THRU: MM-DD-YY

Indicate the date range.

SELECTION

Displays the selection the operator has made.

This report is 132 columns wide. The following items are included in the report:

BANK CODE

The Bank Code representing the institution.

ACCOUNT NUMBER

Custodial account number at institution.

STMT: MM-DD-YY THRU MM-DD-YY

Statement date range.

BANK ACCOUNT BALANCE

Statement balance in the account.

BEGINNING CASHBOOK BALANCE

Beginning cashbook balance at start of statement date.

DEPOSITS TO ACCOUNT

Deposits added to the account.

CHECKS & WITHDRAWALS FROM ACCOUNT

Minus checks and withdrawals from the account.

DEPOSITS NOT CLEARED ACCOUNT

Add deposits not cleared.

CHECKS NOT PAID/CLEARED ACCOUNT

Minus the checks not paid or cleared.

ADJUSTMENTS

Three lines for add (+) adjustments and three lines for minus (-) adjustments.

ENDING CASHBOOK BALANCE

Indicates the subtotal of the column for ENDING CASHBOOK BALANCE.

CASHBOOK TO BANK BALANCE DIFFERENCE

Any difference will be indicated.

Monthly Reconciliation (Page 1) Sample Report (07.07.03.10.<P>)

BANK

The Bank Code for institution.

ACCOUNT

Account at the institution.

TRAN TYPE

Indicates a deposit or withdrawal.

CHECK NO.

Deposits will indicate the LS, MB, or PD account number set up in GL Interface. CHK OUT indicates the account the checks are written from.

DATE

Date of transaction.

AMOUNT

Amount of transaction.

DAY DEPOSIT TOTAL

This will indicate a total amount on the last line of activity for the day.

NAME

Name of payee.

DESCRIPTION

Brief description of the GL Interface account number.

Monthly Reconciliation - Deposits (Page 2) Sample Report (07.07.03.10.<P>)

BANK

The Bank Code for institution.

ACCOUNT

Account at the institution.

TRAN TYPE

Indicates a deposit or withdrawal.

CHECK NO.

Deposits will indicate the LS, MB, or PD account number set up in GL Interface. CHK OUT indicates the account the checks are written from.

DATE

Date of transaction.

AMOUNT

Amount of transaction.

NAME

Name of payee.

DESCRIPTION

Brief description of the GL Interface account number.

Monthly Reconciliation - Checks (Page 3) Sample Report (07.07.03.10.<P>)

This selection provides an account history for each account. It lists by bank, account number, and date range. This report includes the transaction type, date, debit (out), credit (in), the check number, whether cleared, payee, and a description. It also allows viewing of the account and allows account history to be deleted after printing.

Bank Account History Print Screen (07.07.03.11)

<E>DELETE AFTER PRINTING

Indicate if after printing you want the information purged from the package.

<V>VIEW ACCOUNT

Indicate the account to view. This screen will have a <F2>FORWARD and <F3>BACKWARD key to scroll through the various months of history.

<A>BANK: ACCOUNT:

Indicate the Bank Code and account to start the display or print.

<N>NEXT ACCOUNT

Moves to the next account to display.

<D>DATE RANGE FROM: MM-DD-YY THRU: MM-DD-YY

Indicate the date range for the history display or print.

This report is 132 columns wide. The following items are included in the report:

BANK CODE

The Bank Code of institution.

ACCT NO

Custodial account number at institution.

MM-DD-YY TO MM-DD-YY

Date range.

TRAN TYPE

Indicates a deposit or withdrawal.

DATE

Date of transaction.

DEBIT(OUT)

Indicates a withdrawal or debit out of account.

CREDIT(IN)

Indicates a credit or money deposited to account.

CHECK NO

Indicates check number.

CL

Indicates if check has cleared.

PAYEE

Name of payee if a withdrawal or check has been disbursed.

DESCRIPTION

Brief description of GL Interface account number.

Bank Account History Sample Report (07.07.03.11.<P>)

---

---