Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
 
Old 06-15-2006, 06:35 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Investment activities and tax reporting

In microsoft.public.money, eSapient wrote:

- quote -

> I have an investment account. There are some transactions in it which
> correspond to 'Activity = Dividend'. Their amounts are 'transfer'ed to
> a checking account. In the checking account, I see 'Category = Transfer
> > From : investment account'. These transactions cannot be added to a

> 'tax line'. I can't have these transactions automatically picked up for
> my tax report. Am
> I missing something? What is the intent of the design of Money
> regarding these transactions and tax reporting?


Normally the dividends will be in the Investment Transactions, as
you are describing. The dividends should show up in reports such as
the tax-related transactions report and the investment transactions
report.

I suggest switching your reports to Advanced if you have not done so
already.

- quote -

> I am using Microsoft Money for Small Business.
> I understand that for a transaction to be regarded as 'dividend income'
> for purposes of tax calculation, its category must be one associated
> with 'dividend income'. But in my investment account register, I see
> the entry without any category attribute, and if I see the
> corresponding transaction in my checking account register, the category
> is 'Transfer From : investment account' which I cannot find in the 'Set
> up your categories' list, and the category of the checking account
> register entry cannot be changed.


Microsoft Money is very good at producing the information for
schedule D, if you have been downloading or entering your Buys and
Sells. That is really nice. TaxCut and TurboTax are the only two
income tax programs that use this data directly AFAIK. If you do
not have that many sells, you can copy the data from Money's tax
reports by hand into cheaper tax programs, such as TaxAct.

While Microsoft Money can produce entries for other things like
dividends, interest, W-2, etc, few people keep the data perfectly.
Some of the items recorded as dividends may be return of capital or
other special cases. Some may be non-qualified dividends. Since you
will be sent 1099s and perhaps 1098s for these, it will usually be
best IMO to use the 1099 data where it is provided instead of the
Money data for the dividends.

Preparing the Schedule D is one of the best thing the Money program
does for me. Both TaxCut and TurboTax can import the TXF (Tax
eXportFiles) files that Money produces.

If I were preparing a schedule C, the data that Money can send to
the tax program would be very useful. You do not get 1099s for
that information, for the most part. But I don't do that now. If
you itemize, the schedule A information should be useful.


There can be other things that Money can track and provide the
information for your tax return

So how do I proceed ? In Money 2006,
Taxes-> TaxTools-> ExportToTaxSoftware

Set the ReviewTaxesFor drop-down to Completed2005TaxYear.
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.

In Money 2005 and 2006, 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.


To pass information to TaxCut or TurboTax that are installed on
your computer, click Continue. This writeup is not written with
the use of the on-line tax software in mind. If you plan to use
online tax software, read elsewhere about that.

I recommend that you not use the options for TaxCut or TurboTax,
but instead choose UseTaxSoftware, and "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.


  #-1  
Old 06-15-2006, 06:17 AM
eSapient
Guest
 
Posts: n/a
Default Investment activities and tax reporting

I have an investment account. There are some transactions in it which
correspond to 'Activity = Dividend'. Their amounts are 'transfer'ed to
a checking account. In the checking account, I see 'Category = Transfer
- quote -

> From : investment account'. These transactions cannot be added to a
'tax line'. I can't have these transactions automatically picked up for
my tax report. Am
I missing something? What is the intent of the design of Money
regarding these transactions and tax reporting?

I am using Microsoft Money for Small Business.

I understand that for a transaction to be regarded as 'dividend income'
for purposes of tax calculation, its category must be one associated
with 'dividend income'. But in my investment account register, I see
the entry without any category attribute, and if I see the
corresponding transaction in my checking account register, the category
is 'Transfer From : investment account' which I cannot find in the 'Set
up your categories' list, and the category of the checking account
register entry cannot be changed.

 

Tags
activities, investment, reporting, tax
Similar Threads
Thread Forum Replies Last Post
Investment activities and tax reporting
eSapient: I have an investment account. There are some transactions in it which correspond to 'Activity = Dividend'. Their amounts are 'transfer'ed to a...
Microsoft Money 4 04-12-2006 12:29 AM
Investment report for totals of activities - seperately
Tracy_Lit5: I can create a report Performance By Account, but it shows the Buys to include all Buys AND Add Shares. The Short Sells are already there, so that...
Microsoft Money 3 04-29-2005 01:36 AM
Not all investment activities show in the list
Bill Mac: I am unable to add a short-term cap gains transaction for one of my investments in MS Money Sm Business 2004. The drop-down list does not contain...
Microsoft Money 4 02-10-2005 09:07 PM
Investing - Record special activities
RNS: I use Money 2004 Standard and I need to record a spinoff. The Help file says this should be an option within the 'Record a special activity" menu,...
Microsoft Money 1 01-22-2005 10:21 PM
Investment Reporting
Paul Keller: Is there a standard report in 2004 or can a custom report be created to compare investment performance to an index?
Microsoft Money 1 02-08-2004 09:26 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 08:03 PM.