littleoldlady
Member of DD Central
Running down all platforms due to age
Posts: 3,045
Likes: 1,862
|
Post by littleoldlady on Oct 7, 2016 22:38:01 GMT
My use of this platform has been very simple as I have never bought any loans. I have transferred cash into the cash a/c and also directly into the QAA. I have also invested in the 30 day account, and withdrawn it into the cash a/c. Cash has been swept from the cash account into the QAA. I have withdrawn cash from the platform.
On my QAA statement I see the following transaction types:
a Deposit (positive) b Instant withdrawal from QAA (positive) c Inter account transfer from cash account (positive) d Inter account transfer to cash account (negative) e Interest payment for Quick Access Account for month (positive) f Investment into qaa direct from Quick Access Account (negative) g Investment into Quick Access Account (negative)
I presume that some arithmetic combination of these figures will give me my balance but I can't see what it is. Can someone tell me what each type is and how to combine them?
|
|
ilmoro
Member of DD Central
'Wondering which of the bu***rs to blame, and watching for pigs on the wing.' - Pink Floyd
Posts: 11,330
Likes: 11,549
|
Post by ilmoro on Oct 8, 2016 0:32:53 GMT
My use of this platform has been very simple as I have never bought any loans. I have transferred cash into the cash a/c and also directly into the QAA. I have also invested in the 30 day account, and withdrawn it into the cash a/c. Cash has been swept from the cash account into the QAA. I have withdrawn cash from the platform. On my QAA statement I see the following transaction types: a Deposit (positive) b Instant withdrawal from QAA (positive) c Inter account transfer from cash account (positive) d Inter account transfer to cash account (negative) e Interest payment for Quick Access Account for month (positive) f Investment into qaa direct from Quick Access Account (negative) g Investment into Quick Access Account (negative) I presume that some arithmetic combination of these figures will give me my balance but I can't see what it is. Can someone tell me what each type is and how to combine them? Difficult to do without figures but... all transactions should be in pairs and you only normally want one of each pair, though it can depend on your reinvestment settings. The QAA is basically two concentric circles. The inner is the money in the proper QAA earning interest, the outer is the money in transit, either going in or coming out (if the QAA is full its also where direct invest money queues) Anything you do will therefore have two statement entries, one for the outer and one for the inner. Entries relating to cash going into the outer circle are positive.So if you make a deposit, receive interest or transfer funds from cash account or inner circle, there will be a positive entry in the statement types a, b, c, e. Money moving out of the outer circle to cash, type d, or into inner circle, type f, g, are negative. a Deposit (positive) Cash from external A/C into outer circleb Instant withdrawal from QAA (positive) Cash from inner circle to outerc Inter account transfer from cash account (positive) Cash from cash A/C to outerd Inter account transfer to cash account (negative) Cash from outer to cash A/Ce Interest payment for Quick Access Account for month (positive) Interest paid by Assetz into outer circle f Investment into qaa direct from Quick Access Account (negative) Cash from outer to inner (refers to sums already in QAA environment eg interest or queued funds)g Investment into Quick Access Account (negative) Cash from outer to inner circle (has an external source originally) To work out the balance of the account in normal circumstances we are only interested in transactions in and out of the inner circle f, g & b, everything else should mirror one of these. So to work out balance for month B, take balance at end of month A, add total of transactions type f,g (ignore minus) and deduct total of type b. The complication is if the QAA has hit its cap then there will be cash in the outer circle not earning interest. Interest earning balance in inner circle is calculated the same but to get the balance of cash assigned directly to QAA you would need to include any transactions a, c, d, e that dont have a mirror transaction b, f, g. Not an issue at the moment. The above only applies to direct invested funds, anything being swept would need to be calculated separately and has an interest entry into the parent account. I should also add I havent actually used the above, logically it seems correct but its untested. Dont have time.
|
|
pikestaff
Member of DD Central
Posts: 2,187
Likes: 1,546
|
Post by pikestaff on Oct 8, 2016 6:55:37 GMT
littleoldlady If you just want to know your balance, why struggle with the transaction reports? The balance is there for you on the Dashboard, top right (your total investment). The only thing I ever do with the transaction reports is look ay my recent MLIA transactions to see what the system's been buying for me.
|
|
skippyonspeed
Some people think I'm a little bit crazy, but I know my mind's not hazy
Posts: 787
Likes: 424
|
Post by skippyonspeed on Oct 8, 2016 9:17:42 GMT
Every transfer between different accounts will have at least 2 lines, straight forward ones will have just 2, a positive and a negative
If say for example you want to transfer £2.00 from your QAA to 30 day AccCash out QAA -£2.00 Cash in 30day acc. +£2.00 If for example you have elected to put all cash awaiting investment to be swept into QAA and there is no room for all of it in the final destination at the time Example-: £100.00 from 30 day Acc to MLIA, but in this case only £30.00 is up for grabs at that moment. This will have 5 lines Cash out 30 day Acc -£100.00
Cash in MLIA +£30.00
Cash in QAA +£70.00 The final lines of this transaction could be separated by non connected different 2 line transaction eg interest from MLIA to QAA Cash out QAA -£70.00 Cash In MLIA +£70.00
All simple transfers ie no sweepings come in pairs
I have shortened the terminology to try to make it look less daunting!!!!
|
|
littleoldlady
Member of DD Central
Running down all platforms due to age
Posts: 3,045
Likes: 1,862
|
Post by littleoldlady on Oct 8, 2016 9:19:55 GMT
Crikey! ilmoro did you work all that out by yourself? Respect!! pikestaff why bother? Firstly if you trust the platform to get things right then I guess you don't use some of the other platforms that I do. Secondly I am not getting anywhere near the advertised rate. This may be due cash queuing to get in when the QAA is full, or cash staying in the cash account when I expect it to go into the QAA. I am sure that for a month it was showing an amount in the cash account but that amount was also included in the total showing as in the QAA (this was my total investment in the platform except for some interest on the interest from the 30 day account). So I am trying to get to grips with what is going on. I am attracted by the low risk and liquid 3.75% but I find the whole process very opaque. On another tack how can I ever clear out the 30 day account completely?
|
|
pikestaff
Member of DD Central
Posts: 2,187
Likes: 1,546
|
Post by pikestaff on Oct 8, 2016 9:55:25 GMT
Crikey! ilmoro did you work all that out by yourself? Respect!! pikestaff why bother? Firstly if you trust the platform to get things right then I guess you don't use some of the other platforms that I do. Secondly I am not getting anywhere near the advertised rate. This may be due cash queuing to get in when the QAA is full, or cash staying in the cash account when I expect it to go into the QAA. I am sure that for a month it was showing an amount in the cash account but that amount was also included in the total showing as in the QAA (this was my total investment in the platform except for some interest on the interest from the 30 day account). So I am trying to get to grips with what is going on. I am attracted by the low risk and liquid 3.75% but I find the whole process very opaque. On another tack how can I ever clear out the 30 day account completely? Those are rather different points from your OP which was asking about the balance. You don't need the transaction reports for that. As it happens I am comfortable enough with AC not to feel the need to go through everything but the vast majority of my money is in the MLIA which is more transparent. I do reconcile my TC accounts every month. The only money of mine that is showing in two places on AC is cash swept from the MLIA to the QAA, which is correctly included only once in my account total. I'm pretty sure that anything showing in cash won't also be in another account, but you can check this from the dashboard by adding up the balances. [Edit: This must have been wrong as it's evident from comments below that it is possible to sweep from Cash to QAA, which would show up in both places. This is not something I've done, because I put all my cash into the MLIA and have it swept from there.] AFAIK all funds in the QAA and 30 day account earn the stated rate except for queued funds, and I've not seen any complaints that they don't (unlike the GBBA and GEIA, which work differently) but I don't use the 30 day account at all so I'm not really qualified to comment on that.
|
|
ilmoro
Member of DD Central
'Wondering which of the bu***rs to blame, and watching for pigs on the wing.' - Pink Floyd
Posts: 11,330
Likes: 11,549
|
Post by ilmoro on Oct 8, 2016 10:20:02 GMT
Crikey! ilmoro did you work all that out by yourself? Respect!! On another tack how can I ever clear out the 30 day account completely? Finished my post. The hardest part is finding a way to explain it. Oh and might be wrong as its untested but makes sense to me. One point is you have to split your QAA balance between swept and direct funds - click on show more for the breakdown, only direct funds show in the QAA statement and generate the interest that appears in that statement. Swept funds will have an interest entry for QAA in their own accounts. How to clear out 30DAA? Turn off reinvestment, set a withdrawl target greater than investment, then wait until it reaches below 40dp - probably. Ive been trying to empty GBBA for a while but that has the issue of non-tradeable loans. I dont have any direct invest funds, just swept from MLIA/cash as I dont have enough funds on platform to require it and like pikestaff I tend to just trust AC to get it right. Far to complicated to calculate as everything is constantly shifting in nanopence amounts.
|
|
duck
Member of DD Central
Posts: 2,880
Likes: 6,960
|
Post by duck on Oct 8, 2016 10:57:14 GMT
I have to admit that when I started p2pindependentforum.com/thread/6663/cash-account-qaa-statements-confused I was trying to be intelligent and make my spreadsheet read across the various 'account statements', reconcile the entries and project interest. I got as far as MILA, QAA and GBBA and then decided there was more to life than adding in QAA direct ..... Not the easiest of tasks even for somebody that 'enjoys a good spreadsheet' ....
|
|
littleoldlady
Member of DD Central
Running down all platforms due to age
Posts: 3,045
Likes: 1,862
|
Post by littleoldlady on Oct 8, 2016 11:33:40 GMT
Until 2nd Oct I had not recently accessed my account much. I knew I had about £20k on the platform and I believed it was all in the QAA. I had set it up to sweep cash from the cash account into QAA. I vaguely remember seeing at one time on the dashboard c£10k in the cash a/c and c£20k in the QAA which struck me as odd as I only had a total of c£20k. Then on 2nd Oct I noticed that I was only getting interest on half the money so tried a transfer from the cash account to the QAA.
Below is my cash a/c statement. Monies have been swept from cash into QAA but somehow on 2nd Oct there was £10k still in the cash a/c which I had to transfer manually and have received no interest for 3 months. What have I done wrong?
DATE DESCRIPTION CREDIT / DEBIT
2nd Oct 2016 at 19:12 Inter account transfer to product Quick Access Account (5) £-10,124.71
2nd Oct 2016 at 19:12 Instant withdrawal from Quick Access Account (5) £10,124.71
2nd Oct 2016 at 10:26 Investment into qaa swept from cash £-31.54
2nd Oct 2016 at 10:26 Interest payment for Quick Access Account for month 2016-09 @ 3.75% per annum £31.54
1st Sep 2016 at 00:30 Investment into qaa swept from cash £-31.38
1st Sep 2016 at 00:30 Interest payment for Quick Access Account for month 2016-08 @ 3.75% per annum £31.38
22nd Aug 2016 at 20:15 Investment into qaa swept from cash £-27.95
22nd Aug 2016 at 20:15 Inter account transfer from product 30-Day Access Account (7, 673) £27.95
1st Aug 2016 at 17:06 Investment into qaa swept from cash £-9.60
1st Aug 2016 at 17:06 Interest payment for Quick Access Account for month 2016-07 @ 3.75% per annum £9.60
31st Jul 2016 at 16:23 Investment into qaa swept from cash £-24.24
31st Jul 2016 at 16:23 Inter account transfer from product Quick Access Account (5) £24.24
24th Jul 2016 at 10:30 Investment into qaa swept from cash £-9,999.99
24th Jul 2016 at 10:30 Inter account transfer from product 30-Day Access Account (7, 476) £9,999.99
|
|
ilmoro
Member of DD Central
'Wondering which of the bu***rs to blame, and watching for pigs on the wing.' - Pink Floyd
Posts: 11,330
Likes: 11,549
|
Post by ilmoro on Oct 8, 2016 12:48:47 GMT
Until 2nd Oct I had not recently accessed my account much. I knew I had about £20k on the platform and I believed it was all in the QAA. I had set it up to sweep cash from the cash account into QAA. I vaguely remember seeing at one time on the dashboard c£10k in the cash a/c and c£20k in the QAA which struck me as odd as I only had a total of c£20k. Then on 2nd Oct I noticed that I was only getting interest on half the money so tried a transfer from the cash account to the QAA. Below is my cash a/c statement. Monies have been swept from cash into QAA but somehow on 2nd Oct there was £10k still in the cash a/c which I had to transfer manually and have received no interest for 3 months. What have I done wrong? DATE DESCRIPTION CREDIT / DEBIT 2nd Oct 2016 at 19:12 Inter account transfer to product Quick Access Account (5) £-10,124.71 transfer to direct QAA and earning QAA rate (next entry should be 1 day interest on this sum c£1.04)2nd Oct 2016 at 19:12 Instant withdrawal from Quick Access Account (5) £10,124.71 removed from earning QAA rate2nd Oct 2016 at 10:26 Investment into qaa swept from cash £-31.54 as below*2nd Oct 2016 at 10:26 Interest payment for Quick Access Account for month 2016-09 @ 3.75% per annum £31.54 one months interest on £100931st Sep 2016 at 00:30 Investment into qaa swept from cash £-31.38 as below*1st Sep 2016 at 00:30 Interest payment for Quick Access Account for month 2016-08 @ 3.75% per annum £31.38 one month interest on £10034 + 8days on £2822nd Aug 2016 at 20:15 Investment into qaa swept from cash £-27.95 *still in cash but earning at QAA rate22nd Aug 2016 at 20:15 Inter account transfer from product 30-Day Access Account (7, 673) £27.95 transfer of residual 30DAA account to cash 1st Aug 2016 at 17:06 Investment into qaa swept from cash £-9.60 still in cash but earning at QAA rate1st Aug 2016 at 17:06 Interest payment for Quick Access Account for month 2016-07 @ 3.75% per annum £9.60 Interest on 10k in cash account for 8days (high so assume a larger sum earlier in cash A/C earlier in July)31st Jul 2016 at 16:23 Investment into qaa swept from cash £-24.24 still in cash but earning at QAA rate31st Jul 2016 at 16:23 Inter account transfer from product Quick Access Account (5) £24.24 moved from QAA to cash24th Jul 2016 at 10:30 Investment into qaa swept from cash £-9,999.99 still in cash but earning at QAA rate24th Jul 2016 at 10:30 Inter account transfer from product 30-Day Access Account (7, 476) £9,999.99 moved from 30DAA to cashThis is your cash statement not your QAA statement. The transactions on 24/7 is a withdrawl from 30DAA to cash, that money is then swept into the QAA but it isnt actually literally in the QAA, its nominally in QAA so earning QAA rate, so there wont be any entries in the QAA statement for it and any interest payments will show in the cash account. You have recieved interest on it, entires 1/8, 1/9/ 1/10 is the interest for this plus any other money in the cash account. Over the last 3 months the amount in cash account has increased with interest on these swept funds. Now you have moved this money directly into the QAA. Going forward there will only a small amount of interest paid from QAA into the cash. account, just the earning from the 1 day before you transferred the 10k, plus any interest on that if you dont invest it directly each month. The QAA entry on the dashboard shows the total investment in the QAA both direct and swept funds, in order to see the split between the two you have to click show more which then displays separate totals for each element. You should also have a QAA statement which I assume will show a direct investment of £10k and monthly interest paid on that. Add the interest from cash and QAA statements to get your total interest earnt on the 20k. Now you have moved the £10k from cash directly into the QAA all interest will appear in the QAA (bar the odd residual earning I mentioned above) You also seem to have transferred money (interest) from direct QAA and 30DAA accounts in Jul/Aug to the cash account. As far as I can tell all your money has been earning at QAA rate.
|
|
littleoldlady
Member of DD Central
Running down all platforms due to age
Posts: 3,045
Likes: 1,862
|
Post by littleoldlady on Oct 8, 2016 14:34:40 GMT
ilmoro thank you so much for helping me with this, you are a star! It's all too complicated for me but I take great comfort from your final sentence. If you are now bored with this (and I certainly would not blame you) then ignore the rest. I would have thought that money in the cash account would be subject to client account rules, whereas money in the QAA is an investment. If as you say I managed to have money in the risk free cash account but earning the same rate as in the unprotected QAA then why oh why did I move it?
|
|
ilmoro
Member of DD Central
'Wondering which of the bu***rs to blame, and watching for pigs on the wing.' - Pink Floyd
Posts: 11,330
Likes: 11,549
|
Post by ilmoro on Oct 8, 2016 15:12:59 GMT
ilmoro thank you so much for helping me with this, you are a star! It's all too complicated for me but I take great comfort from your final sentence. If you are now bored with this (and I certainly would not blame you) then ignore the rest. I woulhd have thought that money in the cash account would be subject to client account rules, whereas money in the QAA is an investment. If as you say I managed to have money in the risk free cash account but earning the same rate as in the unprotected QAA then why oh why did I move it? Happy to help, though I should add everything is just my interpretation of the info provided. You are right IMHO there is no advantage in having any sum less than £25k directly invested in QAA. The only benefit of direct QAA investment is it jumps to the head of the queue when the account cap is reached. Did have this conversation with Chris a while back and I dont recall him offering a different interpretation but its still a little vague how money can be invested but not invested so to speak.
|
|
pikestaff
Member of DD Central
Posts: 2,187
Likes: 1,546
|
Post by pikestaff on Oct 8, 2016 16:21:50 GMT
... ilmoro If as you say I managed to have money in the risk free cash account but earning the same rate as in the unprotected QAA then why oh why did I move it? Money swept from cash to the QAA is actually in the QAA and earning interest there, despite the fact that (i) it appears in the cash balance too, and (ii) the interest is posted to the cash account. It's not risk free. It is an investment and is exposed to the same risks as any other investment in the QAA.
|
|
littleoldlady
Member of DD Central
Running down all platforms due to age
Posts: 3,045
Likes: 1,862
|
Post by littleoldlady on Oct 8, 2016 17:59:29 GMT
... ilmoro If as you say I managed to have money in the risk free cash account but earning the same rate as in the unprotected QAA then why oh why did I move it? Money swept from cash to the QAA is actually in the QAA and earning interest there, despite the fact that (i) it appears in the cash balance too, and (ii) the interest is posted to the cash account. It's not risk free. It is an investment and is exposed to the same risks as any other investment in the QAA. Thanks pikestaff. Bizarre that it appears in a different account (I presume a Client Funds a/c) from the risky one it actually is in.
|
|