My point exactly. Good info on this thread, but the whole premise is bogus (buy tradelog) Spreadsheets are easy. You can record 30 trades a day in less than 10 minutes. Rollup end of year data to compare with broker data and voila...............now expense accounting.....THAT should be the thread!! BTW, I'll not post my spreadsheet until I can market it and disguise it in a bogus thread...
I agree. Serious traders MUST log every single trade. And I do that in an Excel spreadsheet too. My systems actually log most trades automatically. But reporting accurately more than 2000 stock and option swing trades on a sched D form and "attach extra pages as necessary..." even electronically, is a drag of head-splitting proportions. Hell, Turbo Tax chokes on far less than that! Yes, you can make Excel crank out sched D basis and trade info from your logs, but...forget it, it's too damn early to be talkin' taxes!
Wow, you guys really need to get up to speed. There have been mulitple changes in the last couple years, our old lazy "details upon request" are not accepted anymore (not that they really were). Agreed, that the CURRENT best way is a crate of trade executions--line item Sch. D style. Try keeping up with 300-500 executions a day on spreadsheet and adjusting for wash sales....no thanks. Also agreed that Tradelog is a great product, gainskeeper as well. Use them or lose it......to the IRS.
Oh yeah, I know what the rules are, but until they drag my ass into an audit, they get what they get. To me, the important part is that I do pay all taxes I'm obligated for. One of these dayz, they'll probably call me on it...
mr nbbo who says the irs won't accept anymore? the irs never officially allowed summarized accounting and had never made a statement on it. all they did in 2005 is reiterate there position to list every line which was really there policy to begin with. the idea is because some part time traders who might trade 3000 times a year but only over 40% of the year are filing as traders with writeoffs. with the sch d itemized they can see all the trades and frequency.but for somebody who trades 100k times and there scd d total sales match up i highly doubt they'll every question summarized accounting as the irs has no interest in seeing 1000 pages of sch d. like another poster said if they want it let them pull the 1000's of pages and do it themselves. if you pay what you owe you never have anything to worry about
Gainskeeper is great for stocks and options. I used it for years and never had a problem. This is just one more reason I don't regret moving to trading futures.
Okay okay...I'm looking into TradeLog and Gainskeeper. They are far more sophisticated than they were a few years ago, when I looked at the trade reporting SW that was available then. Mayyybeee I will try 'em. Hell, couldn't hurt!
I have been using this SW and my experience is very bad. I would not trust reporting taxes based on it. My recommendation is to look for something better. One important point to consider is to look for SW that imports transactions in OFX format. In this way it is independent on the specific format of broker statements.