Loan Processing > Modify >

Loan Information > Update

 

         

 

 

Overview


Loan Information - Update allows you to add or edit your Loan Processing loan. If this is a new loan the Person Search window displays. By default the search text for the Name field searches for last names and organizations. To search for first and last names enter your search in the "lastname, firstname" format. You can also search by City and State. Select the Loanee and click the Select button. Alternately, click the Close link to return to the previous page without selecting a Loanee.

 

Note: Search for just a first name by starting your search with a comma (e.g., ", James"). Display a complete list of individuals by searching for just a comma.

 

Type an Account # for reference. The Account Name defaults to the name of the selected Loanee but you can type a different name if desired. There are nine available tabs: Loan Information, General Ledger, Loan Status, Attachments, Note, Phones, Emails, Addresses, and Demographics. You can also Print Amortization and print a Scheduled Audit and Actual Audit reports.

 

This Help page contains the following sections:

Loan Information Tab

General Ledger Tab

Loan Status Tab

Attachments Tab

Note Tab

Phones Tab

Emails Tab

Addresses Tab

Demographics Tab

Print Amortization

Scheduled Audit

Actual Audit

 

 

Loan Information Tab


Select the Account Type from the drop-down list and then select the Type of Loan:

 

Conventional: When invoices are posted, interest due is calculated depending on the Type of Interest chosen. The remaining portion of the payment amount is invoiced to principal.

Balloon: This type of loan requires a balloon date (the date that the entire purchase price plus interest is due - usually 5 or 10 years) to be entered. When that month is reached, the remaining loan balance is invoiced along with the additional interest for that period.

Interest Only: When invoices are posted, the program only calculates and invoices interest due.

 

Select the Type of Interest:

 

Traditional (360): Unless the loan is setup as Interest Only, the program invoices the interest and the principal due for that period. Interest is calculated by taking the present loan balance, multiplying it by the Interest Rate, and then dividing it by Number of Payments Per Year.

Traditional (Actual Days): Unless the loan is setup as Interest Only, the program invoices the interest and the principal due for that period. Interest is calculated by taking the loan balance as the last interest date (from the last posting). The program then goes through a daily calculation, looking at the daily activity within the period (draws, adjustments, and payments) and summing up the daily interest charges through the date of posting (Invoice Date). The remainder is invoiced to principal.

Simple Daily Interest: The program only invoices interest. Interest is calculated by taking the loan balance as of the last posting (last payment or invoice posting), then looking at the daily activity within the period (draws, adjustments, principal write-offs, and payments), calculating interest due on a daily basis, and summing up the daily interest through the date of posting (Invoice Date). The resulting interest amount is then invoiced for the loan.

 

Select if you want to Print 1098. Specify the rest of the loan information:

 

First Payment Date: Select the date the first payment is due.

Inception Date: Select the date the loan originated.

Balloon Date: Select the date the balloon payment is due (only active if the Type of Loan is set to Balloon).

Total Amount: Type the total amount of the loan.

Down Payment %: (Optional) Type the percentage if a dollar amount is not entered.

Down Payment $: (Optional) Type the dollar amount if a percentage is not entered.

# Payments/Year: Select the amount of payments per year. Loan processing runs all loans on a monthly-type basis. For example: a loan with 4 payments per year will be invoiced every three months (90 days).

Interest Rate: Type the interest rate (e.g., 7.5 for 7.5%).

# Payments: Type the number of payments (e.g., 120 for 10 years if there are 4 payments per year). Leave this field blank to have Loan Processing calculate the number of payments after the Payment amount is entered.

Payment: Type the Payment amount. This field is calculated for you if you have specified the # Payments.

 

The Activity Since Inception section allows you to enter or change information about the loan. This is usually used when you first start to use Loan Processing and input existing loans that have already had activity. You can change the following information:

 

Paid Principal: Type the total amount paid in principal prior to entering the loan into your Financials.

