Author Topic: Downloading Lending Club Statements in Excel Format?  (Read 6879 times)

ppan

  • Newbie
  • *
  • Posts: 22
    • View Profile
Downloading Lending Club Statements in Excel Format?
« on: May 03, 2014, 05:09:56 AM »
How do I download the Lending Club Statements in Excel Format (rather than pdf)?

Fred93

  • Hero Member
  • *****
  • Posts: 2108
    • View Profile
Re: Downloading Lending Club Statements in Excel Format?
« Reply #1 on: May 03, 2014, 07:08:01 AM »
There are some pdf to Excel converters available on the web.  I used one of them awhile back on an LC statement.  Messy, but allowed me to check some things.

viking

  • Sr. Member
  • ****
  • Posts: 370
    • View Profile
    • Email
Re: Downloading Lending Club Statements in Excel Format?
« Reply #2 on: May 05, 2014, 05:42:19 PM »
It is possible to download your Lending Club statements to Excel format by following the steps below:

   Log in to your Lending Club account
   Click on "Statements"
   Once you're on the "Statements" page, please paste the following link into your web browser's address bar: https://www.lendingclub.com/account/lenderDocuments.action?display=42

Once you have completed the steps above and you select a statement, there will be an "Excel Version" link to download your statement in Excel format.

Fred93

  • Hero Member
  • *****
  • Posts: 2108
    • View Profile
Re: Downloading Lending Club Statements in Excel Format?
« Reply #3 on: May 05, 2014, 08:33:07 PM »
   Once you're on the "Statements" page, please paste the following link into your web browser's address bar: https://www.lendingclub.com/account/lenderDocuments.action?display=42

How is it that you knew to do this?

Fred

  • Hero Member
  • *****
  • Posts: 1421
    • View Profile

Fred93

  • Hero Member
  • *****
  • Posts: 2108
    • View Profile
Re: Downloading Lending Club Statements in Excel Format?
« Reply #5 on: May 06, 2014, 02:29:23 AM »
How is it that you knew to do this?

https://www.lendingclub.com/mainapp/scripts/b48527e/account/lenderDocuments.js

That's a pretty cryptic answer.  Yes, I see the test for "42" in there.  But...

Do you think this is some new feature they just haven't turned on yet in the production system, or ... something they perversely decided to make us hunt for, or ...  the kind of documentation I can expect for all features in the future?

PS: I see why they haven't made it visible yet.  It doesn't work!
« Last Edit: May 06, 2014, 01:01:41 PM by Fred93 »

Fred

  • Hero Member
  • *****
  • Posts: 1421
    • View Profile
Re: Downloading Lending Club Statements in Excel Format?
« Reply #6 on: May 06, 2014, 09:02:29 PM »
PS: I see why they haven't made it visible yet.  It doesn't work!

Hah ...

Another case where the front-end and back-end teams might not be talking.  The GUI is setup to enable this feature, but the server-side lenderDocuments.action does not process file_extension=xls parameter correctly.

Code: [Select]
https://www.lendingclub.com/account/lenderDocuments.action?file_extension=xls ....

lascott

  • Hero Member
  • *****
  • Posts: 1401
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Re: Downloading Lending Club Statements in Excel Format?
« Reply #7 on: May 07, 2014, 12:44:45 AM »
PS: I see why they haven't made it visible yet.  It doesn't work!
Hah ... Another case where the front-end and back-end teams might not be talking.  The GUI is setup to enable this feature, but the server-side lenderDocuments.action does not process file_extension=xls parameter correctly.
Code: [Select]
https://www.lendingclub.com/account/lenderDocuments.action?file_extension=xls ....
Downloads OK but is really really just a PDF file with an XLS extension.
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

viking

  • Sr. Member
  • ****
  • Posts: 370
    • View Profile
    • Email
Re: Downloading Lending Club Statements in Excel Format?
« Reply #8 on: May 08, 2014, 06:21:05 PM »
Confirmed that it is currently just a pdf file with xls extension. However, this worked some time ago when I had tried it.
It may help to call in to LC and complain.
The squeaky wheel etc......

lascott

  • Hero Member
  • *****
  • Posts: 1401
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Re: Downloading Lending Club Statements in Excel Format?
« Reply #9 on: May 09, 2014, 09:36:35 AM »
Confirmed that it is currently just a pdf file with xls extension. However, this worked some time ago when I had tried it. It may help to call in to LC and complain. The squeaky wheel etc......
Except it appears to be a hidden "feature" that was discovered.  You can not get to that XLS button through LCs normal interface.  Hence, they will tell you that you can't use features they don't provide (or are in alpha behind the scenes).
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

viking

  • Sr. Member
  • ****
  • Posts: 370
    • View Profile
    • Email
Re: Downloading Lending Club Statements in Excel Format?
« Reply #10 on: May 09, 2014, 01:52:54 PM »
Confirmed that it is currently just a pdf file with xls extension. However, this worked some time ago when I had tried it. It may help to call in to LC and complain. The squeaky wheel etc......
Except it appears to be a hidden "feature" that was discovered.  You can not get to that XLS button through LCs normal interface.  Hence, they will tell you that you can't use features they don't provide (or are in alpha behind the scenes).
It was LC themselves who provided written instructions of how to download to Excel. The feature has been there for a long time. However, they have now acknowledged that something appears broken. They are "looking into it".

lascott

  • Hero Member
  • *****
  • Posts: 1401
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Re: Downloading Lending Club Statements in Excel Format?
« Reply #11 on: May 09, 2014, 02:26:16 PM »
Confirmed that it is currently just a pdf file with xls extension. However, this worked some time ago when I had tried it. It may help to call in to LC and complain. The squeaky wheel etc......
Except it appears to be a hidden "feature" that was discovered.  You can not get to that XLS button through LCs normal interface.  Hence, they will tell you that you can't use features they don't provide (or are in alpha behind the scenes).
It was LC themselves who provided written instructions of how to download to Excel. The feature has been there for a long time. However, they have now acknowledged that something appears broken. They are "looking into it".
Thanks for clarifying this to me/others.  I'm relatively new here but all the above post lead me to believe it was done by "hacking" vs written directions from LC (ie. the magic 42 parm).
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

Fred93

  • Hero Member
  • *****
  • Posts: 2108
    • View Profile
Re: Downloading Lending Club Statements in Excel Format?
« Reply #12 on: May 10, 2014, 12:09:32 AM »
It was LC themselves who provided written instructions of how to download to Excel.

When?  Where? 

viking

  • Sr. Member
  • ****
  • Posts: 370
    • View Profile
    • Email
Re: Downloading Lending Club Statements in Excel Format?
« Reply #13 on: May 10, 2014, 03:24:38 AM »
It was LC themselves who provided written instructions of how to download to Excel.

When?  Where?
I asked.

rawraw

  • Hero Member
  • *****
  • Posts: 2756
    • View Profile
Re: Downloading Lending Club Statements in Excel Format?
« Reply #14 on: May 10, 2014, 11:47:20 AM »
It was LC themselves who provided written instructions of how to download to Excel.

When?  Where?
I asked.
Fancy that