Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #7  
Old 09-28-2006, 01:30 PM
Steve
Guest
 
Posts: n/a
Default Re: Budget Calculations


Jason Reeves wrote:
- quote -

> I have now confirmed positively that I am viewing 2005 data for "future
> months" when looking at the Budget Summary page, yet I am looking at 2006
> data for future months when looking at the Annual Budget report. Gosh, what
> a pain that was. That explains why I was getting different numbers because
> I've had pay rate changes in the past year (still, the monthly calculations
> that you provided were great, thanks for those). I simply have not come
> across any documentation that details what I have discovered, am I just blind
> or something? Is this common knowledge to you? I THINK and HOPE that all my
> pressing questions have been answered. I would still like to hear any
> input/thoughts that you guys may have on this. Thanks!


Jason,
I've been an 11 year user of Money and have upgraded each
year. What you have "discovered" about Money's budget is an example of
what we all "find" as we play around with different aspects of the
program. We are all trying to justify what Money says. Sometimes we
can, sometimes we can't. There ARE bugs in certain parts of the program
and certainly the budget area is one of them. Realize also that most of
us use Money differently. I maintain a complete list of all my spending
and reconcile daily to my credit cards and bank accounts. Some just use
the investment area. Some like cash flow or forecasting. I tend to
believe you need to have some kind of accounting background or interest
in order to make complete sense of what Money does. I think it is a
great program for the small cost I spend each year. It needs to be
maintained literly daily for it to be accurate. Just my
observations.Steve

  #6  
Old 09-28-2006, 02:59 AM
Jason Reeves
Guest
 
Posts: n/a
Default RE: Budget Calculations

I have now confirmed positively that I am viewing 2005 data for "future
months" when looking at the Budget Summary page, yet I am looking at 2006
data for future months when looking at the Annual Budget report. Gosh, what
a pain that was. That explains why I was getting different numbers because
I've had pay rate changes in the past year (still, the monthly calculations
that you provided were great, thanks for those). I simply have not come
across any documentation that details what I have discovered, am I just blind
or something? Is this common knowledge to you? I THINK and HOPE that all my
pressing questions have been answered. I would still like to hear any
input/thoughts that you guys may have on this. Thanks!

Jason

"Jason Reeves" wrote:

- quote -

