How to Track Lending Club Investments in Quicken
I’m now convinced that investing through Lending Club is (at least for me) more than just a passing fancy. As such, I decided that it was high time to start tracking things in Quicken.
I’ve actually been avoiding this task because I’ve already invested in over 100 loans, and the prospect of tracking so many independent investments is a bit daunting. But then it hit me… There’s no real reason that I have to track every loan separately.
The system that I’ve settled on is similar to my strategy for tracking CDs with Quicken. I update the data based on my monthly statements, and use just a single “meta-security” instead of tracking each loan individually.
Here’s a quick rundown of the initial setup*:
- Create a new “brokerage” account in Quicken
- Create a new security with a value of $1/share (I called mine “LC loans“)
- Transfer (XFR) your starting (cash) balance into the account
And here’s what I do at the end of each month:
- Transfer (XFR) funds in or out of your account to reflect any real-world transfers
- Buy shares of “LC Loans” in a dollar amount equal to the total of any new notes issued during the month (this reduces your cash balance)
- Sell shares of “LC Loans” in a dollar amount equal to any principal repayments for the month (this increases cash balance)
- Record you total interest payments for the month as dividends (DIV) on your “LC Loans” shares (this increases cash balance)
- Record your investment fees for the month as a miscellaneous (MISC) transaction (this reduces your cash balance)
While you’ll lose the ability to track individual loans, this system is very quick and easy to maintain, and still gives you accurate performance numbers on an account-wide basis. Another benefit is that this approach accounts for the performance drag created by your uninvested cash balance.
For all transactions, I use an effective date of the last day of the month. The order in which you record the individual transactions doesn’t really matter since everything will balance out on that same day.
What about you?
If you’re a Lending Club investor, how do you track your performance? Do you just rely on the Lending Club interface? Or do you do something more? Maybe Quicken or a spreadsheet?
*Note: These notes are based on Quicken 2007 on a Mac, so there might be some subtle differences if you’re using a different version. The overall approach, however, should remain the same.
Disclaimer: Discover is a paid advertiser of this site.
Reasonable efforts are made to maintain accurate information. See the Discover online credit card application for full terms and conditions on offers and rewards.
Filed under: Saving & Investing
About the author: Nickel is the founder and editor-in-chief of this site. He's a thirty-something family man who has been writing about personal finance since 2005, and guess what? He's on Twitter!
Related articles...
» Lending Club Update – April 2010 Performance» Lending Club Update – August 2010 Performance
» How to Account for Lending Club Defaults in Quicken
» Lending Club 2010 Performance
» Lending Club Portfolio Fully Funded
» Lending Club and Your Income Taxes
» Lending Club Update – March 2012
» Lending Club: The Cost of Inactive Money
Was this article useful? Please sign up to receive our content via e-mail:
20 Responses to “How to Track Lending Club Investments in Quicken”
Leave a Reply
Top Cards by Category
Earn 100 Reward Dollars after you make $1,000 in purchases in the first three months of Cardmembership.
Earn 25K Membership Rewards(R) points after you spend $2,000 during your first three months of Card membership.
Consumer friendly credit card with a great low rate of 7.25% and save on interest charges. No balance transfer fees and no annual fee.
The new Discover it card is out to change the way people think about credit cards. No annual fee. No overlimit fee. No foreign transaction fee & no pay-by-phone fee. No late fee on your first late payment. And Discover won't increase your APR for paying late.*
The new Discover it card is out to change the way people think about credit cards. No annual fee. No overlimit fee. No foreign transaction fee & no pay-by-phone fee. No late fee on your first late payment. And Discover won't increase your APR for paying late.*
Consumer friendly credit card with a great low rate of 7.25% and save on interest charges. No balance transfer fees and no annual fee.
Limited Time Offer: Get 25,000 Membership Rewards(R) points after you spend $5,000 in the first three months of Card membership. Enroll and select a qualifying airline to receive up to $200 annually in statement credits for incidental fees, such as checked bags and in-flight refreshments, charged by the airline.
The new Discover it card is out to change the way people think about credit cards. No annual fee. No overlimit fee. No foreign transaction fee & no pay-by-phone fee. No late fee on your first late payment. And Discover won't increase your APR for paying late.*
- How to Become a Millionaire
- How to Get Out of Debt
- The Best Dollars I've Ever Spent
- How Our Estate Plan is Structured
- How We Paid Our Mortgage In Less than 10 Years
- Money Making Ideas
- How to Manage Your Asset Allocation with Multiple Accounts
- Consumption Smoothing - Save While the Saving's Good
- How to Save on Groceries
- How Much Life Insurance Do You Need?
- Eleven Great Books About Money
- Dave Ramsey is Bad at Math
- Dish Network Customer Service SUCKS
- $8,000 Homebuyer Tax Credit
- Pay Off Mortgage Early or Invest?
- How to Claim the First-Time Homebuyer Tax Credit
- Termite Control: Sentricon vs. Termidor
- How Much Should You Pay a Babysitter?
- Ethanol Blended Gas = Lower Mileage?
- Reduced Credit Limits? Share Your Experience
- $15,000 Homebuyer Tax Credit
- Will Mac OS X Lion Kill Quicken 2007?
- Buying Furniture off the Back of a Truck
How to save money on insurance
- How I cut my spending in half to take a job I loved
- Working longer: Fallback or fallacy?
- More money, more happiness: Do you think money can buy happiness?
- Overdraft fees soared to $32 billion in 2012
- How do you combat prom inflation?
- How should you choose a bank? Look in the mirror.
- The cost of clean water
- College debt 101
- Is it possible to live debt free?
- How to prepare for a home appraisal
August 28th, 2009 at 8:46 am
I just started an account with Lending Club, I’m going to track it as an overall savings account. Starting balance plus interest at the end of each month. I don’t know how I’ll account for any loans that go bad yet – hopefully I won’t have any
.
August 28th, 2009 at 10:05 am
I really want to start using Lending Club, but being a MA resident, it’s not an option for me. Does anyone else living in Massachusetts know of any viable alternatives?
August 28th, 2009 at 10:21 am
This is the same way I’ve been tracking my Prosper Loans. In fact by using Quicken I quickly discovered that the real rate of return on my investment has been around 3% and not 12.5% as stated on the Prosper website.
Prosper calculates the return based on the average APR for each loan outstanding. It doesn’t take into account fees, defaulted loans, charge-offs, etc. A have a total of 87 loans and 7 have defaulted so far. I was investing in a “Moderate Portfolio” which was supposed to be low risk.
I decided not to invest any more money in Prosper, hopefully Lending Club has a better record.
August 28th, 2009 at 3:33 pm
Lending Club does indeed seem to have a better record, largely because they have a more rigorous screening process. I believe that as of a few days ago, only two “A” rated loans have ever entered default, out of about 1000.
August 29th, 2009 at 2:01 am
I just opened my account and will track it like comment #1. I found it annoying that I had to go back and reinvest funds that expired for what ever reason or were rejected so I set up a prime account and they reinvest the funds. Today they invested x amount to take the cash below minimum investment criteria and by tonight there was 2x in the cash account from rejected/expired notes.
August 29th, 2009 at 5:46 pm
Somewhat off-topic (because I’m lazy and don’t use Quicken) but your posts about Lending Club have been very interesting and informative. Today I opened an account as an investor and I will be trying to use some of the insight you have provided to maximize results.
Thanks for writing about this subject and I look forward to future posts.
August 30th, 2009 at 7:21 pm
Min,
Did you look at their note trading platform? I’m in AZ and we can’t invest in loans directly, but the trading platform allows me to buy (and sell) notes.
September 1st, 2009 at 9:06 pm
I’d be happier with Lending Club if they computed my real rate of return after losses from unpaid accounts. The rate shown fails to account for losses of principal and interest.
September 1st, 2009 at 9:07 pm
If they only have 2 loans out of 1000 in default, how did I end up with both of them?
November 30th, 2009 at 9:59 am
Great method.
I set this up last night, and it took me a while to reconcile my account for this reason: I am in a state that does not allow direct purchases of loans, so I have to use the secondary market at foliofn. Many of these loans sell for some premium or a discount.
For example, I might pay $26 for a loan with a $25 outstanding principle balance (I’m basically buying the remainder of the interest for $1). So my statement shows that I spent $26, but my “shares” in Quicken have to indicate that the market value is only $25.
What I did to get around this is to buy $25 worth of shares and indicate $1 as the brokerage fee for the transaction. Now my total market value matches the balance on my statement.
Thoughts?
February 6th, 2010 at 11:48 pm
Although MA has not approved Lending Club for investing, it’s still possible to invest. I have found that DCU.org works as well as INGdirect.com. I’m assuming other online banks not based in MA will also work. It’s easy to find out by entering your banks info and clicking the Verify Account button. If it works you’ll see a Lending Club transaction within a few days. If not, try another bank.
May 27th, 2010 at 9:42 pm
I’m using this method with Quicken 2010 and it seems to be setup properly and I see the cash amounts and total market value that I expect but my cost basis seems to be the same value as the market value in the graphs. Any ideas what I might be doing wrong?
July 19th, 2010 at 1:48 pm
Who uses Mac Quicken?? That app is so broken it’s not even worth using. Even me who is now completely mac based use Quicken 2009 Windows in a VMWare Fusion instance.
July 19th, 2010 at 3:12 pm
Works for me, so why change?
July 19th, 2010 at 10:04 pm
Hmm while it works, it’s not the best solution. It’s more a gripe at Intuit who still treats OS X as the bastard child. Even the latest version of Quicken that just came out.
July 19th, 2010 at 10:12 pm
“Best solution”? It does everything I need, and I got it for free. That’s the best solution for me.
But I do agree that Intuit’s Mac support sucks, and their new “Quicken Essentials” (or whatever) is a disaster.
September 7th, 2010 at 6:55 am
While you can’t sell the “stock” for $0, there is an action to Declare the Stock Worthless which might provide a cleaner solution.
I lend on both Prosper and Lending Club, and have yelled at both several times for not having a Quicken download capability.
January 29th, 2011 at 4:20 pm
The 2011 version of Quicken will let you set up a loan account where you are the payee. I am going to see how that works for tracking my lending club loans.
July 19th, 2011 at 2:07 pm
I’ve sold on the trading platform but never bought. If I do, do these loans comingle with my regular Lending Club account? And how do you track the difference in Quicken since there’s a difference between the cost and the cash value?
July 19th, 2011 at 2:08 pm
I’ve sold on the trading platform but never bought. If I do, do these loans comingle with my regular Lending Club account?
And how do you track the difference in Quicken since there’s a difference between the cost and the cash value?