Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #7  
Old 05-26-2007, 03:38 AM
Maaz Mansori
Guest
 
Posts: n/a
Default Re: Negative Expenses

Cal,

Thanks for the information. I changed the setting and the report now shows
up correctly. There doesn't appear to be a way to customize it on the
homepage but at least it now shows correctly when I use the Reports feature.

Maaz

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:ih0a53dh30klmjevd79k4niugn07s01qvd[at]4ax.com...
- quote -

> In microsoft.public.money, Maaz Mansori wrote:
> > I'm using Money 2007 Premium but have had this problem in the last several
> > versions as well. Why is it that if I record a negative expensive, it is
> > not
> > reflected in the reports?
> > > An example: Let's say I go out to dinner with a friend. We receive the

> > check
> > and I pay by credit card and my friend pays me with cash to cover his/her
> > part. I record the restaurant in the Food: Dining Out category in my
> > credit
> > card account and then record that I received the cash in my Cash account
> > and
> > classify it as a negative expense to the same category. However, when I
> > view
> > the reports, only the positive expense shows up and it never subtracts the
> > negative one from the total.
> > > I suppose I could get around this problem by creating a liability account

> > for when such a transaction is needed, but it shouldn't have to be so
> > complicated. Any ideas?

> To show negative expenses in a report, when you customize, make
> sure the Details tab chooses AllTypes, rather than Payments.


  #6  
Old 05-25-2007, 02:09 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Negative Expenses

In microsoft.public.money, ed wrote:

- quote -

> > Another example. I make a, say, $200.00 withdrawel to go to the
> > casino and play some poker or blackjack. I categorize the withdrawel
> > as "entertainment". Say I don't spend/loose it all, or even better,
> > let's say I get lucky and win, then redeposit the money. It seems
> > that I should re-deposit the money into the entertainment category to
> > offset that withdrawel.
> > > Does this seem right to the Microsoft Money saavy folks here?

> I bet this question wouldn't come up if money didn't show a scary popup
> every time you categorize a deposit as an expense category


I think this was more about reports. However clearing
Tools-> Settings-> CategorySettings-> RequireTheCorrectTypeOfEachCategory
would stop that pop-up you refer to if it bothers you.

  #5  
Old 05-25-2007, 01:50 AM
ed
Guest
 
Posts: n/a
Default Re: Negative Expenses


- quote -

> Another example. I make a, say, $200.00 withdrawel to go to the
> casino and play some poker or blackjack. I categorize the withdrawel
> as "entertainment". Say I don't spend/loose it all, or even better,
> let's say I get lucky and win, then redeposit the money. It seems
> that I should re-deposit the money into the entertainment category to
> offset that withdrawel.
> Does this seem right to the Microsoft Money saavy folks here?


I bet this question wouldn't come up if money didn't show a scary popup
every time you categorize a deposit as an expense category
  #4  
Old 05-24-2007, 11:25 PM
Chris Cowles
Guest
 
Posts: n/a
Default Re: Negative Expenses

"Maaz Mansori" <maaz[at]msn.com> wrote in message news:0CB4E74C-FBDD-49D9-9EA4-2EBC1B707F29[at]microsoft.com...
- quote -

> I'm using Money 2007 Premium but have had this problem in the last several
> versions as well. Why is it that if I record a negative expensive, it is not
> reflected in the reports?
> An example: Let's say I go out to dinner with a friend. We receive the check
> and I pay by credit card and my friend pays me with cash to cover his/her
> part. I record the restaurant in the Food: Dining Out category in my credit
> card account and then record that I received the cash in my Cash account and
> classify it as a negative expense to the same category. However, when I view
> the reports, only the positive expense shows up and it never subtracts the
> negative one from the total.
> I suppose I could get around this problem by creating a liability account
> for when such a transaction is needed, but it shouldn't have to be so
> complicated. Any ideas?


I don't have a cash account. I have a "cash withdrawal" category where money just disappears. Call it pocket money. Because I use my credit card for almost everything, the amount that goes to the cash withdrawal category is negligible, and I don't track the details. I have, for certain periods of time, but the results were always that the amounts involved were not worth tracking.

For circumstances such as dining out with friends, I split the transaction between Dining Out and Cash Withdrawal. The amount expensed on that reduces the amount of subsequent ATM withdrawals, because my spending of cash out of pocket doesn't change. I already have cash in my pocket (from my friend's reimbursement) and don't have to get it out of the bank.

For the other respondent who replied regarding company reimbursements:

<miller.nospam[at]gmail.com> wrote in message news:1180022786.152588.138410[at]q66g2000hsg.googlegroups.com...
- quote -

