|
#2
| |||
| |||
| I would add to Cal's #1 process by mentioning that the order of events seems to be important. I've noticed that when I first download and import all of my transactions and then start stepping through and "Accept"ing them then Money sometimes doesn't do such a good job of matching. It appears that the match is done at the time of the import. I would recommend doing the #1 process in this order: 1. Download transactions from account A. 2. Process ("Accept") transactions from account A. 3. Download transactions from account B. 4. Process transactions from account B. "Cal Learner-- MVP" wrote: - quote - > In microsoft.public.money, Roger wrote: > > I have paired savings and checking accounts. Every day money is swept > > either from or too savings to keep a fixed balance. > > > When I pull in the transactions I get entries in both accounts but neither > > shows up as a Transfer. If I edit one of these in the Savings account, for > > example, to make it a transfer from Checking a second entry appears in > > Checking, which I then have to delete. > > > Is there any sensible way to handle this? If you miss one of these > > duplicated entries it screws up your accounts. > You can handle this like a credit card payment. > Here are three ways I like for credit cards, and one of them should > be adaptable for your situation: > 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). 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 . > 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 credit card 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. > It has particular appeal if each end is dated differently, and you > want to preserve both dates. If you miss changing one of the > transactions to a transfer, only the "In Transit" account will have > the wrong amount. |
|
#1
| |||
| |||
| In microsoft.public.money, Roger wrote: - quote - > I have paired savings and checking accounts. Every day money is swept
You can handle this like a credit card payment.> either from or too savings to keep a fixed balance. > When I pull in the transactions I get entries in both accounts but neither > shows up as a Transfer. If I edit one of these in the Savings account, for > example, to make it a transfer from Checking a second entry appears in > Checking, which I then have to delete. > Is there any sensible way to handle this? If you miss one of these > duplicated entries it screws up your accounts. Here are three ways I like for credit cards, and one of them should be adaptable for your situation: 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). 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 . 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 credit card 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. It has particular appeal if each end is dated differently, and you want to preserve both dates. If you miss changing one of the transactions to a transfer, only the "In Transit" account will have the wrong amount. |
| | |||
| |||
| As with all account-to-account transfers when both accounts are downloaded, Money is supposed to offer to match the second transaction downloaded with the first transaction that has already been entered based on things like date and amount. I can't say why it isn't in your case. "Roger" <x[at]y> wrote in message news:uI3%239i9iGHA.4504[at]TK2MSFTNGP03.phx.gbl... - quote - > I have paired savings and checking accounts. Every day money is swept > either from or too savings to keep a fixed balance. > When I pull in the transactions I get entries in both accounts but neither > shows up as a Transfer. If I edit one of these in the Savings account, for > example, to make it a transfer from Checking a second entry appears in > Checking, which I then have to delete. > Is there any sensible way to handle this? If you miss one of these > duplicated entries it screws up your accounts. |
|
#-1
| |||
| |||
| I have paired savings and checking accounts. Every day money is swept either from or too savings to keep a fixed balance. When I pull in the transactions I get entries in both accounts but neither shows up as a Transfer. If I edit one of these in the Savings account, for example, to make it a transfer from Checking a second entry appears in Checking, which I then have to delete. Is there any sensible way to handle this? If you miss one of these duplicated entries it screws up your accounts. Roger |
| Tags |
| automatic, sweeps, working |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Can't Get Automatic Updates Cultcab: I recently got a new PC with Money 2005, and I'm not able to set it up to automatically update when I open the program. I've read all the "help"... | Microsoft Money | 5 | 01-22-2006 01:54 AM | |
| Automatic updates Paul Keller: BlankRecently converted to 05 from 04. In 04 my accounts updated automatically each day when I first opened money. Now I have to click on the... | Microsoft Money | 7 | 12-02-2004 10:03 PM | |
| Automatic Deposits Dan: I have a recurring deposit set up in the bills and deposits for my weekly paycheck. I have it as an estimate though because it is different every... | Microsoft Money | 1 | 11-12-2003 01:51 PM | |
| Thread Tools | |
| Display Modes | |
| |