Report Question

#2 01-05-2006, 05:03 PM

In microsoft.public.money, Kyle wrote:

- quote -

> I did what you mentioned and I guess it's not exactly how I want to see
> things. All I really want it to do is off-set the expense, so it doesn't
> show up.
> What would be a better way of handling the transaction? I know I could set
> up a suspense account - Would that be the best way?

Best is in the eye of the beholder. I think you should experiment to
find the way you are least dissatisfied with.

- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, Kyle wrote:
> > > > I'm going to explain a situation as an example will be easier to understand.
> > > > > I purchase a concert ticket for $50. I have a rewards program on the credit
> > > card allowing me to use points for the ticket. First, the charge is issued
> > > to the card and then, a few days later, I will be credited for the $50 when
> > > my points have been validated. So, essentially, this concert ticket costs me
> > > $0. When the transaction comes through on my credit card, I categorize it as
> > > 'Hobbies and Leisure: Concerts' as an expense. When the credit is issued, I
> > > also categorize it as the same thing (an expense), essentially offsetting the
> > > expense, making the net transaction $0.
> > > > > When I run a report, the offsetting values do not show up. So, according to
> > > MS Money, the concert cost me $50, which is incorrect. I also have the same
> > > problem when I enter rebates if I categorize the rebate to the same expense
> > > account as the purchase.
> > > > > Is there a way to modify the reports so they would be accurate?
> > > To show negative expenses in a report such as "Transactions by
> > category", when you customize, make sure the Details tab chooses
> > AllTypes, rather than Payments.
>

#1 01-05-2006, 04:30 PM

I did what you mentioned and I guess it's not exactly how I want to see
things. All I really want it to do is off-set the expense, so it doesn't
show up.

What would be a better way of handling the transaction? I know I could set
up a suspense account - Would that be the best way?

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Kyle wrote:
> > I'm going to explain a situation as an example will be easier to understand.
> > > I purchase a concert ticket for $50. I have a rewards program on the credit
> > card allowing me to use points for the ticket. First, the charge is issued
> > to the card and then, a few days later, I will be credited for the $50 when
> > my points have been validated. So, essentially, this concert ticket costs me
> > $0. When the transaction comes through on my credit card, I categorize it as
> > 'Hobbies and Leisure: Concerts' as an expense. When the credit is issued, I
> > also categorize it as the same thing (an expense), essentially offsetting the
> > expense, making the net transaction $0.
> > > When I run a report, the offsetting values do not show up. So, according to
> > MS Money, the concert cost me $50, which is incorrect. I also have the same
> > problem when I enter rebates if I categorize the rebate to the same expense
> > account as the purchase.
> > > Is there a way to modify the reports so they would be accurate?
> To show negative expenses in a report such as "Transactions by
> category", when you customize, make sure the Details tab chooses
> AllTypes, rather than Payments.

01-03-2006, 08:21 PM

In microsoft.public.money, Kyle wrote:

- quote -

> I'm going to explain a situation as an example will be easier to understand.
> I purchase a concert ticket for $50. I have a rewards program on the credit
> card allowing me to use points for the ticket. First, the charge is issued
> to the card and then, a few days later, I will be credited for the $50 when
> my points have been validated. So, essentially, this concert ticket costs me
> $0. When the transaction comes through on my credit card, I categorize it as
> 'Hobbies and Leisure: Concerts' as an expense. When the credit is issued, I
> also categorize it as the same thing (an expense), essentially offsetting the
> expense, making the net transaction $0.
> When I run a report, the offsetting values do not show up. So, according to
> MS Money, the concert cost me $50, which is incorrect. I also have the same
> problem when I enter rebates if I categorize the rebate to the same expense
> account as the purchase.
> Is there a way to modify the reports so they would be accurate?

To show negative expenses in a report such as "Transactions by
category", when you customize, make sure the Details tab chooses
AllTypes, rather than Payments.

#-1 01-03-2006, 08:14 PM

I'm going to explain a situation as an example will be easier to understand.

I purchase a concert ticket for $50. I have a rewards program on the credit
card allowing me to use points for the ticket. First, the charge is issued
to the card and then, a few days later, I will be credited for the $50 when
my points have been validated. So, essentially, this concert ticket costs me
$0. When the transaction comes through on my credit card, I categorize it as
'Hobbies and Leisure: Concerts' as an expense. When the credit is issued, I
also categorize it as the same thing (an expense), essentially offsetting the
expense, making the net transaction $0.

When I run a report, the offsetting values do not show up. So, according to
MS Money, the concert cost me $50, which is incorrect. I also have the same
problem when I enter rebates if I categorize the rebate to the same expense
account as the purchase.

Is there a way to modify the reports so they would be accurate?

Similar Threads
Thread	Forum	Replies	Last Post
Another question skid0g@juno.com: I used Money to go to this page: http://www.microsoft.com/money/special/MoneySpecialPages_Launch2006.mspx Here is what this page states: ...	Microsoft Money	2	11-16-2005 05:36 AM
Question on a bad URL Christoher: In Money 2004, I have an account setup with Capitol One. When I'm looking at that account and select "Go to Capitol One" -> "Go to Capitol One...	Microsoft Money	1	02-05-2004 02:38 AM
Report Question Please Bob Newman: How do I print a copy of the check register in date order just as it appears in the checkbook? I do not want the deposits to be seperated from the...	Microsoft Money	3	09-15-2003 01:18 PM
Report Help/Question Kill: Is there a way to get a special transaction to show up in a report I generate monthly that shows what I spend on bills each month...this is a...	Microsoft Money	2	07-28-2003 09:50 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode