Discrepancy between Budget rpt and Income and Expenses rpt

kcannon's Avatar

kcannon

07 Apr, 2016 12:13 AM

When I run the Budget report for the current year, one category (Personal:Dining Out) shows zero actual for Jan and Feb, while the Income and Expense report shows positive balances for those two months. The Income and Expense Detail report agrees with the Income and Expense report. When I look at transactions in that category for Q1, there were clearly transactions posted in Jan and Feb, and the sums of individual transactions for those months agree with the totals on the Income and Expense report. There is no discrepancy for March.

What can have caused this and how do I fix it?

Thanks.

  1. 1 Posted by jstackpo on 07 Apr, 2016 12:42 AM

    jstackpo's Avatar

    This is just a guess, but could it be that you have different date ranges for the two reports? (That's a mistake I make from time to time.) Click on "Edit" to double check.

  2. 2 Posted by kcannon on 07 Apr, 2016 05:25 AM

    kcannon's Avatar

    Hi jstackpo,

    No, the date ranges appear to be the same. I've attached 3 screenshots with
    the relevant fields highlighted. File 1 shows the budget I created. File 2
    shows the Income & Expense report. File 3 shows the Budget report. The
    numbers circled in red are where the discrepancy appears. I'm sure it's
    just some simple mistake I made.

    Looking forward to hearing back from you.

    -Kelly

  3. 3 Posted by -Kevin N. on 07 Apr, 2016 01:34 PM

    -Kevin N.'s Avatar

    Hi Ken,

    The reason is that you don't have any amount budgeted for Dining Out in January and February. Notice the 0's next to 226 and 569 in the actual budget.

    Enter a budgeted amount and the 226 and the 569 should then be included in the Budget Report.

    The reason that the 336 is included in the Budget Report is because you do have 400 budgeted for March.

    HTH -Kevin N.

  4. 4 Posted by kcannon on 07 Apr, 2016 02:44 PM

    kcannon's Avatar

    Thanks, that was it. I love simple solutions. But help me understand why
    Moneydance works that way. If I budget zero expense for a period but in
    fact have some spending in that category, I need to know. It seems like
    this defeats the very purpose of budgeting, identifying unplanned expenses.
    To fail to report activity in a period just because none was planned then
    doesn't make sense. What am I not seeing here?

    Kelly

  5. 5 Posted by -Kevin N. on 07 Apr, 2016 03:12 PM

    -Kevin N.'s Avatar

    Hi Kelly,

    Yours is an excellent point.

    We'll need the Moneydance support staff to chime in on the reasoning behind that particular functionality.

    -Kevin N.

  6. 6 Posted by kcannon on 07 Apr, 2016 04:06 PM

    kcannon's Avatar

    Yes. Can someone from MD support who reads this please comment?

    -Kelly

  7. 7 Posted by jstackpo on 07 Apr, 2016 09:58 PM

    jstackpo's Avatar

    I noticed a curiosity in the screenshot of “Budget: 2016 Budget v4”

    You did NOT check the “Include items with zero actual…” and yet the January and February entries both show zero amounts. This suggests to me that the “real” amounts for those months are not zero (as you reported in your original post) but have somehow been reported as zero amounts.

    But this is just a clue as to what might be wrong — I have no idea if it means anything. Or how to fix it.

    Best,

    John

    John D Stackpole, CPP, RP
    OEO, Parliamentary Services
    11 Battersea Lane
    Fort Washington, MD 20744-7203

    [email blocked]
    Land Line: 301-292-9479
    Cell: 301-221-4105
    Fax: Call Ahead (to set up)

  8. 8 Posted by kcannon on 08 Apr, 2016 04:52 AM

    kcannon's Avatar

    John - Good point. I tried running the report both with and without that
    box checked, but the result was the same either way. I deliberately left it
    unchecked for the example I uploaded because as you say it implies the
    underlying amounts are not actually zero. Which is of course the case.

    When I change the budgeted amounts for Jan and Feb from zero to any
    non-zero number, the actual amounts appear as they should in the Budget
    report. This is a very unacceptable workaround, but I'm now going through
    my 2016 budget and entering 0.01 for every monthly budget amount that is
    now (correctly) zero.

    I can't see how the product could have been designed this way, and this
    behavior is certainly not documented in the manual. Seems like a pretty big
    bug to me.

    I'm still hoping Moneydance support will join this thread and enlighten us.

    Kelly

  9. 9 Posted by rgglickman on 11 Apr, 2016 12:14 AM

    rgglickman's Avatar

    This has been an issue for several versions of MD. You have to have something in the budget plan for the expense to show up in the Budget report.

    When you make up a budget, you want to measure against the plan, and just because there is no plan for expense in a month, doesn't mean that the Budget report should not show out of Budget expenses.

    One of the many reporting flaws. Exporting to an Excel sheet and using the Income-Expense detail or Cash Flow Detail seems to get the right reporting for the Budget Report for current month, or any date range. Unfortunate.

  10. 10 Posted by kcannon on 11 Apr, 2016 04:59 AM

    kcannon's Avatar

    Thanks for jumping in. Unfortunate is right. I'm relatively new to MD and
    I'm sorry to learn there are "many reporting flaws." Are those listed or
    documented anywhere? Would be nice to know what they are before I beat my
    head against the wall trying to solve another one of these.

    Kelly

  11. 11 Posted by jstackpo on 11 Apr, 2016 12:51 PM

    jstackpo's Avatar

    And I appear to have the inverse problem: I have a budget amount (annual only) for a category of income (a tax refund but that shouldn't be relevant) and a refund entered into my bank checking register (thanks Maryland!). (The real money is in the bank, too.)

    But the Budget report just shows the budget amount and 0.00 for the Actual.
    Other incomes show up properly, both budgeted and actual.

    The refund does show up in the Transactions report but NOT in the Income and Expenses Report. Go figure (I wonder what else is missing?).

    At this point about all I can think of is to wait (fingers crossed) for the next update to the code.

  12. 12 Posted by rgglickman on 11 Apr, 2016 12:55 PM

    rgglickman's Avatar

    Reporting is not a MD strength from an overall perspective (sorting, adjusting columns and maintaining the adjustment, etc.).  There is no documentation of 'reporting flaws,' but the only report that gives me grief is the Budget report. I think it is sourced from the Budget set up, whereas the Income-Expense, Cash Flow, and Cash Flow detail all seem to come from the overall database.

    You might want to look at the comments in the Problems section just to get a sense of what is causing issues in the software.
     Rita Glickman
    [email blocked]

          From: kcannon <[email blocked]>
     To: [email blocked]
     Sent: Sunday, April 10, 2016 9:59 PM
     Subject: Re: Discrepancy between Budget rpt and Income and Expenses rpt [Budgeting #672]
       
     #yiv9311732982 pre {width:92%;margin:10px 2%;padding:5px 2%;background:#efefef;border:1px solid #d6d6d6;}#yiv9311732982 blockquote {margin-left:0;padding-left:1em;border-left:5px solid #ccc;}
    |

  13. System closed this discussion on 30 Jul, 2016 03:51 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