Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #2  
Old 06-03-2006, 06:13 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Transaction match 2 different entries

In microsoft.public.money, Driver wrote:

- quote -

> Cal - You may have mis-understood me. I have done the transaction that you
> described in step 1 but my problem is when the credit card company receives
> the transaction and reports the payment as two separate transactions that
> total the payment.
> They report the principle as one transaction and the interest as another
> transaction - the two transactions equal the payment.
> I can match one of the two against the original payment, but when I try to
> match the second transaction against the payment, the payment is unavailable
> to match to.


Yes, I misunderstood.

It sounds like method 2 would be a good one for you. It is easier
too. In your variation, there would be one transaction in the
checking account and two in the credit card account as long as you
are paying interest.



- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, Driver wrote:
> > > > I pay a credit card from one account and the credit card reports the
> > > tranasaction as 2 separate transactions, one for interest and the other for
> > > principle. The sum of the 2 transactions equals the 1 payment transaction.
> > > How can I match the one payment transaction against the 2 credit
> > > transactions?
> > > > Here are three ways I like:
> > > 1. When you process the first transaction of the credit card

> > payment, set the category as a transfer to the other ( credit card
> > or bank account), or use the equivalent "SPECIAL Credit Card
> > Payment" category. When you process the second transaction,Money
> > should match it. Be careful to not just Accept if Money did not
> > find the match on its own for some reason. Click Change and match
> > it to the transfer you already made if Money did not match it for
> > you. I would consider this the classic of the ways I like.
> > > 2. In method 2, don't handle credit card payments as transfers or

> > the pre-defined "Credit Card Payment Instead create one category of
> > "CC payment" or some such. If you define the category as an
> > expense category, expect a warning when you use it to represent the
> > payment within the credit card account -- if you have the warning
> > enabled. Just click Yes in response to the warning. The category
> > should net at zero in reports across accounts, and you can still
> > customize to ignore the category if you like. [this is Bonnie
> > Synhorst's favorite method.]. This method is relatively simple with
> > the least impact if you neglect to change the category.
> > > 3. Create a suspense account.

> > I have one I call "In Transit", and I called it a "cash or other"
> > account. Change each of the downloaded transactions into transfer
> > to/from that account. That account will normally have a zero
> > balance except while funds are in transit. Make your credit card
> > payments as transfers to and from that account. This method will
> > appeal to the desire for best representing what is happening.

>
  #1  
Old 06-03-2006, 05:27 PM
Driver
Guest
 
Posts: n/a
Default Re: Transaction match 2 different entries

Cal - You may have mis-understood me. I have done the transaction that you
described in step 1 but my problem is when the credit card company receives
the transaction and reports the payment as two separate transactions that
total the payment.

They report the principle as one transaction and the interest as another
transaction - the two transactions equal the payment.

I can match one of the two against the original payment, but when I try to
match the second transaction against the payment, the payment is unavailable
to match to.

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Driver wrote:
> > I pay a credit card from one account and the credit card reports the
> > tranasaction as 2 separate transactions, one for interest and the other for
> > principle. The sum of the 2 transactions equals the 1 payment transaction.
> > How can I match the one payment transaction against the 2 credit
> > transactions?

> Here are three ways I like:
> 1. When you process the first transaction of the credit card
> payment, set the category as a transfer to the other ( credit card
> or bank account), or use the equivalent "SPECIAL Credit Card
> Payment" category. When you process the second transaction,Money
> should match it. Be careful to not just Accept if Money did not
> find the match on its own for some reason. Click Change and match
> it to the transfer you already made if Money did not match it for
> you. I would consider this the classic of the ways I like.
> 2. In method 2, don't handle credit card payments as transfers or
> the pre-defined "Credit Card Payment Instead create one category of
> "CC payment" or some such. If you define the category as an
> expense category, expect a warning when you use it to represent the
> payment within the credit card account -- if you have the warning
> enabled. Just click Yes in response to the warning. The category
> should net at zero in reports across accounts, and you can still
> customize to ignore the category if you like. [this is Bonnie
> Synhorst's favorite method.]. This method is relatively simple with
> the least impact if you neglect to change the category.
> 3. Create a suspense account.
> I have one I call "In Transit", and I called it a "cash or other"
> account. Change each of the downloaded transactions into transfer
> to/from that account. That account will normally have a zero
> balance except while funds are in transit. Make your credit card
> payments as transfers to and from that account. This method will
> appeal to the desire for best representing what is happening.

 
Old 05-30-2006, 11:48 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Transaction match 2 different entries

In microsoft.public.money, Driver wrote:

- quote -

> I pay a credit card from one account and the credit card reports the
> tranasaction as 2 separate transactions, one for interest and the other for
> principle. The sum of the 2 transactions equals the 1 payment transaction.
> How can I match the one payment transaction against the 2 credit
> transactions?



Here are three ways I like:

1. When you process the first transaction of the credit card
payment, set the category as a transfer to the other ( credit card
or bank account), or use the equivalent "SPECIAL Credit Card
Payment" category. When you process the second transaction,Money
should match it. Be careful to not just Accept if Money did not
find the match on its own for some reason. Click Change and match
it to the transfer you already made if Money did not match it for
you. I would consider this the classic of the ways I like.

2. In method 2, don't handle credit card payments as transfers or
the pre-defined "Credit Card Payment Instead create one category of
"CC payment" or some such. If you define the category as an
expense category, expect a warning when you use it to represent the
payment within the credit card account -- if you have the warning
enabled. Just click Yes in response to the warning. The category
should net at zero in reports across accounts, and you can still
customize to ignore the category if you like. [this is Bonnie
Synhorst's favorite method.]. This method is relatively simple with
the least impact if you neglect to change the category.

3. Create a suspense account.
I have one I call "In Transit", and I called it a "cash or other"
account. Change each of the downloaded transactions into transfer
to/from that account. That account will normally have a zero
balance except while funds are in transit. Make your credit card
payments as transfers to and from that account. This method will
appeal to the desire for best representing what is happening.
  #-1  
Old 05-30-2006, 11:01 PM
Driver
Guest
 
Posts: n/a
Default Transaction match 2 different entries

I pay a credit card from one account and the credit card reports the
tranasaction as 2 separate transactions, one for interest and the other for
principle. The sum of the 2 transactions equals the 1 payment transaction.
How can I match the one payment transaction against the 2 credit
transactions?
 

Tags
entries, match, transaction
Similar Threads
Thread Forum Replies Last Post
M2006 transaction match problem
JohnA: Hi, Every few weeks, my money file gets into a strange state where the only transactions that are presented to be matched are in the future...
Microsoft Money 2 12-27-2005 02:45 AM
Re: Manual Transaction Match
Michael Gordon, MVP: "Michael Gordon, MVP" <gordonm@denison.edu> wrote in message news:... > The change only appears before the transaction is accepted. Delete the >...
Microsoft Money 2 07-29-2005 09:06 PM
Manual Transaction Match
Paulo Resende: Hello, I'm using Money 2005 Deluxe Edition, and I transferred money from my checking account to a broker account, in another bank. Money did not...
Microsoft Money 1 07-28-2005 10:20 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 07:53 PM.