bug with budget report and budget bars

s©tt's Avatar

s©tt

02 Jan, 2020 09:15 AM

Moneydance 2019.4 build 1899
Windows 10

I use "mixed intervals" budgets. If I create an expense item of, say, €10,000 annually, with a start date of 2020 01 01 and and end date of 2020 12 31, then I would expect on day 1 of the year, the budget bars (on the home page) and the budget report to show " €27.40 year-to-date for a 365-day year (that's 10,000 / 365), or €27.32 for a 366-day year.

Instead, both the budget bars and the budget report show €26.88, which indicates Moneydance is calculating based on a 372-day year.

  1. 1 Posted by mhoggie on 02 Jan, 2020 03:49 PM

    mhoggie's Avatar

    just a user,

    I've seen that issue reported by others. I think MD does not strictly divide the budget by the total days of the year which most would assume. It does something with the average days of the month which makes the reports look wrong when running the report for a period less than the budget period. But it you run the report for the full year, the budgeted amount will show correctly. And if you set an amount by month it will show correctly by month. So it's something in the way they calculate the report.

  2. 2 Posted by s©tt on 02 Jan, 2020 04:56 PM

    s©tt's Avatar

    @mhoggie - the only thing I can think of is that MD assumes - for the purposes of pro-rated annual budget items - that all months are 31 days (31 x 12 = 372). Hard to understand what the logic of that is.

  3. 3 Posted by Ervin on 25 Jan, 2020 12:05 AM

    Ervin's Avatar

    I'm glad I found this thread, as I was having an extremely difficult time trying to understand the value of the bars as it relates.

    Unfortunately, the inability to pick "custom date ranges" (called periods...) from which to base the current budget on makes this not usable in my case as a budgeting tool—my spreadsheets are more effective.

    For example, I'd like to use a period of 90 days--what I need to see in my budget. This is not possible to set.

    There are only 3 choices that limit what can be done-- a) copy and rollover previous period (whatever that is if I can remember what it was when last used...), b) copy the previous period & c) use actual spending--the one that matters most in my case; assuming I can remember whatever the prior period was and when it was last used.

    I’m hopeful more useful budgeting features come online. For now, this is just not usable for customers in my position, looking to set custom date ranges (periods) for the type of budgeting we are attempting to create.

  4. 4 Posted by s©tt on 25 Jan, 2020 09:01 AM

    s©tt's Avatar

    @Ervin - I don't think this thread really has anything to do with your particular question, however I'll give you a couple of things to try... In creating your budget, choose "Mixed Interval" style. Enter your budget items either with start/end dates corresponding to the quarter (90-days) you want the item to cover (in case each quarter has a different amount budgeted, you can have 4 entries per category), or you try the interval of "tri-monthly" if the budget is the same for all 4 quarters. Then in the view of the budget bars, select "this quarter". If your year doesn't start on January 1st, you can set it in File/Preferences/General/Fiscal Year Start. Hope this helps.

  5. System closed this discussion on 25 Apr, 2020 09:10 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac