I created an app called POKIRSCAN (see the IRS substring? lol). From PokerStars playing audit CSV files it computes your total winnings and losses and reports them separately, which the IRS requires you to do on every tax return, and a lot of local and state gov'ts too. It combines games of the same format and buy-in played within 60 minutes into one session. Most people think this is legal and it saves you a lot of money. Enjoy! And consider a donation on the project page. But use with caution, it's version 1.

http://pokirscan.sf.net

Does it work for all games/structures or just NLHE cash?

I should note the IRS only prohibits amateur gamblers from netting out their wins, but if you're pro you probably knew that.

Also, this is a good tool if youre just curious abouts your accumulated winnings and losses, something you cannot tell by just looking at your cashouts or balance.

Works for everything. Also counts bonuses (which are taxable), rebuys, addons, W/T$ sales, etc. The only thing it won't count is receiving money from a player, and possibly new sign up bonuses. If anyone wants these counted just PM me the text in the "actions" column of the sign up bonus or receiving money event in your audit CSV.

Interesting. Will try and, if useful, donate. This could be an epic headache saver.

I should read my own source code. It actually does compute signup bonuses (the 600 dollar bonus)

I fixed a bug, occasionally games weren't getting combined. Players should re-scan. Download at least version 1.1.0. Thanks.

FTP version please and does this include tournaments/sng's as well?

Unfortunately, FTP does not provide playing audits like PokerStars does. Maybe worth asking them to do this. If you want to send me a healthy sample of FTP hand histories, i'd like to add a feature to compute gross winnings/losses from that. promise to never play you if you send HH.

Includes everything from tourney/sngs, cash, rebuys, addons, bonuses (they're taxable), satellites, unregistering, etc. Only thing it doesn't count is player transfers to you. I just don't know what the code is for it in the audit. If you have one PM me the text in the "actions" cell of the transfer's row.

also i'm reasonably confident in the accuracy of the app now, as opposed to before in my original post. i've gone over and over the code, and released several updates since

I could really use something like that for FTP. I wish FTP provided the same hand histories

So it's been a couple of weeks, how are people liking the app? Any suggestions other than adding FTP support (which I still need HH for)?

how does it handle transfers in and out of your account?

It ignores those. I don't suppose you mean deposits because money from your own bank account to your poker account isn't income and isn't taxed. But you probably mean from other players. I just don't have the "action" id used in the audit since I've never done a transfer. Could you look in the audit CSV and tell me the text in the audit column of the row of your transfer? Also, I guess I should make it configurable to count transfers since some people are escrowing etc.

yes, I meant player to player transfers. It is def preferable not to have them counted as income or losses (for a million reasons). I haven't tried this yet, but when I do I will provide the info requested. thx

So to clarify, player transfers are not counted and will never be by default. Thanks and enjoy.

will definitely try this. If it works, definitely a HUGE headache saver

Beta support for Full Tilt will be out soon. Players there with HHs and pokertracker or the like (at least willing to install free demo) please PM me to beta test. Will get back to you by end of next week.

(note that this app won't depend on pokertracker or something weird, just for testing)

maybe a mod could remove "(Stars)" from the thread title if they're feeling nice

Full Tilt Poker is now supported, just in beta though. PokerStars is of course supported too.
http://pokirscan.sf.net

If you want to add up your Full Tilt gross wins and losses and compare that to the net from another program, please tell me how it matches up. And please report any errors. Enjoy.

Full Tilt added a new feature that lets you request past hand histories and you can save them to your computer. As a new feature in 1.10.0, if you put those files in a folder my app can read those and tell you your stats. And of course it still works on a regular hand history folder too.

So if you use Poker Stars or Full Tilt, there really is a simple way to know what you owe in taxes even if you never took notes or saved histories along the way, and you save a lot by having games netted/combined in sessions. Now back to poker.

how do you make a CSV file out of the xls?

In PokerStars there's an option to save as CSV when youre requesting your audit. (Off topic, you can also open in Excel and save as xls, but don't do that for POKIRSCAN).

And don't worry about unzipping, it accepts the zip of the CSV stars gives you.

There is a new, stable release today. http://pokirscan.sf.net/ PokerStars and now Full Tilt Poker are supported. Use your PokerStars playing audit, Full Tilt hand histories, or Full Tilt hand history request file(s) from the web. The combining/netting of games of same stakes played within the set idle time saved me $2.5K.

I keep getting error code 3" while using v. 2.0.7, got stars csv (zipped). Running windows 7 ultimate 64bit. any ideas why? thanks in advance and I'll ship some $$ on my next cashout, provided I get this to work.

hi, error code 3 means that the app tried to skip over 3 lines in your stars CSV file but there weren't that many lines. please double check the README and that you're using the right settings requesting your CSV.

then try using another application to unzip the archive and take a look at the csv file in Notepad or something and let me know if there are at least three lines (turn word wrap off).

the first 3 lines it skips because they just contain the title and some headings. if you want to remove sensitive info from the file and send me the first portion of it, i can take a look at it.

let me know what you find. thanks. (also, i stopped accepting donations for this app, never received any anyhow, so no worries)

I ran it and my computer asked me to connect my phone, ROFL. I'm guessing it just has something to do with file associations; I'll look into it later. I just thought it was a pretty funny random event.