Page 1 of 1

Report for cash or short-term loan receivable (one year projection)...

Posted: Wed Jul 08, 2020 2:01 pm
by wtech_josh
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.
mlp-report-projection.jpg
mlp-report-projection.jpg (69.95 KiB) Viewed 31878 times

Re: Report for cash or short-term loan receivable...

Posted: Wed Jul 08, 2020 2:02 pm
by wtech_josh
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
mlp-report-column1.jpg (94.1 KiB) Viewed 31877 times
And subtract the fees, interest and escrow due from the total amount due. What’s left it the amount that would pay down principal:
mlp-report-column2.jpg
mlp-report-column2.jpg (124.21 KiB) Viewed 31877 times

Re: Report for cash or short-term loan receivable...

Posted: Wed Jul 08, 2020 2:03 pm
by wtech_josh
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.

Re: Report for cash or short-term loan receivable one year projection...

Posted: Wed Jul 08, 2020 2:04 pm
by wtech_josh
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 no payments have arrived.