budgeting dividends by individual security and account

wiensken
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?
Quicken user since 1996 (MS-DOS). When Quicken's head office was in Edmonton Alberta!

Answers

  • Sherlock
    Sherlock Quicken Windows Subscription Member ✭✭✭✭
    If you haven't already, you may want to consider using income reminders for the expected dividends.
  • bmciance
    bmciance Quicken Windows Subscription SuperUser ✭✭✭✭✭
    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.

  • mshiggins
    mshiggins Quicken Windows 2017 SuperUser ✭✭✭✭✭
    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 list

  • bmciance
    bmciance Quicken Windows Subscription SuperUser ✭✭✭✭✭
    @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.

  • mshiggins
    mshiggins Quicken Windows 2017 SuperUser ✭✭✭✭✭
    @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 list

  • Sherlock
    Sherlock Quicken Windows Subscription Member ✭✭✭✭
    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. 

    We've been using recurring reminders.  There is a bit of maintenance where dates and amounts may vary but it's not really different than any other reminder.
    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. 
    We also maintain a spreadsheet we use for our federal and state estimate tax payments which includes the prior years dividends and we update the spreadsheet each month with the actual data from the Tax Summary report.  
This discussion has been closed.