Invoiced Principal: Type the total amount invoiced for principal prior to entering the loan into your Financials.

Paid Interest: Type the total amount paid in interest prior to entering the loan into your Financials.

Invoiced Interest: Type the total amount invoiced for interest prior to entering the loan into your Financials.

Interest Thru: Select the date through which interest was last invoiced.

 

The Activity Since Inception section only displays until the first time invoices are posted for the loan. At that time an invoice and/or payment is generated and added to the loan record as historical data. This information is not posted to General Ledger.

 

 

 

 

General Ledger Tab


Use the drop-down list to select the Bank Account to use for the loan. You can then specify the General Ledger levels and account information:

 

Principal Account: Asset account where principal loan payments are to be credited.

Interest Account: Income account where the interest payments are to be credited.

 

These default to the accounts selected in Preferences (More Information).

 

 

Loan Status Tab


This tab displays the payment history, invoiced summary history, unposted interest (if using simple daily interest), and the last date of interest calculation. One row is displayed per invoice/payment with the following columns: Check #, Date, Principal, Interest, Addtl. Principal, Addtl. Draw, Adjustment, Late Fee, Note, and Setup.

 

Click the Void Payment button to void a payment. This makes the necessary adjustment to the loan and sends the appropriate entry to General Ledger. This also removes the payment from the history of the loan.

 

 

Attachments Tab


The Attachments tab allows you to attach files accessible from your device or to scan image files using the Scanner.Client.exe program. See the Attachments Help Page for detailed information regarding the attachments feature.

 

 

Note Tab


Type a note for the account if desired.

 

 

Phones Tab


The Phones tab displays the phone numbers assigned to a loanee and has options to modify these phone numbers.

 

Phones Tab

The following options are available on the Phones tab.

Click the  link to add a new phone number.

Click the Edit  icon to modify an existing phone number.

Click the Delete  icon to remove a phone number from the system.

Click on the Phone Type, Phone Number, or Extension header to sort the list of phone numbers by that header.

 

Add or Edit a Phone Number

The following fields are available when selecting to add or edit a phone number.

Phone Type: Select the phone type from the drop-down list. (Phone types can be modified on the Lookups page. To navigate there, click the Applications option from the Top menu and then select Utilities -> Lookups. Also, the order of the Phone types can be modified on the Lookups page.)

Phone Number: Enter the phone number. The phone number is automatically formatted when your cursor leaves the Phone Number field. For example, if you enter "9015551234", the number is automatically formatted to display "(901) 555-1234".

ext.: Enter the phone number extension (optional).

Unlisted: This check box is informational. Selecting this option does not prevent the phone number from printing on reports.

SMS: This check box is informational.

 

All phone numbers must have an Area Code. If a phone number is entered without an area code (7-digits), then the default area code is added automatically.

The default area code is specified on the Utilities > Organization page. To navigate there, click the Applications option from the Top menu and then select Utilities -> Organization.

 

Click the  button to save your changes and return to the Phones tab.

Click the Close link to return to the Phones tab without saving your changes.

 

 

Emails Tab


The Emails tab displays the email addresses assigned to a loanee and has options to modify these email addresses.

 

Emails Tab

The following options are available on the Emails tab.

Click the  link to add a new email address.

Click the Edit  icon to modify an existing email address.

Click the Delete  icon to remove an email address from the system.

Hover over the Note  icon to display the text stored in the Note field.

 

Add or Edit an Email Address

The following fields are available when selecting to add or edit an email address.

Email: Enter an email address. The email address must be formatted correctly using the "@" symbol and a period.

Note: Enter a Note (optional). Entering a note causes the Note  icon to display on the Emails tab.

Active: Only Active Email Addresses are used for contacting the employee and for reporting purposes.

Preferred: Only one email address can be designated as the Preferred email address. The Preferred Email address displays at the top of the List of Emails grid. It is used by the system to contact the employee and for reporting purposes.

 

