Margill Loan Manager Margill Loan Manager

Portfolio Management Software
|Site Map |Contact us
 
Questions?
Call us
Toll free: 1-877-683-1815
or 001-450-621-8283
Email
| | | |
 

Margill Loan Manager Software Update

To get the updates go to the Download Center


This page shows the changes and improvements in the latest software updates.


Version 2.3 - Released November 11, 2011
(Version 2.3.111111.1)

Changes and improvements since the September 14th version:

  • New user privilege level: create and edit Records that are in "Draft" state only.
  • New "Notes" section allowing the user to add and view general notes in a Record.
  • In the Main window, new field can be configured to provide the "Interest Accrued from the last paid payment to the current date".
  • In the Results table, new option to instantly recompute (adjust) the interest rate for a line in order to obtain a known interest amount for that line (or period) only.
  • In the Detailed payment schedule report, the following elements can now be excluded from the printed report:

    • "Start Date" column
    • "Interest Rate" column
    • Header: Data window "Description"
    • Header: Borrower window "Other info"

  • In the Detailed payment schedule report the record numbers now appear in the printed report's footer.
  • New fields in Record List (Customized) report, RTF reports (merge)(and main window):

    • Balance Due Interest at Start Date entered
    • Balance Due Principal at Start Date entered

  • Display of the date and time at which the Record was last updated.
  • Main window refresh speed optimized.


Version 2.3 - Release date September 14, 2011
(2.3.110914.2)

Click on the image to see a short video explaining the main changes and improvements (Youtube)

What's new in detail:

  • New option allowing to add Principal, Fees (Fees, Fees 1, Fees 2), Insurance, Taxes, Penalties and Invoices without charging interest on these.

  • Scroll menus may be created for the following fields:

    • Borrower window: Type, State/Prov., Country and the nine (9) custom fields
    • Custom fields (unlimited): All fields
    • Advanced window: Grace period (in days)

  • Most fields available in MLM can now appear in the Main window thus allowing to view and sort with the data contained in these.

  • In the Main window, new field can be configured to provide balance on current date.

  • New fields in Record List (Customized) report, RTF reports (merge)(and main window):

    • File Number (as a number, not text)
    • Today's date - long format
    • Computation method (Simple, Compound, etc.)
    • Day count
    • Short period computation method
    • Year base (anniversary or civil year) for simple interest computations
    • Balance of line of last Paid payment (all "Paid" Line statuses)
    • Amount of last Paid pmt (all "Paid" Line statuses)
    • Total of Fees 1 + Fees 2 + Fees 3
    • Total of Fees 1 Paid + Fees 2 Paid + Fees 3 Paid
    • Principal Total Principal Total (interest bearing portion)
    • Principal Total (no interest portion)
    • Additional Principal (Line Status = Add. Princ.) (interest bearing portion)
    • Additional Principal (Line Status = Add. Princ.) (no interest portion)
    • Principal Total (for the period)
    • Principal Total (interest bearing portion) (for the period)
    • Principal Total (no interest portion) (for the period)

  • Portfolio analysis: Repayment ratio

  • The 9 Custom fields contained in the "Borrower" window now appear in the Payment Update tool.

  • The Custom fields (unlimited) can now be used in the RTF Report Editor as document merge fields.

  • Line numbering in the Results table.

  • New data merge module allowing the creation of very precise scanned (PDF) custom reports.

  • "File" field entered by the user ("Borrower" window) now appears in active Record's header.

  • In the "Results Table", 100 spaces (characters) now allowed in the "Comment" column.

  • In the "Data" window, unlimited number of spaces in the "Description" box.

  • "Mobile" phone field added for Borrower and Creditor.

  • New Record status: "On hold".

  • "File Number" (as a number not text) added for Borrower (in order to sort by numerical order).

  • The file number or numbers entered by the user will now appear in the record window header.

  • For new installations, option to start each Record's unique identifier at a specific number other than 1 or 100 ("Record no." field).

  • In the Record List (Customized) report, the 9 Custom fields contained in the "Borrower" window have been moved from the "Special" column to the "Borrower" column.

  • Various "behind the scenes" improvements and corrections.

  • Knowledge base added on the Margill website: www.margill.com/knowledge.

  • Updated User Guide.

