budgeting dividends by individual security and account
wiensken
Quicken Canada Subscription Member ✭✭
I have about 20 investment accounts and 150 securities. Each month the exercise to determine if the dividends I expected from each security matched what I received - requires a lot of spreadsheet work.
Can I, within quicken, budget the anticipated dividend for each individual security (sort of like the "est. income" field - but with expected payout dates) and then generate a report that shows actual dividends vs expected dividends. Right now I export all the dividend payment data from quicken and merge it with a spreadsheet that holds all my anticipated dividend data and then generate reports to identify the differences.
I see discussions on budgeting dividends at an account level - but not at a security level. As a retiree, it becomes important to quickly identify when a security pays out a dividend that was different from what you expected. Some months an investment may pay out a special (higher) dividend and another investment might miss its dividend entirely - and they could cancel each other out in a high level report - thus the need to budget at a security level.
Suggestion? Thoughts?
Can I, within quicken, budget the anticipated dividend for each individual security (sort of like the "est. income" field - but with expected payout dates) and then generate a report that shows actual dividends vs expected dividends. Right now I export all the dividend payment data from quicken and merge it with a spreadsheet that holds all my anticipated dividend data and then generate reports to identify the differences.
I see discussions on budgeting dividends at an account level - but not at a security level. As a retiree, it becomes important to quickly identify when a security pays out a dividend that was different from what you expected. Some months an investment may pay out a special (higher) dividend and another investment might miss its dividend entirely - and they could cancel each other out in a high level report - thus the need to budget at a security level.
Suggestion? Thoughts?
Quicken user since 1996 (MS-DOS). When Quicken's head office was in Edmonton Alberta!
Tagged:
0
Answers
-
If you haven't already, you may want to consider using income reminders for the expected dividends.1
-
I do exactly as Sherlock suggested. Once a dividend is declared I set up a reminder in the account(s) for that security and when they are paid it matches up with the reminder. I even go a little further by putting the number of shares the div is due on, the rate and the ex-date in the memo of the reminder
Quicken Windows user since 1993.
1 -
I am curious @Sherlock and @bmciance are you using recurring reminders or one-time reminders for your dividends?
I have been using recurring reminders and update the amount for "this and all future instances" when I receive the dividend. It is a bit of maintenance but I always know when to expect the dividend and have a pretty good estimate of the expected amount.
Quicken user since Q1999. Currently using QW2017.
Questions? Check out the Quicken Windows FAQ list0 -
@mshiggins, I only use one-time reminders for dividends. I have a spreadsheet that calculates estimated dividends per month going out to the following calendar year. I have gone back and forth as to whether I should do recurring reminders but since most of my stocks I do dividend reinvestment and the fact that many of them also pay variable dividends or pay semi-regular special dividends I decided not to do it that way. I keep my spreadsheet as my master list and just enter the reminder in Quicken once a dividend is declared. I can see benefits of doing recurring reminders also but my way works for the way I like to do things.
Quicken Windows user since 1993.
1 -
@bmciance
I keep a spreadsheet for the tax year for estimating and tracking dividends and other tax related data. So a bit of double entry, but as you stated, my way makes sense for me.Quicken user since Q1999. Currently using QW2017.
Questions? Check out the Quicken Windows FAQ list0 -
mshiggins said:I am curious @Sherlock and @bmciance are you using recurring reminders or one-time reminders for your dividends?
I have been using recurring reminders and update the amount for "this and all future instances" when I receive the dividend. It is a bit of maintenance but I always know when to expect the dividend and have a pretty good estimate of the expected amount.mshiggins said:@bmciance
I keep a spreadsheet for the tax year for estimating and tracking dividends and other tax related data. So a bit of double entry, but as you stated, my way makes sense for me.
1
This discussion has been closed.