Accrued Interest

Most interesting.  I've done the export, and the sold unit does indeed appear there.  So that's very useful.  Thanks for the tip.

Even more interesting is that I found that the list included a number of South Manchester 2nd Extension units that I had sold that were not shown as Completed and still had accrued interest!  Accrued interest on sold units should be paid to the seller when the next repayment is received, and it looks like that didn't happen here -- possibly because the next payment on the loan was the redemption rather than a 'normal' payment?  I would suggest that anyone else who has sold units in loans in the period immediately before the loans' redemptions needs to check to see if they have accrued interest outstanding as well.  In the case of South Manchester, since the accrued interest was building up at the 24% default rate, the amounts involved could be substantial.

I think this is something chris needs to look into.  The issue would appear to be generic rather than specific to me, so I presume he can see the issue without our having to inundate him with specific data from each of our accounts.  No doubt he'll ask if he needs more info from us.

Finally, I'll note that the reason the possible failure to pay the interest on previously sold units wasn't obvious on our statements is the recent change to reporting interest as a single lump for each loan.  Until that change -- within the last week -- there would have been one line for the interest on units currently being held, and  separate lines showing the deferred interest being paid on units sold since the last payment was credited.  Without those separate lines, we have to trust that AC have paid us the deferred interest we're owed, whereas my downloaded data appears to suggest that they didn't.

chris:  The former -- I don't think I have the capability to do the latter because my account is too complicated for me to keep track of properly, especially as I've been quite active in the Aftermarket.  So I'm relying on AC to do the accounting correctly.  I realise that's not the best way to operate an investment account, but that's the situation. 

I took a stab at making a very rough estimate of how much South Manchester interest I should have received on Thursday evening, but it's rather difficult, to say the least, when I don't know exactly how much of the loan I was holding when the second extension of the loan started, and I can't easily trawl through my very long statement to see how many units of it that I bought and sold before it finally was paid off.  Having said that, though, the sort of number I come up with is much closer to the amount of interest I did receive than it would be if I had received what I did plus all the accrued interest still showing in the loan unit download CSV file.  So it could well be that the problem is one of display rather than accounting if it turns out that you find that the resetting of accrued interest on repaid loans indeed had been overlooked.

I'm hopeful that someone else here who is much better at keeping track of their account will be able to tell whether or not the interest still showing as accrued on sold South Manchester units has been paid to them already, and thus be able to determine whether the issue I raised is significant or insignificant.

I'm good, was confident it was working as I spent a lot of time on the recursive query that powers the payments.  Can't do much where I am at the moment but in the next few days I'll fix the figures in the spreadsheet.

It auto corrected overnight, just couldn't see why that one failed to reset when the others worked ok.

Apparently not if the Loan Units downloaded CSV is working as it should.  And I think chris is going to make a change shortly which should fix the problem discussed near the top of this page of this thread.