Tax Records - Dividend Recording By Stock Name

Not totally clear from your post what your situation is - but sounds like you have one QW account which contains all of your security holdings. You get multiple Form-1099's from different issuing entities or brokerage firms? 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 for dividends]. 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 respectively. 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 and quickfill. 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.