P2P crowdlending excel spreadsheet

The P2P crowdlending Excel spreadsheet can calculate your income, cash flow, risk distribution, XIRR and more. To achieve the highest possible return its necessary for you to actively manage your crowdlending investments, according to your investment strategy. Some of the factors that can reduce your returns are low interest rates, cash drag, increased risks due to unbalanced portfolio, late payments and incorrect calculations from the loan providers. has created a free P2P crowdlending Excel spreadsheet that can help you to manage your peer to peer crowdlending investments. You can DOWNLOAD it now or continue reading about the functionalities below(recommended):

XIRR Calculation

One of the main features of the peer to peer crowdlending Excel spreadsheet is the XIRR calculation. The XIRR calculation will show you the yearly internal actual return taking into account the date of your deposits and withdrawals. The XIRR calculation will also take into account the cash drag (time your money was not invested due to the lack of loans on a platform), as well as how delayed loans payed back with or without accrued interest influenced your investment. Consider the following example: You are investing on platform A that offers you 14% pr. year on loans and platform B that offers you 11%. You notice that often on platform A with 14% interest your full sum of money is not invested and you decide to do the XIRR calculation in the Excel calculator. The calculation shows that the real yearly return on platform A is only 9%, making platform B the better choice interest wise.

Risk distribution

The old saying goes: Don’t put all your eggs in one basket. The same goes for crowdlending, by investing all your funds in few platforms you risk losing a big part of your investments if something goes wrong. The excel calculator will show your distribution between different platforms as well as automatically marking unbalanced investments with different colours to indicate the distribution among them.  

P2P crowdlending excel spreadsheet
The dashboard of the peer to peer crowdlending excel spreadsheet

Cash flow

Did you ever wonder how much money you would be able to withdraw any given month, without selling your investments on the secondary market, if you simply paused all your investments? The peer to peer excel spreadsheet has all the answers and it will include the cash flow from interest, principal and referral bonuses.


The Excel calculator is completely safe to use. All information will only be stored at your local computer and not on 3rd part servers online. Furthermore the Excel spreadsheet has been constructed in a way that no unknown VBA code will be running in the background, so you have full control of your own data.

Support of the crowdlending P2P Excel spreadsheet

Instructions are included in the Excel spreadsheet, furthermore for a limited time there will be e-mail support.   


Version 2.00 2019

Features of the crowdlending P2P Excel spreadsheet:

  • Prepared for 30+ Crowdlending platforms.
  • Easy time efficient entry of data with colour guidance.
  • Simple, easily customizable design.
  • Highly automated calculations.
  • Data will only be stored on your own computer and no VBA programming will run any unknown code in the background.
  • Includes instructions and support by e-mail for a limited time.

The dashboard includes the following information:

  • Monthly interest income and referral income.
  • Graphs for individual Crowdlending platforms as well as total values.
  • Distribution across P2P Crowdlending platforms including colour warnings.
  • XIRR calculations on all individual peer to peer platforms.
  • Monthly Cash flow.
  • Total sum of money invested.
  • And much more..



  1. Søren N

    June 16, 2019 - 7:45 pm

    Thanks for a great tool for keeping track of my platforms.
    Took me a while to get the XIRR calculation to work, but after reading the instructions I figured it out.

  2. DMO

    July 8, 2019 - 11:20 am

    Thanks a lot for your great blog and excel file
    Very Usefull

  3. Jim N

    September 4, 2019 - 6:08 pm

    Thanks for a great blog and this great tool.

    Would like to track my portfolio over more than one year – can the spreadsheet be expanded for that purpose?


      September 4, 2019 - 10:57 pm

      Dear Jim,
      Thanks for your feedback.
      The Excel sheet is fully customizable. Its possible to edit the file yourself to include more than one year. Its however not recommended, since you will end up with some very big graphs and you might lose overview. But if you have a big computer screen and you prefer it that way then its possible. Would recommend you to check back in the nearest future when a new even easier to use version will released.

  4. søren

    September 8, 2019 - 8:16 pm

    so far I have tried to use the sheet . I just need to put in : start month account value & added/withdraw-ed funds during the month & and end month account value and ould like to get the roi ( xirr) for that month calculated . pls advice thx


      September 8, 2019 - 9:24 pm

      Dear Søren,

      Thank you for your comment. Please start by reading the details instructions in the first tab in the Excel file. Its called Instruction (start here). The guide will walk you through all steps. If you still have challenges then, please drop me a message via the contact form here: and I will help you to get it up and running at once.

  5. Andre Butter

    October 1, 2019 - 8:13 pm

    Is it possible that in addition to “total invested sum” you also calculate the XIRR of the “total invested sum?


      October 1, 2019 - 11:32 pm

      Dear Andre,

      Yes it’s possible, but not included in the current version. I will release the next version soon with a lot of improvements including the possibility to calculate the weighted average of XIRR on all investments. Consider signing up for the newsletter not to miss out on the new version. If you need this function added to your current Excel file then write me a message via the contact form.

Leave a Reply

Your email address will not be published. Required fields are marked *