[moneydance] budget: time period bug(s)?

Brett Russ bruss at alum.wpi.edu
Mon Jul 23 08:46:51 EDT 2007


There appears to be a bug (or my misunderstanding) with the way MD
computes the budget when certain time periods are selected for the
budget item.  If I create a new budget, enter a single line item for
$100 semi-monthly, then do a budget report for that budget for some
future time period and subtotal by month, the amount per month is
$206.67.  I'd expect it to be $200, right?

Here are a few that I have tested:

budget input: $100 semi-monthly
MD output: $206.67/mo (all months the same)
I expect: (100 * 2 semi-months per month) = $200/mo

budget input: $100 bi-weekly
MD output: $221.43/mo (for 31day months), $214.29/mo (for 30day months)
I expect: ((100 * 26 bi wks in yr) / 365 days in yr) * 31 days =
$220.82/mo (for 31day months)
or simpler, but less accurate: ((100 * 26 bi wks in yr) / 12 =
$216.67/mo (all months same)

Looks like for the bi-weekly computation, MD uses a year based on 364
days.  In reality, it's 365.25, but I think 365 is sufficient.  For
semi-monthly, I don't know how MD got to that figure.

I'll file in Trac if I don't hear any disagreements.
-BR


More information about the moneydance-info mailing list