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

Handling payments and adjustments, running reports, doing your accounting with Moneylender.
Post Reply
wtech_josh
Site Admin
Posts: 37
Joined: Tue Jul 30, 2019 7:17 pm

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

Post by wtech_josh » Wed Jul 08, 2020 2:01 pm

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 262 times

wtech_josh
Site Admin
Posts: 37
Joined: Tue Jul 30, 2019 7:17 pm

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

Post by wtech_josh » Wed Jul 08, 2020 2:02 pm

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 261 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 261 times

wtech_josh
Site Admin
Posts: 37
Joined: Tue Jul 30, 2019 7:17 pm

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

Post by wtech_josh » Wed Jul 08, 2020 2:03 pm

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
Site Admin
Posts: 37
Joined: Tue Jul 30, 2019 7:17 pm

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

Post by wtech_josh » Wed Jul 08, 2020 2:04 pm

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.

Post Reply