I upgraded to Q2005 Premier H&B in April '05. For years I've been recording
all stocks in one account called "Stocks". When it comes time to transfer
the data to the tax software the following year, I get one figure for all my
dividend income. all under "Stocks". Subsequently, I have to edit the tax
software by changing the name "Stocks" to my first 1099-DIV then adding new
records for each one thereafter. Surely there's a better way than this. I'm
open for suggestions.
Not totally clear from your post what your situation is - but sounds
like you have one QW account which contains all of your security
You get multiple Form-1099's from different issuing entities or
You want QW's tax reporting to sync with the Form-1099's.
Suggest you create separate investment account for each Form-1099
issuer; i.e, each brokerage account and/or individually held stock.
Realize this could be cumbersum if you hold quite a few stocks
individually [outside a brokerage firm].
That's correct, JM; I have the brokerage as well as stocks I hold personally
in that account. Any recommendation for naming these? STOCKS is the account
name now. I have three brokerage accounts and hold certificates as well.
John - want to retract my earlier recommendation - on further review it
will not accomplish your goal - would still get dividend income lumped
in one total.
I do have an alternate that I have been experimenting with - it
parallels your dividend query.
Background - I have four accounts paying taxable interest income.
QW's Tax Schedule Report lumps these together into one total [same as
My objective is to have QW's Tax Schedule Report provide subtotals for
each payee - matching the four 1099-INT forms I get.
Have created a class for each payee; e.g., CHK, SAV, MM, BRKR - [last
one is brokerage].
Have assigned 'Copy Number' to each class; e.g., 1, 2, 3, 4
Interest paid in my checking account is categorized '_IntInc/CHK', etc.
This is handled easily in cash flow accounts - downloads get
automatically categorized with a combination of a memorized transaction
The bokerage account is more difficult.
Downloads come in as '_IntInc' and QW will not let you add the class by
a simple Edit Transaction.
I do a copy/paste and move the income from '_IntInc' box to the
'Miscellaneous' box and then assign the category '_IntInc/BRKR'.
I then delete the original downloaded transaction.
End result is that I get four subtotals for '_IntInc' in the Tax
Schedule Report which match up with the year-end 1099-INT forms.
I infer that you export QW's data to your tax prep software.
I do not know how my approach would export as I do not export due to
complications with other taxable income from my portfolio. My goal is
to generate a Tax Schedule Report that sync's with the 1099's and
provides quick and easy data entry into the tax program.
Bottom line is that this approach will also work for dividends - you
could assign a class for each brokerage and each individually held
stock. You must be entering all transactions manually since all
holdings are in a single account [?] - assigning category/class would
not be difficult in this case.
Back to your original query and response - I would still recommend
re-aligning you QW records to reflect the real world. Would have
separate QW accounts for each brokerage account and one account for all
securities held outside of a brokerage account.
BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here.
All logos and trade names are the property of their respective owners.
Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee
neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.