Margill Loan Manager Detailed Features

Getting started

• Import your Borrowers in seconds directly from an Excel spreadsheet
• Import your regular and irregular loans and payments from an Excel spreadsheet
• System configuration and data import services

Basics

• PC: Windows based / Citrix / Remote Desktop
• Mac running Parallels Desktop
• Available as network installed (your infrastructure) or on the Margill Azure Cloud (SAAS)
• Uses its own database (Hyperfile)(database is encrypted)
• Database can be located at any desired location on a local area network (LAN)
• Can be used on your own Cloud too
• Network (multi-user) or Single User
• Manage from 10 to 100,000+ loans
• Search tool in the Main window (Multiple field search)
• Large database instant data refresh
• Ultra high resolution (4K) and small very high resolution screen (>1080p) optimization

Security and Privacy

• Login by User name and Password
  • “Strong” (versus simple) password may be set as mandatory
  • Multifactor authentication (MFA)
  • 5 attempts to enter software before being locked out
• Users: Administrator, Power, Regular, Draft, Read-only
  • Multiple other rights can be provided or removed
  • Compulsory (or not) Template for Main window and Payment schedule data displayed
• ADMIN user only can activate additional security and confidentiality measures including:
  • 6 activity logs saved as JSON files
  • “Strong” password
  • And many more…
• Social Insurance Number and Bank account Privacy

The Math

• Simple Interest
• Simple Interest Capitalized
• Compound Interest
• Multiple Compounding Periods (no need to match payment frequency)
• Multiple Payment Frequencies and Irregular
• Regular or Irregular First Payment Date
• Multiple Day Counts (Actual/Actual, Actual/365, Actual/360, 30/360)
• Short & Long Periods
• Mix of Compound and Simple interest in one schedule (pretty advanced stuff!!)
• Add-on (precomputed) Interest

Origination

• Accept / Reject applications (bulk import via Excel and JSON)
• Create payment schedules
• Create loan documents
• Store documents

Interest Rates

• Fixed Interest Rate
• Variable Interest Rates
  • Create your own Rate tables (Prime, SOFR, etc.)
  • Variable rates + or – x% (Spread)
  • Update interest rates in bulk (for multiple selected loans at once)
  • Change interest rates for all future payments or for a specific time period only
  • Payment schedule automatically updated when the Rate table is updated or updated at regular frequencies
    • Update Rate tables in bulk via Excel sheet
    • Payment auto update based on rate increase or decrease
• Rates up to 6 decimal places

Borrowers – Guarantors – Creditors

• Client (Borrower/Guarantor) Database
• Creditor Database
• Borrower and Creditor databases independent from the loan itself
• Number of borrowers that can be entered in the system is triple (3x) the number of loans purchased with the license
• Multi-lender, Syndicated loans (Can include dozens/hundreds of Creditors / Reports participation of each)
• Co-Borrower(s) for a loan
• Guarantor(s) for a loan
• Employer Database
• Maximum Credit for all of a Borrower’s Loans
• Unlimited custom fields for Borrower, Creditor and Loan
• Multiple Loan Officers for a Creditor
• Metro 2 Credit reporting fields
• Add Notes or Attach files to a Borrower
• Import new Borrower data in bulk via spreadsheet
• Automatic import and update in near real-time of Borrower’s data via a JSON or Excel file through a Windows Service (API)
• Automatic Import/Export from/to Salesforce (CRM) of Borrower data (API)

International and Standards

• Multi-Currency / Convert to one currency
• Truth-in-Lending Act (USA)
• Canadian Regulations
• European Regulations
• Standard Interest Calculation Methodology (for most jurisdictions in the world)
• English & French Versions

Amortization Table

• Custom Payment Plans (Regular, Irregular, Principal and Interest, Interest-only, Fixed Principal, Lump Sum, Combination of these, Rate-Adjusted Payments, Recomputation of Payments, Interest Rate Changes)
• Additional Principal (Waterfall advances) to an existing Loan (Phased disbursements)
• Fees, Penalties, Insurance, Taxes (Add others and name as desired)
• Interest or No Interest on Added Principal, Fees, Penalties, Insurance and Taxes
• “Cash” or “non-cash” payment types for accounting (Adapt the payment types to your exact needs) (Example: Paid Visa, Paid Check, Admin Fees, etc.)
• Custom Additional Principal Types (Name as you wish)
• Payment Principal only
• Pay interest only and “in advance”
• Custom Paid Principal and Paid Interest (can be “In Advance”) types (name as you wish)
• Irregular Payments Management (Unpaid, Partial, Late)
• Automatic recomputation of payments after upstream changes (interest rate change, missed payments, balloon payments, etc.):
  • Interest-only payments
  • Fixed principal payments
  • Principal, interest and fee payments in order for the loan to be fully repaid (or with a residual value)
