Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #7  
Old 04-19-2006, 11:40 AM
Jim Johnson
Guest
 
Posts: n/a
Default Re: Linking duplicate transactions in Money

On 18 Apr 2006 22:25:51 -0700, "Igor Okulist" <okigan[at]gmail.comwrote:

- quote -

> I may have found a way to make Money work the way I like.
> Just to recap: the problem to me is the way "Transfer:" works in ms
> money is that it affects transaction(s) in both source and destination
> account - which causes mismatches on the next download (in at least
> one of the accounts).
> Proposed work around:
> *Create a hypothetical account. I'll call it "Ether Account"
> which will hold funds being in transfer
> *Every time I instruct a bank to make an ACH from source account I will
> record it as a transfer _into_ "Ether Account"
> *Every time the money actually lands in the destination account, I will
> record it as transfer _from_ "Ether Account"
> Pros:
> *Maintains the record integrity between money register(s) and bank
> register
> *Budget should work correctly
> Cons:
> *Extra account
> Anybody sees any other negatives or caveats?
> Thanks,
> Igor


Maybe I'm not understanding your situation fully, but what I do is
just record the transfer in it's respective account BEFORE I download
the information from the bank. It matches in both the source and
destination account when I do download and everything is cool.

Jim
  #6  
Old 04-19-2006, 05:25 AM
Igor Okulist
Guest
 
Posts: n/a
Default Re: Linking duplicate transactions in Money

I may have found a way to make Money work the way I like.

Just to recap: the problem to me is the way "Transfer:" works in ms
money is that it affects transaction(s) in both source and destination
account - which causes mismatches on the next download (in at least
one of the accounts).

Proposed work around:
*Create a hypothetical account. I'll call it "Ether Account"
which will hold funds being in transfer
*Every time I instruct a bank to make an ACH from source account I will
record it as a transfer _into_ "Ether Account"
*Every time the money actually lands in the destination account, I will
record it as transfer _from_ "Ether Account"


Pros:
*Maintains the record integrity between money register(s) and bank
register
*Budget should work correctly
Cons:
*Extra account


Anybody sees any other negatives or caveats?

Thanks,
Igor

  #5  
Old 03-23-2006, 01:45 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: Linking duplicate transactions in Money

Losing the accounting integrity provided by the matched single transaction
to preserve one relatively meaningless date that will surely be reflected on
the paper statement seems a very odd choice to make. But suit yourself.

"Igor Okulist" <okigan[at]removethishotmail.com> wrote in message
news:87mUf.49470$F_3.33715[at]newssvr29.news.prodigy.net...
- quote -

> > Yes, you 'lose information'. Choose whether you want the checking account
> > transaction date, or the credit card transaction date. You cannot have
> > both, and still have a link that you can right-click on to go to the
> > other account.

> For this choice is clear for me -- not to use "money's match" function and
> keep
> the information.



  #4  
Old 03-23-2006, 12:10 AM
Chris Cowles
Guest
 
Posts: n/a
Default Re: Linking duplicate transactions in Money

"Igor Okulist" <okigan[at]removethishotmail.com> wrote in message
news:87mUf.49470$F_3.33715[at]newssvr29.news.prodigy.net...
- quote -

> But overall you are right -- the consequences of money's match are
> unacceptable.


Many years ago I used a personal finance program from Parsons Technology
called MoneyCounts. It did what you wanted - it allowed recording the
posting date separate from the recording date. But it still showed the same
transaction date in both sides of the transfer accounts. It did not sort by
the stored posting date.

The detail of that information could be useful, but I'm personally not
willing to spend more time anguishing over its absence. My credit card
payments are made before the due date. That, and the amount, are all I
really care about.

How does this differ from not being able to record the entry date vs. the
posting date of a check in your checking account? Like payments to a credit
card, you get to pick from one of two dates. Either one you pick is wrong,
from the other perspective.
--
Chris Cowles
Gainesville, FL



  #3  
Old 03-22-2006, 11:39 PM
Igor Okulist
Guest
 
Posts: n/a
Default Re: Linking duplicate transactions in Money

- quote -

> "Chris Cowles" <spam_magnet[at]remove-me-bellsouth.net> wrote in message
> news:ekxrw9gTGHA.1688[at]TK2MSFTNGP11.phx.gbl...
> Yes, this topic has been beaten to death, but you apparently are unwilling
> to accept the choices available to you, or their consequences.
> Your only choice within Money's design is to match them. That is how you
> mark a relationship between the two transactions. Not matching them
> creates duplicate expenses in the budget.

"Your only choice within Money's design is to match them." -- ok, now at
least
it is clear what's possible what's not.

- quote -

> Yes, you 'lose information'. Choose whether you want the checking account
> transaction date, or the credit card transaction date. You cannot have
> both, and still have a link that you can right-click on to go to the other
> account.

For this choice is clear for me -- not to use "money's match" function and
keep
the information.

- quote -

> Perhaps recording the posting date of one account in the memo field could
> partially satisfy your expectations?

I see an interesting option in account register: "Exclude from Budget", I
guess
that is the solution for duplicate entries in budget.

But overall you are right -- the consequences of money's match are
unacceptable.

Thanks,
Igor



  #2  
Old 03-22-2006, 11:19 PM
Chris Cowles
Guest
 
