|
Post by gaspilot on Oct 31, 2014 10:16:43 GMT
Since the new website came online I have a new problem with the dashboard calculations.
Surely the amount in ('Your Total Investment' + 'Your Bids') should equal (Amount Deposited + Interest + Cashback + Purchase Profit.)
Mine is out by £23.76 (after taking account of previous rounding errors).
I can't for the life of me fathom out where this money came from.
I tried exporting all of my transactions to date to an xls file.
I would have thought that the summation in the 'Amount' column would equal zero.
Mine came to just under -£7000. Why is that?
Any help or suggestions gratefully appreciated.
|
|
|
Post by Come_on_Grandad on Oct 31, 2014 10:53:59 GMT
Since the new website came online I have a new problem with the dashboard calculations. Surely the amount in ('Your Total Investment' + 'Your Bids') should equal (Amount Deposited + Interest + Cashback + Purchase Profit.) Mine is out by £23.76 (after taking account of previous rounding errors). I can't for the life of me fathom out where this money came from. I tried exporting all of my transactions to date to an xls file. I would have thought that the summation in the 'Amount' column would equal zero. Mine came to just under -£7000. Why is that? Any help or suggestions gratefully appreciated. As far as the dashboard is concerned, the biggest problem is that it doesn't reflect the value that you have in settled bids (less shadow bids), nor the pending adjustment for FF principal. That's not going to help you being out by 23 pounds. For me, dashboard 'Total Investment' = cash account balance + MLIA 'total investment'. As far as summing your cash account statement, you should find that by filtering out those entries with a status of deleted, the amounts sum to your cash balance. Deleted entries occurred when bids made on auctions that subsequently failed were returned to you. Here is your history of deposits, withdrawals, interest, cashback etc pre-transition. Your MLIA statement should reflect everything since transition.
|
|
mikes1531
Member of DD Central
Posts: 6,453
Likes: 2,320
|
Post by mikes1531 on Oct 31, 2014 13:32:42 GMT
Your MLIA statement should reflect everything since transition. Wouldn't any post-transition deposits or withdrawals end up on the cash statement? Or does that not matter because the money for those has to be transferred into or out of the MLIA in order to be used -- except for the settlement of shadow bids?
|
|
|
Post by Come_on_Grandad on Oct 31, 2014 13:55:32 GMT
Your MLIA statement should reflect everything since transition. Wouldn't any post-transition deposits or withdrawals end up on the cash statement? Or does that not matter because the money for those has to be transferred into or out of the MLIA in order to be used -- except for the settlement of shadow bids? You're right - where to look for post transition activity is not as straightforward as I claimed. Especially if, as I understand it, the default "reinvest repayments" no longer applies.
|
|
|
Post by cyrilmadrid on Oct 31, 2014 22:55:20 GMT
I just realised that indeed, the settled accepted bids are not included in Your Total Investment, which does not make sense. I was trying to understand why my total investment was down a few kGBP, I understand now. Hopefully the issue will disappear when all these settled bids transform into loan parts, and no new settled bids should be created if auctions disappear.
|
|
shimself
Member of DD Central
Posts: 2,563
Likes: 1,171
|
Post by shimself on Nov 1, 2014 11:39:33 GMT
I just realised that indeed, the settled accepted bids are not included in Your Total Investment, which does not make sense. I was trying to understand why my total investment was down a few kGBP, I understand now. Hopefully the issue will disappear when all these settled bids transform into loan parts, and no new settled bids should be created if auctions disappear. There's nothing to stop AC from displaying these (settled bids) on the dashboard somewhere and including them in the total. I expect I'm not the only one to have had a panic attack.
|
|
|
Post by chielamangus on Nov 1, 2014 16:25:48 GMT
There is another issue with the interest total (under tax statement) not counting anything after Oct 17th. My interest is the same on the 17th as on the 31st Oct. I have not yet checked whether the figure to Oct 17th & it is correct to within a penny.
I will give Chris a break for the weekend and contact him on Monday about this.
|
|
|
Post by gaspilot on Nov 1, 2014 16:42:11 GMT
There is another issue with the interest total (under tax statement) not counting anything after Oct 17th. My interest is the same on the 17th as on the 31st Oct. I have not yet checked whether the figure to Oct 17th is correct. I will give Chris a break for the weekend and contact him on Monday about this. I think I might have the same problem. The amount of interest I accrued in October is less than half of previous months, with very little change in loans to account for it. I think I'm going mad with all the difficulties of this new website.
|
|
|
Post by chielamangus on Nov 1, 2014 16:57:43 GMT
Wrong interest - I think the issue is simply related to the MIA. The original tax calculation would have picked up the interest data from the cash account, but for this month it should pick it up from both accounts, which it hasn't. And for future months it should drop the cash account and pick the data up from the other accounts - manual, green, bespoke ...
|
|
|
Post by chris on Nov 2, 2014 8:30:35 GMT
Wrong interest - I think the issue is simply related to the MIA. The original tax calculation would have picked up the interest data from the cash account, but for this month it should pick it up from both accounts, which it hasn't. And for future months it should drop the cash account and pick the data up from the other accounts - manual, green, bespoke ... Thanks for figuring this one out. Believe this is already on our radar but I will flag it again with the relevant developer.
|
|
|
Post by chielamangus on Nov 2, 2014 10:45:07 GMT
Wrong interest - I think the issue is simply related to the MIA. The original tax calculation would have picked up the interest data from the cash account, but for this month it should pick it up from both accounts, which it hasn't. And for future months it should drop the cash account and pick the data up from the other accounts - manual, green, bespoke ... Thanks for figuring this one out. Believe this is already on our radar but I will flag it again with the relevant developer. Turn off that mobile at the weekend, Chris ! I'll bet that's what your wife says as well. We don't (well, I don't) expect a 24/24 7/7 service. You must take a break sometime.
|
|
|
Post by chris on Nov 2, 2014 10:47:53 GMT
Thanks for figuring this one out. Believe this is already on our radar but I will flag it again with the relevant developer. Turn off that mobile at the weekend, Chris ! I'll bet that's what your wife says as well. We don't (well, I don't) expect a 24/24 7/7 service. You must take a break sometime. She's just spending time with her family and is happy for me to be occupied elsewhere. I'll take a break when the green amount is launched and I'm happy there are no other display issues or urgent usability fixes required. That said I do need to walk the dog now.
|
|
|
Post by gaspilot on Nov 3, 2014 17:49:08 GMT
I do now have some interest from 18th October but the amount is very small. By my calculation I should have received about £270 in October and the amount I did receive was £123.55. There appears to be yet another anomaly here.
|
|
mikes1531
Member of DD Central
Posts: 6,453
Likes: 2,320
|
Post by mikes1531 on Nov 3, 2014 19:33:29 GMT
I do now have some interest from 18th October but the amount is very small. By my calculation I should have received about £270 in October and the amount I did receive was £123.55. There appears to be yet another anomaly here. My Tax Report shows my interest from 18-31 October is about half that from 1-17 October. But that could be because more of my loans have repayments due on 1-17 of the month. I've looked at September, and there I also have a lot more from 1-17 than from 18-30. So the good news is that the two months look similar. The bad news is that I can't tell easily whether either month is correct. I could download my detailed statement and probably determine whether the data in the tax report is consistent with the data from the statement, but is it worth the effort?
|
|