• Payment order/sequence
  • Regular method: Fees > Interest > Principal
  • You can manually alter this order
  • Special method (upon request): Interest > Expected Principal > Fees > Principal
• “Expected Principal” concept
• Interest payment can pay capitalized interest before current accrued interest (Advanced feature)
• End-of-month payments or on the 28, 29, 30, 31
• Custom interest regular “capitalization” date

Easy User Customization

• Custom Fields (Unlimited)
• Custom Scroll Menus
  • Import and update scroll menus via spreadsheet
• Customization of names and multiple standard fields
• Custom Record statuses
• Custom Dashboard (Main Window):
  • Set data displayed by user
  • Custom Display Record filters
  • Rename fields names shown in Main window
  • see portfolio trends and interesting data with Widgets
• Custom Transaction and Payment types (over 100 types)(Paid Cash, Paid EFT, Extra Pmt, etc.)
  • Set special attributes to these transaction types (must be >0.00,  <0.00 or =0.00)
• Custom Reports with hundreds of fields
• Custom columns (3 monetary, 3 numerical, 3 text) to enter extra loan information

Tools

• Post payment tool that allows batch posting
• Post paid, unpaid, partial and late payments, add Fees, add Comments, etc. “Unpay” paid payments in batch.
• Post/Update payments via an Excel sheet (Unique line ID for each payment or exact date and amount)
• Import regular and irregular payments (or extra Principal) in bulk from a simple Excel sheet. Add multiple other data for each payment (Comment, Note, etc.)
• API: Automatic data Import and Update (in real time) from third-party information systems by JSON or Excel sheet
  • Borrowers
  • Borrowers and Loans
  • Transactions
• Electronic signature with Xodo Sign  (formerly Eversign)
• Change future transaction data in bulk (with an Excel sheet)
• Send emails in bulk with templates
• Send SMS (text messages) in bulk with templates
• Record Sorting and Search
• Sort by multiple criteria
• Full database Search tool
• Record Sorting and Search
• Sort by multiple criteria
• Record Display Filter
• Record Notes (unlimited length)
• Notes timestamped by user and cannot be changed after 24 hours
• Record Notes on Individual Payment Lines
• History (Log) of Changes
• Document management – attach files to Loans / Borrowers
  • Add standardized document/file Types (tags) and Comment
  • Log of attached file activity
• Returned checks module
• Global import/changes in the database manually or via Excel sheet
• Bulk import and change data and fees in payment schedule (via Excel sheet)
• Mass change data in Payment schedule
• Quick Irregular payments entry
• Backup (automatic or one-click when needed)
• Sandbox (test environment) before updating to latest version

Alerts

• System Alerts, Line status Alerts, Record Alerts, Payment Line-specific Alerts, Conditional Alerts
• Send automatic reminders to Borrowers by Email (upcoming payments, unpaid payments, etc.). Create your own templates.
• Alerts can be sent via email or SMS internally (to other key personnel)
• Show and change Notes directly from Alerts
• Add Alerts from the Alerts module
• Send Emails and SMS automatically from the Alerts module to Borrowers
• Maximum credit for a Borrower for all his Active loans in the system
• Send invoices/statements (Document Merge) via Alerts window

Reporting – Invoices – Statements

• Custom Reports using over 1000 fields + Custom fields+ Equations you create
• Sorting and subtotals according to the chosen fields in the Record list.
• Automatic report creation (overnight or anytime) and import to third-party software (report generation with Windows Task scheduler)
  • Reports can be saved or sent via email automatically
  • Reports can be sent to FTP or secure FTP directory
• Create Advanced queries (include or exclude part of portfolio)
  • Include loans (for invoicing) only if payments are expected
