I updated my Quicken Prosper.com brokerage account per yesterday’s post: http://www.rateladder.com/2007/04/10/adam-nash-merged-with-rateladder-to-form-the-ideal-quicken-solution-without-prosper-integration/
The one things that is even easier is that if you use your monthly statement you don’t need to enter a fee transaction… However, I also used my account history to update my account for March… I plan on using my statement to reconcile these numbers. The March estimate also needed a fee transaction since the prosper history includes the fees. Or I could have just waited another day or two to get my March statement.
The bottom line is that for each month there are 3 transactions… A purchase for new loans, a sale of principal portions of payments, and in interest distribution for interest portion of payments. If you have a principal reduction (I haven’t had one yet, but I think they come from debt sales or bankruptcy) then you would also need a transaction for this… I haven’t decided how to enter this, but I think it is a sold transaction for a $1 with a commission for the principal reduction. Thoughts?
The benefits
- Low Number of Transactions to Enter
- Cash vs Loans Account Balance Tracked
- ROI for Account and Prosper Loans Tracked
- Prosper Loans Called Out as Different Asset Class
The downside
- All loans Rolled into a Single Security (Individuality is Lost.) (You will be Assimilated.)
My YTD results are 12.78% for account, 14.72% for loans.
My all time results are 7.33% for account, 9.55% for loans.
I would like to thanks Adam Nash of Psychohistory for his post regarding his Prosper and Quicken Solution which I combined with my original approach to come up with the current approach.
Related Posts -
Debt Sale Accounting via Quicken In the recent default debt sale I had a loan sold. This is my first opportunity to account for such an event. I use Quicken for my personal finances including my Prosper account (read about it here). Here are the details of my defaulted loan: CreditGrade: AA Homeowner: Yes Verified...... -
New Loan Funded — Financial Freedom / Credit Card Consolidation — $25,000 at 11.44% — AA Credit — DTI 37% A new loan funded (Financial Freedom / Credit Card Consolidation â $25,000 at 11.44%). I participated via my standing order RL Overlooked. The borrower had AA credit, a 37% DTI. As a reminder my standing orders (and manual bids) only find loans with 0 current delinquencies, 10 or less delinquencies in the last 7...... -
New Loan Funded — Purchasing rental equipment in my hardware store — $20,000 at 24% — C Credit — DTI 29% A new loan funded (Purchasing rental equipment in my hardware store â $20,000 at 24%). I participated via a manual bid, this was an auto funding loan.  The borrow had C credit and 29% DTI. As a reminder my standing orders (and manual bids) only find loans with 0 current delinquencies, 10...... - Prosper.com and Your Emergency Fund I was reading an article on bankrate.com about Using a CD Ladder as Parking Locations for Your Emergency Fund. One of the big problems with a CD Ladder is the finite number of times you can withdraw money without a fee. Another big problem is length of time it......
- Prosper Delinquent Debt Sale In Progress Yesterday Prosper began a delinquent debt sale. This happens when loans are 4 months or more late and are sold to delinquent debt buyers... Loans receive different amounts depending on the credit grade and other borrower information. From my standpoint (observer as I have no loans in the debt sale)......
Related Websites - In Defense of Prosper.com - Other Common Complaints Rebutted (Jonathan at My Money Blog has a very in-depth two part review of Prosper.com. My Money Blog is one of my favorite sites, which is why itâs in my blog roll and feed reader. Itâs worth familiarizing yourself with that article before continuing here with my rebuttals.) Jonathan notes that......
-
Lending Club New Investor Bonus $64.62 Lending Club, one of the two most popular peer to peer lending networks, is now offering a $64.62 bonus to new investors that sign up through one of our links before December 31st, complete their registration and link a bank account to their Lending Club account. The bonus funds can’t...... -
Making Extra Money With P2P Lending Peer to Peer lending is quickly becoming one of the hottest new ways to create multiple streams of income. While there is risk involved, there are various methods that can reduce the risks that individual investors face and provide protection against non-payments. If you're looking for an potential way to...... -
Wikipedia Wednesday: Prosper.com [Editor's Note: We've decided to start a new feature on Getting Green. Every Wednesday night we are going to feature an article by perhaps you! We are going to showcase one article relating to money from Wikipedia so that you can better share in the knowledge of the masses!]Today we're...... -
Save Time, Money and Space in Over 80 Ways If you're looking for handy gadgets, tools and various items that can save you time, money or space (or all three!) this list of more than 80 top products is just what you need. Everyone's got saving money on their minds these days. Some of us are always looking to......
Categories:
Prosper.com, Quicken
Tags:
8 comments ↓
Thank you for this great blog. All the ads are a little disconcerting but I guess the content makes up for them. I will checking your blog for updates.
I also write about Prosper on my blog. You can find my Prosper related posts here: Link .
Sanjeev
The ads pay for hosting… If you see something you like or interesting don’t hesitate to visit.
I am glad you like the content.
[...] Update (4/11/2007): OK, last update. But Rateladder.com has followed up with a finally post on the topic. Between the two of us, I think we’ve provided the best way to handle this until we convince Prosper to provide downloadable transactions. Posted in Personal Finance, E-Commerce, Economics. [...]
Hi Kevin,
I updated my post with a pointer to your final updates. Glad I could help here – this issue of how to track Prosper in Quicken has been bugging me for more than a year!
In terms of principal loss due to bankruptcy or settlement, my recommendation would be two transactions:
1) A “Sale” of shares to represent the decrease in principal.
2) A “Misc” expense, attributed to a “loss of principal” or “bankruptcy” expense to remove the cash from the account.
Adam
Question: would the principal repayment be considered a “return of capital?” as opposed to a sale? What are the implications of using one category over the other? I’ve taken a look at the irs (a search on the phrase returned numerous results) and wikipedia (http://en.wikipedia.org/wiki/Return_of_capital)websites on the topic, but I’m still a little hazy.
I could only find the IRS applying the phrase to stocks and mutual funds.
I’ve tried both in Quicken. Recording principal payments as sales resulted in my cost basis increasing when that payment was reinvested, but with return of capital used the cost basis did not increase. (Well, technically it did with the purchase, but it declined by an equal amount when the payment was recorded.)
I like the idea of my cost basis only being what I move into Prosper I will try it out…
I posted my responce here: http://www.rateladder.com/2007/04/17/accounting-for-prosper-in-quicken-strategy-update/
Union-Run Fund May Remedy Big Three's Health Care…
Akron’s Goodyear Tire and Rubber Co. and the United Steelworkers signed in December a contract that vested responsibility for retiree health care from the company to the union. Goodyear paid $1 billion up front, but it is no longer burdened to put tho…
Leave a Comment