Money: How to Track Tax-Exempt Dividends
  
PSS ID Number: Q130467
Article last modified on 12-12-1997
 
3.0 3.0a 4.0 4.0a 5.0
 
WINDOWS
 

======================================================================
3.0 3.0a 4.0 4.0a 5.0
WINDOWS
 
-----------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Money version 5.0 for Windows 95
 - Microsoft Money versions 4.0 and 4.0a for Windows 95
 - Microsoft Money versions 3.0, 3.0a
-----------------------------------------------------------------------
 
SUMMARY
=======
 
If you have stocks or mutual funds invested in an IRA or a 401(k)
retirement plan, you may want to track dividends as tax exempt
dividends for tax reporting purposes. This must be done manually in an
associated Cash Account.
 
MORE INFORMATION
================
 
In the Investment Account, when you choose Dividend as your investment
activity, Money internally categorizes this as Investment
Income/Dividend Income.
 
When you choose Reinvest Dividend as your investment activity, Money
internally records this as two transactions; a Dividend transaction and
a Buy transaction. Because Money does this internally, you can not
designate the Dividend as a tax-exempt activity. Performing these tasks
manually allows you to designate the correct subcategory
 
To track a dividend as tax-exempt, manually enter the dividend in an
associated Cash Account. If the dividend was reinvested, use the
following steps to enter Buy transactions.
 
1. To track these dividends, you must create an investment income
   subcategory called Tax-Exempt Dividend.
 
   Money 5.0, 4.0:
 
   a. Go To the Payees & Categories window.
 
   b. Click Categories.
 
   c. Select the Investment Income category, and click New.
 
   d. Select Subcategory of Investment Income and enter the following
      name:
 
         Tax-Exempt Dividend
 
   e. Click Next, and answer Yes to the question of whether it is tax
      related.
 
   f. If you plan to export tax information to tax preparation
      software, assign this subcategory to the proper tax form.
 
      1) Click Go To Details.
 
      2) On the Tax Form list, click Schedule B.
 
      3) On the Form Line pulldown list, click Div Inc., Non-taxable.
 
   Money 3.x:
 
   a. On the List menu, click Category List.
 
   b. On the Category List, click Investment Income.
 
   c. On the Investment Income subcategory list, click New.
 
   d. In the Name box, type the following and click OK:
 
         Tax-Exempt Dividend
 
   e. Select Include On Tax Reports.
 
   f. If you plan to export tax information to tax preparation
      software,
      assign this subcategory to the proper tax form.
 
      1) On the Tax Form list, click Schedule B.
 
      2) On the Tax Form Line pulldown list, click Div Inc., Non-
         taxable.
 
   g. Click Close.
 
2. To track Dividend Income for Tax Exempt Investments categories, use
   an associated Cash Account. If your investment account does not have
   an associated Cash Account, you can modify your investment account
   to include one.
 
   Money 5.0, 4.0:
 
   a. In Account Manager, select the account you use to track your tax
      deferred investments.
 
   b. Click Account Detail, and click Modify.
 
   c. Select Cash Account Enabled and click OK.
 
   d. Leave the Opening Balance empty and click OK.
 
   Money 3.0:
 
   a. On the List menu, click Investment Account List.
 
   b. Select the account you use to track your tax deferred
      investments.
 
   c. Click Modify.
 
   d. Select Cash Account Enabled and click OK.
 
   e. Leave the Opening Balance empty and click OK.
 
   f. Click Close.
 
3. Use the following steps for your version of Money:
 
   Money 5.0, 4.0:
 
   Go To the Account Register and select the associated Cash Account
   for the Investment account.
 
   Money 3.0:
 
   In the Investment Details window, click the Cash Account button for
   your tax deferred account.
 
4. Record the dividend paid on your tax-exempt investment as a
   transaction in the Cash Account using the following steps:
 
   a. In the Date field, type the date the dividend was paid.
 
   b. In the Payee field, type "dividend" (without the quotation marks)
      and your investment's name.
 
   c. In the Deposit field, type the amount of the dividend.
 
   d. In the Category field, type "Investment Income" (without the
      quotation marks).
 
   e. In the Subcategory field, type "Tax-Exempt Dividend" (without the
      quotation marks).
 
   f. Press ENTER to record the transaction.
 
5. If the dividend was reinvested, record the Buy transaction in the
   Cash Account using the following steps:
 
   a. In the Date field, type the date of the reinvestment.
 
   b. In the Payee field, type "Reinvest Dividend" (without the
      quotation marks).
 
   c. In the Payment field, type the amount of the dividend.
 
   d. In the Category field, type "Buy Investment" (without the
      quotation marks).
 
   e. In the Buy Investment dialog box, complete the information for
      the purchase of the investment.
 
   f. Click OK.
 
KBCategory: 
KBSubcategory:
 
Additional query words: kbhowto w_money 3.00 3.00 401k 401K 4.00
money95 Rollerbob
money_95 95_money
 
======================================================================
Version           : 3.0 3.0a 4.0 4.0a 5.0
Platform          : WINDOWS
=============================================================================
Copyright Microsoft Corporation 1997.