
































            Proof read, Spell Checked, Formated, generated  11-23-92
            Revised for vers 1.52                                                 08-01-93









            **********************************************************
            *        NOTICE                                          *
            *                                                        *
            *     Your printer MUST be set to condensed type          *
            *    in order to properly print this manual.             *
            *                                                        *
            *     If your printer is not set to condensed print,      *
            *     Cancel the print job NOW! and set it.               *
            *                                                        *
            *                                                        *
            *     If you do not know how to set condensed print,      *
            *     refer to your printer manual.                       *
            *                                                        *
            *                                                        *
            **********************************************************









                                               WARNING


                                     This software will  not work
                                         for computer experts!

                                   It works only for individuals who
                                read the manual and study the examples.


                     Do not enter trial data just to see what happens. 





            This is a loan accounting system. It makes extensive use  of several different
            dates. If you  do not  understand exactly  what these  dates are  and how  the
            system uses them, you cannot 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  Accounting  System
                                                                 

                                             Versions 1.52

                                            Date  08-01-93

                                        Copyright 1989,91,92,93
                                      Bottom Line Software, Inc.

                                             Serial Number



                                              







                                         TABLE OF CONTENTS


            License Agreement . . . . . . . . . . . . . . . . . . . . . . . . . . . .    1

            Introducing Loan Master . . . . . . . . . . . . . . . . . . . . . . . . .    3

            Installation  . . . . . . . . . . . . . . . . . . . . . . . . . . . . .    4
                  Distribution Disks  . . . . . . . . . . . . . . . . . . . . . . . .    4
                  Automatic Installation  . . . . . . . . . . . . . . . . . . . . . .    5
                  Creating A Subdirectory . . . . . . . . . . . . . . . . . . . . . .    5
                  CIF Installation  . . . . . . . . . . . . . . . . . . . . . . . . .    5
                  Report Writer Installation  . . . . . . . . . . . . . . . . . . . .    6
                  Manual Installation . . . . . . . . . . . . . . . . . . . . . . . .    6
                  Path to Data Files  . . . . . . . . . . . . . . . . . . . . . . . .    7
                  Upgrading Loan Master Versions  . . . . . . . . . . . . . . . . . .    7
                  Automatic Data File Conversion  . . . . . . . . . . . . . . . . . .    7
                        Running the Conversion Program  . . . . . . . . . . . . . . .    8
                        Converting Your Parameter File  . . . . . . . . . . . . . . .    8

            It's Installed, What Next?  . . . . . . . . . . . . . . . . . . . . . . .    9

            User Defined Options, the Parameter File  . . . . . . . . . . . . . . . .    9

            Before  Entering Existing Loans . . . . . . . . . . . . . . . . . . . . .   10
                  Conversion Date . . . . . . . . . . . . . . . . . . . . . . . . . .   10
                  Setting the Update Date . . . . . . . . . . . . . . . . . . . . . .   11
                  New Loan?  or  Existing Loan? . . . . . . . . . . . . . . . . . . .   11

            Learning To Use Loan Master . . . . . . . . . . . . . . . . . . . . . . .   13
                  Sample Setup of New Loan  . . . . . . . . . . . . . . . . . . . . .   13
                  Set Up A New Loan . . . . . . . . . . . . . . . . . . . . . . . . .   14
                  Sample Setup of Existing Loan . . . . . . . . . . . . . . . . . . .   29
                  Setting Up Charged Off Loans (Past Maturity)  . . . . . . . . . . .   41
                        Single Payment Loan - Past Maturity . . . . . . . . . . . . .   43
                        Installment Loan - Past Maturity  . . . . . . . . . . . . . .   44
                        Installment Loan - Before Final Maturity  . . . . . . . . . .   45
                        Update The File . . . . . . . . . . . . . . . . . . . . . . .   47

            Help Function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .   50
                  Customizing Help Screens  . . . . . . . . . . . . . . . . . . . . .   50

            Menu Operations,  All Systems . . . . . . . . . . . . . . . . . . . . . .   51
                  Using the Menus . . . . . . . . . . . . . . . . . . . . . . . . . .   51
                  Selecting Menu Options  . . . . . . . . . . . . . . . . . . . . . .   51

            Menu  Functions Available . . . . . . . . . . . . . . . . . . . . . . . .   52
                  Menu Structure  . . . . . . . . . . . . . . . . . . . . . . . . . .   52
                        Main Menu . . . . . . . . . . . . . . . . . . . . . . . . . .   52
                        Loan Maintenance Menu . . . . . . . . . . . . . . . . . . . .   53
                        Transaction Maintenance Menu  . . . . . . . . . . . . . . . .   53
                        Loan File Update Menu . . . . . . . . . . . . . . . . . . . .   53

                                                                                         i







                        Printed Reports Menu  . . . . . . . . . . . . . . . . . . . .   53
                        Printed Notices Menu  . . . . . . . . . . . . . . . . . . . .   53
                        Screen Reports Menu . . . . . . . . . . . . . . . . . . . . .   54
                        Year End Processing Menu  . . . . . . . . . . . . . . . . . .   54
                        Utilities Menu  . . . . . . . . . . . . . . . . . . . . . . .   54
                  Menu Hierarchy  . . . . . . . . . . . . . . . . . . . . . . . . . .   54

            Loan Maintenance Menu Functions . . . . . . . . . . . . . . . . . . . . .   56
                  Add an Existing Loan  . . . . . . . . . . . . . . . . . . . . . . .   56
                  Add a New Loan  . . . . . . . . . . . . . . . . . . . . . . . . . .   57
                  Edit (Change) a Loan Record . . . . . . . . . . . . . . . . . . . .   57
                  Delete a Loan Record  . . . . . . . . . . . . . . . . . . . . . . .   57
                  Browse the Master File  . . . . . . . . . . . . . . . . . . . . . .   58
                  Search the Master File  . . . . . . . . . . . . . . . . . . . . . .   58
                  Display Loan Payoff Screen  . . . . . . . . . . . . . . . . . . . .   59

            Transaction Maintenance Functions . . . . . . . . . . . . . . . . . . . .   59
                  Posting Payments  . . . . . . . . . . . . . . . . . . . . . . . . .   59
                  Posting Transactions to User Defined Fields . . . . . . . . . . . .   62
                  Posting Principal Advances  . . . . . . . . . . . . . . . . . . . .   64
                  Reverse a Previous Transaction  . . . . . . . . . . . . . . . . . .   65
                  Browse the Transaction File . . . . . . . . . . . . . . . . . . . .   67
                  Return Check Charge . . . . . . . . . . . . . . . . . . . . . . . .   67
                  Escrow Payments and Disbursements . . . . . . . . . . . . . . . . .   67

            Screen Reports Function . . . . . . . . . . . . . . . . . . . . . . . . .   69
                  Loan Statement (History)  . . . . . . . . . . . . . . . . . . . . .   69

            Utility Menu Functions  . . . . . . . . . . . . . . . . . . . . . . . . .   70
                  Reindex All Files . . . . . . . . . . . . . . . . . . . . . . . . .   70
                  Set Program Options . . . . . . . . . . . . . . . . . . . . . . . .   70
                        Update the Parameter File . . . . . . . . . . . . . . . . . .   70
                        Parameter File Fields . . . . . . . . . . . . . . . . . . . .   71
                              Name of Owner or Servicer . . . . . . . . . . . . . . .   71
                              Line 1 of User Address  . . . . . . . . . . . . . . . .   71
                              Past Due Limit  . . . . . . . . . . . . . . . . . . . .   71
                              Will Be Due Limit . . . . . . . . . . . . . . . . . . .   72
                              Visual Update Flag  . . . . . . . . . . . . . . . . . .   72
                              Date Last File Update . . . . . . . . . . . . . . . . .   72
                              Payment Fraction  . . . . . . . . . . . . . . . . . . .   72
                              Payment Allocation Option . . . . . . . . . . . . . . .   73
                              Detail Accrual File       . . . . . . . . . . . . . . .   74
                              Daily Accrual Totals File . . . . . . . . . . . . . . .   75
                              Four Digit Year . . . . . . . . . . . . . . . . . . . .   75
                        User Defined Parameter Fields . . . . . . . . . . . . . . . .   75
                              Names of User Defined Fields  . . . . . . . . . . . . .   76
                  Custom Help Messages is On/Off  . . . . . . . . . . . . . . . . . .   77
                  Set the Path to the Data Files  . . . . . . . . . . . . . . . . . .   77
                  Clean Up the Data Files . . . . . . . . . . . . . . . . . . . . . .   77
                  Display System Status . . . . . . . . . . . . . . . . . . . . . . .   77
                  WordPerfect Merge File  . . . . . . . . . . . . . . . . . . . . . .   77
                        Merging the Data  . . . . . . . . . . . . . . . . . . . . . .   80

            ii







                        The Filter Expression . . . . . . . . . . . . . . . . . . . .   81
                        The Merge File Structure  . . . . . . . . . . . . . . . . . .   82
                        Using Other Word Processors . . . . . . . . . . . . . . . . .   82

            Report Menu Functions . . . . . . . . . . . . . . . . . . . . . . . . . .   83
                  Print Trial Balance . . . . . . . . . . . . . . . . . . . . . . . .   83
                  Print Past Due Report . . . . . . . . . . . . . . . . . . . . . . .   83
                  Print Past Due Notices  . . . . . . . . . . . . . . . . . . . . . .   83
                  Print Will Be Due Notices . . . . . . . . . . . . . . . . . . . . .   83
                  Individual, Custom Past Due Notices . . . . . . . . . . . . . . . .   83
                  Print Loan Statement  . . . . . . . . . . . . . . . . . . . . . . .   83
                  Print a Custom Report . . . . . . . . . . . . . . . . . . . . . . .   84
                  Print Posting Totals  . . . . . . . . . . . . . . . . . . . . . . .   84
                  Print Transaction Listing . . . . . . . . . . . . . . . . . . . . .   85
                  Print Accrual Report  . . . . . . . . . . . . . . . . . . . . . . .   85
                  Year End Close Out  . . . . . . . . . . . . . . . . . . . . . . . .   85
                  End of Year Interest Statements . . . . . . . . . . . . . . . . . .   86
                  Screen Reports Menu . . . . . . . . . . . . . . . . . . . . . . . .   86
                  The Loan Transaction Statement  . . . . . . . . . . . . . . . . . .   86
                  The Totals Report . . . . . . . . . . . . . . . . . . . . . . . . .   87

            Data Entry Screens  . . . . . . . . . . . . . . . . . . . . . . . . . . .   88
                  Data Entry Cursor Control Keys  . . . . . . . . . . . . . . . . . .   88
                  Date Screen . . . . . . . . . . . . . . . . . . . . . . . . . . . .   91
                  New Loan Screen . . . . . . . . . . . . . . . . . . . . . . . . . .   92
                  User Defined Screen . . . . . . . . . . . . . . . . . . . . . . . .   92
                  Loan Maintenance Screen . . . . . . . . . . . . . . . . . . . . . .   92
                  Add Transaction History Screens . . . . . . . . . . . . . . . . . .   92
                  Browse Screens  . . . . . . . . . . . . . . . . . . . . . . . . . .   94
                  Browse Cursor Control Keys  . . . . . . . . . . . . . . . . . . . .   96

            Visual Update System  . . . . . . . . . . . . . . . . . . . . . . . . . .   98

            Updating the Loan File  . . . . . . . . . . . . . . . . . . . . . . . . .   99
                  Catching Up . . . . . . . . . . . . . . . . . . . . . . . . . . . .   99
                  Posting Payments During the Update  . . . . . . . . . . . . . . . .  100
                  Lying About the Date  . . . . . . . . . . . . . . . . . . . . . . .  100

            Loan Master Reports . . . . . . . . . . . . . . . . . . . . . . . . . . .  100
                  Past Due and Will Be Due  . . . . . . . . . . . . . . . . . . . . .  101
                        Will Be Due Notices   . . . . . . . . . . . . . . . . . . . .  101
                        Abbreviated Billing Notices . . . . . . . . . . . . . . . . .  103
                        Problems with Will Be Due Notices . . . . . . . . . . . . . .  104
                        Past Due Notices  . . . . . . . . . . . . . . . . . . . . . .  104
                        Problems with Past Due Notices  . . . . . . . . . . . . . . .  104
                  Controlling Notices . . . . . . . . . . . . . . . . . . . . . . . .  105
                  Problems with Tutorial Data . . . . . . . . . . . . . . . . . . . .  105

            Problems with Hardware and Software . . . . . . . . . . . . . . . . . . .  105
                  If the Program Crashes on Startup:  . . . . . . . . . . . . . . . .  105
                  Outdated Loan Master Data File  . . . . . . . . . . . . . . . . . .  106
                  DOS Error 4 . . . . . . . . . . . . . . . . . . . . . . . . . . . .  106

                                                                                       iii







                  DOS  Error 2  . . . . . . . . . . . . . . . . . . . . . . . . . . .  107
                  Memory Error Messages . . . . . . . . . . . . . . . . . . . . . . .  107
                        Not Enough Memory to Run Application  . . . . . . . . . . . .  107

            Customer Information System  . . . . . . . . . . . . . . . . . . . .  108

            Customer Information Menu Operations  . . . . . . . . . . . . . . . . . .  109

            Menu Options Available  . . . . . . . . . . . . . . . . . . . . . . . . .  109
                  The Main Menu . . . . . . . . . . . . . . . . . . . . . . . . . . .  109
                  The Utilities Menu  . . . . . . . . . . . . . . . . . . . . . . . .  109
                  The Edit or Delete Menu . . . . . . . . . . . . . . . . . . . . . .  109

            Find a Customer by Number . . . . . . . . . . . . . . . . . . . . . . . .  110

            Find a Customer by Name . . . . . . . . . . . . . . . . . . . . . . . . .  110

            Add a New Customer  . . . . . . . . . . . . . . . . . . . . . . . . . . .  111

            Add a New Address . . . . . . . . . . . . . . . . . . . . . . . . . . . .  113

            Add a New Telephone Number  . . . . . . . . . . . . . . . . . . . . . . .  114

            Show a Customer . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  115

            Delete a Customer . . . . . . . . . . . . . . . . . . . . . . . . . . . .  117

            Edit a Customer . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  117

            Edit a Telephone Number . . . . . . . . . . . . . . . . . . . . . . . . .  119

            Edit an Address . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  120

            Browse Screens  . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  121

            Rebuild the Index Files . . . . . . . . . . . . . . . . . . . . . . . . .  121

            Print Mailing Labels  . . . . . . . . . . . . . . . . . . . . . . . . . .  122

            Report Writer  . . . . . . . . . . . . . . . . . . . . . . . . . . . .  123

            Report Writer Main Menu . . . . . . . . . . . . . . . . . . . . . . . . .  124

            Creating Reports  . . . . . . . . . . . . . . . . . . . . . . . . . . . .  124
                  Data Entry Screen:  . . . . . . . . . . . . . . . . . . . . . . . .  124

            Creating a Label Format . . . . . . . . . . . . . . . . . . . . . . . . .  130

            The label format screen:  . . . . . . . . . . . . . . . . . . . . . . . .  131
                  Width . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  131
                  Height  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  131
                  Across  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  132

            iv







                  Remarks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  132
                  Margin  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  132
                  Lines . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  132

            Printing a Report . . . . . . . . . . . . . . . . . . . . . . . . . . . .  133

            Error Messages While Printing . . . . . . . . . . . . . . . . . . . . . .  133

            Error Example . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  133

            Loan File Data Fields   . . . . . . . . . . . . . . . . . . . . . . .  135

            Customer Information Data Fields  . . . . . . . . . . . . . . . . . . . .  145
                  Customer No . . . . . . . . . . . . . . . . . . . . . . . . . . . .  145
                  Company  Name . . . . . . . . . . . . . . . . . . . . . . . . . . .  145
                  Last Name . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  145
                  First Name  . . . . . . . . . . . . . . . . . . . . . . . . . . . .  146
                  Title of Address  . . . . . . . . . . . . . . . . . . . . . . . . .  146
                  Customer Type . . . . . . . . . . . . . . . . . . . . . . . . . . .  146
                  Address File Data Fields  . . . . . . . . . . . . . . . . . . . . .  146
                  Address Line 1  . . . . . . . . . . . . . . . . . . . . . . . . . .  146
                  Address Line 2  . . . . . . . . . . . . . . . . . . . . . . . . . .  146
                  City  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  146
                  State . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  146
                  Zip . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  146
                  Location  . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  146
                  Address Number  . . . . . . . . . . . . . . . . . . . . . . . . . .  147

            Telephone File Data Fields  . . . . . . . . . . . . . . . . . . . . . . .  147
                  Telephone Number  . . . . . . . . . . . . . . . . . . . . . . . . .  147
                  Extension . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  147
                  Location  . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  147
                  Comment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  147

            Loan  Master  Files . . . . . . . . . . . . . . . . . . . . . . . . . . .  148

            File Specifications . . . . . . . . . . . . . . . . . . . . . . . . . . .  151
                  Field Definitions for LMLOAN.DBF  . . . . . . . . . . . . . . . . .  151
                  Field definitions for LMPARM.DBF  . . . . . . . . . . . . . . . . .  152
                  Field Definitions for LMTRAN.DBF  . . . . . . . . . . . . . . . . .  153
                  Field Definitions for LMTACCR.DBF . . . . . . . . . . . . . . . . .  154
                  Field Definitions for LMACCRUE.DBF  . . . . . . . . . . . . . . . .  155
                  Field Definitions for CICUST.DBF  . . . . . . . . . . . . . . . . .  156
                  Field definitions for CIADDR.DBF  . . . . . . . . . . . . . . . . .  156
                  Field Definitions for CIPHONE.DBF . . . . . . . . . . . . . . . . .  156

            Transaction Codes . . . . . . . . . . . . . . . . . . . . . . . . . . . .  156

            Loan Master Setup Sheets  . . . . . . . . . . . . . . . . . . . . . . . .  161
                  New Loan Setup Sheet  . . . . . . . . . . . . . . . . . . . . . . .  161
                  Loan Maintenance Sheet  . . . . . . . . . . . . . . . . . . . . . .  162
                  User Defined Screen . . . . . . . . . . . . . . . . . . . . . . . .  163

                                                                                         v




























































            vi







            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 agree
            to 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 copies 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.

            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.



            Loan Master, Loan Accounting System                                          1







            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.


                  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, Inc. 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 Inc.



















            2                                          Loan Master, Loan Accounting System







            Introducing Loan Master


            The  Loan Master Loan Accounting system is  a computer program written for the
            IBM PC/XT/AT/PS2 family of small computers and any 100% compatible clone.

            Loan Master is a general loan accounting package. Its design is similar to the
            loan accounting systems used by most banks.  

            The program stores most data about each  loan in a file called the loan master
            file.  The term master file indicates  the file which contains the controlling
            data for the  application.  Data for  all loans is  stored in the same  master
            file.  The  master  file  holds  all  the  data  about  the  loans except  the
            transaction data. Data about  transactions is stored in  a second file  called
            the transaction file.

            For each loan, there is a  borrower. Information about the borrowers is stored
            in a  separate set  of  files and  managed by  a separate  program called  the
            Customer Information File. Refer  to the Customer Information section  of this
            manual for information about maintaining names, addresses, and phone numbers. 

            Loan Master stores information about loans. From this store of information, it
            is  able to  calculate  the interest  for  each loan  as  it  becomes due.  It
            calculates each payment date and  determines if the payment has been  made. If
            the payment has not been made, it marks the  loan as past due. If late charges
            are specified, it assesses the late charge. 

            When interest and  late charges are  paid, it determines  if the amounts  paid
            were less than, equal to, or greater than the amounts due. If the amounts paid
            are greater  of less than the  amounts due, it keeps  up with the  past due or
            prepaid amounts.

            Every day, the program calculates the interest due  on every loan in the file.
            If you prefer not to use the program  on a daily basis, it will catch up. Most
            small  loan companies  update the  files weekly.  Some individuals  update the
            files monthly.  Regardless of the frequency of the updates,  Loan Master works
            on a daily basis and updates every loan one day at a time.

            When a payment  is received, it is posted  by the operator. Loan  Master tells
            the  operator how  much interest,  principal and  late charge  is due.  If the
            operator agrees  with the  allocation suggested  by Loan  Master,  and if  the
            borrower  has paid the  correct amount, the  operator simply presses  a key to
            accept  the  payment.  If the  operator  does  not  agree  with the  suggested
            allocation, it may be changed.









            Loan Master, Loan Accounting System                                          3







            Installation

            Distribution Disks


            Loan Master  consists  of several  programs.  To facilitate  installation  and
            upgrades, each program  is distributed on a separate disk. The complete system
            currently consists of these modules. You may or may not have them all. 


                  Module Name

                  Standard Modules:

                        Loan Master Loan Accounting

                        Customer Information System 

                        Report Writer


                  Optional Modules:

                        Document Tracking System

                        Watch List System

            If you  are upgrading  from a version  prior to  1.23, you  may need the  File
            Conversion Utility. It is not included in this package.
























            4                                          Loan Master, Loan Accounting System







            Automatic Installation

            Each  distribution  disk  includes  a  completely  automatic,    menu  driven,
            installation program.

            Before installing the software, you should create a subdirectory to  hold your
            loan accounting software and loan files. 


            Creating A Subdirectory

            To create a subdirectory on your hard drive C:

                  Enter these commands:

                  CD \(enter)

                  MD C:\LOANS(enter)


            To make this new directory the current directory,

                  Enter this command:

                  CD \LOANS(enter)

            To use the automatic installation system, place the distribution disk in drive
            A:

                  Log on to drive by typing the command:

                  A:(enter)

                  The colon is required.

                  When you see the A prompt, type the command:

                  Menu(enter)

                  and select an appropriate installation action.

                  This  procedure must be repeated  for each disk  you wish to
               install.


            CIF Installation

            The CIF system  disk contains a menu  program to install  the system for  you.
            The CIF  System must be  installed in  the same directory  as the Loan  Master
            System.



            Loan Master, Loan Accounting System                                          5








            Report Writer Installation

            The Report  Writer system disk contains  a menu program to  install the system
            for you.  The Report Writer System must be installed in  the same directory as
            the Loan Master System.


            Installation Notes


            1)    The autoinstall program does not alter or create a  CONFIG.SYS file. YOU
                  MUST HAVE ONE! SEE THE NEXT SECTION.

            2)    Each disk has  its own installation menu to install  the system resident
                  on each disk.

            3)    Each  installation is done to the current subdirectory on the hard disk.
                  You must select this subdirectory before running the installation  menu.
                  This is done with the DOS command:

                              CD \ LOAN  

                  The \ is required. Add one space after "CD", none after "\". The name of
                  the  directory can be any name you  choose. Common names are "LOANS", or
                  "LM".

                  To create a subdirectory. use the DOS command:

                        MD \LOAN

                  This command will  create the directory LOAN. It will  be located in the
                  root directory of your disk.

                  Note that a directory must  be created, MD, before you can change to it,
                  CD.

                  For additional  information on  directories and subdirectories,   please
                  refer to your DOS manual.


            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.







            6                                          Loan Master, Loan Accounting System







            Path to Data Files

            The path statement is not required and is not recommended for anyone below the
            rank of DOS Wizard. The system will work with all files in the same directory.
            It is designed to work that way.  For those who prefer,  the path may be set.

            The loan accounting system must know  where to find its 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.

            If  the path  is used,  a path  statement must  also be  set for  the Customer
            Information system.  For any group of  loans, the loan files  and the customer
            information files must be in the same directory.



            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.



            Automatic Data File Conversion

            As features are added to Loan Master,  it may 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 data
            file, the program, Loan Master, will not run. 

            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  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.

            

            Loan Master, Loan Accounting System                                          7







            The  critical  files  are   LMLOAN.DBF,  LMTRAN.DBF,  LMPARM.DBF,  CICUST.DBF,
            CIADDR.DBF, CIPHONE.DBF, CIPARM.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. (Floppy disk systems are no  longer supported by Bottom
            Line Software, Inc.)

            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 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 upgrade  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.

            

            8                                          Loan Master, Loan Accounting System







            The  critical  files  are   LMLOAN.DBF,  LMTRAN.DBF,  LMPARM.DBF,  CICUST.DBF,
            CIADDR.DBF, CIPHONE.DBF, and CIPARM.DBF.


            It's Installed, What Next?

            After  installation, turn immediately to  Learning  to Use Loan Master on page
            13.


            User Defined Options, the Parameter File


            The  parameter  file stores  information unique  to  each individual  user. It
            stores 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.

            Refer to page  70 for details about setting the user defined parameters.

































            Loan Master, Loan Accounting System                                          9







            Before  Entering Existing Loans


            DO  NOT   ATTEMPT   TO  ENTER   AND    UPDATE  LIVE   DATA   UNTIL  YOU   HAVE
            ENTERED   AND  UPDATED   THE EXAMPLES.     (Page 13 -  Sample  setup   of  new
            loan.)

            After entering  the examples, enter  two or three  live loans and  update them
            past a payment date to check your setup data.

            Do not enter two hundred loans and then discover you did it wrong!

            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" on
            page 99.

            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 or the other 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 first year.


            Conversion Date

            You  must pick  a conversion  date. It  can be  any date  that is  convenient.
            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.

            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 a  loan setup sheet for  each loan. For existing loans,  use the Loan



            10                                         Loan Master, Loan Accounting System







            Maintenance Sheet. For new loans, use the New Loan Setup Sheet.  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 using  either the new loan setup function
            or  the existing  loan  setup function  as  appropriate. These  functions  are
            located on the Loan Maintenance Menu.

            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 to the data entry
            screen. When the screen is 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.  


            Data Entry

            Do not enter partial data for any loan! 

            Dates  are  especially critical.  Missing dates  cause  havoc with  the update
            cycle. The current balance is also critical. The only place the balance can be
            entered is on the setup screen and the setup screen cannot access a previously
            entered loan. If the current balance  is entered incorrectly, the loan must be
            deleted and then re-entered.


            Setting the Update Date in the Parameter File

            When  the data has  been entered, you have  a 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 Utilities Menu, then Set Program Options,
            then Update  the Parameter File. Use  the down arrow  key to step down  to the
            item  labeled "Date  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!


            They are called LMLOAN.DBF and LMTRAN.DBF.


            New Loan?  or  Existing Loan?



            Loan Master, Loan Accounting System                                         11







            When  entering loans into the database, 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 has not come 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.












































            12                                         Loan Master, Loan Accounting System







            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  another 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.


            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 database, 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 you 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 Accounting System                                         13







                  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

             Use a new loan setup sheet and fill it out like  this:

                                       New Loan Setup Sheet

                          Date setup:  01_/01_/88_  Entered by:  Bob________

                  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______                                                 
                                                                                               
                                                                                               
                                                                                               
                                                                                               
                                                                                               
                                                                                               
                 ͼ


            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.





            14                                         Loan Master, Loan Accounting System







            3)    Enter  the new loan data exactly as  shown in the new loan setup example
                  above.

            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 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______                                                 
                                                                                               
                                                                                               
                                                                                               
                                                                                               
                                                                                               
                                                                                               
                 ͼ


            4)    After the data entry is complete, return to the Main Menu.

            5)    From the Main Menu,  select the utilities option. Next select the option
                  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 Accounting System                                         15







                  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 ->                                    
                                                                                               
                 ͼ


                  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


            8)    Exit this screen by pressing PgDn then return back to the Main Menu.

                  From  the Main  Menu,  select the  Loan File  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.



            16                                         Loan Master, Loan Accounting System







                  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  file, the entire
                  file will be skipped and no update will occur.

                  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.

                  You will see  a message  "Validating the Date  File". This procedure  is
                  always performed  before an update.   It is doing data  base maintenance
                  and does not effect the loan data.

                  The next message is  a question "Print daily totals?".  For the purposes
                  of the tutorial, always answer "N".

                  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 PgDn to  start the update. You will see  the visual update screen.
                  It looks like this:











            Loan Master, Loan Accounting System                                         17







                   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  displays the  status of  each field  before and  after the
                  update. Updates are always for one day only.

                  Notice these changes:

                  Item              Changed     Changed
                                    From        to

                  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 day divisor.  The actual amount is
                  13.0685 but all displays are rounded to exact cents. Note  that only the
                  display  is rounded  to exact  cents. The  internal interest  accrual is
                  maintained to four decimal places.

                  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.  (The -31 is  not
                  displayed. Only the current day's -30 will appear on the screen.)




            18                                         Loan Master, Loan Accounting System







                  When days  past due  is negative,  the loan  or the  loan  payment,   is
                  prepaid ( not yet due).

            11)   Press enter to return to the menu (Again, answer "N" to the daily totals
                  question.)  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 PgDn  to start the update.  You will see the  visual update screen
                  again. This time it will look like this:


                   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           Changed
                                    From            To

            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



            Loan Master, Loan Accounting System                                         19







                  your update period. The payment is due tomorrow and the next key pressed
                  will exit the update screen.

            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 PgDn  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                                          
                                                                                                 
                  
                                                                                               

            This time, a payment has matured. There are several  interesting changes. Note
            these:

                  Item              Changed 
                                    From        To

                  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.   
                                                                                  



            20                                         Loan Master, Loan Accounting System







            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, basis = 12, the interest  would have been $397.50.  Remember
            that if the interest basis is 12, the interest is calculated on the  scheduled
            balance, not the current  balance.

            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.


            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, the date will be updated two months.  

            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:





            Loan Master, Loan Accounting System                                         21







            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. 

            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.

            When partial  payments are  made in  amounts less  than the specified  payment
            fraction, the date is not updated. If a borrower pays one fourth of  a payment
            each week for eight weeks, the payment date will not be updated. 

            Changes in the Date Due  For, made necessary by small irregular  payments must
            be made on  the loan maintenance screen.  When changing this date, be  sure to
            keep it on a regularly scheduled payment date.


            13)   Press enter and  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 (and  principal) due does not.
            Note also that the days  past due has changed from zero (due today)  to 1 (due
            yesterday).

            Again  press enter  repeatedly until  the date  last update  is 02-10-88.  the
            update screen will look like this:





















            22                                         Loan Master, Loan Accounting System







                   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 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 the Post a Payment menu selection.

            17)   Enter Customer number 76543 and loan number 3.

                  The posting screen will be displayed:








            Loan Master, Loan Accounting System                                         23







                  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                    
                 ͼ



            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.  





            24                                         Loan Master, Loan Accounting System







            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 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 the  payment is  posted, (accepted),  the loan  look up  screen reappears
            anticipating  another loan look  up to post  another payment.  When you finish
            posting, press the Esc key to exit the loan look up screen.

            18)   Select the Loan  Maintenance Menu function to  edit a loan  record. When
                  asked, Enter the customer number, 76543  and loan number  3, to retrieve
                  our loan record. 





















            Loan Master, Loan Accounting System                                         25







                  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 unpaid            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                1  
                   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.


            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.

                  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.








            26                                         Loan Master, Loan Accounting System







            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 but 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 interest is computed by even months. 

                  The first month's calculations are:

                  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                         35,248.67

                  This is the actual principal balance remaining unpaid.











            Loan Master, Loan Accounting System                                         27







            Interest Accrued                             130.69

                  Interest  accrued,  since  the loan  began,  is  the  present amount  of
                  interest that has been earned by this  loan but which has not been paid.
                  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.  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                            0.00

                  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 above.


            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  without,  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.









            28                                         Loan Master, Loan Accounting System







            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,  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 you 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
            Information System. Refer to that section of the manual and  create a customer
            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 are in  a hurry to see some calculations, just skip the above. You will
            still get notices. They will have the borrower's name but no address. 

            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





            Loan Master, Loan Accounting System                                         29







            An amortization schedule is available.  It is reproduced here.


                   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,  you determine the 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.

            These two lines are represented on the above schedules by the dotted lines.





            30                                         Loan Master, Loan Accounting System







            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

            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



            Loan Master, Loan Accounting System                                         31







            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.

























            32                                         Loan Master, Loan Accounting System







            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 input    _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

            Do  not use the  user defined fields  on the optional user  defined screen, at
            this time. 

            When the maintenance  sheet is complete, select the option  to Add an Existing
            Loan from the Loan Maintenance menu.  Enter the data to the screen exactly  as
            it appears on the maintenance sheet.  

            After the  data is entered, the  User Defined Screen will  be displayed. Since
            this  is an example,  press the Page  Down key  to skip the  user defined data
            entry screen.



            Loan Master, Loan Accounting System                                         33







            When you set up your real loans, you may use the User Defined 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 enclosed. You may reproduce them on any
            copier.

            2)    Return to the Main Menu. Select  the menu option as follows,  Utilities,
                  Set Program Options, Update the Parameter File. Note, this is three menu
                  selections to bring you to the following screen.













            34                                         Loan Master, Loan Accounting System







            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 Loan File Update screen appears:

                  1)    Set the date of update to 09/02/89. This is one day after the next
                        payment is due.

                  2)    Set visual update to "T".

                  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.






            Loan Master, Loan Accounting System                                         35







                   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        
                  
                  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                                          
                                                                                                 
                  






            36                                         Loan Master, Loan Accounting System







            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 containing amounts due will change.

                  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    2,009.01
                  Days Late charge      30           0.00
             

            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.

            Press the  enter  key one  more  time. The  September  second update  will  be
            performed and the menu will return. Return to the Main Menu.




            Loan Master, Loan Accounting System                                         37







            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 database, it will be the only loan on the past due report.

                  Next select  the option Print Notices Menu.  From that menu request past
                  due notices.  When Asked for the  level of detail, select  level 1, full
                  details. 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. Next compare the
                  data on the past due notice to the data on the loan edit screen.

            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:


                  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                    
                 ͼ




            

            38                                         Loan Master, Loan Accounting System







            The top part of this screen reports the current status of the loan.

            PAY 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 with the oldest payments on top, and the most
            recent payments on bottom.  Then update the file a few days at a time, (to the
            date of  the oldest  payment)  Post that  payment 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 pre-
            allocated 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.

            You will be asked if you want a receipt. Be sure the printer is ready and then
            press "Y".

            After the receipt has  been sent to the  printer, (but before it  has finished
            printing) you will be asked, "Eject another page?". If your printer is a laser
            printer the  answer is "N". If  your printer uses continuous  forms paper, the
            answer is probably "Y".

















            Loan Master, Loan Accounting System                                         39







            7)    Select  the posting option  again. This time  the screen will  look 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.
            The  posting screen will force the principal  + interest + late charge amounts
            to remain equal to the total amount received. In  some cases, the total amount
            received will  not agree  with the  amount expected.  Change the  total amount
            received before attempting to change the principal, interest, or late charge.

            If you need a  calculator, press the F-9 key.  Press "Q" or "Esc" to  exit the
            calculator.


            8)    Return again to the Main Menu and update the file  through 09/28/89. The
                  next  payment  is due  on  10/01/89, only  three  days  away. Since  the



            40                                         Loan Master, Loan Accounting System







                  parameter  file specifies  pre-due (billing)  notices for  anything less
                  than or  equal to six  days before maturity,  this loan needs  a billing
                  notice.

            9)    Return again to the Main Menu  and select the Printed Reports Menu. From
                  that  menu,  select the  Print Notices  Menu and  then  the Will  Be Due
                  Notice. When asked, request complete details. 

            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.


            Setting Up Charged Off Loans (Past Maturity)

            Loan Master  was designed to maintain a portfolio of performing  loans. With a
            little understanding,  it can also be  used to maintain charged  off loans. It
            should not be used  to maintain both charged  off and performing loans  in the
            same portfolio.

            Before beginning the following  tutorial, be sure  you have a newly  installed
            copy of  the Loan Master accounting system version 1.50.00 or higher. You must
            also have new, empty,  data files. The distribution diskette(s) include a menu
            driven installation system that will install  new empty data files these files
            for you.

            This tutorial makes three assumptions.

                  1)    You must be familiar with loan accounting.

                  2)    You  have read the manual, especially the part dealing with dates,
                        and you understand what the dates mean and how they are used.

                  3)    You have  already completed the tutorial  demonstrating setting up
                        normal (new and existing) loans.

                  4)    You  now know how  to navigate the  menu system and  enter or edit
                        data.

            In several places this tutorial will tell you to "do this, or do that" without
            telling you how. The how is covered by the above assumptions.










            Loan Master, Loan Accounting System                                         41







            DATES ARE CRUCIAL IN LOAN MASTER. 

            Never  underestimate  the  importance  of   having  your  dates  correct  when
            accounting for loan transactions. Everything is driven by dates.

            The first step is to access the parameter file and set the "Date file updated"
            to correspond to the dates used in the  example. The example date is 02-01-91.
            The parameter screen is shown below. The only thing that is critical for  this
            exercise is the  "Date file update". It must  be set to February 1,  1991. All
            other information may be left as is. 


            If you experiment and update the example loans again, the date in  this screen
            MUST correspond to the date last update in each individual loan record. If you
            update  the  loans past  the  time  covered  by  this example,  05-01-91,  the
            parameter file and the loan file dates will be correctly set by the program. 

            If you reset  the loan records  to their initial  values, you must also  reset
            this parameter screen to its original condition. Initial values means original
            dates AND original numbers (all of them!).

            Initial Parameter Screen for This Example:

                 ͻ
                                                  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 
                   Detail accrual file :  F                      Payment fraction  :    0.9400 
                   Total accrual file  :  F                      Date file update  :02/01/91   
                   Four digit year : F                                                         
                      
                   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    :  Cust No Picture:    -    -           
                   Alpha field 2    : Alpha field 2    :  Loan No Picture:    -    -           
                   Name of user defined screen:                                                
                   <-- Name of User's custom screen here ->                                    
                                                                                               
                 ͼ





            42                                         Loan Master, Loan Accounting System







            Single Payment Loan - Past Maturity

            The  first loan to  be set up  on the Loan  Master system is  a single payment
            loan, interest and principal due at maturity. No payment was ever received.


                  Loan date                     01-01-90
                  Maturity date               01-01-91
                  Date charged off              02-01-91

                  Loan amount                   10,000.00
                  Current Balance               10,000.00
                  Interest due unpaid                  1,300.00


            The  loan is  set up  using the  existing  loan setup  function. The  new loan
            function does not allow the flexibility  necessary to set dates and amounts to
            the required values.

            The set up screen should look like this:


                  LOAN RECORD UPDATE SCREEN ͻ
                                                                                               
                   Customer No.            1                Original Amt.           10,000.00  
                   Loan No.                1                Scheduled Bal.          10,000.00  
                   Cust name.     Single pay past mty       Current Bal.            10,000.00  
                   Comments                                 Accrued Int.             1,300.00  
                                                            Int. due unpaid          1,300.00  
                   Makers/Guarantors ...                    Prin. due unpaid        10,000.00  
                                                            Int. paid YTD                0.00  
                                                            Int. paid life               0.00  
                                                            Late Chg due                 0.00  
                                                            Late Chg YTD                 0.00  
                   Date Note         01/01/90               Late Chg Life                0.00  
                   Date First Pmt    01/01/91               Late Charge Rate           0.0000  
                   Date maturity     01/01/91               Late Charge @ Day               0  
                   Next Pmt Due      01/01/91               Payment Amt Reg         11,200.00  
                   Pmt due for       01/01/91               Payment Amt Lst         11,200.00  
                   Date last mty     01/01/91               Number payments                 1  
                   Last transaction  02/01/91               Final payment no                1  
                   Last update       02/01/91               Payments matured             1.00  
                   Int Rate Orig      12.0000               Payments paid                0.00  
                   Int Rate Cur       12.0000               Payments per yr                 1  
                   Int Comp Basis         365               Days past due                  31  
                   No int. until       /  /                 Gross payoff            11,300.00  
                 ͼ






            Loan Master, Loan Accounting System                                         43








            Installment Loan - Past Maturity

            The next loan loan  to be set up is  an installment loan. It has  passed final
            maturity but has not been paid.

                  Date of loan                        
                                                    01-01-90
                  Date first payment                  
                                                    02-01-91
                  Date Maturity                       
                                                    01-01-91
                  Date next payment due       01-01-91
                  Payment due for             01-01-91
                  Date last maturity                  
                                                    01-01-91
                  Date last transaction               
                                                    02-01-91
                  Date last update            02-01-91

                  Original principal                   1,000.00
                  Remaining balance                200.00
                  Interest due unpaid                     50.00
                  Interest paid YTD                  0.00
                  Interest paid life                     100.00
                  Late charges due                  17.77
                  Late chg paid YTD                  0.00
                  Late chg paid life                       0.00
                  Late charge rate                    .05
                  Late charge @ day                 10.00
                  Payment amount reg                      88.85
                  Payment amt final                 88.85
                  Number of payments                      12.00
                  Number payments paid               8.00
                  Payments per year                  1.00























            44                                         Loan Master, Loan Accounting System








            The setup screen should look like this:

                  LOAN RECORD UPDATE SCREEN ͻ
                                                                                               
                   Customer No.            2                Original Amt.            1,000.00  
                   Loan No.                1                Scheduled Bal.               0.00  
                   Cust name.     Pmt loan past mty         Current Bal.               200.00  
                   Comments                                 Accrued Int.                50.00  
                                                            Int. due unpaid             50.00  
                   Makers/Guarantors ...                    Prin. due unpaid           200.00  
                                                            Int. paid YTD                0.00  
                                                            Int. paid life             100.00  
                                                            Late Chg due                17.77  
                                                            Late Chg YTD                 0.00  
                   Date Note         01/01/90               Late Chg Life                0.00  
                   Date First Pmt    02/01/90               Late Charge Rate           0.0500  
                   Date maturity     01/01/91               Late Charge @ Day              10  
                   Next Pmt Due      01/01/91               Payment Amt Reg             88.85  
                   Pmt due for       01/01/91               Payment Amt Lst             88.85  
                   Date last mty     01/01/91               Number payments                12  
                   Last transaction  02/01/91               Final payment no               12  
                   Last update       02/01/91               Payments matured            12.00  
                   Int Rate Orig      12.0000               Payments paid                8.00  
                   Int Rate Cur       12.0000               Payments per yr                12  
                   Int Comp Basis         365               Days past due                  31  
                   No int. until       /  /                 Gross payoff               267.77  
                 ͼ




            Installment Loan - Before Final Maturity

            The next loan loan to be set up is an installment loan. It has not yet reached
            final maturity but is considered to be uncollectible.

                  Date of loan                  
                                              01-01-90
                  Date first payment            
                                              02-01-90
                  Date Maturity                 
                                              01-01-92
                  Date next payment due   
                                        03-01-91
                  Payment due for         
                                        09-01-90
                  Date last maturity            
                                              02-01-91
                  Date last transaction         
                                              02-01-91
                  Date last update        
                                        02-01-91








            Loan Master, Loan Accounting System                                         45







                  Original principal             1,000.00
                  Scheduled balance          520.00
                  Remaining balance          700.00
                  Accrued interest            36.00
                  Interest due unpaid               30.00
                  Principal due unpaid             180.00
                  Interest paid YTD            0.00
                  Interest paid life                77.00
                  Late charges due            23.00
                  Late chg paid YTD            0.00
                  Late chg paid life                 6.00
                  Late charge rate              .05
                  Late charge @ day           10.00
                  Payment amount reg                47.07
                  Payment amt final           47.07
                  Number of payments                24.00
                  Number payments paid        13.00
                  Payments per year           12.00


            The setup screen should look like this:

                  LOAN RECORD UPDATE SCREEN ͻ
                                                                                               
                   Customer No.            3                Original Amt.            1,000.00  
                   Loan No.                1                Scheduled Bal.             520.00  
                   Cust name.     Pmt loan before mty       Current Bal.               700.00  
                   Comments                                 Accrued Int.                36.00  
                                                            Int. due unpaid             30.00  
                   Makers/Guarantors ...                    Prin. due unpaid           180.00  
                                                            Int. paid YTD                0.00  
                                                            Int. paid life              77.00  
                                                            Late Chg due                23.00  
                                                            Late Chg YTD                 0.00  
                   Date Note         01/01/90               Late Chg Life                6.00  
                   Date First Pmt    02/01/90               Late Charge Rate           0.0500  
                   Date maturity     01/01/92               Late Charge @ Day              10  
                   Next Pmt Due      03/01/91               Payment Amt Reg             47.07  
                   Pmt due for       09/01/90               Payment Amt Lst             47.07  
                   Date last mty     02/01/91               Number payments                24  
                   Last transaction  02/01/91               Final payment no               24  
                   Last update       02/01/91               Payments matured            13.00  
                   Int Rate Orig      12.0000               Payments paid                9.00  
                   Int Rate Cur       12.0000               Payments per yr                12  
                   Int Comp Basis         365               Days past due                 153  
                   No int. until       /  /                 Gross payoff               759.00  
                 ͼ






            46                                         Loan Master, Loan Accounting System







            Update The File

            Return to the main  menu, select the file update option. Verify  that the date
            of last file  update was 01-01-91.  If it was  not, press  escape to exit  the
            update function, return to the utilities  menu and update the date last update
            in the parameter file.

            When you have set the date last file update in the parameter file, request the
            file  update function,  enter the  date of  this update  as 05-01-91.  At your
            option you  may tell the  program to stop  after every loan update  every day.
            This will allow you to inspect the results of each day's  update. It will also
            require you to  press the enter key  267 times to  finish the update. You  may
            speed  up the process by  holding the enter key down  and watching the date of
            update in the upper  left hand corner of the visual update screen. Release the
            enter  key and return  to the single  key press method when  this date reaches
            about 04-10-91.

            After the update, from the  Main Menu, select the Loan File  Maintenance Menu,
            then the loan edit function. You may look up each loan in turn by entering the
            loan and customer numbers. The updated loan screens will look like this:


            Single Pay Loan Past Maturity

                  LOAN RECORD UPDATE SCREEN ͻ
                                                                                               
                   Customer No.            1                Original Amt.           10,000.00  
                   Loan No.                1                Scheduled Bal.          10,000.00  
                   Cust name.     Single pay past mty       Current Bal.            10,000.00  
                   Comments                                 Accrued Int.             1,592.61  
                                                            Int. due unpaid          1,592.61  
                   Makers/Guarantors ...                    Prin. due unpaid        10,000.00  
                                                            Int. paid YTD                0.00  
                                                            Int. paid life               0.00  
                                                            Late Chg due                 0.00  
                                                            Late Chg YTD                 0.00  
                   Date Note         01/01/90               Late Chg Life                0.00  
                   Date First Pmt    01/01/91               Late Charge Rate           0.0000  
                   Date maturity     01/01/91               Late Charge @ Day               0  
                   Next Pmt Due      01/01/91               Payment Amt Reg         11,200.00  
                   Pmt due for       01/01/91               Payment Amt Lst         11,200.00  
                   Date last mty     01/01/91               Number payments                 1  
                   Last transaction  02/01/91               Final payment no                1  
                   Last update       05/01/91               Payments matured             1.00  
                   Int Rate Orig      12.0000               Payments paid                0.00  
                   Int Rate Cur       12.0000               Payments per yr                 1  
                   Int Comp Basis         365               Days past due                 120  
                   No int. until       /  /                 Gross payoff            11,592.61  
                 ͼ




            Loan Master, Loan Accounting System                                         47










            Payment Loan Past Maturity


                  LOAN RECORD UPDATE SCREEN ͻ
                                                                                               
                   Customer No.            2                Original Amt.            1,000.00  
                   Loan No.                1                Scheduled Bal.               0.00  
                   Cust name.     Pmt loan past mty         Current Bal.               200.00  
                   Comments                                 Accrued Int.                55.86  
                                                            Int. due unpaid             55.86  
                   Makers/Guarantors ...                    Prin. due unpaid           200.00  
                                                            Int. paid YTD                0.00  
                                                            Int. paid life             100.00  
                                                            Late Chg due                17.77  
                                                            Late Chg YTD                 0.00  
                   Date Note         01/01/90               Late Chg Life                0.00  
                   Date First Pmt    02/01/90               Late Charge Rate           0.0500  
                   Date maturity     01/01/91               Late Charge @ Day              10  
                   Next Pmt Due      01/01/91               Payment Amt Reg             88.85  
                   Pmt due for       01/01/91               Payment Amt Lst             88.85  
                   Date last mty     01/01/91               Number payments                12  
                   Last transaction  02/01/91               Final payment no               12  
                   Last update       05/01/91               Payments matured            12.00  
                   Int Rate Orig      12.0000               Payments paid                8.00  
                   Int Rate Cur       12.0000               Payments per yr                12  
                   Int Comp Basis         365               Days past due                 120  
                   No int. until       /  /                 Gross payoff               273.63  
                 ͼ



                 Payment Loan Before Maturity


















            48                                         Loan Master, Loan Accounting System







                  LOAN RECORD UPDATE SCREEN ͻ
                                                                                               
                   Customer No.            3                Original Amt.            1,000.00  
                   Loan No.                1                Scheduled Bal.             393.13  
                   Cust name.     Pmt loan before mty       Current Bal.               700.00  
                   Comments                                 Accrued Int.                56.48  
                                                            Int. due unpaid             56.48  
                   Makers/Guarantors ...                    Prin. due unpaid           306.87  
                                                            Int. paid YTD                0.00  
                                                            Int. paid life              77.00  
                                                            Late Chg due                30.05  
                                                            Late Chg YTD                 0.00  
                   Date Note         01/01/90               Late Chg Life                6.00  
                   Date First Pmt    02/01/90               Late Charge Rate           0.0500  
                   Date maturity     01/01/92               Late Charge @ Day              10  
                   Next Pmt Due      06/01/91               Payment Amt Reg             47.07  
                   Pmt due for       09/01/90               Payment Amt Lst             47.07  
                   Date last mty     05/01/91               Number payments                24  
                   Last transaction  04/11/91               Final payment no               24  
                   Last update       05/01/91               Payments matured            16.00  
                   Int Rate Orig      12.0000               Payments paid                9.00  
                   Int Rate Cur       12.0000               Payments per yr                12  
                   Int Comp Basis         365               Days past due                 242  
                   No int. until       /  /                 Gross payoff               786.53  
                 ͼ


            This concludes the tutorial section of the manual. 

            Before setting up a number of real live loans, experiment with one or two real
            loans starting with new blank data files. Remember, the installation disk will
            install new blank data files.





















            Loan Master, Loan Accounting System                                         49







            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.

            ͻ
                                                  LOAN MASTER                                  
                                                  Verify Date                                  
                 ͹
                                                                                               
                                                                                               
                                                                                               
                                                                                               
                                                                                               
                 ɵ Verify System Date ͻ
                                                                                             
                 The loan processing program MUST always know the correct current date. It   
                 uses the current date to compute interest and late charges and to keep up   
                 with the pre-due or past-due status of each loan.                           
                                                                                             
                 The program reads the date from your computer's calendar. If the date is    
                 not correct, you should exit the program and use the DOS command, DATE, to  
                 set the correct date.                                                       
                                                                                             
                 If you do not know how to use the DOS command DATE, please refer to your    
                 DOS manual.                                                                 
                                                                                             
                  Edit text, Ctrl W = Save, Esc = Abort ͼ
                                                                                               
                 ͼ

            To exit a help  screen, press the  Esc key.   In some cases  you will need  to
            press it twice.


            Customizing Help Screens










            50                                         Loan Master, Loan Accounting System







            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.




            Menu Operations,  All Systems

            Loan Master is completely menu operated.  

            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 and some menu selections
            display additional menus called submenus.


            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. If your  machine has
            Windows or OS/2, it will return to your program group or task list.


            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 Accounting System                                         51







            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 (underline or
            otherwise).

            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.


            Menu  Functions Available

            Menu Structure

            Loan Master is  completely menu driven.  All functions are  accessed from  the
            menus. The menus and submenus are:



                        Main Menu
                        1) Loan Maintenance Menu
                        2) Transaction Maintenance Menu
                        3) Loan File Update
                        4) Printed Reports
                        5) Screen Reports
                        6) Year End Processing
                        7) Utilities Menu
                        9) Quit












            52                                         Loan Master, Loan Accounting System







                        Loan Maintenance Menu
                        1) Edit, (Change) A Loan Record
                        2) Add A New Loan
                        3) Add An Existing Loan
                        4) Delete a Loan Record
                        5) Browse The Loan Master File
                        6) Search The Loan Master File
                        7) Display Loan Payoff
                        9) Return To Main Menu


                        Transaction Maintenance Menu
                        1) Post A Payment Transaction
                        2) Post An Advance Transaction
                        3) Reverse a Previous Transaction 
                        4) Browse The Transaction File
                        5) Post User Defined Field 1.    (2)
                        6) Post User Defined Field 2.    (2)
                        7) Post The Penalty Field
                        8) Post Escrow Payments and Disbursements
                        9) Return To The Main Menu


                        Loan File Update Menu
                        1) Update The Master File
                        2) Post A Loan Payment
                        9) Return To The Main Menu

                        Printed Reports Menu
                        1) Print Trial Balance
                        2) Print Past Due Report
                        3) Print Notices Menu
                        4) Print Accrual Report
                        5) Print Posting Totals
                        6) Print Loan Statement
                        7) Print A Custom Report
                        8) Transaction Listing
                        9) Return 


                        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) Custom Will Be Due Notices
                        6) Print Loan Statement
                        9) Return (To printed reports menu)





            Loan Master, Loan Accounting System                                         53







                        Screen Reports Menu
                        1) Loan Statement (Transaction History)
                        2) Totals Report
                        9) Return




                        Year End Processing Menu
                        1) Year End Interest Statements
                        2) Year End Closeout
                        9) Return


                        Utilities Menu
                        1) Set The Program Options
                        2) Reindex All Files
                        3) Clean Up The Data Files
                        4) Display System Status
                        5) Create WordPerfect Merge File
                        6) Add History to Loan Record
                        7) Set or Change System Date
                        9) Return


            Menu Hierarchy

            Some of  the menus display yet  additional menus. The menus  fit together like
            this:


                  Main Menu         Sub Menus

            1)    Loan File Maintenance Menu
                        1) Edit, (change) a Loan Record
                        2) Add a New Loan
                        3) Add an Existing Loan
                        4) Delete a Loan Record
                        5) Browse the Loan Master File
                        6) Search the Loan Master File
                        7) Display Loan Payoff
                        9) Return to Main Menu











            54                                         Loan Master, Loan Accounting System







            2)    Transaction Maintenance Menu
                        1) Post a Payment Transaction
                        2) Post an Advance Transaction
                        3) Reverse a Previous Transaction
                        4) Browse the Transaction File
                        5) Post User Defined Field 1.       (2)
                        6) Post User Defined Field 2.       (2)
                        7) Post the Penalty Field           (2)
                        8) Escrow Payments and Disbursements
                        9) Return to the Main Menu

            3)    Loan File Update
                        1) Update All Loans
                        2) Post a Loan Payment
                        9) Return to The Main Menu

            4)    Printed Reports
                        1) Print Trial Balance
                        2) Print Past Due Report
                        3) Print Notices Menu
                              1) Print Past Due Report
                              2) Print Past Due Notices
                              3) Individual Past Due Notice
                              4) Print Will Be Due Notices
                              5)Custom Will Be Due Notices
                              6) Print Loan Statement
                              9) Return (To Printed Reports Menu)
                        4) Print Accrual Report
                        5) Print Posting Totals
                        6) Print Loan Statement
                        7) Print A Custom Report
                        8) Transaction Listing
                        9) Return

            5)    Screen Reports
                        1) Loan Statement (History)
                        2) Totals Report
                        9) Return to Main Menu

            6)    Year End Processing
                        1) Year End Interest Statements
                        2) Year End Closeout
                        9) Return to Main Menu

            7)    Utilities
                        1) Update the Parameter File
                        2) Customize Help Messages
                        3) Clean Up The Data Files
                        4) Display System Status
                        5) Create WordPerfect Merge File



            Loan Master, Loan Accounting System                                         55







                        6) Add History to Loan Record
                        7) Set or Change System Date
                        9) Return to Main Menu

            9     Quit (Return to DOS)


            Notes On Menu Options


            (2)   These options  access user defined  fields,   and can  be customized  by
                  editing the parameter file. See the section on changing the user defined
                  options.



            Loan Maintenance Menu Functions


            Add an Existing Loan

            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.

            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.

            For detailed  instructions on setting  up an  existing loan, see  the tutorial
            section of the manual titled "Setting up an existing loan" on page 29.










            56                                         Loan Master, Loan Accounting System







            Add a New Loan

            This function is used to add a new  loan to the database. 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  cannot be  used to  add  an existing  loan  to the  database. An
            existing loan is a  loan that has already been  funded and has already  earned
            some interest or possibly had payments made.

            For detailed  instructions on setting  up an existing  loan, see  the tutorial
            section of the manual titled "Setting up a new loan" on page 13.



            Edit (Change) a Loan Record

            This screen displays all the data in the file for any individual loan. You can
            use this screen  to just view the  data on the screen,  or you can change  the
            data if necessary.

            See  the section  on  data entry  screens  for  instructions on  entering  and
            changing data.

            You may not change the customer number or the balance.

            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 is used  to delete a loan from  the file. You should not  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 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 marked to delete. 

            If the loan is not paid off,   you will receive a message warning you the loan
            is still active. You will be asked if you want to delete it anyway. regardless
            of  your answer, you will  be asked again  if you want to  delete the loan, or



            Loan Master, Loan Accounting System                                         57







            cancel the deletion procedure.   If you respond  "C" for cancel, the loan  and
            its transactions will be deleted.


            Browse the Master File

            The browse function allows the loan records to be displayed on the screen in a
            spread sheet  format, one  loan per  line with the  fields listed  in parallel
            columns. The fields may be  edited. Refer to the section on browse screens. It
            is titled "Browse Screens" and is found on page  94.


            Search the Master File

            For normal processing operations, Loan Master expects the operator to know the
            customer and the loan  number of each loan. To  find a loan and display  it on
            the screen, the  operator will enter the customer number  and the loan number.
            These two numbers are used to perform a look up in the master file index. This
            process is  very  quick.  It allows  finding  the last  loan  in a  2000  loan
            portfolio in one to two seconds depending on the speed of the computer.

            Occasionally,  the operator  will  not know  the customer  number or  the loan
            number.  The search  function  allows finding  any  loan in  the  file if  the
            operator  knows either  the customer number,  the loan number  or the customer
            name.


            Loan Search Menu

            The loan search menu displays a screen that looks like this:


                                      Loan Processing
                                  Locate individual loan

                          Ŀ
                                                                             
                                1) Locate loan 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.





            58                                         Loan Master, Loan Accounting System







            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 borrowers name, the loan  will be
            displayed. Upper  and lower case are  ignored. Note that the  name compared is
            the name in the loan file, not the name in the customer file. 

            Loan look up example:

            If you enter the characters "Smith", (without 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. Press PgDn to  step from one loan to the next. You cannot back up. You
            can stop the process by pressing the Esc key.


            Display Loan Payoff Screen

            The  loan payoff screen  displays a limited  selection of data  related to the
            final payment  of  the loan.  All  data needed  to  quote  a final  payoff  is
            included. Data not related to the final payment of the loan is omitted to make
            the screen easier to read.


            Transaction Maintenance Functions

            Functions that are used to process  normal day to day transactions are grouped
            together on the Transaction Maintenance Menu.


            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. 









            Loan Master, Loan Accounting System                                         59







            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 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.


            To Post a Payment:

            1)    Verify the customer  number, loan number and customer name on the screen
                  to be sure you are posting to the correct loan.











            60                                         Loan Master, Loan Accounting System







            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 allocate 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 amount according  to your selection  of
                  several preset  options. (See payment  allocation option on  the Program
                  Options Screen.)

            5)    Read step  2) above. Next, if it is  not correct, 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  highlighting   the  "N"
                  following  "Is  the payment  correct?" and  pressing  the "Y"  key. This
                  action  tells the program to  accept the data as it is presented  on the
                  screen and post the transaction to the loan. The result is immediate.

                  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.






            Loan Master, Loan Accounting System                                         61







                  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 appropriate.

            7)    Enter  the amount of the payment to apply to interest, if any. It is not
                  required to  collect the interest  due. If  you do not,  it will  simply
                  carry forward. It will  not be added to  the interest paid or  paid YTD.
                  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 a  principal  payment is  not  allocated, 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. It is  not necessary
                  to collect the late charge. If  late charges are due, the amount may  be
                  changed back to  0.00 and  the previously allocated  late charge  amount
                  will be reallocated  to interest or principal.  The late charge due  but
                  not  collected will be carried forward to  the next payment. If the late
                  charges are to be forgiven, set the  late charge amount due on the  edit
                  screen to 0.00.

            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.

            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 payment
                  until all payments  are posted. You are not required to post them in any
                  specific order although keeping them in date order is more convenient.

            12)   To QUIT posting,  you may press the ESC key to return to the Transaction
                  Maintenance Menu.


            Posting Transactions to User Defined Fields

            There are two user defined fields. Loan Master calls  them user1 and user2 but
            you may name them anything you like. See the Program Options Menu selection to
            change the names of these fields.










            62                                         Loan Master, Loan Accounting System







            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
            Utilities Menu, Update the Parameter File.

            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, 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 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  be ignored. To exit  the screen
            without saving the transaction, press the Esc key.










            Loan Master, Loan Accounting System                                         63







            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  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.

            If  a principal  advance is  posted on  the 20th,  and the  loan has  not been
            updated since the 10th,  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.
            Press the Esc  key to return to the Main Menu.  Then 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  interest accrual rate 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 interest 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.





            64                                         Loan Master, Loan Accounting System







            Reverse a Previous Transaction

            This function  reverses the  effects of  a previous  transaction. It does  not
            remove the previous  transaction from  the transaction file.  The reversal  is
            accomplished by posting a new transaction equal in size and opposite in effect
            to the original transaction.

            The  first  step in  reversing  a  transaction is  to  identify the  erroneous
            transaction. When the transaction reversal process  is requested,  you will be
            asked to  enter  a  customer  and loan  number.  If  the loan  is  found,  the
            transaction browse  screen will appear.  (See page 94)  From this  screen, you
            will select  the transaction you wish to reverse. This function is intended to
            reverse only payment  transactions. Escrow  transactions are  reversed on  the
            Escrow  Menu. User  defined  transactions are  reversed  on the  user  defined
            transaction screens.






































            Loan Master, Loan Accounting System                                         65







            The transaction reversal screen looks like this:

                 ͻ
                                        Reverse the Selected Transaction                       
                                                                                               
                 ͹
                  Ŀ 
                   This is the transaction you have chosen to reverse:                       
                                                                                             
                   Borrower Name :  Johnson, Sam         12                                  
                      Customer No:    12-0012-12                                             
                          Loan No:          0001                                             
                   
                  Ŀ 
                       Tran       Tran      Late Chg         Interest    Principal           
                       Code       Date          Paid             Paid         Paid           
                                                                                             
                          0   05/01/90          0.00            97.58       215.52           
                   
                                                                                               
                                                                                               
                                                                                               
                                                                                               
                                                                                               
                 ͹
                                                                  Reverse this Transaction  N  
                 ͼ

            This is a display only screen. You cannot change any data on this  screen. The
            only response this  screen will accept is  "Y"es, reverse the  transaction, or
            "N"o, don't reverse it.

            If you respond "Y", the reversal transaction will be posted to the transaction
            file and  the master file will be updated. These  fields in the loan file will
            be modified:

                        cur_bal     
                        prin_due   
                        int_accrd   
                        int_due
                        int_paid
                        int_ytd
                        lc_due
                        lc_paid
                        lc_ytd
                        pmts_paid

            (See page 135 for detailed descriptions of these fields.)





            66                                         Loan Master, Loan Accounting System







            NOTE:

            There  will be  an error  in accrued  interest  due to  the difference  in the
            principal  balance during the time the erroneous transaction was not reversed.
            This error is NOT corrected by the reversal process. For example:

            A transaction for 55.00 principal, and 150.00 interest is posted  to the wrong
            account. Sixty days later, it is reversed. During that sixty days the reported
            current balance  was 55.00 too low. At 10%,  the interest accrued on this loan
            was $0.9041 less than it should have been. The current  reversal function does
            not  correct this  error because  it must  make the  assumption that  no other
            errors occurred and that nothing else changed during that period.



            Browse the Transaction File

            The browse function allows the loan records to be displayed on the screen in a
            spread  sheet format,  one transaction  per  line with  the  fields listed  in
            parallel columns. Refer to the section on browse screens. It is titled "Browse
            Screens" and is found on page  94.

            Return Check Charge

            Many  businesses, lenders  included, assess  a service  charge for  handling a
            returned check. This menu function works  exactly like the user defined fields
            and allows you to record penalties charged for returned checks. 

            If you like,  you can use the Set Program Options  function to change the name
            from returned check charge  to anything you like (up to  18 characters).  This
            option allows you to define a third user defined data field if you give up the
            returned check charge.



            Escrow Payments and Disbursements

            The  Escrow Payments and  Disbursements option  displays a  menu of   possible
            escrow related options.

            1)    Post an Escrow Deposit
            2)    Reverse an Escrow Deposit
            3)    Post an Escrow Disbursement
            4)    Reverse an Escrow Disbursement


            The  escrow posting screen allows only the entry of the date and the amount of
            the  transaction.  Transaction codes  are assigned  by  the program.  When the
            cursor rests on the "N" pressing a "Y" will accept the transaction. The Escape




            Loan Master, Loan Accounting System                                         67







            key will  return to the prior  menu without saving the  transaction. Any other
            key will remain in the edit mode.



            ͻ
                                             Post an Escrow deposit                            
                        Cust:   12-0012-12  Loan:         0001  Johnson, Sam         12        
                 ͹
                                                                                               
                              Date of last update               :        01/15/91              
                              Current loan balance              :        9,703.40              
                              Current Escrow Balance            :            0.00              
                              Escrow payment amount due         :            0.00              
                                                                                               
                                                                                               
                              Loan payment due for (date)       :        01/19/91              
                                                                                               
                                                                                               
                              Enter the date of the transaction :        10/27/92              
                              Enter the Escrow deposit amount   :            0.00              
                                                                                               
                                                                                               
                                                                                               
                                                                                               
                                                                                N              
                                                                                               
                 ͹
                                      Esc = abort   PgDn = save   F1 = help                    
                 ͼ

            The escrow payment screens are all very similar so only one will be shown.





















            68                                         Loan Master, Loan Accounting System







            Screen Reports Function

            Loan Statement (History)

            This function displays all transactions stored in the transaction file for the
            requested  loan. The display looks  somewhat like an  amortization schedule or
            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 in  order by date  for the loan  you requested.
            This may cause a delay  from one to several seconds depending on  the speed of
            your machine.

            When the screen is  full, approximately twelve transactions, the  display will
            stop and wait for you to view the screen. To  display additional transactions,
            if there are any,  press the return key.

            Pressing  the return key does  two things. It  backs up   two transactions and
            then  displays twelve  more. This  is done  to give  some continuity  from one
            screen to the next.
































            Loan Master, Loan Accounting System                                         69







            Utility Menu Functions


            Reindex All Files

            Occasionally  it is good  practice to build  new index files.  Index files may
            become damaged  through interrupted or incomplete  operations, power failures,
            turning off the computer, etc.

            The most common symptom of  a damaged index file is that you will  not be able
            to get addresses  on your notices. Other symptoms include  inability to find a
            loan you know exists, or asking for a loan by number and getting a loan with a
            different number.

            If you  experience any such symptoms, select the utility option to reindex all
            files.


            Set Program Options

            This function allows the user to modify some Loan Master features. 


            Update the Parameter File

            Updating the parameter  file is done with a  data entry screen. It  works just
            like the other data entry screens. See page 88 for details of data entry.


























            70                                         Loan Master, Loan Accounting System







            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 118826                 Pre due notice at day  :    6 
                   Address     : Carrollton,TX 75011-8826        Pmt allocation option  :    4 
                   Address     :                                 Visual update on       :    T 
                   Detail Accrual file : F                       Payment fraction  :    0.9400 
                   Total Accrual file  : F                       Date file update  :  02/05/91 
                   Four Digit year : F                                                         
                      
                   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 ->                                    
                                                                                               
                 ͼ



            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 Owner or Servicer                                        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



            Loan Master, Loan Accounting System                                         71







            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.


            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 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.











            72                                         Loan Master, Loan Accounting System







            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 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.

            Note:

            Most payment allocation options work properly only if the interest computation
            basis = 360 or 365. They do not work as stated if interest basis = 12.

            See options 4 and 5 for loans with interest basis = 12.

            The payment allocation options are:


            Option            Description:

            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. Interest basis must  be 360 of  365. Does not
                              work for interest basis 12.

            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.
                              Interest  basis  must  be 360  of  365.  Does  not work  for
                              interest basis 12.


            2                 Assume the normal payment amount is received. If the payment
                              is early,  compute interest due  as of  the regular  payment



            Loan Master, Loan Accounting System                                         73







                              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. Does not work for interest basis = 12.

            3                 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, collect it.Interest  basis must be 360 of  365. Does
                              not work for interest basis 12.

            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, and
                              basis  =  360 or  365,  take interest  due  as  of the  next
                              scheduled payment date. Collect  any late charges due. Apply
                              the remainder if any to the principal. 

                              This option works for interest basis 12.


            5                 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, and
                              basis =  360  or 365,  take  interest  due as  of  the  next
                              scheduled payment date. Do not collect any late charges due.
                              Apply the remainder if any to the principal. 

                              This option works for interest basis 12.


            Detail Accrual File

            If this option is set to true "T", the program will record all accrual details
            for every loan, every day.

            Every day,  for each  loan in the  master file,  the program  will record  the
            dollar amount of the  daily accrual and the  dollar amount of any late  charge
            accrual. 

            The entries for each day are added to the  file. No data is ever deleted. This
            file  is used  by  users for  creating  detailed accrual  reports for  accrual
            accounting. The name of the file is lmaccrue.dbf.

            This file quickly grows very large. Do not turn it on unless you use it. 






            74                                         Loan Master, Loan Accounting System







            Daily Accrual Totals File

            If this  option is set to  true "T", the  program will record the  daily total
            accrual figures for interest and late charges accrued to a disk file. The name
            of the file is lmtaccr.dbf.

            This file  store daily totals. One  daily total each day  for interest accrual
            and late charge accrual. 

            The entries for each day are added to the  file. No data is ever deleted. This
            file  is used  by  users for  creating  detailed accrual  reports for  accrual
            accounting. The name of the file is lmaccrue.dbf.

            This file slowly grows very large. Do not turn it on unless you use it. 


            Four Digit Year

            If this field is set to True, "T", all data entry fields requesting dates will
            require the entry of a four digit year. eg.

            06-15-2001

            Loan Master now assumes  that any two digit year  less than 50 is in  the next
            century. If you enter a two digit year of 12, eg 07-01-12, Loan Master assumes
            this is July  first, 2012.  If you want  to be  certain you can  see all  four
            digits by setting this option to "T".



            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 through 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. The report
            writer can  perform calculations on the  contents of these  fields and display
            the results on a report.






            Loan Master, Loan Accounting System                                         75







            Names of User Defined Fields

            Loan Master  allows users  a certain  amount of  flexibility to customize  the
            program  for individual  needs. This  functionality is  optional. You  are not
            required to use  these fields in any manner.  If  you do use them, nothing you
            place in them will have any effect on any built in Loan Master function.

            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 date 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

            Names of the two user defined alpha fields

            NAMEUSRSCR 

            Name of the data entry screen which updates the user defined fields





            76                                         Loan Master, Loan Accounting System







            Custom Help Messages is On/Off 

            When custom help messages  is turned on, the user is allowed  to edit the help
            screens.


            Set the Path to the Data Files

            See page 7 for a discussion of data paths.


            Clean Up the Data Files

            This  function creates a new data file  from the existing data file. It copies
            all records that have not been  marked to delete. It checks loan  and customer
            numbers to  see that they have  been properly justified. It  deletes any loans
            that are blank or otherwise invalid. It will not delete a loan with a balance.

            This function  should be used daily  by new users.   After becoming proficient
            with  the program, it should  be run weekly. For users  who update only once a
            month, monthly is adequate.



            Display System Status

            The system status screen  displays information about the current  condition of
            the system. The following items may indicate problems:

            If the number of file handles less than six or eight, the program is in danger
            of crashing if the user attempts anything more than simple data lookups.

            If  the KB Memory  free is less  than 50 (thousand  bytes), the program  is in
            danger of crashing with a memory error.

            If  memory is a problem,  you must free  up memory in your  lower 640K region.
            This is  a DOS problem,  not a Loan Master  Problem. If your  machine has less
            than 640 K, additional memory will help. Otherwise, reconfiguration is needed.

            Instructions on reconfiguring DOS are not with in the scope of this manual.



            WordPerfect Merge File

            Loan Master will create a text file containing most of  the information stored
            in its  data files in a  WordPerfect merge file format.  WordPerfect can merge
            the information  from this file into  its document files. This  feature may be
            used  for personalized form letters,  custom notices, special  reports, or any
            other function supported by WordPerfect.



            Loan Master, Loan Accounting System                                         77







            To create the merge file, select utilities from the main menu, then select the
            merge file option from the utilities  menu. The process will take from several
            seconds to  several minutes depending on  the size of your  loan portfolio and
            the speed of your computer.

            The  merge  file will  be  created  in the  Loan  Master  directory and  named
            LMLOAN.WPM.   It will  be almost as large  as all your  Loan Master data files
            combined. Remember to delete it when you are finished with it.

            Each time you create a  merge file, the old file, if you have  not deleted it,
            will be replaced  by the new file. The contents of  the old file will be lost.
            If you  want to keep  the old file,   be sure to  copy it to  another location
            before creating a new one.

            This  manual will not  attempt to teach  you how to use  the WordPerfect merge
            feature. This feature is very powerful and flexible. It can be as simple or as
            complicated as you want. Refer to the WordPerfect manual for details.

            WordPerfect, during a  merge operation, identifies the data it will merge into
            its  document file  by  records and  fields. Fields  are  identified by  field
            numbers.  In  the merge  file, each  loan occupies  one  record. Each  item of
            information for each loan occupies one field within that record.

            The merge  file contains one  record for  each loan. Each  record contains  53
            fields or items of information about one loan.

            The Field Numbers and Their Contents Are:

            WordPerfect       Loan Master Description of Data
            Merge Field       Field Name

            Data from the Loan Master Loan Edit Screens:
            {FIELD}1~               cust_no     Customer number
            {FIELD}2~               loan_no     Loan Number
            {FIELD}3~               cust_name   Customer name
            {FIELD}4~               maker1      Maker 1
            {FIELD}5~               maker2      Maker 2
            {FIELD}6~               maker3      Maker 3
            {FIELD}7~               maker4      Maker 4
            {FIELD}8~               comment1    First comment line
            {FIELD}9~               comment2    Second comment line

            Data from the User Defined Screen:
            {FIELD}10~        alpha1      First user alpha field
            {FIELD}11~        alpha2      Second user alpha field

            Data from the Customer Information System:






            78                                         Loan Master, Loan Accounting System







            {FIELD}12~        custname    Customer company name
            {FIELD}13~        lastname    Customer last name
            {FIELD}14~        firstname   Customer first name
            {FIELD}15~        minitial    Customer middle initial
            {FIELD}16~        title Title of address
            {FIELD}17~        taxpayer    Tax payer or SS No
            {FIELD}18~        addrsline1  Line one of address
            {FIELD}19~        addrsline2  Line two of address
            {FIELD}20~        city  City
            {FIELD}21~        state State
            {FIELD}22~        postalcode  Zip code
            {FIELD}23~        telephone   Telephone number (1)
            {FIELD}24~        phoneext    Telephone extension (1)
            {FIELD}25~        location    Telephone location comment (1)
            {FIELD}26~        comment     Telephone comment       (1)

            Numeric Data from the Loan File:
            {FIELD}27~        org_amt     Original amount
            {FIELD}28               cur_bal     Current Balance
            {FIELD}29               pmt_amt_rg  Regularly scheduled payment amount
            {FIELD}30~        pmt_amt_fn  Final scheduled payment amount
            {FIELD}31~        rate_cur    Current interest rate
            {FIELD}32~        n0_pmts     Number of payments required
            {FIELD}33~        int_accrd   Interest accrued and unpaid (2)
            {FIELD}34~        int_due     Interest due and unpaid       (2)
            {FIELD}35~        int_ytd     Interest paid year to date
            {FIELD}36~        prin_due    Principal due and unpaid     (2)
            {FIELD}37~        lc_due      Late charge due and unpaid (2)
            {FIELD}38~        lc_ytd      Late charges paid year to date
            {FIELD}39~        penalty     User defined penalty paid
            {FIELD}40~        penaltyytd  User defined penalty paid ytd
            {FIELD}41~        user1 User defined field number 1
            {FIELD}42~        user1ytd    User field one, year to date
            {FIELD}43~        user2 User defined field number 2
            {FIELD}44~        user2 YTD   User field one ytd
            {FIELD}45~        numeric1    User numeric storage number 1
            {FIELD}46~        numeric2    User numeric storage number 2
            {FIELD}47~        numeric3    User numeric storage number 3
            {FIELD}48~        numeric4    User numeric storage number 4
            {FIELD}49~        numeric5    User numeric storage number 5
            {FIELD}50~        numeric6    User numeric storage number 6
            {FIELD}51~        (computed)  Loan payoff = 
                                    current balance  + 
                                    interest accrued + 
                                    late charges due
            {FIELD}52~        (computed)  Days past due = 
                                    Date last update -
                                    Date due for





            Loan Master, Loan Accounting System                                         79







            Date Data From the Loan File:
            {FIELD}53~        date_note   Original contract date
            {FIELD}54~        date_first  Date first scheduled payment
            {FIELD}55~        date_noint  No interest until this date
            {FIELD}56~        date_next   Next scheduled payment date
            {FIELD}57~        date_due    Scheduled date of next payment to be received.
                                          (Do not make assumptions about this date. If you
                                          are not sure what it means, see the field
                                          definitions section of the manual.)
            {FIELD}58~        date_upd    This loan has been updated only through this
                                          date. If this date is not today, the data is not
                                          current.


            (1)   The Customer  Information System allows unlimited  telephone numbers for
                  each borrower.  The  WordPerfect  merge system  does  not  support  this
                  feature. Only the  first telephone number  will be placed  in the  merge
                  file.

            (2)   The merge file will contain the information currently stored in the loan
                  file. If the file has not been updated, the  data in the merge file will
                  not be current.


            Merging the Data

            To accomplish the merge in WordPerfect (5.1 DOS):

                  Press Ctrl-F9 (Merge/Sort)

                  Select 1 (Merge)

                  Primary file:(enter your file name)

                  Secondary file: lmloan.wpm


            You will see a WordPerfect screen that looks like this:

                  Merge: DOS Text File

                  1 - Field Delimiters    - Begin
                                    - End       ,

                  2 - Record Delimiters   - Begin
                                    - End       [CR]

                  Selection: 0





            80                                         Loan Master, Loan Accounting System







            You must modify this screen to look like the following example.

            This  operation  is  a  little  tricky,  but  may  be  accomplished  by  these
            keystrokes:

            F ; Down ; Enter ; Down ; R ; Down ; Ctrl-L ; Down ; F7

            Press the keys  between the semicolons. Do not enter  the semicolons. The [LF]
            code  is  generated by  the  Enter  key. The  [FF]  Code is  generated  by the
            Control+L key.


                  Merge: DOS Text File

                  1 - Field Delimiters    - Begin
                                    - End       [LF]

                  2 - Record Delimiters   - Begin
                                    - End       [FF]


                  Selection: 0



            The Filter Expression

            A filter expression allows the selection of a subset of all loans to be placed
            in the merge file. For example:

                  All loans with balances greater than $5,000.00.

                  All loans originated after June 30, 1991

                  All loans with user defined field 4 set to 99.

                  All loans more than 9 days past due.

            Loan Master filter expressions must conform to the rules allowed by DBASE III.
            For  complete details,  refer  to a  DBASE  III programming  manual.  Many are
            available at any book store.

            Comparisons may be made on any Loan Master field, whether or not it is located
            in the merge file. Merge file fields are listed above. See  the manual section
            on data field specifications for other fields available.

            Example Filter Expressions:

            All loans with balance greater than 10,000.00




            Loan Master, Loan Accounting System                                         81







                  cur_bal > 10000
                  (Do not use "$" or commas in numbers.)

            All loans with user numeric field 4 = 99

                  numeric4 = 99

            All loans past due

                  date_upd - date_due > 0

            All loans 10 days or more past due

                  date_upd - date_due > 9


            You  may  use multiple  comparisons  by following  DBASE  III rules.  Only one
            example  will be given. See a DBASE III  book for more detail. Read about "SET
            FILTER" and about "Logical Operators" or "Boolean Operators".

            Select all loans with balances greater than 10,000.00 and greater than 10 days
            past due.

                  (date_upd - date_due > 0) .and. (cur_bal > 10000)

            The  "."s are  required.  The "()"  are  not always  required  but are  always
            recommended. They break the comparison up in to logical pieces.


            The Merge File Structure
            Using Other Word Processors

            The merge file is an ASCII text file.  Fields are delimited by Carriage Return
            + Line Feed. The decimal ASCII codes for these characters are 13, and 10.

            The records are separated by Form Feed characters, decimal ASCII code 12.

            You  may look  at this  file with the  DOS 5  Edit program  or with  any other
            program that  will not change its ASCII nature. Most word processors will read
            and display the file  but will modify its  content when  it is saved. If  you
          use a word processor to look at it, do not modify it or save it.












            82                                         Loan Master, Loan Accounting System







            Report Menu Functions


            All   printed reports are selected from  this menu.  Some  of the options from
            this menu display  menus of additional reports.


            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
            or for quick look ups when the computer is off, etc. 

            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.   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.


            Individual, 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




            Loan Master, Loan Accounting System                                         83







            This function prints a statement listing the transactions for a single loan or
            a range of loans selected by the operator.

            Statements may include all transactions in the  file or a starting date may be
            specified.  Leaving the  starting  date blank,  will  result in  printing  all
            transactions in the file.

            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.

            When  the statement  is printed,  the computed  balance is  compared with  the
            stored balance.  If these balances do not agree, an error message is displayed
            on the screen and a warning is printed on the statement.


            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.

            These files  may be created with Dbase III or any compatible database manager.
            They may also be created with the Report Writer by Bottom Line Software, Inc.


            Print Posting Totals

            The  posting  totals report  lists all  interest,  principal, and  late charge
            transactions posted for  a range  of dates.  Before printing  the report,  the
            operation will enter a starting and ending date. These dates are inclusive.









            84                                         Loan Master, Loan Accounting System







            Print the posting totals for the month of August:

                  Beginning date    =  08-01-91

                  Ending date             =  08-31-91



            Print the posting totals for August tenth.

                  Beginning date    = 08-10-91

                  Ending date       = 08-10-91


            Note  that separate details  and separate totals  are listed  for positive and
            negative transactions.  A principal payment  transaction for $100.00  would be
            listed as +100.00. A principal payment reversal for $100.00 would be listed as
            -100.00.


            Print Transaction Listing

            The Transaction Listing report lists all transactions in the transaction file.
            It orders the transactions  by customer, then by loan, then  by date. For each
            customer,  it gives a complete  historyof all transactions  posted with annual
            totals.


            Print Accrual Report

            The accrual  report will list  the interest and  late charges accrued  for any
            period of time. This report uses the accrual files mentioned in the section on
            the parameter file, see page 74 for information about the accrual files.


            Year End Close Out

            BACK UP YOUR MASTER FILE BEFORE USING THIS FUNCTION

            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, late charges paid year to date,  and all the user
            defined YTD fields 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.  



            Loan Master, Loan Accounting System                                         85








            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.

            This statement may include or exclude the user defined YTD fields. This is the
            only  report on which  they are available.  To save them for  the file history
            without sending them to the borrower, print two reports, one with and one with
            out the user defined fields.  Keep a copy of both. If you have many borrowers,
            someone  will call and ask for another copy.  If you have only the report with
            the user defined fields, you will not be able to make a copy without them.



            Screen Reports Menu

            If a permanent paper record is not needed, it is convenient to display reports
            on the screen. Loan Master provides two on screen reports. 

            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.





            86                                         Loan Master, Loan Accounting System







            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.
            eg. The total of the fields storing the original interest rate would not  be a
            meaningful total, so it is not calculated.












































            Loan Master, Loan Accounting System                                         87







            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 a  prompt 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 the data 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 it is  correct. You  will use  the cursor  control keys  to
            control the movement of  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.





            88                                         Loan Master, Loan Accounting System








                                 DATA ENTRY CURSOR CONTROL KEYS


            ^ Indicates the Control key labeled  Ctrl. Thus ^LeftArrow means hold down the
            control key while pressing the Left Arrow 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.

            ^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




            Loan Master, Loan Accounting System                                         89







                              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.













































            90                                         Loan Master, Loan Accounting System







            Date Screen

            This screen is the  first data entry screen you  see  when the program starts.
            This screen  is first  because the  date is  critical in  calculating interest
            accruals and in determining past due and maturity status.


            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:

                  The system date is            04/04/89

            It then reads the date the file was last updated and tells you that date.

                  The last file 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. 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.

            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.






            Loan Master, Loan Accounting System                                         91







            New Loan Screen

            This screen is 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. The 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. 

            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.

            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. The  up arrow  has the
            opposite effect.

            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.


            Add Transaction History Screens

            Loan Master  catigorizes all loans into two classes, new and existing. When an
            existing loan  is entered  into the  system, the operator  enters the  current
            balance and the system continues with  the system from the setup date forward,
            but no historical information is stored.





            92                                         Loan Master, Loan Accounting System







            The  Add  History  function allows  going  back  and  entering the  historical
            information for a loan which was  originally set up as an existing  loan. This
            function is not needed for a loan which was set up as a new loan.

            The  Add History  funcfion  uses  the  transaction  browse  screen  to  accept
            transactions  from the operator.  Refer to page  94 for details  of the browse
            screens.

            Adding   history  is  a  serious  business.  It  totally  replaces  all  prior
            information about this loan. 
               
            The first transaction must  be a setup  transaction. The setup transaction  is
            the original  balance of the loan. It's transaction code  is 11. See page  156
            for a list of Loan Master transaction codes.

            It  is  not  necessary  to enter  the  interest  rate  when  entering histtory
            transactions. If the loan has an  adjustable rate, this feature will provide a
            convient way of recording the change dates.

            After the new  history is entered,  press Esc to exit  the browse screen.  The
            next screen  will show you  the results  of the history  information you  have
            entered. The New history column shows the currrent status of the loan based on
            the new  history you have  entered. The right  column shows the status  of the
            loan before you entered the new history.

            If the new history produced the results desired, select the option to save the
            new  history  and  modify  the  master file.  Both  the  master  file  and the
            transaction  file will  be changed to  reflect the  new transactions  you have
            entered.  NOTE: The old information is REPLACED with the new history and is no
            longer available. It cannot be retrieved. 

            If the  new information did  not produce the  results desired, you  may either
            revise it, or delete it. If you delete it, it is gone and the original file is
            not changed. If you revise  it, you will be offered the opportunity to save it
            when the revisions are completed.


















            Loan Master, Loan Accounting System                                         93







                 ͻ
                                                                                               
                                                                                               
                 ͹
                                                                                               
                                         ----- Loan Status By -----                            
                                         New History    Master File                            
                     Current Balance           9703.40       9703.40                           
                     Interest paid             2123.33       1115.60                           
                     Interest YTD                82.97         82.78                           
                     late Charge Paid            15.00          0.00                           
                     late Charge YTD              0.00          0.00                           
                                                                                               
                                                                                               
                               Ŀ             
                                   1)  Save New History and Modify Master File.              
                                   2)  Revise New History.                                   
                                   3)  Abandon New History and Exit...                       
                                            
                                                                                               
                                                                                               
                                                                                               
                 ͹
                              Old data will be replaced. It cannot be recovered.               
                 ͼ

            Browse Screens

            The browse screen options allow you to browse  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.


            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       
                                                                                          
                                                                                          
                        ; 





            94                                         Loan Master, Loan Accounting System







            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.

            To edit a field on the browse screen, highlight it and press the Enter key.
            The cursor will appear in the highlighted area and the data may be changed.
            Pressing the Enter key again turns off the cursor and accepts the changes. The
            browse screens do not work like the data entry screens. Please read the
            section on Browse Cursor Control Keys 







































            Loan Master, Loan Accounting System                                         95








                                    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.

            ^
             CtrlUp     Not used.

            ^
             CtrlDn     Not used.

            ^ 
            CtrlRight   Scroll the entire database one column to the left. (Moves the
                        cursor to the right)

            ^
             CtrlLeft   Scroll the entire database one column to the right. (Moves the
                        cursor to the left)

            PgDn  Move down one page (further into the database).

            PgUp  Move up one page (back towards the top of the database).

            ^PgUp Move to the top, first record in the database.

            ^PgDn Move to the bottom, last record of the database.

            End   Move to the right most column on the screen.

            Home  Move to the left most column on the screen.





            96                                         Loan Master, Loan Accounting System







            ^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 Accounting System                                         97







            Visual Update System


            Computers usually do things in the dark. We can't see what is going on and we
            wonder about the results.

            Loan Master has a visual update system that,  if turned on,  continually
            displays information about the update procedures 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.

            To use this system you must turn it on.  Turning on the visual update screens
            is done through updating the parameter file. Set the visual update field to
            "T", (true).

            The visual update system may be 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. It is seldom
            advantageous, speedwise, to turn off the visual update system on any computer
            faster than an 8088.

            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.













            98                                         Loan Master, Loan Accounting System







            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 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.

            Loan Master knows that you are not going to come to the office and run the
            computer every day to update your loan file.  It must be able to keep up with
            the days you miss and "catch up".


            Verify Date Screen 

            In the parameter file,  the program stores the date of last file update.  When
            the Loan Master program starts, the first thing it does is read the system
            clock and the parameter file and display the current system date and the date
            of last file update. The program MUST know the date of the current update. If
            your system clock is not correct, or if you are updating for a date in the
            past, you must enter the correct current date when this screen is displayed.


            Updating the Loan File

            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  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 example is a new 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 Accounting System                                         99







            This loan will be entered into the data file. Its date last update will be set
            to March 1. 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 During the Update

            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 About the Date

            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 request 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 Reports

            The loan accounting system produces these reports:


                        Trial Balance Reports

                        Past Due Loans Reports




            100                                        Loan Master, Loan Accounting System







                        Past Due Notices

                        Past Due Notices Custom

                        Will Be Due Notice (Billing Statement)

                        Loan Transaction Statement

                        Year End Interest Statement



            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 in 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 

            Always update the loan file before printing 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.











            Loan Master, Loan Accounting System                                        101







            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 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.





















            102                                        Loan Master, Loan Accounting System







            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.

            Abbreviated Billing Notices

            Both past and will be due notices are available in an abbreviated format in
            which only the payment amount is printed.



















            Loan Master, Loan Accounting 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 notices.

            The will be due notice bills the customer for the amount needed to bring the
            note current, not just the amount of the regularly scheduled payment.



            Past Due Notices

            The past due notice is easier to understand then the will be due notice.  It
            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 data field 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.


            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 printed.

            The days past due is defined by the program as the number of days between the
            date of the oldest payment missed and the system date entered when the program
            started.



            104                                        Loan Master, Loan Accounting System







            It is important to update the file before printing past due notices. If past
            due notices are printed from an old master file, it is possible for performing
            loans to get past due notices.

            Controlling Notices

            The mail code is found on the user defined screen. This code may be used to
            control the printing of notices. The mail codes defined and their meanings
            are:

                  Mail        Meaning
                  Code

                  0           No restrictions. Print any notice that is due.

                  1           Print will be due notices. Do not print Past due notices

                  2           Print past due notices. Do not print will be due notices.

                  3           Print no notices.



            Problems with Tutorial 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.

            Problems with Hardware and Software

            The Loan Master Loan Accounting System is a very large and complex system. It
            was designed to duplicate the functions of a bank data processing service
            bureau on a personal computer. It occasionally strains the capability of the
            machine.


            If the Program Crashes on Startup:

            CONFIG.SYS File

            With all modules installed, the Loan Master loan accounting system uses as
            many as fifty different data files. As many as twenty may be open all at the
            same time.  




            Loan Master, Loan Accounting System                                        105







            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 default DOS configuration will result in the system crashing every time
            you try to run it. You will receive a message about the config.sys file, then
            the program will return to DOS.

            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)".

                                     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 30 or greater. 

            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,  you must create it.



            Outdated Loan Master Data File

            The program will fail to execute if data file conversion is required but has
            not been done. A message will be printed instructing the use of the conversion
            program.


            DOS Error 4

            DOS error 4 indicates that the operating system, DOS, has used all the files
            it is authorized to use and has been instructed to open yet another file. It
            cannot do so.





            106                                        Loan Master, Loan Accounting System







            To correct this error, it is necessary to increase the number of files
            authorized in the CONFIG.SYS file, and to set an environment variable. See
            CONFIG.SYS File (Page105)

            Increase the number of files in the files statement of the CONFIG.SYS by at
            least 5. If there is no files statement in the CONFIG.SYS file set it to at
            least 30. examples:

                  files=20          This is not enough. Change it to at least 30.

                  files=30          Minimum for Loan Master.

                  files=60          If you are on a network, files should be at least 50,
                                    in some cases 90 or more.


            Both the CONFIG.SYS file and the AUTOEXEC.BAT file are found in the root
            directory of your hard disk. If you are using a floppy system, they are in the
            root directory of the boot disk.


            DOS  Error 2

            DOS error 2 Indicates that the program cannot find the loan and customer data
            files. These files, and the parameter files,  must be in the startup
            directory. The startup directory is the directory where the LMMENU.EXE and
            CIMENU.EXE files are located.

            The location of these files can be changed using the path option on the  User
            Options Menu.


            Memory Error Messages

            Not Enough Memory to Run Application

            This is a DOS error message. It means the available base memory on your
            machine is not large enough to allow the program to start. Loan Master will
            usually run on a 512K machine using DOS 3.x or DOS 5.x if there is no
            terminate and stay resident software such as network drivers, calculators,
            Sidekick, etc. If the machine has DOS 4.0 or 4.01, a 512K machine will need
            the DOS to be specially configured for Maximum program memory and minimum
            operating system functionality. This configuration is done by the DOS 4.x
            installation program. Configuring DOS is beyond the scope of this manual.









            Loan Master, Loan Accounting System                                        107







            Customer Information System



            The Customer Information System stores and retrieves information about your
            customers, name, address, phone number, etc.















































            108                                        Loan Master, Loan Accounting System







            Customer Information Menu Operations


            A menu is a list of tasks, or functions the program can perform.  Entering a
            new customer, is a menu function.  Since one menu cannot display all the
            possible functions the system can perform, related tasks are listed together
            on menus.


            Menu Options Available

            The Main Menu

            The main menu offers these options:

                  1)    Find a Customer by Number.
                  2)    Find a Customer by Name.
                  3)    Show a Customer.          
                  4)    Add a New Customer.
                  5)    Add a New Address.   
                  6)    Add a New Phone Number.
                  7)    Utilities Menu.
                  8)    Edit or Delete Customers.
                  9)    Quit.

            The Utilities Menu

            The Utilities Menu offers these options:

                  1)    Print Mailing Labels.   
                  2)    Rebuild All Indexes.
                  3)    Custom Help Screens Are Off.  (On)
                  4)    Browse the Customer File.
                  5)    Browse the Address File.
                  6)    Browse the Phone File.
                  7)    Edit the Parameter File.
                  9)    Return to Prior Menu.


            The Edit or Delete Menu

            The Edit or Delete Menu offers these options:

                  1)    Delete a Customer.   
                  2)    Delete an Address.
                  3)    Delete a Phone Number.
                  4)    Edit  a Customer.
                  5)    Edit an Address.
                  6)    Edit a Phone Number.
                  9)    Return to Prior Menu.



            Loan Master, Loan Accounting System                                        109










            Find a Customer by Number

            The quickest way to locate a customer and display the related data on the
            screen is to use the locate by number function.  When this function is chosen,
            you will be asked to enter the customer number. When you have entered the
            number, press the return key.

            The computer will search the data file for a customer record with the number
            you entered. If it is found, it will immediately be displayed on the screen. 
            The cursor will be on the customer name field and will be waiting for you to
            edit (change) the record.

            You may edit the record, or simply view it.


            Find a Customer by Name

            If you select the option to find and edit a customer by name. You will be
            asked to enter the customer's name. The search method used is very broad. If
            the name or characters you enter appear anywhere in the name field, the record
            will be displayed. Upper and lower case are ignored.

            The name look up function will display a screen that looks like this:

                                      Last name    
                                      First name   


            Customer Look Up Example:

            You may enter either the last name, the first name, or both names.  If you
            enter only the last name, the computer will locate and display all customers
            with that last name. A partial match will work too.  If the customer's last
            name is Smithfield and you remember the "field" but are not suer if it is
            "Smithfield", "Smythefield", or "Greenfield", just enter the "field" and you
            will find them all.

            If you enter the characters "Smith", (With out the quotes),
            the search will find all of the following customers:

                              Smith, Jack
                              SMITH, JACK
                              smith, jack
                              Smithfield, Susan
                              William T. Smith
                              James R. Goldsmith




            110                                        Loan Master, Loan Accounting System







            The first name search works exactly the same way.


            Using Both Names

            When you know who you are looking for, enter both names.  If both names are
            used, the search will require a match for both the first and last names.

            If you enter "Smith" in the last name field and "Bob" in the first name field,
            (Without the quotes).

            The computer will find the following names:

                              Smith, Bob
                              SMITH, BOB
                              smith, bob
                              Smith, Bobby
                              Smithfield, Bobby

            It will not find:

                              Smith, Jack
                              Smythe, Jack
                              Smythe, Bob


            The search begins at the beginning of the file and continues through the file
            one record at a time. As each match is found, the customer will be displayed
            on the screen and you will be asked if this is the customer 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 customers that match.

            When you respond "Y", this is the customer you want, the program will continue
            with the requested operation, using the customer you just selected. If you
            told it to delete a customer it will display it, you tell it to quit searching
            and then it will ask if you want to delete it, you can answer yes or no.

            This is a search function. It searches the entire file. It is noticeably
            slower than using the customer number which goes directly to that customer.



            Add a New Customer

            You will first be asked for a customer number. Each customer must have a
            unique identifying number. The number may have from 1 to 12 characters and
            numbers need not be assigned in any order.




            Loan Master, Loan Accounting System                                        111







            When you enter the number for the new customer, the computer will look to see
            if there is already a customer in the file using that number.  If there is, it
            will be displayed and you will be asked if you want to edit this address or if
            you want to assign a new number.


                  The Screen will look like this:

                            ͻ
                                                                                    
                                     Customer number    23435                       
                                     Customer name      Bob T Smith                 
                                     Customer type      1                           
                                                                                    
                                                                                    
                                     Address line 1     66445 Camp Bowie Blvd       
                                     Address line 2     Suite 7777                  
                                                                                    
                                               City     Fort Worth                  
                                              State     Tx                          
                                                Zip     12345-1234                  
                                         Address no     2                           
                                    Ŀ         
                                        1)  Assign new number.                    
                            ͵    2)  Edit this address.           ͼ
                                                                          
                                     



            Sometimes you will simply forget and try to set up the same customer twice. 
            If this happens, you will see a screen with the existing customer data, not a
            blank screen. In this case, simply return to the Main Menu by selecting option
            1. If you like, you can change  the address before you return to the menu.

            If this is NOT the customer you want, you have a decision to make.  You are
            attempting to assign the same number to two different customers.  This is not
            allowed.  You must assign a different number to one or the other of these
            customers.


            If you want to assign a different number to the new customer,  select the
            assign new number option.  You will be returned to the main menu where you can
            select the add new customer function and assign another customer number.









            112                                        Loan Master, Loan Accounting System







            In most cases, you will select an acceptable number for the customer and will
            see a screen that looks like this:


                 ͻ
                                                                              
                           Customer number                           
                              Company name          
                                 Last name          
                                First name                
                            Middle Initial                                   
                          Title of Address                             
                             Customer type                                  
                            Address line 1               
                            Address line 2               
                                      City                 
                                     State                                  
                               Postal Code                        
                                Address no                                  
                           Telephone / Ext   /  Ext          
                                  Location                       
                                                                              
                 ͼ




            Add a New Address

            CIF will store multiple addresses for any customer. The address you enter when
            the customer record is created is the first and main address. Other addresses
            may be stored if needed.

            To add an address, select the appropriate menu selection from the main menu.
            You will be asked to identify the customer for which the address will be
            added. When asked, enter the customer number. If you do not know the customer
            number, you may use the function to find the customer by name and note the
            customer number from the screen.















            Loan Master, Loan Accounting System                                        113







            When the customer has been selected, the screen for adding addresses will be
            displayed, it looks like this:


                          ͻ
                                                                                     
                                                                                      
                                                                                      
                                         Customer No:          333                    
                                        Company name: S&S Southland Stores            
                                       Customer name:                                 
                                 Williford S. Southerland Esquire                     
                                                                                      
                                    Address line 1     
                                    Address line 2                                   
                                              City                                   
                                             State                                   
                                       Postal Code                                   
                                      Address no                                      
                                                                                      
                          ͼ 



            The name of the customer will be displayed at the top of the screen with a
            blank data entry form at the bottom of the screen ready to receive a new
            address. See page 88, Data Entry Screens for details of the data entry
            process.

            Enter the customer name and address information. You can use the arrow keys to
            move from one field to the next and back.  Refer to the section on Data Entry
            Cursor Control Keys (page 88), for details on data entry and editing.



            Add a New Telephone Number

            CIF will store multiple telephone numbers for any customer. The phone number
            you enter when the customer record is created is the first and main phone
            number. Other telephone numbers may be stored if needed.

            To add a telephone number, select the appropriate menu selection from the Main
            Menu. You will be asked to identify the customer for which the telephone
            number will be added. When asked, enter the customer number. If you do not
            know the customer number, you may use the function to find the customer by
            name and note the customer number from the screen.







            114                                        Loan Master, Loan Accounting System







            When the customer has been selected, the screen for adding telephone numbers
            will be displayed, it looks like this:




                        ͻ
                                   Custfile Custno  :          333                      
                                         Customer No:          333                      
                                        Company name: S&S Southerland Stores            
                                       Customer name:                                   
                                 Williford S. Southerland Esquire                       
                                                                                        
                                     Telephone number:                      
                                     Extension number:                                  
                                   Telephone location:                                  
                                             Comment :                                  
                                                                                        
                        ͼ


            The name of the customer will be displayed at the top of the screen with a
            blank data entry form at the bottom of the screen ready to receive a new
            address. See page 88, Data Entry Screens for details of the data entry
            process.

            Enter the customer name and address information.


            Show a Customer

            To see an overview of a customer's locations and phone numbers, select this
            function. The screen will ask for the customer number and will display up to
            three addresses and five telephone numbers for the requested customer. This
            display is for information only. You cannot edit the data.


















            Loan Master, Loan Accounting System                                        115







            The show screen looks like this:

                 Customer...ͻ  Phone, ( Main office) Ŀ
                  Cust no: 333                Type   2  333-333-0001-1111  Pres. Direct line 
                  S&S Southerland Stores                
                 ͼ  Phone, ( Main office ) Ŀ
                  Address, ( Main     ) Ŀ 333-333-0002-0002  Personnel Dept    
                  <-- addressline1 333----------->      
                  <-- addressline2 333----------->       Phone, ( Warehouse ) Ŀ
                  <-- city line    333----------->      333-333-0004-                        
                  <-- State line   333----------->      
                                                         Phone, ( Shipping  ) Ŀ
                  333-333-0003                         
                  Address, ( Warehouse ) Ŀ 
                  address line 1                         Phone, ( Acct/Pay  ) Ŀ
                  address 2                             333-333-0005                         
                  city, state  zip                      
                                                                                               
                                                                                               
                                                         
                  Address, ( Vail Condo ) Ŀ                                        
                  address line 1                                                               
                  address line 2                                                               
                  Vail                                                                         
                  CO 88888-8888                                            Return ?  N         
                                                                                               
                                                         


            The only response to this screen is Yes, return. When you press the "Y" key
            the screen will return to the menu.






















            116                                        Loan Master, Loan Accounting System







            Delete a Customer

            To delete a customer record,  you will be asked to identify the customer
            first.  When the computer identifies a match, you will be asked if this is the
            customer you want to delete.  The screen will look like this:


            ͻ
                                                                                               
                                                                                               
                 ͹
                        ͻ      
                                                                                             
                                                                                             
                                                                                             
                                         Customer No:   12-0012-12                           
                                        Company name: Sam's Company                          
                                       Customer name:                                        
                                    Address line 1  address line 1                           
                                    Address line 2  address 2 0001                           
                                                                                             
                                              City  Cith 0001                                
                                             State  St 0001                                  
                                       Postal Code      zip 0001                             
                                        Address no  0                                        
                                                                                             
                                                                                             
                        Delete this customer ? Nͼ      
                                                                                               
                 ͹
                                                                                               
                 ͼ


            If this is not the customer you want to delete, Press the "N" key to return to
            the menu.

            If You want to delete this customer, press the Y key. Any other key will
            return you to the menu without deleting the record.


            Edit a Customer

            Edit means to change. The editing process requires first that a data record to
            be displayed. The operator is then offered an opportunity to modify the data.
            After the data is modified, the changes may be saved (stored to the disk file)
            or discarded. If the changes are discarded, the permanent data on the disk is
            not changed.





            Loan Master, Loan Accounting System                                        117







            You will first be asked for a customer number. Each customer must have a
            unique identifying number. 

            When you enter the  customer number, the computer will look to see if there is
            a customer in the file using that number.  If there is, it will be displayed
            and you will be allowed to edit the data. If the record is not found, you will
            receive a message telling you the record was not found.


            The Edit screen will look like this:

                 ͻ
                                          CUSTOMER INFORMATION SYSTEM                          
                                                  Edit Screen                                  
                 ͹
                                                                                               
                                    Customer number           333                              
                                      Company  name   <- Name of customer 333>                 
                                          Last name   <-Last name of customer 333 ->           
                                         First name   < First 333>                             
                                   Title of address   MRSZ                                     
                                      Customer type   88                                       
                                     Address line 1   <-- addressline  333-1 -------->         
                                     Address line 2   <-- addressline2 333-1 -------->         
                                               City   <-- city line    333-1 -------->         
                                              State   <-- State line   333-1 -------->         
                                        Postal Code   333-11111101                             
                                         Address no    1                                       
                                    Telephone / ext   333-333-0001 Ext 1111                    
                                           Location   333loc_1                                 
                                                                                               
                                                                                               
                 ͹
                          Esc = exit, don't save changes.   PgDn = exit, save changes.         
                 ͼ



            The address and phone numbers displayed will be the primary address and 
            telephone numbers. These are the first address and telephone numbers, those
            that were entered when the customer record was created.

            You may also edit other address and telephone numbers. See the separate
            sections for those functions.

            While the edit screen is displayed, the operator may change any data except
            the customer number. Customer numbers may not be changed. When it is necessary
            to change a customer number,  the record must be deleted.





            118                                        Loan Master, Loan Accounting System







            To keep the same customer data and assign a new number, delete the old record,
            exit the program, restart the program, then create a new record with the new
            number. 



            Edit a Telephone Number

            You will be asked for a customer number. When you enter the customer number,
            the computer will look to see if there is a customer in the file using that
            number.  If there is, it will be displayed and you will be allowed to edit the
            data. If the record is not found, you will receive a message telling you the
            record was not found.

            The telephone edit screen looks like this:

                 ͻ
                                                                                               
                                                                                               
                 ͹
                                                                                               
                                                                                               
                                                                                               
                                    custfile custno  :          333                            
                                          Customer No:          333                            
                                         Company name: <- Name of customer 333>                
                                        Customer name:                                         
                                  < First 333>S<-Last name of customer 333 ->                  
                                                                                               
                                      Telephone number:  333-333-0001                          
                                      Extension number:  1111                                  
                                    Telephone location:  location 1                            
                                              Comment :  phone comment    1                    
                                                                                               
                                                                                               
                                                                                               
                                                                                               
                                                                                               
                 ͹
                          Esc = exit, don't save changes.   PgDn = exit, save changes.         
                 ͼ


            On this screen, only the telephone data may be edited. The customer
            information is displayed only for identification.

            Editing additional telephone numbers is also accomplished on this screen. When
            PgDn or Esc is pressed, the program will search for additional telephone
            numbers for this customer. If they are found, they will be displayed
            sequentially, one at time, and you will be allowed to edit them.



            Loan Master, Loan Accounting System                                        119









            Edit an Address


            You will first be asked for a customer number. When you enter the number for
            the customer, the computer will look to see if there is a customer in the file
            using that number.  If there is, it will be displayed and you will be allowed
            to edit the data. If the record is not found, you will receive a message
            telling you the record was not found.

            The address edit screen looks like this:


                 ͻ
                                          CUSTOMER INFORMATION SYSTEM                          
                                                  Edit Screen                                  
                 ͹
                                                                                               
                                    Customer number           333                              
                                      Company  name   <- Name of customer 333>                 
                                          Last name   <-Last name of customer 333 ->           
                                         First name   < First 333>                             
                                   Title of address   MRSZ                                     
                                      Customer type   88                                       
                                     Address line 1   <---- address line 1 33303-----"         
                                     Address line 2   address 2 333                            
                                               City   <-------  city 333-3----->               
                                              State   <---- State 333-3 ------->               
                                        Postal Code     99999-9999                             
                                         Address no    3                                       
                                    Telephone / ext   333-333-0001 Ext 1111                    
                                           Location   333loc_4                                 
                                                                                               
                                                                                               
                 ͹
                          Esc = exit, don't save changes.   PgDn = exit, save changes.         
                 ͼ



            On this screen, only the address data may be edited. The customer information
            is displayed only for identification.

            Editing additional addresses is accomplished on this screen. When PgDn or Esc
            is pressed, the program will search for additional addresses for this
            customer. If they are found, they will be displayed sequentially, one at time,
            and you will be allowed to edit them.





            120                                        Loan Master, Loan Accounting System







            Browse Screens

            The browse screen options allow you to browse  the customer 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.

            This browse screen uses the real field names from the data files. These names
            are somewhat more cryptic than the data input screen prompts but they are
            readable. They are listed in the section on the data files. See Data File
            Specifications for details of the field names.

            The browse screen looks like this:

                      ͸
                                                                    Record 21 of 136    
                                                                                        
                         CUST_NO   CUST_NAME            LASTNAME         FIRST NAME     
                      ͵ 
                                                                                         
                              33   Smith Construction   Smith            Jack            
                              22   Jones Welding        Jones            Robert          
                              22   Acme Office Supplies Billings         Sue             
                                                                                         
                                                                                         
                      ; 


            The record contains many more fields than can be displayed on the screen on a
            single line. To accomplish the goal of one record 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.

            See the section on Browse Screen Cursor Control Keys, (Page 96 ) 



            Rebuild the Index Files

            The CIF system maintains several different data files. The customer
            information file, the address file and the telephone file. Each file has an
            associated file called an index file. The index file makes finding data much
            faster. The index files work just like the index of a book. They tell the
            program where to look to find the data it needs. 

            See the section on rebuilding index files on page 70.






            Loan Master, Loan Accounting System                                        121







            Print Mailing Labels

            When the mailing labels selection is requested, the label menu will be
            displayed. The mailing label menu offers these options:


                        1)    Sort by zip code.
                        2)    Sort by last name.
                        3)    Sort by company name.
                        4)    Sort by customer number.

            The labels are printed on standard one up mailing label stock. They will be
            sorted in the order requested.








































            122                                        Loan Master, Loan Accounting System







            Report Writer

            The Bottom Line Software Report Writer allows the user to design and print
            custom reports from the databases created by Loan Master.

            The user can select information from the Loan Master loan accounting database,
            the Customer Information database, or any of the report files created by Loan
            Master. This information can be printed in a standard data processing style
            report with the data printed in columns. You specify the content and the
            heading of each column.

            You may total any or all columns, and may also specify subtotals within any
            column report.

            You may specify a column header of up to four lines of text.

            You may insert or delete columns at any time.

            You may also specify a page header to be printed on each page of the report.


































            Loan Master, Loan Accounting System                                        123







            Report Writer Main Menu

            The main menu is a bar type menu across the top of the screen, it looks like
            this:


            Report           Label       Quit


            When this menu is displayed, the word Report will be highlighted. 

            Pressing the "R" key or pressing the return key while the word "Report" is
            highlighted will select the Report option. This option allows you to create a
            disk file that specifies the format and content of a printed report.

            Pressing the "L" key allows you to create a disk file which contains data to
            specify the format and content of a label. This option can also be selected by
            pressing the right arrow key to highlight the word "Label". When "Label" is
            highlighted, press the <enter> key to select the Label option. The label
            function is used to create mailing labels. These labels may be designed in any
            format. This label function is not the same as the label report in the
            Customer Information System.

            Pressing the "Q" key, or using the left or right arrow keys to highlight the
            word "Quit" will return you to the DOS prompt.

            Creating Reports
            Data Entry Screen:
            The standard report is formatted like this:

            Page No.    1
                 06-10-90
                 Report title line one
                 Report title line two
                 Report title line three

                 Column 1                  Column 2                 Column 3                  Column 4
                 header can                Header can               Header can                Header can
                 be up to                  be up to                 be up to                  be up to
                 four lines                four lines               four lines                four lines

                 Column 1 data             Column 2 data    Column 3 data    Column 4 data
                 Column 1 data             Column 2 data    column 3 data    Column 4 data
                 Column 1 data             Column 2 data    Column 3 data    Column 4 data

                 Group heading
                 Group total 1             Group total 2    Group total 3    Group total 4


                 Report total 1            Report total 2   Report total 3   Report total 4

                 

            124                                        Loan Master, Loan Accounting System









            1)    To create a custom report,  you must first have a general idea of how
                  you want the report to look. Until you become comfortable with designing
                  reports, you should sketch the report with a  pencil before attempting
                  to use Report Writer.  

            2)    First list the columns (data fields) you want on the report. Next place
                  them in order from left to right.  Now decide which columns you want
                  totaled.

            3)    Report Writer must know the actual field names of the fields it will
                  print on the report. The actual field name is not the name by which the
                  field is labeled on the screen. See page 135 for the names of all
                  available data fields.

                  Look up these field names and pencil them in on your  draft copy so you
                  won't have to look them up later while you are entering the report
                  format.


            4)    Do you want totals or subtotals? A total is printed at the bottom of the
                  report, it is the sum of all the data in the report column above the
                  total. Totals are always printed below their respective columns.

                  Subtotals are the sum of only part of a column of data. Subtotals are
                  printed in their respective columns and are labeled as subtotals. You
                  specify the exact wording of the label. In the sample report above, the
                  line labeled "Customer total" reports the total interest due from each
                  customer. This line is printed each time the customer number changes.

                  List the columns you want totalled. List the columns you want
                  subtotalled

                  List the column (one only) which will control the printing of the
                  subtotals. A subtotal will be printed each time the value of the data in
                  this column changes.

            5)    Start the program by typing the command RW at the DOS prompt. When the
                  main menu is displayed, select the report options by pressing the "R"
                  key.












            Loan Master, Loan Accounting System                                        125







                  After specifying a file name, you will see the Field Definition Screen.
                  It will look like this:


                 F1               F2               F3               F4               F5               F6               F7
                          F10
                 ...              Layout   Groups  Fields   Delete  Insert   Go To   Exit

                                                                                                               File 
                 MYREPORT.FRM
                                                                                                               Field 1
                                                   Field definitions                                  Total 1

                 Contents         
                                                                               
                                                                               
                 Headings                                                      
                          1       
                          2       
                          3       
                          4       

                 Formatting
                 Width     
                 Decimals  
                 Totals     


                  In the contents field, type the name of the field you want printed in
                  this column of the report. In this case, since this is the first column
                  we have created, this would be the first (left hand) column of the
                  report.

                  In the headings field(s) type the column header you want printed on the
                  report above this column. If you type a column header 30 characters in
                  width over a one character column, that column will take up 30
                  characters on the report. You should attempt to make column headers as
                  narrow as possible.

                  In the width field, enter the maximum width of this column. If you are
                  displaying a 12 digit number or a 12 character name, don't forget to add
                  a couple (at least one) of columns for spacing and enter 13 or 14 in the
                  width field.

                  In the decimal field, enter the number of decimal places to display. If
                  more decimal places are stored, the field will be rounded to the number
                  of decimal places entered here.

                  In the Totals field enter either "Y" or "N". "Y" means total this
                  column. "N" means do not total this column.



            126                                        Loan Master, Loan Accounting System








                  For the sample report above, this screen would like this:

                 F1       F2               F3               F4               F5               F6               F7
                 F10
                 ...      Layout  Groups   Fields  Delete   Insert  Go To    Exit

                                                                             File MYREPORT.FRM
                                                                                                               Field 1
                                                   Field definitions                                  Total 1

                 Contents  CUST_NO
                                                                               
                                                                               
                 Headings                                                      
                          1    Customer
                                                                                   
                          2    Number
                                                                                   
                          3    
                                                                                   
                          4    
                                                                                   

                 Formatting
                 Width     15
                 Decimals  0
                 Totals     N


            6)    When you enter the "N" in the Totals field, the field number in the
                  upper right corner of the screen will change to 2. This means you are
                  now entering the second field on your report. This field will be printed
                  in the second column. The Total counter will also say 2. This means
                  there are now two fields (or columns).

                  You can also proceed to the next field, or column by pressing the Page
                  Down key.

            7)    Continue in this manner until all your columns are entered. Note that
                  the Total indicator in the upper right corner of the screen tells you
                  the total columns entered.

            8)    Do not specify more columns that you printer or your paper can accept.


            Specifying Groups and Sub Groups
            (Subtotals and Sub Subtotals)

            A custom report can total any numeric field and report the total of all data
            in that field at the bottom of the report. Additional flexibility is provided
            by the ability to further divide the report into groups and subgroups.





            Loan Master, Loan Accounting System                                        127







            A group occurs when the value in one specific field changes. The field can
            contain either numeric or alphabetic data. For example:

             You want a report of total sales by state and within each state you want the
            total for each office and each salesperson. The report might look like this:


                          State            Office  Sales            Sales
                                                   Person

                          New Sales Person
                          Tenn             169     101              1234.55
                          Tenn             169     101              1234.55
                          *Sub subtotal*                            2469.10

                          New Sales Person
                          Tenn             169     102              2234.55
                          Tenn             169     102              2222.22
                          *Sub subtotal*                            4456.77

                          *Subtotal*                                6925.87


                          New Office
                          New Sales Person
                          Tenn             170     110              1111.11


            Note that you may have only two levels of subtotals. You have requested a
            subtotal each time the sales person changes and each time the office number
            changes. You will not be able to  have a total each time the state changes.






















            128                                        Loan Master, Loan Accounting System







            To specify groups and sub groups, press the F3 key. You will see this screen:

                 F1       F2               F3               F4               F5               F6               F7
                 F10
                 ...      Layout  ...      Fields  ...      ...     ...      Exit

                                                                                 File TEST.FRM
                                               Group Specification

                 Group On Expression         officecode
                 Group Heading               New Office
                                             
                 Summary Report Only         
                 Page Eject After Group      
                                             
                                              Sub - Group Specifications
                                             
                 Sub-Group On Expression     personcode
                 Sub-Group Heading           New Sales Person



            The " ... "s indicate those keys are not active and cannot be selected.


            The fields labeled "Group on Expression" and "Sub-Group On Expression" will
            contain the field names of the fields on which the data is to be grouped or
            sub grouped. In the example above the field which contains the office code is
            named officecode. The field which contains the code for the salesperson is
            called personcode.

            The fields labeled Group Heading and Sub group heading will contain the
            headings for the groups and subgroups. These headings are printed above each
            respective group or subgroup.

            Specifying the report page format

            To specify how the report will be placed on the page, press the F2 key to
            select the Layout function.  This key will display the Page Header screen. It
            looks like this:













            Loan Master, Loan Accounting System                                        129







                 F1               F2               F3               F4               F5               F6               F7
                          F10
                 ...      ...    Groups    Fields  ...      ...     ...                       Exit

                                                                             File TEST.FRM
                                               Page Header

                       1  
                       2  
                       3  
                       4  


                                                                    Formatting
                                                               Page Width        80
                                                               Left Margin        8
                                                               Right Margin       0
                                                               Lines Per Page    58
                                                               Double Space?      N

                                                               Printer Directives
                                                           Page Eject Before Print   Y
                                                           Page Eject After Print    N
                                                           Plain Page                N



            The formatting and printer directives allow you to specify how the report will
            be oriented on the page and whether or not the printer will eject a blank page
            before printing  and eject the  final page  after printing, or  both. You  may
            specify the  maximum width of the  report and the left  margin. Specifying the
            left margin is handy when the report prints too close to the left edge  of the
            paper.

            Plain  Page specifies no date  or page number  is to be printed  at the top of
            each page of the report. This should normally be set to "N".

            The  Page Header is a  four line header  that will be printed  at the top left
            corner of each page of the report. This header can be used to title the report
            and perhaps to identify the source and destination of the report.


            Creating a Label Format

            REPORT WRITER   allows the  creation of  mailing labels. These  labels may  be
            created  from any file containing  name and address  information. Label format
            files  may be  created for  almost any style  labels. Labels  may be  large or
            small, one, two, or three across the page.





            130                                        Loan Master, Loan Accounting System







            When you  select the Label  option from the  main menu, you  will be  asked to
            enter  a file  name.  This file  will  be  used by  REPORT  WRITER to    store
            information to  specify the format and  content of a label.  You must remember
            this file name to print the labels so use a name that is meaningful to you.


            The label format screen:

            Immediately after  selecting a file  or entering  a new file  name, the  label
            formatting screen will be displayed. 


                 F1                        F2                       F3
                          F10
                 ...              Toggle   Formats                                                             Exit
                 
                                                                             File  MYLABEL.LBL

                 Dimensions                                         Formatting
                          Width   40                                Margin    6
                          Height  5                                Lines     1
                          Across  1                                Spaces    

                          Remarks
                                

                          CONTENTS
                 
                 Line 1  
                 Line 2
                 Line 3
                 Line 4
                 Line 5


            Width

            The  width is the width of each  individual label measured in characters. This
            means the actual  size of the characters you intend to  print. If a label is 4
            inches wide, its width would be 40 if you are printing  10 characters per inch
            but it would be 48 if you are printing at 12 characters per inch.


            Height

            The height is the height of the label  in lines of print. Most labels are  one
            inch  tall.  A one  inch label  can contain  six lines  of normal  print. Most
            printers can be  set to print more  than six lines  in one inch if  necessary.
            Normally a  one inch  label will have  a height  of six  or less. The  example
            screen shows a height of five.  This means that only five lines of  print will
            be printed on each label even though they would hold as much as six lines.



            Loan Master, Loan Accounting System                                        131







            This label might look like this:

                        Bob Copperfield
                        Copperfield Kitchen Pots
                        123456  77th Avenue
                        P.O. Box 98765
                        Copperville, Utah  77777-7777


            Across

            Continuous  form  labels are  available in  many  different sizes  and several
            different formats.   They are available  with one, two,  three or four  labels
            side by side on the backing  paper. This field allows you to specify  how many
            labels are across the page.


            Remarks

            This field is simply a comment to yourself. It will not be printed.

            Margin

            The margin allows you  to specify a left margin. This feature  is used to move
            the printed area on the label to the right  to center it on the label. Another
            way to accomplish  the same  goal is to  move the  labels to the  left in  the
            printer. Typically, it will be more convenient to change the margin.

            Entering a  margin of one  will move the  printing one space  to the  right. A
            margin of five  will move the print five spaces to the right. On most printers
            five spaces  is one half  inch.  If your printer prints  twelve characters per
            inch, a margin of  six will move the print one half inch  to the right. If you
            are printing with condensed  print, a margin of  seven or eight will  move the
            print one half inch to the right.


            Lines

            The  lines  parameter tells  the  program to  skip  lines, print  blank lines,
            between labels.  This feature  is used  when you  want to  print  a four  line
            address on a label large enough to hold five or more lines. 

            Some labels are placed close together on the backing paper,  others are placed
            on  the backing  paper  with a  space  between  individual labels.  The  lines
            parameter can be used to skip  over this blank space before starting to  print
            the next label.

            To determine the  proper entry for the  number of lines  to skip, measure  the
            exact distance from the  top of one label to  the top of the next  label. This
            distance will usually be some even multiple of one sixth of one inch,  perhaps



            132                                        Loan Master, Loan Accounting System







            one inch or one and two thirds inch. This spacing is used because printers are
            designed to print six lines per vertical inch of space on each page, or label.
            Determine  the number of  lines your  printer will print  from the  top of one
            label to the  top of the next.   The sum of the height parameter  and the line
            parameter should equal the number of lines your printer can print on the label
            you are using.


            Printing a Report

            The REPORT WRITER program produces  a disk file. This file is a  report format
            file. It  stores information about  how a report is  to be formatted  and what
            data is to be printed on it. It does not print the report.

            When  you have prepared  your format file,  copy it to the  directory in which
            your Bottom Line  Software application program  is executed. Load  application
            program and select the printed reports menu option. One of the printed reports
            options will be a custom report. Select the custom report option.  You will be
            asked  for a file name. Enter  the name of your format  file.  The application
            program will read the report  format file and attempt to format  the data from
            the application data files to fit the specifications of the format file. If it
            is successful, the report will  begin printing. If it is not, you will receive
            an error message.


            Error Messages While Printing

            When  you  request the  custom  report from  the  print menu,  the application
            program must  depend on  you to  give it good  instructions.   Setting up  the
            format file is computer programming.

            The most  common cause  of errors  will be in  specifying a  nonexistent field
            name. The primary key field  in the Loan Master loan database  is the customer
            number. The name of this  field is cust_no. This can be spelled with all lower
            case,  all upper case  or any combination  of the  two but it  must be spelled
            correctly.   the  underscore, "_",   is  required. Press  Shift "-"  (minus or
            hyphen).   On  most  keyboards it  is immediately  right  of the  Zero on  the
            typewriter keyboard.


            Error Example

            If the  custom report  format  file specifies  the customer  number  is to  be
            printed, but  misspells the field  name cust_na, when the  program attempts to
            print  the field  specified, cust_na,  it will  not be  able  to find  it. The
            program will  stop and print an error  message on the top  line of the screen.
            This message will look like this:


                  Proc CUSTREPORT line nnnn, undefined identifier (in .FRM) cust_na



            Loan Master, Loan Accounting System                                        133








            This  message  means  that in  the  procedure  (Proc)  CUSTREPORT the  program
            attempted to find a field named cust_na and  was unable to find it.  It  could
            not find it because the actual field name is cust_no, or CUST_NO.

            When you get a message like this, check your manual for the actual name of the
            field you want to print and  then use the REPORT WRITER program to  check your
            format file  to be sure  the field name  is spelled exactly  right. Two common
            errors are using  a l  (lower case  L) for a  1 (one)  or an  O (15th  letter)
            instead of a 0 (zero).











































            134                                        Loan Master, Loan Accounting System







            Loan File Data Fields


            The database file stores the following data for each loan.  The headings below
            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 field  name from each
            header. Note that the " _ " underscores are significant.

            Complete  file specifications  are printed in  the File  Specification Section
            (page  151 ).


            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.

            This number is used to group different loans to the same borrower.


            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
            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.


            Customer Name                                                        CUST_NAME


            Required. 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.

            This name is used on all notices. The Statement (transaction history, uses the
            name and address from the Customer Information files.






            Loan Master, Loan Accounting System                                        135







            Maker1,2,3,                                                         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. 


            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 balance is
            used to determine if the  loan is keeping pace, falling behind, or  gaining on
            the original agreed payment schedule.


            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, 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.












            136                                        Loan Master, Loan Accounting System







            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.


            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 because  if the number of  payments made equals the  number of payments
            matured, and the  loan was six months  past due and  recently  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.


            Payment Amount Regular                                              PMT_AMT_RG


            Required. Entered.  This is the  amount of the regularly scheduled payment. If
            there is a balloon payment, see the next field.











            Loan Master, Loan Accounting System                                        137







            Payment  Amount, Last                                               PMT_AMT_FN


            Required.  Entered.  This is the  total amount including interest of the final
            payment. If  there is no balloon  payment, this field should  contain the same
            amount as the Payment Amount Regular.


            Number  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.


            Final  Payment Number                                                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. If there  is no balloon payment, the final  payment
            number is the same as the Number of Payments.


            No Payments Per Year                                                  PMT_FREQ


            Required. This is self descriptive.  If payments are due monthly, this  is 12.
            If the payments are due quarterly, this is 4. Etc. 

            NOTE:

            Only commonly used schedules are supported. The data entry screen will display
            a pick list if an invalid number is entered.

            If  payments per  year is  24. Only  payments due  on the  first and  15th are
            supported.














            138                                        Loan Master, Loan Accounting System







            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 rate is for  information only, it is  not used to calculate  the interest
            accrual. See: rate, current.

            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.


            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%.

            Basis 12  is provided for monthly amortizing loans. Interest on these loans is
            calculated  as  if every  payment  was made  on  time regardless  of  when the
            payments  are actually  made.  When using  basis  12, late  payments will  not
            increase  the interest accrual  and early payments  will not reduce  it. Loans
            that  are prepaid enough to warrant credit  for early payment must be manually
            adjusted.






            Loan Master, Loan Accounting System                                        139







            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.



            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 by using the  earlier date as the setup date, or  by computing the
            interest and adding  it to  accrued interest on  the edit screen.  (Do not  do
            both.)


            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 will be due although
            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  or 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.




            140                                        Loan Master, Loan Accounting System







            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  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. If the last
            transaction  was a  payment,  this date  will be  the  same as  the date  last
            payment.


            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   the latest  date through which  interest has  been calculated and  for
            which past due status has been checked.

            It is  very 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. On this date,
            the entire balance and all accrued interest and late charges will be due.







            Loan Master, Loan Accounting System                                        141







            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, 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.









            142                                        Loan Master, Loan Accounting System







            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.  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 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 previous 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.




            Loan Master, Loan Accounting System                                        143







            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.


            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 transaction codes are displayed  on the posting
            screen.

            The parameter file can be edited to assign a meaningful name to this field.


            User Field 2                                                             USER2
            User Field 2 YTD                                                      USER2YTD

            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.)




            144                                        Loan Master, Loan Accounting System







            Two transaction  codes are provided, one  to add to  this field, the  other to
            subtract from this field. The  transaction codes are displayed on  the posting
            screen.

            The parameter file can be edited to assign a meaningful name to this field.


            User Numeric Fields 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.




            Customer Information Data Fields


            Customer No                                                             CUSTNO

            Required.   The customer number is a unique number assigned to each individual
            borrower.  If a borrower  has more than  one customer, this number  is used to
            identify  the  customer  and  to  locate  the  customer's  address(es),  phone
            number(s), and other information.


            Company  Name                                                         CUSTNAME

            Optional.   CIF  assigns  a company  name  field to  every customer.    CIF is
            primarily centered around keeping  up with customers. Customers may  be people
            or companies.  If a customer is  not directly or indirectly  associated with a
            company of any kind, this field may be left blank.



            Last Name                                                             LASTNAME

            Required. The  program will work with no  last name but it  will make locating
            the  record more dependent on  the customer number.  In the case  of a company
            where you know no one,  you may leave both the first and the last names blank.





            

            Loan Master, Loan Accounting System                                        145







            First Name                                                           FIRSTNAME

            Required. Same as the last name. It is not really necessary but without it you
            are placing more reliance on the customer  number.  If searching for a company
            where you know no one,  you may leave both the first and the last names blank.


            Title of Address                                                         TITLE

            Optional.   If you enter  it, it will be  used. If you omit it,  the names and
            addresses will be printed without it. Do not add the "." period. eg enter "Ms"
            not "Ms." The "." will be added when the address is printed.


            Customer Type                                                         CUSTTYPE

            Required.   Customer type 1 means this is a real live human person.  All other
            types are assigned by you and mean whatever you say they mean.  

            Taxpayer Identification                                               TAXPAYER

            Required. Social Security  number of Taxpayer  Identification Number. Used  at
            year end.


            Address File Data Fields

            Address Line 1                                                      ADDRSLINE1
            Address Line 2                                                      ADDRSLINE2


            Optional. You are  allowed two lines for the customer address.  City and state
            do not go here. They  each have their own field to make  sorting and selecting
            simpler.


            City                                                                      CITY
            State                                                                    STATE
             Zip                                                                POSTALCODE

            Required.   These fields  are  each  separate  to facilitate  control  of  the
            mailing list. Note that the Zip (postal code) is 12 characters in length. Non-
            USA postal codes containing alpha characters may be entered.


            Location                                                              LOCATION

            The CIF application allows multiple addresses for each customer. This field is
            a  short description of  which address  is displayed.  Eg. Home,  office, lake
            cabin, beach house, store 77, etc.



            146                                        Loan Master, Loan Accounting System








            Address Number                                                       ADDRESSNO

            Each  customer  is allowed  to  have up  to  99 addresses.  These  numbers are
            assigned  by the  user and  are not  required to  be consecutive.  The current
            version does not use them.



            Telephone File Data Fields


            Telephone Number                                                     TELEPHONE

            Enter the telephone  number. This is an alpha field, so  you can enter the "-"
            where appropriate. Eg. 817-817-8171


            Extension                                                             PHONEEXT

            Enter the extension, if any. This is a four character field.


            Location                                                              LOCATION

            The  CIF application allows multiple telephone numbers for each customer. This
            field is a short description of which telephone number is displayed. Eg. Home,
            office, lake cabin, beach house, store 77, etc.

            Comment                                                                COMMENT

            The  CIF application allows multiple telephone numbers for each customer. This
            field is a short comment about the  telephone number displayed. Eg. Call after
            7PM, Not on weekend, etc


            Phone Number                                                           PHONENO

            This may  be confusing. It is not  the telephone number you  dial to reach the
            customer. It is the sequence number of this customer's telephone records. If a
            customer  has six  telephone numbers,  this number  will be  one in  the first
            telephone record, and six in the last telephone record.











            Loan Master, Loan Accounting System                                        147







            Loan  Master  Files


            The Loan Master Loan Accounting system stores a considerable amount of data on
            the disk drive. Data is stored in these files:



                 File name                     Description                               Location
                                                                                         (Comments)

                 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.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).  It  must  be  renamed  to CIPARM.DBF.  The  normal
                                                                autoinstall routine does this for you.

                 CIPHONE.DBF  Phone file                        Data disk or directory.(Not used)

                 CIREMIND.DBF         Reminder file             Data disk or directory. (Not used)


                 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!!!



            148                                        Loan Master, Loan Accounting System







                 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.

                 LMPARM.DBF           Loan Master options file  Program disk or directory.

                 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.)
                                                                This  file  must  be renamed  to  LMPARM.DBF.  The  installation
                                                                routine normally does this.

                 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.


                 Normal System Files

                 These files are necessary for Loan Master to operate:

                 LMLOAN.DBF           The loan database file.

                 LMACCRUE.DBF         The daily accrual file. Details of each loan.(Optional)

                 LMTACCR.DBF          The daily accrual file. Totals only.(Optional)

                 LMLOAN.NTX           The loan database index.

                 LMALPHA.NTX          The loan database alpha index.

                 LMTRAN.DBF           The transaction database.

                 LMTRAN.NTX           The transaction index file.

                 LMPARM.DBF           The parameter file.




            Loan Master, Loan Accounting System                                        149







                 LMHELP.DBF           The help system.

                 LMHELP.DBT           The help screens text.

                 LMHELP.NTX           The help system index.

                 LMREPORT.RP1         The other reports definition file.

                 *.FRM                Any report file created by the  Loan Master report writer or any Dbase compatible  report
                                      writer.



                 These files are necessary for the Customer Information System to operate:

                 CIMENU.EXE           The Customer Information program.

                 CICUST.DBF           The customer information database file.

                 CIADDR.DBF           The customer address file.

                 CIPHONE.DBF          The customer's telephone numbers.

                 CIHELP.DBF           The customer information system help system.

                 CIHELP.DBT           The actual help screens text.

                 CIHELP.NTX           The customer information help screen index.

























            150                                        Loan Master, Loan Accounting System







            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 
            INT_YTD         Numeric     12  2 
            PENALTY         Numeric     12  2
            PENALTYYTD      Numeric     12  2
            USER1           Numeric     12  2
            USER1YTD        Numeric     12  2



            Loan Master, Loan Accounting System                                        151







            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



            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










            152                                        Loan Master, Loan Accounting System







            Field Definitions for LMTRAN.DBF

            Field name      Data type   Size    Dp

            CUST_NO         Character   12
            LOAN_NO         Character   12
            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 Accounting System                                        153







            Field Definitions for LMTACCR.DBF

            Field name        Data type Size    Dp

            TRAN_DATE         Date      8
            TRAN_CODE         Numeric   4       0
            TRAN_AMT          Numeric   12      2


            Tran code assignments:

            Daily total interest accrual            =  61
            Daily total late charge accrual         =  62

            This file contains one record for each day. That record contains total accrual
            amounts for all loans in the master file.

            Loan Master does not use this file. It simply adds the record each day. Do not
            use this file unless you plan to  use the data. See the parameter file  update
            menu to turn this file off.

































            154                                        Loan Master, Loan Accounting System







            Field Definitions for LMACCRUE.DBF

            Field name      Data type   Size    Dp

            CUST_NO         Character   12
            LOAN_NO         Character   12
            DATE_UPD        Date         8
            ACCDTODAY       Numeric     12      4
            TRAN_CODE       Numeric     4



            Tran code assignments:

            Daily total interest accrual            =  61
            Daily total late charge accrual     =  62

            This file  contains one record for  each loan every day.  Each record contains
            individual loan accrual amounts for  each loan in the master file.  There will
            be  at least one  record for  each loan every  day. If  a loan accrues  a late
            charge, it will have two records.

            Loan Master does not use this file. It simply adds the record each day. Do not
            use this file unless you plan  to use the data. See the parameter  file update
            menu to turn this file off.




























            Loan Master, Loan Accounting System                                        155







            Field Definitions for CICUST.DBF

            Field name      Data type   Size    Dp

            CUSTNO          Character   12
            CUSTNAME        Character   24
            LASTNAME        Character   30
            FIRSTNAME       Character   12
            MINITIAL        Character   1
            TITLE           Character   4
            CUSTTYPE        Numeric     2
            TAXPAYER        Character   12




            Field definitions for CIADDR.DBF

            Field name      Data type   Size    Dp

            CUSTNO          Character   12
            LOCATION        Character   10
            ADDRESSNO       Numeric     2
            ADDRESSLINE1    Character   32
            ADDRESSLINE2    Character   32
            CITY            Character   32
            STATE           Character   32
            POSTALCODE      Character   12


            Field Definitions for CIPHONE.DBF

            Field name      Data type   Size    Dp

            CUSTNO          Character   12
            TELEPHONE       Character   12
            PHONEEXT        Character   4
            LOCATION        Character   10
            PHONENO         Numeric     2
            COMMENT         Character   18


            Transaction Codes

            A Transaction Code is part of a transaction record. It is a numeric  code that
            tells  the  system what  the  transaction is,  and  how to  compute  it. Every
            transaction has a transaction code.






            156                                        Loan Master, Loan Accounting System







                              Loan Master Transaction Codes

             00-10       Credits, subtract from balance
                  01          Principal payment

                  11-20       Debits, add to balance
                  11          Principal advance
                  18-100      Nonbalance changes

                  18          Late Charge Accrued
                  19          Late Charge paid
                  30-39       Escrow transactions

                  31          Escrow deposit
                  32          Escrow deposit reversal

                  34          Escrow disbursement
                  35          Escrow disbursement reversal
                  40-40       User fields

                  41          Add to user field 1
                  42          Subtract from user field 1
                  43          Add to user field 2

                  44          Subtract from user field 2
                  45          Add to penalty field

                  46          Subtract from penalty field
                  61-69       Accruals
                  61          Interest accrued today (for accrual file)

                  62          Late charge accrued today (for accrual file)
                  101-998     reserved




















            Loan Master, Loan Accounting System                                        157








                                            Loan Master 
                                                 INDEX

             File Update Cycle  . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99
            Billing Notices 
                Abbreviated . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  103
            Browse Screen
                Cursor Control Keys . . . . . . . . . . . . . . . . . . . . . . . . . . 96
            Browse screens  . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  121
            Charged Off Loans
                Set up  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41
                Tutorial  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41
            CONFIG.SYS FILE . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  105
            Conversion
                conversion date . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
            Customer
                new . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  111
            Customer number . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  135
            Data Entry
                Cursor Control Keys . . . . . . . . . . . . . . . . . . . . . . . . . . 88
                Screen Fundamentals . . . . . . . . . . . . . . . . . . . . . . . . . . 88
            Data fields, description  . . . . . . . . . . . . . . . . . . . . . . 135, 145
            Date (of) payment due . . . . . . . . . . . . . . . . . . . . . . . . . .  140
            Date Screen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91
            Date, system  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91
            Delete
                Customer  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  117
                Loan  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57
                Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65
            Delete an old customer  . . . . . . . . . . . . . . . . . . . . . . . . .  117
            Error Message
                Custom Report Example . . . . . . . . . . . . . . . . . . . . . . . .  133
                Memory Errors . . . . . . . . . . . . . . . . . . . . . . . . . . . .  107
                Not enough memory to run application  . . . . . . . . . . . . . . . .  107
                While Printing Custom Reports . . . . . . . . . . . . . . . . . . . .  133
            Existing Loan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56
            Find a customer . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  110
            Finding Lost Loans  . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58
            Index files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  121
            Installation  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  5
            Interest Calculation  . . . . . . . . . . . . . . . . . . . . . . . . . . . 99
            Loan Data Entry
                Charged Off Loans . . . . . . . . . . . . . . . . . . . . . . . . . . . 41
                Existing Loan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56
                Existing Loans  . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
                Installment Loan, Nonperforming . . . . . . . . . . . . . . . . . . . . 45
                Installment Loan, Past Maturity . . . . . . . . . . . . . . . . . . . . 44
                Loans Past Maturity . . . . . . . . . . . . . . . . . . . . . . . . . . 41
                New Loan  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57



            158                                        Loan Master, Loan Accounting System







                Screen Fundamentals . . . . . . . . . . . . . . . . . . . . . . . . . . 88
                Single Payment Loan,  Past Maturity . . . . . . . . . . . . . . . . . . 43
            Loan Statement (History)  . . . . . . . . . . . . . . . . . . . . . . . . . 69
            Location of Lost Loans  . . . . . . . . . . . . . . . . . . . . . . . . . . 58
            Mailing Labels  . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  130
            Matured Loans
                Set up  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41
                Tutorial  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41
            Menu
                Definition  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51
                Structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52
                Sub Menus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54
                Use of  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51
            Menu operations . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  109
            Name And Address
                Add New . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  111
            Notices
                Controling mailings . . . . . . . . . . . . . . . . . . . . . . . . .  105
            Payments
                Posting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59
                Posting Dates . . . . . . . . . . . . . . . . . . . . . . . . . . . .  100
                To User Fields  . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62
            Problem
                Custom Report Error . . . . . . . . . . . . . . . . . . . . . . . . .  133
            Problems
                CONFIG.SYS File . . . . . . . . . . . . . . . . . . . . . . . . . . .  105
                Crashes at Startup  . . . . . . . . . . . . . . . . . . . . . . . . .  105
                DOS Error 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  107
                Dos Error 4 . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  106
                Finds Wrong Account or Address  . . . . . . . . . . . . . . . . . . .  121
                Hardware  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  105
                Memory Error Messages . . . . . . . . . . . . . . . . . . . . . . . .  107
                Past Due Notices  . . . . . . . . . . . . . . . . . . . . . . . . . .  104
                Software  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  105
                Test Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  105
                Will Be Due Notices . . . . . . . . . . . . . . . . . . . . . . . . .  104
            Report Writer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  123
            Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  83, 100
                Creating Custom . . . . . . . . . . . . . . . . . . . . . . . . . . .  124
                Mailing Labels  . . . . . . . . . . . . . . . . . . . . . . . . . . .  130
                Mailing Labels, Print . . . . . . . . . . . . . . . . . . . . . . . .  122
            Searching for Lost Loans  . . . . . . . . . . . . . . . . . . . . . . . . . 58
            Sort  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  122
            Transaction
                Deletion  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65
            Transactions
                Browsing, by Loan . . . . . . . . . . . . . . . . . . . . . . . . . . . 67
                Out of Date Sequence  . . . . . . . . . . . . . . . . . . . . . . . .  100
                Posting Dates . . . . . . . . . . . . . . . . . . . . . . . . . . . .  100
                Principal Advance . . . . . . . . . . . . . . . . . . . . . . . . . . . 64



            Loan Master, Loan Accounting System                                        159







            Updating
                file update . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99
            Updating Master File  . . . . . . . . . . . . . . . . . . . . . . . . . . . 99
            Updating the Loan File  . . . . . . . . . . . . . . . . . . . . . . . . . . 99
            Visual Update   . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 98
            Word Perfect Merge File
                Filter Expression . . . . . . . . . . . . . . . . . . . . . . . . . . . 81
                Merge File Structure  . . . . . . . . . . . . . . . . . . . . . . . . . 82
            WordPerfect Merge File  . . . . . . . . . . . . . . . . . . . . . . . . . . 77
             File Update Cycle  . . . . . . . . . . . . . . . . . . . . . . . . . . .  128
            Browse Screen
                Cursor Control Keys . . . . . . . . . . . . . . . . . . . . . . . . .  125
            Browse screens  . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  165
            Charged Off Loans
                Set up  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55
                Tutorial  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55
            CONFIG.SYS FILE . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  138
            Conversion
                conversion date . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
            Customer
                new . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  152
            Customer number . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  184
            Data Entry
                Cursor Control Keys . . . . . . . . . . . . . . . . . . . . . . . . .  118
                Screen Fundamentals . . . . . . . . . . . . . . . . . . . . . . . . .  117
            Data entry screens  . . . . . . . . . . . . . . . . . . . . . . . . . . .  147
            Data fields, description  . . . . . . . . . . . . . . . . . . . . . . 184, 200
            Date (of) payment due . . . . . . . . . . . . . . . . . . . . . . . . . .  192
            Date Screen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  121
            Date, system  . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121, 122
            Delete
                Customer  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  158
                Loan  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76
                Transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86
            Delete an old customer  . . . . . . . . . . . . . . . . . . . . . . . . .  158
            Error Message
                Custom Report Example . . . . . . . . . . . . . . . . . . . . . . . .  183
                Memory Errors . . . . . . . . . . . . . . . . . . . . . . . . . . . .  140
                Not enough memory to run application  . . . . . . . . . . . . . . . .  140
                Not enough memory to run reports  . . . . . . . . . . . . . . . . . .  141
                While Printing Custom Reports . . . . . . . . . . . . . . . . . . . .  182
            Existing Loan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74
            Find a customer . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  148
            Finding Lost Loans  . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77
            Index files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  166
            Installation  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  8
            Interest Calculation  . . . . . . . . . . . . . . . . . . . . . . . . . .  128
            Loan Data Entry
                Charged Off Loans . . . . . . . . . . . . . . . . . . . . . . . . . . . 55
                Existing Loan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74



            160                                        Loan Master, Loan Accounting System







                Existing Loans  . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
                Installment Loan, Nonperforming . . . . . . . . . . . . . . . . . . . . 60
                Installment Loan, Past Maturity . . . . . . . . . . . . . . . . . . . . 58
                Loans Past Maturity . . . . . . . . . . . . . . . . . . . . . . . . . . 55
                New Loan  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75
                Screen Fundamentals . . . . . . . . . . . . . . . . . . . . . . . . .  117
                Single Payment Loan,  Past Maturity . . . . . . . . . . . . . . . . . . 57
            Location of Lost Loans  . . . . . . . . . . . . . . . . . . . . . . . . . . 77
            Mailing Labels  . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  178
            Matured Loans
                Set up  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55
                Tutorial  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55
            Menu
                Definition  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65
                Structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67
                Sub Menus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70
                Use of  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65
            Menu operations . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  143
            Name And Address
                Add New . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  152
            Payments
                Posting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79
                Posting Dates . . . . . . . . . . . . . . . . . . . . . . . . . . . .  130
                To User Fields  . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83
            Problem
                Custom Report Error . . . . . . . . . . . . . . . . . . . . . . . . .  183
            Problems
                CONFIG.SYS File . . . . . . . . . . . . . . . . . . . . . . . . . . .  138
                Crashes at Startup  . . . . . . . . . . . . . . . . . . . . . . . . .  138
                DOS Error 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  140
                Dos Error 4 . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  139
                Finds Wrong Account or Address  . . . . . . . . . . . . . . . . . . .  166
                Hardware  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  138
                Memory Error Messages . . . . . . . . . . . . . . . . . . . . . . . .  140
                Past Due Notices  . . . . . . . . . . . . . . . . . . . . . . . . . .  137
                Software  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  138
                Test Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  137
                Will Be Due Notices . . . . . . . . . . . . . . . . . . . . . . . . .  136
            Report Writer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  168
            Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109, 132
                Creating Custom . . . . . . . . . . . . . . . . . . . . . . . . . . .  171
                Mailing Labels  . . . . . . . . . . . . . . . . . . . . . . . . . . .  178
                Mailing Labels, Print . . . . . . . . . . . . . . . . . . . . . . . .  167
            Searching for Lost Loans  . . . . . . . . . . . . . . . . . . . . . . . . . 77
            Sort  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  167
            Transaction
                Deletion  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86
            Transactions
                Browsing, by Loan . . . . . . . . . . . . . . . . . . . . . . . . . . . 86
                Out of Date Sequence  . . . . . . . . . . . . . . . . . . . . . . . .  131



            Loan Master, Loan Accounting System                                        161







                Posting Dates . . . . . . . . . . . . . . . . . . . . . . . . . . . .  130
                Principal Advance . . . . . . . . . . . . . . . . . . . . . . . . . . . 84
            Updating
                file update . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  128
            Updating Master File  . . . . . . . . . . . . . . . . . . . . . . . . . .  128
            Updating the Loan File  . . . . . . . . . . . . . . . . . . . . . . . . .  128
            Visual Update   . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  127
            Word Perfect Merge File
                Filter Expression . . . . . . . . . . . . . . . . . . . . . . . . . .  106
                Merge File Structure  . . . . . . . . . . . . . . . . . . . . . . . .  107
            WordPerfect Merge File  . . . . . . . . . . . . . . . . . . . . . . . . . . 99










































            162                                        Loan Master, Loan Accounting System





                                    Loan Master Setup Sheets
                                       
                                New Loan Setup Sheet 

                              Date __________     Entered by: __________

            NEW LOAN SCREEN ͻ
                                                                                         
            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    ______________  
                                                                                         
                           ________________________   Beginning Escrow   ______________  
                                                                                         
                           ________________________   Escrow Payment     ______________  
                                                                                         
            Date Note           /  /                                                     
                                                                                         
            Date First Pmt      /  /                                                     
                                                                                         
            Date maturity       /  /                                                     
                                                                                         
            No int. until       /  /                                                     
                                                                                         
            Int Rate Orig    ____.______                                                 
                                                                                         
            Int Comp Basis   ___________                                                 
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
           ͼ





                                     Loan Maintenance Sheet 

                              Date ___________    Entered by ___________


            LOAN RECORD UPDATE SCREEN ͻ
                                                                                         
             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 Maintenance Sheet 
                                       User Defined Screen

                             Date ___________     Entered by ___________

           <                                      >ͻ
                                                                                         
             Customer No.                             Original amount :                  
                                                                                         
             Loan No.                                 Current balance :                  
                                                                                         
             Cust name.     ______________________                                       
                                                                                         
             Comments       ______________________                                       
                                                   Escrow Balance  : _______________     
                                                                                         
                                                     Escrow Payment: _______________     
             Alpha field 1  _______________________                                      
                                                          Mail Flag: _______________     
             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 Maintenance Sheet 
                                       User Defined Screen

                             Date ___________     Entered by ___________

           <                                      >ͻ
                                                                                         
             Customer No.                             Original amount :                  
                                                                                         
             Loan No.                                 Current balance :                  
                                                                                         
             Cust name.     ______________________                                       
                                                      Escrow Payment  : ______________   
             Comments       ______________________                                       
                                                      Escrow Balance  : ______________   
                                                                                         
                                                      Mail Flag       : ______________   
                            _______________________                                      
                                                                                         
                            _______________________                                      
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                               _____________                          _______________    
                                                                                         
                               _____________                          _______________    
                                                                                         
                               _____________                          _______________    
                                                                                         
                               _____________                          _______________    
                                                                                         
                               _____________                          _______________    
                                                                                         
                               _____________                          _______________    
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
           ͼ
