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

[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 (69.95 KiB) Viewed 46778 times

[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 (94.1 KiB) Viewed 46777 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 (124.21 KiB) Viewed 46777 times

[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.

[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.