home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Share Gallery 1
/
share_gal_1.zip
/
share_gal_1
/
BF
/
BF030.ZIP
/
LMMENUSW.ZIP
/
LMMENUSW.MAN
< prev
next >
Wrap
Text File
|
1990-12-09
|
265KB
|
8,445 lines
*****************************************************************************
* NOTICE *
* *
* The manual tells you that this software does not work for computer *
* experts who do not read the manual. It is not kidding. This software *
* will not produce the results you expect unless ALL the dates are *
* set correctly. You CANNOT SET THEM CORRECTLY UNLESS YOU READ THIS *
* MANUAL. Pay close attention to the section on setting up new loans *
* beginning on page 63. Also read the section titled problems with test *
* data on page 105. *
* *
* WHEN THE PROGRAM IS EXECUTED, IT WILL TELL YOU THE DATE AND ASK YOU *
* TO VERIFY IT IS CORRECT. FOR THE TEST DATA TO WORK CORRECTLY YOU *
* MUST RESPOND WITH THE DATE: *
* *
* 01-01-88 *
* *
* FAILURE TO SET THIS DATE WILL RESULT IN NOT RECEIVING PROPER PAST *
* DUE NOTICES AND WILL BE DUE NOTICES. *
* *
*****************************************************************************
*****************************************************************************
* NOTICE *
* *
* Loan Master requires as many as 12 files to operate. *
* *
* DOS will not allow this many files to be accessed unless it is *
* instructed to do so by the CONFIG.SYS file. This file is found *
* in the root (main) directory of your boot disk. The CONFIG.SYS *
* file MUST CONTAIN A LINE WHICH SAYS: *
* *
* files=20 *
* *
* The actual number may be 20 or any larger number. *
* *
* If the number is not large enough, the program will crash with an *
* error message that looks like: *
* *
* ... database required ... *
* *
*****************************************************************************
This manual was written and formatted to be printed as a typeset manual.
The Registered version of the program comes with the printed manual. It
is printed in helvetica type in 8 to 14 point typefaces and is quite
readable.
The normal 10 CPI dot matrix printer simply cannot adequately reproduce
the manual. You will find the pages to be too full and the margins to be
inadequate or non existant.
If you can set your printer to 12 characters per inch, you can produce
a somewhat neater document by moving the paper about 1/2 inch to the left
to increase the margin somewhat.
If you are using a laser printer, be sure to set it for 66 lines per
page. If this is not done, the page breaks will not be correct.
Loan Master Loan Accounting software is a "bank type" loan
accounting system for simple interest loans. It stores and
computes interest and late charges on simple interest loans of any
type.
Loan Master performs these functions:
Compute interest accruals
Report Past due status
Compute and report late charges due
Accept interest, principal and late charge payments
Maintain current balance and year to date totals
Print trial balance and past due report
Print Past due notices
Print a custom past due notice using your text.
Print will be due notices.
Print loan transaction statements
Print year end interest paid notices for borrowers.
Stores all data necessary to maintain the current status of any
simple interest loan.
Provides three user definable fields which can be posted to
maintain balances and ytd totals for individual needs such as:
Escrow balances
Returned check charges
Prepayment penalties
Collections expenses
Servicing fees
Dealer reserve or income participation
etc, etc, etc,
(remember 3 total postable fields)
Provides six numeric tickler fields. You can assign names and
insert any numeric data. (No calculations are done.)
Provides two 30 character alpha fields. You assign the names.
Planned future features:
On screen collections. Computer will report who is past due and
prompt you call them. It will then record your collections
activities and the borrowers responses.
Loan master 78 Support for rule of 78ths loans.
Report writer to allow each user to create individualized custom
reports utilizing any data in the database.
Additional functions provided by other products:
Maintain records of all loan documents and report impending
expiration dates for any type document.
Maintain a watch list of non performing or troubled loans.
Calculate and print amortization schedules for any type loan,
including loans with totally irregular schedules and multiple
draws. (Lines of credit or revolving lines of credit.)
On line manual.
Some computers have color capable vidio display electronics with
monochrome monitors. These computers sometimes do not display all
colors visibly.
The On Line Manual is normally displayed with red text on a white
background. Some computers cannot display the on line manual menus
in this color scheme. The manual describes the instalation of
a special monochrome version of this manual so these computers
can display the manual properly. Unfortunately, the system will not
fit on the distribution disk. The shareware version therefore is
shipped with only the monochrome version of the manual. This version
will work on any monitor. The registered version comes with both
versions.
Pricing for the registered versions:
Loan Master Loan Accounting Application $ 249.95
Customer Information File Application $ 249.95
Custom Report Writer $ 99.95
On Line Collections $ 249.95
On Line Collections expenses $ 249.95
DocTrac Document tracking $ 495.95
PCLOAN5 Loan amortization system $ 79.95
Interest Checker, free form amortization $ 79.95
Mortgage Comparison and reduction strategies $ 79.95
Watchlist II, Watchlist of classified loans $ 495.00
Packaged Pricing:
Loan Accounting + Customer Information
+ Report Writer $ 495.00
Support:
Telephone support. First two hours $ free
Additional hours $ 30.00
Updates:
Update subscriptions, all updates
all applications, per year $ 100.00
LOAN MASTER
Loan Accounting System
WARNING
This software does not work
for computer experts!
It works only for those operators
who take the time study the manual.
Do not enter trial data just to see what happens.
SUGGESTION
This is a loan accounting application. It makes very
heavy use of several different dates. If you do not
understand exactly what these dates are and how the system
uses them, you cannnot produce a meaningful result.
Do not attempt to enter real data or produce real loan
reports without first reading the sections of the manual
which explain the meaning and uses of the dates. Pay special
attention to system_date, date_first, date_next, date_due,
date_last, date_tran, and date_upd, and the section on
setting up new and existing loans. Then do the examples for
setting up a new loan and an existing loan.
LOAN MASTER
Loan Processing System
Version 1.21
Date 12-12-90
Copyright 1989,90
Bottom Line Software
P. O. Box 1804
Burleson, Texas 76028-1804
817-447-5524
TABLE OF CONTENTS
License Agreement . . . . . . . . . . . . . . . . . . . 1
Installation . . . . . . . . . . . . . . . . . . . . . 4
Automatic installation . . . . . . . . . . . . . . 4
Manual installation . . . . . . . . . . . . . . . 4
Path to data files . . . . . . . . . . . . . . . . 5
Automatic data file conversion . . . . . . . . . . . . 5
Running the conversion program . . . . . . . . . . 6
Converting your parameter file . . . . . . . . . . 7
If the program crashes on startup. . . . . . . . . 7
Upgrading Loan Master Versions . . . . . . . . . . . . 9
User defined options, the parameter file . . . . . . . 9
Help function . . . . . . . . . . . . . . . . . . . . . 9
Customizing help screens . . . . . . . . . . . . . 9
On Line Manual . . . . . . . . . . . . . . . . . . . . 10
Menu operations . . . . . . . . . . . . . . . . . . . . 11
Using the menus . . . . . . . . . . . . . . . . . 11
Selecting menu options . . . . . . . . . . . . . . 11
Data entry screens . . . . . . . . . . . . . . . . . . 12
Data entry cursor control keys . . . . . . . . . . 13
Date Screen . . . . . . . . . . . . . . . . . . . 16
Loan look up menu. . . . . . . . . . . . . . . . . 17
New Loan Screen . . . . . . . . . . . . . . . . . 18
User defined screen . . . . . . . . . . . . . . . 18
Loan Maintenance Screen . . . . . . . . . . . . . 19
Browse screens . . . . . . . . . . . . . . . . . . 19
Browse Cursor Control Keys . . . . . . . . . . . . 21
Menu functions . . . . . . . . . . . . . . . . . . . . 23
Setting up an existing loan . . . . . . . . . . . 24
Add A loan Record . . . . . . . . . . . . . . . . 24
Add an existing loan record . . . . . . . . . . . 25
Edit (change) a loan record. . . . . . . . . . . . 25
Delete a loan record. . . . . . . . . . . . . . . 25
Posting payments . . . . . . . . . . . . . . . . . 26
The posting screen . . . . . . . . . . . . . 27
To post a payment: . . . . . . . . . . . . . . . . 28
Posting transactions to user defined fields . . . 30
Posting principal advances . . . . . . . . . . . . 32
Display loan transactions. (on screen) . . . . . . 33
Edit (Change) the parameter file. . . . . . . . . 34
Parameter file fields . . . . . . . . . . . . . . 36
Past due limit . . . . . . . . . . . . . . . 36
Will be due limit . . . . . . . . . . . . . . 36
Visual update flag . . . . . . . . . . . . . 37
Date last file update . . . . . . . . . . . . 37
Payment fraction . . . . . . . . . . . . . . 37
Payment allocation option . . . . . . . . . . 38
The payment allocation options are . . . . . 38
User defined parameter fields . . . . . . . . . . 39
Names of user defined fields . . . . . . . . . . . 40
Year end close out . . . . . . . . . . . . . . . . 41
Report menu functions . . . . . . . . . . . . . . . . . 41
Print trial balance . . . . . . . . . . . . . . . 41
Print past due report . . . . . . . . . . . . . . 42
Print past due notices . . . . . . . . . . . . . . 42
Print will be due notices . . . . . . . . . . . . 42
Custom past due notices . . . . . . . . . . . . . 42
Print loan statement . . . . . . . . . . . . . . . 42
Print a custom report . . . . . . . . . . . . . . 43
End of year interest statements . . . . . . . . . 43
Screen Reports Menu . . . . . . . . . . . . . . . 43
The loan transaction statement . . . . . . . . . 44
The totals report. . . . . . . . . . . . . . . . . 44
Data fields, description . . . . . . . . . . . . . . . 44
Visual update system . . . . . . . . . . . . . . . . . 57
Updating the loan file . . . . . . . . . . . . . . . . 58
Catching up . . . . . . . . . . . . . . . . . . . 59
Posting payments. . . . . . . . . . . . . . . . . 60
Lying to the computer . . . . . . . . . . . . . . 60
Entering Existing Loan Portfolios . . . . . . . . . . . 61
Conversion date. . . . . . . . . . . . . . . . . . 61
Setting the update date . . . . . . . . . . . . . 62
Entering loans into the database . . . . . . . . . . . 63
Sample setup of new loan . . . . . . . . . . . . . 63
Learning to use Loan Master . . . . . . . . . . . 66
Set up a new loan . . . . . . . . . . . . . . . . 66
The posting screen . . . . . . . . . . . . . 79
Sample setup of existing loan . . . . . . . . . . 85
The posting screen . . . . . . . . . . . . . 97
The posting screen . . . . . . . . . . . . . 99
Loan Master Reports . . . . . . . . . . . . . . . . . . 100
Past Due and Will Be Due . . . . . . . . . . . . . 101
Will Be Due Notices . . . . . . . . . . . . 101
Problems with will be due notices . . . . . . . . 104
Past due notices . . . . . . . . . . . . . . 104
Problems with past due notices . . . . . . . . . . 105
Problems with test data . . . . . . . . . . . . . 105
Loan Master Files . . . . . . . . . . . . . . . . . . 105
File specifications . . . . . . . . . . . . . . . . . . 110
Field definitions for LMLOAN.DBF . . . . . . . . . 110
Field definitions for LMPARM.DBF . . . . . . . . . 112
Field definitions for LMTRAN.DBF . . . . . . . . . 113
Bottom Line Software, Inc. License Agreement
By using this product, I agree to comply with the
following license agreement.
This is a legal agreement between you, the end user and
Bottom Line Software, Inc.(BLS). By opening this sealed
package or by using this software, you are agreeing be bound
by the terms of this license agreement..
Grant of license: Bottom Line Software, Inc. grants you,
(the person or entity who purchased this license) a non
exclusive, non transferable license to use this software on
a single terminal, connected to a single CPU. You may not
network the software or otherwise use it on more than one
computer at the same time.
If any provision of this license shall be held to be
unenforceable, such holding shall not affect the
enforceability of any other provision. Your licensed right
to use this software terminates upon your violation of any
of the terms of this agreement.
You may terminate this license agreement without notice
by destroying the software and any printed materials
provided with it.
Proprietary rights: You agree to take all necessary steps to
ensure that the provisions of this license agreement are not
violated by yourself or any other person under your control
or in your service. The software and manual contain
important trade secrets and intellectual property of BLS.
All copyright, patent, trade secret, trademark, and other
intellectual proprietary rights to the licensed software are
and shall remain the valuable property of BLS.
Copyright: This software is owned by BLS and is protected by
United States Copyright laws and international treaty
provisions. You must treat the software as any other
copyrighted material with these exceptions: You may make one
copy of this software for on site backup purposes and one
more copy for off site backup. You may copy the software to
a hard disk. You may not copy the manual or other printed
materials accompanying the software.
LOAN MASTER Loan Processing System 1
Other restrictions: You may not rent, lease, or sell the
Software. You may not reverse engineer, decompile, or
disassemble the Software.
Dual Media Software: If the Software includes both 3 1/2 and
5 1/4 inch disks, you may use only one or the other as
appropriate for your computer. You may not use the other
disks on another computer or rent, loan, lease, or otherwise
transfer them to another user.
Limited Warranty: BLS warrants that the software will
perform substantially in accordance with the accompanying
written materials for a period of 90 days from the date of
receipt as determined by the invoice date. The media is
warranted to be free of defects and readable for the same
period. Implied warranties on the software media are also
limited to the same period.
Customer Remedies: BLS's entire liability and your exclusive
remedy shall be, at BLS's option either (a) the return of
the price paid or (b) the replacement of the software or
media that does not meet the limited warranty and which is
returned to BLS with a copy of your invoice.
No other warranties: BLS disclaims any other warranties,
either expressed or implied including but not limited to
implied warranties of merchantability and fitness for a
particular purpose.
No liability for consequential damages: In no event shall
BLS or its dealers or suppliers be liable for any damages
whatsoever (including, without limitation, damages for loss
of business profits, business interruption, loss of business
information, or other pecuniary loss) arising out of the use
of or inability to use this product, even if BLS has been
advised of the possibility of such damages.
This limited warranty gives you specific legal rights. Since
some states do not allow certain exclusions or limitations
of liability, you may have other rights that vary from state
to state.
LOAN MASTER Loan Processing System 2
IN NO EVENT SHALL BOTTOM LINE SOFTWARE BE LIABLE
FOR LOSS OF BUSINESS PROFITS OR LOSS OF INTEREST
INCOME OR LOSS OF PRINCIPAL PAYMENTS, OR LOSSES
CAUSED BY USE OF SCHEDULES, REPORTS, SCREEN
DISPLAYS OR ANY OTHER OUTPUT FROM THIS SOFTWARE,
OR LOSSES CLAIMED BY DEBTORS OR CREDITORS OF
LICENSED OR UNLICENSED USERS OF THIS SOFTWARE.
Both the software and the manual are furnished under
the terms of this license agreement. Both are copyrighted by
Bottom Line Software and neither may be reproduced or copied
except in accordance with the terms of the license
agreement. Both the Software and the manual are, and remain
the property of Bottom Line Software.
Information in this document is subject to change without
notice.
LOAN MASTER Loan Processing System 3
Installation
Automatic installation
The distribution disks include a completely automatic,
menu driven, installation program. This installation system
consists of several files. To use this system, place the
distribution disk in drive A:
Log on to drive by typing the command:
A:(return)
The colon is required.
When you see the A prompt, type the command:
Menu(return)
and select either hard disk or floppy disk
installation.
NOTE:
The autoinstall program does not alter of create a
CONFIG.SYS file. YOU MUST HAVE ONE! SEE THE NEXT SECTION.
Manual installation
If you need a custom setup, you may configure Loan
Master to your needs. See the section at the end of the
manual on the loan master files. It will list each file and
specify where it must be located.
BEFORE ATTEMPTING A CUSTOM INSTALLATION, READ THE SECTION ON
PATH TO DATA FILES.
LOAN MASTER Loan Processing System 4
Path to data files
The Loan Processing system must know where to find
it's data files. The path to the data files is stored in a
file named LMPARM.DBF. This file MUST be in the same
directory as the program file LMMENU.EXE. You will find a
menu option to update this file and change the data path.
Alternatively, there are two beginning files furnished.
LMPARM.HD and LMPARM.FD. these are the hard disk and floppy
disk version. The hard disk version specifies that the data
files are in the same directory as the program. The floppy
disk version specifies the data files are on disk B: (and
the program file is on disk A:)
If you are using a floppy system copy the file LMPARM.FD
to your program disk and place all the other data and index
files on another disk in drive B: The program disk will go
in drive A:
If neither of the options provided suits your needs,
you will need to install the program using one of the
options provided. Once done, you can update the parameter
file to indicate your path preference to your data files.
Copy your modified lmparm.dbf file to your chosen program
directory. Next time the program is started, it will read
your customized parameter file and look for the data in
their directory you specify.
BE SURE YOU COPY THE DATA AND HELP FILES TO YOUR DATA
DIRECTORY BEFORE STARTING THE PROGRAM. IF YOU FORGET THIS
STEP, THE PROGRAM WILL CRASH WITH AN ERROR MESSAGE.
Automatic data file conversion
As features are added to Loan Master, it will be
necessary to modify the file structure. When these
modifications are done, Loan Master will detect the need to
upgrade your data file and will warn you. If you fail to
upgrade the datafile, the program, Loan Master, will crash.
If you have installed an upgraded version of Loan
Master, the first time it is started, the program will check
your data files for compliance with the latest file
LOAN MASTER Loan Processing System 5
specifications. If it doesn't comply (if it is not the
latest version), you will see a message that informs you of
this fact and that the conversion to the new format needs to
be done.
Upgrades do not always require data file conversion. If
you install an upgraded program and you are not warned to
convert your data files, the conversion is not needed.
The file conversion program is called convert. It is
supplied only with updates since it is not needed by new
users.
ALWAYS BACK UP YOUR DATA FILES BEFORE ALLOWING THE
CONVERSION TO PROCEED. FAILURE TO DO SO COULD RESULT
IN LOSS OF YOUR ENTIRE DATA FILE.
The critical files are LMLOAN.DBF, LMTRAN.DBF, and
LMPARM.DBF.
Running the conversion program
The conversion program expects to find the old files in
its default directory. If you have a hard disk, simply copy
the convert program to the hard disk subdirectory which
contains your Loan Master system.
The name of the conversion program file is:
CONVERT.EXE
If you have a floppy disk system, you must have the
convert program and all data files on the floppy disk in
drive A: This means that if you use the low density 362K
5.25 inch disks, your system will be quite limited in the
size of files it can convert.
Start the conversion program by typing its name.
CONVERT <enter>
The program will display a screen explaining what it is
about to do and warning you to back up your files before
LOAN MASTER Loan Processing System 6
allowing the conversion to start. You will be asked to
respond "C" to continue with the conversion or "Q" to quit
the conversion program before the files are opened. Note
that the program assumes "Q". If you simply press <enter>,
the program will quit.
Converting your parameter file
The parameter file stores user definable options. These
options determine the way the program works. In some cases,
when the upgrade includes new features or new user options,
the parameter file must be replaced with a new file. Old
parameter files are not converted but are replaced with new
files.
If you need a new parameter file, it will be included
on the update disk. The name of the parameter file is
LMPARM.DBF. If you use the auto installation feature on the
upgrade disk, the new parameter file will be installed for
you. If you upgade manually by copying the new program
files, check for the existence of a new parameter file. If
it is on the disk, it must be copied to the same directory
as the program file, LMMENU.EXE.
ALWAYS BACK UP YOUR DATA FILES BEFORE ALLOWING THE
CONVERSION TO PROCEED. FAILURE TO DO SO COULD RESULT IN LOSS
OF YOUR ENTIRE DATA FILE.
The critical files are LMLOAN.DBF, LMTRAN.DBF, and
LMPARM.DBF.
If the program crashes on startup.
LOAN MASTER loan accounting system uses as many as ten
different files, all at the same time.
DOS uses a minimum of 3 files. Unless it is commanded
to allow more, DOS allows only 8 files to be opened. Eight
minus three leaves only five files available for Loan
Master.
The normal default DOS configuration will result in the
system crashing every time you try to run it.
LOAN MASTER Loan Processing System 7
On your boot disk, or in the root directory of your
hard disk C:, you will find a file called CONFIG.SYS.
Display the content of this file on your screen by typing
the following command:
type d:config.sys(return)
d: indicates the disk drive where the file is located,
usually either A: or C:. The colon is required. (return)
means press the return key. Do not type the letters
"(return)".
If the file exists, you will see something like this:
A>type config.sys
files=10
buffers=10
device=ansi.sys
The line beginning with files= is the line in which we
are
interested. The number after the = must be 15 or greater. 20
is good.
You can use your word processing program or any text
editor to change the file if it needs changing. If you use a
word processing program, BE SURE to tell the word processing
program that the file is an ASCII text file when you load it
AND AGAIN when you save it. If this file does not exist on
your boot disk, use the DOS COPY command to copy the sample
file to your boot disk. The sample CONFIG.SYS file is
included in the original distribution package.
The program can also crash if data file conversion is
required but has not been done.
LOAN MASTER Loan Processing System 8
Upgrading Loan Master Versions
From time to time, features will be added or improved.
If you licensed your program direct from Bottom Line
Software, you will receive notices of upgrades in the mail.
If you purchased your program license from a dealer, it is
very important that you register your license with Bottom
Line Software so that you may be informed of upgrades.
User defined options, the parameter file
The parameter file stores information unique to each
individual user. It remembers this information while the
program is not being used and informs the program each time
it is started. For complete details of what this file stores
and how to change it to your needs, see the section on
editing the parameter file in the menu options section of
the manual.
Help function
Loan Master has a built in help function. Help screens
are available to instruct the operator on various functions
and operations. On screen help is not always available.
When it is, it is accessed by pressing the function key
marked F1.
Help screens appear as windows. In some cases, the
amount of text required will not fit in the space available.
In these cases help screens can be scrolled to display more
text by pressing the down arrow or the PgDn keys.
To exit a help screen, press the Esc key. In some
cases you will need to press it twice.
Customizing help screens
LOAN MASTER Loan Processing System 9
On the program options menu, an option allows you to
customize the help screens. This option is normally turned
off. When the option is off, the screens cannot be changed.
When this option is on, however, they may be changed to
display any text or instructions you wish.
On Line Manual
Loan Master provides an on line manual. This manual is
more comprehensive than the popup help screens. It is
organized as a text file. The text appears on the screen and
each text screen occupies the entire computer screen.
The on line manual is accessed by pressing the F2 key.
The first screen displayed by the on line manual is a list
of topics for which help is available. This list is a menu.
The top topic will be highlighted. Select a topic by using
the up and down cursor keys to highlight the topic in which
you are interested. Note that some of the topics in the menu
are submenus of related additional topics. When the desired
topic is highlighted, press the enter key.
The screen will display the text describing the
function you requested. In some cases the description will
be brief and will occupy only part of the screen. In other
cases, more than one screen of text will be required. To
display the next screen, press the page down key. Page up
will display the previous screen. There is always a next
screen of text but it may not be related to your original
inquiry. If you page down beyond your topic, you may page
back up or press the ESC key to return to the menu.
If you have a monochrome monitor, you might not be able
to see the highlighted selection on the menu screens. This
problem can be cured by using the original installation disk
to install the monochrome version of the on line manual.
LOAN MASTER Loan Processing System 10
Menu operations
Loan Master is completely menu operated. You never
have to remember any commands.
A menu is a list of tasks, or functions the program can
perform. Entering a new loan, is a menu function. Printing
a trial balance is a menu function. Since one menu cannot
display all the possible functions the system can perform,
related tasks are listed together on menus.
Using the menus
Menus consist of a list of options, or items,
preceded by an option number. The option number is listed
to the left of the menu item. To keep the screen clean and
readable, menus are limited to no more than eight options
plus the ninth, return option. Option 9 is always return.
The return option takes you back to the point in the
program from which you came to the current menu. This may be
to a previous menu or to some other function.
The return option on the main menu returns you to DOS,
or to your automatic menu system, if you have one installed
on your machine.
Selecting menu options
There are two ways to select a menu option.
If you know exactly what you want to do and how to do
it, simply press the numeric key corresponding the menu
option. To select option 3, press the 3 key. You may select
either the 3 key on the typewriter keyboard, or if the
NumLock key is set to numbers, you may use the 3 key on the
numeric key pad. DO NOT use the function key labeled F3.
If you are a new user and not yet confident in your
knowledge of the menu options and the functions they
perform, you may use the cursor keys, or to select a
menu option.
LOAN MASTER Loan Processing System 11
Cursor key selection is done by highlighting a menu
selection and pressing the return key.
Highlighting means that one selection will be displayed
in a manner that is noticeably different from the rest of
the options. Highlighting usually results in the selected
option being displayed in reversed colors. Some computer
video displays may handle this in a different manner.
When an option is highlighted, selected, a message
will appear at the bottom of the screen. This message will
give additional information about the selected option.
To select an option, press either the or the keys.
If you press the up key, the highlight bar will jump to the
next higher option on the screen (Lower number, higher
physical position). The down key has the opposite effect.
The highlight bar will "roll around" from top to bottom
or from bottom to top. If you press Up when the bar is on
the top selection, it will "roll around" to the bottom
selection and vice versa.
It is always possible to select any option with either
key. It is never necessary to change keys after you have
selected the key to press.
Data entry screens
When the program needs information from the operator,
it displays a data entry screen. Usually data entry screens
occupy the entire screen. Occasionally, as in the case of a
simple yes or no answer, the computer will open a small
window on the screen and ask "Is this the loan you want?
Y/N". in this instance the remainder of the screen will
stay as is was before.
Data entry screens use prompts (messages, questions),
to ask for data. It uses fields to receive data. A field is
a specific, isolated, identified, area in which data is
entered on the screen, stored in memory or on disk.
Usually prompts will appear on the screen followed by
the data field to its immediate right. This is not always
the case. The prompt may be below, above, left, or right of
LOAN MASTER Loan Processing System 12
the data field. It is the responsibility of the programmer
to make it evident to the user which prompt refers to which
field.
When the prompts and fields are printed on the screen,
the fields may or may not already contain data. If the
program is building a new record, the data fields will be
empty. If the operator has asked to edit an old record, the
fields will contain the old data.
If the program is asking a question to verify a command
you have already given, or implied, the response field will
contain a default answer. A default answer is the answer the
computer will use unless you tell it something different. If
you ask to delete loan number 33, the program will find it
and display it on the screen. It will then ask you, "Is this
the loan you want to delete? Y/N". The response field will
contain a "N". "N" then, is the default answer. If you
simply press the <Return> key, you have answered "N". The
purpose for this manner of operation is to require the
operator to think about the answer and to take a positive
step, pressing "Y" before deleting a loan.
Data entry cursor control keys
During data entry, you will move the cursor around the
screen and enter or change data until you have it like you
want it. You will use the cursor control keys to control the
cursor.
The cursor control keys are controlled by the NumLock
and the Shift keys. The NumLock key toggles the numeric key
pad back and forth between the numeric mode and the cursor
control mode.
The Shift key does the same thing but on a temporary
basis. for example: You have the numeric key pad set for
cursor control. You move the cursor to a numeric entry. Next
press and hold down the shift key, this action changes the
numeric keypad to numeric entry. You now enter your number
(still holding down the shift key) and then release the
Shift key. The numeric key pad shifts back to cursor
control.
LOAN MASTER Loan Processing System 13
DATA ENTRY CURSOR CONTROL KEYS
If you are a WordStar fan, you will find the Wordstar
diamond works pretty much as you would expect but none of
the other WordStar commands are implemented.
^ Indicates the Control key labeled Ctrl. Thus ^LeftArrow
means hold down the control key while pressing the LeftArrow
key.
This key: Does this:
Home Move the cursor to the beginning of the
current field.
^Home Move the cursor to the beginning of the first
field on this screen.
End Move the cursor to the last character of the
current field.
^End Move the cursor to the beginning of the last
field on this page.
UpArrow Move the cursor to the previous field.
DownArrow Move the cursor to the next field. Will not
end the current input screen by continuing to
the next screen.
RightArrow Move the cursor one character to the right in
the current field.
^RightArrow Move the cursor to the beginning of the next
word in the current field.
LeftArrow Move the cursor to the left one character in
the current field.
^LeftArrow Move the cursor to the beginning of the
current word. If it is already at the
beginning, move it to the beginning of the
previous word.
LOAN MASTER Loan Processing System 14
^T Delete from the cursor to the end of the
current word.
^Y Delete from the cursor to the end of the
current field.
PgUp PgDn Save the data on the current screen and
continue to the next screen.
Esc Continue to the next screen. Do not save the
changes, if any that were made to the current
screen.
^U Restore the current field to its original
value. This only works before the cursor is
moved out of the field. Once the cursor has
been moved, the only way to restore the
original value is to retype it.
Backspace Delete the character to the left of the
cursor.
Delete Delete the character under the cursor
Insert Toggle between insert and typeover modes.
LOAN MASTER Loan Processing System 15
Date Screen
This screen is the first data entry screen you will see
when the program starts. This screen is first because it is
the most important data the program will ask of you.
NOTE
It is not possible to overemphasize the importance of
this date. This date is especially important when you are
doing the example loans. If this date is set to the current
calendar date when doing the examples, results will not be
correct.
If you make a mistake on one of the loan input screens,
you will affect only that individual loan. If you make a
mistake on this screen, you will affect every loan in the
file.
When this screen is displayed, the computer reads the
date from its internal calendar and tells you what it is:
I think the date is 04/04/89
It then reads the date the file was last updated and
tells you that date.
The last update was 04/01/89
You are asked to verify the date. If your computer's
calendar is set incorrectly or not set at all, this date
will not be correct. You can set the date to any date you
want, after the date of the last update. Normally you will
set this date to the current date (the date of the day you
are doing the work). Occasionally, you will set it to a date
before the current date.
How is this date used?
When the computer starts updating the loans in the
file, It computes interest and checks for past due status
and late charges beginning the day after the date of the
last update, and continuing to the date you set as the
current date.
LOAN MASTER Loan Processing System 16
If you set the current date before or equal to the date
of the last update, nothing will happen. The computer will
read the file and look at all the loans, but since the days
between the date of last update and the current date are 0
or less, it will skip them all.
If you don't want to update the file.
The file is not updated unless you select the update
option from the menu.
Loan look up menu.
The loan look up menu displays a screen that looks like
this:
Loan Processing
Locate individual loan
1) Locate by borrower name.
2) Locate loan by loan number.
3) Locate loan by customer number.
9) Return.
This look up screen is a menu just like the other
menus. See the Menu instructions for details of how it
works.
If you select option 1), locate by name. You will be
asked to enter the borrowers name. The search method used is
very broad. If the name or characters you enter appear
ANYWHERE in the name field, the loan will be displayed.
Upper and lower case are ignored.
LOAN MASTER Loan Processing System 17
Loan look up example:
If you enter the characters "Smith", (With out the
quotes), the search will find all of the following loans:
Smith, Jack
SMITH, JACK
Smithfield, Susan
William T. Smith
James R. Goldsmith
The search begins at the beginning of the file and
continues through the file one loan at a time. As each match
is found, the loan will be displayed on the screen and you
will be asked if this is the loan you want. You may respond
either Y or N. No other response will be accepted.
If you respond "N", the search will continue to display
the next matching record until you respond "Y" or until
there are no more loans to check.
When you respond "Y", this is the loan you want, the
program will continue with the requested operation, using
the loan you just selected. If you told it to delete a loan
it will delete it, if you told it to send it a past due
notice, it will print the notice for this loan, etc.
New Loan Screen
This screen us used only to set up a new loan. It
cannot be used to set up an existing loan. Much of the data
needed to keep the status of a loan is computed and changes
frequently. This data is not entered when the loan is new
but is computed later by the computer. This computed data is
not displayed or entered on this screen.
User defined screen
This screen is used to enter and display data the user
defines. There are three user defined fields which can be
posted, six user defined numeric fields and two user defined
alpha fields.
LOAN MASTER Loan Processing System 18
The user may assign names to these fields by entering
these names in the parameter file. The names entered in the
parameter file will be displayed on the screen as the field
names when this screen is displayed.
See the section on user defined parameter fields in the
section
dealing with the parameter file. (user options)
Loan Maintenance Screen
This screen is used to display the information about a
loan on the screen. At your option, you may change any data
that is not restricted for security reasons.
This screen displays all the information stored for
each individual loan, including the data computed by the
computer during the update process.
To change data on this screen, move the cursor to the
field you need to change by pressing the up or down arrow
key. The down arrow key moves the cursor down the left
column to the bottom and then up to the top of the right
column and continues on down to the bottom of the left
column.
When the cursor is in the field you need to change, you
can enter new data, or change the old data. See the section
on cursor control and editing key functions for more detail.
Browse screens
The browse screen options allow you to browse through
the data files. Each data record is displayed on one line
across the screen. Several records are displayed on each
screen with the fields appearing in columns.
LOAN MASTER Loan Processing System 19
The browse screen looks like this:
Record 1 of 136
Customer Loan
Number Number Customer Name Maker 1
33 1 Smith, Bob Smith, Bob
22 1 Jackson, Wm Jackson, Thomas
22 1 Jackson, Wm Jackson, Thomas
The record contains many more fields than can be
displayed on the screen on a single line. To accomplish the
goal of one loan on one line, the line scrolls across the
screen. As you use the cursor keys to move your view to the
right, the columns on the left side of the screen scroll off
the screen to the left while the formerly invisible columns
to the right of the screen scroll onto the screen from the
left.
You can browse either the loan master file, or the
transaction file.
Try it. It much simpler to do than to describe.
LOAN MASTER Loan Processing System 20
Browse Cursor Control Keys
This key Does this:
Up Move the cursor up one line, (record, loan,
transaction)
Down Move the cursor down one line, (record, loan,
transaction)
Right Move the cursor one column (field) to the right.
If the cursor is in a field and the editing mode
is on, move the cursor one character to the right.
Left Move the cursor one column (field) to the left. If
the cursor is in a field and the editing mode is
on, move the cursor one character to the left.
<Return> Turn on the editing mode (feature) and edit the
data in the currently selected field. If the edit
mode is already on, quit editing the current
field, keep the edited field and continue on the
next field to the right.
^ CtrlRight Scroll the entire data base one column to the
left. (Moves the cursor to the right)
^ CtrlLeft Scroll the entire data base one column to the
right. (Moves the cursor to the left)
PgDn Move down one page (further into the data base).
PgUp Move up one page (back towards the top of the
database).
^PgUp Move to the top, first record in the data base.
^PgDn Move to the bottom, last record of the data base.
End Move to the right most column on the screen.
Home Move to the left most column on the screen.
LOAN MASTER Loan Processing System 21
^End Move to the last field to the right of the current
record and scroll the screen so that field is in
the right most column of the screen.
^Home Move to the first field of the current record and
place the first field of each record in the left
most column on the screen.
Esc Exit the browse function and return to the menu.
LOAN MASTER Loan Processing System 22
Menu functions
Menu structure
LOAN MASTER is completely menu driven. all functions
are accessed from the menus. The menus and submenus present
the following options.
Main Menu. Sub Menus.
1) Loan maintenance menu.
1) Edit, (change) a loan record.
2) Add a new loan record.
3) Add an existing loan record.
4) Delete a loan record.
5) Browse the loan master file.
9) Return to main menu.
2) Transaction maintenance menu.
1) Post a payment transaction.
2) Post a principal advance.
3) Delete a transaction record.
4) Browse the transaction file.
5) Post user defined field 1. *
6) Post user defined field 2. *
7) Post the penalty field.
9) Return to the main menu.
3) Loan file update.
1) Update the master file.
9) Return to the main menu.
4) Printed reports menu.
1) Print the trial balance.
2) Print the past due report.
3) Printed notices menu.
1) Print past due report.
2) Print past due notices.
3) Individual past due notices.
4) Print will be due notices.
5) Print loan statement.
9) Return. (To printed reports menu.)
4) Print a loan statement.
LOAN MASTER Loan Processing System 23
5) Print a custom report.
9) Return to the main menu.
5) Screen reports menu.
1) Display loan statement.
2) Display totals report.
9) Return to main menu.
6) Year end processing menu.
1) Print year end interest statements.
2) Close out FYE accumulators.
9) Return to main menu.
7) Program options menu.
1) Update the parameter file.
2) Customize help messages.
9) Return to main menu.
9 Quit (Return to DOS).
* These two options are user defined and can be defined
by editing the parameter file. See the section on
changing the user defined options.
Setting up an existing loan
To place an existing loan on the computer, you must
first accumulate all the data needed by this screen and then
enter it. It is recommended you use a data entry form to
first assemble and organize the necessary data and then
enter the data from the form.
See the section on data fields for details of exactly
what each field means and how it is used.
Add A loan Record
This function is used to add a new loan to the data
base. It displays the new loan data entry screen and prompts
the operator to enter the data necessary for the program to
begin processing the new loan.
This screen is not used to add an existing loan to the
data base. An existing loan is a loan that has already been
LOAN MASTER Loan Processing System 24
funded and has already earned some interest or possibly had
payments made.
Add an existing loan record
An existing loan is a loan on which interest has
already been accrued and on which interest or principal
payments have already been made. Setting up an existing loan
is considerably more complex than a new loan.
Since the computer does not know the history of the
existing loan, it is necessary for the current status of all
the required fields to be computed manually and entered.
It is not possible to have the computer compute this
information by entering the transactions since it has
already computed the past time period on all the other loans
in the database and cannot repeat these calculations.
Edit (change) a loan record.
This screen displays all the data in the file for each
individual loan. You can use this screen to just view the
data on the screen, or you can change the data to correct
errors.
See the section on data entry screens for instructions
on entering and changing data.
To view a loan on this screen you must identify it
either by name or number. See the section on the loan look
up menu.
Delete a loan record.
This option us used to delete a loan from the file. You
cannot delete a loan until it has been paid off.
Before deleting a loan, make a backup copy of the data
files, "Just in case". Then display the edit screen and use
your screen print key to print a permanent record of all the
data fields for both the master loan screen and the user
defined screen. Next, select the option to print a loan
LOAN MASTER Loan Processing System 25
statement and print out the loan statement listing all
transactions in the file. Store these printed records in
your permanent loan file.
Next, use the loan look up screen to identify the loan
you want to delete. If it is found, you will be asked to
identify it. "Is this the loan you want to delete? Y/N". If
you answer "Y", the program will check to be sure the loan
is paid off. If it is, it will be deleted. You cannot
recover it. It is GONE.
If the loan is not paid off, it will not be deleted.
To delete a loan that is not paid off, it is necessary
to post a final payment for the amount due. If the loan is
not really paid, this entry might be a fictitious payment
for the interest and principal amounts due.
Posting payments
When the posting option is selected, you will first be
asked to identify the loan which is to be posted by customer
and loan number. Enter these two numbers and press the
return key. The loan requested, if found, will be displayed
on the posting screen. That screen looks like this:
LOAN MASTER Loan Processing System 26
The posting screen looks like this:
Post a loan payment
Cust: 76543 Loan: 3 Customer
Date of last update : 02/11/88
Total interest accrued not paid : 130.69
Interest due, not yet paid : 0.00
Principal due, not yet paid : 68.49
Late charges due, not yet paid : 0.00
Total amount due, not yet paid : 68.49
Payment due for (date) : 03/01/88
Scheduled payment amount : 1,217.32
Enter the date of the transaction : 08/13/90
Enter the total amount received : 1,217.32
Allocation of payment amount -
Enter amount of interest payment : 243.12
Enter amount of principal payment : 974.20
Enter amount of late charge paid : 0.00
Is the payment correct? Y/N : N
Esc = abort PgDn = save F1 = help
This screen does not display all information about the
loan. It does however display the information needed to
identify the loan and the information needed to post a
payment.
Before posting payments turn to the section on cursor
control and editing keys for instructions on how to navigate
the posting screen and to enter and change (edit) or reenter
data.
LOAN MASTER Loan Processing System 27
To post a payment:
1) Verify the customer number, loan number and customer
name on the screen to be sure you are posting the
correct loan.
2) Observe the date of the last update. It should be
today's date if the posting date is today. If not
today's date, it should be the same as the posting date
for the transaction. If these dates do not agree, the
interest accrual will not be accurate as of the posting
date.
If your policy is to charge all interest accrued as of
the posting date, it is vital that the two dates agree.
In the event the payment was due only a few days ago
and you intend to charge only the interest due, not yet
paid, the date of update should be equal to or later
than the maturity date of the payment.
3) The top half of the box displays the following
information:
Date of last update
Total interest accrued not paid
Interest due not yet paid
Principal due not yet paid
Late charges due, not yet paid
Total amount due, not yet paid
Scheduled payment due date
Scheduled payment amount
This information is just that, information. This is
data you will need to know to determine how to divide
the payment amount among interest, principal and late
charge.
4) The bottom half of the screen is the information you
must enter to post the payment. The program will
attempt to post the payment for you. It allocates the
scheduled payment amountaccording to your seldction of
several preset options. (See payment allocation option
on the program options screen.)
LOAN MASTER Loan Processing System 28
5) Read step 2) above. Next enter the posting date of the
transaction.
6) If you agree with the program's allocation of interest,
principal and late charge, and the program's
calculation of the total payment amount, you may post
the entire payment by simply pressing the page sown
key. This action tells the program to accept the data
as it is presented on the screen and post the
transaction to the loan.
If you use this method of accepting the payment, skip
the remaining steps, 7, 8, 9, 10.
If you do not agree with the program's allocation in
this particular case, you may change it by posting any
amounts you like to interest, principal and late
charges.
If you never agree with the allocation made by the
program, see the payment allocation option on the
program parameter options screen. You might find
another allocation option more to your liking.
7) Enter the amount of the payment to apply to interest,
if any. It is not required to collect the interest. If
you do not, it will simply carry forward. It will not
be added to the interest paid or paid YTD however.
Unpaid interest is not compounded (Added to the
principal balance).
8) Enter the amount to apply to the principal. If any.
Again as for the interest amount, it is not required
that you make a principal payment. If desired, or if
need be, the entire amount may be applied to interest.
It is possible to overpay the interest. If you do, the
interest accrued field will show a negative number.
9) Enter the amount of late charge collected, if any.
10) Move the highlight to the "N" following the question
"Is the payment correct?". Pressing the "Y" key will
accept the payment, post it, update the loan record,
and exit the screen.
LOAN MASTER Loan Processing System 29
11) You will be returned to the look up screen and asked to
enter a new customer and loan number. You may continue
to post additional loans until all payments are posted.
You are not required to post them in any specific
order.
12) To QUIT posting, enter customer number 0 and loan
number 0 followed by pressing the return key.
Alternatively, you may press the ESC key.
Posting transactions to user defined fields
There are two user defined fields. LOAN MASTER calls
them user2 and user2 but you may name them anything you
like. See the program options menu selection to change the
names of these fields.
LOAN MASTER Loan Processing System 30
When you select the transaction option to post a
transaction to these fields, you will see this screen:
Post transaction to User field 1
Cust: 123 Loan: 123 Smith, Sam
Principal balance : 103,000.00
Date of last update : 02/05/91
<User field 1 > : 0.00
<User field 1 >YTD : 0.00
Transaction date<User field 1 :> 06/04/90
Transaction amount<User field 1 :> 0.00
Transaction code, 41+, 42- : 0
Accept transaction ? : N
The information at the top of the screen is for
information only, it cannot be changed. It is displayed to
give you an idea of the status of the loan.
The four areas enclosed in angle brackets < > will
display the name of the user field assigned in the parameter
file. You can change this name from the program options
menu.
To post the transaction, enter the transaction date.
The current system date will already be displayed. To accept
it, simply press the enter key.
Next enter the transaction amount. The amount may be
positive or negative if you wish, but negative entries
should be handled with the transaction codes. Note that
there is a transaction code for adding the transaction to
the field and another code for subtracting the code from the
LOAN MASTER Loan Processing System 31
field. The computer will not accept an invalid transaction
code.
When the data is entered, it must be verified by
answering "Y" to the verification question. Any other answer
will result in the screen asking for the entire transaction
to be reentered. If this happens, and the transaction is
correct, you may reenter it quickly by simply pressing
<return> or <down arrow> until the "N" is highlighted and
then pressing the "Y" key.
Posting principal advances
Post a loan advance transaction
Cust 123 Loan 123 Smith, Sam
Date of last update : 02/05/91
Date of principal advance : / /
Days since last update :
Principal balance : 103,000.00
Amount principal advance : 0.00
Current interest rate : 12.0000
Daily accrual (on advance) :
Interest error due to dates :
To post a principal advance, first enter check the date
of the last update. It should be the same as the transaction
date. This is important because this transaction will change
the loan balance.
LOAN MASTER Loan Processing System 32
If a principal advance is posted on the 20th, but the
loan has not been updated since the 10th, when the principal
advance is posted, the principal balance will be increased
immediately. Later, when the update from the 10th to the
20th is computed, it will be computed on the increased
balance and the interest accrual will be too large.
When you enter the transaction date, the computer
computes the days from the date of the last update to the
date of the principal advance. If this number of days is not
zero, the computer will compute the error in the interest
accrual and display it for you. It will not prevent you from
posting the advance regardless of the size of the error. It
simply warns you. If the error is large enough to cause
concern, do not post the transaction. Return to the main
menu and update the master file to the date of the advance
transaction. This done, the number of days will be zero and
the error amount will be zero.
IF YOUR ACCRUAL IS CLOSE TO OR EQUAL TO YOUR USURY RATE
LIMIT, POSTING TRANSACTIONS OF THIS TYPE MAY CAUSE YOUR
INTEREST ACCRUAL TO BE USURIOUS.
IF YOUR ACCRUAL RATE IS CLOSE TO OR EQUAL TO YOUR USURY
RATE LIMIT, DO NOT POST A PRINCIPAL ADVANCE IF THE DAYS
SINCE LAST UPDATE IS GREATER THAN ZERO.
Display loan transactions. (on screen)
This function displays all transactions stored in the
transaction file for the requested loan. The display looks
somewhat like an amortization schedule or perhaps a ledger
card.
When you have selected a loan, the program reads the
transaction file and sorts it into order by transaction date
and loan numbers so that it can display only the
transactions for the loan you requested and so that they
will be displayed in date order.
When the screen is full, approximately twelve
transactions, the display will stop and wait for you to view
the screen. To continue to the next transactions, press the
return key.
LOAN MASTER Loan Processing System 33
Pressing the return key does two things. It resets the
pointer in the transaction file back in time by two
transactions and then displays twelve more. This is done to
give some continuity from one screen to the next.
Edit (Change) the parameter file.
Updating the parameter file is done with a data entry
screen, It works just like the other data entry screens. See
the Data entry section for details of data entry.
LOAN MASTER Loan Processing System 34
The parameter file data entry screen looks like this:
LOAN MASTER
Update User Defined Parameters
Company Name: Bottom Line Financial Services Past due notice at day : 6
Address : P.O. Box 1804 Pre due notice at day : 6
Address : Burleson, TX 76028-1804 Pmt allocation option : 4
Address : Visual update on : T
Payment fraction : 0.9400
Date file update : 02/05/91
User field 1 : User field 1 ytd Numeric field 1: Numeric field 1 :
User field 1 YTD : User field 1 : Numeric field 2: Numeric field 2 :
User field 2 : User field 2 : Numeric field 3: Numeric field 3 :
User field 2 YTD : User field 2 ytd : Numeric field 4: Numeric field 4 :
Penalty field : Ret check chg : Numeric field 5: Numeric field 5 :
Penalty field YTD: Reg check chg ytd: Numeric field 6: Numeric field 6 :
Alpha field 1 : Alpha field 1 :
Alpha field 2 : Alpha field 2 :
Name of user defined screen:
<-- Name of User's custom screen here ->
LOAN MASTER Loan Processing System 35
The parameter file is a data file that stores
information about how the user wants the system to work. The
information stored in this file includes:
Parameter file fields
Name of user 30 characters
Line 1 of user address 24 characters
Line 2 of user address 24 characters
Line 3 of user address 24 characters
The name is used as part of the header on the
printed reports. When an address is needed, as on
past due notices, this is the address used.
It is good collection strategy to place your phone
number in the last line of the address.
Past due limit 2 digits
This is number of days past the due date that a
loan will be marked to produce a past due notice.
If this field is set to 10 (days), the loan will
receive a past due notice when it becomes ten days
past due.
Will be due limit 2 digits
This field holds the number of days prior to the
payment date at which the loan should receive a
will be due notice.
If this field is set to 7, a loan with a payment
due on the 20th, will receive a will be due notice
on the 10th.
Do not set this limit very high. If a notice is
received more than about 7 to 10 days early, it
will be forgotten before the due date.
LOAN MASTER Loan Processing System 36
Visual update flag True or False, Yes or No.
Many of the functions which read and update the
files, have visual indicators which can be
displayed on the screen. These indicators give the
status of and track the progress of the update.
These visual updates do slow down the update
process, and may be turned off.
Setting this flag to True, "T" means the visual
screens will be displayed. If the flag is set to
False, "F" they will not be displayed.
Date last file update
This is the date of the most recent file update to
the master file. On this date, all loans were
processed. The interest and late charges were
calculated, due and past due dates were set. The
file is ready to print past due or will be due
notices for this date.
Payment fraction
Occasionally a borrower will pay the wrong amount.
Perhaps the payment is late but the late charge is
not included.
If the borrower pays 99% of the payment amount
due, should the loan be considered past due or
current?
This fraction tells the computer to credit the
loan with a full payment if the payment amount
posted is greater than or equal to this payment
fraction. This does not mean to decrease the
balance by more than was actually received. It
does mean to consider the current monthly payment
requirement to be met and to advance the calendar
to show the next payment due next month.
If this fraction is set to 0.98, and the loan
payment is $100.00, a payment of $98.00 will
LOAN MASTER Loan Processing System 37
advance the maturity indicator to show the note to
be paid current. A payment of $97.99 or less will
leave the loan status unpaid for this month.
Payment allocation option
This option allows the user to specify how a
normal payment is to be allocated to interest and
principal.
Loan Master knows the normal payment amount. It
assume the payment will be a normal payment and
allocates that payment amount to interest,
principal, and late charge according to your
choice of several preset rules.
The payment allocation options are:
Payment
Allocation
Option
0 Assume normal payment amount is
received. If a late charge is due,
collect it. Next collect any interest
ACCRUED through the date of last update.
Apply any remaining amount to principal.
1 Assume the normal payment amount is
paid. Ignore late charges. Take all
interest ACCRUED through the date last
update. Apply any remaining amount to
the principal payment.
2 Assume the normal payment amount is
received. If the payment is early,
compute interest due as of the regular
payment date. If the payment is late,
charge the interest accrued through the
date of last update. Do not give credit
for early payment in the interest
calculation. If a late charge is due,
ignore it.
3 Assume the normal payment amount is
received. If the payment is early,
LOAN MASTER Loan Processing System 38
compute interest due as of the regular
payment date. If the payment is late,
charge the interest accrued through the
date of last update. Do not give credit
for early payment in the interest
calculation. If a late charge is due,
collect it.
4 Assume regular payment amount is
received. Take interest DUE today. If
the payment is late, take the interest
due as of the most recent payment date.
If the payment is early, take interest
due as of the next scheduled payment
date. Collect any late charges due.
Apply the remainder if any to the
principal.
User defined parameter fields
Loan Master provides several user defined fields. The
user may store any needed information in these fields.
Three numeric fields allow actual posting of debits and
credits. These fields store cumulative totals for the life
of the loan and for year to date. This actually requires six
fields, one for the cumulative total and another for the
year to date total for each of the three items. The year to
date totals are cleared, reset to zero, by the year end
processing.
Six numeric fields allow maintaining numeric
information. These fields may be changed only by the
maintenance screen and no calculations are done. The user
must determine the correct contents of the field and enter
that amount from the keyboard. These fields may be used by
the report writer. Report writer can perform calculations on
the contents of these fields and display the results on a
report. The report may be displayed on the screen or sent to
the printer.
LOAN MASTER Loan Processing System 39
Names of user defined fields
LOAN MASTER allows each user a certain amount of
flexibility to customize the program for individual needs.
This customization is accomplished through several user
defined fields.
The user can assign any name (up to 18 characters in
length) to these fields.
The user defined fields are
NAMEUSER1 18 characters
NAMEU1YTD 18 characters
Name of user defined field 1 and its
year to date accumulator
NAMEUSER2 18 characters
NAMEU2YTD 18 characters
Name of user field 2 and its year to
data accumulator.
NAMEPEN1 18 characters
NAMEPEN1YT 18 characters
Name of the penalty field and its year
to date accumulator.
NAMENUM1 18 characters
NAMENUM2 18 characters
NAMENUM3 18 characters
NAMENUM4 18 characters
NAMENUM5 18 characters
NAMENUM6 18 characters
Names of the six user defined numeric
fields.
NAMEALPH1
NAMEALPH2
LOAN MASTER Loan Processing System 40
Names of the two user defined alpha
fields.
NAMEUSRSCR
Name of the data entry screen which
updates the user defined fields.
Year end close out
This function is run each year after the December 31st
update and after the year end interest statements have been
printed.
The purpose of this function is to reset the year to
date totals to zero. Interest paid year to date and late
charges paid year to date are reset to zero.
This function can be run at any time if desired. If it
is NOT run at year end, there is no automated way to recover
the year end status of each loan except to return to the
year end backup file. You did keep a backup didn't you?
Report menu functions
Most printed reports are selected from this menu. Year
end reports like interest paid reports for borrowers are
located on the additional file maintenance menu.
Print trial balance
The trial balance report list all loans. Totals are
accumulated for important dollar amounts like current
balance, interest accrued etc.
This report is used for balancing the loan portfolio
with the general ledger, for quick look ups, when the
computer is off, etc.
LOAN MASTER Loan Processing System 41
Print past due report
The past due report lists all loans that are past due.
This report is used for collections efforts and auditing. It
lists all dollar amounts and dates related to the past due
status of the loan.
Print past due notices
This function is not a single report but a series of
reports (notices) for each past due loan. The notice lists
the borrower, and the status of the loan along with a
message informing the borrower the loan is past due and
requesting payment.
Print will be due notices
Will be due notices, sometimes called payment billings
are notices to the borrower before the due date of each
payment. They remind each borrower a payment will be due
soon. Do not mail these notices so early that the borrower
will have time to forget. The borrower should receive this
notice not more than four or five days before the payment is
due.
In the case of annual or quarterly payments, an earlier
notice would be appropriate, perhaps 30 days early.
Custom past due notices
Individualized past due notices are printed one loan at
a time for loans selected by the operator. Rather than a
canned notice, the operator types the text, or message of
the notice. The program supplies the status information.
Print loan statement
This function prints a statement listing the
transactions for a loan selected by the operator.
LOAN MASTER Loan Processing System 42
The program reads the transaction file, selects the
transactions for the selected loan and sorts them into date
order. They are then printed in a statement format.
This report prints a computed balance. This balance is
computed from the transactions found in the file. THIS
BALANCE WILL NOT BE CORRECT unless the file contains all
transactions, including the original setup. When a loan is
set up on the system, the original amount is placed in the
transaction file as a principal advance, (negative payment
amount). If the loan is not set up properly, the principal
payment transactions will simply start subtracting from
zero.
Print a custom report
This menu selection allows the user to specify a
special report defined by the user. User reports are
created and defined by the user using the report writer. The
format of these special reports is stored in a disk file.
When a custom report is requested, the user is asked
for a filename. The user must then respond with the name of
a file which contains a user defined custom report. The
report specified by the report file will then be printed, or
displayed on the screen.
End of year interest statements
At the end of each year, before performing the year end
closeout. The program will, if requested, print statements
for each borrower listing the amount of interest paid during
the preceding year.
The Statement lists other status information such as
past due status, late charge status, etc.
This is not a single report, but a series of
statements, one for each loan in the file. If a customer
has three loans, he will receive three statements.
Screen Reports Menu
LOAN MASTER Loan Processing System 43
When a permanent paper record is not needed, it is
occasionally convenient to display reports on the screen.
LOAN MASTER provides two on screen reports. Others may be
designed by the user using the report writer.
Two reports are available on screen, the loan
transaction statement, and the totals report.
The loan transaction statement
This function prints a statement listing the
transactions for a loan selected by the operator.
The program reads the transaction file, selects the
transactions for the selected loan and sorts them into date
order. They are then printed in a statement format.
This report prints a computed balance. This balance is
computed from the transactions found in the file. THIS
BALANCE WILL NOT BE CORRECT unless the file contains all
transactions, including the original setup. When a loan is
set up on the system, the original amount is placed in the
transaction file as a principal advance, (negative payment
amount). If the loan is not set up properly, the principal
payment transactions will simply start subtracting from
zero.
The totals report.
This report reads the loan master file and calculates
the totals of all numeric fields and displays the totals on
screen. The Print Screen key can be used to print a snap
shot of these totals.
Some numeric totals would not be meaningful and are
therefore not calculated. The total of the fields storing
the original interest rate would not be a meaningful total,
so it is not calculated.
Data fields, description
LOAN MASTER Loan Processing System 44
The data base file stores the following data for each
loan. The headings consist of the full, descriptive name of
the data field followed by the actual internal field names
in capital letters. If you are a programmer and want to
access the data files directly you will use the shorter,
second name from each header. Note that the " _ " underlines
ARE SIGNIFICANT.
Complete file specifications are printed in the back of
the manual.
Customer number CUST_NO
Required. The customer number is a unique number
assigned to each individual borrower. If a borrower has
more than one loan, this number is used to group the
borrower's loans together.
If you like, this number can be used to group loans of
different borrowers.
Loan number LOAN_NO
Required. The loan number is a number assigned to
uniquely identify each individual loan. This is
different from the customer number. A customer can have
several loan numbers but only one customer number.
Loan numbers should be unique. No two loans should have
the same number. The program will work if they do, but
locating accounts by loan number will be slightly more
difficult.
If you have two loans with the same number and request
a display of one of them, you will see them both, (or
all if more than two) they will be displayed
sequentially in the order they are in the file. You
will have to step through them one at a time until you
find the one you want.
LOAN MASTER Loan Processing System 45
Customer name CUST_NAME
Optional. The program does not care about this field
but you will find the reports hard to read if you leave
it out. The customer name is printed on each report to
make each loan easier to identify.
Maker1,2,3,4 MAKER1 ETC
The makers are the people who signed the note and
promise to pay it. All these fields are optional.
The maker may be or may not be the same as the customer
name. The customer name may be Industrial Cleaning
Service and the maker may be Sue Smith the owner.
Comments (two lines) COMMENT1, COMMENT2
These lines are optional and may contain any data you
wish. They appear only on the screen. They will not
appear on anything the customer will see.
Original amount ORG_AMT
Required. This is the face amount of the note. This is
the amount the computer will use to compute the
scheduled balance. The scheduled ballance is used to
determine if the loan is keeping pace, falling behind,
or gaining on the original agreed payment schedule.
LOAN MASTER Loan Processing System 46
Current Balance CUR_BAL
Required. Computed. This is the amount remaining
unpaid. Each time a principal payment is paid, this
amount is reduced by the principal amount paid. This
amount should always be less than or equal to the
scheduled balance. In real life however, payments are
made late, payments are made early, some months have
more or less than 30 days, etc. It will not be
uncommon to find the current balance slightly above the
scheduled balance.
This balance should not exceed the scheduled balance by
more that about five or six days interest accrual. If
it exceeds the scheduled balance by more than fifteen
days, and especially if the difference is growing from
payment to payment, some collections efforts should be
considered.
Scheduled balance SCH_BAL
Computed. Each time a payment is due, the program
computes the interest due and the "scheduled" balance
assuming the payment was made on the date due. This
calculation is done and the results stored so the
program can compare the real current status of the loan
with what it should be if all payments had been made on
time. The results of this comparison are used to
calculate the amount of interest and principal required
to bring the loan current. If the loan is past due,
both these numbers will be positive. If the loan is
prepaid, the principal figure calculated will be
negative, indicating that more principal has been paid
than was required.
LOAN MASTER Loan Processing System 47
Payments matured PMTS_MTD
How many payments have matured since the loan was
placed on this system. This counter is increased by one
each time a payment matures.
Payments paid PMTS_PAID
How many payments have actually been paid since the
loan was placed on this system. This counter is
increased each time a payment is paid. It is increased
by the actual number of payments made. Fractional
payments are recorded to two decimal places, (+/- 1%).
If the actual payment due is $100.00, and the customer
pays $155.75, this indicator will be increased by 1.55.
This indicator, when compared to the payments matured
counter, gives another indication of the status of the
loan. It does not really indicate the true status
however because if the number of payments made equals
the number of payments matured, and the loan was six
months past due and recently got caught up, the balance
will still be larger than the scheduled balance because
more interest was charged than would have been charged
if all payments were made on time.
Regular payment PMT_AMT_RG
Required. Entered. This is the amount of the regularly
scheduled payment. If there is a balloon payment, see
the next field.
Balloon payment PMT_AMT_FN
Required. Entered. This is the total amount including
interest of the balloon payment. If there is no balloon
payment, this field should contain zero, $0.00.
LOAN MASTER Loan Processing System 48
No. Regular payments NO_PMTS
Required. Entered. This is the number of regular
payments. If all payments are the same amount, this is
simply the total number of payments. If the final
payment is a balloon, the number of regular payments
will be one less than the total number of payments.
No. Balloon payment FINAL_PMT
Required. This is the payment number of the balloon
payment. The program always assumes there is only one
balloon payment. If the loan is payable in 35
installments of $200.00 and one final installment of
6,250.00 the number of the balloon payment is 36.
No payments per year PMT_FREQ
Required. This is self descriptive. If their payments
are monthly, this is 12. if the payments are quarterly,
this is 4. Etc. NOTE, only commonly used schedules are
supported, 52, 13, 12, 6, 4, 2, and 1.
Rate, original RATE_ORG
Required. This is the original interest rate on the
loan. If the rate is fixed, this rate will be used
throughout the life of the loan.
This is the rate that will be charged on the first day
of the loan.
If the loan is a variable rate loan, this field IS NOT
CHANGED. If the rate is variable, change the current
rate field.
LOAN MASTER Loan Processing System 49
Rate, current. RATE_CUR
Required. This is the rate used to do the actual
interest computation during the update. When the loan
is new, this rate will be the same as the rate,
original. If the rate is changed after the loan begins
to accrue interest, this is the rate to change.
Interest basis BASIS
Required. This is the basis by which the interest is
computed. The update always computes interest every
calendar day during the life of the loan, one day at a
time.
Each day the interest formula is computed for every
loan. This is the formula:
(Current balance) x (rate, current)
Daily accrual = ------------------------------------
(Basis)
The basis can be either 360 or 365. Most banks use 360.
This practice increases your interest income by
1.3889%.
WARNING:
IF YOU DO NOT KNOW WHAT YOU ARE DOING, USING THE 360
DAY BASIS CAN CAUSE YOU TO RUN AFOUL OF REGULATION Z
AND OF SOME STATE USURY LAWS.
WE RECOMMEND YOU ALWAYS USE THE 365 DAY BASIS.
LOAN MASTER Loan Processing System 50
Date of note DATE_NOTE
Required. This is the date of the note. The date on
the document. It is usually, but not always, the date
the document was signed. It is the date at which
interest will begin to accrue.
If you need the interest to begin accruing at a later
date, see the field called Date No Interest. To begin
the accrual at an earlier date, you must do it
manually.
Date of first payment DATE_FIRST
Required. This is the date the first payment, payment
number one, is due. This will usually be one month
after the date of the note. All future payment dates
will be calculated from this date.
Date next due DATE_NEXT
Required. Computed. This is the next scheduled
maturity date. This date is updated every time a
payment matures whether or not the payment is made.
This date will always be a future date.
Even when the loan is past due and the payments are not
being made, this date continues to increment to reflect
the fact that a payment is coming due even though we
know it will most likely not be made.
Date (of) payment due DATE_DUE
Required. Computed. This is the most recent date for
which a payment was due but not yet made.
This is the date that keeps up with the past due pr
prepaid status of the loan. If this date is in the
future, the loan is current or prepaid. If this date
is in the past, the loan is past due.
LOAN MASTER Loan Processing System 51
Today is June 20. A payment was due on April 15, May
15, and June 15. The April payment was made on time.
The May and June payments have not yet been made. The
date due (date of payment due) is May 15. We say "The
loan is due for may 15th." It is 36 days past due. (May
15th to June 20.) The date next due however is July 15.
Another payment is due on that date whether or not the
prior payments have been made.
Today is September 5. A payment was due June, July,
August, and September first. They were all made on
time. The loan is "due for Oct. 1". The date payment
due is 10-01-xx. the date next due is also 10-01-xx.
Date last payment maturity DATE_LAST
Required. Computed. This is the most recent date on
which a payment matured. It may or may not be the date
on which the last payment was paid. This date is used
to keep up with late charges due on past due loans.
Date last transaction DATE_TRAN
Required. Computed. This is the date of the last
transaction, any transaction. If the last transaction
was a payment, this date will be the same as the date
last payment. If the last transaction was for example a
late charge assessment, the dates will not be the same.
Date last update DATE_UPD
Required. Computed. This is the date of the last
update. It is the date the operator entered as the date
of the last update. It may or may not be the same as
the actual calendar date the update was done.
It is however the latest date through interest has been
calculated and for which past due status has been
checked.
LOAN MASTER Loan Processing System 52
It is most important to update the file before posting
payments or printing past due notices or past due
reports.
Date maturity DATE_MTY
Required. This is the maturity date of the loan. On
this date, the final payment of all remaining interest
and principal is due. If the loan is a balloon note,
this date is the same as the balloon payment date.
Date no interest DATE_NOINT
Optional. In retail financing, it is common to offer a
purchaser an initial interest free period. eg. "90
days, no interest!"
Interest will not accrue until this date. If the date
of the note is January 1, 1989 with monthly payments on
the first of each month, and the no interest date is
February 15, 1989, the loan will accrue no interest
until February 15th, on that date, it will accrue the
first days interest.
If the interest computation basis is 12, the loan will
not accrue interest until the next payment date after
the no interest date. The loan mentioned would accrue
one month interest on March 1, 1989.
If you use interest basis 12, all interest free periods
should expire one month before a payment date.
Interest accrued INT_ACCRD
Required. computed. This is the amount of interest
which has accrued on the loan and which has not yet
been paid. This amount may or may not be due.
Every update computes the interest due since the date
of the last update and adds it to this amount. This
happens every day. When an interest payment is posted,
LOAN MASTER Loan Processing System 53
this amount is reduced by the amount of the interest
payment.
Interest due, unpaid INT_DUE
Required. Computed. This is the amount of interest
due and unpaid. Every payment date, the entire amount
of interest in the accrued interest field is moved into
this field. Note that it is moved, not added.
The program assumes that at each payment date, all
interest is due.
Each time an interest payment is posted, the payment
amount is subtracted from this field.
Interest paid (life) INT_PAID
Required. Computed. This is the total of all interest
payments on this loan since it started. This amount is
kept for reference only.
Interest paid (YTD) INT_YTD
Required. Computed. This is the total interest paid on
this loan since the end of last year. Note that this is
PAID, not ACCRUED. This amount is reset to zero at year
end.
Principal due PRIN_DUE
Required. Computed. This is the amount of principal
required to bring the current balance in line with the
originally scheduled repayment plan. This is more or
less meaningless if it is negative. A negative number
indicates the loan is prepaid.
If this amount is positive, a payment has matured and
not yet been paid. A positive amount will also occur if
interest is calculated on the actual day basis using a
360 divisor. This system accrues 1.39% more interest
than the monthly interest method. This extra interest
LOAN MASTER Loan Processing System 54
will cause each principal payment to be slightly less
then the scheduled principal payment.
Late Charges due, unpaid LC_DUE
Required. Computed When a loan is new, this field is
zero. Each time a late charge is assessed, it is added
to this field. When late charge payments are posted,
they are subtracted from this field.
Late charge paid LC_PAID
Required. Computed. This is the total of all late
charges paid since the loan was new. Each time a new
late charge payment is posted, the amount is added to
the field.
Late charge paid YTD LC_YTD
Required. Computed. This field maintains the total of
all late charges actually paid since the end of the
privious year.
Late charge rate LC_RATE
Required. Entered. The late charge rate is used to
assess late charges when due. The late charge routine
allows the late charge rate to be used to specify
either a dollar amount for the late charge, or a
percentage of the payment amount.
If the late charge rate is less than 1.00, it is
interpreted as a percentage and computes the late
charge as that percent of the regular payment amount.
If the late charge rate is equal to or greater than
1.00, it is interpreted as a dollar amount and assesses
that exact amount for the late charge.
LOAN MASTER Loan Processing System 55
Late charge examples:
Payment amount = 100.00
Late charge rate Late charge amount
0.05 5.00
7.50 7.50
Penalty paid PENALTY
Penalty paid YTD PENALTYYTD
These fields are not used by LOAN MASTER. They are
reserved for the each user's needs. The penalty field
may be used for returned check charges, prepayment
penalties, or any other amount for which the user needs
to account.
The user may edit the parameter file to change the name
of the penalty field and the penalty YTD fields.
User field 1 USER1
User field 1 YTD USER1YTD
These fields are reserved for each user. They may be
posted through the transaction maintenance menu. The
program maintains a running total for user field 1
throughout the life of the loan. The user field 1 YTD
field is closed out each year through the year end
closeout procedure. (Reset to zero.)
Two transaction codes are provided, one to add to this
field, the other to subtract from this field.
The parameter file can be edited to assign a meaningful
name to this field.
User field 2 USER2
User field 2 YTD USER2YTD
LOAN MASTER Loan Processing System 56
These fields are reserved for each user. They may be
posted through the transaction maintenance menu. The
program maintains a running total for user field 2
throughout the life of the loan. The user field 2 YTD
field is closed out each year through the year end
closeout procedure. (Reset to zero.)
Two transaction codes are provided, one to add to this
field, the other to subtract from this field.
The parameter file can be edited to assign a meaningful
name to this field.
User numeric field 1 - 6 NUMERIC1, NUMERIC2, Etc
These fields are not used by LOAN MASTER. They are
reserved for each individual user. They cannot be
posted and there are no year to date accumulators. Each
field must be changed to the desired number through the
edit screen. These changes are not recorded in the
transaction file.
These fields can be used for any purpose. They can be
named by editing the parameter file. They will be
totalled by the total report and can be included in
custom reports designed by the user.
Visual update system
In many cases, computers are somewhat confusing and
frustrating. Computers usually do things in the dark. We
can't see what is going on and we can't understand the
results.
Loan Master has a visual update system that, if turned
on, displays information about the update procedures
continuously on the screen. These screens range from a very
simple record counter telling which record is being updated
to the very complex data file update screen that displays
the contents of each field before and after the update, and
optionally stops for you to inspect the record after each
day's computations.
LOAN MASTER Loan Processing System 57
To use this system you must turn it on. Turning on the
simple screens is done through updating the parameter file.
Set the visual update field to "T", (true).
The data file update is turned on or off when the
update is started. This function slows the update function
considerably. For this reason, it can be turned off even
when the other visual functions are on.
This allows you to have visual status updates during
printing the reports but not during the data file update.
To get acquainted with the system, turn it on when you
start the update procedure, request the pause after each
loan function. When the update starts, the loan status will
be displayed on the screen in the before columns. The
interest and status information is updated and then the new
status is displayed in the after columns. The screen will
display the "Press any key to continue..." message at the
bottom of the screen. You can now inspect the loan status
before and after the update calculations. When you are
ready, press the return key and the next loan will be
processed.
For normal operations, you will probably want to turn
this option "on" in the parameter file and turn it "off" for
the update. If you like, you can turn the update display
"on" and the "pause" off. This will result in displaying the
loan status on the screen as each loan is updated but the
screen will not pause for inspection before updating the
next loan.
For a practice session with the visual update system,
see the examples for setting up new and existing loans.
Updating the loan file
A loan earns interest every day, one day at a time. It
earns interest whether you turn on the computer or not. If
you must keep up with very many loans, a payment may come
due on any day of the month. Something happens every day.
Loan Master loan accounting software expects to keep up
with an unlimited number of loans. It must compute interest
on every loan every day and it must check every loan every
LOAN MASTER Loan Processing System 58
day to see if a payment is due or if it has reached final
maturity. This is exactly how the loan file is updated.
Every loan is updated every day, one day at a time.
We know that you are not going to come to the office
and run the computer EVERY DAY to update your loan file.
Thus, the computer must be able to keep up with the days you
miss and "catch up".
In the parameter file, the program stores the date of
last file update. When the program starts, the first thing
it does is read the system clock and the parameter file and
display the date. "I think today is 03-31-89", and the date
of last update. The program MUST know today's date. If your
system clock is not correct, you must enter the correct date
when this screen is displayed.
As soon as the program knows the correct date, it
compares it to the date of last file update. It then knows
how many days you have skipped. If today's date is 03-20-89
and the data of last file update is 03-17-89, you have
skipped the 18th and the 19th, two days. It needs to update
for three days however to update through the 20th.
In this case, if you order a file update, the program
will read the entire file, one loan at a time, and add one
days interest and check maturities for the 18th. As soon as
this process is finished, it will immediately be repeated
for the 19th, and then again for the 20th. When the process
is finished, the entire file will be updated current for
03-20-89.
Catching up
Occasionally a loan for some reason will not be
updated to the same date as the rest of the file. One
possible example is an existing loan that is added to the
file. The date of last file update was March 20. The new
loan was closed on March 5th but we received it from the
salesman on march 21. When we enter this loan, it will never
have been updated. Another way of saying this is that the
date of last update is the same as the date of the loan, or
March 1.
LOAN MASTER Loan Processing System 59
This loan will be entered into the data file. It's date
last update will be set to March first. When the file is
updated, the program will detect that this loan is "behind".
When this condition is detected, this loan will be updated
repeatedly until it is "up to date", then the program will
continue with the next loan in the file.
If we enter this loan on March 21, and then run the
March 21 update, the program will update the old loans only
one day (March 20 to March 21). When it comes to the new
loan, it will notice that it is "behind" and will update it
one day at a time until its date last update is the same as
the other loans in the file. This one day at a time method
is necessary so the program can check for payment dates and
late charges due.
Posting payments.
Today is the 21st. The last update was the 17th and you
received a payment on the 18th. If you post the payment
before the update. Credit will be given as of the 17th. You
will lose interest for the 18th, 19th, and 20th on the
amount of the principal reduction. If the payment amount is
$100.00 and $80.00 is interest, you will lose three days
interest on 20.00. About two cents.
On the other hand, if you post the payment after the
update, the customer will loose credit for the 19th and the
20th, about one and one third cents.
Lying to the computer
If you process a large number of loans, or if the
amounts are large enough to make the above numbers
significant, you can get it exactly right by lying to the
computer. This is how you do it.
When you order a master file update, you are told the
date of last master file update and asked for the date of
this update. In the above example, today is really the 20th
but you can tell the program to update for the 18th and it
will update only one day. You can then post the payments
received on the 18th and then update again, telling the
program to update for the 19th. etc.
LOAN MASTER Loan Processing System 60
Entering Existing Loan Portfolios
DO NOT ATTEMPT TO ENTER AND UPDATE LIVE DATA UNTIL
YOU HAVE ENTERED AND UPDATED THE EXAMPLES. (SAMPLE
SETUP OF NEW LOAN.)
To enter a portfolio of already existing loans
successfully, you must understand how the update process
works, and why it works that way. If you have not already
done so, read the section titled "Updating the loan file"
Now that you understand how the update works, you are
ready to understand the process of entering a portfolio of
existing loans.
The first step is to reproduce a supply of the new loan
setup sheets and the existing loan setup sheets. You will
need one of each for every loan you want to add to the
system.
You should have an amortization schedule for each loan.
If you don't, you must have or compute the information
necessary to complete the setup sheets. You must know the
balance due and the interest due. It is nice, but not
required, to know the late charges due, if any. If you do
not know the late charges, the system will keep up with them
in the future but it cannot go backwards.
Other numbers. Interest paid year to date is nice to
know. If you have it, you can print a year end tax
statement for each borrower. If you don't have it and can't
or don't want to get it, the system will keep up with it in
the future. It just will not be complete the current year.
Conversion date.
You must pick a conversion date. It can be any date
that is convenient for you. January first is exceptionally
nice but usually not practical. If you can use January
first, you can forget about all the year to date numbers
and let the computer compute them for you during the new
year.
LOAN MASTER Loan Processing System 61
When choosing a conversion date, be sure to allow
yourself enough time to complete the preparations needed.
This is what you must do to prepare. Complete the new loan
setup sheet and the existing loan sheet for each existing
loan. Mostly this is a job of copying data from the note to
the setup sheet. Some of the information must be calculated.
You MUST calculate the balance due and the interest due on
the conversion date for each and every loan.
When all the setup sheets are complete, at least a day
or two before the conversion date, Enter all the data. The
process is as follows.
Select the menu option to add a new loan or to add an
existing loan as appropriate to each individual loan. The
data input screen will closely match the data input form.
Enter the data from the data entry form on to the data entry
screen. When the screen if completed, the data is saved in
the master file.
Repeat this process until all loans are entered.
When all data is entered, select the printed reports
menu and print a trial balance. Check this report to see if
the totals add up to what you expected. If not you can use
the trial balance to look for errors.
Setting the update date in the parameter file
When the data has been entered, you have a computer
file that contains the data for every loan as of the
conversion date. In other words, the conversion date is the
date of last update. Select the file maintenance menu.
From that menu select the option to update the parameter
file. Use the down arrow key to step down to the item
labeled "Date of last master file update". Change that date
to the conversion date. Your installation is now complete
and you are ready to update.
BEFORE YOU RUN THE UPDATE PROCEDURE,
MAKE A BACKUP COPY OF YOUR MASTER
FILE AND YOUR TRANSACTION FILE!
LOAN MASTER Loan Processing System 62
They are called LMLOAN.DBF and LMTRAN.DBF.
Entering loans into the database
When entering loans into the data base, there are two
possible types of loans that must be considered. New loans
and existing loans.
A new loan is a loan on which no payments have matured.
It may or may not have been funded but the first payment is
not yet due.
An existing loan is any loan that is not a new loan. It
has been funded and one or more payments have matured. The
matured payments may or may not have actually been paid, but
they have matured.
Sample setup of new loan
This example MUST be done using a NEW, BLANK loan
database file. If you have entered loan data on any loans in
to the data base, save it in a safe place, perhaps on
another disk or an other subdirectory, then use the original
LOAN MASTER distribution disk to reinstall LOAN MASTER. This
will insure hou have an empty data file.
Setting up a new loan is a relatively simple process.
For this example, we will use the loan described below. This
same loan will be used later in the existing loan setup
example.
LOAN MASTER Loan Processing System 63
The loan:
Loan date 01-01-88
Date first payment 02-01-88
Face amount 36,0000.00
Interest rate 13.25%
Payment amount 1,217.32
Number payments 36
LOAN MASTER Loan Processing System 64
Use a new loan setup sheet and fill it out like this:
New Loan Setup Sheet
Date setup: 01_/01_/88_ Entered by: _____________
NEW LOAN SCREEN
Customer No. _76543__________________ Original Amt. _36000.00_____
Loan No. _3______________________ Late Charge Rate _0.05_________
Customer name. _Sam Smith______________ Late charge at day _10___________
Comments _Home Improvement_______ Payment Amt Reg _1217.32______
_swimming pool__________ Payment Amt Lst _1217.32______
Makers/Guarantors ... Number payments _36___________
_Smith, Sam_____________ Final payment no _36___________
_Smith, Robin___________ Payments per yr _12___________
________________________
________________________
Date Note 01/01/88
Date First Pmt 02/01/88
Date maturity 01/01/91
No int. until / /
Int Rate Orig __13.25____
Int Comp Basis __365______
LOAN MASTER Loan Processing System 65
A blank set up sheet will be found in
the back of the manual.
Learning to use Loan Master
The first step in learning to use Loan Master is to set
up a loan. This must be done before you set up your own
data. If you have already set up live data, back up your
data files to an other disk or to an other subdirectory on
your hard disk. Once your data is safe, reinstall the Loan
Master system from the original installation disks. This
will replace your data files with new, empty data files.
With these new, empty data files, we can control exactly
what you see on the screen and explain the various steps in
maintaining the loan records.
Set up a new loan
1) Select Loan maintenance from the main menu.
2) Select the function to add a new loan record from the
loan maintenance menu.
3) Enter the new loan data exactly as shown in the new
loan setup example above.
LOAN MASTER Loan Processing System 66
After the data is entered, the new loan screen will
look like this:
NEW LOAN SCREEN
Customer No. _76543__________________ Original Amt. _36000.00_____
Loan No. _3______________________ Late Charge Rate _0.05_________
Customer name. _Sam Smith______________ Late cahrge at day _10___________
Comments _Home Improvement_______ Payment Amt Reg _1217.32______
_swimming pool__________ Payment Amt Lst _1217.32______
Makers/Guarantors ... Number payments _36___________
_Smith, Sam_____________ Final payment no _36___________
_Smith, Robin___________ Payments per yr _12___________
________________________
________________________
Date Note 01/01/88
Date First Pmt 02/01/88
Date maturity 01/01/91
No int. until / /
Int Rate Orig __13.25____
Int Comp Basis __365______
4) After the data entry is complete, return to the main
menu.
5) Select the main menu option to set program options.
This option is used to update the parameter file.
6) From the options menu, select the option to update the
parameter file.
LOAN MASTER Loan Processing System 67
The parameter file update screen looks like this:
LOAN MASTER
Update User Defined Parameters
Company Name: Bottom Line Financial Services Past due notice at day : 6
Address : P.O. Box 1804 Pre due notice at day : 6
Address : Burleson, TX 76028-1804 Pmt allocation option : 4
Address : Visual update on : T
Payment fraction : 0.9400
Date file update : 01/01/88
-----------------------------------------------------------------------------
User field 1 : User field 1 ytd Numeric field 1: Numeric field 1 :
User field 1 YTD : User field 1 : Numeric field 2: Numeric field 2 :
User field 2 : User field 2 : Numeric field 3: Numeric field 3 :
User field 2 YTD : User field 2 ytd : Numeric field 4: Numeric field 4 :
Penalty field : Ret check chg : Numeric field 5: Numeric field 5 :
Penalty field YTD: Reg check chg ytd: Numeric field 6: Numeric field 6 :
Alpha field 1 : Alpha field 1 :
Alpha field 2 : Alpha field 2 :
-----------------------------------------------------------------------------
Name of user defined screen:
<-- Name of User's custom screen here ->
LOAN MASTER Loan Processing System 68
If you have not already done so, change the
company name and address to the name and address of
your company.
Set the following fields to the indicated values:
Visual update on T
Past due notice at day 6
Pre due notice at day 6
Payment fraction .94
Date file update 01-01-88
Some versions of the program allow a setting for late
charge. This field is no longer used by the system.
Late charge dates are set in each individual loan
record. Use the Loan Record Maintenance function to
make this change.
8) Exit this screen by pressing PgDn then return back to
the Main Menu.
From the Main Menu, select the Update function. From
the Update Menu, select the update all loans function.
9) You will see a screen that asks you to verify the date
of this update. That field will contain the actual date
from the computer's system clock or the date you set.
If the date is set, it will probably be today's date.
If it is not set, it will probably be 01-01-1980.
This is the date for which we will be updating the
file. This means that each loan in the file will be
updated THROUGH this date. Updating means that the
interest will be calculated for each day between the
last date each loan was updated and the date of update.
Each loan will also be checked for payments due and for
late charges. If payments mature or if late charges
accrue, they will be added to the fields which
accumulate the amounts due but unpaid.
If the date of update is earlier than or the same as
the date of last update of any individual loan in the
file, that loan will be skipped. It will not be
updated. Similarly, if the date of update is earlier,
or equal to the date of last update for the entire loan
LOAN MASTER Loan Processing System 69
file, the entire file will be skipped and the menu will
reappear immediately.
Change the date of update to 01-01-88. This date is the
date of the origination of our test loan. It is also
the date of the last update we specified in the
parameter file in the previous step.
Set the Pause after every day's update to "T".
Set the Turn on Visual Display to "T".
Press return to update.
The menu reappears immediately. Nothing happened. Why?
The reason nothing happened is that the program looked
at the date of the last file update in the parameter
file, (01-01-88) and compared it to the date of update,
(01-01-88). They are the same so no update is needed
and the program simply skips the update process and
returns to the menu.
10) Now select the update all option and set the date of
update to 01/02/88. Press return to start the update.
You will see the visual update screen. It looks like
this:
LOAN MASTER Loan Processing System 70
Updating cust no : 76543 loan no : 3 record no : 1
Updating for ... 01/02/88
Field Before After Field Before After
Name Update Update Name Update Update
Current bal 36,000.00 36,000.00 Date first pmt 02/01/88 02/01/88
Schuled bal 36,000.00 36,000.00 Date next pmt 02/01/88 02/01/88
Int accrued 0.00 13.07 Date last mty 01/01/88 01/01/88
Int due 0.00 0.00 Date pmt missed 02/01/88 02/01/88
Prin due 0.00 0.00 Date last tran 01/01/88 01/01/88
Late cg due 0.00 0.00 Date last upd 01/01/88 01/02/88
Late cg pd 0.00 0.00 Days past due -30
Late cg ytd 0.00 0.00 Days Lt Chg 1
Interest pd 0.00 0.00
Interest ytd 0.00 0.00
Current rate 13.25000 13.25000
This screen shows the status of each relevant field
before and after the update. Updates are always for one
day only.
Notice these changes:
Item Changed to
From
Interest accrued 0.00 13.07
Date last update 01/01/88 01/02/88
Days past due -31 -30
These changes reflect the change in status from 01-01-
88 to 01-02-88.
The loan has accrued one day's interest, $13.07. Note
that this is one day at 13.25% on $36,000 with a 365
LOAN MASTER Loan Processing System 71
day divisor. The actual amount is 13.0685 but all
displays are rounded to exact cents.
The loan has been updated through 01-02-88. Interest
has been calculated and maturity dates have been
checked. No payments have come due since the last
update and no late charges have been assessed.
The past due status has changed from -31 days past due
to -30 days past due. This means that yesterday the
next unpaid payment is 31 days in the future. Today
that same date is only 30 days in the future. On the
date the payment is due, the days past due will be
zero.
11) Press enter to return to the menu then select the
update all option again. This time set the date of this
update to 01-31-88. Note that this is the day before
the first payment is due. Note also that Loan Master
does not need to be run every day to maintain accurate
status information on each loan. It can update several
days in a single operation.
Press enter to start the update. You will see the
visual update screen again. This time it will look like
this:
LOAN MASTER Loan Processing System 72
Updating cust no : 76543 loan no : 3 record no : 1
Updating for ... 01/03/88
Field Before After Field Before After
Name Update Update Name Update Update
Current bal 36,000.00 36,000.00 Date first pmt 02/01/88 02/01/88
Schuled bal 36,000.00 36,000.00 Date next pmt 02/01/88 02/01/88
Int accrued 13.07 26.14 Date last mty 01/01/88 01/01/88
Int due 0.00 0.00 Date pmt missed 02/01/88 02/01/88
Prin due 0.00 0.00 Date last tran 01/01/88 01/01/88
Late cg due 0.00 0.00 Date last upd 01/02/88 01/03/88
Late cg pd 0.00 0.00 Days past due -29
Late cg ytd 0.00 0.00 Days Lt Chg 2
Interest pd 0.00 0.00
Interest ytd 0.00 0.00
Current rate 13.25000 13.25000
Notice these changes:
Item Changed to
From
Interest accrued 13.07 26.14
Date last update 01/02/88 01/03/88
Days past due -30 -29
These changes reflect the change in status from 01-02-
88 to 01-03-88.
Now press the enter key and check the changes again.
Press the enter key again and again, watching the
changes each time. WATCH THE DATE LAST UPDATE CLOSELY.
When it reaches 01-31-88, you have reached the end of
your update period. The payment is due tomorrow and the
next keypress will return you to the menu.
LOAN MASTER Loan Processing System 73
12) Select the update option again. The date last update
was 01-31-88, the payment is due on 02-01-88. When
asked, set the date of update to 02-01-88.
When the enter key is pressed, the machine will update
for 02-01-88 and the update screen will appear. It will
look like this:
Updating cust no : 76543 loan no : 3 record no : 1
Updating for ... 02/01/88
Field Before After Field Before After
Name Update Update Name Update Update
Current bal 36,000.00 36,000.00 Date first pmt 02/01/88 02/01/88
Schuled bal 36,000.00 35,180.18 Date next pmt 02/01/88 03/01/88
Int accrued 392.06 405.12 Date last mty 01/01/88 02/01/88
Int due 0.00 405.12 Date pmt missed 02/01/88 02/01/88
Prin due 0.00 819.82 Date last tran 01/01/88 01/01/88
Late cg due 0.00 0.00 Date last upd 01/31/88 02/01/88
Late cg pd 0.00 0.00 Days past due 0
Late cg ytd 0.00 0.00 Days Lt Chg 0
Interest pd 0.00 0.00
Interest ytd 0.00 0.00
Current rate 13.25000 13.25000
LOAN MASTER Loan Processing System 74
This time, a payment has matured. There are several
interesting changes. Note these:
Item Changed to
From
Interest accrued 392.06 405.12
Date last update 01/31/88 02/01/88
Days past due -1 0
Int Due 0.00 405.12
Prin due 0.00 819.82
Date Next pmt 02-01-88 03-01-88
Date last mty 01-01-88 02-01-88
Date payment missed 02-01-88 02-01-88
(Not changed)
These changes reflect the change in status from 01-31-
88 to 02-01-88.
Interest accrued
The interest accrued through the date of the first
payment is 405.12. This is computed as 31 days at
13.25% on the balance of $36,000.00, using a 365
divisor. You may also specify a 360 divisor or a
monthly interest calculation. Using a 360 divisor, the
interest would have been $410.75. Using the monthly
interest option, the interest would have been $397.50.
The monthly option calculates $36,000 * .1325 / 12.
Interest due
The interest due, is the amount of interest accrued
through the payment date.
Principal due
The principal due is the total payment amount less the
interest due as calculated above.
LOAN MASTER Loan Processing System 75
Date next payment
The date of the next payment is the next date on which
a payment will mature. This date will change on every
payment date regardless of whether the payment is made
or not.
Date last mty
The date of last, (prior) maturity is the most recent,
past date on which a payment matured. For new loans
this date begins with the date of the note. It is
changed to the payment date each time a payment
matures.
Date pmt missed
Date of payment missed. This is the oldest date for
which the full payment has not been made. This date is
updated only when payments are posted. If the March
payment is missed, then the April payment and May
payments are missed, this date will still indicate
March. When a payment is posted, this date will be
increased ONE MONTH. Partial payments are accepted and
may be posted but status updates are one month at a
time. If two payments are posted the same day, they
must be posted as two separate payments.
This update is affected by the payment fraction in the
parameter file. The payment fraction allows a partial
payment to be accepted as a full payment. For example:
The company late charge policy is to charge 5% of the
payment amount. If the payment amount received does not
cover the late charge, it is collected anyway. The
interest and late charge are deducted from the payment
amount and the balance is applied to the principal. To
determine past due status the interest and principal
are added together and compared to the scheduled
payment amount. The actual interest and principal paid
is 95% of the scheduled payment amount.
LOAN MASTER Loan Processing System 76
The payment fraction is inspected and found to be 0.94.
This is 94%. If the total interest and principal
received is greater than 94% of the scheduled amount,
the past due status is upgraded one month. In this case
it is 95%, so the date payment missed is changed from
March to April.
Other changes made necessary by small irregular
payments must be made on the loan maintenance screen.
13) Press enter to return to the menu. Select the update
option again and set the date of update to 02-10-88
When the first update screen appears for 02-02-88, note
that the accrued interest continues to increase but the
interest due does not. Note also that the days past due
has changed from zero (due today) to 1 (due yesterday).
LOAN MASTER Loan Processing System 77
Again press enter repeatedly until the date last update
is 02-10-88. the update screen will look like this:
Updating cust no : 76543 loan no : 3 record no : 1
Updating for ... 02/10/88
Field Before After Field Before After
Name Update Update Name Update Update
Current bal 36,000.00 36,000.00 Date first pmt 02/01/88 02/01/88
Schuled bal 35,180.18 35,180.18 Date next pmt 03/01/88 03/01/88
Int accrued 509.67 522.74 Date last mty 02/01/88 02/01/88
Int due 405.12 405.12 Date pmt missed 02/01/88 02/01/88
Prin due 819.82 819.82 Date last tran 01/01/88 01/01/88
Late cg due 0.00 0.00 Date last upd 02/09/88 02/10/88
Late cg pd 0.00 0.00 Days past due 9
Late cg ytd 0.00 0.00 Days Lt Chg 9
Interest pd 0.00 0.00
Interest ytd 0.00 0.00
Current rate 13.25000 13.25000
Note:
The days past due = 9.
The days lt chg (late charge counter) = 9.
A late charge will be due tomorrow.
14) Return to the menu and update again. This update will
be for 02/11/88.
The days past due counter and the late charge counter
will indicate 10 days and the late charge due field
LOAN MASTER Loan Processing System 78
will indicate a late charge of $60.87 is accrued and
unpaid.
15) Return to the main menu and select the transaction
maintenance menu selection.
16) Select Post a payment menu selection.
17) Enter Customer number 76543 and loan number 3.
The posting screen will be displayed:
The posting screen looks like this:
Post a loan payment
Cust: 76543 Loan: 3 Customer no:
Date of last update : 02/11/88
Total interest accrued not paid : 535.81
Interest due, not yet paid : 405.12
Principal due, not yet paid : 819.82
Late charges due, not yet paid : 60.87
Total amount due, not yet paid : 1,285.81
Payment due for (date) : 02/01/88
Scheduled payment amount : 1,217.32
-------------------------------------------------------
Enter the date of the transaction : 02/11/88
Enter the total amount received : 1,217.32
Allocation of payment amount -
Enter amount of interest payment : 405.12
Enter amount of principal payment : 751.33
Enter amount of late charge paid : 60.87
Is the payment correct? Y/N : N
Esc = abort PgDn = save F1 = help
LOAN MASTER Loan Processing System 79
The top part of this screen reports the current status
of the loan.
PAY PARTICULAR ATTENTION TO THE DATE LAST UPDATE. If
that date is not today, the interest accruals will not
be correct and the amounts due and past due and the
late charges due may not be correct.
Always update the file to the current date before
posting payments.
If you choose not to update every day, but to post
payments in batches, sort your payments into order by
date and update the file a few days at a time to the
date of the oldest payment, then post it and repeat the
process by updating to the date of the next oldest
payment, then posting it, and then the next oldest
payment, etc.
Today is 02-11-88. You have received the check for the
payment due on this loan. The amount of the check is
$1,217.32, the exact amount of the scheduled payment.
The late charge due is not included.
Your company policy is to always collect late charges.
This is done by collecting first the late charge
amount, then the interest amount, then applying the
remainder of the check to the principal.
Total check 1,217.32
Late charge due 60.87
Interest due 405.12
Remaining for principal payment 751.33
Now look at the screen. You will notice that the
computer has already done this calculation and
displayed the results for you to either accept or to
reject. To accept this allocation of interest principal
and late charge, you simply press the enter (or down
arrow) key until the question "Is the payment correct?"
is highlighted. Note that the answer to this question
is "N". If you press enter accidentally, the payment
LOAN MASTER Loan Processing System 80
will not be accepted or rejected. You will be offered
an opportunity to change it. If you do not like this
allocation of the payment to interest, principal, and
late charge, you may use the up and down arrow keys to
select each field and then change the allocation to
match your requirements.
When the payment is allocated properly, move the
highlight to the "N" after the question "Is this
payment correct?", change the "N" to "Y". The payment
is posted and the file is updated immediately.
When posting payments to real loans, it is not
necessary to accept the allocation of the payment
computed by the program. The operator may use the
cursor keys to highlight and change the total payment
amount, the interest payment amount, the principal
payment amount, or the late charge paid amount.
When the payment is posted, (accepted), the loan lookup
screen reappears anticipating another loan lookup to
post another payment. When you finish posting press
enter twice, once on the empty customer number field
and once on the empty loan number field. The program
will return to the file maintenance menu. Alternatively
you may press the Esc key to exit the loan lookup
screen with one key.
18) Select the loan maintenance function to edit a loan
record. When asked, respond locate by borrower number.
Enter the borrower number, 76543 to retrieve our loan
record.
LOAN MASTER Loan Processing System 81
The (first) loan maintenance screen will look like
this:
LOAN RECORD UPDATE SCREEN
Customer No. 76543 Original Amt. 36,000.00
Loan No. 3 Scheduled Bal. 35,180.18
Cust name. Current Bal. 35,248.67
Comments Accrued Int. 130.69
Int. due unpaid 0.00
Makers/Guarantors ... Prin. due unpd 68.49
Int. paid YTD 405.12
Int. paid life 405.12
Late Chg due 0.00
Late Chg YTD 60.87
Date Note 01/01/88 Late Chg Life 60.87
Date First Pmt 02/01/88 Late Charge Rate 0.0500
Date maturity 01/01/91 Late Charge @ Day 10
Next Pmt Due 03/01/88 Payment Amt Reg 1,217.32
Pmt due for 03/01/88 Payment Amt Lst 1,217.32
Date last mty 02/01/88 Number payments 36
Last transaction 02/11/88 Final payment no 36
Last update 02/11/88 Payments matured 0
Int Rate Orig 13.2500 Payments paid 1
Int Rate Cur 13.2500 Payments per yr 12
Int Comp Basis 365 Days past due -19
No int. until / / Gross payoff 35,379.36
This screen displays all the fields that relate to
interest, principal, late charges, and past due status.
Some of these date fields may need an explanation.
Next pmt due 03/01/88
This is the next date a payment is due to be paid.
regardless of whether all previous payments have been
made or not.
LOAN MASTER Loan Processing System 82
On 02/05/88 the Next payment due date was 03/01/88. The
next payment maturity date at that time was 03/01/88.
Even though the 02/01/88 payment had not been made, the
03/01/88 was the NEXT date on which a payment would be
due.
Pmt due for 03/01/88
This is the date of the oldest payment which has
matured but which has NOT BEEN PAID. This date is now
03/01/88 but during the period after 02/01/88 but
before the payment was made, this date was 02/01/88.
Check the screens above.
Date last mty. 02/01/88
This is the most recent, past, date on which a payment
became due.
Last Transaction (date) 02/11/88
This is the most recent date on which a transaction was
posted to this account. A late charge assessment is a
transaction and does change this date.
Scheduled Balance 35,180.18
This field maintains the scheduled balance based on the
same rules used by a normal amortization schedule. All
payments are made on the due date and interests is
computed by even months. The first month's calculations
are:
LOAN MASTER Loan Processing System 83
Balance 36,000.00
Times Rate 13.25
One year interest 4,770.00
Divide by 12 12.00
One month interest 397.50
Payment amount 1,217.32
Interest payment 397.50
Principal payment 819.82
Remaining (scheduled) balance 35,180.18
Current bal.
This is the actual principal balance remaining unpaid.
Interest accrued.
Interest accrued is the present amount of interest that
has been earned on this loan but which has not been
paid since the loan began. This amount increases by one
day's accrual each day the loan is updated. It is
decreased only when interest payments are posted.
Interest begins to accrue on the first day of the loan.
The lender has earned it and the borrower owes it. This
is not the same thing as being DUE within the meaning
used by Loan Master. As used by Loan Master, DUE means
either the entire loan or at least a scheduled payment
has matured, has become payable, is DUE.
Interest due unpaid.
Since the payment was made, and all interest was
collected and posted (although late), no interest
amount is DUE today. See the explanation of DUE in the
above paragraph dealing with interest accrued.
LOAN MASTER Loan Processing System 84
Principal due unpaid $68.49
This is the difference between the actual balance and
the scheduled balance. It is used as an indication of
relative performance. When an loan is several years old
and has had partial payments, early payments and late
payments posted with and with out late charges. It
becomes very difficult to determine if the payments
actually received are adequate or inadequate. The
traditional way to judge the status of this type loan
is to print an amortization schedule and compare the
actual balance to the scheduled balance. Loan Master
performs the same function internally.
In this case, the actual amount, $68.49 consists of two
components.
Actual interest collected 405.12
Scheduled interest 397.50
Difference 7.62
Late charge collected 60.87
Sum, LC + interest difference 68.49
Since both the late charge collected and the extra
interest collected both act to reduce the principal
payment, the actual principal balance remaining is
larger than the scheduled balance by the sum of the two
amounts.
Sample setup of existing loan
This example MUST be done using a NEW, BLANK loan
database file. If you have entered loan data on any loans in
to the data base, save it in a safe place, perhaps on
another disk or an other subdirectory, then use the original
LOAN MASTER distribution disk to reinstall LOAN MASTER. This
will insure hou have an empty data file.
We will be printing a past due notice and a pre due
notice as part of this example. If you want those notices to
have mailing addresses for use in window envelopes, the
addresses must be created by the Loan Master Customer
LOAN MASTER Loan Processing System 85
Information System. If you have this system, refer to its
manual and create a file record with the following data.
Customer number : 76543
Last name : Smith
First Name : Sam
Initial : S
Title : Mr
Address : 12345 Smithfield Drive
: Smithfield Arkansas
Zip : 44444
If you do not have the Customer Information System,
just skip the above. You will still get notices. They will
have the borrower's name but no address. You can type in the
address and use them in window envelopes or you can use
regular number 10 envelopes and address them.
Today is August 10, 1989. We have selected August 15th
as our conversion date and the loan described below is to be
set up as an existing loan.
The loan:
Loan date 01-01-88
Date first payment 02-01-88
Face amount 36,0000.00
Interest rate 13.25%
Payment amount 1,217.32
Number payments 36
An amortization schedule is available. It is
reproduced here.
LOAN MASTER Loan Processing System 86
no Date Date Interest Principal Balance Cumulative
due paid payment payment remaining interest
1 02-01-1988 _______ 397.50 819.82 35,180.18 397.50
2 03-01-1988 _______ 388.45 828.87 34,351.31 785.95
3 04-01-1988 _______ 379.30 838.02 33,513.29 1,165.25
4 05-01-1988 _______ 370.04 847.28 32,666.01 1,535.29
5 06-01-1988 _______ 360.69 856.63 31,809.38 1,895.98
6 07-01-1988 _______ 351.23 866.09 30,943.29 2,247.21
7 08-01-1988 _______ 341.67 875.65 30,067.64 2,588.88
8 09-01-1988 _______ 332.00 885.32 29,182.32 2,920.88
9 10-01-1988 _______ 322.22 895.10 28,287.22 3,243.10
10 11-01-1988 _______ 312.34 904.98 27,382.24 3,555.44
11 12-01-1988 _______ 302.35 914.97 26,467.27 3,857.79
---------------------------------------------------------------------------
12 01-01-1989 _______ 292.24 925.08 25,542.19 4,150.03
13 02-01-1989 _______ 282.03 935.29 24,606.90 4,432.06
14 03-01-1989 _______ 271.70 945.62 23,661.28 4,703.76
15 04-01-1989 _______ 261.26 956.06 22,705.22 4,965.02
16 05-01-1989 _______ 250.70 966.62 21,738.60 5,215.72
17 06-01-1989 _______ 240.03 977.29 20,761.31 5,455.75
18 07-01-1989 _______ 229.24 988.08 19,773.23 5,684.99
19 08-01-1989 _______ 218.33 998.99 18,774.24 5,903.32
---------------------------------------------------------------------------
20 09-01-1989 _______ 207.30 1,010.02 17,764.22 6,110.62
21 10-01-1989 _______ 196.15 1,021.17 16,743.05 6,306.77
22 11-01-1989 _______ 184.87 1,032.45 15,710.60 6,491.64
23 12-01-1989 _______ 173.47 1,043.85 14,666.75 6,665.11
24 01-01-1990 _______ 161.95 1,055.37 13,611.38 6,827.06
25 02-01-1990 _______ 150.29 1,067.03 12,544.35 6,977.35
26 03-01-1990 _______ 138.51 1,078.81 11,465.54 7,115.86
27 04-01-1990 _______ 126.60 1,090.72 10,374.82 7,242.46
After careful planning, we determine our conversion
date will be August 15, 1989.
First, locate the conversion date on the schedule. The
exact conversion date will most likely not be there. Draw a
line across the schedule between the two payments dated
immediately before and immediately after the conversion
date.
Second, draw another line between the January payment
of this year and the December payment of the previous year.
LOAN MASTER Loan Processing System 87
These two lines are represented on the above schedules
by the dotted lines.
Referring to the schedule, we determine that the
borrower has not yet paid the payment due on August 1, 1989.
The last payment was the July first payment.
Referring to the schedule, we see that after the July
payment, the remaining balance was $19,773.23
On August first the interest due was $218.33.
On August 15th, the conversion date an additional 14
days interest will be due. We calculate this amount as
follows:
14 days
14 days interest = .1325 x $19,773.24 x ------------
365 days
14 days interest = $100.49
Total interest due
on conversion date
Interest due 08-01-89 $218.33
Interest for Additional
14 days $100.49
-------------------------------------------------
Int due conversion date $318.82
If we are charging late charges, we determine that the
payment is late enough to charge a late charge. Our late
charge is 5% of the payment amount or 0.05 x 1217.32 = 60.87
LOAN MASTER Loan Processing System 88
We add up the interest paid each month from the
schedule and determine that the total interest paid year to
date is $1827.20. This is the total interest paid beginning
with the January payment. The two lines you drew on the
chart identify the payments paid this year. The interest
payments between these lines make up the interest paid YTD.
DO NOT ADD IN THE INTEREST FOR PAYMENTS THAT HAVE NOT BEEN
PAID!
The principal amount due after the July payment was
19,773.23. That is the current balance. From the schedule,
we see that the current balance SHOULD BE 18,774.24 if the
August payment had been made. Loan Master calls this the
scheduled balance. The amount of principal due and unpaid is
the amount necessary to reduce the current balance to the
scheduled balance. Since only one payment is late, this is
also the amount of the scheduled principal payment for
August 1, 1989. The principal due and unpaid is 19,773.23 -
18,774.24, or 998.99.
The number of payments matured, again from the
schedule, is 19. If your schedule does not list the payment
number, you must count them. The number of payments actually
made is 18, since the August payment has not been made yet.
We now have identified these amounts. As of the
conversion date:
Balance due 19,773.23
Interest due 318.82
Interest paid YTD 1,827.20
Late charge due 60.87
Late charges YTD 0.00
Principal Due, Unpaid 998.99
1) Transfer these amounts to the loan maintenance sheet.
It will look like the example on the next page.
LOAN MASTER Loan Processing System 89
Loan Maintenance Sheet
Date of setup: 08_/15_/89 Entered by : Bob_________
LOAN RECORD UPDATE SCREEN
Customer No. 76543 Original Amt. _36000.00______
Loan No. 3 Scheduled Bal. _18774.24______
Cust name. Smith, Sam________________ Current Bal. _19773.23______
Comments This is Sam's Swimming____ Accrued Int. _318.82________
pool HIP loan. Int. due unpaid _218.33________
Makers/Guarantors ... Prin. due unpd _998.99________
Smith, Sam________________ Int. paid YTD _1827.20_______
__________________________ Int. paid life _5684.99_______
__________________________ Late Chg due ___60.87_______
__________________________ Late Chg YTD _______0_______
Date Note 01/01/88 Late Chg Life _______0_______
Date First Pmt 02/01/88 Late Charge Rate _0.05__________
Date maturity 01/01/91 Late Charge @ Day _10 ___________
Next Pmt Due 09/01/89 Payment Amt Reg _1217.32_______
Pmt due for 08/01/89 Payment Amt Lst _1217.32_______
Date last mty 08/01/89 Number payments _36____________
Last transaction 07/01/89 Final payment no _36____________
Last update 08/15/89 Payments matured _19____________
Int Rate Orig 13_.25__ Payments paid _18____________
Int Rate Cur 13_.25__ Payments per yr _12____________
Int Comp Basis 365_____ Days past due calculated field
No int. until / / Gross payoff calculated field
The term "calculated field" in the example means you
cannot enter this data. It is calculated and displayed
in that location by the program.
The actual data displayed should be 14 days past due
and $20,152.92 gross payoff
If you are using the user defined fields on the
optional user defined screen, you will also complete
the maintenance sheet for the user defined screen.
LOAN MASTER Loan Processing System 90
Since this is an example, press the Page Down key to
skip the user defined data entry screen.
Loan Maintenance Sheet
User Defined Screen
Date 08_/15_/89 Entered by Bob______
<-- Name of User's custom screen here ->
Customer No. Cannot change Original amount : cannot change
Loan No. Cannot change Current balance : cannot change
Cust name. ______________________
Comments ______________________
Alpha field 1 _______________________
Alpha field 2 _______________________
User field 1 _____________ Numeric field 1 : _______________
User field 1 ytd _____________ Numeric field 2 : _______________
User field 2 _____________ Numeric field 3 : _______________
User field 2 ytd _____________ Numeric field 4 : _______________
Ret check chg _____________ Numeric field 5 : _______________
Reg check chg ytd _____________ Numeric field 6 : _______________
Blank maintenance sheets will be found in the back of
the manual. You may reproduce them on any copier.
2) Return now to the main menu. and select the menu option
to update the program options. From the next menu,
select the option to update the parameter file.
LOAN MASTER Loan Processing System 91
The parameter file update screen looks like this:
LOAN MASTER
Update User Defined Parameters
Company Name: Bottom Line Financial Services Past due notice at day : 6
Address : P.O. Box 1804 Pre due notice at day : 6
Address : Burleson, TX 76028-1804 Pmt Allocation option : 4
Address : Visual update on : T
Payment fraction : 0.9400
Date file update : 08/15/89
User field 1 : User field 1 ytd Numeric field 1: Numeric field 1 :
User field 1 YTD : User field 1 : Numeric field 2: Numeric field 2 :
User field 2 : User field 2 : Numeric field 3: Numeric field 3 :
User field 2 YTD : User field 2 ytd : Numeric field 4: Numeric field 4 :
Penalty field : Ret check chg : Numeric field 5: Numeric field 5 :
Penalty field YTD: Reg check chg ytd: Numeric field 6: Numeric field 6 :
Alpha field 1 : Alpha field 1 :
Alpha field 2 : Alpha field 2 :
Name of user defined screen:
<-- Name of User's custom screen here ->
Set the date file update field to the date shown,
08/15/89. This is the date we chose as our conversion
date. When the date is changed to these values, press
the Page Down key to save the data and exit this
screen.
3) Return again to the main menu and select the option to
update the loan file.
When the update screen appears:
1) Set the date of update to 09/02/89. This is ond
day after the next payment is due.
2) Set visual update to "T".
LOAN MASTER Loan Processing System 92
3) Set pause after each update to "T".
The first date updated will be 08/16/89. After that
update, the screen will pause with this display.
Updating cust no : 76543 loan no : 3 record no : 1
Updating for ... 08/16/89
Field Before After Field Before After
Name Update Update Name Update Update
Current bal 19,773.23 19,773.23 Date first pmt 02/01/88 02/01/88
Schuled bal 18,774.24 18,774.24 Date next pmt 09/01/89 09/01/89
Int accrued 318.82 326.00 Date last mty 08/01/89 08/01/89
Int due 218.33 218.33 Date pmt missed 08/01/89 08/01/89
Prin due 998.99 998.99 Date last tran 07/01/89 07/01/89
Late cg due 60.87 60.87 Date last upd 08/15/89 08/16/89
Late cg pd 0.00 0.00 Days past due 15
Late cg ytd 0.00 0.00 Days Lt Chg 15
Interest pd 5,684.99 5,684.99
Interest ytd 1,827.20 1,827.20
Current rate 13.25000 13.25000
Press the return key repeatedly. Each time the key is
pressed the loan will be updated one more day and the
screen will display the changes.
Watch the date last update field carefully. When it
reaches 08/31/89, the screen will look like this:
Updating cust no : 76543 loan no : 3 record no : 1
LOAN MASTER Loan Processing System 93
Updating for ... 08/31/89
Field Before After Field Before After
Name Update Update Name Update Update
Current bal 19,773.23 19,773.23 Date first pmt 02/01/88 02/01/88
Schuled bal 18,774.24 18,774.24 Date next pmt 09/01/89 09/01/89
Int accrued 426.49 433.67 Date last mty 08/01/89 08/01/89
Int due 218.33 218.33 Date pmt missed 08/01/89 08/01/89
Prin due 998.99 998.99 Date last tran 07/01/89 07/01/89
Late cg due 60.87 60.87 Date last upd 08/30/89 08/31/89
Late cg pd 0.00 0.00 Days past due 30
Late cg ytd 0.00 0.00 Days Lt Chg 30
Interest pd 5,684.99 5,684.99
Interest ytd 1,827.20 1,827.20
Current rate 13.25000 13.25000
Note that date last update is 08/31/89. The loan is now
30 days past due. Another payment is due tomorrow
(09/01/89). Also note the interest due, principal due,
and late charge due fields. They have not changed. They
will change at the next update, 09/01/89.
Press the enter key again to continue the update
process. This will cause the September first update to
be done. Another payment matures today and all the
fields contining amounts due will change.
LOAN MASTER Loan Processing System 94
The update screen for 09/01/89 looks like this:
Updating cust no : 76543 loan no : 3
record no : 1
Updating for ... 09/01/89
Field Before After Field Before After
Name Update Update Name Update Update
Current bal 19,773.23 19,773.23 Date first pmt 02/01/88 02/01/88
Schuled bal 18,774.24 17,764.22 Date next pmt 09/01/89 10/01/89
Int accrued 433.67 440.85 Date last mty 08/01/89 09/01/89
Int due 218.33 440.85 Date pmt missed 08/01/89 08/01/89
Prin due 998.99 2,009.01 Date last tran 07/01/89 07/01/89
Late cg due 60.87 60.87 Date last upd 08/31/89 09/01/89
Late cg pd 0.00 0.00 Days past due 31
Late cg ytd 0.00 0.00 Days Lt Chg 0
Interest pd 5,684.99 5,684.99
Interest ytd 1,827.20 1,827.20
Current rate 13.25000 13.25000
Note the changes in these fields:
Field: Changed from to
Interest accrued 433.67 440.85
Interest due 218.33 440.85
Principal due 998.99 2009.01
Days Late charge 30 0
The late charge due did not change. The payment is due
today but the late charge is not due for ten days.
notice that the late charge counter changed from 30
days to 0 days. The late charge counter starts new
today. if it reaches 10 days, a new late charge will be
added.
LOAN MASTER Loan Processing System 95
Press the enter key one more time. The September second
update will be performed and the menu will return.
Return to the Main Menu.
4) After returning to the main menu, select the option for
printed reports, then select the option to print the
past due report. Our loan will appear on the past due
report. Of course since it is the only loan in the data
base, it will be the only loan on the past due report.
Next select the option to display the notices menu.
From that menu request past due notices. You will now
receive a past due notice for the loan. If you created
a name and address record with the Loan Master Customer
Information System, your past due notice will have the
name and address printed so that the notice can be
folded and placed in a number 10 window envelope. If
you did not create the name and address record, the
name will appear but the address space will be blank.
5) Return again to the main menu. This time, select the
transaction maintenance option and then the payment
posting option. You will now see the posting screen. It
looks like this:
LOAN MASTER Loan Processing System 96
The posting screen looks like this:
Post a loan payment
Cust: 76543 Loan: 3 Customer Smith, Sam
Date of last update : 09/02/89
Total interest accrued not paid : 448.02
Interest due, not yet paid : 440.85
Principal due, not yet paid : 2,009.01
Late charges due, not yet paid : 60.87
Total amount due, not yet paid : 2,510.73
Payment due for (date) : 08/01/89
Scheduled payment amount : 1,217.32
Enter the date of the transaction : 09/02/89
Enter the total amount received : 1,217.32
Allocation of payment amount -
Enter amount of interest payment : 440.85
Enter amount of principal payment : 715.60
Enter amount of late charge paid : 60.87
Is the payment correct? Y/N : N
Esc = abort PgDn = save F1 = help
The top part of this screen reports the current status
of the loan.
PAY PARTICULAR ATTENTION TO THE DATE LAST UPDATE. If
that date is not today, the interest accruals will not
be correct and the amounts due and past due and the
late charges due may not be correct.
Always update the file to the current date before
posting payments.
If you choose not to update every day, but to post
payments in batches, sort your payments into order by
date and update the file a few days at a time to the
LOAN MASTER Loan Processing System 97
date of the oldest payment, then post it and repeat the
process by updating to the date of the next oldest
payment, then posting it, and then the next oldest
payment, etc.
Note that the information about what is due and payable
at the top of this screen is the same as was displayed
on the last visual update screen.
You have in hand the check for the August first
payment. It is in the amount of $1,217.32. You intend
to collect the late charge.
The bottom part of the screen is the posting screen. It
has already preallocated the payment for you. In this
case, we agree with the allocation so you press the
enter key until the "N" is highlighted at the bottom of
the screen. Change this "N" to "Y", the payment will be
accepted and posted immediately.
7) Select the posting option again. This time the screen
will look like this:
LOAN MASTER Loan Processing System 98
The posting screen looks like this:
Post a loan payment
Cust: 10003 Loan: 3 Customer no: 3
Date of last update : 09/02/89
Total interest accrued not paid : 7.17
Interest due, not yet paid : 0.00
Principal due, not yet paid : 1,293.41
Late charges due, not yet paid : 0.00
Total amount due, not yet paid : 1,217.32
Payment due for (date) : 09/01/89
Scheduled payment amount : 1,217.32
Enter the date of the transaction : 09/02/89
Enter the total amount received : 1,217.32
Allocation of payment amount -
Enter amount of interest payment : .00
Enter amount of principal payment : 1,217.32
Enter amount of late charge paid : 0.00
Is the payment correct? Y/N : N
Esc = abort PgDn = save F1 = help
Again, assume you have received another payment, you
agree with the precomputed allocation and apply the
payment by accepting the computer's allocation. Change
the "N" to "Y" and the payment is posted.
When posting payments to real loans, it is not
necessary to accept the allocation of the payment
computed by the program. The operator may use the
cursor keys to highlight and change the total payment
amount, the interest payment amount, the principal
payment amount, or the late charge paid amount.
8) Return again to the Main Menu and update the file
through 09/28/89. The next payment is due on 10/01/89,
LOAN MASTER Loan Processing System 99
only three days from now. Since the parameter file
specifies pre due notices for anything less than or
equal to six days before maturity, this loan needs a
pre due notice.
9) Return again to the Main Menu and select the Printed
Reports Menu. From that menu, select the printed
notices menu and then the will be due notice.
You will now receive a will be due notice for the loan.
If you created a name and address record with the Loan
Master Customer Information System, your notice will
have the name and address printed so that the notice
can be folded and placed in a number 10 window
envelope. If you did not create the name and address
record, the name will appear but the address space will
be blank.
Loan Master Reports
The loan processing system produces these reports:
Trial Balance Report
Past Due Loans Report
Past Due Notices
Past Due Notices Custom.
Will Be Due Notice (Billing Statement)
Loan Transaction Statement
Year End Interest Statement
LOAN MASTER Loan Processing System 100
Past Due and Will Be Due
The numbers on the past due report do not agree with
the numbers on the will be due notice, Why?
The past due notice gives the status of the loan as of
a date on the past. The date of the payment missed.
The will be due notice gives the anticipated amounts
due at a date in the future, the date the payment will be
due.
Will Be Due Notices
The Will Be Due notice lists this information.
Date of notice
Date payment will be due
Interest due
Principal due
Late charge due
Date of notice
The date of notice is the date the loan was last
updated. This date is used in case a payment has been
made since that date but which has not yet been posted
to the account.
Date payment will be due
This is the date the next payment will mature. The
next regularly scheduled payment will be due on this
date.
Interest due
This is the anticipated amount of interest due on
the date of the next regularly scheduled payment date.
This amount includes all interest accrued through the
date of the notice plus the interest that will accrue
LOAN MASTER Loan Processing System 101
from the date the notice is printed to the date the
payment is due.
NOTE that this is ALL interest accrued and not
paid as of the date of the next payment.
Principal due
This is the anticipated principal that will be due on
the next regularly scheduled payment date. This amount is
calculated by taking the principal due amount and adding the
anticipated principal component of the total payment amount
as of the date of the next payment.
EXAMPLE
The payment is due in 4 days. The interest accrued as
of today is $233.00, four days interest is 36.00. The
interest that "Will be due" in four days is $233.00 + 36.00
or $269.00.
The principal due today is $14.00. The payment due in
four days is $300.00.
LOAN MASTER Loan Processing System 102
The principal due in four days will be:
Payment due $300.00
Interest due 269.00
-----------------------------------------------
Principal component 31.00
of this payment
Principal due now
from prior payments 14.00
------------------------------------------------
Total principal due 45.00
NOTE:
Total principal due 45.00
Total interest due 269.00
--------------------------------------------------
Total amount due 314.00
Total amount billed 314.00
Scheduled payment 300.00
The will be due notice has billed the customer for the
amount needed to bring the note current, not just the amount
of the regularly scheduled payment.
LOAN MASTER Loan Processing System 103
Problems with will be due notices
If you do not receive a will be due notice when you
think you should, check the dates carefully. Use the edit
screen to check the dates.
A will be due, or billing notice is sent when the
number of days from the date of last update to the date next
due is less than or equal to the number of days specified in
the parameter file for will be due notiices.
Past due notices
The past due notice is easier to understand then the
will be due notice. The past due notice lists this
information:
Interest Due
Principal Due
Late charge due
Each of these amounts comes directly from the master
file with no calculations or assumptions or projections.
The interest due is the amount of interest which has
matured but has not been paid. It is not the total interest
accrued. See the date definitions for an explanation of the
difference.
The principal due is the amount of principal which has
matured but which has not been paid.
The late charge due is the total of all late charges
which have been assessed but which have not yet been paid.
LOAN MASTER Loan Processing System 104
Problems with past due notices
Past due notices are determined by the current date.
The date today. When the program starts, it reads the date
from the computer's system clock and reports it. You are
asked to verify it. The date you enter, or accept, in
response to this question will be used to determine if a
past due notice is sent.
The days past due is defined by the program as the
number of days between the date of the oldest payment missed
and the date of the last update. The names of these fields
are DATE_DUE and DATE_UPD. You may read more about these
dates in the section called Data Fields, Description.
When a past due notice is printed the definition used
for data past due is changed to use today's date instead of
date update. Today's date is the date you entered when the
program started.
Problems with test data
If you are getting past due notices on loans which are
not past due, it is likely that you are using an old master
file (a file not updated to the current date) and have
allowed the computer to use the current date.
When using test data and experimenting with the
examples given in the manual, be sure the system date,
(today's date) is set to a date near the date of update
being used by your test data. To set this date, you must
exit the program and restart it.
Loan Master Files
The Loan Master Loan processing system stores a
considerable amount of data on the disk drive. Data is
stored in these files:
LOAN MASTER Loan Processing System 105
File name Description Location
1.BAT Not used by Loan Master
2.BAT Not used by Loan Master
2.BAT Not used by Loan Master
2.DOC Not used by Loan Master
3.BAT Not used by Loan Master
4.BAT Not used by Loan Master.
CIADDR.DBF blank address file data disk or
directory.
CICUST.DBF blank customer file data disk or
directory.
CIHELP.DBF CIF help file data disk or
directory.
CIHELP.DBT CIF help screens data disk or
directory.
CIHELP.NTX CIF help index data disk or
directory.
CIMENU.EXE CIF program file Program disk or
directory.
This file is quite large and will not fit on
the same 360K disk with the LOAN MASTER
program file.
CIPARM.DBF CIF options file This file must
be on the same
disk or in the
same directory
as CIF.EXE.
CIPARM.FD Floppy disk parm file.Tells CIF.EXE to
look for data on drive B: If you use a
two drive, drive a: and drive B: system,
this file must be on your CIF program
disk.
LOAN MASTER Loan Processing System 106
CIPARM.HD HARD disk parm file
Tells CIF.EXE to look for the data files
in the current directory of the current
disk. This requires the data files and
the help files to be in the same
directory as the program file. It can be
used on a hard disk or on a high density
floppy (720K or larger).
CIPHONE.DBF Phone file Data disk or
directory.(Not
used)
CIREMIND.DBF Reminder file Data disk or
directory. (Not
used)
CONFIG.DOC Important info READ THIS FILE!
CONFIG.SYS Sample config file
Root directory of boot or hard disk. DO
NOT COPY THIS FILE IF YOUR SYSTEM
ALREADY HAS A FILE WITH THIS NAME!!!
LMHELP.DBF Loan Master help file Data disk or
directory.
LMHELP.DBT Loan Master help screens Data disk or
directory.
LMHELP.NTX Loan Master help index Data disk or
directory.
LMLOAN.DBF Loan Master data file Data disk or
directory.
LMLOAN.NTX Loan Master data index Data disk or
directory.
LMMENU.EXE Loan Master Program Program disk or
directory.
LMMENU.HLP Loan Master On Line Manual
LOAN MASTER Loan Processing System 107
Program disk or
directory.
LMMENU.QHX Loan Master Manual Index Program disk or
directory.
LMPARM.DBF Loan Master options file Program disk or
directory.
LMPARM.FD Floppy disk options file
Use only on two drive system using drive
A: for program and drive B: for data. If
used, copy it to the program disk and
rename it to LMPARM.DBF.
LMPARM.HD Hard disk options file
This file tells Loan Master to look for
its data in the current directory. It
can be used on a hard disk system or on
a large capacity floppy disk if the data
files are stored on the same disk as the
program. (requires at least 720K floppy
capacity.)
LMTRAN.DBF Transaction file
Data disk or directory. Stores all
transactions for all loans.
MENU.BAT Not used by Loan Master.
MENU.BAT Not used by Loan Master.
MENU.SCR Not used by Loan Master.
MENU.SCR Not used by Loan Master.
README.BAT Not used by Loan Master.
LOAN MASTER Loan Processing System 108
Normal system files
These files are necessary for Loan Master to operate:
1) LMLOAN.DBF The loan data base file.
2) LMLOAN.NTX The loan data base index.
3) LMTRAN.DBF The transaction database.
4) LMTRAN.NTX The transaction index file.
5) LMPARM.DBF The parameter file.
6) LMHELP.DBF The help system.
7) LMHELP.DBT The help screens text.
8) HELP.NTX The help system index.
9) LMMENU.HLP The on line manual.
10) LMMENU.QHX The on line manual index.
These files are necessary for the Customer Information
System to opeerate:
1) CIMENU.EXE The Customer Information program.
2) CICUST.DBF The customer information database file.
3) CIADDR.DBF The customer adddress file.
4) CIHELP.DBF The customer information system help
system.
5) CIHELP.DBT The actual help screens text.
6) CIHELP.NTX The customer information help screen
index.
LOAN MASTER Loan Processing System 109
File specifications
Field definitions for LMLOAN.DBF
Field name Data type Size Dp
CUST_NO Character 12
LOAN_NO Character 12
CUST_NAME Character 24
MAKER1 Character 24
MAKER2 Character 24
MAKER3 Character 24
MAKER4 Character 24
COMMENT1 Character 24
COMMENT2 Character 24
ORG_AMT Numeric 12 2
CUR_BAL Numeric 12 2
SCH_BAL Numeric 12 2
PMT_AMT_RG Numeric 12 2
PMT_AMT_FN Numeric 12 2
RATE_ORG Numeric 7 4
RATE_CUR Numeric 7 4
BASIS Numeric 3 0
N0_PMTS Numeric 3 0
FINAL_PMT Numeric 3 0
DATE_NOTE Date 8
DATE_FIRST Date 8
DATE_NEXT Date 8
DATE_DUE Date 8
DATE_LAST Date 8
DATE_TRAN Date 8
DATE_UPD Date 8
DATE_MTY Date 8
DATE_NOINT Date 8
PMTS_MTD Numeric 3 0
PMTS_PAID Numeric 6 2
PMT_FREQ Numeric 2 0
INT_ACCRD Numeric 12 4
INT_DUE Numeric 12 2
PRIN_DUE Numeric 12 2
LC_DUE Numeric 12 2
LC_PAID Numeric 12 2
LC_RATE Numeric 7 4
LC_YTD Numeric 12 2
INT_PAID Numeric 12 2
LOAN MASTER Loan Processing System 110
INT_YTD Numeric 12 2
PENALTY Numeric 12 2
PENALTYYTD Numeric 12 2
USER1 Numeric 12 2
USER1YTD Numeric 12 2
USER2 Numeric 12 2
USER2YTD Numeric 12 2
NUMERIC1 Numeric 12 2
NUMERIC2 Numeric 12 2
NUMERIC3 Numeric 12 2
NUMERIC4 Numeric 12 2
NUMERIC5 Numeric 12 2
NUMERIC6 Numeric 12 2
ALPHA1 Character 30
ALPHA2 Character 30
LOAN MASTER Loan Processing System 111
Field definitions for LMPARM.DBF
Field name Data type Size Dp
NAME Character 30
ADDRESS1 Character 24
ADDRESS2 Character 24
ADDRESS3 Character 24
PDLIMIT Numeric 2 0
WBLIMIT Numeric 2 0
LCLIMIT Numeric 2
PMTFRACT Numeric 6 0
VISUAL Logical 1
LSTFILEUPD Date 8
PSWDMASTER Character 12
NAMEUSER1 Character 18
NAMEU1YTD Character 18
NAMEUSER2 Character 18
NAMEU2YTD Character 18
NAMEPEN1 Character 18
NAMEPEN1YTD Character 18
NAMENUM1 Character 18
NAMENUM2 Character 18
NAMENUM3 Character 18
NAMENUM4 Character 18
NAMENUM5 Character 18
NAMENUM6 Character 18
NAMEALPH1 Character 18
NAMEAPPH2 Character 18
NAMEUSERSCR Character 18
LOAN MASTER Loan Processing System 112
Field definitions for LMTRAN.DBF
Field name Data type Size Dp
CUST_NO Character 12
LOAN_NO Character 1 2
TRAN_DATE Date 8
TRAN_CODE Numeric 4 0
TRAN_RATE Numeric 7 4
DAYS_ACCR Numeric 4 0
INT_ACCD Numeric 12 4
INT_PAID Numeric 12 2
PRIN_PAID Numeric 12 2
LC_PAID Numeric 12 2
LOAN MASTER Loan Processing System 113
New Loan Setup Sheet
Date __________ Entered by: __________
Customer No. ________________________ Original Amt. ______________
Loan No. ________________________ Late Charge Rate ______________
Customer name. ________________________ Late charge at day ______________
Comments ________________________ Payment Amt Reg ______________
________________________ Payment Amt Lst ______________
Makers/Guarantors ... Number payments ______________
________________________ Final payment no ______________
________________________ Payments per yr ______________
________________________
________________________
Date Note / /
Date first Pmt / /
Date maturity / /
No int. until / /
Int Rate Orig ____.______
Int Comp Basis ___________
LOAN MASTER Loan Processing System 114
Loan Maintenance Sheet Date ___________ Entered by ___________
Customer No. _______________________ Original Amt. _______________
Loan No. __________________________ Scheduled Bal. _______________
Cust name. __________________________ Current Bal. _______________
Comments __________________________ Accrued Int. _______________
Int. due unpaid _______________
Makers/Guarantors ... Prin. due unpd _______________
__________________________ Int. paid YTD _______________
__________________________ Int. paid life _______________
__________________________ Late Chg due _______________
__________________________ Late Chg YTD _______________
Date Note / / Late Chg Life _______________
Date First Pmt / / Late Charge Rate _______________
Date maturity / / Late Charge @ Day _______________
Next Pmt Due / / Payment Amt Reg _______________
Pmt due for / / Payment Amt Lst _______________
Date last mty / / Number payments _______________
Last transaction / / Final payment no _______________
Last update / / Payments matured _______________
Int Rate Orig ___.____ Payments paid _______________
Int Rate Cur ___.____ Payments per yr _______________
Int Comp Basis ________ Days past due _______________
No int. until / / Gross payoff _______________
LOAN MASTER Loan Processing System 115
Loan Maintenance Sheet
User Defined Screen
Date ___________ Entered by ___________
< >
Customer No. Original amount :
Loan no Current balance :
Cust name. ______________________
Comments ______________________
Alpha field 1 _______________________
Alpha field 2 _______________________
User field 1 _____________ Numeric field 1 : _______________
User field 1 ytd _____________ Numeric field 2 : _______________
User field 2 _____________ Numeric field 3 : _______________
User field 2 ytd _____________ Numeric field 4 : _______________
Ret check chg _____________ Numeric field 5 : _______________
Reg check chg ytd _____________ Numeric field 6 : _______________
LOAN MASTER Loan Processing System 116
Loan Maintenance Sheet
User Defined Screen
Date ___________ Entered by ___________
< >
Customer No. Original amount :
Loan No. Current balance :
Cust name. ______________________
Comments ______________________
_______________________
_______________________
_____________ _______________
_____________ _______________
_____________ _______________
_____________ _______________
_____________ _______________
_____________ _______________
LOAN MASTER Loan Processing System 117
INDEX
Basis . 13, 50, 53, 54, 65, 67, 82, 90, 110,
114, 115
Billing notice . . . . . . . . . . . . . 104
Conversion
conversion date . . . . . . . . . . 61
Cursor control . . . . 4, 13, 14, 19, 21, 27
Customer no 65, 67, 79, 82, 90, 91, 99, 114-117
Customer number . . . . . . . . . . . . . 45
Data entry 4, 12-14, 16, 24, 25, 34, 35, 41,
62, 67, 91
Data fields . . . . . 5, 13, 24, 25, 44, 105
Data fields, description . . . . . . . . 44
Date (of) payment due . . . . . . . . . . 51
Delete . . . . . . 4, 13, 15, 18, 23, 25, 26
Display . 5, 6, 8-11, 13, 18, 19, 24, 25, 27,
31, 33, 39, 44, 45, 58, 59, 70,
93, 96
Edit . 4, 5, 13, 21, 23, 25, 27, 34, 56, 57,
81, 104
Existing loan 2, 4, 5, 18, 23-25, 59, 61-63,
85, 86
Field . 6, 12-15, 17, 19, 21-24, 29, 31, 32,
35, 36, 39, 40, 45, 46, 48, 49,
51, 54-58, 68, 69, 71, 73, 74, 78,
81, 83, 90-95, 110, 112, 113, 116
License agreement . . . . . . . . . . 1, 3, 4
Loan look up . . . . . . . 4, 17, 18, 25, 26
Loan maintenance 4, 19, 23, 66, 77, 81, 82,
89-91, 115-117
Loan no . 65, 67, 71, 73, 74, 78, 82, 90, 91,
93, 95, 114-117
Maker . . . . . . . . . . . . . . . . 20, 46
Menu 4, 5, 9-12, 17, 22-25, 30, 31, 33, 41,
43, 56, 57, 62, 66, 67, 69, 70,
72, 73, 77-79, 81, 91, 92, 96, 99,
100, 108
New loan . . 2, 4, 5, 11, 18, 23-25, 59-63,
65-67, 114
Notices 5, 6, 9, 23, 36, 37, 42, 53, 85, 86,
96, 100, 101, 104, 105
Past due . 5, 6, 16, 18, 23, 35-37, 42, 43,
47, 48, 51-53, 68, 69, 71-78, 80,
82, 85, 90, 92-97, 100, 101, 104,
105, 115
LOAN MASTER Loan Processing System 118
Past due report . . . . . . . . . . . . . . .
5, 23, 42, 96, 101
Posting . . . 4-6, 26-30, 32, 33, 39, 52, 60,
79-81, 96-99
Report menu . . . . . . . . . . . . . . 5, 41
Reports . 2, 3, 5, 6, 23, 24, 36, 41-44, 46,
53, 57, 58, 62, 80, 96, 97, 100, 105
Setup sheet . . . . . . . . . . . 62, 65, 114
Statement . . . 5, 23, 24, 26, 42-44, 61, 100
Transaction statement . . . . . . 5, 44, 100
Trial balance . . . . 5, 11, 23, 41, 62, 100
Updating
file update . . . . . . . . . . . . 58
Visual update . 5, 35, 37, 57, 58, 68-70, 72,
92, 98
Will be Due 5, 6, 23, 36, 37, 42, 78, 88, 100-104
Year end 5, 24, 39, 41, 43, 54, 56, 57, 61, 100
YTD . 29, 31, 35, 54-57, 68, 71, 73, 74, 78,
82, 89-95, 110, 111, 115, 116
LOAN MASTER Loan Processing System 119