> OK, stop the presses, I found something interesting here. I now see that the
> budgeted income for future months is different when viewed in the Annual
> Report vs. the "Current Month" view in the Budget Summary. In the Annual
> Report, the numbers are correct for each month (paycheck X 2)! I'm guessing
> that since Money always uses a 12-month budget window and always starting in
> January, it must be considering some months from 2005 when displaying info in
> the Budget Summary. Do you agree? Thanks for putting up with all my
> rambling....
> Jason
> "Jason Reeves" wrote:
> > Perhaps I know part of the issue here. If I read correctly, then Money's
> > budget will analyze your spending over the past 12 months. Looking at my
> > budget's electric bill entry (which I have budgeted $200/month for), I see
> > that past months due not use that budgeted amount (but rather $150, and a
> > couple of months have $198), but future months do use $200/month. I tried
> > setting up a budget a while back, but had these same problems, so I started
> > the budget over from scratch this month. I think it is still taking into
> > account what I used to have in my Bills & Deposits area or something to come
> > up with these past-month values. Is there a way to start your budget from
> > scratch regarding how these calculations are made, perhaps a new start date
> > of this month (or next month now that we're nearly in October)?
> > > Jason
> > > > "Jason Reeves" wrote:
> > > > BennyT,
> > > > > Thanks for the info, and as I mentioned to the other poster, sorry for the
> > > long delay getting back to this. Looking my annual budget report, I now have
> > > more questions. My budgeted income listed for each month is different.
> > > There are a few months that are the same (July, August, and October are all
> > > equal down to the penny; in addition, November and December are the same;
> > > every other month has a different amount). Could the fact that I started my
> > > budget at this time of the year make a difference? Would it be different if
> > > I started in January? I don't even know if that is possible. To give you a
> > > rough idea, out of biweekly income amounts of around $5000, I'm getting
> > > variances as little as $26 and as much as $217, and this is excluding the
> > > months with an extra payment! I must be missing something obvious because
> > > this is just not acceptable. Surely, thousands of other users would be
> > > screaming from their rooftops with this much variance in their monthly
> > > incomes. I find it odd that the first 6 months all vary, but then the last
> > > six months (other than September with the extra paycheck) have at least one
> > > other month with an identical income amount. Any thoughts?
> > > > > "BennyT." wrote:
> > > > > > Jason; I'm new to this forum, and to the advanced budget also. This problem
> > > > that you described nearly drove me crazy also. Here is what I've figured out
> > > > on my own, and it seems to be accurate. If your remember these simple
> > > > guidelines.
> > > > #1. A year has 365.25 days, this accounts for leap year every 4th year.
> > > > #2. A year has 52.1785xxxxx weeks according to the above calculation.
> > > > #3. Take half of #2 for "every other week" paychecks.
> > > > Example.
> > > > I want to budget $20.00 weekly for gasoline. Normal calculations would say
> > > > to multiply $20.00 X 52 then divide by 12 to get the monthly budget.
> > > > This would be 86.67 per month "per normal calculations".
> > > > Now using the rules above.
> > > > (((365.25/7) X $20.00)/12) = $86.96 per month.
> > > > I know this is only $0.29 cents difference, but this is also a small budget
> > > > amount.
> > > > The difference can get really big when several hundred dollars are budgeted
> > > > like this.
> > > > Hope this helps.
> > > > > > > > > > > > > "Jason Reeves" wrote:
> > > > > > > > I setup an Advanced Budget for the first time, but I'm not sure how Money
> > > > > 2005 (Deluxe) is calculating my monthly "Budgeted" values. For example,
> > > > > sometimes it looks like a yearly total divided by 12 (months). Other times,
> > > > > it looks like a weekly budget item is divided by 7 (days) and then multiplied
> > > > > by the number of days in the month. Is there some documentation on how the
> > > > > values are calculated?
> > > > > > > > > Also, something that drives me crazy is the budgeting of my income. I get
> > > > > paid every other Friday, so some months have 3 pay-days in them. Rather than
> > > > > showing those months with an extra payment, Money indicates that my monthly
> > > > > income is higher than it really is, presumably accounting for the 2-3 extra
> > > > > pay days per year. Is there a way to have a real month-to-month income
> > > > > reported?
> > > >
  #5  
Old 09-28-2006, 02:49 AM
Jason Reeves
Guest
 
Posts: n/a
Default RE: Budget Calculations

OK, stop the presses, I found something interesting here. I now see that the
budgeted income for future months is different when viewed in the Annual
Report vs. the "Current Month" view in the Budget Summary. In the Annual
Report, the numbers are correct for each month (paycheck X 2)! I'm guessing
that since Money always uses a 12-month budget window and always starting in
January, it must be considering some months from 2005 when displaying info in
the Budget Summary. Do you agree? Thanks for putting up with all my
rambling....

Jason

"Jason Reeves" wrote:

- quote -

> Perhaps I know part of the issue here. If I read correctly, then Money's
> budget will analyze your spending over the past 12 months. Looking at my
> budget's electric bill entry (which I have budgeted $200/month for), I see
> that past months due not use that budgeted amount (but rather $150, and a
> couple of months have $198), but future months do use $200/month. I tried
> setting up a budget a while back, but had these same problems, so I started
> the budget over from scratch this month. I think it is still taking into
> account what I used to have in my Bills & Deposits area or something to come
> up with these past-month values. Is there a way to start your budget from
> scratch regarding how these calculations are made, perhaps a new start date
> of this month (or next month now that we're nearly in October)?
> Jason
> "Jason Reeves" wrote:
> > BennyT,
> > > Thanks for the info, and as I mentioned to the other poster, sorry for the

> > long delay getting back to this. Looking my annual budget report, I now have
> > more questions. My budgeted income listed for each month is different.
> > There are a few months that are the same (July, August, and October are all
> > equal down to the penny; in addition, November and December are the same;
> > every other month has a different amount). Could the fact that I started my
> > budget at this time of the year make a difference? Would it be different if
> > I started in January? I don't even know if that is possible. To give you a
> > rough idea, out of biweekly income amounts of around $5000, I'm getting
> > variances as little as $26 and as much as $217, and this is excluding the
> > months with an extra payment! I must be missing something obvious because
> > this is just not acceptable. Surely, thousands of other users would be
> > screaming from their rooftops with this much variance in their monthly
> > incomes. I find it odd that the first 6 months all vary, but then the last
> > six months (other than September with the extra paycheck) have at least one
> > other month with an identical income amount. Any thoughts?
> > > "BennyT." wrote:
> > > > Jason; I'm new to this forum, and to the advanced budget also. This problem
> > > that you described nearly drove me crazy also. Here is what I've figured out
> > > on my own, and it seems to be accurate. If your remember these simple
> > > guidelines.
> > > #1. A year has 365.25 days, this accounts for leap year every 4th year.
> > > #2. A year has 52.1785xxxxx weeks according to the above calculation.
> > > #3. Take half of #2 for "every other week" paychecks.
> > > Example.
> > > I want to budget $20.00 weekly for gasoline. Normal calculations would say
> > > to multiply $20.00 X 52 then divide by 12 to get the monthly budget.
> > > This would be 86.67 per month "per normal calculations".
> > > Now using the rules above.
> > > (((365.25/7) X $20.00)/12) = $86.96 per month.
> > > I know this is only $0.29 cents difference, but this is also a small budget
> > > amount.
> > > The difference can get really big when several hundred dollars are budgeted
> > > like this.
> > > Hope this helps.
> > > > > > > > > "Jason Reeves" wrote:
> > > > > > I setup an Advanced Budget for the first time, but I'm not sure how Money
> > > > 2005 (Deluxe) is calculating my monthly "Budgeted" values. For example,
> > > > sometimes it looks like a yearly total divided by 12 (months). Other times,
> > > > it looks like a weekly budget item is divided by 7 (days) and then multiplied
> > > > by the number of days in the month. Is there some documentation on how the
> > > > values are calculated?
> > > > > > > Also, something that drives me crazy is the budgeting of my income. I get
> > > > paid every other Friday, so some months have 3 pay-days in them. Rather than
> > > > showing those months with an extra payment, Money indicates that my monthly
> > > > income is higher than it really is, presumably accounting for the 2-3 extra
> > > > pay days per year. Is there a way to have a real month-to-month income
> > > > reported?
> > >
  #4  
Old 09-28-2006, 01:44 AM
Jason Reeves
Guest
 
Posts: n/a
Default RE: Budget Calculations

Perhaps I know part of the issue here. If I read correctly, then Money's
budget will analyze your spending over the past 12 months. Looking at my
budget's electric bill entry (which I have budgeted $200/month for), I see
that past months due not use that budgeted amount (but rather $150, and a
couple of months have $198), but future months do use $200/month. I tried
setting up a budget a while back, but had these same problems, so I started
the budget over from scratch this month. I think it is still taking into
account what I used to have in my Bills & Deposits area or something to come
up with these past-month values. Is there a way to start your budget from
scratch regarding how these calculations are made, perhaps a new start date
of this month (or next month now that we're nearly in October)?

Jason


"Jason Reeves" wrote:

- quote -

> BennyT,
> Thanks for the info, and as I mentioned to the other poster, sorry for the
> long delay getting back to this. Looking my annual budget report, I now have
> more questions. My budgeted income listed for each month is different.
> There are a few months that are the same (July, August, and October are all
> equal down to the penny; in addition, November and December are the same;
> every other month has a different amount). Could the fact that I started my
> budget at this time of the year make a difference? Would it be different if
> I started in January? I don't even know if that is possible. To give you a
> rough idea, out of biweekly income amounts of around $5000, I'm getting
> variances as little as $26 and as much as $217, and this is excluding the
> months with an extra payment! I must be missing something obvious because
> this is just not acceptable. Surely, thousands of other users would be
> screaming from their rooftops with this much variance in their monthly
> incomes. I find it odd that the first 6 months all vary, but then the last
> six months (other than September with the extra paycheck) have at least one
> other month with an identical income amount. Any thoughts?
> "BennyT." wrote:
> > Jason; I'm new to this forum, and to the advanced budget also. This problem
> > that you described nearly drove me crazy also. Here is what I've figured out
> > on my own, and it seems to be accurate. If your remember these simple
> > guidelines.
> > #1. A year has 365.25 days, this accounts for leap year every 4th year.
> > #2. A year has 52.1785xxxxx weeks according to the above calculation.
> > #3. Take half of #2 for "every other week" paychecks.
> > Example.
> > I want to budget $20.00 weekly for gasoline. Normal calculations would say
> > to multiply $20.00 X 52 then divide by 12 to get the monthly budget.
> > This would be 86.67 per month "per normal calculations".
> > Now using the rules above.
> > (((365.25/7) X $20.00)/12) = $86.96 per month.
> > I know this is only $0.29 cents difference, but this is also a small budget
> > amount.
> > The difference can get really big when several hundred dollars are budgeted
> > like this.
> > Hope this helps.
> > > > > "Jason Reeves" wrote:
> > > > I setup an Advanced Budget for the first time, but I'm not sure how Money
> > > 2005 (Deluxe) is calculating my monthly "Budgeted" values. For example,
> > > sometimes it looks like a yearly total divided by 12 (months). Other times,
> > > it looks like a weekly budget item is divided by 7 (days) and then multiplied
> > > by the number of days in the month. Is there some documentation on how the
> > > values are calculated?
> > > > > Also, something that drives me crazy is the budgeting of my income. I get
> > > paid every other Friday, so some months have 3 pay-days in them. Rather than
> > > showing those months with an extra payment, Money indicates that my monthly
> > > income is higher than it really is, presumably accounting for the 2-3 extra
> > > pay days per year. Is there a way to have a real month-to-month income
> > > reported?

> >
  #3  
Old 09-28-2006, 01:10 AM
Jason Reeves
Guest
 
Posts: n/a
Default RE: Budget Calculations

BennyT,

Thanks for the info, and as I mentioned to the other poster, sorry for the
long delay getting back to this. Looking my annual budget report, I now have
more questions. My budgeted income listed for each month is different.
There are a few months that are the same (July, August, and October are all
equal down to the penny; in addition, November and December are the same;
every other month has a different amount). Could the fact that I started my
budget at this time of the year make a difference? Would it be different if
I started in January? I don't even know if that is possible. To give you a
rough idea, out of biweekly income amounts of around $5000, I'm getting
variances as little as $26 and as much as $217, and this is excluding the
months with an extra payment! I must be missing something obvious because
this is just not acceptable. Surely, thousands of other users would be
screaming from their rooftops with this much variance in their monthly
incomes. I find it odd that the first 6 months all vary, but then the last
six months (other than September with the extra paycheck) have at least one
other month with an identical income amount. Any thoughts?

"BennyT." wrote:

- quote -

> Jason; I'm new to this forum, and to the advanced budget also. This problem
> that you described nearly drove me crazy also. Here is what I've figured out
> on my own, and it seems to be accurate. If your remember these simple
> guidelines.
> #1. A year has 365.25 days, this accounts for leap year every 4th year.
> #2. A year has 52.1785xxxxx weeks according to the above calculation.
> #3. Take half of #2 for "every other week" paychecks.
> Example.
> I want to budget $20.00 weekly for gasoline. Normal calculations would say
> to multiply $20.00 X 52 then divide by 12 to get the monthly budget.
> This would be 86.67 per month "per normal calculations".
> Now using the rules above.
> (((365.25/7) X $20.00)/12) = $86.96 per month.
> I know this is only $0.29 cents difference, but this is also a small budget
> amount.
> The difference can get really big when several hundred dollars are budgeted
> like this.
> Hope this helps.
> "Jason Reeves" wrote:
> > I setup an Advanced Budget for the first time, but I'm not sure how Money
> > 2005 (Deluxe) is calculating my monthly "Budgeted" values. For example,
> > sometimes it looks like a yearly total divided by 12 (months). Other times,
> > it looks like a weekly budget item is divided by 7 (days) and then multiplied
> > by the number of days in the month. Is there some documentation on how the
> > values are calculated?
> > > Also, something that drives me crazy is the budgeting of my income. I get

> > paid every other Friday, so some months have 3 pay-days in them. Rather than
> > showing those months with an extra payment, Money indicates that my monthly
> > income is higher than it really is, presumably accounting for the 2-3 extra
> > pay days per year. Is there a way to have a real month-to-month income
> > reported?

>
  #2  
Old 09-28-2006, 12:53 AM
Jason Reeves
Guest
 
Posts: n/a
Default Re: Budget Calculations

Sorry for the long delay getting back to your post, its been one of those
weeks. I stand corrected, Money does show that two of the months have higher
incomes that are roughly equivalent to an extra pay check (March and
September). However, this report shows some interesting and confusing points
for me that I'd like to bring up. I'm going to respond to the other post in
order to include the other contributor to this discussion, please read my
reply there. Thanks for your help!

Jason

"Chris Cowles" wrote:

- quote -

> If you look at the annual budget report, does it show which months have
> higher income?
> --
> Chris Cowles
> Gainesville, FL
> "Jason Reeves" <Jason Reeves[at]discussions.microsoft.com> wrote in message
> news:AA20ABBE-D362-436A-8BB0-9877073367E0[at]microsoft.com...
> > I setup an Advanced Budget for the first time, but I'm not sure how Money
> > 2005 (Deluxe) is calculating my monthly "Budgeted" values. For example,
> > sometimes it looks like a yearly total divided by 12 (months). Other
> > times,
> > it looks like a weekly budget item is divided by 7 (days) and then
> > multiplied
> > by the number of days in the month. Is there some documentation on how
> > the
> > values are calculated?
> > > Also, something that drives me crazy is the budgeting of my income. I

> > get
> > paid every other Friday, so some months have 3 pay-days in them. Rather
> > than
> > showing those months with an extra payment, Money indicates that my
> > monthly
> > income is higher than it really is, presumably accounting for the 2-3
> > extra
> > pay days per year. Is there a way to have a real month-to-month income
> > reported?

>
  #1  
Old 09-24-2006, 02:38 AM
BennyT.
Guest
 
Posts: n/a
Default RE: Budget Calculations

Jason; I'm new to this forum, and to the advanced budget also. This problem
that you described nearly drove me crazy also. Here is what I've figured out
on my own, and it seems to be accurate. If your remember these simple
guidelines.
#1. A year has 365.25 days, this accounts for leap year every 4th year.
#2. A year has 52.1785xxxxx weeks according to the above calculation.
#3. Take half of #2 for "every other week" paychecks.
Example.
I want to budget $20.00 weekly for gasoline. Normal calculations would say
to multiply $20.00 X 52 then divide by 12 to get the monthly budget.
This would be 86.67 per month "per normal calculations".
Now using the rules above.
(((365.25/7) X $20.00)/12) = $86.96 per month.
I know this is only $0.29 cents difference, but this is also a small budget
amount.
The difference can get really big when several hundred dollars are budgeted
like this.
Hope this helps.



"Jason Reeves" wrote:

- quote -

> I setup an Advanced Budget for the first time, but I'm not sure how Money
> 2005 (Deluxe) is calculating my monthly "Budgeted" values. For example,
> sometimes it looks like a yearly total divided by 12 (months). Other times,
> it looks like a weekly budget item is divided by 7 (days) and then multiplied
> by the number of days in the month. Is there some documentation on how the
> values are calculated?
> Also, something that drives me crazy is the budgeting of my income. I get
> paid every other Friday, so some months have 3 pay-days in them. Rather than
> showing those months with an extra payment, Money indicates that my monthly
> income is higher than it really is, presumably accounting for the 2-3 extra
> pay days per year. Is there a way to have a real month-to-month income
> reported?

 
Old 09-22-2006, 01:57 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: Budget Calculations

If you look at the annual budget report, does it show which months have
higher income?
--
Chris Cowles
Gainesville, FL



"Jason Reeves" <Jason Reeves[at]discussions.microsoft.com> wrote in message
news:AA20ABBE-D362-436A-8BB0-9877073367E0[at]microsoft.com...
- quote -

> I setup an Advanced Budget for the first time, but I'm not sure how Money
> 2005 (Deluxe) is calculating my monthly "Budgeted" values. For example,
> sometimes it looks like a yearly total divided by 12 (months). Other
> times,
> it looks like a weekly budget item is divided by 7 (days) and then
> multiplied
> by the number of days in the month. Is there some documentation on how
> the
> values are calculated?
> Also, something that drives me crazy is the budgeting of my income. I
> get
> paid every other Friday, so some months have 3 pay-days in them. Rather
> than
> showing those months with an extra payment, Money indicates that my
> monthly
> income is higher than it really is, presumably accounting for the 2-3
> extra
> pay days per year. Is there a way to have a real month-to-month income
> reported?



  #-1  
Old 09-21-2006, 01:50 PM
Jason Reeves
Guest
 
Posts: n/a
Default Budget Calculations

I setup an Advanced Budget for the first time, but I'm not sure how Money
2005 (Deluxe) is calculating my monthly "Budgeted" values. For example,
sometimes it looks like a yearly total divided by 12 (months). Other times,
it looks like a weekly budget item is divided by 7 (days) and then multiplied
by the number of days in the month. Is there some documentation on how the
values are calculated?

Also, something that drives me crazy is the budgeting of my income. I get
paid every other Friday, so some months have 3 pay-days in them. Rather than
showing those months with an extra payment, Money indicates that my monthly
income is higher than it really is, presumably accounting for the 2-3 extra
pay days per year. Is there a way to have a real month-to-month income
reported?

 

Tags
budget, calculations
Similar Threads
Thread Forum Replies Last Post
401(k) Manager Calculations
Farnk: I've been using the 401(k) Manager to update my portfolio with my quarterly statement (since Money 2002 Deluxe). A real annoyance, still around in...
Microsoft Money 24 01-23-2006 05:00 AM
Mortgage Calculations
Money User: Can anyone tell/show me how Money calculates the mortgage principal and interest amounts? I've been pulling (what's left) my hair out the last...
Microsoft Money 6 02-06-2005 02:42 PM
Mortgage calculations
Brenda \(au\): Recently I created a mortgage account in MS-Money (ver: standard, 2003, International apparently) as per bank statements. However none of the...
Microsoft Money 7 08-11-2004 05:02 PM
erroneous roi calculations
cmgilldh: What causes this? I have a mutual fund for which the 3 month and ytd calc is obviously wrong. During this period I transferred the shares from one...
Microsoft Money 1 03-01-2004 06:48 PM
Invoice calculations
Bill: I reported to MS Tier I tech service that there was a bug in MS Money Sm Business 2004 in the invoicing area. Specifically, while MsMo allows a...
Microsoft Money 1 02-10-2004 09:31 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 06:57 PM.