tag:infinitekind.tenderapp.com,2009-01-14:/discussions/budgeting/658-budget-reports-not-working-properlyInfinite Kind: Discussion 2016-07-05T01:30:24Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/395459362016-04-03T16:12:21Z2016-04-03T16:12:21ZBudget reports not working properly<div><p>Hi Marcelo,</p>
<p>Probably the best way to help with this would be for you to
provide a screenshot of the parameters that you used to generate
the report. (the form that appears when you click the 'Edit' button
in the report)</p>
<p>Also point out the line item(s) that do not seem to add up;
indicating what the expected amount should be based on the amount
in Tools > Categories.</p>
<p>-Kevin N.</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/395459362016-04-03T21:55:43Z2016-04-03T21:55:44ZBudget reports not working properly<div><p>Hi, thank you for your email. Below is the information
requested:</p>
<p>[image: Inline image 1]​</p>
<p>[image: Inline image 2]</p>
<p>The correct actual balance for the following categories should
be:</p>
<p>Viajes:México:Avión $7,091.00<br>
Viajes:México:Camión $1,436.40<br>
Viajes:México:Comidas $3,873.42<br>
Viajes:México:Estacionamiento $309<br>
Viajes:México:Hotel $1,066.95<br>
Viajes:México:Taxis $1,077.35</p>
<p>This is just an example, there are other categories in the
budget report<br>
that do not show the correct actual balance. However, in the same
budget<br>
report still other categories do show the correct actual
balances!</p>
<p>Thank you for your help,</p>
<p>Marcelo Galas</p></div>Marcelo Galas Btag:infinitekind.tenderapp.com,2009-01-14:Comment/395459362016-04-03T22:51:07Z2016-04-03T22:51:07ZBudget reports not working properly<div><p>Hi Marcelo,</p>
<p>One way that I can see this happening is when the amount shown
in Tools > Categories predates the time frame of the budget
report.</p>
<p>The amount shown in Tools > Categories is the accumulated
amount from day 1 for each category. The report that is being
generated (per your screenshot) is only from Jan 1 2016.</p>
<p>Another way of this happening is if the user is using the old
style budget and the 'Start Date' and 'End Date' are different than
the date range of the generated report.</p>
<p>I'm not too adept at using the new style budget but it would be
my assumption that unless the budget was build back to day 1, then
the resulting budget report would only return those values for
which an amount was budgeted. Thus the budget report amounts would
not equal the amounts shown in Tools > Categories.</p>
<p>I'm probably not the best one to be responding to budget
queries. Maybe someone else can chime in here who is more
experienced with the new style budget.</p>
<p>Are you using the new style budget or the old style?</p>
<p>-Kevin N.</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/395459362016-04-04T00:09:17Z2016-04-04T00:09:17ZBudget reports not working properly<div><p>Hi Kevin: thank you for your email.</p>
<p>I am new to Moneydance, and I started using it on January 1st,
this year,<br>
so I don't know about "old style" and "new style"
budget​.</p>
<p>Any way, as I said, there is no information in any category
captured before<br>
January 1st., so I guess the amount shown in Tools>Categories
should be the<br>
same as in the budget report I sent you.</p>
<p>Any other ideas?</p>
<p>Thanks again,</p>
<p>Marcelo</p></div>Marcelo Galas Btag:infinitekind.tenderapp.com,2009-01-14:Comment/395459362016-04-04T00:23:56Z2016-04-04T00:23:56ZBudget reports not working properly<div><p>Hi Marcelo,</p>
<p>Hmm. I confess that I'm stumped.</p>
<p>Perhaps if you could provide a screenshot of the Tools >
Categories window of the categories in question. Hopefully, it may
shed some light.</p>
<p>-Kevin N.</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/395459362016-04-04T00:32:14Z2016-04-04T00:32:14ZBudget reports not working properly<div><p>Hi Marcelo,</p>
<p>What version of Moneydance are you using? Menu bar > Help
> About Moneydance</p>
<p>The latest build is currently MD 2015.7 (1358) There is quite a
few improvements to the budget mentioned in the blog about it.<br>
<a href="http://infinitekind.com/blog/moneydance-2015-7-one-more-update-before-the-big-one">
http://infinitekind.com/blog/moneydance-2015-7-one-more-update-befo...</a></p>
<p>-Kevin N.</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/395459362016-04-04T01:53:38Z2016-04-04T01:53:39ZBudget reports not working properly<div><p>Hi Kevin:</p>
<p>I updated to the current version (I was running version 2015.6
(1299)),<br>
but that didn't fix this problem. Here is a ​screen capture
of the<br>
information in the Tools>Categories window:</p>
<p>[image: Inline image 1]</p>
<p>I hope this gives you a clue as to what might be going on.</p>
<p>Thanks again,</p>
<p>Marcelo</p></div>Marcelo Galas Btag:infinitekind.tenderapp.com,2009-01-14:Comment/395459362016-04-04T02:44:10Z2016-04-04T02:44:10ZBudget reports not working properly<div><p>Hi Marcelo,</p>
<p>Unfortunately, I'm not seeing anything obvious. From what you've
shown, your report should be returning the values that you
expect.</p>
<p>The only missing item is the budget itself. If you want to post
a screenshot of the actual budget window, that may be the key. Try
to include any of the line items in question.</p>
<p>I hope someone from the MD support staff chimes in here soon
because I'm about out of ideas.</p>
<p>-Kevin N.</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/395459362016-04-04T17:47:18Z2016-04-04T17:47:20ZBudget reports not working properly<div><p>Ok, thank you Kevin. Here is the budget screen capture​
showing the<br>
categories in question.</p>
<p>[image: Inline image 1]</p>
<p>Marcelo</p></div>Marcelo Galas Btag:infinitekind.tenderapp.com,2009-01-14:Comment/395459362016-04-04T18:26:18Z2016-04-04T18:26:18ZBudget reports not working properly<div><p>Hi Marcelo,</p>
<p>OK. It looks to me that there is no amounts budgeted for
February or March and likely April too. This is what is causing the
discrepancy.</p>
<p>You'll likely need to manually insert the desired budgeted
amounts for February and March.</p>
<p>When you advance to April, look for a downward facing arrow next
to April (see screenshot)</p>
<p>Clicking that arrow will offer you 3 options to automatically
fill in the budget amounts so that you won't have to.</p>
<p>HTH -Kevin N.</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/395459362016-04-04T19:21:03Z2016-04-04T19:21:04ZBudget reports not working properly<div><p>Ok, Kevin, what you say may have something to do with this
discrepancy, but<br>
it is not the only cause. As you can see in the images below, even
though<br>
some categories have no amount budgeted, some times when there is a
charge<br>
to them, that amount does show in the budget report, ​and at
other times<br>
they do not.</p>
<p>Look at the categories "Casa:Mantenimiento" and "Casa:Mejoras";
there<br>
happens what you say, but look at the categories "Comisiones
bancarias:MJGB<br>
Santander 0563" and "Comisiones bancarias:RTdeG Santander" and
there your<br>
assumption doesn't hold:</p>
<p>[image: Inline image 1]</p>
<p>[image: Inline image 2]</p>
<p>[image: Inline image 3]</p>
<p>I think there is a bug in the program in the way the budget
reports are<br>
generated, ¿what do you think?</p>
<p>Marcelo</p></div>Marcelo Galas Btag:infinitekind.tenderapp.com,2009-01-14:Comment/395459362016-04-04T20:17:45Z2016-04-04T20:17:45ZBudget reports not working properly<div><p>Hi Marcelo,</p>
<p>"Comisiones bancarias:MJGB Santander 0563" and "Comisiones
bancarias:RTdeG Santander" are both listed as (Not in Budget) per
your screenshot of the budget report.</p>
<p>Do you have the option to 'Include categories not defined in
budget' check-marked in the budget report's parameters window?</p>
<p>If so, that may explain why those items show up in the report
even though there was never a budgeted amount assigned them.</p>
<p>-Kevin N.</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/395459362016-04-04T22:38:52Z2016-04-04T22:38:53ZBudget reports not working properly<div><p>Kevin: Yes I have that option check-marked, so it is correct
that they show<br>
up in the report.</p>
<p>But the point is not that they show up in the report, but that
they show<br>
up​ with the correct amounts, even though they had no amounts
budgeted at<br>
all.</p>
<p>So it seems that in this case the fact that they had no budgeted
amounts<br>
didn't prevent the budget report to show the correct balances,
while in the<br>
other categories I mentioned previously you think that is the
reason why<br>
the budget report is not showing the correct balances.</p>
<p>Do you see my point? In two equal circumstances, namely
categories without<br>
budgeted amounts, in one case the budget report shows the correct
balances<br>
and in the other it doesn't.</p>
<p>What do you think?</p>
<p>Marcelo</p></div>Marcelo Galas Btag:infinitekind.tenderapp.com,2009-01-14:Comment/395459362016-04-04T23:15:52Z2016-04-04T23:15:52ZBudget reports not working properly<div><p>Hi Marcelo,</p>
<p>I think I'm getting a little lost in all of this. This is why
I'm not really a 'Budget' kind of guy.</p>
<p>The way I see this is, line items that are assigned a budgeted
amount each month (and every month) will display the proper
Budgeted amount, Actual amount and Difference in the budget
report.</p>
<p>Line items <em>not</em> assigned a budget amount, appear in the
budget report with zero as the Budgeted amount, their total Actual
amount and a negative Difference equal to their respective totals.
(provided the option to 'Include categories not defined in budget'
is checked)</p>
<p>To me, this is the correct & expected behavior.</p>
<p>-Kevin N.</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/395459362016-04-05T00:05:11Z2016-04-05T00:05:11ZBudget reports not working properly<div><p>Ok, my point is this:</p>
<p>Look at the February​ column in the Budget screen.</p>
<p>Category "Casa:Mejoras" doesn't have a budgeted amount in that
month. But<br>
there was an actual expense of 811, which added to the 54 expense
in<br>
January, gives a balance of 865. This amount is shown correctly in
the<br>
Tools>Categories screen (864.90 actually, but that's alright).
But the<br>
Budget Report only shows the January expense and "ignores" the
February<br>
expense. You say this may be because there was no budgeted amount
in<br>
February.</p>
<p>However, category "Comisiones bancarias:MJGB Santander 0563"
also doesn't<br>
have a budgeted amount in February, and there was an actual expense
of 870.<br>
Again, this balance is shown correctly in the Tools>Categories
screen. But<br>
in this case, the Budget Report does show the correct balance, even
though<br>
there was no amount budgeted in February.</p>
<p>In short: in both categories there was no budgeted amount in
February, and<br>
in one instance ("Casa:Mejoras"), the Budget Report "ignores" the
actual<br>
expense but in the other ("Comisiones bancarias:MJGB Santander
0563"), it<br>
takes it into account. Why?</p>
<p>Marcelo</p></div>Marcelo Galas Btag:infinitekind.tenderapp.com,2009-01-14:Comment/395459362016-04-05T01:25:38Z2016-04-05T01:25:38ZBudget reports not working properly<div><p>Hi Marcelo,</p>
<p>This is the way that I understand it to work...</p>
<p>'Casa:Mejores' <em>is</em> a budgeted item. Thus, in order for
that expenditure to be displayed in the budget report, it requires
a budgeted amount to be entered into each and every month where
there is any expenditure to 'Casa:Mejores'.</p>
<p>'Comisiones bancarias:MJGB Santander 0563' is <em>not</em> a
budgeted item. Thus it does not require a budgeted amount to be
entered into any month whatsoever; and yet, the expenditures for
non-budgeted items will still be displayed in the budget report.
(provided the option to 'Include categories not defined in budget'
is checked)</p>
<p>-Kevin N.</p></div>-Kevin N.