Home Page link  

Correcting for wash sales

  
Groups | Search | About
User Password
Register Now! Lost Password?

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Correcting for wash sales Jay Levitt 10-26-2006
Posted by Jay Levitt on October 26, 2006, 6:55 pm
Please log in for more thread options
 Could somebody check my "Quicken math" on this?

I buy 100 shares of ABC on 1/1/05, and sell all 100 on 3/1/05 for a $25
loss.

I then buy 10 shares of ABC @ 10 ea. on 3/15/05 (total cost: $100). I
don't sell them during 2005.

The sale on 3/1/05 is now a wash sale. So I:

- Add a $25 offsetting transaction to my Schedule D spreadsheet
- Change the "Buy" on 3/15 into an "AddShares/ShrsIn" so I can set the lot
date to 1/1/05
- Add a MiscExp transaction on 3/15 for $100 since I did really buy the
shares
- Add a RtrnCap transaction on 3/15 for $25 to offset the loss

Is that right? Is that the best way to do this?

Jay Levitt

Posted by A Count on October 26, 2006, 9:59 pm
Please log in for more thread options
> Could somebody check my "Quicken math" on this?
> I buy 100 shares of ABC on 1/1/05, and sell all 100 on 3/1/05 for a $25
> loss.
> I then buy 10 shares of ABC @ 10 ea. on 3/15/05 (total cost: $100). I
> don't sell them during 2005.
> The sale on 3/1/05 is now a wash sale. So I:
> - Add a $25 offsetting transaction to my Schedule D spreadsheet
> - Change the "Buy" on 3/15 into an "AddShares/ShrsIn" so I can set the lot
> date to 1/1/05
> - Add a MiscExp transaction on 3/15 for $100 since I did really buy the
> shares
> - Add a RtrnCap transaction on 3/15 for $25 to offset the loss
> Is that right? Is that the best way to do this?
>

Only ten shares is a wash sale...

Sell 90 shares of the first transaction for a 22.50 loss. Sell 10 shares of
the first transaction for break even.
Adjust the basis of the 10 share buy...by -2.50 .



Posted by A Count on October 26, 2006, 10:04 pm
Please log in for more thread options
>> Could somebody check my "Quicken math" on this?
>> I buy 100 shares of ABC on 1/1/05, and sell all 100 on 3/1/05 for a $25
>> loss.
>> I then buy 10 shares of ABC @ 10 ea. on 3/15/05 (total cost: $100). I
>> don't sell them during 2005.
>> The sale on 3/1/05 is now a wash sale. So I:

Correcting:

> Only ten shares is a wash sale...
>
> Sell 90 shares of the first transaction for a 22.50 loss. Sell 10 shares
> of the first transaction for break even.
> Adjust the basis of the 10 share buy...by +2.50 .
>



Posted by TomYoung on October 26, 2006, 10:26 pm
Please log in for more thread options
Jay Levitt wrote:
> Could somebody check my "Quicken math" on this?
>
> I buy 100 shares of ABC on 1/1/05, and sell all 100 on 3/1/05 for a $25
> loss.
>
> I then buy 10 shares of ABC @ 10 ea. on 3/15/05 (total cost: $100). I
> don't sell them during 2005.
>
> The sale on 3/1/05 is now a wash sale. So I:
>
> - Add a $25 offsetting transaction to my Schedule D spreadsheet
> - Change the "Buy" on 3/15 into an "AddShares/ShrsIn" so I can set the lot
> date to 1/1/05
> - Add a MiscExp transaction on 3/15 for $100 since I did really buy the
> shares
> - Add a RtrnCap transaction on 3/15 for $25 to offset the loss

As a matter of tax law - of which I'm no expert - I think you could
claim 90% of the loss since 10/100 = 10%. However, we'll stick with
your premise that the full $25 has to be added to the basis of the
3/15/05 purchase.

I did it this way:

Left the 1/1/05 Buy and 3/1/05 Sale alone.

Entered an ABC stock RtrnCapX transaction between the Buy and Sell
dates for $25.
(Doesn't affect cash, results in no gain/loss on 3/1/05 which is the
situation for tax purposes, if not GAAP purposes.)

Added the 10 shares of ABC @ $10/sh on 3/15/05 with a lot date of
1/1/05

Entered an ABC stock RtrnCapX transaction on 3/15/05 for ($25).
(Doesn't affect cash, adds to $100 actual cost basis of new 10 shares.)

Did an XOut transaction of $100 on 3/15/05.
(Gets cash in account correct for 3/15/05 purchase, doesn't show up on
a Income/Expense report.)

Of course, I'd document as much as I could in each entry's memo field
so I could figure out what the hell I did here when I was looking at
these entries 2 or 3 years down the road. :-)

Tom Young


Posted by Jay Levitt on October 27, 2006, 4:18 pm
Please log in for more thread options
On 26 Oct 2006 19:26:48 -0700, TomYoung wrote:

> As a matter of tax law - of which I'm no expert - I think you could
> claim 90% of the loss since 10/100 = 10%.

I did not realize that! I was reading the fairmark.com guide to wash sales
instead of the actual IRS pub, and they never deal with the case where the
lots are different sizes. Argh. Thanks for pointing that big mistake out.

> However, we'll stick with
> your premise that the full $25 has to be added to the basis of the
> 3/15/05 purchase.
>
> I did it this way:
>
> Left the 1/1/05 Buy and 3/1/05 Sale alone.
>
> Entered an ABC stock RtrnCapX transaction between the Buy and Sell
> dates for $25.
> (Doesn't affect cash, results in no gain/loss on 3/1/05 which is the
> situation for tax purposes, if not GAAP purposes.)

Makes sense. I'm just editing the Schedule D output manually in Excel,
which accomplishes the same thing for tax purposes.

> Added the 10 shares of ABC @ $10/sh on 3/15/05 with a lot date of
> 1/1/05
>
> Entered an ABC stock RtrnCapX transaction on 3/15/05 for ($25).
> (Doesn't affect cash, adds to $100 actual cost basis of new 10 shares.)

Ah! Right, that RtrnCap needs to be negative. I discovered that when I
found that selling a lot with a negative cost basis does verrry interesting
things in Quicken.

> Did an XOut transaction of $100 on 3/15/05.
> (Gets cash in account correct for 3/15/05 purchase, doesn't show up on
> a Income/Expense report.)

Perfect. I'll use XOut instead of MiscExp, which (turns out) affects the
cost basis.

And yes, I'm commenting heavily on each of these, plus saving the Excel
file which contains a list of wash sales...

Thanks a bunch for the pointers.

Jay

Similar ThreadsPosted
Correcting incorrect matches September 30, 2006, 1:25 pm
Wash sale December 19, 2007, 6:20 pm
Accting for sales tax receipts in Q05 March 28, 2007, 6:48 am
Money Market sales taxable? February 28, 2007, 6:38 pm
Nothing Down, Foreclosure Short Sales and Tax Lien Certificates December 12, 2006, 10:48 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap