Entries by Marc Gelinas
Early payoff – How to do this in Margill Loan Manager
Q: How to do an early payoff in Margill Loan Manager A: For example, the loan term was originally for 5 years or 60 months (so end date was in June 2020). The borrower calls you, the creditor, and wishes to payoff his/her loan early, on October 12, 2018. Original payment schedule: I first […]
Loan Servicing with Excel? Pitfalls and alternatives
Loan Servicing with Excel? Pitfalls and Alternatives I’m a great fan of Excel. I think it is the most important and useful software ever developed. I first started using spreadsheets many years ago with Lotus 123 which was a great tool that lost the spreadsheet war to Microsoft. Excel can be used in so many […]
Margill Loan Manager: Is there an audit trail that can be printed to show transactions / changes to records on a daily basis?
Q: Is there an audit trail that can be printed to show transactions / changes to records on a daily basis? A: Yes very easily. Go to the Main Margill window, select all the loans (probably only Active loans) , Tools > Various > Display the history of changes for selected Records. You can then […]
How to obtain the daily interest amount (per diem) in Margill Loan Manager
Q: How to obtain the daily interest amount (per diem) in Margill Loan Manager? A: This can be added very easily through a simple Mathematical Equation. Go to Reports > Equation Management and click on Name the Equation Select the two required fields (balance and interest rate) from the various themes on the left Add […]
Margill Law/Standard Edition – Regular and Irregular payment schedule
Question: I was wondering who I could contact at Margill for help on calculating a rather complex amortization table. Beginning on 6/25/17 – the principal loan amount was $640,000 at an interest rate of 3% – payments of $3,000 to begin on 1/1/2018. However, a payment of $350,000 was made on 7/12/2017 Additional loan amount […]
Can Margill Loan Manager be used to manage rentals (rent)?
Question: Our company does loans and rentals. Can Margill Loan Manager be used to manage rentals (monthly rents)? Answer: As strange as this may sound for a loan servicing software, yes Margill Loan Manager can manage rentals. The difference between a loan and a rental is that loans begin with a principal amount borrowed that […]
A little banking humor! His name was Boudreaux…
His name was Boudreaux. He was from Cutoff, Louisiana … and he needed a loan, So…….. He walked into a bank in New York City and asked for the loan officer. He told the loan officer that he was going to Paris for an International Cajun festival for two weeks and needed to borrow $5,000, and that he was not a […]
Importing batch payments in Margill Loan Manager (CSV, Excel)
Question: Our company collects weekly (bi-weekly or monthly – no matter) payments drawn directly from their bank accounts in some cases and in others as payroll deductions. We receive CSV files from the bank and processors. Can these transactions then be imported back to Margill Loan Manager? Answer: As you guessed, since I blogged this, […]
Margill Loan Manager: Is there a way for me to see if users are logged on to the system?
Question: Is there a way for me to see if users are logged on to the system? Answer: Go to Tools > Users and see this: