|
#7
| |||
| |||
| 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.
Maybe I'm not understanding your situation fully, but what I do is> 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 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
| |||
| |||
| 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
| |||
| |||
| 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
| |||
| |||
| "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
Many years ago I used a personal finance program from Parsons Technology> unacceptable. 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
| |||
| |||
| - quote - > "Chris Cowles" <spam_magnet[at]remove-me-bellsouth.net> wrote in message
least> 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 it is clear what's possible what's not. - quote - > Yes, you 'lose information'. Choose whether you want the checking account
keep> 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 the information. - quote - > Perhaps recording the posting date of one account in the memo field could
guess> partially satisfy your expectations? I see an interesting option in account register: "Exclude from Budget", I 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
| |||
| |||
| "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.
Yes, this topic has been beaten to death, but you apparently are unwilling> 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. 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
| |||
| |||
| 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. |
| | |||
| |||
| In microsoft.public.money, Siddhesh Karmali wrote: - quote - > I notice that Money automatically downloads the same transaction twice from
When you process the first transaction of the credit card> 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? 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
| |||
| |||
| 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 | |
| |