If the Preferred email address is not marked Active, the system defaults to using the next available Active email address listed on the List of Emails grid.

 

Click the  button to save your changes and return to the Emails tab.

Click the Close link to return to the Emails tab without saving your changes.

 

 

Addresses Tab


The Addresses tab displays the addresses assigned to a loanee and has options to modify these addresses.

 

Addresses Tab

The following options are available on the Addresses tab.

Click the  link to add a new address.

Click the Edit  icon to modify an existing address.

Click the Delete  icon to remove an address from the system.

Click on the Address Type, or Address header to sort the list of addresses by that header.

 

Add or Edit an Address

The following fields are available when selecting to add or edit an address.

Address Type: Select the address type from the drop-down list.

Address Line 1: Enter the first line of the address.

Address Line 2: Enter the second line of the address (Optional).

Postal Code: Enter the Postal Code/Zip Code.

City: Enter the name of the City.

State: Select the State from the drop-down list using your mouse or type the first letter of the state. (You can continue to press the first letter of the state to scroll through the states that start with that letter.)

Country: Select the Country from the drop-down list.

Primary: Only one address can be designated as the Primary address. The Primary address displays on grids and is used by the system to contact the loanee and for reporting purposes.

 

The Address Types and the Country drop-down options can be modified on the Lookups page. To navigate there, click the Applications option from the Top menu and then select Utilities -> Lookups.

Also, the order of the Address types and Countries can be modified on the Lookups page.

 

Click the  button to save your changes and return to the Addresses tab.

Click the Close link to return to the Addresses tab without saving your changes.

 

 

Demographics Tab


Enter the Birth Date, Social Security Number, Salutation, Gender, Employer, and Position in the fields provided.

 

If the account belongs to an organization, the following fields display:  Date CreatedFederal Tax ID Number, and Salutation.

 

Print Amortization


Click the Print Amortization button to bring up the Amortization Parameters window. The Principal, Interest, and Total of payments display. The Beginning payment # and Ending payment # fields reflect the total number of payments by default although you can type in different values if you want to print only a range of payments. Click the OK button to display a preview of your Amortization Schedule or the Cancel link to return to the previous page. Once the preview displays you can navigate the pages, export to several formats (e.g., PDF, Excel, Word), and Print. Click the Close Report button to return to the previous page.

 

Scheduled Audit


Click the Scheduled Audit button to bring up the Scheduled Audit Report. This is similar to an amortization schedule. The difference is that each period is built using anticipated amounts that should have been invoiced for principal and interest based on the actual payment activity found prior to that period. The report displays amounts that would have been invoiced for principal and interest if done on schedule, including the actual payment summary with running totals for the invoiced principal and invoiced interest balances. The invoiced information is calculated in the period before the payment is applied.  Once the preview displays you can navigate the pages, export to several formats (e.g., PDF, Excel, Word), and Print. Click the Close Report button to return to the previous page.

 

The Scheduled Audit Report displays every scheduled invoice from the start of the loan through the current date.

 

 

Actual Audit


Click the Actual Audit button to bring up the Actual Audit Report. This has the same formatting as the scheduled report and displays the same scheduled invoice dates except that each period is built using the actual activity in the period (invoiced and paid) showing the amount paid within the period, and ending balance, and running totals for invoiced principal and invoiced interest balances.  Once the preview displays you can navigate the pages, export to several formats (e.g., PDF, Excel, Word), and Print. Click the Close Report button to return to the previous page.

 

The Actual Audit Report displays every scheduled invoice from the start of the loan through the current date. If you have invoiced a future date already it does not display on the report.

 

 

When finished click the Update button to save your changes and return to the Loan Information page, the Reset link to undo all changes since the last time the loan was updated, or the Cancel link to discard all changes and return to the Loan Information page.

 

Compiled on 10/16/2018 10:23:13 AM