Version 2.2 - December 3, 2010
(2.2.101203.4)

  • Major new Alert module that includes four (4) types of alerts:
      • System Alerts: General alerts for one or all users.
      • Line status Alerts: Alerts based on the Line status conditions.Most useful for due payments.
      • Record Alerts: General alerts but specific to each record.
      • Record Line-specific Alerts: In the Results table of each record, on each payment line

    • New sub-statuses for Active Records as well as the corresponding Metro 2 code (for credit reporting agencies). Option to show only certain sub categories in the main window. These fields have also been added in the Custom Record List report and in RTF (merge reports)

      • Current (0)
      • Deferred payment
      • Late payment
      • Late payment 30-59 days (1)
      • Late payment 60-89 days (2)
      • Late payment 90-119 days (3)
      • Late payment 120-149 days (4)
      • Late payment 150-179 days (5)
      • Late payment 180 days or more (6)
      • Collection (G)
      • Foreclosure completed (H)
      • Voluntary surrender (J)
      • Repossession (K)
    • Option allowing for a grace period for late payments. Thus, even if a payment is late by x days, no extra interest is charged to the borrower. However, the feature is not automated but a new column was created in the Results table in which to insert the true payment date if a grace period is given. See Advanced settings to set the Grace period for each Record.
    • Bi-monthly payment frequencies no longer limited to the 1st and 15th of the month.
    • Annual interest rate up to 999%.
    • New Line status - "Paid Returned Check".
    • Option to add the actual Results table (with various data elements) in the RTF (merge) reports.
    • Multiple new fields in Record List (Customized) report and RTF reports (merge):
    • Grace period (days)

    ----------

    • Sub-status (for Active Records)
    • Sub-status (for Active Records) - Metro 2 code

    ----------

    • Paid Pmt (Line status = Paid Pmt)
    • Paid Late Pmt (Line status =
    • Paid Late Pmt) Partial Pmt (Line status = Partial Pmt)
    • Partial Late Pmt (Line status = Partial Late Pmt)
    • Add. Pmt (Line status = Add. Pmt)
    • Returned Checks Paid (Line status = Paid Pmt Returned Check )
    • Balance Total Unpaid portions (Unpaid, Partial, Returned checks)

    ----------

    • Outstanding (balance) Start Date entered
    • Outstanding (balance) End Date entered
    • Outstanding Paid (for the period)

    ----------

    • Principal paid Year to date

    ----------

    • Detailed lines (for the period)(RTF report only)
    • New columns in the Results table allowing you to determine the outstanding payments balance. The "Outstanding (Balance)" column factors in the payment that should have been paid less the true payment amount as well as the extra payment that compensates the unpaid or partial payments.
    • New columns in the Results table:

      • True Pmt Date (Grace)
      • Outstanding (Balance)
      • Alert to accomplish
      • Alert Days Before - / After +

    • New columns in the Invoices and Statements module:

      • Phone
      • Creditor
      • Expected payment
      • True payment date (Grace)
      • Outstanding (Balance)
  • Maximum file size attached to a record now up to 2 Meg (was 1 Meg in version 2.1).
  • Backup of the software and the database now in Tools.
  • Shortcut summaries with F2.
  • Link to check Internet connection (Tools, Settings)
  • Menu button changes and optimization.
  • Various other fixes and process optimization.


    Version 2.1 - April 12, 2010
    (2.1.100412.1)

    • Improved Line status navigation (simplified constraints)
    • Various adjustments of version 2.0 which was a major update

    Version 2.0 - February 9, 2010
    (2.0.100209.1)

    • New custom data fields (unlimited number) that may be included in Record List (Customized) report.
    • Multiple currencies within the same portfolio.
    • In Record List Customized, conversion of various currencies based on exchange rate to selected base currency or to any other.
    • Unique log on by the same user name.
    • Record access blocked to one user. Other users in read-only.
    • Multiple new Line statuses:

    • Fees paid
    • Fees 2
    • Fees 2 paid
    • Fees 3
    • Fees 3 paid
    • Invoice paid
    • Penalty
    • Penalty paid
    • Insurance
    • Insurance paid
    • Taxes
    • Taxes Paid
    • Investment
    • Investment withdrawal
    • Deposit
    • Other 4
    • Other 5
    • Adjustment
    • Information
    • Not set
    • New data integrity constraints (takes into account Line status and the amounts indicated for these payments as well as logical parameters).
    • For accounting: actual paid interest, due interest, refunded principal, due principal (if Line status = Paid pmt, Partial pmt or Late pmt, Add. pmt) can now be obtained easily.
    • Over 10 new columns in the Result table offering additional information (for example: balance prior to payment, interest paid, principal paid, scheduled payment date, different balances, etc.).
    • Column identifying the minimum payment to be paid.
    • Optional adjustment on Payment as opposed to preset Fixed principal amount or interest portion for an Interest-only payment. Multiple new refunding options particularly fro SImple interest calculations.
    • Automatically calculated fixed principal refund amount to yield balance = 0.00 or X.
    • Multiple (over 40) new data elements in Record List (Customized) report and RTF reports (merge):
    • Current date

    ----------

    • Amortization period less 1 payment
    • Amortization period less 2 payments
    • Interest rate (nominal end effective) quoted on a monthly basis

    ----------

    • First Payment Amount (> 0.00)
    • First Payment Date (Pmt > 0.00)
    • Last Payment Amount (> 0.00)
    • Last Payment Date (Pmt > 0.00)

    ----------

    • Currency - Symbol
    • Currency - Abbreviation

    ----------

    • Fees Paid (Line Status = Fees Paid)
    • Fees 2 (Line Status = Fees 2)
    • Fees 2 Paid (Line Status = Fees 2 Paid)
    • Fees 3 (Line Status = Fees 3)
    • Fees 3 Paid (Line Status = Fees 3 Paid)
    • Adjustment (Line Status = Adjustment)
    • Invoices Paid (Line Status = Invoice Paid)
    • Insurance (Line Status = Insurance)
    • Insurance Paid (Line Status = Insurance Paid)
    • Tax (Line Status = Tax)
    • Tax Paid (Line Status = Tax Paid)
    • Penalty (Line Status = Penalty)
    • Penalty Paid (Line Status = Penalty Paid)
    • Investment (Line Status = Investment)
    • Investment Withdrawal (Line Status = Investment Withdrawal)
    • Other 4 (Line Status Other 4)
    • Other 5 (Line Status Other 5)

    ----------

    • Princ. (original) + Add. Princ. (Line Status) up to End Date entered
    • Accrued interest from last Payment
    • Date of last Pmt tagged as "Paid" (Line status = Paid Pmt, Paid Late Pmt, Partial Pmt, Partial Paid Pmt or Add. Pmt)
    • Accrued interest - Year to date Paid interest - Year to date
    • Minimum Payments (Total for the period)
    • Next Due Minimum Payment
    ----------
    • Paid Interest (for the period) Paid
    • Principal (for the period)
    • Balance Due Principal
    • Balance Due Interest
    • Balance all other

    ----------

    • Doubtful Accounts (%)
    • Doubtful Accounts (Date from Record)
    • Doubtful Accounts (Balance from Record date)
    • Doubtful Accounts (Balance from Report date)
    • Bad Debt (Date) Bad Debt (Balance)
    ----------
    • APR - Total Principal + Total Cost (Interest + Fees)
    • Comment may be added for each payment line directly in the Payment update tool.
    • Record Attachment notification (paper clip image).
    • In Record List (Customized) report, multiple CSV "pure" date formats and export to Excel with or without currency.
    • Telephone number now in the Loan Summary window (main window) in order to sort by phone number
    • Major database optimization for larger loan portfolios (1000-5000 Records)
    • Borrower first and last names and company name in Record window header (for easier identification).
    • One less step when saving and replacing a Record.
    • Multiple other "behind the scenes" improvements and adjustments.

    Version 1.4 - March 16, 2009
    (1.4.090316.1)


    Version 1.4 includes mutiple new components the main ones being : custom reports, reports between two dates, invoice and statement module, new custom fields and read-only user.

    Changes and improvements since version 1.3:

    • Nine (9) new customizable fields in Borrower (fields may be text, monetary, percentage, numerical or date)
    • Document management – attach documents to a specific Record
    • Read-only user
    • Record access limited to own records if desired
    • Data integrity tool that checks to see if line status is appropriate for a positive, negative or 0.00 payment
    • Forced "Additional Principal" line status to be negative
    • Custom invoices and statements (including tax reports – IRS 1098 for example)
    • Reports:

      • Reports for a user-defined period (monthly, quarterly, yearly, etc.) using start and end dates
      • User-created custom Record lists that may be saved to Excel, CSV or TXT formats and then exported to third party software (accounting, pre authorized payment system, etc.)
      • For detailed reports, system number now on each page for quick identification
      • For invoices and statements and other data merges (RTF Editor) option to save as one RTF file, one RTF file with x number of records per page or multiple files (including system numbering)

    • Balance = 0.00 not checked unless specifically checked by user
    • Alt-2 shortcut to select, in the payments schedule, one line out of every two lines (to have payments only every second month for example)
    • In the main MLM window (Record Summary window) and in the payments schedule, Alt- shortcut to increase font size and Alt- to reduce the size.
    • Change of name from Actuarial Method to Effective Rate Method
    • Multiple changes and adjustments from version 1.3

    Version 1.3 - March 20, 2008
    (1.3.080320.1)

    • Payment update tool
    • Various adjustments from verison 1.1


    Version 1.1 - May 25, 2007
    (1.1.070525.1)

    • Release of the Margill Loan Manager


  •      

    Fully functional
    packages


    Easily manage from 10 to thousands of:
      Loans (car, personal, commercial)
      Add-on Interest Loans
      Mortgages
      Adjustable Rate Mortgages (ARM)
      Reverse Mortgages
      Lines of credit
      Collection - Bills, Invoices...
      Leases
      Late and/or unpaid salaries, rent, annuities
      Investment portfolios

    MARGILL NEWS
     
     


    | Home | Products | Price/Buy | Try | Our Company | Support | Contact us |
    | Margill Standard | Margill Law | Margill Loan Manager | Tables |
    | Download Center | FAQ |

    Copyright © Margill / Jurismedia inc., All rights reserved