> Another example that seems to fall into the same category is my
> tuition re-imbursement. My company re-imburses me for a certain
> percentage of acredited education. My college payments, my children's
> private school tuition, lunch money, school supplies, and training
> materials all fall under our "education" category. I do not want to
> classify tuition re-imbursement as any sort of income. I just want it
> to offset the education expense category.


In that case I'd create an asset account. Split the transactions between your share (if any) of the educational expense and a transfer to the 'Reimbursements Due to Me" account. When you deposit the reimbursement check, deposit as a transfer from the reimbursement account.

This has a couple of advantages:

1. You can track how much you're owed.
2. Since reimbursements are after-the-fact, you don't have excess expenses in the starting month, and negative expenses in the reimbursement month.

Make sure the reimbursement account is in-budget, so transfers to and from are budget-neutral. Should you not meet the requirements for reimbursement, (low grades?) edit the original transaction to shift the expense to yourself.
--
Chris Cowles
Gainesville, FL
  #3  
Old 05-24-2007, 04:31 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Negative Expenses

In microsoft.public.money, miller.nospam[at]gmail.com wrote:

- quote -

> On May 23, 10:11 pm, Cal Learner-- MVP <via_newsgr...[at]please.tnx> wrote:
> > In microsoft.public.money, Maaz Mansori wrote:
> > > > I'm using Money 2007 Premium but have had this problem in the last several
> > > versions as well. Why is it that if I record a negative expensive, it is not
> > > reflected in the reports?
> > > > An example: Let's say I go out to dinner with a friend. We receive the check
> > > and I pay by credit card and my friend pays me with cash to cover his/her
> > > part. I record the restaurant in the Food: Dining Out category in my credit
> > > card account and then record that I received the cash in my Cash account and
> > > classify it as a negative expense to the same category. However, when I view
> > > the reports, only the positive expense shows up and it never subtracts the
> > > negative one from the total.
> > > > I suppose I could get around this problem by creating a liability account
> > > for when such a transaction is needed, but it shouldn't have to be so
> > > complicated. Any ideas?
> > > To show negative expenses in a report, when you customize, make

> > sure the Details tab chooses AllTypes, rather than Payments.

> Thank you! I'm not the original poster, but I stumbled across this,
> and this has really been bugging me for some time now.
> Question: Is this the right way to handle such situations? It seems
> to me like it is, but I'm very new to microsoft money and no nothing
> about accounting.


It is a good way, and it is probably the best way for most.


- quote -

> Another example that seems to fall into the same category is my
> tuition re-imbursement. My company re-imburses me for a certain
> percentage of acredited education. My college payments, my children's
> private school tuition, lunch money, school supplies, and training
> materials all fall under our "education" category. I do not want to
> classify tuition re-imbursement as any sort of income. I just want it
> to offset the education expense category.
> Another example. I make a, say, $200.00 withdrawel to go to the
> casino and play some poker or blackjack. I categorize the withdrawel
> as "entertainment". Say I don't spend/loose it all, or even better,
> let's say I get lucky and win, then redeposit the money. It seems
> that I should re-deposit the money into the entertainment category to
> offset that withdrawel.
> Does this seem right to the Microsoft Money saavy folks here?


Seems right.

  #2  
Old 05-24-2007, 04:22 PM
Dick Watson
Guest
 
Posts: n/a
Default Re: Negative Expenses

It's probably not the right way for Formal Accountants. For many of us
longtime Money users it seems best for lots of the reasons you are grappling
with.

<miller.nospam[at]gmail.com> wrote in message
news:1180022786.152588.138410[at]q66g2000hsg.googlegroups.com...
- quote -

> Thank you! I'm not the original poster, but I stumbled across this,
> and this has really been bugging me for some time now.
> Question: Is this the right way to handle such situations? It seems
> to me like it is, but I'm very new to microsoft money and no nothing
> about accounting.
> Another example that seems to fall into the same category is my
> tuition re-imbursement. My company re-imburses me for a certain
> percentage of acredited education. My college payments, my children's
> private school tuition, lunch money, school supplies, and training
> materials all fall under our "education" category. I do not want to
> classify tuition re-imbursement as any sort of income. I just want it
> to offset the education expense category.
> Another example. I make a, say, $200.00 withdrawel to go to the
> casino and play some poker or blackjack. I categorize the withdrawel
> as "entertainment". Say I don't spend/loose it all, or even better,
> let's say I get lucky and win, then redeposit the money. It seems
> that I should re-deposit the money into the entertainment category to
> offset that withdrawel.
> Does this seem right to the Microsoft Money saavy folks here?



  #1  
Old 05-24-2007, 04:06 PM
miller.nospam@gmail.com
Guest
 
