I have found what I think is the most complete solution to the Quicken and Prosper dilemma, but that doesn’t mean it is the best solution…  Let me start with the negative and work to the positive…

The problem with his solution is that it is too much work…  I have 70 loans and if I had to update each one it would require 210 transactions a month by hand.  I communicate regularly with people with 100-1000 loans.  Suscintly, the problem with the solution is accurate accounting requires 3 transactions per month per loan by hand.  He even admits as much…

This is likely too much work to do monthly, although you need to if you want Quicken’s IRR calculations to be accurate. Personally, I’ve decided just to update the account once every 3-6 months, which is sufficient for my needs.

I have called for Prosper integration in the past.  With such integration Adam’s solution would be the best solution for the integration.

Here is his solution: 

Step 1: Create a Security for each Prosper Loan. I name them after the unique Prosper Loan number, like “Prosper Loan 335″

Step 2: Create a Brokerage account for your Prosper account. Transfer the money from your checking account to this account when you move money to Prosper.

Step 3: When you make a loan for a certain amount, let’s say $100, then purchase the shares of the Prosper Loan security, at $1 per share. So, in this example, you would purchase 100 shares of “Prosper Loan 335″

Step 4: Whenever you want to update the account, use the following 3 transactions. Use a “Sell Shares” transaction to represent the principal re-payment. Use a “Interest Income” transaction to represent the receipt of the interest payment. Lastly, use a “Miscellaneous” transaction to record the Prosper fees charged.

This works accurately on a number of different fronts, but most appropriately by following the Quicken model enough so that Quicken can calculate your IRR, and you are tracking principal, interest, and fees on a per loan basis.

I think a hybrid of his approach and mine (simplified cashflows only: http://www.rateladder.com/2006/12/31/prospercom-and-quicken-the-workable-solution-for-playmates-that-dont-get-along/) would work great and be manageable…  Here is my proposed merge my existing approach with his…  (I haven’t tried this yet, but I think it will work great.)

Step 1: Create a brokerage account called Prosper.com.  For each transfer from your bank transfer money into the cash balance of this account.  This is easy as your bank likely integrates with Quicken.

Step 2: Create a Single security called “Prosper Loans”.  Set the asset class to “Unclassified” to separate this security from more traditional in your portfolio.

Step 3: For each month, using your lender statement… Buy shares for for the entire principal loaned for the month at $1 per share.

Step 4: For each month, using your lender statement… “Sell Shares” to represent principal repaid during the month; use an “Interest Income” transaction to represent the receipt of the interest payment; and Lastly, use a “Miscellaneous” transaction to record the Prosper fees charged

The hybrid approach retains all of Adam’s original accuracy expect it rolls it up into a single security instead of a security for each loan.  It also, maintains Rateladder’s goal of not spending my entire life tracking Prosper in Quicken.  Most importantly, as you portfolio grows the time required for tracking does not increase rapidly linearly; let alone exponentially.  Anybody care to guess at BigO.  Constant?  LogN? or NLogN?  I think constant, but I will let you know after I update Quicken.

Update 8/28/2007: Default Debt Sale Accounting with Quicken

Related Posts

• Prosper Ordered to Cease and Desist by SEC http://www.sec.gov/litigation/admin/2008/33-8984.pdf It appears to me that the ruling is that they have been selling unregistered securities without a license.  What does that mean for the lenders?   Doesn't the board and company officers have some personal liability too? There is some discussion at prospers.org: http://www.prospers.org/forum/prosper_order_to_cease_and_desist_by_sec-t10903.0.html No one seems sure just yet... SEC: UNITED......
• A Look At the Graphs and Charts from Quicken in My Prosper.com Account Last week I merged RateLadder's Quicken solution with a Solution from Adam Nash, then I followed up with a post on How Easy The Solution is to Implement and My ROI According to Quicken. Having looked a little into deeper Quicken I have found a graph I want to show:......
• Prosper.com and Quicken -- The workable solution for playmates that don't get along. Prosper.com and Quicken (or Money) do not play nicely.  In fact, they can be downright burdensome to make them bridge the gap.  Here I present my workable solution, but this should be addressed by Quicken, Money, and Prosper.com   The heart of the problem is that Quicken doesn't understand the Prosper.com model...  Sure......
• Another Step in the Prosper Lawsuits Against Borrowers As I have talked about before Prosper is going to sue deadbeat borrowers and I have opted to join the suit as opposed to receiving an equivalent to the last junk debt sale buyout.  For me this meant giving up ~$30 to remain on the lawsuits of 6 of my delinquent......
• Prosper in May Set a New Monthly Loan Origination Volume High Water Mark (sql to produce statistics at the end of post)  In May, Prosper originated more loan volume than in any previous month roughly 9.6M loans the vast majority were credit grades AA-C.  This is great news for Prosper on 2 fronts: total volume and loan quality. Here is the breakdown... May......

Related Websites

• Personal Finance Equations You Should Know: the Amortization Equation Amortization is probably one of the most ubiquitous financial concepts that encompasses our daily lives, but yet, few of us know what it means, how it works, much less, how the monthly payments on all our stuff is calculated. By definition, amortization is: The reduction of a debt over time......
• Delaying Social Security after Stopping Work Some baby boomers are asking the question of what happens to their Social Security retirement benefits if they stop working but do not claim benefits until later. The answer to that question depends on how many working years you have in the system. Your Social Security retirement benefit is based on......
• Dave Ramsey Baby Steps Defined It seems a bit like a rite of passage for every personal finance writer to share their opinion of Dave Ramsey. That alone speaks volumes about Ramsey's reach in the personal finance sector, but not all of the reviews have been glowing. I personally consider his book, The Total Money......
• Paying off Debt in 9 Steps pt 1 Throwing away your bills and shredding your credit card payment reminders simply is not going to make the problem go away. Debt is going to hover over you until you find a way to deal with it. Interest will continue to compound, and payments will continue to climb until you......
• Running through payback time on a mortgage refinance Five Cent Nickel posted on how to calculate the payback period for a potential mortgage refinance.  It's indeed important to figure this out before paying for a refinance that might never save any money.  (There are plenty of ways to blow money that are more fun than going through a......

Online Stores

• Security Keypads Home Security Home Improvement
• Omron Step Pedometers Monitors & Pedometers Gym, Workout & Yoga Exercise & Fitness
• Deluxe Step/Riser Sets Fitness Equipment Gym, Workout & Yoga Exercise & Fitness
• Step Stools Kitchen Furniture Home Store
• Work Benches Benches, Chairs & Lounges Patio & Garden Furniture Yard, Garden & Outdoor Living Nursery

If you liked this article, vote for it on del.icio.us and stumbleupon.


Categories:

Prosper.com, Quicken, Tools

Tags:

azerbaijan, mozambique