In this article, you’ll find out exactly how I keep track of all of my P2P investment accounts and how I calculate my returns from peer to peer lending every month, with the help of a free tool called Portfolio Performance.

You’re going to learn how you can easily track the performance of your investments and see the actual internal rate of return on your money.

Why you should do your own IRR calculations

You shouldn’t rely on the return percentages you see when logging in to your P2P platform accounts, as those can differ quite a bit from your own calculations. One reason for that is that they don’t take potential cash drag into account, meaning money that is sitting in your account waiting to be invested.

But if you’re anything like me, chances are you want to know the actual returns you’re getting on your investment, to identify the peer to peer lending platforms that are really worth your time and money in the long run.

Portfolio Performance: What I’ve been using to track my P2P investments for over a year

To do just that, I’ve been using a free, open-source software called Portfolio Performance. It’s available for Windows, Mac and Linux, it’s completely free from ads and doesn’t require a registration. In short, it’s a fantastic tool.

I’m very grateful to the German developer who has been doing all of this for free and who keeps updating it on a regular basis. I’m sure a lot of people, me included, would be happy to send him a small donation to support his work if he ever adds a Donate button to his website.

portfolio performance

Download the Software here:

Tracking your P2P Portfolio with Portfolio Performance

Once you’re done downloading and installing Portfolio Performance, here is what you need to do to set it up.

Setting up Portfolio Performance

Create a new file, choose the base currency (Euro in our case), add a securities account (doesn’t matter in our case – we can delete it after) and a reference account (here you can add the first P2P platform you’d like to track) and click Add.

portfolio performance setup

Tap Finish. Now you can delete the securities account again if you wish, as we won’t be needing it for our calculations, which are focused around p2p lending in this article.

portfolio performance add account

Add all the P2P platforms that you’d like to track using Portfolio Performance under Deposit Accounts by clicking on the + sign in the top right.

portfolio performance p2p accounts

Once the accounts are all there, start adding your deposits to each platform, using the correct dates. Select the platform, right click the Transactions window below and click on Deposit…

To get all the correct dates of your deposits, either check the platforms themselves or search for each platform in your e-mails. Most of them (all?) send you an e-mail as soon as they receive new funds from you.

portfolio performance add p2p deposit

Now, add all the deposits you made to the P2P platform one by one, using the respective date when it arrived on the platform. If you’re adding more than one, you can cut some time by clicking Save & New instead of Save.

portfolio performance add deposit

Do the same for Withdrawals, if you made any. Do a right click in the Transactions window and select Removal… Once again make sure you’re using the respective date/s of the withdrawal/s.
portfolio performance p2p withdrawal

How To Add Your Monthly P2P Income (Interest)

I recommend spending a couple of minutes every month on the same date (eg. on the 1st) to add all interest payments you received last month. In my opinion, the easiest way to do this is by comparing your current balance on a platform to the month before and adding the difference as interest.

This shouldn’t take more than a couple of minutes of your time.

If you have very little time that day, you can also quickly login to your accounts, take a screenshot and add the numbers later. It’s up to you if you count bonus payments and cashback you receive as interest income or not, I personally add it to my calculations (if it’s available to all investors).

To add interest, right click the Transactions window again and choose Interest…

portfolio performance crowdlending accounts

  • In this example, we made our first deposit on October 3rd, withdrew some money on October 10th and added our monthly interest on November 1st.

How To Track Your Existing Peer to Peer Lending Accounts

If you have existing accounts, which is likely the case for most of you, of course it’s going to take you a little while to set up everything correctly. Still, it’s going to be way less effort than using other tools like Excel to track everything.

I’ll give you examples for how to import existing data from a couple of popular crowdlending platforms below. After the initial setup, you’ll be able to save some time by simply adding the account balance difference as interest on a month-by-month basis in the future.

For the exact dates of your deposits and withdrawals, you can either get that information by doing a platform search within your own e-mails or get the information on the platforms themselves, together with the payments you received.

Adding Mintos to Portfolio Performance

mintos portfolio performance import

Let’s start with Mintos. Click on Account Statement and choose a full month. As I import my data on the 1st, I like to count from the 2nd of the previous month until the 1st of the current month. You can use different dates if you like, just stay consistent.

Tap Search. Then, add up interest received, late fees received, interest income on rebuy and potential bonus payments and add those to Portfolio Performance as interest (we would use Feb. 1st as date in this case).

By clicking on Deposits, you’ll be able to see the exact dates of your deposits, which you can then add to Portfolio Performance as well if you haven’t already.

Adding Envestio to Portfolio Performance

