| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
| |||
| |||
| I was doing some data clean-up (from 2005) and noticed I had incorrectly categorized a few transactions, so I went back and corrected them this morning. All these transactions involved a credit card payment that I errornously had entered as a "household" expense, rather than calling it a "transfer: [account]". I went back and changed the transaction in my checking account so it represented a "transfer: [creditcard]". When I did this, like Money should, it created the corresponding entry in my creditcard account. My problem is that I now have duplicated entries. I would like to match these two transactions, but they have both been "accepted", so I do not have the "match" option in the register. Is there some way that I can match the transactions after they have been accepted? I guess I *could* delete the credit card transaction and re-download it, but I would like to not go through that process. Thanks! Kyle |
|
#2
| |||
| |||
| In microsoft.public.money, Kyle wrote: >I was doing some data clean-up (from 2005) and noticed I had incorrectly >categorized a few transactions, so I went back and corrected them this >morning. All these transactions involved a credit card payment that I >errornously had entered as a "household" expense, rather than calling it a >"transfer: [account]". > >I went back and changed the transaction in my checking account so it >represented a "transfer: [creditcard]". When I did this, like Money should, >it created the corresponding entry in my creditcard account. My problem is >that I now have duplicated entries. > >I would like to match these two transactions, but they have both been >"accepted", so I do not have the "match" option in the register. Is there >some way that I can match the transactions after they have been accepted? I >guess I *could* delete the credit card transaction and re-download it, but I >would like to not go through that process. I would Void the duplicates. It would seem that you did not modify the existing transactions, but that you somehow entered new ones. For future use, you might take a look at Find and Replace to aid changing several transactions. |
|
#3
| |||
| |||
| I know what you're saying, but either way I chose to modify my current transaction, one account would have been incorrectly stated. For instance: Checking account has a transaction of $50 that was accepted, but has no category assigned. Credit Card account contains the matching transaction of $50 that was accepted, but categorized as expense "Household". Now, let's say the transaction *should* have been entered as: - Checking account "Transfer : Credit Card" - Credit card account "Transfer : Checking" If I change the checking account transaction (from no category to "transfer: credit card"), it will add the corresponding transaction to the credid card account, creating a duplicate entry. If I change the credit card account (from "household" to "transfer: checking"), it will add the corresponding transaction to the checking account. So, how would using find/modify help me in this situation? I'm modifying the transactions that were in there in the first place, I just want to link them together. Why does Money allow you to match the transactions when you first enter them, but not let you go back and do so? I don't see any problem with doing so...? Kyle "Cal Learner-- MVP" wrote: > In microsoft.public.money, Kyle wrote: > > >I was doing some data clean-up (from 2005) and noticed I had incorrectly > >categorized a few transactions, so I went back and corrected them this > >morning. All these transactions involved a credit card payment that I > >errornously had entered as a "household" expense, rather than calling it a > >"transfer: [account]". > > > >I went back and changed the transaction in my checking account so it > >represented a "transfer: [creditcard]". When I did this, like Money should, > >it created the corresponding entry in my creditcard account. My problem is > >that I now have duplicated entries. > > > >I would like to match these two transactions, but they have both been > >"accepted", so I do not have the "match" option in the register. Is there > >some way that I can match the transactions after they have been accepted? I > >guess I *could* delete the credit card transaction and re-download it, but I > >would like to not go through that process. > > I would Void the duplicates. > > It would seem that you did not modify the existing transactions, but > that you somehow entered new ones. > > For future use, you might take a look at Find and Replace to aid > changing several transactions. > > |
|
#4
| |||
| |||
| In microsoft.public.money, Kyle wrote: >I know what you're saying, but either way I chose to modify my current >transaction, one account would have been incorrectly stated. > >For instance: >Checking account has a transaction of $50 that was accepted, but has no >category assigned. > >Credit Card account contains the matching transaction of $50 that was >accepted, but categorized as expense "Household". > >Now, let's say the transaction *should* have been entered as: >- Checking account "Transfer : Credit Card" >- Credit card account "Transfer : Checking" > >If I change the checking account transaction (from no category to "transfer: >credit card"), it will add the corresponding transaction to the credid card >account, creating a duplicate entry. If I change the credit card account >(from "household" to "transfer: checking"), it will add the corresponding >transaction to the checking account. Ahh. I was thinking you wanted to change it from Household to Insurance or some such. 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 "EXPENSE Credit Card Payment". I would Delete that category. > >So, how would using find/modify help me in this situation? I'm modifying >the transactions that were in there in the first place, I just want to link >them together. Why does Money allow you to match the transactions when you >first enter them, but not let you go back and do so? I don't see any problem >with doing so...? I will engage in philosophical discussions at times, but this one inspires me less than some others. Such as why can't I schedule an estimated $0 transfer to match against. The $0 would cause less confusion if I somehow fail to match it than would an estimated $400. > >Kyle > >"Cal Learner-- MVP" wrote: > >> In microsoft.public.money, Kyle wrote: >> >> >I was doing some data clean-up (from 2005) and noticed I had incorrectly >> >categorized a few transactions, so I went back and corrected them this >> >morning. All these transactions involved a credit card payment that I >> >errornously had entered as a "household" expense, rather than calling it a >> >"transfer: [account]". >> > >> >I went back and changed the transaction in my checking account so it >> >represented a "transfer: [creditcard]". When I did this, like Money should, >> >it created the corresponding entry in my creditcard account. My problem is >> >that I now have duplicated entries. >> > >> >I would like to match these two transactions, but they have both been >> >"accepted", so I do not have the "match" option in the register. Is there >> >some way that I can match the transactions after they have been accepted? I >> >guess I *could* delete the credit card transaction and re-download it, but I >> >would like to not go through that process. >> >> I would Void the duplicates. >> >> It would seem that you did not modify the existing transactions, but >> that you somehow entered new ones. >> >> For future use, you might take a look at Find and Replace to aid >> changing several transactions. >> >> |
|
#5
| |||
| |||
| That's precisely what I'm trying to do...the problem is that I do not have the option to match the transaction anymore as both sides of the initial transaction were reconciled. There is no longer the change option. That's what I'm looking for...is there any way to get that option back after you have accepted the transaction. Basically, I want Money to think like I just entered the transaction so I can go match it to the duplicate entry. "Cal Learner-- MVP" wrote: > In microsoft.public.money, Kyle wrote: > > >I know what you're saying, but either way I chose to modify my current > >transaction, one account would have been incorrectly stated. > > > >For instance: > >Checking account has a transaction of $50 that was accepted, but has no > >category assigned. > > > >Credit Card account contains the matching transaction of $50 that was > >accepted, but categorized as expense "Household". > > > >Now, let's say the transaction *should* have been entered as: > >- Checking account "Transfer : Credit Card" > >- Credit card account "Transfer : Checking" > > > >If I change the checking account transaction (from no category to "transfer: > >credit card"), it will add the corresponding transaction to the credid card > >account, creating a duplicate entry. If I change the credit card account > >(from "household" to "transfer: checking"), it will add the corresponding > >transaction to the checking account. > > Ahh. I was thinking you wanted to change it from Household to > Insurance or some such. > > 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 "EXPENSE Credit Card > Payment". I would Delete that category. > > > > > >So, how would using find/modify help me in this situation? I'm modifying > >the transactions that were in there in the first place, I just want to link > >them together. Why does Money allow you to match the transactions when you > >first enter them, but not let you go back and do so? I don't see any problem > >with doing so...? > > I will engage in philosophical discussions at times, but this one > inspires me less than some others. Such as why can't I schedule an > estimated $0 transfer to match against. The $0 would cause less > confusion if I somehow fail to match it than would an estimated > $400. > > > > > >Kyle > > > >"Cal Learner-- MVP" wrote: > > > >> In microsoft.public.money, Kyle wrote: > >> > >> >I was doing some data clean-up (from 2005) and noticed I had incorrectly > >> >categorized a few transactions, so I went back and corrected them this > >> >morning. All these transactions involved a credit card payment that I > >> >errornously had entered as a "household" expense, rather than calling it a > >> >"transfer: [account]". > >> > > >> >I went back and changed the transaction in my checking account so it > >> >represented a "transfer: [creditcard]". When I did this, like Money should, > >> >it created the corresponding entry in my creditcard account. My problem is > >> >that I now have duplicated entries. > >> > > >> >I would like to match these two transactions, but they have both been > >> >"accepted", so I do not have the "match" option in the register. Is there > >> >some way that I can match the transactions after they have been accepted? I > >> >guess I *could* delete the credit card transaction and re-download it, but I > >> >would like to not go through that process. > >> > >> I would Void the duplicates. > >> > >> It would seem that you did not modify the existing transactions, but > >> that you somehow entered new ones. > >> > >> For future use, you might take a look at Find and Replace to aid > >> changing several transactions. > >> > >> > |
|
#6
| |||
| |||
| In microsoft.public.money, Kyle wrote: >That's precisely what I'm trying to do...the problem is that I do not have >the option to match the transaction anymore as both sides of the initial >transaction were reconciled. > >There is no longer the change option. That's what I'm looking for...is >there any way to get that option back after you have accepted the >transaction. Basically, I want Money to think like I just entered the >transaction so I can go match it to the duplicate entry. A yes answer could be File->Restore. At times you will find Money does not work the way you might want it to work. What you are left with is using what Money offers to more closely approximate what you want to do. You can change the transaction to a Transfer whenever you want. When that happens, Money does not go thru the transactions in the other account to see if it could match something that has been accepted in the account. Your best available course of action is to make the transaction a Transfer in one account *before* you accept the corresponding transaction. Your fallback action is to Void or Delete the duplicate. Were just reiterating your point? > >"Cal Learner-- MVP" wrote: > >> In microsoft.public.money, Kyle wrote: >> >> >I know what you're saying, but either way I chose to modify my current >> >transaction, one account would have been incorrectly stated. >> > >> >For instance: >> >Checking account has a transaction of $50 that was accepted, but has no >> >category assigned. >> > >> >Credit Card account contains the matching transaction of $50 that was >> >accepted, but categorized as expense "Household". >> > >> >Now, let's say the transaction *should* have been entered as: >> >- Checking account "Transfer : Credit Card" >> >- Credit card account "Transfer : Checking" >> > >> >If I change the checking account transaction (from no category to "transfer: >> >credit card"), it will add the corresponding transaction to the credid card >> >account, creating a duplicate entry. If I change the credit card account >> >(from "household" to "transfer: checking"), it will add the corresponding >> >transaction to the checking account. >> >> Ahh. I was thinking you wanted to change it from Household to >> Insurance or some such. >> >> 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 "EXPENSE Credit Card >> Payment". I would Delete that category. >> >> >> > >> >So, how would using find/modify help me in this situation? I'm modifying >> >the transactions that were in there in the first place, I just want to link >> >them together. Why does Money allow you to match the transactions when you >> >first enter them, but not let you go back and do so? I don't see any problem >> >with doing so...? >> >> I will engage in philosophical discussions at times, but this one >> inspires me less than some others. Such as why can't I schedule an >> estimated $0 transfer to match against. The $0 would cause less >> confusion if I somehow fail to match it than would an estimated >> $400. >> >> >> > >> >Kyle >> > >> >"Cal Learner-- MVP" wrote: >> > >> >> In microsoft.public.money, Kyle wrote: >> >> >> >> >I was doing some data clean-up (from 2005) and noticed I had incorrectly >> >> >categorized a few transactions, so I went back and corrected them this >> >> >morning. All these transactions involved a credit card payment that I >> >> >errornously had entered as a "household" expense, rather than calling it a >> >> >"transfer: [account]". >> >> > >> >> >I went back and changed the transaction in my checking account so it >> >> >represented a "transfer: [creditcard]". When I did this, like Money should, >> >> >it created the corresponding entry in my creditcard account. My problem is >> >> >that I now have duplicated entries. >> >> > >> >> >I would like to match these two transactions, but they have both been >> >> >"accepted", so I do not have the "match" option in the register. Is there >> >> >some way that I can match the transactions after they have been accepted? I >> >> >guess I *could* delete the credit card transaction and re-download it, but I >> >> >would like to not go through that process. >> >> >> >> I would Void the duplicates. >> >> >> >> It would seem that you did not modify the existing transactions, but >> >> that you somehow entered new ones. >> >> >> >> For future use, you might take a look at Find and Replace to aid >> >> changing several transactions. >> >> >> >> >> |
|
#7
| |||
| |||
| No, I'm not reiterating my point... I understand *now* that I should be entering transactions with transfers as I've been doing so for about 2 years now. The problem is that prior to me understanding exactly how that worked, I was categorizing transactions differently. So, yes, I know I should match transactions before I accept them, but that's not what I was doing. As I said originally, the transactions I "fixed" are from 2005, so I'm not going to do a file restore back to 2005 so I can have 12 transactions correctly inserted. I don't really expect that Money should try to match a 2005 transaction that's been accepted to something I change in 2007, but is there a way to "unaccept" a transaction? Seems silly that the only way for me to correct this now is basically to delete the transaction and re-download the transaction detail. I'm not going to void the transaction because it's correct, just has a wrong category. "Cal Learner-- MVP" wrote: > In microsoft.public.money, Kyle wrote: > > >That's precisely what I'm trying to do...the problem is that I do not have > >the option to match the transaction anymore as both sides of the initial > >transaction were reconciled. > > > >There is no longer the change option. That's what I'm looking for...is > >there any way to get that option back after you have accepted the > >transaction. Basically, I want Money to think like I just entered the > >transaction so I can go match it to the duplicate entry. > > A yes answer could be File->Restore. > > At times you will find Money does not work the way you might want it > to work. What you are left with is using what Money offers to more > closely approximate what you want to do. > > You can change the transaction to a Transfer whenever you want. When > that happens, Money does not go thru the transactions in the other > account to see if it could match something that has been accepted in > the account. > > Your best available course of action is to make the transaction a > Transfer in one account *before* you accept the corresponding > transaction. Your fallback action is to Void or Delete the > duplicate. > > Were just reiterating your point? > > > > > > > > > >"Cal Learner-- MVP" wrote: > > > >> In microsoft.public.money, Kyle wrote: > >> > >> >I know what you're saying, but either way I chose to modify my current > >> >transaction, one account would have been incorrectly stated. > >> > > >> >For instance: > >> >Checking account has a transaction of $50 that was accepted, but has no > >> >category assigned. > >> > > >> >Credit Card account contains the matching transaction of $50 that was > >> >accepted, but categorized as expense "Household". > >> > > >> >Now, let's say the transaction *should* have been entered as: > >> >- Checking account "Transfer : Credit Card" > >> >- Credit card account "Transfer : Checking" > >> > > >> >If I change the checking account transaction (from no category to "transfer: > >> >credit card"), it will add the corresponding transaction to the credid card > >> >account, creating a duplicate entry. If I change the credit card account > >> >(from "household" to "transfer: checking"), it will add the corresponding > >> >transaction to the checking account. > >> > >> Ahh. I was thinking you wanted to change it from Household to > >> Insurance or some such. > >> > >> 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 "EXPENSE Credit Card > >> Payment". I would Delete that category. > >> > >> > >> > > >> >So, how would using find/modify help me in this situation? I'm modifying > >> >the transactions that were in there in the first place, I just want to link > >> >them together. Why does Money allow you to match the transactions when you > >> >first enter them, but not let you go back and do so? I don't see any problem > >> >with doing so...? > >> > >> I will engage in philosophical discussions at times, but this one > >> inspires me less than some others. Such as why can't I schedule an > >> estimated $0 transfer to match against. The $0 would cause less > >> confusion if I somehow fail to match it than would an estimated > >> $400. > >> > >> > >> > > >> >Kyle > >> > > >> >"Cal Learner-- MVP" wrote: > >> > > >> >> In microsoft.public.money, Kyle wrote: > >> >> > >> >> >I was doing some data clean-up (from 2005) and noticed I had incorrectly > >> >> >categorized a few transactions, so I went back and corrected them this > >> >> >morning. All these transactions involved a credit card payment that I > >> >> >errornously had entered as a "household" expense, rather than calling it a > >> >> >"transfer: [account]". > >> >> > > >> >> >I went back and changed the transaction in my checking account so it > >> >> >represented a "transfer: [creditcard]". When I did this, like Money should, > >> >> >it created the corresponding entry in my creditcard account. My problem is > >> >> >that I now have duplicated entries. > >> >> > > >> >> >I would like to match these two transactions, but they have both been > >> >> >"accepted", so I do not have the "match" option in the register. Is there > >> >> >some way that I can match the transactions after they have been accepted? I > >> >> >guess I *could* delete the credit card transaction and re-download it, but I > >> >> >would like to not go through that process. > >> >> > >> >> I would Void the duplicates. > >> >> > >> >> It would seem that you did not modify the existing transactions, but > >> >> that you somehow entered new ones. > >> >> > >> >> For future use, you might take a look at Find and Replace to aid > >> >> changing several transactions. > >> >> > >> >> > >> > |
|
#8
| |||
| |||
| I have to ask why you need to download the transaction again? You can manually correct the mistake. Void one transaction as Cal suggested. "Kyle" <Kyle@discussions.microsoft.com> wrote in message news:5037B9AB-6C83-4567-B5A7-700F27E78BA8@microsoft.com... > No, I'm not reiterating my point... > > I understand *now* that I should be entering transactions with transfers > as > I've been doing so for about 2 years now. The problem is that prior to me > understanding exactly how that worked, I was categorizing transactions > differently. So, yes, I know I should match transactions before I accept > them, but that's not what I was doing. > > As I said originally, the transactions I "fixed" are from 2005, so I'm not > going to do a file restore back to 2005 so I can have 12 transactions > correctly inserted. I don't really expect that Money should try to match > a > 2005 transaction that's been accepted to something I change in 2007, but > is > there a way to "unaccept" a transaction? Seems silly that the only way > for > me to correct this now is basically to delete the transaction and > re-download > the transaction detail. I'm not going to void the transaction because > it's > correct, just has a wrong category. > > "Cal Learner-- MVP" wrote: > >> In microsoft.public.money, Kyle wrote: >> >> >That's precisely what I'm trying to do...the problem is that I do not >> >have >> >the option to match the transaction anymore as both sides of the initial >> >transaction were reconciled. >> > >> >There is no longer the change option. That's what I'm looking for...is >> >there any way to get that option back after you have accepted the >> >transaction. Basically, I want Money to think like I just entered the >> >transaction so I can go match it to the duplicate entry. >> >> A yes answer could be File->Restore. >> >> At times you will find Money does not work the way you might want it >> to work. What you are left with is using what Money offers to more >> closely approximate what you want to do. >> >> You can change the transaction to a Transfer whenever you want. When >> that happens, Money does not go thru the transactions in the other >> account to see if it could match something that has been accepted in >> the account. >> >> Your best available course of action is to make the transaction a >> Transfer in one account *before* you accept the corresponding >> transaction. Your fallback action is to Void or Delete the >> duplicate. >> >> Were just reiterating your point? >> >> >> >> >> >> >> > >> >"Cal Learner-- MVP" wrote: >> > >> >> In microsoft.public.money, Kyle wrote: >> >> >> >> >I know what you're saying, but either way I chose to modify my >> >> >current >> >> >transaction, one account would have been incorrectly stated. >> >> > >> >> >For instance: >> >> >Checking account has a transaction of $50 that was accepted, but has >> >> >no >> >> >category assigned. >> >> > >> >> >Credit Card account contains the matching transaction of $50 that was >> >> >accepted, but categorized as expense "Household". >> >> > >> >> >Now, let's say the transaction *should* have been entered as: >> >> >- Checking account "Transfer : Credit Card" >> >> >- Credit card account "Transfer : Checking" >> >> > >> >> >If I change the checking account transaction (from no category to >> >> >"transfer: >> >> >credit card"), it will add the corresponding transaction to the >> >> >credid card >> >> >account, creating a duplicate entry. If I change the credit card >> >> >account >> >> >(from "household" to "transfer: checking"), it will add the >> >> >corresponding >> >> >transaction to the checking account. >> >> >> >> Ahh. I was thinking you wanted to change it from Household to >> >> Insurance or some such. >> >> >> >> 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 "EXPENSE Credit Card >> >> Payment". I would Delete that category. >> >> >> >> >> >> > >> >> >So, how would using find/modify help me in this situation? I'm >> >> >modifying >> >> >the transactions that were in there in the first place, I just want >> >> >to link >> >> >them together. Why does Money allow you to match the transactions >> >> >when you >> >> >first enter them, but not let you go back and do so? I don't see any >> >> >problem >> >> >with doing so...? >> >> >> >> I will engage in philosophical discussions at times, but this one >> >> inspires me less than some others. Such as why can't I schedule an >> >> estimated $0 transfer to match against. The $0 would cause less >> >> confusion if I somehow fail to match it than would an estimated >> >> $400. >> >> >> >> >> >> > >> >> >Kyle >> >> > >> >> >"Cal Learner-- MVP" wrote: >> >> > >> >> >> In microsoft.public.money, Kyle wrote: >> >> >> >> >> >> >I was doing some data clean-up (from 2005) and noticed I had >> >> >> >incorrectly >> >> >> >categorized a few transactions, so I went back and corrected them >> >> >> >this >> >> >> >morning. All these transactions involved a credit card payment >> >> >> >that I >> >> >> >errornously had entered as a "household" expense, rather than >> >> >> >calling it a >> >> >> >"transfer: [account]". >> >> >> > >> >> >> >I went back and changed the transaction in my checking account so >> >> >> >it >> >> >> >represented a "transfer: [creditcard]". When I did this, like >> >> >> >Money should, >> >> >> >it created the corresponding entry in my creditcard account. My >> >> >> >problem is >> >> >> >that I now have duplicated entries. >> >> >> > >> >> >> >I would like to match these two transactions, but they have both >> >> >> >been >> >> >> >"accepted", so I do not have the "match" option in the register. >> >> >> >Is there >> >> >> >some way that I can match the transactions after they have been >> >> >> >accepted? I >> >> >> >guess I *could* delete the credit card transaction and re-download >> >> >> >it, but I >> >> >> >would like to not go through that process. >> >> >> >> >> >> I would Void the duplicates. >> >> >> >> >> >> It would seem that you did not modify the existing transactions, >> >> >> but >> >> >> that you somehow entered new ones. >> >> >> >> >> >> For future use, you might take a look at Find and Replace to aid >> >> >> changing several transactions. >> >> >> >> >> >> >> >> >> |
![]() |
| Thread Tools | |
| Display Modes | |
In an effort to better serve ads to our visitors, cookies are used on objectmix.com. For more information, check out our Privacy Policy.