Posts: n/a
Default Re: Linking duplicate transactions in Money

"Igor Okulist" <okigan[at]removethishotmail.com> wrote in message
news:%23erXG4gTGHA.5908[at]TK2MSFTNGP14.phx.gbl...
- quote -

> This topic has been beaten to death -- though refuses to go away.
> Cal, although I can reproduce the steps you specify, that solution
> does not make sense to me.
> For clarity I'll try to repeat the scenario: I am paying for a credit
> card from a bank account (or transferring from bank account to
> another bank account)
> There are two transactions/actions taking place:
> 1) Deduction of funds from bank account
> 2) Credit/Deposit of funds into credit card account/another bank account
> *Matching* them looks like a mistake seems it erases information. For
> example it looses the date of the transaction (of either deduction or
> deposit).
> So while I would like to have them automatically correlated to each other
> they are not identical. So that brings to a new question:
> How to mark a relationship between two transactions?
> So that I could right click on one and find the related one in the other
> account.


Yes, this topic has been beaten to death, but you apparently are unwilling
to accept the choices available to you, or their consequences.

Your only choice within Money's design is to match them. That is how you
mark a relationship between the two transactions. Not matching them creates
duplicate expenses in the budget.

Yes, you 'lose information'. Choose whether you want the checking account
transaction date, or the credit card transaction date. You cannot have both,
and still have a link that you can right-click on to go to the other
account.

Perhaps recording the posting date of one account in the memo field could
partially satisfy your expectations?
--
Chris Cowles
Gainesville, FL



  #1  
Old 03-22-2006, 11:09 PM
Igor Okulist
Guest
 
Posts: n/a
Default Re: Linking duplicate transactions in Money

This topic has been beaten to death -- though refuses to go away.

Cal, although I can reproduce the steps you specify, that solution
does not make sense to me.

For clarity I'll try to repeat the scenario: I am paying for a credit
card from a bank account (or transferring from bank account to
another bank account)

There are two transactions/actions taking place:
1) Deduction of funds from bank account
2) Credit/Deposit of funds into credit card account/another bank account

*Matching* them looks like a mistake seems it erases information. For
example it looses the date of the transaction (of either deduction or
deposit).

So while I would like to have them automatically correlated to each other
they are not identical. So that brings to a new question:

How to mark a relationship between two transactions?
So that I could right click on one and find the related one in the other
account.

Thanks,
Igor



--

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

> In microsoft.public.money, Siddhesh Karmali wrote:
> > > I notice that Money automatically downloads the same transaction twice

> > from
> > two different accounts. For example, if I'm paying my credit card bill via
> > the checking account, it will appear twice under two different accounts.
> > > How do I link the two transactions?

> 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. Note
> that for this you would *not* use the Money 2005 "EXPENSE Credit
> Card Payment". Instead you should consider deleting that "EXPENSE
> Credit Card Payment" to avoid confusion.
> To fix the ones you already processed, void/delete one transaction,
> and change the other to a transfer.



 
Old 03-22-2006, 07:30 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Linking duplicate transactions in Money

In microsoft.public.money, Siddhesh Karmali wrote:

- quote -

> I notice that Money automatically downloads the same transaction twice from
> two different accounts. For example, if I'm paying my credit card bill via
> the checking account, it will appear twice under two different accounts.
> How do I link the two transactions?


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. Note
that for this you would *not* use the Money 2005 "EXPENSE Credit
Card Payment". Instead you should consider deleting that "EXPENSE
Credit Card Payment" to avoid confusion.

To fix the ones you already processed, void/delete one transaction,
and change the other to a transfer.
  #-1  
Old 03-22-2006, 05:41 PM
Siddhesh Karmali
Guest
 
Posts: n/a
Default Linking duplicate transactions in Money

One more question...

I notice that Money automatically downloads the same transaction twice from
two different accounts. For example, if I'm paying my credit card bill via
the checking account, it will appear twice under two different accounts.

How do I link the two transactions?

thanks!
 

Tags
duplicate, linking, money, transactions
Similar Threads
Thread Forum Replies Last Post
Duplicate Transactions on Money 2006
Vegasdonj: My accounts registers are being corrupted with dup. transactions. I do NOT download account data from my banks, but I do update stock transactions....
Microsoft Money 7 04-13-2007 10:18 PM
Money 2005 Duplicate Downloaded Transactions
Shawn: I finally got my Bank of America account transactions to download through online services. My only gripe is that old transactions which have...
Microsoft Money 9 01-15-2005 03:42 AM
Money 2005 duplicate transactions
Heath: When I download statements directly from Bank of America, the downloaded transactions match up nicely with my manually entered transactions and I...
Microsoft Money 9 12-08-2004 05:38 PM
Duplicate Downloaded Transactions - Money 2005
Robert Ward: I have money 2005 Deluxe and have run into a huge problem. When money downloads transaction that are duplicate and are in my bill & deposits it...
Microsoft Money 2 12-04-2004 12:05 AM
Money 2004: Duplicate downloaded transactions
Andrew: When I update my transaction list from my bank to Money, the same transactions get listed twice on my transaction list in Money. Is there a way to...
Microsoft Money 3 12-03-2004 05:14 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 06:00 PM.