Skip to main content
Level 2
March 27, 2024
Question

problem with 1099-div multiple state tax exempt income input

  • March 27, 2024
  • 2 replies
  • 86 views

I have one 1099-div that has multiple states with tax exemptions (actually, 31 states)

When I enter all of these states with their associated values, the program tells me the sum of the individual values does not sum to the total value in box 12. The data I have from my broker is given in percentages. Total from box 12 is $941.71  -  the data I have entered is shown in the table:

 

   
Pennsylvania13.82130.14
New York10.1595.58
New Jersey9.0785.41
Texas8.6181.08
Illinois7.5771.29
California6.3759.99
Alabama4.5743.04
Massachusetts4.2840.31
Arizona3.8135.88
Connecticut3.7935.69
Florida2.9928.16
South Carolina2.9727.97
Colorado2.7325.71
Minnesota2.220.72
Missouri2.1620.34
Tennessee1.8317.23
North Carolina1.7316.29
Iowa1.4813.94
Puerto Rico1.4713.84
Wisconsin1.3813.00
Michigan1.059.89
Indiana1.049.79
Georgia0.98.48
Hawaii0.757.06
Ohio0.696.50
Louisiana0.585.46
Washington0.545.09
District of Columbia0.524.90
Virginia0.444.43
Nevada0.292.73
New Mexico0.191.79
   
  $941.71

    2 replies

    SteamTrain
    Level 15
    March 27, 2024

    @ericlarsanderson 

     

    NO...You're doing unnecessary work.  (probably some strange rounding in your situation though)

     

    You only do Your own state, plus any US Territory (Puerto Rico etc), and the rest are lumped together as one entry as "Multiple States" (Online software) or "More than one state" (Desktop software).

     

    (Unless you live in MN, CA, IL.....and UT is somewhat different too)

    _________________

    Example for an NC resident:

     

    ____________*Answers are correct to the best of my knowledge when posted, but should not be considered to be legal or official tax advice.*
    Level 2
    March 28, 2024

    Many thanks, SteamTrain!

    Very much appreciated.

    @ericlarsanderson