Author Topic: Payments to date - Summary screen vs SUM(Portfolio column)  (Read 2972 times)

lascott

  • Hero Member
  • *****
  • Posts: 1438
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Payments to date - Summary screen vs SUM(Portfolio column)
« on: November 07, 2014, 09:23:37 AM »
For a few months now I captures (cut-n-paste) my Portfolio screen table and paste into a spreadsheet to calculate some numbers for each of my portfolios. One column I summarize is "Payments to date".

I also captures the Payments section on the Account/Summary screen that contains "Payments to date".  I do a little checks-n-balance between the two totals for "Payments to date".

Before yesterday it was always <= $0.01.  Today it is off by $12.33.  Yesterday had various LC "system error" corrections resulting in "Credit for ineligible loan{s} ".

Anyone else compare these two numbers and find them difference?  Only takes a few seconds to cut-n-paste.
« Last Edit: November 10, 2014, 12:34:43 AM by lascott »
Tools I use: (main) BlueVestment: https://www.bluevestment.com/app/pricing + https://www.interestradar.com/ , (others) Lending Robot referral link: https://www.lendingrobot.com/ref/scott473/  & Peercube referral code: DFVA9Y

lascott

  • Hero Member
  • *****
  • Posts: 1438
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Re: Payments to date - Summary screen vs SUM(Portfolio column)
« Reply #1 on: November 10, 2014, 12:39:28 AM »
I've been sending LC some info to look into this difference.

Anyone else have a difference in these two "Payments To Date" areas?



If you have more than one Portfolio just cut-n-paste this table into Excel or Google Docs spreadsheet to SUM it up.  (Make sure you have 0 in the notes not assigned area)

Tools I use: (main) BlueVestment: https://www.bluevestment.com/app/pricing + https://www.interestradar.com/ , (others) Lending Robot referral link: https://www.lendingrobot.com/ref/scott473/  & Peercube referral code: DFVA9Y

hoggy1

  • Sr. Member
  • ****
  • Posts: 401
    • View Profile
    • Email
Re: Payments to date - Summary screen vs SUM(Portfolio column)
« Reply #2 on: June 15, 2015, 07:22:34 AM »
I have a huge problem with Payments to date: mine is totally nonsensical. I think it has something to do with Folio trades but can't find any calculation on the extended note CSV and traded notes CSV that even gets close? Here is a guess:

The "payments to date" is the sum of payments made on all loans I hold and not "payment made to me". So depending on when I purchased it I am seeing payments made to the previous owner (on folio purchased notes) added to "my payments to date".
« Last Edit: June 15, 2015, 07:25:04 AM by hoggy1 »
Steve

lascott

  • Hero Member
  • *****
  • Posts: 1438
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Re: Payments to date - Summary screen vs SUM(Portfolio column)
« Reply #3 on: June 15, 2015, 09:07:15 AM »
I don't do folio trades (as of yet) but mine are now matching up.  This thread is pretty old but there was another problem which I reported and they solved not too long ago.

Topic: Portfolios tab Payments To Date (PTD) <> Account Summary Payments PTD! 
on: May 01, 2015, 09:50:11 am
http://www.lendacademy.com/forum/index.php?topic=3196.0

Reported via post "May 30, 2015, 12:23:31 am" that it was solved.
Tools I use: (main) BlueVestment: https://www.bluevestment.com/app/pricing + https://www.interestradar.com/ , (others) Lending Robot referral link: https://www.lendingrobot.com/ref/scott473/  & Peercube referral code: DFVA9Y

GS

  • Sr. Member
  • ****
  • Posts: 413
    • View Profile
Re: Payments to date - Summary screen vs SUM(Portfolio column)
« Reply #4 on: June 15, 2015, 06:35:54 PM »
I have a huge problem with Payments to date: mine is totally nonsensical. I think it has something to do with Folio trades but can't find any calculation on the extended note CSV and traded notes CSV that even gets close? Here is a guess:

The "payments to date" is the sum of payments made on all loans I hold and not "payment made to me". So depending on when I purchased it I am seeing payments made to the previous owner (on folio purchased notes) added to "my payments to date".

Mine is like that, too.  For example, I have a portfolio that has one note left in it (used to have more in this portfolio, but I sold them).  I bought the lone note for $23.31, but my payments to date show $58.33, with $6.24 left in principle.  I think all my portfolio sums are screwed up like this, but you don't really notice until there are just a few notes left.