• Executive Dashboard (Portfolio overview – number of records, amounts, averages and graphics)
• Transactions Report
• Financial Projections
• Contracts, Letters, Invoices, Statements (Custom Merges with your Word (DOCX or RTF) Documents)
• Produce DOCX, RTF or PDF documents
• Send Invoices / Statements in bulk by Email, attach to Record, save and print with one click
• Creditor/investor statements (including participation loans)
• Mathematical Equations: Add, subtract, multiply, divide… fields together
• Advanced Mathematical Equations including IF / IF NOT conditions
• Data fields classified by theme
• Standard Reports
• Detailed payment schedules (Including Quarterly, Yearly, Fiscal Year-end Totals)
• Monthly, Quarterly, Yearly Reports (or Between any Dates)
• Current Balances
• Escrow reporting
• Repayment Ratio
• Detailed Accounting Data (see below)
• Ageing report (current, 30, 60, 90… days late)
• Credit reporting (Metro 2) (with Credit Manager 5 by The Service Bureau)(USA and Canada)

APR Module

• Very sophisticated calculation for multiple APR scenarios
• Fees can be Paid up-front, Financed or Paid subsequently
• Paid Financed fees distribution by type

Accounting

• Accounting automatic refund order:
  • Fees, Interest, Principal
  • Order may me modified
  • Great flexibility for irregular orders
• Export Debits and Credits to your General Ledger (QuickBooks, Sage 50/300, Acomba, CSV, TXT, Excel)
• Over 350 accounting fields for reporting:
• Interest Accrued and Paid, Paid Principal, Outstanding Amounts, Principal Balance, Due Interest, Payment source, etc.
• Export to your GL as Lender or as Borrower
  • Accounting entries according to creditor participation
• Total Debits and Credits by account

Electronic Funds Transfer

• ACH with NACHA file for the United States
  • VoPay International payment processor in the US
• Automatic debit from bank account – Canada via ACCEO-Tranphere and VoPay International including e-Transfer (credit) to Borrowers
  • Automatic update of Affiliate Records when Master Records are updated
  • Automatic payment returns (NSF)
  • Cannot submit payments requests if more than x previous bounced payments
• Europe: SEPA EFT files (pain008.001.02 and pain008.001.08)
• South Africa – Direct debit with Standard Bank
• Other countries – development based on your needs

Fees, Insurance and Taxes

• Include fees, insurance or taxes with automatic recomputation based on:
  • Percent of loan balance
  • Percent of interest accrued
  • Percent of principal balance and days (same calculation as Simple interest)
  • Simply an amount set by user that can be changed as needed
• Fees can be added as columns (6 personalized columns) or as lines
• Column fees automatically generated according to the rules established by the Administrator
• Column Sales Taxes automatically eliminated for unpaid payments
• Escrow module
• Easily change Fees refund order
• Automatic fees based on number of days late
• Automatic fees according to the Record Type or a Custom field.
• Column fees paid automatically according to a preset refund order that can be modified

Web Features

• Bulk import loan applications and accept or decline (via JSON or Excel file). Keep history of all applications
• Automatic and real-time import of approved loans from your loan approval system via JSON or Excel
• Web Portal for your borrowers and investors to consult various data pertaining to their loan(s)(you decide on which data can be seen)
• Salesforce data exchange via our API
• Gmail and Microsoft family “OAut 2.0” protocol for sending emails
• On-line web application form (customized for each customer)(web – separate module from MLM)
• On-line loan approval tool (web – separate module from MLM)

Cool Features

• Customize your Dashboard (Main window) – important data for your needs
• Add Color to identify problem loans / Sort and Display by color
  • Change Color Name (Loan Labels)
• Add Color to payment lines
• Compulsory Fields
• Background tasks: automatic backups, current balance recomputation, alerts etc.
• Scan files directly in the software (then attach documents)
• Increase or decrease font size in the Dashboard, Payment schedule, Post payment window
• Spreadsheets directly in most reports
• 35+ shortcuts – view with F2
• Unique Identifiers for Borrowers, Creditors and Loans (to tie in to third-party software)
• Loan balance and Ageing report based on date – updated daily on Dashboard
• Obtain the amount payable by borrower at any date to get his payment schedule back on track
• Remembers last report dates
• Email mass sending test tool
• Multiple customizable field names
• System Notes in Main window

Investor Module (Participation / Syndicated Loans)(as an add-on module only)

• Manage complex multi-creditor (investor) investment scenarios including investments and divestments at various dates, pro-rated interest calculations and payment of interest and principal based on investment amounts and dates

Help

• Quick Tutorial directly in Margill
• Take a Quick Tour with one of our Experts
• Download a 30-day Trial
• Quick Start User Guide
• Short video guides
• Detailed User Guide (over 1200 pages!)(available upon request)
• Knowledge Base: margill.com/en/knowledge-base/
• Questions or having problems? Call or email.  We are there for you…