Moneylender Forums

When printing it's points – 96 per inch. There’s a ¼” (24 point) margin on the left edge of the report table. If printed to an 8.5” wide sheet, having combined column widths that total up to 768 should essentially fill the page and have the report be centered with ¼” on both sides. On the preview sc...

When sizing “width” columns in a report, what are the values based on? If I want to customize them.

You’ve got a few ways you might tackle it. Probably the easiest – set the interest to a Fixed Currency Amount. If you know the monthly interest on $296,000 is, say, $500/month, you can set the interest rate to 500 and set the rate type to Fixed Currency Amount. mlp-fixed-currency-interest.png Whenev...

I’m wondering if you would advise me on the best way to set up a loan with an construction escrow account. The borrower pays interest on the full loan amount, however, $32000 was withheld at closing to be dispersed as the project is completed. There is not a set draw schedule, rather the amounts are...

Your mail server rejected the messages. Try sending them one at a time. Maybe there’s some kind of throttling on how many emails you can send per hour or per day or something. Mail service providers put rate limits on emails (especially free accounts) to help prevent the spread of viruses and spam. ...

Oh, ok. So change the amount due column - make the column value be “amount due -minus- fees outstanding” and then the other formulas in the screenshots from my earlier reply work just fine. That way, your projection for the next year shows the total that becomes due, less the assumed late fees when ...

The report works well, but look like we should not include the outstanding fees. If we do, it will calculate $10*11 mos of pmt behind. Please advise.

The interest is the amount of earned, unpaid interest on the loan, and then the principal is the total due minus the interest. You can set up column values like: mlp-report-column1.jpg And subtract the fees, interest and escrow due from the total amount due. What’s left it the amount that would pay ...

Good morning,

i need to run a report for cash or short term loan receivable. As below, we can get total amount due, but can we aslo have two separate columns for accrued PRIN and INT?

Thank you.