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