Greetings,
Running: 5.1.80-a486847 Build 3606 on Windows
I have 3 loan accounts I’ve created Loan reports for under KMM/Reports/Transactions. These accounts are tied together through refinance, meaning at the end of the term of a loan, I transferred the balance to the next loan.
I have a Loan Transactions report combining all 3 accounts and for some reason, the balance transfer from the first account to the second account appears to be in reverse as per below (all 3 loan accounts showing from the report and I cut the ledger entries to save space):
The first loan account had a closing balance of 199,116.18 which when transferred to the new loan for refinance appears to show reversed in/out entries, leading to doubling the closing balance instead of zeroing it.
Any ideas what could be causing this? I looked up in the XML but could not find any obvious errors.
Thanks for your help!
P.S. I had more images showing the ledger entries which match the report, and report settings, however since I’m a first time poster there is a limitation and could not include them.
There does seems to be something odd about which columns the report uses for the numbers, and whether they are reported as positive or negative. All the routine loan payments show up as negative, and decrease the balance, but that last payment shows up as positive and increases the balance, although the final balance (2024-12-31) does show 0.00. (I found similar issues in my own loan transaction report, although I don’t have any “sequential” loans like yours. I’m going to need some time to dig into this, probably tracing through the logic of the reporting code.
Let me know if I can be of assistance as I’ve spent some time digging through the XML and trying different report parameters to track this down. I’ve also changed around some transactions however the result is always the same.
The assumption was a malformed XML or inconsistency in the Transactions but I’ve pretty much eliminated this possibility at this point.
Please run a regular transaction report, but limit the accounts to only those three loan accounts. If I’m right, they will look OK. I am beginning to suspect an issue in how the transaction loan report specifically assigns values within the transaction to the columns in the report, and whether it might be adjusting sign, possibly incorrectly, possibly depending on how many accounts and how many splits there are in the transaction. I’m hoping I can create a sample data file which demonstrates the problem - possibly with loan accounts which do not use schedules.
Here is what I did:
Using this:
I generated a report with the 3 accounts with the date range ‘all time’ and:
Result:
Which is exactly what we’re expecting vs. what we’re seeing with the loan Roport.
Can you try if updating to at least build 3644 solves the issue?
The issue I saw in one of my three loan accounts is gone with today’s build from git master. Hopefully it also works for tcpsorcerer’s.
Can confirm issue is resolved. Awesome work 
P.S. tested in build 3649
Greetings,
I previously missed this: the Interest column total is blank. Is that a bug or feature? Seems to be present on all builds I have, including 3649 from version 5 all the way back to 4.8.3 stable.
Image from 3649
Speaking of which, I just noticed that in 4.8.3 the Payment column is populated unlike in all the builds I have from v5
Image from 4.8.3 stable
Payment column is fixed with this commit.
