|
#7
| |||
| |||
| One from Verizon and one from GTE. Both show up on my 1099-B along with the other investments that the Capital Gains report found. The sell transaction was in 07, the buy in 06. "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news:h9hbs35nkveupvr6hqnkk4ose9dnmiihdq[at]4ax.com... - quote - > In microsoft.public.money, David Schwartz wrote: > > HEY WAIT-WE'RE NOT DONE YET!!!! > > HOW COME MY BONDS DON'T SHOW UP ON THE CAPITAL GAINS REPORT? > I dunno. I never sold a bond. You mean a corporate or muni bond? And > you did a Buy before and a Sell transaction dated in 2007? > > Dave > > > > > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message > > news gqas391ni9mbmbluogdlsljtnnk96ga1f[at]4ax.com...> > > In microsoft.public.money, David Schwartz wrote: > > > > > > All of the transactions were entered into Money at the time of the > > > > transactions. > > > > How do I calculate the cost basis of the 100 shares of mutual fund I > > > > sold > > > > on > > > > July 1, 2007? > > > > > Good. In the US, there are three permitted ways to report mutual > > > fund sales. Once you have used an average basis method for a given > > > fund, you are required to stick with it. Since you only now have > > > sold this fund, and you want to use the specific shares method with > > > FIFO, go to the Details for the fund by right-clicking any > > > reference. On the CostBasis item, select ActualCostBasis. > > > > > Once you have done that, just enter a Sell of 100 shares. Depending > > > on settings, Money will either assume FIFO or make that a selection. > > > When you generate the Schedule D info, Money will actually make an > > > entry for each lot that has shares sold. It could combine them, but > > > it does not. > > > > > The Capital Gains report should then tell you what the lot data was. > > > Even better is to have Money create a TXF file that you can feed to > > > TaxCut or TurboTax to fill out your schedule D. > > > > > So how do you proceed ? In Money 2007, > > > Taxes-> TaxTools-> ExportToTaxSoftware > > > > > Set the ReviewTaxesFor drop-down to Completed2007TaxYear. > > > Continue. > > > > > Select the items that you want Money to send to the tax program, > > > and de-select those things that you will instead pull off of the > > > 1099s. This may be Schedule A, Schedule C, and both long- and > > > short-term capital gains, depending on your needs. > > > > > If you want to print a tax report for > > > yourself or your tax preparer, do not click Continue at this point. > > > Instead click File-> Print to print the selected tax information. > > > This may be in two sections: the forms, line numbers and amounts > > > for most of the selected items, and then the information for > > > Schedule D. > > > > > I recommend that you "Export your tax information > > > as a data file you can use with any tax software program". This > > > will produce a .txf file. I suggest you do not use the FileByHand, > > > UseTurboTax, or UseACPA choices in Money 2005 or 2006. Start your > > > tax program. Make a copy of your tax file under another name. > > > Then File-> Import the .txf file. If you see that you selected the > > > wrong information for export/import go back to Money and re-select > > > the items. Then go back to the copy of the tax program that you > > > had not imported into yet, save another copy of that and > > > File-> Import the revised .txf file. > > > > > > > In cases where you wanted to see the tax lot info without entering a > > > sell, the CaptitalGainsManager can let you do that. That is useful > > > when you are thinking about selling and telling the broker which > > > shares you want to sell in advance. > > > > > > A better question is, "How do I get Money to calculate the cost basis of > > > > the > > > > 100 shares of mutual fund I sold on July 1, 2007." > > > > Also, if the FIFO principle determines that some of the 100 shares, but > > > > not > > > > all were purchased less than a year before the sale, which would make > > > > the > > > > proceeds short term capital gain, will the program tell me that also or > > > > do > > > > I > > > > have to do that manually? > > > > Dave > > > > |
|
#6
| |||
| |||
| In microsoft.public.money, David Schwartz wrote: - quote - > HEY WAIT-WE'RE NOT DONE YET!!!!
I dunno. I never sold a bond. You mean a corporate or muni bond? And> HOW COME MY BONDS DON'T SHOW UP ON THE CAPITAL GAINS REPORT? you did a Buy before and a Sell transaction dated in 2007? - quote - > Dave > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message > news gqas391ni9mbmbluogdlsljtnnk96ga1f[at]4ax.com...> > In microsoft.public.money, David Schwartz wrote: > > > > All of the transactions were entered into Money at the time of the > > > transactions. > > > How do I calculate the cost basis of the 100 shares of mutual fund I sold > > > on > > > July 1, 2007? > > > Good. In the US, there are three permitted ways to report mutual > > fund sales. Once you have used an average basis method for a given > > fund, you are required to stick with it. Since you only now have > > sold this fund, and you want to use the specific shares method with > > FIFO, go to the Details for the fund by right-clicking any > > reference. On the CostBasis item, select ActualCostBasis. > > > Once you have done that, just enter a Sell of 100 shares. Depending > > on settings, Money will either assume FIFO or make that a selection. > > When you generate the Schedule D info, Money will actually make an > > entry for each lot that has shares sold. It could combine them, but > > it does not. > > > The Capital Gains report should then tell you what the lot data was. > > Even better is to have Money create a TXF file that you can feed to > > TaxCut or TurboTax to fill out your schedule D. > > > So how do you proceed ? In Money 2007, > > Taxes-> TaxTools-> ExportToTaxSoftware > > > Set the ReviewTaxesFor drop-down to Completed2007TaxYear. > > Continue. > > > Select the items that you want Money to send to the tax program, > > and de-select those things that you will instead pull off of the > > 1099s. This may be Schedule A, Schedule C, and both long- and > > short-term capital gains, depending on your needs. > > > If you want to print a tax report for > > yourself or your tax preparer, do not click Continue at this point. > > Instead click File-> Print to print the selected tax information. > > This may be in two sections: the forms, line numbers and amounts > > for most of the selected items, and then the information for > > Schedule D. > > > I recommend that you "Export your tax information > > as a data file you can use with any tax software program". This > > will produce a .txf file. I suggest you do not use the FileByHand, > > UseTurboTax, or UseACPA choices in Money 2005 or 2006. Start your > > tax program. Make a copy of your tax file under another name. > > Then File-> Import the .txf file. If you see that you selected the > > wrong information for export/import go back to Money and re-select > > the items. Then go back to the copy of the tax program that you > > had not imported into yet, save another copy of that and > > File-> Import the revised .txf file. > > > > In cases where you wanted to see the tax lot info without entering a > > sell, the CaptitalGainsManager can let you do that. That is useful > > when you are thinking about selling and telling the broker which > > shares you want to sell in advance. > > > > A better question is, "How do I get Money to calculate the cost basis of > > > the > > > 100 shares of mutual fund I sold on July 1, 2007." > > > Also, if the FIFO principle determines that some of the 100 shares, but > > > not > > > all were purchased less than a year before the sale, which would make the > > > proceeds short term capital gain, will the program tell me that also or do > > > I > > > have to do that manually? > > > Dave > > |
|
#5
| |||
| |||
| HEY WAIT-WE'RE NOT DONE YET!!!! HOW COME MY BONDS DON'T SHOW UP ON THE CAPITAL GAINS REPORT? Dave "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news gqas391ni9mbmbluogdlsljtnnk96ga1f[at]4ax.com...- quote - > In microsoft.public.money, David Schwartz wrote: > > All of the transactions were entered into Money at the time of the > > transactions. > > How do I calculate the cost basis of the 100 shares of mutual fund I sold > > on > > July 1, 2007? > Good. In the US, there are three permitted ways to report mutual > fund sales. Once you have used an average basis method for a given > fund, you are required to stick with it. Since you only now have > sold this fund, and you want to use the specific shares method with > FIFO, go to the Details for the fund by right-clicking any > reference. On the CostBasis item, select ActualCostBasis. > Once you have done that, just enter a Sell of 100 shares. Depending > on settings, Money will either assume FIFO or make that a selection. > When you generate the Schedule D info, Money will actually make an > entry for each lot that has shares sold. It could combine them, but > it does not. > The Capital Gains report should then tell you what the lot data was. > Even better is to have Money create a TXF file that you can feed to > TaxCut or TurboTax to fill out your schedule D. > So how do you proceed ? In Money 2007, > Taxes-> TaxTools-> ExportToTaxSoftware > Set the ReviewTaxesFor drop-down to Completed2007TaxYear. > Continue. > Select the items that you want Money to send to the tax program, > and de-select those things that you will instead pull off of the > 1099s. This may be Schedule A, Schedule C, and both long- and > short-term capital gains, depending on your needs. > If you want to print a tax report for > yourself or your tax preparer, do not click Continue at this point. > Instead click File-> Print to print the selected tax information. > This may be in two sections: the forms, line numbers and amounts > for most of the selected items, and then the information for > Schedule D. > I recommend that you "Export your tax information > as a data file you can use with any tax software program". This > will produce a .txf file. I suggest you do not use the FileByHand, > UseTurboTax, or UseACPA choices in Money 2005 or 2006. Start your > tax program. Make a copy of your tax file under another name. > Then File-> Import the .txf file. If you see that you selected the > wrong information for export/import go back to Money and re-select > the items. Then go back to the copy of the tax program that you > had not imported into yet, save another copy of that and > File-> Import the revised .txf file. > In cases where you wanted to see the tax lot info without entering a > sell, the CaptitalGainsManager can let you do that. That is useful > when you are thinking about selling and telling the broker which > shares you want to sell in advance. > > A better question is, "How do I get Money to calculate the cost basis of > > the > > 100 shares of mutual fund I sold on July 1, 2007." > > Also, if the FIFO principle determines that some of the 100 shares, but > > not > > all were purchased less than a year before the sale, which would make the > > proceeds short term capital gain, will the program tell me that also or do > > I > > have to do that manually? > > Dave > |
|
#4
| |||
| |||
| Cheeze, thanks a lot. I hope you didn't sit there and type this whole thing out. I hope it was prepackaged. But thanks anyway. -- David Schwartz Commack, NY "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news gqas391ni9mbmbluogdlsljtnnk96ga1f[at]4ax.com...- quote - > In microsoft.public.money, David Schwartz wrote: > > All of the transactions were entered into Money at the time of the > > transactions. > > How do I calculate the cost basis of the 100 shares of mutual fund I sold > > on > > July 1, 2007? > Good. In the US, there are three permitted ways to report mutual > fund sales. Once you have used an average basis method for a given > fund, you are required to stick with it. Since you only now have > sold this fund, and you want to use the specific shares method with > FIFO, go to the Details for the fund by right-clicking any > reference. On the CostBasis item, select ActualCostBasis. > Once you have done that, just enter a Sell of 100 shares. Depending > on settings, Money will either assume FIFO or make that a selection. > When you generate the Schedule D info, Money will actually make an > entry for each lot that has shares sold. It could combine them, but > it does not. > The Capital Gains report should then tell you what the lot data was. > Even better is to have Money create a TXF file that you can feed to > TaxCut or TurboTax to fill out your schedule D. > So how do you proceed ? In Money 2007, > Taxes-> TaxTools-> ExportToTaxSoftware > Set the ReviewTaxesFor drop-down to Completed2007TaxYear. > Continue. > Select the items that you want Money to send to the tax program, > and de-select those things that you will instead pull off of the > 1099s. This may be Schedule A, Schedule C, and both long- and > short-term capital gains, depending on your needs. > If you want to print a tax report for > yourself or your tax preparer, do not click Continue at this point. > Instead click File-> Print to print the selected tax information. > This may be in two sections: the forms, line numbers and amounts > for most of the selected items, and then the information for > Schedule D. > I recommend that you "Export your tax information > as a data file you can use with any tax software program". This > will produce a .txf file. I suggest you do not use the FileByHand, > UseTurboTax, or UseACPA choices in Money 2005 or 2006. Start your > tax program. Make a copy of your tax file under another name. > Then File-> Import the .txf file. If you see that you selected the > wrong information for export/import go back to Money and re-select > the items. Then go back to the copy of the tax program that you > had not imported into yet, save another copy of that and > File-> Import the revised .txf file. > In cases where you wanted to see the tax lot info without entering a > sell, the CaptitalGainsManager can let you do that. That is useful > when you are thinking about selling and telling the broker which > shares you want to sell in advance. > > A better question is, "How do I get Money to calculate the cost basis of > > the > > 100 shares of mutual fund I sold on July 1, 2007." > > Also, if the FIFO principle determines that some of the 100 shares, but > > not > > all were purchased less than a year before the sale, which would make the > > proceeds short term capital gain, will the program tell me that also or do > > I > > have to do that manually? > > Dave > |
|
#3
| |||
| |||
| In microsoft.public.money, David Schwartz wrote: - quote - > All of the transactions were entered into Money at the time of the
Good. In the US, there are three permitted ways to report mutual> transactions. > How do I calculate the cost basis of the 100 shares of mutual fund I sold on > July 1, 2007? fund sales. Once you have used an average basis method for a given fund, you are required to stick with it. Since you only now have sold this fund, and you want to use the specific shares method with FIFO, go to the Details for the fund by right-clicking any reference. On the CostBasis item, select ActualCostBasis. Once you have done that, just enter a Sell of 100 shares. Depending on settings, Money will either assume FIFO or make that a selection. When you generate the Schedule D info, Money will actually make an entry for each lot that has shares sold. It could combine them, but it does not. The Capital Gains report should then tell you what the lot data was. Even better is to have Money create a TXF file that you can feed to TaxCut or TurboTax to fill out your schedule D. So how do you proceed ? In Money 2007, Taxes-> TaxTools-> ExportToTaxSoftware Set the ReviewTaxesFor drop-down to Completed2007TaxYear. Continue. Select the items that you want Money to send to the tax program, and de-select those things that you will instead pull off of the 1099s. This may be Schedule A, Schedule C, and both long- and short-term capital gains, depending on your needs. If you want to print a tax report for yourself or your tax preparer, do not click Continue at this point. Instead click File-> Print to print the selected tax information. This may be in two sections: the forms, line numbers and amounts for most of the selected items, and then the information for Schedule D. I recommend that you "Export your tax information as a data file you can use with any tax software program". This will produce a .txf file. I suggest you do not use the FileByHand, UseTurboTax, or UseACPA choices in Money 2005 or 2006. Start your tax program. Make a copy of your tax file under another name. Then File-> Import the .txf file. If you see that you selected the wrong information for export/import go back to Money and re-select the items. Then go back to the copy of the tax program that you had not imported into yet, save another copy of that and File-> Import the revised .txf file. In cases where you wanted to see the tax lot info without entering a sell, the CaptitalGainsManager can let you do that. That is useful when you are thinking about selling and telling the broker which shares you want to sell in advance. - quote - > A better question is, "How do I get Money to calculate the cost basis of the > 100 shares of mutual fund I sold on July 1, 2007." > Also, if the FIFO principle determines that some of the 100 shares, but not > all were purchased less than a year before the sale, which would make the > proceeds short term capital gain, will the program tell me that also or do I > have to do that manually? > Dave |
|
#2
| |||
| |||
| And, I should mention, I am running Money 2007 "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news 83as3hub3nb0djl80iv86nlfdm9kaa6g1[at]4ax.com...- quote - > In microsoft.public.money, David Schwartz wrote: > > OK-the most important thing this program can do for me is to figure the > > cost > > basis of shares of stock or mutual fund I have sold within the calendar > > year > > as far tax purposes are concerned (i.e.-transactions reported on > > 1099-B's.) > > > Lets say I sold 100 shares of a mutual fund on July 1, 2007. I first > > started buying the fund in 2000. I have sold some in previous years, > > bought > > some outright in previous years, and reinvested dividends almost every > > month > > which, is, in effect, buying. > > > I understand the First In First Out concept, but can the program figure > > out > > the cost basis of the 100 shares I sold? This can be pretty difficult > > with > > 50 or so transactions over a 7 year period. > Money requires you to enter those 50 or so transactions as Buy, > ReinvestDividend, ReinvestLTCapitalGain etc. > > > How might I get this information? > So your question might be how to get the info into the tax program > after you entered the 50 or so Buy transactions and the Sell > transaction. That has an easy answer, so if that is the question, > re-ask. > If your question is how to get the info to enter the 50 or so > transactions, that is a problem. Your mutual fund company may be > able to provide you with average basis info so that you could enter > an equivalent transaction to represent the older shares. Then when > you sell, you will hand-modify the date for the Schedule D buy to > "Various". > So find out what info is available from your fund company and do > your best. Re-ask once you know what is available if you then wonder > how to enter that into Money. > Keep your current transactions up to date for the future. |
|
#1
| |||
| |||
| All of the transactions were entered into Money at the time of the transactions. How do I calculate the cost basis of the 100 shares of mutual fund I sold on July 1, 2007? A better question is, "How do I get Money to calculate the cost basis of the 100 shares of mutual fund I sold on July 1, 2007." Also, if the FIFO principle determines that some of the 100 shares, but not all were purchased less than a year before the sale, which would make the proceeds short term capital gain, will the program tell me that also or do I have to do that manually? Dave "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news 83as3hub3nb0djl80iv86nlfdm9kaa6g1[at]4ax.com...- quote - > In microsoft.public.money, David Schwartz wrote: > > OK-the most important thing this program can do for me is to figure the > > cost > > basis of shares of stock or mutual fund I have sold within the calendar > > year > > as far tax purposes are concerned (i.e.-transactions reported on > > 1099-B's.) > > > Lets say I sold 100 shares of a mutual fund on July 1, 2007. I first > > started buying the fund in 2000. I have sold some in previous years, > > bought > > some outright in previous years, and reinvested dividends almost every > > month > > which, is, in effect, buying. > > > I understand the First In First Out concept, but can the program figure > > out > > the cost basis of the 100 shares I sold? This can be pretty difficult > > with > > 50 or so transactions over a 7 year period. > Money requires you to enter those 50 or so transactions as Buy, > ReinvestDividend, ReinvestLTCapitalGain etc. > > > How might I get this information? > So your question might be how to get the info into the tax program > after you entered the 50 or so Buy transactions and the Sell > transaction. That has an easy answer, so if that is the question, > re-ask. > If your question is how to get the info to enter the 50 or so > transactions, that is a problem. Your mutual fund company may be > able to provide you with average basis info so that you could enter > an equivalent transaction to represent the older shares. Then when > you sell, you will hand-modify the date for the Schedule D buy to > "Various". > So find out what info is available from your fund company and do > your best. Re-ask once you know what is available if you then wonder > how to enter that into Money. > Keep your current transactions up to date for the future. |
| | |||
| |||
| In microsoft.public.money, David Schwartz wrote: - quote - > OK-the most important thing this program can do for me is to figure the cost
Money requires you to enter those 50 or so transactions as Buy,> basis of shares of stock or mutual fund I have sold within the calendar year > as far tax purposes are concerned (i.e.-transactions reported on 1099-B's.) > Lets say I sold 100 shares of a mutual fund on July 1, 2007. I first > started buying the fund in 2000. I have sold some in previous years, bought > some outright in previous years, and reinvested dividends almost every month > which, is, in effect, buying. > I understand the First In First Out concept, but can the program figure out > the cost basis of the 100 shares I sold? This can be pretty difficult with > 50 or so transactions over a 7 year period. ReinvestDividend, ReinvestLTCapitalGain etc. - quote - > How might I get this information?
So your question might be how to get the info into the tax programafter you entered the 50 or so Buy transactions and the Sell transaction. That has an easy answer, so if that is the question, re-ask. If your question is how to get the info to enter the 50 or so transactions, that is a problem. Your mutual fund company may be able to provide you with average basis info so that you could enter an equivalent transaction to represent the older shares. Then when you sell, you will hand-modify the date for the Schedule D buy to "Various". So find out what info is available from your fund company and do your best. Re-ask once you know what is available if you then wonder how to enter that into Money. Keep your current transactions up to date for the future. |
|
#-1
| |||
| |||
| OK-the most important thing this program can do for me is to figure the cost basis of shares of stock or mutual fund I have sold within the calendar year as far tax purposes are concerned (i.e.-transactions reported on 1099-B's.) Lets say I sold 100 shares of a mutual fund on July 1, 2007. I first started buying the fund in 2000. I have sold some in previous years, bought some outright in previous years, and reinvested dividends almost every month which, is, in effect, buying. I understand the First In First Out concept, but can the program figure out the cost basis of the 100 shares I sold? This can be pretty difficult with 50 or so transactions over a 7 year period. How might I get this information? Thanks -- David Schwartz Commack, NY |
| Tags |
| basis, cost, investment, purposes, sales, tax |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Re: Can't alter Cost Basis of investment in Microsoft Money 14.0.120.1 Cal Learner-- MVP: In microsoft.public.money, Alan Blandford wrote: >I have an investment in my Portfolio for which I paid £500. I understand >that this purchase... | Microsoft Money | 3 | 01-05-2007 08:09 PM | |
| cost basis/avg cost per share David: I've got 2 accounts (mutual funds) set up under a single financial institution. In Portfolio, using Valuations view, Money calculates the cost... | Microsoft Money | 2 | 03-03-2004 11:00 AM | |
| XP M2003 Investment cost basis not showing up in portfolio view Peter Filipski: I have M2003 standard (came with Dell) on XP. For some investments (shares), in the portfolio view nothing shows up in the Cost Basis column. There... | Microsoft Money | 4 | 11-20-2003 03:38 AM | |
| Thread Tools | |
| Display Modes | |
| |