envestio data import portfolio performance
On Envestio, click on Statistics,  enter the dates and click on Download document to get an income statement for each month.
envestio portfolio performance import part 2

From the documents, add your total income as interest to Portfolio Performance. Additionally, check your e-mails for your deposit/withdrawal dates.

Adding Iuvo Group to Portfolio Performance

iuvo group portfolio performance import

On Iuvo Group, click on Account Statement, enter the month and click Filter. Add up Late fees received, Interest received, Early interest repayment and potential Refer-a-friend Bonuses and add them as interest to your Iuvo Group account in Portfolio Performance.

Just like on Mintos, you’ll be able to see the exact dates and amounts of your contributions under Deposits.

Adding Grupeer to Portfolio Performance

grupeer portfolio performance import part 1

To import your investments from Grupeer, click on OverviewIncome statement and then download an income statement for each month.
grupeer portfolio performance import part 2
Add up Interest income and Other income (bonuses) and add it as interest for the month. As far as deposits and withdrawals are concerned, doing a search within your e-mails is probably the fastest way.

Calculating the Internal Rate of Return of your P2P Investments

After you finished adding the data from all of your P2P platforms, you probably want to know your actual internal rate of return (IRR) for each platform.

Click on Performance, and in the top right corner, press the + sign next to Dashboard. Enter P2P Portfolio or another name in the New view window that pops up.

Next, right click and delete every single label until you have a blank page. Now, we can finally add our platform widgets. To do that, right click a column and select New WidgetCommonHeading.

portfolio performance add heading
After that, right click the new label and change its name to one of your platforms (eg. Mintos). By default, you have 3 columns. To add more, tap the Settings-icon in the top right corner.
portfolio performance p2p account headings

In this example, I added three more columns. We now have one for each platform and one for our entire P2P Portfolio.

Note: If you’re invested on more than five platforms, add them below the first five, as adding more columns could make it look too cluttered.

portfolio performance internal rate of return

To display your IRR so far, do this for each P2P platform:

1. Right click the space below the name, select New WidgetPerformanceInternal Rate of Return (IRR).

portfolio performance data series

2. To make sure the correct platform is being displayed, right click the widget, choose Select data series and select the platform.

portfolio performance reporting period

3. With one last right click, make sure that the Reporting period starts on the day of your first deposit to the platform and ends on the last day when you updated all the numbers (eg. on the 1st of the month).

internal rate of return portfolio performance mintos
It should now show the (correct) internal rate of return on our money so far. You might notice that it can differ quite a bit from the numbers the platforms themselves like to display.
portfolio performance report interval
As an example, next month, after adding monthly interest you received on the 1st of December, also update the Report interval to the same date, to correctly display our internal rate of return so far.
portfolio performance irr p2p portfolio
To know the internal rate of return of your entire portfolio, follow the same steps and simply choose Entire portfolio instead of a single platform. Make sure you have the date of your first P2P deposit set up as the starting date.

My Returns from P2P Lending in Portfolio Performance

Since my first P2P investment on September 1st, 2018 and over a year of tracking with Portfolio Performance, here is what my Performance-tab looks like:
my p2p portfolio internal rate of return portfolio performance
My Returns from P2P lending in Portfolio Performance

The software also comes with a lot of other features that I like and which make my life a lot easier. Let’s take a look at some of them.

portfolio performance calculation

  • Calculation shows a nice summary of your earnings, deposits etc. during your selected time period.

portfolio performance p2p earnings month

  • Earnings gives you a nice overview of your monthly income from P2P lending.

portfolio performance p2p earnings per year

  • As well as your earnings by Quarter or Year.

portfolio performance p2p earnings month graph

  • Under Month you can also see your progression compared to the previous months and to the previous year, which can be very motivating to follow over time.
portfolio performance reports holding p2p allocation
My P2P platform allocation as of Nov. 1st, 2019
  • Last but not least, Holdings shows your percentage allocation to each peer to peer platform in your portfolio. This is another feature I really love and which can make the decision making process of where to allocate more funds easier.

Conclusion

While Portfolio Performance was originally programmed to track other investments like stocks and ETFs (I have yet to experiment with adding my own ETFs to it), I’ve been using the software for over a year now and think it works very well to track investments in P2P lending.

Once you’re done setting up all of your accounts, it should now take you very little time and effort to keep track of your peer-to-peer investment portfolio and to calculate your (actual) returns in the long run.

Some links you might be interested in:

Video of the article

2 Comments

  1. Nice!

    Switched from my old excel to this! =) It will probably be easier to keep track of all platforms.

    • thank you Daniel! Great, I‘m very happy to hear it seems to have made your life easier as well 🙂

Leave a Comment

%d bloggers like this: