tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/4593-cost-basis-report-with-tax-lot-informationInfinite Kind: Discussion 2019-11-21T00:00:23Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/475356252019-08-18T12:33:17Z2019-08-18T12:33:19ZCost Basis Report with Tax Lot information?<div><p>I'm looking for a way to show all tax lot information for all accounts/securities.</p>
<p>I can review the tax lot details for each account/security in the Security Details view, but I'd like a report so I can easily export the data for all accounts/securities to excel or a pdf without having to manually capture the details for each security.</p>
<p>Does such a report exist?</p>
<p>Thanks</p></div>magellantag:infinitekind.tenderapp.com,2009-01-14:Comment/475356252019-08-19T13:51:19Z2019-08-19T13:51:20ZCost Basis Report with Tax Lot information?<div><p>Well moneydance sure is flexible. I'm a complete python noob, but I was able to create a script that shows all open tax lots for all accounts/securities as of the current date.</p>
<p>Just in case anyone else needs this, the python script is attached. Typical disclaimers apply - This is the first snippet of python code I've ever written as well as my first attempt at moneydance coding, so I really have no idea what I'm doing - Run the script at your own risk.</p>
<p>The script only produces meaningful output if you have at least one security with a positive share balance and the Cost Basis set to 'Lot Matching'</p>
<p>You can run the report by selecting Window->'Show MoneyBot Console', pasting the text from the attached file into the Python Snippet window, and clicking the 'Run Snippet' button.</p>
<p>It's easier to read the output if you copy/paste it into excel and format the 'Available Shares' and 'Cost Basis' columns</p></div>magellantag:infinitekind.tenderapp.com,2009-01-14:Comment/475356252019-08-19T21:14:22Z2019-08-19T21:14:25ZCost Basis Report with Tax Lot information?<div><p>The script above was a good first effort, but further testing revealed that it doesn't handle splits correctly. This new and improved one should be better.</p>
<p>I just finished verifying the information for all of the outstanding lots against what Quicken has and it checks out.</p>
<p>One thing I realized in this exercise is that the MoneyDance Lot Matching window shows the split adjusted share count for each lot, but it doesn't show the adjusted price.</p>
<p>So if I understand it correctly, you can't use the information shown in the Lot Matching window to compute the capital gains on the sale if you have splits. That's a bit of a problem because the Cost Basis and Capital Gains reports are a bit lacking w.r.t. specific lot id reporting.</p></div>magellantag:infinitekind.tenderapp.com,2009-01-14:Comment/475356252019-08-19T21:19:03Z2019-08-19T21:19:04ZCost Basis Report with Tax Lot information?<div><p>Sorry, the file above was the same as the original upload.</p>
<p>Hopefully this is the correct one.</p></div>magellantag:infinitekind.tenderapp.com,2009-01-14:Comment/475356252019-08-21T23:54:55Z2019-08-21T23:54:56ZCost Basis Report with Tax Lot information?<div><p>Sorry for all the spam. Another version with better output formatting.</p></div>magellan