Skip to main content
No. of Recommendations: 0
To: GLSYMTHE

George, in working with your drip spreadsheet that you have so generously shared with all of us, I have added one feature that will come in handy when the 1099's start arriving in Jan/Feb 2000.

On the individual stock spreadsheet, in the empty column next to "Shares" I added "Dividends". I fill in the dividend amounts both under "Amount Sent" as you do, but also under "Dividends". The total of the dividends are in cell 5E (beside all the other totals). When I receive the 1099, a quick glance will tell if the amount reported to the IRS is the same amount I show.

Hope you and/or others can use this too.
Print the post Back To Top
No. of Recommendations: 0
To: GLSYMTHE

Actually, the addition of the "E" at the end would make the name English - Smyth is Irish - just had to point that out. <g>

On the individual stock spreadsheet, in the empty column next to "Shares" I added "Dividends". I fill in the dividend amounts both under "Amount Sent" as you do, but also under "Dividends".

The thing that I like about using a spreadsheet is that it can be bent and shaped to suit the user. I originally wanted to use Money to hold all of my information, but didn't like the way things were presented. The spreadsheet concept means that you can do whatever you want to make it more useful to you.

Thanks for sharing your idea.

Cheers -

george

Print the post Back To Top