Posts: n/a
Default Re: Negative Expenses

On May 23, 10:11 pm, Cal Learner-- MVP <via_newsgr...[at]please.tnxwrote:
- quote -

> In microsoft.public.money, Maaz Mansori wrote:
> > I'm using Money 2007 Premium but have had this problem in the last several
> > versions as well. Why is it that if I record a negative expensive, it is not
> > reflected in the reports?
> > An example: Let's say I go out to dinner with a friend. We receive the check
> > and I pay by credit card and my friend pays me with cash to cover his/her
> > part. I record the restaurant in the Food: Dining Out category in my credit
> > card account and then record that I received the cash in my Cash account and
> > classify it as a negative expense to the same category. However, when I view
> > the reports, only the positive expense shows up and it never subtracts the
> > negative one from the total.
> > I suppose I could get around this problem by creating a liability account
> > for when such a transaction is needed, but it shouldn't have to be so
> > complicated. Any ideas?

> To show negative expenses in a report, when you customize, make
> sure the Details tab chooses AllTypes, rather than Payments.


Thank you! I'm not the original poster, but I stumbled across this,
and this has really been bugging me for some time now.

Question: Is this the right way to handle such situations? It seems
to me like it is, but I'm very new to microsoft money and no nothing
about accounting.

Another example that seems to fall into the same category is my
tuition re-imbursement. My company re-imburses me for a certain
percentage of acredited education. My college payments, my children's
private school tuition, lunch money, school supplies, and training
materials all fall under our "education" category. I do not want to
classify tuition re-imbursement as any sort of income. I just want it
to offset the education expense category.

Another example. I make a, say, $200.00 withdrawel to go to the
casino and play some poker or blackjack. I categorize the withdrawel
as "entertainment". Say I don't spend/loose it all, or even better,
let's say I get lucky and win, then redeposit the money. It seems
that I should re-deposit the money into the entertainment category to
offset that withdrawel.

Does this seem right to the Microsoft Money saavy folks here?

 
Old 05-24-2007, 03:11 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Negative Expenses

In microsoft.public.money, Maaz Mansori wrote:

- quote -

> I'm using Money 2007 Premium but have had this problem in the last several
> versions as well. Why is it that if I record a negative expensive, it is not
> reflected in the reports?
> An example: Let's say I go out to dinner with a friend. We receive the check
> and I pay by credit card and my friend pays me with cash to cover his/her
> part. I record the restaurant in the Food: Dining Out category in my credit
> card account and then record that I received the cash in my Cash account and
> classify it as a negative expense to the same category. However, when I view
> the reports, only the positive expense shows up and it never subtracts the
> negative one from the total.
> I suppose I could get around this problem by creating a liability account
> for when such a transaction is needed, but it shouldn't have to be so
> complicated. Any ideas?


To show negative expenses in a report, when you customize, make
sure the Details tab chooses AllTypes, rather than Payments.
  #-1  
Old 05-24-2007, 03:00 AM
Maaz Mansori
Guest
 
Posts: n/a
Default Negative Expenses

I'm using Money 2007 Premium but have had this problem in the last several
versions as well. Why is it that if I record a negative expensive, it is not
reflected in the reports?

An example: Let's say I go out to dinner with a friend. We receive the check
and I pay by credit card and my friend pays me with cash to cover his/her
part. I record the restaurant in the Food: Dining Out category in my credit
card account and then record that I received the cash in my Cash account and
classify it as a negative expense to the same category. However, when I view
the reports, only the positive expense shows up and it never subtracts the
negative one from the total.

I suppose I could get around this problem by creating a liability account
for when such a transaction is needed, but it shouldn't have to be so
complicated. Any ideas?

Maaz

 

Tags
expenses, negative
Similar Threads
Thread Forum Replies Last Post
how to use a negative number
Dave: I have a client that gave me a deposit for a service. I was paid this deposi last year. I now have made a invoice for this service with Money Home...
Microsoft Money 5 04-22-2007 09:40 PM
Why does catagorizing "negative" expenses not work
BJT: I did catagorize the income as a "negative" expense. That's how I did it on Yahoo! but for some reason the amount in that catagory still is the...
Microsoft Money 5 02-24-2005 08:53 PM
Balances negative - help!!
Tommy Becker: I accepted a downloaded transaction today and Money 2004 crashed on me. When I restarted, I noticed that my checking account balance was negative...
Microsoft Money 12 01-30-2004 03:18 AM
negative balances
neal: no version of MONEY i have ever used has allowed me to show a negative balance in an investment account, e.g., a money market fund that has...
Microsoft Money 1 10-16-2003 02:41 AM



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 10:56 PM.