How can I enter multiple payments and advances in a loan without having to enter them one by one? I have over 100 in one loan. I have the data in Excel.

Q: How can I enter multiple payments and advances in a loan without having to enter them one by one? I have over 100 in one loan. I have the data in Excel.

A: Very easily, in seconds with a simple 4-column Excel sheet.

Go to Tools > Post Payments. On the top of the window, far right, you will see the “Bulk Payment Import” button. Of the two options, choose “Import new payments” (payments can be actual paid payments, upcoming payments, advances (additional principal), etc.)

The window will then show you the required Excel file format with the 3 required data columns and others that are optional:

  • Column A is the loan ID (this can be the MLM ID or your unique ID)
  • Column B is the Date
  • Column C is the amount (always positive)
  • Column D, in this case required since you are importing payments and advances, will specify what the amount is (a payment, what type of payment or an advance)

You can add additional information such as a line comment, a check number, other data, even that the payment should be a fixed principal payment (see the ?).

For Column D of the Excel file, you would specify what the amount is:

A Paid Payment would be a 4 in column D, and an advance would be a 14. If an amount is due but not yet paid, then this would be a 1 (so something in the future, not in the past).

 

Here is a sample Excel sheet with 2 advances (12,000 and 15,000), 5 Paid payments and 10 Due payments in the future:

The result is all good since no errors are shown. Errors would be shown in red with descriptions of whey they are in error (wrong dates, illogical scenarios, loan is not Active, etc.): To import press on “Insert lines”:

 

See also: Importing batch payments in Margill Loan Manager (CSV, Excel)

Can Margill software be used for HOA (Home Owners Association) collections along with the interest calculation?

Q: Can Margill software be used for HOA (Home Owners Association) collections along with the interest calculation?

A: Yes, very easily without needing an agency to do these calculations.

Many law firms and accountants are tasked with collecting HOA assessments and find it time consuming with a risk or error when this is done by hand or in a spreadsheet.

Option 1 – Low volume

Margill Law Interest Calculator can be used to do these calculations when there is a low volume (less than 20-25). You can even import the assessment amounts and dates as well as the payments made with a very simple 2-3 column Excel sheet.

Example of a HOA collection table where assessments are included as well as payments and attorney fees:

Nice need reports can also be produced in PDF formats that show how payments are applied.

Option 2 – Higher volume 

If your volume if greater than twenty or so cases (and can go to the hundreds or thousands), then Margill Loan Manager would be a better solution since all data is stored in a nice-neat database in which assessments, payments, attorney fees and costs can be added in bulk though a spreadsheet. You can also manage payments and collect through ACH payments – so you can actually service the HOA assessments. Furthermore, you can instantly provide your client with balances for all outstanding assessments.

For more information, please contact us at 1-877-683-1815 or by email support@margill.com

 

How to change the Windows Short date format

Margill prefers a date format that contains 4 digits for the year. This is especially important for calculations that may (if these still are out there!) predate the year 2000. How to change the Windows Short date format: Windows 10 gives you various ways to change the short date format (Control Panel or Settings) 1) […]

Can you walk me through how I would update MLM to the latest version on the Cloud?

Question:

My Margill Loan Manager is installed on a server on the Cloud.  It wants to have me input a path and so on, and I was not comfortable starting it. It also said to back up MLM data first, and I am not sure if that is necessary for me given that we have the server back-up every night.

Answer:

When all goes smoothly, an update should take 3-4 minutes.

If not already done, download the full update (for existing clients) at www.margill.com/get. Download from the remote server, not from your personal computer. This way, the installer will already be on the Cloud, as opposed to being on your PC.

Run the Margill Installer. It will ask for the path for the software installation. The default setting will usually be the last installation path or the C: drive which is where Margill is usually installed on the Cloud.

The Data (so where the database resides), when installed on C:\Program Files (x86) will usually be under C:\Program Data\MLM_Data.

If it is not there (as it usually should be), then an error will appear, and you will have to find the proper Data path. Search for the “DB” folder using the Windows search tool. Depending on who did the installation, data could be anywhere, so let’s hope the person who installed did a good, clean job!

ALWAYS do a backup. Everything should go smoothly with the update, but never take the chance; do a backup.

You will need basic knowledge of Windows to do this unless your paths are all properly configured.

If a client makes a payment, how do I feed that into the program?

Question:

Hi – I’ve been giving your software a trial, and really like it.

The only thing I haven’t been able to do is feed information into the ledger. For example, if a client makes a payment, how do I feed that into the program? How does it know when a payment hasn’t been made? And if someone makes a partial payment, does it automatically adjust the remaining payments?
Answer:
You will notice that when a schedule is created, the “Line status” for each line is “Due Pmt.” You then manage the payments as they are paid (or not paid) by changing this Line status to Paid, Unpaid, Partial payment, etc.

You can do this loan by loan. Or, a much much faster way, is to use the Post payment tool, probably the most important tool in software where you can batch update payments.

Post payment tool to batch update Due payments

The software usually does not recompute payments – it recomputes the interest for the remaining of the loan automatically. Fees can also automatically be added for unpaid payments for example – you create the rules (Tools > Settings > Administrator settings > Column Fees Automatic).
When a borrower does not pay, the loan will show a balance. You could also decide to recompute the payments, or you can extend the loan (after an agreement with the borrower). This can all be done with the powerful right mouse click.

Why are there two sets of Custom Fields in Margill Loan Manager?

Question:

Why are there two sets of Custom fields in Margill Loan Manager?

Read more