Loanbook analysis (Z)

The difference is probably mainly uninvested money, in the queue to lend (which is quite slow at present). Goto Summary and click on manage next to each product to see how much is waiting to lend, either matching, repayments or new money.

If you are right you are saying that a figure described as "Invested Money" includes uninvested money. In any case my Capital Outstanding total (from the portfolio download) is 43% more (not less) than the Invested Money on the site, and my uninvested money is almost zero.

Looking back at old spreadsheets, I used to compare the Overall Balance on the site to my Overall Balance calculated from:

Total Paid In - Total Taken Out + 'Earnings to Date'

Zopa now give a figure for all of these, (if you accept their figures). I used to keep track of money in and out and calculate earnings to date from:

Interest earned - Defaults + Bonuses

Now there are also Debt Sales and Recoveries to take into account. I'm not sure if Recoveries are accounted for in the defaults, I think they probably are, but I don't think Debt Sales are allocated to specific loans.

To get to the 'Invested Money' you then have to account for un-lent funds, as discussed above.

I haven't done this routinely for a long time and I'm sure there are lots of other ways of reconciling the figures.

Withdrawn just means the borrower has the money.

I don't know enough about how and when funds are written off but anything Closed with funds outstanding, default, deceased, possibly collection and settled which I think include loans that have been sold in the debt sales, may not be in the Dashboard figure. There are also deferred repayments, I expect they are still in the Dashboard figures.

aju is definitely the Zopa expert! He may be along to explain all.

As in my previous post I attacked the account balance check from a different angle.

(Blue text marker) An interesting concept - me being an expert in Zopa. 

littleoldlady , If you are looking for descriptions of the relevant fields then the Zopa Glossary, available on the loanbook page may be of interest.

www.zopa.com/invest/loanbook-glossary

It's available from both Loanbook pages and is titled "loan book glossary"

secure2.zopa.com/lender/loan_book/standard/current for Invest
and
secure2.zopa.com/lender/loan_book/isa/current for ISA

You have to be logged in for all these links to work and if you use them to get there much quicker you may find that logging out will not clear the cookies correctly. (I use direct links quite a bit to get me where I want to be and have found that once logged out just looping the top left and right links when logged out does eventually clear them all and I can then login without being immediately logged back out again (Zopa seems to have lost track of the cookies they use probably due to making changes without understanding the flow diagrams they probably don;t have!). Very boring I know but using direct links will allow much quicker traversing around an increasingly slow web page system I find.)

Hope this helps you understand the loanbook fields better and helps you to marry up the numbers - there are quite a lot to work with I'm afraid. The main issue's I have found is that things are changing daily, even hourly, and it takes quite some effort to keep on top of things without specialised tool (interlinked spreadsheets in my case). Sadly I have tools coming out of my earholes for want of a better term but if I noticed something like you seem to have then I might be tempted to just go to Zopa and get them to investigate it.

In my case - myself and mrs aju have 4 accounts 2 each - I have not found that much of a discrepancy of late and definitely nothing as large as you may have suggested across our 4 products I have found small discrepancies over somedays when the systems get out of sync due to overloads I feel but as I say nothing that looks that far out. In fact I can even see from the dashboard when to consider a removal of funds as the lineup to my data can see when they are more than a few pence different to my last checks. (I use this method as its not always a give that overnights will run the same time or even at all. - they mostly do not run over the weekends )

I have spreadsheet totalisers for both Zopa and RS and it's very clear to me that the time of day and sometimes even the Day of the week can mean that things get out of sync quite a bit in both systems. This is just the nature of these routine batch processes etc. In reality if you can prove that Zopa has an error in their systems and can identify where to them it can be quite a lucrative excercise if they deem that they have made a boo boo - I have stated elsewhere that we made more in compo payments than interest a couple of years or so ago. 

My experience working with Zopa they have always been very receptive in the past and users helping them to get their systems working better has never been a big issue. Sometimes one has to push past the front end triage and get someone who understands the workings at these levels to take notice but they usually help rather than hinder. In my view they are very open to users input most of the time, one of the better players in my view.

Anyway I hope the glossary will help you understand things better, apologies if you already have that info and its still unclear do not hesitate to ask - I am not a Zopa expert at the level that zopa people are though far from it just a user who was in the software business a good few years back and now uses spreadsheets to monitor my accounts to the n'th degree - sad old git that I am..

Thanks. This is a relatives's account that I am managing under a LPA. He doesn't have enough in there (lowish 4 figures) to justify me spending the amount of time on it that you do. He is running down his investment and I just wanted to look at his loan book to get a rough idea of the future time line of repayments. Subtracting defaults and settled gets me close enough to the dashboard figure. So unless anyone knows of a way of speeding up his exit from the platform, (I don't think even dying would work), then we can close this thread.

Thanks aju I should have said that I sold everything that would sell, about 80% or so of the loan book. Took quite a hit but less than interest earned so he has not lost out on those loans, it remains to be seen how much of the rump he will get back. 95% is non-performing one way or another